Exporting data from PowerLink to Excel 2007 RE: MAPICS-L Digest, Vol 8, Issue 195
Mike Bennett <[email protected]>
| Newsgroups | gmane.comp.systems.as400.mapics |
|---|---|
| Message-ID | <[email protected]> |
2 cents MS ACCESS is a very good data mining tool for Infor Data Tables too. ODBC (linked tables) You can even solve the whole 1100101 (not binary) date problem thing by building and joining to a table that has all the Infor dates in one column and real dates in another. Mike Bennett Improvement Requires Change Your existing system is designed to give you the results you're currently getting. If you want different results, you must change the system! Materials Manager www.kimray.com Think Green--Please don't print this e-mail unless you really need to. This e-mail may contain information which is privileged, confidential, and protected from disclosure. If you are not an intended recipient, any disclosure, dissemination, distribution, copying, or other use of this communication is strictly prohibited. If you have received this communication in error, please e-mail the sender at [email protected] and promptly destroy all electronic and printed copies of this communication and any attached document. Thank you. -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, November 18, 2010 12:00 PM To: [email protected] Subject: MAPICS-L Digest, Vol 8, Issue 195 Send MAPICS-L mailing list submissions to [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 [email protected] You can reach the person managing the list at [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. Exporting data from PowerLink to Excel 2007 (Weston Wheat) 2. Re: Exporting data from PowerLink to Excel 2007 (Chuck Mick) 3. Re: Exporting data from PowerLink to Excel 2007 ([email protected]) 4. Re: Exporting data from PowerLink to Excel 2007 (Richard Stover - Guide) 5. Re: Exporting data from PowerLink to Excel 2007 ([email protected]) 6. Re: Exporting data from PowerLink to Excel 2007 (Weston Wheat) ---------------------------------------------------------------------- message: 1 date: Thu, 18 Nov 2010 10:41:51 -0700 from: "Weston Wheat" <[email protected]> subject: [MAPICS-L] Exporting data from PowerLink to Excel 2007 Hello All. I have this weird problem. I cannot get a large record set of data to export correctly into Excel from powerlink. It is leaving out records in the exported text file. We are trying to export bookings data to Excel and the totals are not matching up. Also the row count is off so we know that it is skipping records. I have up'ed on the Limit clipboard export to first K Chars, setting to the max. But that didn't help. Does anyone have any tricks that work? We are at R7.8 . Thanks And p..s. Please don't flood this tread with a bunch of Marketing for Excel linked financial type appl's. ------------------------------ message: 2 date: Thu, 18 Nov 2010 12:47:54 -0500 from: "Chuck Mick" <[email protected]> subject: Re: [MAPICS-L] Exporting data from PowerLink to Excel 2007 Weston, I had a similar issue in R7.7 with the client. I worked with support on and off for a while but was never able to obtain a definitive reason. I would appear to be missing random rows and records...but never as consistent as one would expect. In my case, I was trying to push Infor by using the count statistic to get the rows...and then export. The count statistic and the export would not have the same number of rows. This made it easier to demonstrate the issue...but did not give a resolution. Ultimately, I pushed the larger sets to ODBC links in Excel with pivot tables. This is what the users really wanted in my case...so maybe it is an option? 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: [email protected] [mailto:[email protected]] On Behalf Of Weston Wheat Sent: Thursday, November 18, 2010 12:42 PM To: MAPICS ERP System Discussion Subject: [MAPICS-L] Exporting data from PowerLink to Excel 2007 Hello All. I have this weird problem. I cannot get a large record set of data to export correctly into Excel from powerlink. It is leaving out records in the exported text file. We are trying to export bookings data to Excel and the totals are not matching up. Also the row count is off so we know that it is skipping records. I have up'ed on the Limit clipboard export to first K Chars, setting to the max. But that didn't help. Does anyone have any tricks that work? We are at R7.8 . Thanks And p..s. Please don't flood this tread with a bunch of Marketing for Excel linked financial type appl's. ------------------------------ message: 3 date: Thu, 18 Nov 2010 09:50:01 -0800 from: [email protected] subject: Re: [MAPICS-L] Exporting data from PowerLink to Excel 2007 Have you tried to transfer the data directly from Excel using the "Add-ins" (provide by iSeries Access). I do this every time that there is a need of getting a large number of records. Antonio. From: "Weston Wheat" <[email protected]> To: "MAPICS ERP System Discussion" <[email protected]> Date: 11/18/2010 09:42 AM Subject: [MAPICS-L] Exporting data from PowerLink to Excel 2007 Sent by: [email protected] Hello All. I have this weird problem. I cannot get a large record set of data to export correctly into Excel from powerlink. It is leaving out records in the exported text file. We are trying to export bookings data to Excel and the totals are not matching up. Also the row count is off so we know that it is skipping records. I have up'ed on the Limit clipboard export to first K Chars, setting to the max. But that didn't help. Does anyone have any tricks that work? We are at R7.8 . Thanks And p..s. Please don't flood this tread with a bunch of Marketing for Excel linked financial type appl's. _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: [email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l. ------------------------------ message: 4 date: Thu, 18 Nov 2010 12:52:17 -0500 from: "Richard Stover - Guide" <[email protected]> subject: Re: [MAPICS-L] Exporting data from PowerLink to Excel 2007 In PowerLink go into any one of the main views (i.e. Customer Service); select CUSTOMIZE then PREFERENCES then the MISCELLANEOUS tab. Change the "Limit Clipboard" value. Best Regards Richard (Dick) Stover Consulting Manager INFOR GOLD LEVEL CHANNEL PARTNER www.guidetechnologies.com [email protected] 215-499-8530 -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Weston Wheat Sent: Thursday, November 18, 2010 12:42 PM To: MAPICS ERP System Discussion Subject: [MAPICS-L] Exporting data from PowerLink to Excel 2007 Hello All. I have this weird problem. I cannot get a large record set of data to export correctly into Excel from powerlink. It is leaving out records in the exported text file. We are trying to export bookings data to Excel and the totals are not matching up. Also the row count is off so we know that it is skipping records. I have up'ed on the Limit clipboard export to first K Chars, setting to the max. But that didn't help. Does anyone have any tricks that work? We are at R7.8 . Thanks And p..s. Please don't flood this tread with a bunch of Marketing for Excel linked financial type appl's. ------------------------------ message: 5 date: Thu, 18 Nov 2010 12:55:36 -0500 from: [email protected] subject: Re: [MAPICS-L] Exporting data from PowerLink to Excel 2007 Did you try to do this? 1) On MAPICS Browser, click on CUSTOMIZE >> PREFERENCES 2) Click on the MISCELLANEOUS tab. 3) Increment the EXPORT value I believe you can put 9999999. 4) Click on CONTINUE. Then, just in case, close the browser, call it again and try to do the export once more... PETER VIDAL PALL CORPORATION SR System Analyst | WH Application Development 10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111 727-844-2414 | Fax: 727-815-3120 | www.pall.com "Imagination is more important than knowledge" Albert Einstein (1879 - 1955) -- -------------------------------------------------------------------------------- Attention: This communication may contain information that is confidential, privileged and/or exempt from disclosure under applicable law. If you are not the intended recipient, please notify the sender immediately and delete the original, all attachments, and all copies of this communication. -------------------------------------------------------------------------------- ------------------------------ message: 6 date: Thu, 18 Nov 2010 10:56:34 -0700 from: "Weston Wheat" <[email protected]> subject: Re: [MAPICS-L] Exporting data from PowerLink to Excel 2007 Thanks But I tried that already. Weston -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of [email protected] Sent: Thursday, November 18, 2010 10:56 AM To: MAPICS ERP System Discussion Subject: Re: [MAPICS-L] Exporting data from PowerLink to Excel 2007 Did you try to do this? 1) On MAPICS Browser, click on CUSTOMIZE >> PREFERENCES 2) Click on the MISCELLANEOUS tab. 3) Increment the EXPORT value I believe you can put 9999999. 4) Click on CONTINUE. Then, just in case, close the browser, call it again and try to do the export once more... PETER VIDAL PALL CORPORATION SR System Analyst | WH Application Development 10540 Ridge Rd., Suite 203, New Port Richey, FL 34654-5111 727-844-2414 | Fax: 727-815-3120 | www.pall.com "Imagination is more important than knowledge" Albert Einstein (1879 - 1955) -- ------------------------------------------------------------------------ -------- Attention: This communication may contain information that is confidential, privileged and/or exempt from disclosure under applicable law. If you are not the intended recipient, please notify the sender immediately and delete the original, all attachments, and all copies of this communication. ------------------------------------------------------------------------ -------- ------------------------------ _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) digest list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: [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 8, Issue 195 **************************************** _______________________________________________ This is the MAPICS ERP System Discussion (MAPICS-L) mailing list To post a message email: [email protected] To subscribe, unsubscribe, or change list options, visit: http://lists.midrange.com/mailman/listinfo/mapics-l or email: [email protected] Before posting, please take a moment to review the archives at http://archive.midrange.com/mapics-l.