Re: Data transfer question

HI Greg,

We use a tool from Symtrax for this (XL400 - although they have replaced it with Starquery now), but you could do either of these:

Edit the data transfer select option to read "ORDNO as Order_Number" for example

Use VBA to extract directly from iSeries, I have used this quite successfully, modifying code found here: http://itknowledgeexchange.techtarget.com/beyond-excel/say-goodbye-to-querytables/
You can, for example, enter a couple of dates in an excel spreadsheet, click a button and return all sales between these two dates. This effectively does the same as the Symtrax offering but without having to buy any software. It allows you to pass variables from your excel spreadsheet into the SQL statement for extracting.

Kind regards,

David.

-----Original Message-----
From: mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected] [mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Greg Wenzloff
Sent: 23 June 2011 15:21
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.


________________________________

Please consider your environmental responsibility before printing this e-mail.
**
The information transmitted in this document is intended only for the person or entity to whom it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender and delete all copies of the material. Any views or opinions presented in this email are solely those of the author and do not necessarily represent those of CML Innovative Technologies.
________________________________________
_______________________________________________
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.