Modifying Data By Import

It is possible to modify existing data in Auctria by importing an Excel file that has the key field for the table mapped.

When you import bidders from an Excel file, if you have a bidder# column in your spreadsheet, and you map that column to the bidder# field, then the system will look for a matching bidder# for each row.

If there is a matching bidder in the system then this bidder will be modified with the information from the other mapped columns in the spreadsheet rather than inserting a new bidder.

If the bidder# is blank, or the bidder# does not exist in the system then a new bidder record will be created.

Key Fields

The following tables list the key field for commonly imported tables

Table	Key field
Bidder	Bidder#
Item	Item#
Donor	Name
Item Category	Name

It is not possible to modify exisiting records when importing into the 'winning bid' or payments table.