RE: Question on exporting to Excel from the iSeries

["Terry Anderson" <terrya@xxxxxxxxxxxx>]

Dale,
Go to http://www.geocities.com/~alex_nubla/tips.htm and look for the tip
that says "Convert Physical File to Excel".

I use this all the time to convert PF's to an excel sheet which is then
emailed to the user. 

Terry Anderson



> > message: 7
> > date: Mon, 26 Feb 2007 16:06:40 -0500
> > from: DaleGindlesperger@xxxxxxxxxxx
> > 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