Complex CSV export

[John Scott]

My shopping cart is designed to interface with QuickBooks, but I am a die-hard Panorama user (since OverVue).  I need to export a complex CSV file to import into my shopping cart.  The file format has several sections, each with header info on multiple lines, and then data, sometimes combining info from several records onto a single line.

My understanding of the export wizard is somewhat limited (I am an old-school forms kinda guy), but the multiple-line headers, and combining data from a non-fixed number of records onto a single line both seem incompatible with this route.  Generally, I would prefer to solve this using scripts and forms.

I can produce the CSV lines readily using multiple forms, but am unable to output them into a single file with appropriate header info before each section.

1) Is there any way to append to a single text file when I use save as text?

2) How can I write multiple lines of header info to a text file (the text from a header tile is ignored when I save as text)?

I considered exporting into separate files, bringing them back into a single Panorama file (I could then script in the header info between each import), but since these are csv files Panorama wants to break each line imported into multiple fields.

Thanks...

-John