TN IT120 Setting different Modes for a DBLoad explained
Setting different Modes for a DBLoad explained
- Author: Alex Davenport
- Published: 04/07/2015
- Applies to: InTouch All Versions
1 When we export the tagname dictionary via DBDump a DB.CSV is created as seen below.
2 Once the DBDump has been edited ready for a DBLoad, if you look at the top left hand corner of the CSV in Cell A1 it contains a mode setting as seen below. This is configurable to allow different ways of initializing a DB Load into an InTouch Application and how this will react.
3 The different Modes are as follows
:MODE=REPLACE, :MODE=UPDATE, :MODE=ASK, :MODE=IGNORE, :MODE=TERMINATE and :MODE=TEST.
These are explained in more detail below.
If a duplicate tag is encountered, the DBLoad utility deletes the existing tag in the Tagname Dictionary and replaces it with the tag from the import file with the same name.
If a duplicate tag is encountered, the DBLoad utility overwrites the existing tag definition in the Tagname Dictionary only with data explicitly specified from the import file. All other data associated with the tag remains unchanged in the Tagname Dictionary.
DBLoad stops when a duplicate tag is encountered while loading the Tagname Dictionary. The Duplicate Name dialog box appears and shows a list of options to handle duplicate tags. This is the default import mode.
The DBLoad import utility ignores the duplicate tag and continues processing the remaining records of the import file.
The DBLoad import operation stops when a duplicate tag is encountered.
DBLoad scans the import file for errors and does not attempt to load tag definitions into the Tagname Dictionary. DBLoad generates a report that identifies any format errors by line number and location in the import file.