thankQ Help

IMPORT (table)

This table defines a set of data being imported.

IMPORTDUPLICATEMATCHES

Any potentially duplicate records are logged in this table.

IMPORTEXTERNALIDLOOKUP

Any records that have a Configuration ID of “EXTERNAL ID”, will have its ID saved alongside the thankQ ID.

IMPORTPROCESSTIMES

Lists the time it took for an import stage to process along with the database query it ran.

IMPORTRECORDTEMPIDS

Assigns temporary unique identities to new records.

IMPORTSTREETABBREVIATIONS

A list of abbreviations of full street names, for example if an address contains 'Rd' in it it will recognise that this means 'Road'.

IMPORTVALIDATIONERROR

Any validation errors are inserted into this table.