Re: Question on exporting to Excel from the iSeries

Hi Dale - I came across this web-page some time ago, and kept it for future
reference.

http://www.mcpressonline.com/mc?50@xxxxxxxxxxxxxxxxxxxxx@.6ae84984



Alan Shore

NBTY, Inc
(631) 244-2000 ext. 5019
AShore@xxxxxxxx

midrange-l-bounces@xxxxxxxxxxxx wrote on 02/26/2007 04:06:40 PM:

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


--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing

list

To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.