Headings on Data Transfer
Connie Webb <cwebb-mcPmRQV/[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
I use the "results" field in QRY to rename the headings. Just be sure to select the renamed field in your report. See this example: STORE T02.LLOCN Location Everytime you run this qry the heading STORE will come down instead of LLOCN. -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of mapics-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] Sent: Thursday, June 23, 2011 1:00 PM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: MAPICS-L Digest, Vol 9, Issue 78 Send MAPICS-L mailing list submissions to mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe or unsubscribe via the World Wide Web, visit http://lists.midrange.com/mailman/listinfo/mapics-l or, via email, send a message with subject or body 'help' to mapics-l-request-Zwy7GipZuJhWk0Htik3J/[email protected] You can reach the person managing the list at mapics-l-owner-Zwy7GipZuJhWk0Htik3J/[email protected] When replying, please edit your Subject line so it is more specific than "Re: Contents of MAPICS-L digest..." Today's Topics: 1. Data transfer question (Greg Wenzloff) 2. Re: Data transfer question (Chuck Mick) 3. Re: Data transfer question (Tom E Stieger) 4. Re: Data transfer question (Dale Gindlesperger) 5. Re: Data transfer question ([email protected]) 6. Re: Data transfer question (Tim Rosendahl) 7. Re: Data transfer question ([email protected]) ---------------------------------------------------------------------- message: 1 date: Thu, 23 Jun 2011 10:21:23 -0400 from: "Greg Wenzloff" <[email protected]> subject: [MAPICS-L] Data transfer question I need to transfer the contents of a MAPICS file into an Excel spreadsheet. When I do this I get column headings such as ORDNO. Is there something I can do to get different column headings other than the field name. Perhaps ORDER NUMBER. I want to automate this and not go into Excel to adjust column heading each time this transfer is run. Thanks, Greg ------------------------------ message: 2 date: Thu, 23 Jun 2011 10:28:18 -0400 from: "Chuck Mick" <[email protected]> subject: Re: [MAPICS-L] Data transfer question Greg, This may not be the desired option... We often create a refreshable file with the standard XA names...but we then insert a pivot table that contains the user desired information / report. Within the pivot table, we rename the column headings to be more friendly. Users can then refresh the data and the pivot...retaining the headings. Alternatively, we have several 'reports' that have standard headers and the imported information displays before the headers. We set Excel to not include the field names... Other times (and I know this probably not the most efficient...but is effective for us)...we create logical views and rename the columns as desired. We then refresh using the logical. I would like to see if anybody gives a direct answer...but we have 'worked around' it as above... Chuck Chuck Mick Diversified Machine Inc. (o) 248.277.4315 (m) 517.643.3548 ? Confidential: This electronic message and all contents or attachments contain information from Diversified Machine, Inc. which may be privileged, confidential or otherwise protected from disclosure. The information is intended to be for the addressee only. If you are not the addressee, or have received this message in error, any disclosure, copy, distribution or use of the contents of this message is prohibited. If you have received this electronic message in error, please notify us immediately (248-277-4311) and destroy the original message and all copies.?Thank you for your assistance in this matter. ? ** Please consider the environment before printing this e-mail ** ? -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Greg Wenzloff Sent: Thursday, June 23, 2011 10:21 AM To: MAPICS ERP System Discussion Subject: [MAPICS-L] Data transfer question I need to transfer the contents of a MAPICS file into an Excel spreadsheet. When I do this I get column headings such as ORDNO. Is there something I can do to get different column headings other than the field name. Perhaps ORDER NUMBER. I want to automate this and not go into Excel to adjust column heading each time this transfer is run. Thanks, Greg _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 3 date: Thu, 23 Jun 2011 07:37:49 -0700 (PDT) from: Tom E Stieger <testieger-7y5+ka1ulstWk0Htik3J/[email protected]> subject: Re: [MAPICS-L] Data transfer question Greg- How are you doing the transfer? I've been semi-successful using some properties on a JDBC Connection URL to bring over the column headings. JDBC Driver: com.ibm.as400.access.AS400JDBCDriver JDBC URL: jdbc:as400://myas400.name;translate binary=true; extended metadata = true; This would bring over a column heading looking like this: 'Order Number' I'm not sure if there something similar with ODBC. I think I have also had success using some of Chuck's suggestions. -Tom Stieger IT Manager California Fine Wire -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Greg Wenzloff Sent: Thursday, June 23, 2011 7:21 AM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: [MAPICS-L] Data transfer question I need to transfer the contents of a MAPICS file into an Excel spreadsheet. When I do this I get column headings such as ORDNO. Is there something I can do to get different column headings other than the field name. Perhaps ORDER NUMBER. I want to automate this and not go into Excel to adjust column heading each time this transfer is run. Thanks, Greg _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 4 date: Thu, 23 Jun 2011 08:06:01 -0700 (PDT) from: Dale Gindlesperger <dale_gindlesperger-/[email protected]> subject: Re: [MAPICS-L] Data transfer question Greg, I've used three ways regularly, all work OK, but none are "ideal" in my opinion.?? 1)? For repeated extracts of the same data using the Client Access "Access data from iSeries" option, I keep the spreadsheet headings intact, clear the data, and position the cursor to below the headings, then transfer without including the headings from the extract file.? Formatting stays intact, headings are the way the user wants them.?? Manual process, yes, but it's easy and works fine.? BUT.... only practical for repeated downloads of the same data. 2)? Another way to automate the process (similar), is to use a CL, keep a "canned heading" file stored in the folder, copy the canned heading file in, then copy append the data afterwards.? Then I can email the file to the user.? That's how I eliminated a lot of printed reports.? However, like option #1, this only works for repeats. A possible alternative (if Excel is not a carved-in-stone requirement) is: 3)? I also eliminated a number of reports with Browser/PowerLink/NetLink by creating the reports as databases and letting the users access the information on demand.? That way you don't have to worry about headings and such, or emailing.? You can also easily create comment fields that users can populate during the day to pass information.? That was popular with some of the production departments and the sales and marketing people.? Again, only useful for repeats, but I really liked that when I could use it.? You don't need to get copies of Office (and yes, I used OpenOffice extensively - over 80% of the PCs had it), but you STILL have to install and set it up), so it can save you money over time (assuming your users use Browser/PowerLink/NetLink). I'm looking forward to hearing what others have come up with for this!? :) Dale (Cork) Gindlesperger, CPIM Click here for my professional profile on LinkedIn "If I'd asked my customers what they wanted, they'd have said a faster horse." - Henry Ford >________________________________ >From: Greg Wenzloff <[email protected]> >To: MAPICS ERP System Discussion <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> >Sent: Thursday, June 23, 2011 10:21 AM >Subject: [MAPICS-L] Data transfer question > >I need to transfer the contents of a MAPICS file into an Excel >spreadsheet. >When I do this I get column headings such as ORDNO. > >Is there something I can do to get different column headings other than >the field name. >Perhaps ORDER NUMBER. > >I want to automate this and not go into Excel to adjust column heading >each time this transfer is run. > >Thanks, >Greg >_______________________________________________ >This is the MAPICS ERP System Discussion (MAPICS-L) mailing list >To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] >To subscribe, unsubscribe, or change list options, >visit: http://lists.midrange.com/mailman/listinfo/mapics-l >or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] >Before posting, please take a moment to review the archives >at http://archive.midrange.com/mapics-l. > > > > ------------------------------ message: 5 date: Thu, 23 Jun 2011 11:16:23 -0400 from: <[email protected]> subject: Re: [MAPICS-L] Data transfer question You can gather all column's field names and inside the Client Access transfer change the name, like below Select area: ORDNO as order_number Jose Rivera -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Greg Wenzloff Sent: Thursday, June 23, 2011 7:21 AM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: [MAPICS-L] Data transfer question I need to transfer the contents of a MAPICS file into an Excel spreadsheet. When I do this I get column headings such as ORDNO. Is there something I can do to get different column headings other than the field name. Perhaps ORDER NUMBER. I want to automate this and not go into Excel to adjust column heading each time this transfer is run. Thanks, Greg _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 6 date: Thu, 23 Jun 2011 09:07:48 -0700 (PDT) from: Tim Rosendahl <rosetj2011-/[email protected]> subject: Re: [MAPICS-L] Data transfer question I jave several of these and I set up a template for each of the transfers. I the transfer request I have unchecked the item wich includes fields headings. ________________________________ From: "[email protected]" <[email protected]> To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Sent: Thu, June 23, 2011 11:16:23 AM Subject: Re: [MAPICS-L] Data transfer question You can gather all column's field names and inside the Client Access transfer change the name,? like below Select area: ORDNO as? order_number Jose Rivera -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Greg Wenzloff Sent: Thursday, June 23, 2011 7:21 AM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: [MAPICS-L] Data transfer question I need to transfer the contents of a MAPICS file into an Excel spreadsheet. When I do this I get column headings such as ORDNO. Is there something I can do to get different column headings other than the field name. Perhaps ORDER NUMBER. I want to automate this and not go into Excel to adjust column heading each time this transfer is run. Thanks, Greg _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 7 date: Thu, 23 Jun 2011 09:24:03 -0700 from: [email protected] subject: Re: [MAPICS-L] Data transfer question Hi Greg, We use Sequel Viewpoint from Help Systems and works perfect for us when downloading data to Excel including the column names, other benefits are: - Conversion of the Date from CYYMMDD to MMDDYY or any other format - You can change the value of the output field.. .for example instead of showing ITTYP = 1, your query can convert this to column 'Item Type', and the value to be : "1 - Finished Good' We also have Linoma software for this. Regards Antonio. From: Tim Rosendahl <rosetj2011-/[email protected]> To: MAPICS ERP System Discussion <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]> Date: 06/23/2011 09:08 AM Subject: Re: [MAPICS-L] Data transfer question Sent by: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] I jave several of these and I set up a template for each of the transfers. I the transfer request I have unchecked the item wich includes fields headings. ________________________________ From: "[email protected]" <[email protected]> To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Sent: Thu, June 23, 2011 11:16:23 AM Subject: Re: [MAPICS-L] Data transfer question You can gather all column's field names and inside the Client Access transfer change the name,? like below Select area: ORDNO as? order_number Jose Rivera -----Original Message----- From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Greg Wenzloff Sent: Thursday, June 23, 2011 7:21 AM To: mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected] Subject: [MAPICS-L] Data transfer question I need to transfer the contents of a MAPICS file into an Excel spreadsheet. When I do this I get column headings such as ORDNO. Is there something I can do to get different column headings other than the field name. Perhaps ORDER NUMBER. I want to automate this and not go into Excel to adjust column heading each time this transfer is run. Thanks, Greg _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) digest list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. End of MAPICS-L Digest, Vol 9, Issue 78 *************************************** This email and any files transmitted with it are confidential and intended solely for the use of the individual to whom they are addressed. If you are not the intended recipient, be aware that disclosing, copying, distributing, or taking any action in reliance on the contents of this information is strictly prohibited. Please notify the sender immediately by email if you have received this email in error and delete this email from your system. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: MAPICS-L-request-Zwy7GipZuJhWk0Htik3J/[email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.