RE: Question on exporting to Excel from the iSeries

I have used Giuseppe Costagliola's SQL2CSV tool for many of my data extract 
projects....

I'll point you to the forum where several bugs and fixes are discussed, but the 
top of the page has a link to the original article, where you can download the 
source code.  

http://www.mcpressonline.com/mc?128@xxxxxxxxxxxxxxxx@.6b0883b3

Eric

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of
DaleGindlesperger@xxxxxxxxxxx
Sent: Monday, February 26, 2007 3:07 PM
To: midrange-l@xxxxxxxxxxxx
Subject: Question on exporting to Excel from the iSeries






Hi list,

I need some assistance, and I'm certain this stellar group can assist me.
Currently, we run a variety of jobs that build files on the iSeries (i5,
whatever).  For some users, they go into Excel and do a "Transfer Data from
iSeries".   However, some of my users are remote, without access to the
iSeries readily available.  For those users, I am requested to just e-mail
them the data.  Today, I use the following command to create the file as a
CSV:


 CPYTOIMPF  FROMFILE(FGCSTIV3) TOSTMF('/FGCSTIV3.CSV') +
              MBROPT(*REPLACE) RCDDLM(*CR)

and I email the file to them through the iSeries using this command:

 SNDEMAIL   FILENAME('LIST COSTS FOR TRAILERS - AFTER +
              COST ROLL') +
              RECIPADDR('DGINDLES@xxxxxxxxxxx') +
              SENDERADDR('TDISTEFANO@xxxxxxxxxxx') +
              SENDERNAME('IT Department') +
              ATTACHMENT('/FGCSTIV3.CSV') SUBJECT('LIST +
              COSTS FOR TRAILERS - AFTER COST ROLL') +
              MESSAGE('The file headers from left to +
              right are: Item#, Desc, Cur Mtl, Cur Lbr, +
              Cur Ovh, Cur Oth, Cur Unit Cst, Tot Mtl +
              Std, Tot Lbr Std, Tot Ovr Std, Tot Other +
              Cost Std, Std Cost, Diff Cur to Std')

That part works fine.   The problem is when I have a complex spreadsheet,
with a lot of columns.  This approach just puts data out there, without
column headings - not even field names.  Putting the fields labels in the
body of the email is OK for a 5 or 6 column sheet, but a big sheet is
impractical.

Has anyone figured out an approach that resolves this?   I had thought
about changing the CL to concatenate a one-line CSV file at the beginning
that contained headings, but I can't see to where the CPYTOIMPF file writes
the data.

Help?

Dale Gindlesperger
IT Manager/Special Projects Leader
Fleetwood Folding Trailers, Inc.
258 Beacon Street
Somerset, PA  15501