Data Import Settings

Data Source and Destination

Use these options to select a spreadsheet that contains records to be imported and the destination for these items in SBM.

Note: The administrator performing the import operation must have privileges to submit items into the selected table or project (for primary items).

Spreadsheet
Browse to a spreadsheet that is formatted based on the specifications in Preparing a Spreadsheet for Importing Data.
Import into table
The list contains tables that the importing user has privileges to submit items into and that is configured to allow imports. For on-premise systems, this setting can be found on the Advanced tab of the Edit Table dialog box in SBM System Administrator.

Select the primary or auxiliary table into which data will be imported.
Project
If you select a primary table, you must also select a project into which items will be imported.
Note: The Allow new items to be submitted option must be selected on the General page for the project you select. In addition, you must have privileges to submit items into the selected project.

Duplicates

Optionally, select a spreadsheet column to detect and handle duplicate records in the spreadsheet and the selected project or auxiliary table. If you do not specify a column for duplicate detection, new records are added for every row in the spreadsheet.

Detection is based on identical values in the spreadsheet row and the SBM field. For guidance, refer to Record Matching.

The following duplication detection options are available:

Spreadsheet column for duplicate detection
Select the spreadsheet column that should be used for duplicate detection. Values in the column's row are matched with values in SBM fields.
If matching record exists in SBM database:
- Do Not Modify
  Select this option to ignore duplicate items in the spreadsheet and leave existing SBM items intact.
- Replace Mapped Attributes
  Update mapped fields in existing SBM items based on data in the spreadsheet.

Notification E-mail Options

Use these options to send a copy of the import log file by e-mail when the import process completes and to send e-mail messages to newly imported users.

The Notification Server must be configured and running to send import logs and new user confirmations. On-premise customers use SBM Configurator to manage the Notification Server. The Notification Server is enabled in on-demand systems.

Change these options as needed:

Send notification e-mail when import completes
This check box is selected by default. Clear it to stop the import log from being sent by e-mail.
E-mail
By default, the user logged into SBM Application Administrator when the import process is started is sent the log message. Change the e-mail address as needed. To send the log to multiple addresses, separate each address with a comma.

Field Mapping

Use the Field Mapping section to map spreadsheet columns to SBM fields. You can save field mappings for specific tables and reuse them for additional imports and updates. For guidelines, refer to Field Mapping Considerations.

Field Mapping
This drop-down list stores field mappings saved for the selected import table. This enables you to quickly perform additional imports or update existing data. Saved field mappings can be used by any administrator who has privileges to submit and update items into the table selected for the field map.
Use the options to manage field mappings:
- Set default values for empty cells
  Select this check box to use default values for cells that do not contain data. If a default value is not set for the mapped field, the field value is empty after the import is complete.
- Save ()
  Select this icon to save field mappings.
- Clear
  Select to clear existing mappings and create new field mappings.
- Delete ()
  Select this icon to delete a field mapping.
- Parse multiple values in a cell
  Select this option to have the data import split the cell value into multiple values using the value separator of your choice. This enables you to import multiple values into Multi-Selection, Multi-User, Multi-Group, and Multi-Relational fields.
- Use value separator
  Used in combination with the Parse multiple values in a cell option. Specify the character that is used in your spreadsheet to distinguish multiple values in a cell. For example, enter a comma if your selections are in a comma-separated list (Val 1, Val 2, Val 3), or use the pipe symbol (|) if commas are used in the values that you want to import.
Spreadsheet Columns
- Column
  Lists the information from the first row of the spreadsheet. This is considered a header row used for mapping and data in this row is never imported as a data record.
- Sample Data
  Lists information from the second row of the spreadsheet. Data in this row is provided to assist you with mapping and is also imported as a primary or auxiliary item.
- SBM Field
  As you map fields, this column shows the SBM field mapped to the spreadsheet column.
Mapping Options
- Auto Map
  Click this button to automatically map similar columns in the spreadsheet to SBM fields. Matching is based on a case-insensitive comparison of the spreadsheet column header and the field name.
- Map
  To map fields individually, select a spreadsheet column and an SBM field, and then click Map.
- Unmap
  To individually unmap fields, select a spreadsheet column and an SBM field, and then click Unmap.
- Unmap All
  Click this button to remove all field mappings.
SBM Fields
- Search
  Search for fields by display name. Searches are case-insensitive.
- Field Name
  Indicates the display name for the SBM.
- Type
  Indicates the type of SBM field.