automating an import
Walter Vaughan
wvaughan at steelerubber.com
Fri Oct 3 06:37:32 PDT 2008
scooter6 at gmail.com wrote:
> I have a monthly file we'll be getting from a client that will
> maintain the same naming convention each month.
> I have the output only processing written and it works just fine, etc.
> Currently, I go into Request Output - Quickstart, choose the filepro
> file I'm importing to, choose the output processing, I choose no index
> and then don't choose all records....then load set selection of
> 'recone' to run the import.
Not the answer you are looking for, just another method.
Over the years I've kinda thought that it was easier to maintain and
deal with doing imports in
an input table. Below is just about as bare as you can get.
How it works is you would hit "I" from sitting on a blank or deleted
record. When it finishes you already are in
IUA, and can move to the records you just imported and make sure
everything is copasetic.
Typically I'll put in a "guess the password line" so that it doesn't run
by accident, and put something in to keep someone from running it multiple times
by accident as well.
1 -------
If:
Then: end
2 ------- -
@keyI If:
Then:
3 -------
loop If:
Then: import word imp=/tmp/2009.csv
4 ------- -
If: not imp
Then: end
5 ------- -
If:
Then: 1= imp(1); 2=imp(2)
6 ------- -
If:
Then: lookup - r=free -e
7 ------- -
If:
Then: goto loop
More information about the Filepro-list
mailing list