Thanks, Rob. That helps some...but I'm not even sure what they mean whey they say, "You can write a .prc table..." I assume this is a "processing table". Is it a text file with the lines below written into it?
Line 1 --- Then: export word fil = \myfile Line 2 --- Then: fil(1) = 2; fil(2) = 3; fil(3) = 6 I guess this stuff is executed from a command prompt? Thanks for your guidance... Rick >From the referenced webpage: A. You can write a .prc table and use the 'export' function to output filePro data in various formats including Word, WordPerfect, DIF and Muliplan. Example: Line 1 --- Then: export word fil = \myfile Line 2 --- Then: fil(1) = 2; fil(2) = 3; fil(3) = 6 Line 1 opens a file named myfile.wp in the root directory of the current Line 2 exports the content of field 2 as the 1st element in the output, then field 3 and 6 as the 2nd and 3rd elements. The data exported in the example will be standard CSV format so each field will be delimited with quotes and a comma. "data_in_field_2","data_in_field_3","data_in_field_6" Note: You also need to create a "process only" format with the same name as the processing table name you assigned. Use the "define output" option to create the "process only" format. -----Original Message----- From: Rob Rohan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 8:13 PM To: CF-Talk Subject: RE: Anyone know how to get FilePro 4.5 to output data to CSV file? here is something that looks like it might help http://www.fptech.net/jsp/filepro/faq/datainterchange.htm this might help loading http://www.mysql.com/doc/en/LOAD_DATA.html Good luck, Rob http://treebeard.sourceforge.net http://ruinworld.sourceforge.net -----Original Message----- From: Rick Faircloth [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 08, 2003 5:03 PM To: CF-Talk Subject: OT: Anyone know how to get FilePro 4.5 to output data to CSV file? Hi, all. I'm converting an old FilePro database-driven system to a MySQL/Cold Fusion web-application for a client and need to figure out how to get the data from the old database into a CSV file, so I can import it into MySQL. I've checked the manual and the FilePro website, but they're not helpful. I'm having a hard time figuring out this DOS-based software. First, is it possible? Secondly, anyone have an explanation of how, or know of a resource that could provide some pointers? Thanks, Rick ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/cf_lists/index.cfm?method=subscribe&forumid=4 FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Signup for the Fusion Authority news alert and keep up with the latest news in ColdFusion and related topics. http://www.fusionauthority.com/signup.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
