<div dir="ltr"><div>I always use a full path in the filename as well ever since filePro helpfully put the resulting file in the fpmerge directory. If I want a filename without an extention, I just end the filename with a ".".<br><br></div>Laura Brody<br></div><div class="gmail_extra"><br><div class="gmail_quote">On Tue, Aug 15, 2017 at 1:30 PM, Brian K. White via Filepro-list <span dir="ltr"><<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><span class="">On 8/15/2017 12:17 PM, Chris Rendall via Filepro-list wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
James,<br>
<br>
I think filePro automatically adds in the .wp if you don't specify a file extension.<br>
</blockquote>
<br></span>
Put PFADDWP=off in your fp config file.<br>
(? - filepro directory -> F6 - configuration editor)<br>
<br>
There is also something similar about the *beginning* of the value where if the value doesn't specify a full path for the filename, then import will look in and export will save to the fpmerge directory. I don't remember the exact behavior since I always specify a full path because, sanity. ;) It might be something like if the value contains any slashes at all or something.<span class="HOEnZb"><font color="#888888"><br>
<br>
-- <br>
bkw</font></span><div class="HOEnZb"><div class="h5"><br>
<br>
<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
Try setting the environment variable PFADDWP=OFF to prevent that.<br>
<br>
-- Chris<br>
<br>
From: James Flanagan [mailto:<a href="mailto:James@Flantec.com" target="_blank">James@Flantec.com</a>]<br>
Sent: Tuesday, August 15, 2017 11:10 AM<br>
To: Chris Rendall <<a href="mailto:crendall@teamind.com" target="_blank">crendall@teamind.com</a>><br>
Cc: filePro (<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.<wbr>com</a>) <<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.celestial.<wbr>com</a>><br>
Subject: Re: import command with filename containing a variable<br>
<br>
Chris<br>
<br>
40 is just a 6 digt .0 interger.<br>
<br>
in debug mode, fn returns /tmp/addv/901458, as i would expect, but i see an added “.wp” as a file extension, but that is not in the fn variable. I have no idea where that is coming from. thank you<br>
<br>
*** A System Error Has Occurred ***<br>
<br>
On File: /tmp/addv/901458.wp<br>
<br>
Output Processing<br>
Line Number: 56<br>
<br>
import ascii data=(fn) r=\n f=: o=" c="<br>
<br>
<br>
No such file or directory<br>
<br>
James Flanagan<br>
<a href="http://Flantec.com/" rel="noreferrer" target="_blank">http://Flantec.com/</a><br>
<br>
email: mailto:<a href="mailto:James@Flantec.com" target="_blank">James@Flantec.com</a><br>
mobile: <a href="tel:760-458-8498" value="+17604588498" target="_blank">760-458-8498</a><br>
home: <a href="tel:219-221-6219" value="+12192216219" target="_blank">219-221-6219</a><br>
text: mailto:<a href="mailto:7604588498@txt.att.net" target="_blank">7604588498@txt.att.net</a><br>
<br>
aim: Flantec<br>
oovoo: Flantec<br>
Skype: Flantec<br>
ichat: mailto:<a href="mailto:Flantec@mac.com" target="_blank">Flantec@mac.com</a><br>
<br>
home: 1901 Cidermill Road<br>
Michigan City, IN 46360<br>
<br>
On Aug 15, 2017, at 11:48 AM, Chris Rendall via Filepro-list <mailto:<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.cel<wbr>estial.com</a>> wrote:<br>
<br>
How is field 40 defined?<br>
<br>
How about this: fn="/tmp/addv/"{40{""<br>
<br>
I'm wondering if there are extra blanks in field 40 that are being included in the filename and causing the no such file or directory error.<br>
<br>
-- Chris<br>
<br>
<br>
From: James Flanagan [mailto:<a href="mailto:James@Flantec.com" target="_blank">James@Flantec.com</a>]<br>
Sent: Tuesday, August 15, 2017 10:43 AM<br>
To: Chris Rendall <mailto:<a href="mailto:crendall@teamind.com" target="_blank">crendall@teamind.com</a>><br>
Cc: filePro (mailto:<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.cel<wbr>estial.com</a>) <mailto:<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.cel<wbr>estial.com</a>><br>
Subject: Re: import command with filename containing a variable<br>
<br>
Chris,<br>
<br>
I tried that, and i get the same error regarding no such file or directory. Thank you.<br>
<br>
James Flanagan<br>
<a href="http://Flantec.com/" rel="noreferrer" target="_blank">http://Flantec.com/</a><br>
<br>
email: mailto:<a href="mailto:James@Flantec.com" target="_blank">James@Flantec.com</a><br>
mobile: <a href="tel:760-458-8498" value="+17604588498" target="_blank">760-458-8498</a><br>
home: <a href="tel:219-221-6219" value="+12192216219" target="_blank">219-221-6219</a><br>
text: mailto:<a href="mailto:7604588498@txt.att.net" target="_blank">7604588498@txt.att.net</a><br>
<br>
aim: Flantec<br>
oovoo: Flantec<br>
Skype: Flantec<br>
ichat: mailto:<a href="mailto:Flantec@mac.com" target="_blank">Flantec@mac.com</a><br>
<br>
home: 1901 Cidermill Road<br>
Michigan City, IN 46360<br>
<br>
On Aug 15, 2017, at 11:37 AM, Chris Rendall via Filepro-list <mailto:<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.cel<wbr>estial.com</a>> wrote:<br>
<br>
Try setting to a variable such as: fn="/tmp/addv/"{40<br>
<br>
Then for you import command use: import ascii data=(fn) r=\n f=^A o=" c="<br>
<br>
-- Chris<br>
<br>
-----Original Message-----<br>
From: James Flanagan via Filepro-list [mailto:<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.cel<wbr>estial.com</a>]<br>
Sent: Tuesday, August 15, 2017 10:31 AM<br>
To: Filepro_List <mailto:<a href="mailto:filepro-list@lists.celestial.com" target="_blank">filepro-list@lists.cel<wbr>estial.com</a>><br>
Subject: import command with filename containing a variable<br>
<br>
I am trying to build a routine import command where the file name of the import would contain a respective variable of the record in am standing in. Because quotes are not used when defining the filename, i realize that i cannot just throw a variable in there. however, when i use parenthesis and quotes to attempt to achieve what i intend, it comes back with “NO SUCH FILE OR DIRECTORY”. Using the EXISTS command, and identical syntax as below, it returns that the file does indeed exist.<br>
<br>
Is there a way to inject a variable successfully into the filename of the import command? thank you very much,<br>
<br>
::import ascii data=("/tmp/addv/"{40) r=\n f=^A o=" c=":<br>
<br>
<br>
James Flanagan<br>
<a href="http://Flantec.com" rel="noreferrer" target="_blank">http://Flantec.com</a> <<a href="http://flantec.com/" rel="noreferrer" target="_blank">http://flantec.com/</a>><br>
<br>
email: mailto:<a href="mailto:James@Flantec.com" target="_blank">James@Flantec.com</a> <mailto:<a href="mailto:James@Flantec.com" target="_blank">James@Flantec.com</a>><br>
mobile: <a href="tel:760-458-8498" value="+17604588498" target="_blank">760-458-8498</a><br>
home: <a href="tel:219-221-6219" value="+12192216219" target="_blank">219-221-6219</a><br>
text: mailto:<a href="mailto:7604588498@txt.att.net" target="_blank">7604588498@txt.att.net</a> <mailto:<a href="mailto:7604588498@txt.att.net" target="_blank">7604588498@txt.att.net</a><wbr>><br>
<br>
aim: Flantec<br>
oovoo: Flantec<br>
Skype: Flantec<br>
ichat: mailto:<a href="mailto:Flantec@mac.com" target="_blank">Flantec@mac.com</a> <mailto:<a href="mailto:Flantec@mac.com" target="_blank">Flantec@mac.com</a>><br>
<br>
home: 1901 Cidermill Road<br>
Michigan City, IN 46360<br>
<br>
-------------- next part --------------<br>
An HTML attachment was scrubbed...<br>
URL: <<a href="http://mailman.celestial.com/pipermail/filepro-list/attachments/20170815/1afb4f5f/attachment.html" rel="noreferrer" target="_blank">http://mailman.celestial.com/<wbr>pipermail/filepro-list/attachm<wbr>ents/20170815/1afb4f5f/attachm<wbr>ent.html</a>><br>
______________________________<wbr>_________________<br>
Filepro-list mailing list<br>
mailto:<a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.cele<wbr>stial.com</a><br>
Subscribe/Unsubscribe/Subscrip<wbr>tion Changes <a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/m<wbr>ailman/listinfo/filepro-list</a><br>
______________________________<wbr>_________________<br>
Filepro-list mailing list<br>
mailto:<a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.cele<wbr>stial.com</a><br>
Subscribe/Unsubscribe/Subscrip<wbr>tion Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/m<wbr>ailman/listinfo/filepro-list</a><br>
<br>
______________________________<wbr>_________________<br>
Filepro-list mailing list<br>
mailto:<a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.cele<wbr>stial.com</a><br>
Subscribe/Unsubscribe/Subscrip<wbr>tion Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/m<wbr>ailman/listinfo/filepro-list</a><br>
<br>
______________________________<wbr>_________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.c<wbr>om</a><br>
Subscribe/Unsubscribe/Subscrip<wbr>tion Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/m<wbr>ailman/listinfo/filepro-list</a><br>
<br>
</blockquote>
<br>
______________________________<wbr>_________________<br>
Filepro-list mailing list<br>
<a href="mailto:Filepro-list@lists.celestial.com" target="_blank">Filepro-list@lists.celestial.c<wbr>om</a><br>
Subscribe/Unsubscribe/Subscrip<wbr>tion Changes<br>
<a href="http://mailman.celestial.com/mailman/listinfo/filepro-list" rel="noreferrer" target="_blank">http://mailman.celestial.com/m<wbr>ailman/listinfo/filepro-list</a><br>
</div></div></blockquote></div><br></div>