import command with filename containing a variable

[Laura Brody]

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 ".".

Laura Brody

On Tue, Aug 15, 2017 at 1:30 PM, Brian K. White via Filepro-list <
filepro-list at lists.celestial.com> wrote:

> 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.cel
>> estial.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/attachm
>> ents/20170815/1afb4f5f/attachment.html>
>> _______________________________________________
>> Filepro-list mailing list
>> mailto:Filepro-list at lists.celestial.com
>> Subscribe/Unsubscribe/Subscription Changes http://mailman.celestial.com/m
>> ailman/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
>>
>>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20170815/93b181fd/attachment.html>