Qdb Import Validation Rules

When importing an AutoCare Qdb (Qualifier Database) file many STEP validation rules are performed. The table below describes each of these validation rules, where the validation check occurs, what happens when a validation fails, and an example of a failed validation message (when applicable). However, it does not detail the file type's data rules per the AutoCare Association. This information can be found at www.autocare.org.

For information on the supported versions, refer to the Supported Versions and Formats topic within this guide here.

Accepted File Extension: .zip

Validation Rule

Occurs

When Validation Fails

Failed Validation Message Example
All tables present Validation state BGP ends in an error triggering the import to enter the Error state. The required table '[Required Table Name]' is missing in the ZIP archive or is empty.
Mandatory values present Validation state BGP ends in an error triggering the import to enter the Error state. Table '[Table Name]' contains a row that misses value for the required column '[Column Name]' at line 3.
Correct number of columns (If last column is optional, then the last column can be missing without affecting validation.) Validation state BGP ends in an error triggering the import to enter the Error state. Table '[Table Name]' contains a row with wrong number of columns at line 2.
Loading of older version Validation state Warning is displayed. Existing version '2015-09-25' is newer that provided '2014-11-28.'
Empty line Validation state Warning is displayed. Table '[Table Name]' contains an empty row at line 3.