RE: [sqr-users] LIS File characters

["Steve Cavill" <steve.cavill@infoclarity.com.au>]

Hi John, you are creating HP PCL output.  Looks like the report was declared
somehow as PCL - maybe in the setup section.  Anyway you should be able to
override that by specifying - printer:lp on the command line e.g.:

"C:\sqr5\reports\rfqfaxtb.sqt maxrep/maximo/maximo rfqnum='"frfqnum"' ''
'' '' '' '' '' '' -fC:\spl\rfqfax.lis"  -printer:lp

lp means lineprinter - i.e. ASCII

btw, congrats on an excellent problem description - you supplied everything
that could be useful - you should be in tech support!

Cheers, Steve.


-----Original Message-----
From: sqr-users-admin@sqrug.org [mailto:sqr-users-admin@sqrug.org]On
Behalf Of John F. Connell Jr.
Sent: Friday, 14 November 2003 5:31 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] LIS File characters


Hi Group,

I would like to create a multiple text file for faxing by using a lis
file output copied to a txt file. However when the files are created
they contain print characters that I don't need..

I create the lis file and text files with the following code.

begin-procedure CreateNewFile

   move #filecount to $filecount 99
   let $filecount = ltrim($filecount,' ')

NEW-REPORT 'TEST' ! Closes the current file, Junk will not be created if
!you do not write additional data to the file

print ' ' (+1,1)
let $command = getenv('comspec')

let $bfile = 'C:\spl\bak\'||$rfqnum||$filecount||'.txt'

let $ofile = 'c:\spl\rfqfax.lis'
let $nfile = 'c:\spl\'||'rfqfax'||'.txt'

let $command = $command||' /c copy '||$ofile||' '||$nfile
call system using $command #1

let $command = $command||' /c copy '||$ofile||' '||$bfile
call system using $command #1

New-report 'C:\spl\rfqfax.lis'

display $command
display #1
display $nfile
display $ofile
display $bfile
display 'File created'

let $command = getenv('comspec')
let $ofile = 'c:\spl\rfqfax.spf'
let $nfile = 'c:\spl\'||$rfqnum||$filecount||'.spf'

let $command = $command||' /c copy '||$ofile||' '||$nfile
call system using $command #1

end-procedure CreateNewFile

However when the lis file is created and copied to the txt file they
both contain print control characters like the example below when made
and this not applicable to the fax server.

E&l0O&k12.0000H&l8C(0U(s1P(s10V(s4T
&a1L&l2E&a120v86H#BEG
&a240v86H#FAX
&a240v446H890-123-4567
&a360v86H#MAIL YES
&a480v86H#SENDER
&a480v662H
&a480v2246H
&a600v86H#COMMENT1 RFQ
&a600v1526H6074
&a720v86H#USER
&a720v518H
&a840v86H#RECIP_NAME
&a840v1094HJohn Connell
&a960v86H#RECIP_COMP
&a960v1094HTest Company 1
&a1080v86H#LEF 100
&a1200v86H#END
&a1320v86H

&a1440v86HPlease revert to above fax number if incorrectly received


I am running this with a command line like this and have also tested it
without using the -f switch.

"C:\sqr5\reports\rfqfaxtb.sqt maxrep/maximo/maximo rfqnum='"frfqnum"' ''
'' '' '' '' '' '' -fC:\spl\rfqfax.lis"

The viewer spf file output is working fine and starts with the following
header.


#BEG
#FAX    890-123-4567
#MAIL YES
#SENDER
#COMMENT1 RFQ        6074
#USER
#RECIP_NAME             John Connell
#RECIP_COMP             Test Company 1
#LEF 100
#END

Any ideas would be appreciated.

TIA

Regards,

John

John F. Connell Jr.


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users


_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users