Unique run identifier

When using BIX, you can provide a unique run identifier for each BIX extraction run to a database or a CSV file, marking additions to both parent and child tables in the database, and parent and child nodes in the CSV file. This enables you to:

  • Easily identify all inserted records for a particular BIX extract run, both in the main table for a class and in subsidiary tables created for page lists, page groups, and value lists in the class.
  • Delete records from a failed BIX run so that an extract can be re-run without producing incorrect or redundant data.

Two fields have been added to the main table for each extracted class in the database, pxExtractDateTime.TIMESTAMP and pxRunIdentifier VARCHAR(255).

The pxExtractDateTime field has also been added to all subsidiary tables for the class in the database.

The value of the pxExtractDateTime field matches the value of pyLastUpdateTime in the table pr_extract_time for the run. This allows you to perform a join action and obtain all of the records inserted for a BIX run.

You can also include a run identifier through the –k command-line option.

BIX can still run in backward compatibility mode for tables without new fields. If the new fields exist in the database, they are filled in by BIX; otherwise, BIX runs in backward compatibility mode.

Note: This functionality is available when you purchase and install the BIX application.