Re: Cannot get CSV output from SQR - FIXED!

["Bollinger, Steve" <SBollinger@RAINBIRD.COM>]

Conclusion of CSV problem posted to yahoo/peoplesoft-fans group
I would like to correct my statement of yeasterday that this is not
fully working. We had missed applying a step in Resolution 703928
and would now like to report that it does indeed work as stated. CSV
output is occurring without a need for "write" statements,
using "print" statements only.

Note: The header prints once at the top of this file. Once in
Excel, a quick delete of those lines gets rid of the header. If
there is a comma (,) or double quote (") in a field, SQR will
properly quote around it. However we found one case where the SQR
CSV output goes wrong. If there is both a comma and a double quote
in the same field, it will incorrectly divide it into two fields.
Manual repair in Excel is not difficult, but it would be nice to have
Brio fix this. Are there any Brio employees out there to pass this
along to the development group?

Thanks to one and all who helped.
Steve Bollinger

--- In peoplesoft-fans@y...
</group/peoplesoft-fans/post?protectID=1970562531150181980901490610561810161
34026031196169130152150>, "stevieb_2000_94070" <stevieb@s...
</group/peoplesoft-fans/post?protectID=061243192084082198180218000036129208>
>
wrote:
> We did these steps and still no output. Is there anything else
anyone
> can think of that we might be doing wrong.
>
> Thanks,
> Steve
>
> --- In peoplesoft-fans@y...
</group/peoplesoft-fans/post?protectID=1970562531150181980901490610561810161
34026031196169130152150>, Ganesh.Ramasundaram@e...
</group/peoplesoft-fans/post?protectID=2441662340560991250332291751631470881
52026015009251079181045073205142076> wrote:
> > Steve,
> >
> > There is a resolution for this in Customer Connection. Here are
the
> details:
> >
> > Resolution Details: Resolution 703928, "Release 8 - How to create
a
> CSV file
> > for an SQR report"
> >
> >
> > Problem: Unable to create a CSV file for an SQR report
> >
> >
> >
> > Solution:
> >
> >
> > You won't be able to produce CSV or enhanced HTM output unless the
> > environment variable SQRDIR is defined correctly. SQR finds
> functionality
> > for producing these types of output based on that setting. SQRDIR
> is set in
> > the PSSQR.INI (Windows) or PSSQR.UNX (UNIX) file and points to
the
> correct
> > BINW where the SQR executables are installed. We deliver this set
> to dummy
> > because we have no idea where the customer will install SQR. It
is
> up to the
> > customer to set this correctly for these features to work.
> >
> >
> >
> > Here is what the different flags mean:
> >
> >
> >
> > -EH_CSV Generates a {report}.csv file from the report data.
> >
> >
> > Note: This flag is applicable only when either the -PRINTER:EH
or -
> PRINTER:
> >
> >
> > EP flag is specified.
> >
> >
> > -EH_CSV:file Associates the CSV icon with the specified file.
> >
> >
> > Note: This flag is applicable only when either the -PRINTER:EH
or -
> PRINTER:
> >
> >
> > EP flag is specified.
> >
> >
> > -EH_CSVONLY Creates a CSV file, but does not create an HTML file.
> >
> >
> > Note: This flag is applicable only when either the -PRINTER:EH
or -
> PRINTER:
> >
> >
> > EP flag is specified.
> >
> >
> >
> >
> > You should see several files popo005_xxx.csv, popo005_xxx.htm
> > popo005_xxx_frm.HTM, popo005_xxx_nav.htm depending on what flags
> you have
> > set. The xxx is the process instance.
> >
> >
> >
> > Additional Note:
> >
> >
> > Some suggestion from GSC lab:
> >
> >
> > 1. Make sure SQRBIN has been pointed to the right place where
BINW
> is
> > located. (we have a problem in here previously because we didn't
> point it to
> > the right drive.)
> >
> >
> > 2. If it doesn't work, make sure the Enhance HTML option on
Process
> > Scheduler configuration file is 'Yes'.
> >
> >
> > 3. If it still doesn't work, reboot process scheduler machine and
> clear the
> > cache.
> >
> > HTH,
> >
> > Ganesh
> >
> > -----Original Message-----
> > From: stevieb_2000_94070 [mailto:stevieb@s...
</group/peoplesoft-fans/post?protectID=061243192084082198180218000036129208>
]
> > Sent: Thursday, April 11, 2002 2:26 PM
> > To: peoplesoft-fans@y...
</group/peoplesoft-fans/post?protectID=1970562531150181980901490610561810161
34026031196169130152150>
> > Subject: Re: Cannot get CSV output from SQR
> >
> >
> > I am afraid I have not made myself entirely clear, so let me
> correct
> > that. I am not doing any "write" statements in my SQR nor do I
> > really want to. I am only doing "print" statements. This is a
> > report that I normally print to a PDF or HTM (HTML).
> >
> > In PeopleSoft 8 on the web (PIA), when one clicks "Run" to print
a
> > report, the next page is called "Process Scheduler Request".
> > Clicking "OK" on this page kicks off the report. On this page
> there
> > is a Type selection (Web, File, Email, Printer) and there is a
> Format
> > selection (PDF, SPF, HTM, HP, CSV, etc.). When printing an SQR,
> > Format CSV is available for types Email, File and Web.
Regardless
> of
> > what type I use, the Format CSV produces no output. The Process
> > Monitor says it completed successfully and Message Log gives me a
> > filename and location. Yet no such file exists. If I use any
other
> > type than CSV, then I DO get the expected output. (If I select
PDF,
> I
> > DO get a PDF file. If I select HTM, I DO get the HTM files,
etc.)
> > Here is the example of the Message Log:
> >
> > -------------------------------------------------
> > PeopleTools 8 - PSSQR
> > Copyright (c) 1988-2001 PeopleSoft, Inc.
> > All Rights Reserved
> >
> > Database Type: Microsoft
> > Database Name: SCDEV
> > Report Name: RBIN41RS
> > Process Instance: 326797
> > Run Control ID: 1
> > Output Destination Type: FILE
> > Output Destination Format: CSV
> > Output Destination: p:\temp\
> > Output Directory (SQOT):
> > P:\SCDEV\Appserv\prcs\SCDEV\log_output\SQR_RBIN41RS_326797
> > Log Directory (SQLG):
> > P:\SCDEV\Appserv\prcs\SCDEV\log_output\SQR_RBIN41RS_326797
> > SQR Flags: -ZIFP:\SCDEV\SQR\PSSQR.INI -DEBUGE -
S
> > Log File (SQLF):
> > P:\SCDEV\Appserv\prcs\SCDEV\log_output\SQR_RBIN41RS_326797
> > \RBIN41RS_326797.out
> > Include File (SQIN): P:\SCDEV\USER\SQR\;P:\SCDEV\SQR\;\;\
> > File (FILE_1): p:\temp\RBIN41RS_326797.CSV
> >
> > SQR Command = P:\SCDEV\BIN\SQRPS\SQR\MSS\BINW\sqrw
> > P:\SCDEV\USER\SQR\RBIN41RS.sqr SCDEV/*/* -
> > oP:\SCDEV\Appserv\prcs\SCDEV\log_output\SQR_RBIN41RS_326797
> > \RBIN41RS_326797.out -xmb -xcb -
> > iP:\SCDEV\USER\SQR\;P:\SCDEV\SQR\;\;\ -
ZIFP:\SCDEV\SQR\PSSQR.INI -
> > DEBUGE -S "-fp:\temp\RBIN41RS_326797.CSV" -PRINTER:EH -eh_csv
> SCDEV
> > 326797 SBOLLINGER 1
> > --------------------------------------------------
> >
> > My expectation for this option is to take my printed output and
> > deliver me a CSV file instead. I would expect that the output of
> > each coded "print" statement in my SQR would become a single
field
> in
> > the CSV file and that each print line would become a line in the
> CSV
> > file. Is this a wrong expectation? Neither PeopleBooks nor SQR
> Help
> > are helpful on this point.
> >
> > Is there something else I need to do in my code to make this
> happen?
> > Please set me straight here.
> >
> > Thanks in advance for any help,
> > Steve
> >