Importing a file

[Jeff Harrison]

--- Scott Brown <lordblue at msn.com> wrote:

> Hi,
> 
> I need to do a import on a comma delimited file into
> filepro 4.8. The file 
> will be ftp'd every day and the name will be
> different each day. Example: 
> 20060523xact.csv one day and 20060224eact.csv the
> next day. I can't use a 
> static file name because of the small chance of data
> loss. Is there a way to 
> code filepro to import a file that has a different
> name every day without 
> having to manually change it?
> Below is a portion of what I had before I found out
> I can't use a static 
> file name.
> 
[snip]
> 
> Any help would be most appriciated!
> 
> Thanks,
> 
> Scott Brown
> 
> 

You can have a variable file name, and then use an
environment variable to pass the name to filepro, or
use a command line argument.  For example use
something like the following to call the processing:

$PFDIR/fp/dclerk filename -z processing -r myfile.csv
-s1

Make sure your import statement looks something like
the following:

import ascii fil = (@pm{"") r=whatever f=whatever

The key is to use the parenthesis.

Good Luck.

Jeff Harrison
jeffaharrison at yahoo.com

Author of JHExport and JHImport.  The easiest and
fastest ways to generate code for filePro exports and imports.

__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com