Database Import Shell Properties

Database import shell property accessors are defined when importing data from a generic ODBC database.

Shell.ImportAction()

string (input). Specifies the operation of the data import on the current item. Possible values are add (add a new item) and update (update an existing item).

Shell.ImportCommand()

int (output). Applies a command to the currently running script. Possible values are:

0 (Continue) – The default value, which allows the data import to continue running.
1 (Bypass import Item) – Stops all actions on the current item and moves on to the next item. The current item will not be added or updated if this value is set.
2 (Kill Import) – Stops the data import for all items.

Shell.ImportID()

int (input). ID of the current Import Option Set record.

Shell.ImportLog()

TSLog object (input/output). The TSLog object is a complex object used to log messages into the DBImport log file. The logging levels defined in the TSLog object are minimal, average, and verbose. The message function defined in the TSLog object logs messages directly into the DbImport log using the following syntax:

Message ( Logging Level ( Int ), Message ( String ) )

For example:

var Log = Shell.ImportLog;
Log.Message ( Log.MINIMAL, "Message Logged at Minimal Logging Level" );
Log.Message ( Log.AVERAGE, "Message Logged at Average Logging Level" );
Log.Message ( Log.VERBOSE, "Message Logged at Verbose Logging Level" );

Shell.ImportName()

string (input). Name of the current Import Option Set record.

Shell.Source()

dictionary (key(string), object (DbImportObj) (input).

Key

The key string contains the source column name and optionally the destination (SBM) field ID. Keys that contain only the source column name are unmapped source values available for processing via the script. All mapped keys will use the '.' as a separator followed by the SBM field database name. For example, issuetype.ISSUETYPE, state.STATE, title.TITLE, color.COLOR_SINGLE_SELECTION, issueid.ISSUEID, id.

The following example will iterate through all values contained within the Source Dictionary:

var Source = Shell.Source();
var DbImportObjKey;
var DbImportObj;
for (  DbImportObjKey : Source  ) {
DbImportObj = Source.Item( CStr( DbImportObjKey ) );

Value

DbImportObj. The DbImportObj is a complex scripting object that contains values representing the source database values:

SrcColumn

string. The database column from the source database.

SrcType

integer. The database column type from the source database. The following database data types are supported:

1 SQL_CHAR
2 SQL_NUMERIC
3 SQL_DECIMAL
4 SQL_INTEGER
5 SQL_SMALLINT
6 SQL_FLOAT
7 SQL_REAL
8 SQL_DOUBLE
9 SQL_DATE
10 SQL_TIME
11 SQL_TIMESTAMP
12 SQL_VARCHAR
91 SQL_TYPE_DATE
92 SQL_TYPE_TIME
93 SQL_TYPE_TIMESTAMP
-1 SQL_LONGVARCHAR
-5 SQL_BIGINT
-6 SQL_TINYINT

SrcData

string/integer. The actual data from the source database.

SrcLabel

string. If an "Int" type value maps to a reference table, this string value represents the label from the source database.

DestFldId

integer. If mapped, this value represents the destination (SBM) field ID.

Shell.SourceDb()

AppDB object (input).The source database object.