Thanks Emmitt,
Very odd. I did the same as you listed below. My result was
a file created with 0 bytes! Oh well.... too many other things
to do at the moment, so I will have to let it go.
Thanks again,
-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 12:09 PM
To: RBASE-L Mailing List
Subject: [RBASE-L] - Re: CSV report output
Bob,
I just went into Concomp, selected the contacts by customer report, did the
text file setup (comma delimited), and printed to a text file. I obtained
the expected results. So in principle it works.
My steps:
1. Open the report in the designer.
2. Select File / Text file setup
3. Specify the filename
4. Select the file type as comma delimited
5. Select the detail band
6. Select all objects from the available list and move them to the selected
list
7. Close the designer
8. From db explorer, select the report and click Run
9. Click on File under print target, click OK
10. In the print to file section, select TEXT as the file type
11. Click OK and it works.
>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]
Emmitt Dove
Manager, DairyPak Business Systems
Blue Ridge Paper Products, Inc.
40 Lindeman Drive
Trumbull, CT 06611
(203) 673-2231
[EMAIL PROTECTED]
[EMAIL PROTECTED]
