Re: 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.   

 

 

 

_______________________________________________
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.