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.


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.