Skip to main content
InSource Solutions

TN IT120 Setting different Modes for a DBLoad explained

  1. Last updated
  2. Save as PDF

insource logo large.jpg

 

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.

 

DB1.JPG

 

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.

 

DB.JPG

 

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.

:MODE=REPLACE

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.

:MODE=UPDATE
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.
:MODE=ASK
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.
:MODE=IGNORE
The DBLoad import utility ignores the duplicate tag and continues processing the remaining records of the import file.
:MODE=TERMINATE
The DBLoad import operation stops when a duplicate tag is encountered.

:MODE=TEST
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.