How to make a report with one output file for each record

[Richard Kreiss]

> -----Original Message-----
> From: filepro-list-bounces+rkreiss=verizon.net at lists.celestial.com
[mailto:filepro-list-
> bounces+rkreiss=verizon.net at lists.celestial.com] On Behalf Of Enrique
Arredondo
> Sent: Thursday, June 03, 2010 9:54 AM
> To: filepro-list at lists.celestial.com
> Subject: How to make a report with one output file for each record
> 
> Hi
> 
> I need to run a report that will generate a flat file that will be
> processed by my Unix-EDI software but instead of creating a single output
> I need it to spawn multiple outputs and one for each record. So that when
> my EDI software imports each flat file it sends a separate document in
> order to get an acknowledgement for each invoice (997).
> 
> I thought about doing an ascii export but that will only create one file,
> or could I make the filename dynamic ?
> 
> Thanks

Export the file based on each invoice.  If you have header/detail records,
create the output from the header.  Close the export after the last details
record is read.

Use a variable for the file name such as Innnn.csv.  As each record is
processed, the export file name changes.

However, this may present a problem for your edit software as it needs to
read in each file and then process it.

At the current time at 2 clients who are using EDI, one file is transmitted
with a unique transmittal number.  A report is generated with this # and the
invoice and dollar total sent.  The next day, the functional
acknowledgements returned are matched up to the transmission of the
preceding day. 


Richard Kreiss
GCC Consulting
rkreiss at gccconsulting.net