Top

Introduction

The Import Settings screen allows you to specify how the CSV files or spreadsheet is to be imported. This screen allows you to perform multiple imports. Each Import Data row defines the import source, import range, destination category, and column mappings. This allows you to import two different parts of the same file to two different categories if needed. By default there will be one Import Data row per CSV file or spreadsheet tab.

Top

Features

The settings are divided into two sections.

Import Data

Each row represents one range of data to be imported into a specific category. Tapping a row brings up either the CSV Data Settings screen or the Spreadsheet Data Settings screen depending on the type of data imported. These screen allow you to configure all the options for that specific data import. Add additional rows as needed to import another range of data into another category. Delete any of the initial rows if you don't wish to import all of the data.

Imported Item Processing

Delete Existing Items

Turn this option ON if you wish to replace all existing items in the chosen category with the items imported from the imported file. If OFF, the new items will be added to the existing items and no existing items will be modified in any way.

Duplicate Values

If you choose not to delete the existing items in the category then you can specify how duplicate items from the imported file are handled. Choose 'Skip Imported Item' to ignore a new item if it is found to be a duplicate. Choose 'Replace Existing Item' to replace the existing with the imported item. If you choose 'Ignore Imported Value' then the duplicate item will be imported but the duplicate value will be removed from the new item.

Duplicate checking is based on any category attributes that have their Unique property turned ON. If no attributes in the category are marked as unique then no duplicate checking is performed on the imported items.