Convert Spool file to data file
Debra Priest
formatted like a print file. I want formatted data to use in spreadsheet.
Deb
Ugo Gagliardelli
Debra Priest wrote:
>
> New to AS400. Have tried the CPYSPLF command but that seems to give me data
> formatted like a print file. I want formatted data to use in spreadsheet.
A possible way is to copy the spooled file into an external described
file with appropriate fields to accomodate the columns of the printed
report, you may want to create a logical file to omit undesired columns
or undesired rows (e.g.page header information or dummy columns), then
copy the logical file into the spreadsheet.
--
Dr.Ugo Gagliardelli,Modena,Italy-Certified uindoscrasher-AlcoolInside
Spaccamaroni andate a cagare/Spammers not welcome
Spamers iros a la mierda/Spamers allez vous faire foutre
Spammers loop schijten/Spammers macht Euch vom Acker
James Durr
My company sells an AS/400 command, CVTSPLF (Convert Spooled File), that
can convert
an AS/400 report to an Excel spreadsheet and place it in the Integrated
File System.
Visit our site at http://www.kemetech.com to learn more and request an
evaluation.
--
James Durr
Technical Consultant
KemeTECH Systems Inc.
103 Vassar Avenue, Newark, NJ 07112-2249
Phone( 973) 923-2328 e-fax (978-231-5825)
jd...@kemetech.com
Terry Perkins
There are some programming techniques & commercial products to help with
this. But I find this works for me using MS Excel.
Get the file onto your PC. Use Operations Navigator & drag the print
file to your desktop (or CPYSPLF & download).
Open the resulting text file with a text editor (eg Notepad) and remove
extraneous page headers and footers. You might leave or cleanup any
column headers at the top of the report.
Then open the result with Excel (request all file types & look on the
desktop or wherever you saved the resulting .txt file.. If your setup
works like mine, this will start an Excel Import Wizard. It will
probably give you just about what you want by default. You can tailor
individual columns if needed.
Terry P
tpe...@gocougs.wsu.edu
Dan Hicks
In addition to what others have said, sometimes you can OVRDBF the print
file and write the print data directly to a DB file with fields defined
to match the print file fields. It's tricky and not too robust (and
often simply not possible, depending on what's being done), but in some
cases it will get you the data in nice columns.
--
Dan Hicks
More die in the United States of too much food than of too little. --
Galbraith
Walter
without column structure.
You can simply drag and drop it onto your PC with Operations Navigator,
which is part of AS/400's PC client software Client Access.
Many other ways to do this, like cpysplf and ftp it to the PC, copying the
spool file as ascii txt into a folder of the AS/400's built-in PC server
system (advantage: can be done automatically by batch CL) and mapping this
folder as drive letter in your PC and others.
Then you have a ascii txt file on your PC. To get it into a spreadsheet you
must do the same as always with the import function of Excel or so.
Nice alternative: prepare a receiving file on the AS/400 with a logical view
that fits to the columns, cpysplf the data into it and open this logical
file directly from Excel via ODBC. Kill header and footer lines, if
necessary (Bradley Stone wrote a shareware called SPLTOOL that does this and
many other things automatically and is used instead of WRKSPLF and CPYSPLF).
Walter
Richard Schoen
If you're open to commercial solutions, take a look at our CSV converter
which allows you to query a report just like a database and select just the
records and the columns you need from within the report.
For more information, check out our web site or contact me directly.
Regards,
Richard Schoen
RJS Software Systems Inc.
"The AS/400 Report and Data Delivery Experts"
Email: ric...@rjssoft.com
Web Site: http://www.rjssoft.com
"Debra Priest" <pri...@bellsouth.net> wrote in message
news:%5_58.633$Up4....@e3500-atl1.usenetserver.com...