An issue I've seen pop up over the years is where the FDF has an error in 
it's missing one of the format chars.  The below example worked to upload
user entered text & numeric data.  Let's face it certain people are far 
productive using Excel - plus you don't tie-up a MAPICS license for the 

In the example below, the second line has a '1' in it, the signifies it 
includes text and numeric.
Sometimes the '2' is missing, simply edit the file with notepad, add the 
'2', save and run.

PCFT 12          <----------------------   sometimes the '2' is missing, 
PCFO 1,1,1,1,1
PCFL PB1 2 9
PCFL PRICE1 2 14/3
PCFL PB2 2 9
PCFL PRICE2 2 14/3
PCFL PB3 2 9
PCFL PRICE3 2 14/3
PCFL PB4 2 9
PCFL PRICE4 2 14/3
PCFL PB5 2 9
PCFL PRICE5 2 14/3
PCFL PB6 2 9
PCFL PRICE6 2 14/3
PCFL PB7 2 9
PCFL PRICE7 2 14/3
PCFL PB8 2 9
PCFL PRICE8 2 14/3

Pete Olshavsky <polshavsky@xxxxxxxxx> 
Sent by: mapics-l-bounces@xxxxxxxxxxxx
12/13/2005 07:05 AM
Please respond to
MAPICS ERP System Discussion <mapics-l@xxxxxxxxxxxx>


[MAPICS-L] excel to as400

Morning everyone. 
  I am trying to take an excel spreadsheet that I initially created from 
the 400 with data. Some data was keyed inot columns that I provided. When 
I try to transfer the spreadsheets back to the 400 I am getting errors 
that data in this field is incorrect or does not match the PC data type. I 
think what has happened is the users keyed into a flds that they were not 
meant to. I have tried using the data transfer off the client access 
session. I have also tried using the data transfer option on the 
speadsheet itself. Neither works. 
  Hope this makes sense.....
  Is there a way to prevent this??? 
  Thanks in advance...
  Pete Olshavsky
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,
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives

As an Amazon Associate we earn from qualifying purchases.

This thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 by 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.