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" <Micklc@xxxxxxxxx>
To: "MAPICS ERP System Discussion" <mapics-l@xxxxxxxxxxxx>
Date: 10/05/2010 10:16 AM
Subject: Re: [MAPICS-L] Loading Offline Files from Excel
Sent by: mapics-l-bounces@xxxxxxxxxxxx
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@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx] On Behalf Of Bob Anderson
Sent: Tuesday, October 05, 2010 11:08 AM
To: MAPICS-L@xxxxxxxxxxxx
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@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.
_______________________________________________
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.
midrange.com
