Brief instructions:
1. Load the Mapics offline file with a single fake record
2. Use IBM Client access transfer utility to download the file using
parameters:
Output Device: File
Details/File Type: BIFF3 MS Excel 3
Check Save transfer description (FDF file)
This download will give you an excel file with a single record to use as
template.
3. Paste your data on the downloaded excel file, use the Paste Values
option so you don't copy formats (you need to be careful with data
types, you may have to do some trial an error to make sure you have the
right data type in place)
4. Use the transfer utility to upload the file using the FDF file
description you saved on the download. Be aware that problems with data
formats will give you an error on the upload.
Hope this helps
Regards
Josue Najera
-----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.
midrange.com
