Need code assistance (export from yesterday)

Matthew Williams matthew.d.williams at gmail.com
Tue Jan 18 12:08:47 PST 2005


Brian, thanks for the update, I did manage to get things working,
however I just noticed my output included only the first record for
each RepCode, some have dozens a records, this code only picks up the
first record then moves on to the next RepCode and so on and so forth.

I guess i'm a little confused now!

  1  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       If: rc ne 1 or rc ne ""                                               
       Then: close rep                                                         
  2  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       If: rc ne 1 or rc ne ""                                               
       Then: rc(3,*,g)=1 ; of = "/upss/invoices/"{1{".txt"; gosub exp          
  3  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       If:                                                                   
       Then: rep(1)=1;rep(2)=2;rep(3)=3;rep(4)=4;rep(5)=5;rep(6)=6;rep(7)=7
.... end
 
19  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
exp  If:                                                                   
       Then: export word rep = (of) -r=\n -f=,                                 
 20  -------   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -   -
       If: ' Export file header                                              
       Then: rep(1)="SalesPerson";rep(2)="OrderNumber";rep(3)="AccountNumber";
write; return

I will try to go through your email again and see what I can do, i'm
guessing its one of those IF statements you said I shouldn't have
thats preventing it from processing all the records?  Right now I'm
getting the output I want, <repcode>.txt but with only a single
record.

Thanks again!
-Matt


More information about the Filepro-list mailing list