Re: Loading Offline Files from Excel

Bob,

Install the 'Add-in' in excel to connect to the iSeries  (this is part of 
the iseries software).

Once in excel you can get or send data to the iSeries.




The Transfer Data to iSeries is very easy to use,  just define headings on 
your row 1  (this will be your Field Name)  and data in the rest 
of the rows.... then select the cell range and follow the wizard to create 
the physical file.








Notes:
1. Always use check the option to conver to CCSID 65535
2. When you do the 'Scan'  change the fields from 'UNICODE' to 
'CHARACTER'.





Antonio Rojas
Manager Applications Development
Semtech Corp.
Cell.    (805) 216-4651
Office (805) 480-2135




From:   "Chuck Mick" <[email protected]>
To:     "MAPICS ERP System Discussion" <mapics-l-Zwy7GipZuJhWk0Htik3J/[email protected]>
Date:   10/05/2010 10:16 AM
Subject:        Re: [MAPICS-L] Loading Offline Files from Excel
Sent by:        mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]



Bob,

I have used Excel and Access on various occasions to update the XA
offline files...and then run the offline programs within XA.  I believe
you can create an ODBC and update the iSeries offline files directly
from Excel...but I have used Access since I found that easier.

As a starting point - have you looked at the file layouts for the XA
offline file loads? 

If this sounds like what you are looking for -- give me a call or email
directly and I will try to assist. 

Have a great day.


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-Zwy7GipZuJhWk0Htik3J/[email protected]
[mailto:mapics-l-bounces-Zwy7GipZuJhWk0Htik3J/[email protected]] On Behalf Of Bob Anderson
Sent: Tuesday, October 05, 2010 11:08 AM
To: MAPICS-L-Zwy7GipZuJhWk0Htik3J/[email protected]
Subject: [MAPICS-L] Loading Offline Files from Excel

Hello,
                I have a requirement to load some offline data to our
MAPICS system. Currently it is in an Excel 2003 spreadsheet and I need
to get it into a file on the iSeries that I can use to load from.  As I
have never done this before I have no clue on how to proceed.

Could some kind soul out there enlighten me.

Thanks very much in advance

Bob Anderson

IT Manager
Kent Sporting Goods Inc.
433 Park Ave. S
New London OH 44851
419-929-7021 x315
P Please consider the environment before printing this e-mail.

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

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

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