Exporting a report to CSV

[iamtechman]

I have created a DB that prints out statements at the end of the month. I am using it to replace another DB that can export the statements to a CSV file and upload it to a service that does my billing. The problem is that I do not know how to replicate the CSV file. An example of the output for two statements looks like this:

"VERSION","CA14","RunDate: 04/27/2008","Thank you for your business!","Payments after the 15th will incur a $10.00 late fee."

"HEADER","3162 Avery Way","","Sacramento, CA 95853","(916) 358-9000","5150833","Zavil Adi","PO Box 349053","Sacramento, CA 95834","","03/24/2008","04/25/2008","28.00"

"DETAIL","5150633","03/24/2008","Crd","*** Previous balance ***",0.00

"DETAIL","5150633","04/16/2008","Inv","Ticket_#2810",28.00

"FOOTER","2"

"HEADER","3162 Avery Way","","Sacramento, CA 95853","(916) 358-9000","4181948","Tobi Duniga","1994 Kane Ave"," Sacramento, CA 95834","","03/24/2008","04/25/2008","82.25"

"DETAIL","4191948","03/24/2008","Deb","*** Previous balance ***",133.85

"DETAIL","4191948","03/26/2008","Inv","Ticket_#2502",15.90

"DETAIL","4191948","04/02/2008","Inv","Ticket_#2597",4.90

"DETAIL","4191948","04/07/2008","Pmt","Payment",-133.85

"DETAIL","4191948","04/09/2008","Inv","Ticket_#2667",4.90

"DETAIL","4191948","04/16/2008","Inv","Ticket_#2805",25.90

"DETAIL","4191948","04/23/2008","Inv","Ticket_#2881",30.65

"FOOTER","7"

"SUMMARY","# of statements = 122","total Amount billed = 7792.73"

This output is produced with two tables, one for the transactions and one for the customer address. I thought of copying them all to another table but the customer address record has more fields than the transactions and it would export with a lot of empty fields hanging at the end of the transaction. Is this something that I need to use an XSLT stylesheet to produce? Any help would be greatly appreciated.

[mz123]

You could create a script that sets a global field to a concatenation that looks like the export you need. Then you can export that field contents into a text file.

Could that work?

The meat of the script would loop and set the field globalExport to....

globalExport &¶& ""DETAIL","" and SomeNumber and "","" & somedate & "","" & someType & "","" & someDescription & "," & someBalance