|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.