|
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
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2025 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.