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Âmbennett@xxxxxxxxxx and promptly destroy all electronic and printed copies of this communication and any attached document. Thank you.
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of mapics-l-request@xxxxxxxxxxxx
Sent: Thursday, November 18, 2010 12:00 PM
To: mapics-l@xxxxxxxxxxxx
Subject: MAPICS-L Digest, Vol 8, Issue 195
Send MAPICS-L mailing list submissions to
mapics-l@xxxxxxxxxxxx
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@xxxxxxxxxxxx
You can reach the person managing the list at
mapics-l-owner@xxxxxxxxxxxx
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
(ARojas@xxxxxxxxxxx)
4. Re: Exporting data from PowerLink to Excel 2007
(Richard Stover - Guide)
5. Re: Exporting data from PowerLink to Excel 2007
(Peter_Vidal@xxxxxxxx)
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" <wwheat@xxxxxxxxxxxxxx>
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" <Micklc@xxxxxxxxx>
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: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] 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: ARojas@xxxxxxxxxxx
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" <wwheat@xxxxxxxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
Date: 11/18/2010 09:42 AM
Subject: [MAPICS-L] Exporting data from PowerLink to Excel 2007
Sent by: mapics-l-bounces@xxxxxxxxxxxx
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: MAPICS-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
visit:
http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
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" <rstover@xxxxxxxxxxxxxxxxxxxxx>
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
rstover@xxxxxxxxxxxxxxxxxxxxx
215-499-8530
-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx [mailto:mapics-l-bounces@xxxxxxxxxxxx]
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: Peter_Vidal@xxxxxxxx
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)
midrange.com
