RE: excel to as400

Pete,

Excel can edit CSV and tab delimitated files, but the reason my method works 
for me, is that when it comes to uploading the files to the 400, Excel is taken 
out of the equation and the standalone data transfer tools are dealing with a 
very simple file format with no concept of numeric or text data - therefore 
there can be no conflict of what Excel and the FDF believe the data to be. So 
unfortunately, the process would not be as "stream-lined" as you require.

The other option is to try coaxing Excel in to working by manually forcing the 
columns to the data types specified by the 400 and using data validation and 
worksheet protection to prevent people from inadvertently changing them. My 
help here is limited as I usually try the CSV export first.

By coincidence, we do a very similar exercise here, but I created a file on the 
400 and put it into the Browser as an updateable object via Integrator. The 
magic of Browser and Integrator is that once the users have grasped the 
concepts, they can apply the same interface and logic to any file you can add 
into the model.

Feel free to e-mail me directly to continue this off the list.

Regards,
Alan Bell
IT Leader
Munster Simms Engineering Ltd.
P: +44 (0)28 9127 6519
F: +44 (0)28 9146 6421
M: +44 (0)7710 815276
E: alanb@xxxxxxxxxxxxxx <mailto:alanb@xxxxxxxxxxxxxx>

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Pete Olshavsky
Sent: 13 December 2005 17:37
To: MAPICS ERP System Discussion
Subject: RE: [MAPICS-L] excel to as400


Alan, By doing this does this allow users to key data into the spreadsheet.  Or 
do you have them change the extension from csv to xls and then you change it 
back before you load back to the 400
   
  Maybe I should clarify what we are trying to do. We are creating a spread 
sheet with sales history. Then we are asking reps to contact customer and ask 
what the are forecasting for the coming year. The reps enter this data on 
spreadsheet. We then want to get this info back on the 400 and do some 
programming type stuff..
   
  Eventually this function of loading to excel and getting data back to 400 
will be turned over to a non-programming person (We Hope). So I would like this 
to be painless as possible..
  Click on the data transfers that I have created and it just runs.
   
   
  Thanks for all the responses.
   
  Pete
  
Alan Bell <AlanB@xxxxxxxxxxxxxx> wrote:
  Hi Pete,

I export the data to CSV or tab delimitated files for transferring to and from 
the 400, this gets around the problem of Excel reformatting fields which appear 
numeric but should really be text (our component parts are, for example 
"755.50", so this happens frequently). If the problem is the users incorrectly 
entering the data, Excel has functions for data validation and worksheet 
protection that may help you, search for them in the help files.

Regards,
Regards,
Alan Bell
IT Leader
Munster Simms Engineering Ltd.
P: +44 (0)28 9127 6519
F: +44 (0)28 9146 6421
M: +44 (0)7710 815276
E: alanb@xxxxxxxxxxxxxx 

-----Original Message-----
From: mapics-l-bounces@xxxxxxxxxxxx
[mailto:mapics-l-bounces@xxxxxxxxxxxx]On Behalf Of Pete Olshavsky
Sent: 13 December 2005 15:05
To: mapics-l@xxxxxxxxxxxx
Subject: [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,
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.

  

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