import command with filename containing a variable

Tue Aug 15 10:30:27 PDT 2017

On 8/15/2017 12:17 PM, Chris Rendall via Filepro-list wrote:
> James,
>
> I think filePro automatically adds in the .wp if you don't specify a file extension.

Put PFADDWP=off in your fp config file.
(? - filepro directory -> F6 - configuration editor)

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.

-- 
bkw

> Try setting the environment variable PFADDWP=OFF to prevent that.
>
> -- Chris
>
> From: James Flanagan [mailto:James at Flantec.com]
> Sent: Tuesday, August 15, 2017 11:10 AM
> To: Chris Rendall <crendall at teamind.com>
> Cc: filePro (filepro-list at lists.celestial.com) <filepro-list at lists.celestial.com>
> Subject: Re: import command with filename containing a variable
>
> Chris
>
> 40 is just a 6 digt .0 interger.
>
> 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
>
> *** A System Error Has Occurred ***
>
> On File: /tmp/addv/901458.wp
>
> Output Processing
> Line Number: 56
>
> import ascii data=(fn) r=\n f=: o=" c="
>
>
> No such file or directory
>
> James Flanagan
> http://Flantec.com/
>
> email:	mailto:James at Flantec.com
> mobile:	760-458-8498
> home: 	219-221-6219
> text:		mailto:7604588498 at txt.att.net
>
> aim:		Flantec
> oovoo:	Flantec
> Skype:	Flantec
> ichat:	mailto:Flantec at mac.com
>
> home:	1901 Cidermill Road
> 		Michigan City, IN 46360
>
> On Aug 15, 2017, at 11:48 AM, Chris Rendall via Filepro-list <mailto:filepro-list at lists.celestial.com> wrote:
>
> How is field 40 defined?
>
> How about this: fn="/tmp/addv/"{40{""
>
> 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.
>
> -- Chris
>
>
> From: James Flanagan [mailto:James at Flantec.com]
> Sent: Tuesday, August 15, 2017 10:43 AM
> To: Chris Rendall <mailto:crendall at teamind.com>
> Cc: filePro (mailto:filepro-list at lists.celestial.com) <mailto:filepro-list at lists.celestial.com>
> Subject: Re: import command with filename containing a variable
>
> Chris,
>
> I tried that, and i get the same error regarding no such file or directory.  Thank you.
>
> James Flanagan
> http://Flantec.com/
>
> email:	mailto:James at Flantec.com
> mobile:	760-458-8498
> home: 	219-221-6219
> text:		mailto:7604588498 at txt.att.net
>
> aim:		Flantec
> oovoo:	Flantec
> Skype:	Flantec
> ichat:	mailto:Flantec at mac.com
>
> home:	1901 Cidermill Road
> 		Michigan City, IN 46360
>
> On Aug 15, 2017, at 11:37 AM, Chris Rendall via Filepro-list <mailto:filepro-list at lists.celestial.com> wrote:
>
> Try setting to a variable such as: fn="/tmp/addv/"{40
>
> Then for you import command use: import ascii data=(fn) r=\n f=^A o=" c="
>
> -- Chris
>
> -----Original Message-----
> From: James Flanagan via Filepro-list [mailto:filepro-list at lists.celestial.com]
> Sent: Tuesday, August 15, 2017 10:31 AM
> To: Filepro_List <mailto:filepro-list at lists.celestial.com>
> Subject: import command with filename containing a variable
>
> 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.
>
> Is there a way to inject a variable successfully into the filename of the import command?  thank you very much,
>
> ::import ascii data=("/tmp/addv/"{40) r=\n f=^A o=" c=":
>
>
> James Flanagan
> http://Flantec.com <http://flantec.com/>
>
> email:	mailto:James at Flantec.com <mailto:James at Flantec.com>
> mobile:	760-458-8498
> home: 	219-221-6219
> text:		mailto:7604588498 at txt.att.net <mailto:7604588498 at txt.att.net>
>
> aim:		Flantec
> oovoo:	Flantec
> Skype:	Flantec
> ichat:	mailto:Flantec at mac.com <mailto:Flantec at mac.com>
>
> home:	1901 Cidermill Road
> 		Michigan City, IN 46360
>
> -------------- next part --------------
> An HTML attachment was scrubbed...
> URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170815/1afb4f5f/attachment.html>
> _______________________________________________
> Filepro-list mailing list
> mailto:Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/mailman/listinfo/filepro-list
> _______________________________________________
> Filepro-list mailing list
> mailto:Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
> _______________________________________________
> Filepro-list mailing list
> mailto:Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>