Adding header to a delimited export
Matthew Williams
matthew.d.williams at gmail.com
Mon Jan 10 09:06:01 PST 2005
Hello all, it's been many months since I've posted but i'm back with a
small problem.
Currently I export UPS orders to a small delimited file, from there we
would simply do a batch import into the UPS software and life was
good.
Recently UPS updated their software and now it requires that our file
contain headers to identify the fields. It simply won't map field 1
to customerID etc etc, you need the header to say "CustomerID" and
then map it to their field.
Why any software developer would make a change like this is beyond me
and is just plain annoying but we can't just stop doing business with
them and I guess it's not that big of a change.
This is where one of you comes in! How do I append this header to my
file? Could it be done with a simple sub-routine so it acts before
any records are chosen and written to the file?
Below is the line I use to export:
Then: export word plant = /upss/ups.txt -r=\n -f=,
Then: plant(1)=1;plant(2)=2;plant(3)=3;plant(4)=4;plant(5)=5
Thanks a lot in advance! I'm sure this is a easy hack, just nothing I
could find in the documentation (unless I didn't look hard enough).
On a side note it's been months since i've been on the list and I
forget how it sends the mail, I would just like to setup a simple
filter with my GMail account so I don't clog up my Inbox, are all
messages sent from a single address or do they contain a subject with
a static "Filepro" line somewhere? I guess i'll find out soon enough
as the messages start coming in.
Thanks again and I look forward to keeping up with some good Filepro
conversation!
-Matt Williams
Hale Mfg.
More information about the Filepro-list
mailing list