Creating and Exporting Reports

[ridgedale]

Does anyone known if there are any guidelines for running reports from the command line under FoxPro 2.6 Unix and for exporting the report out to a .csv file?

I'm trying to automate a task that will automatically upload data to a customer's website.

Thanks in advance for any assistance.

 

[DSummZZZ]

Export the report to a CSV file? Why not export the data itself to a CSV file programmatically?


-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[ridgedale]

Dave,

Thanks for your reply. OK, so I need to find out what fields are used to generate the required report. Then how do I go about doing what you have suggested? Please bear in mind that although I have done some database work I have never used FoxPro 2.6 (Unix) before.

Thanks again.

 

[TamarGranor]

Actually, you can just:

USE <the table>
COPY TO NewFile TYPE CSV

Tamar

 

[DSummZZZ]

To expound a bit on Tamar's post:

I need to find out what fields are used to generate the required report

Once you have determined what fields you need, you can use

USE <the table>
COPY TO NewFile [COLOR=blue]FIELDS [i]field1, field2, ...  [/i][/color]TYPE CSV

Instead of the entire file.



-Dave Summers-

Even more Fox stuff at:

http://www.davesummers.net/foxprolinks.htm

 

[ridgedale]

Thanks for your help, Tamar and Dave.

You'll have to excuse my ignorance here. I presume the commands work fine under the Unix 2.6 version and that the commands have to be run after FoxPro has been launched from the command line?

If my assumptions are correct, how do I launch FoxPro from the command line and I presume I need to close the program upon completion of the task as well, again, if so, how do I achieve this?

Many thanks again.

 

[pthalacker]

how do I launch FoxPro from the command line

I assume that you do it the same way you launch any application from the command line. I have never used Unix but in DOS you just typed the name of the EXe.

I presume I need to close the program upon completion of the task as well, again, if so, how do I achieve this?

Once Fox is launched you get a Dot '.' prompt that functions much like the C:\ prompt in DOS. To exit Fox you type 'Quit' at the dot prompt.

pamela

 

[ridgedale]

Thanks for your help, Pamela. I think a little RTFM is required! I'll get my reading cap on!

Thanks again