import command with filename containing a variable

[Chris Rendall]

James,

I think filePro automatically adds in the .wp if you don't specify a file extension.  

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