Almyta Systems Homepage
Forum Home Forum HomeSBS and AID Software packagesUser Interface and Navigation
  New Posts New Posts RSS Feed - Data import question
  FAQ FAQ  Forum Search   Register Register  Login Login

This site is dedicated to Almyta Systems Inventory Software

Data import question

 Post Reply Post Reply
Author
Message
John K View Drop Down
Newbie
Newbie


Joined: 31 Aug 2011
Points: 2
Post Options Post Options   Thanks (0) Thanks(0)   Quote John K Quote  Post ReplyReply Direct Link To This Post Topic: Data import question
    Posted: 31 Aug 2011 at 11:12pm
When importing data - same record with updated field - will system overwrite existing field or I need do deleteit first from the sytem??
Back to Top
BillD View Drop Down
Senior Member
Senior Member


Joined: 01 Jul 2011
Location: Nevada, US
Points: 474
Post Options Post Options   Thanks (0) Thanks(0)   Quote BillD Quote  Post ReplyReply Direct Link To This Post Posted: 01 Sep 2011 at 6:24pm

In Imports, a key field gets matched against existing records. If key is found then record gets modified. Otherwise, a new record with the key is appended. A key is a unique column in a table. For Inventory Item Master is is the Item ID. For orders, it is an order number. If key is found, all fields supplied in a current import will be modified. For the orders, only headers are modified, but line items are deleted and re-imported from scratch. It means the for orders, line items must contain all information, but not just a few columns that we need to adjust. Also orders marked as shipped cannot be overwritten.

Back to Top
 Post Reply Post Reply
  Share Topic   

Forum Jump Forum Permissions View Drop Down

Forum Software by Web Wiz Forums® version 10
Copyright ©2001-2011 Web Wiz Ltd.

This page was generated in 0.125 seconds.