Atul,

If I understand your statement correctly, you know how to export data from 
MAPICS to Excel, so your problem is in exporting IMHIST file.
You can not export the complete file of IMHIST, this is because there is a 
field in IMHIST called TKEN(Token), which is not understood by Excel. So, 
you need to create a simple query using IMHIST after excluding the TKEN 
field, and output into a temporary file and then down load the temporary 
file into Excel.
You can use either 'Data Transfer from iSeries'  tool or Excel Add-Ins 
'Client Access Data Transfer'. 

Regards,

S.P. Selvaraj
Senior I.T. Specialist, Asia Pacific
Tel. Dir (65) 6586-8009, Mobile (65) 9653-4048, IP Phone 4368

The information contained in this message, and any attachments, are or may 
be privileged and/or confidential and protected from disclosure and may 
also be covered by the Electronic Communications Privacy Act, 18 U.S.C. 
2510-2521. If the recipient of this message is not the intended recipient 
or authorized to receive this information for the addressee, you are 
hereby notified that any dissemination, distribution or copying of this 
communication is strictly prohibited. If you have received this 
communication in error please delete it from your computer immediately. 



atul beedu <a_beedu@xxxxxxxxx> 
Sent by: mapics-l-bounces@xxxxxxxxxxxx
07/21/2005 04:27 AM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


To
mapics-l@xxxxxxxxxxxx
cc

Subject
INVENTORY HISTORY FILES EXPORT TO EXCEL






Is there any way to export Inventory transaction
history files from mapics to excel?.I have exported
the imhist and itembal files out but not been able to
export the inv trans hist for a partcular components. 
i want to push these files into a Foxpro database.
Uptil now i am exporting them from the mapics browser
to excel, this is not effecient while dealing with
many components, i hope to automate this.

Any help would be greatly appreciated.

regards

Atul Beedu 


 
____________________________________________________
Start your day with Yahoo! - make it your home page 
http://www.yahoo.com/r/hs 
 
_______________________________________________
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.



As an Amazon Associate we earn from qualifying purchases.

This thread ...

Replies:

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.