creating multi export

[Jeff Harrison]

----- Original Message ----

> From: Dennis Malen <dmalen at malen.com>
> To: filepro-list at lists.celestial.com
> Sent: Mon, February 28, 2011 10:33:43 PM
> Subject: creating multi export
> 
> When creating a multi export file the file it creates uses the following for 
> values:
> 
> C;Y(row);X(column);K(value)
> 
> If I want to send a line  that creates a new position in the file, what 
> command would I send from  filepro?
> 
> For instance, I want to add a total to the next line.
> The  fifth line is:
> C;Y5;X3,K20.00
> 
> I want the next line (6) to be the total  of everything preceding the fifth 
> row. I need to send it at the end of line  5 as a dummy field is holding the 
> accumulated total. So Need to  send:
> 
> C;Y6;X3;K(total)
> 
> When the multi export writes the next line  it will overwrite the old line 6 
> with the new one and then create a line 7  with the new total. This way I 
> will always have a total.
> 
> Any  ideas.
> 
> Dennis Malen
> 516.479.5912 
> 

Hi Dennis.  Its been a while, but believe that export multi works similarly to 
any other export.  So I believe something like the following should work.  
Basically you just need to execute the same export line with different values - 
the total value in your case.

::running_total = running_total + xx:
::aa=1; ab=2; ac=3; ad=4:
::gosub expit:
:line = '6' 'if it is time to export the total do it here:aa=""; ab=""; ac=""; 
ad=running_total; gosub expit:
::end:
expit:::
::export multi fil = etc...:
::fil(1)=aa; fil(2)=ab; fil(3)=ac; fil(4)=ad:
::return:

Good Luck.

Jeff Harrison
Author of JHExport and JHImport