I am trying to export some data from FMP6. I want to export the
following:

JobNumber
Customer
Contact
Address
City
State
Zip
Project Manager

That information is all stored in one .fp5 file. For each job number,
I would like to export each po on the job with the following
information:

PO#
Date
Vendor
DatePromised

All that information is store in one .fp5 file. For each po#, I would
like to export the line items on the po with the following information:

PartNumber
Desc
Qty
Cost
Ext. Cost
Status

Also for each job, I would like to export each MiscExpense which is
located in the same fp5 file as the job number with the following
information:

Date
PartNum
Desc
Qty
Cost
ExtCost

I have a script that will export that data into a .tab file so excel
can import it. I need to format the data in excel into a standard
report that we use for costing on a job. My question is on the best
method to do the exporting. If I export it to all one file, the number
of columns is large (one for each field) and the rows are not a
"complete record" with all the information on it. Is it better to
export to one file and manipulate the data or should I export data from
each fp5 file to a seperate .tab file and then do what I need to do in
excel.

I see pros and cons to each way and would like to get some feedback as
to what others have done.

Thanks

I do a lot of this type thing (more that I really want to). You're right in
that there are 2 schools of thought. The one I choose most often is to
export all the data flat (1 row has all the fields in it) then write a macro
in Excel to do the rest. This is especially useful if you have a specific
format to twist the data into.

fwiw
Steve

"krollenhagen" <keith.rollenhagen (AT) gmail (DOT) com> wrote