Re: excel to as400

Pete,

You probably won't like how we handle this at Fleetwood.   We don't allow
people to do this.  If they have a data entry application, they do it on
the iSeries.  Period.  It's such a terrific database handler, and has good
enough reporting tools that we can't come up with a rational reason for why
anyone would do it the other way.

Of course, you do realize that this is this way at Fleetwood due to our
users - and you are familiar with them.   Most of them think a spreadsheet
is something you put on a bed.....  And the good ones prefer to pull the
data from MAPICS (or other apps) and put it into spreadsheets if they want
- they don't go the other way.   They like their green screens and Browser.

Dale Gindlesperger
IT Manager/Special Projects Leader
Fleetwood Folding Trailers, Inc.
258 Beacon Street
Somerset, PA  15501




                                                                           
             Pete Olshavsky                                                
             <polshavsky@yahoo                                             
             .com>                                                      To 
             Sent by:                  mapics-l@xxxxxxxxxxxx               
             mapics-l-bounces@                                          cc 
             midrange.com                                                  
                                                                   Subject 
                                       [MAPICS-L] excel to as400           
             12/13/2005 10:05                                              
             AM                                                            
                                                                           
                                                                           
             Please respond to                                             
             MAPICS ERP System                                             
                Discussion                                                 
             <mapics-l@midrang                                             
                  e.com>                                                   
                                                                           
                                                                           




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.