Emmitt, I am using V7 (updated this morning). This would be a resolution to my situation, except that for some reason, I cannot get a TEXT file to "work". When I output to a text file, it creates the file, but there are no contents. Size is 0. I have selected the controls under the Text File setup and they show as selected. (High lighted them under Available Controls and moved them under Selected Controls)
If I print to a RTF format, it works fine, but not to a TXT format. I have at this time met my requirements by doing your second recommendation of creating a variable with all the columns and adding a comma between each. I then output to RTF and simply rename the file to a CSV extension. It seems to work OK! However, I would like to determine what I am doing wrong on the TXT format file or if it is something I need to submit to RBTI. Thanks for your input! -Bob Thompson Technology Consultants 276 Chippewa LaPorte, IN 46350 219-324-2605 (Phone & Fax) 219-363-7441 (Cell) http://ttc.inc.home.comcast.net -----Original Message----- From: Emmitt Dove [SMTP:[EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 11:10 AM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: CSV report output Bob, You don't mention which version of R:Base. If you're using 7, check out the Print to Text File Setup Options (on the File menu in Reports Designer). You can now use a v7 report to print a detail-only, fixed format text file or comma-delimited text file. Or, you can do what we do and build up a variable in code and then write the variable to a text file line-by-line. We use this for EDI exchanges with a logistics provider. >I seem to remember a thread about outputting a report to CSV format, >but I could not find it. > >I am writing an EDI application and need to create a CSV file. I know >I can EXPORT through Gateway, but it poses a particular problem. >I have to get one field of information from an accounting package >through ODBC. I have tried creating a view to include this info, but >the ODBC driver is so extremely slow, (this is not an Rbase problem) >it makes the file creation time unrealistic. Also, I have not figured out >how to turn off the column headings in the export file. (I tried Set Head >Off, but that did not accomplish the task) > >I can create a report, and use a lookup variable to the ODBC table and >the speed is fine! (Evidently, their ODBC driver does not handle views >very well. I did insure my linking columns where properly keyed) >However, while reports give me much more flexibility in creating >a data file, it does not have a CSV output format. > >Any ideas would be appreciated. > >Thanks, >-Bob > >Thompson Technology Consultants >276 Chippewa >LaPorte, IN 46350 >219-324-2605 (Phone & Fax) >219-363-7441 (Cell) >http://ttc.inc.home.comcast.net Emmitt Dove Manager, DairyPak Business Systems Blue Ridge Paper Products, Inc. 40 Lindeman Drive Trumbull, CT 06611 (203) 673-2231 [EMAIL PROTECTED] [EMAIL PROTECTED]
