Welcome, Guest. Please Login.
05/25/25 at 12:10:58
News:
Home Help Search Login


Pages: 1
Send Topic Print
importing Data changes to existing files (Read 404 times)
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
importing Data changes to existing files
04/30/07 at 09:13:02
 
Not a new subject, just a new question or two, based on the nifty directions in the evoerpwiki....
 
If I am changing data in a field that only exists in MTICMSTR and not in BKICMSTR or BKICLOC (lead time), do I need to Copy all three to the temporary files or can I just do the one that is affected?
 
I would like to change quite a few status codes.  Doing them one part at a time, sometimes I get the message cannot change to (O)bsolete as the part exists on a work order.  The work order is a 2003 order that hasn't been archived yet.  If I change the part to (O) using the data import and there are existing records that prevent it from changing, will the error check catch these?
 
Thanks!
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Lynn_Pantic
Administrator
*****


evolution (n) -
gradual change to a
different form

Posts: 5663
Re: importing Data changes to existing files
Reply #1 - 04/30/07 at 13:54:34
 
If you are certain you are changing a field that only exists in one of the 3 files, then you can copy only that one back.  As for error checking, the import does not test Active Status against order status so you could make something Obsolete via the import that IN-B would not have allowed you to do.
Back to top
 
 

Lynn Pantic
IS Tech Support
lynn@istechsupport.com
Email   IP Logged
cathyh
Active Member
*****


I used to be
indecisive; now I'm
not so sure......

Posts: 1210
Gender: female
Re: importing Data changes to existing files
Reply #2 - 04/30/07 at 15:52:30
 
Thanks, Lynn.  I think I'll wait to archive some work orders before I change the status of those items to obsolete.
Back to top
 
 

Cathy Hamilton
Wing Inflatables, Inc.
EVO-ERP2008.1(20 users) w/IS Tech update 5/25/09 (as of 08/21/09)
Windows 2008 Server/client
Pervasive V10.1
Email WWW   IP Logged
Pages: 1
Send Topic Print