import excel to filepro

[GCC Consulting]

From: filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com [mailto:filepro-list-bounces+gccconsulting=comcast.net at lists.celestial.com] On Behalf Of Dennis Diller
Sent: Sunday, March 22, 2009 12:50 PM
To: filepro-list at lists.celestial.com
Subject: import excel to filepro

I have a file in excel save in csv format I want to get it into filepro does anyone have the answer.
 
Thanks In advance
Denny
dendil at electricalusa.com

Dennis,

Use the filepro import command:

29  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       ◄ If:
       Then: import ascii data=(folder) R=^J F=, O=" C="

That's the simple explanation.

Folder is the long variable holding the full path and name to the csv file.

Remember that you may have to skip the row or rows holding an column headers.

Data is the name of alias name of the "array" which holds the imported data,

Data(1)=first field of the imported data.

Now comes the interesting part, what do you want to do with this data?

If it to be posted to a file, you can do a lookup free and then post each imported field to the corresponding filed in you fp file.

You could copy the data into an array and massage it before doing whatever with it.

I have one import routine that imports data from one csv file, does a lookup to two other filepro files and created a new csv file which is the used to transmit edi information.

So, you now have the basics.


Richard Kreiss
GCC Consulting
rkreiss at gccconsulting.net