Import duplicate record update options for Part

Top  Previous  Next  Print

 

The no charge ImportExport.csv utility provides the ability to import and export part records into and out of AyaNova

 

If you have purchased the Importexport.csv duplicate option license, then you will also have the ability to update existing AyaNova part records with this utility.

 

Only if you have purchased a license for the Importexport.csv duplicate option will the Duplicate import options menu show on the initial drop down list and in the importexport.csv screen

 

duplicateimportoption1   duplicateimportoption2part

 

 

 

1. Select the Duplicate import options menu from either of the two locations as per above.

 

This will open the Import duplicate record update options window

 

duplicateimportoption4

 

2. If you want an existing Part record's Cost field to be updated if an existing AyaNova part record already exists, then set to True. If you want an existing Part record's Retail price field updated, then set to True;  and so on.

 

3. Click on the green OK button OK1 to save any True False settings, and then import your data into AyaNova.

 

ImportParts5

 

A message will display identifying the following:

 

how many new parts were imported (in screenshot above, this is 16)
how many existing parts were updated (in screenshot above, this is 8)
how many parts were not imported because they were exact duplicates having no changes from existing AyaNova parts; or because they did not follow the format rules. (in screenshot above, 344 parts were not imported because they were exact duplicates - no changes from existing).