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)

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.