Specifying Scripts for Generic Data Imports

You can specify a script to run before or after importing data from a generic ODBC database. The process is as follows:

  1. Read or initialize the destination record.
  2. Run the Pre-DbImport script, if defined.
  3. Map fields in the source database to destination fields.
    Note: If a Pre-DbImport script modified a mapped SBM field, the source to destination mapping will not have an effect. The script change takes precedence.
  4. Run the Post-DbImport script, if defined.
  5. If updating existing items, validate any changed items and bypass the update if the Update only if change detected option is enabled.
  6. Add or update the destination record to the SBM database.

The scripts can include common shell properties as well as shell properties specific to the Pre-DbImport and Post-DbImport contexts. For details, refer to the SBM AppScript Reference Guide or the SBM ModScript Reference Guide.

Related Topics

Specifying Constant Field Values for Import

Mapping Generic Referential Field Information

Connecting to the Generic ODBC Import Data Source

Specifying a Generic Data Source Import Table

Specifying a Destination for Data

Specifying Additional Options for Generic Data Imports