Selecting the type of records to import

iBase can import data from a number of different sources. The first step in creating an import specification is identifying the structure and location of data that will be added to records.

  1. Select File > Data > Import.
  2. Select the type of record that will be created.
    Each import specification can import data for single entity type or a link type and two supported link ends. Specify whether the data corresponds to Entities or Links, and select the type of record to create.
  3. Optional: Select the options that apply to your import:
    • Bulk Import - For SQL Server databases that have been activated for bulk import, you can specify that the import specification is intended for bulk import. In addition, you can select Do not perform safety checks before importing to prevent verification of the number of records in the database that would be updated by the import.
    • Validate imported 'Selected from Code List' values - If you want to verify that the values in the source data are valid for the code lists in the current database. Invalid values are reported as errors during an import.
    • Do not update existing field values with blank values - If you want to prevent blank fields in the source data from overwriting fields in existing iBase records that contain data, turn on this option. This option applies where the action on discovering a match with existing data is Modify Record.
  4. Select the type of file that contains the data: