interesting problem
Richard Kreiss
rkreiss at verizon.net
Thu Jun 17 10:46:38 PDT 2010
> -----Original Message-----
> From: Kenneth Brody [mailto:kenbrody at spamcop.net]
> Sent: Thursday, June 17, 2010 12:10 PM
> To: Richard Kreiss
> Cc: filepro-list at lists.celestial.com
> Subject: Re: interesting problem
>
> On 6/17/2010 10:59 AM, Richard Kreiss wrote:
> > Declare run_date(8,yymd),filename
>
> So far, so good.
>
> > d_code(4,#)(real field)
>
> That's not valid filePro code.
>
> > Run_date=@td
>
> I would suggest @T4, though @TD is fine with a valid PFCMARK setting. - done
>
> > Filename="f:\foobar\d_code{run_date{".txt"{""
OK: here is the code:
13 ------- - - - - - - - - - - - - - - - -
◄ If:
Then: bs=chr("92")
14 ------- - - - - - - - - - - - - - - - -
◄ If:
Then: drive=getenv("pfdata"){getenv("pfdir")
15 ------- - - - - - - - - - - - - - - - -
◄ If:
Then: where=drive{bs{"web_txt"{""
16 ------- - - - - - - - - - - - - - - - -
◄ If:'not used - remove
Then:' doc_folder=drive{bs{"web_files"{bs{doc_code{""
17 ------- - - - - - - - - - - - - - - - -
◄ If: 'check to see if director exists
Then: GOSUB ck_fold
18 ------- - - - - - - - - - - - - - - - -
◄ If: 'reverse date format and append to file name
Then: run_date=@t4
19 ------- - - - - - - - - - - - - - - - -
◄ If:
Then: fname=where{bs{doc_code{"_"{run_date{".txt"
20 ------- - - - - - - - - - - - - - - - -
◄ If: rn ne @rn
Then: rn(8,.0,g)=@rn
21 ------- - - - - - - - - - - - - - - - -
printit◄ If:
Then: CLS("1","4")
22 ------- - - - - - - - - - - - - - - - -
◄ If: zz = ""
Then: zz(4,.0)=numrecs(-)+"1"
23 ------- - - - - - - - - - - - - - - - -
◄ If:
Then: what="-v sel_drweekly -a -u -iF"<"-rw"<doc_code<"-rz"<zz<"-p"<fname
24 ------- - - - - - - - - - - - - - - - -
◄ If:
Then: doit=drive{"/fp56/fp/rreport l_patient_market -f members_weekly"<what
25 ------- - - - - - - - - - - - - - - - -
◄ If:
Then: system doit
>
> That's not a valid line. Please give the actual line.
>
> > System run rreport members -f weekly_report -v sel_members -rw d_code -p
> > filename
>
> Again, that's not valid code. Please give the actual line.
>
> > Filename should resolve into NNNN_20100617.txt for this report.
>
> "Should", or "did"?
In 124 cases it resolved properly. 6 case had the added 0001. This report has been run since April 24th each day and this is the first time this has happened.
>
> > These txt file are being converted to pdf file through Printwiz service.
>
> Via what command?
Printwiz is running as a service looking for TXT file in the e:\company\filepro\web_txt directory. The service work properly in creating the pdf in e:\company\filpro\web_files. (UNC path would be \\ccpdbsrv\filpro\web_txt or \\ccpdbsvr\web_files). All pdf's are created and the txt file deleted.
>
> > There are 130 separate d_codes to select with varying number of member
> > associated with that code.
> >
> > Of these, about 6 files had the name NNNN_201006170001.pdf.
> >
> > Can anyone suggest where the 00001 after the run_date may have come from?
>
> Give us the actual code to generate the SYSTEM dreport command and all of
> its components, as well as the command to convert the txt to pdf. Plus,
> what was the corresponding txt filename?
>
> --
> Kenneth Brody
More information about the Filepro-list
mailing list