Once data is logged it progresses through a series of steps until it is inserted into thankQ.
There are four steps: Logging, Validating, Updating and Importing.
At the start and end of each step the import record has its Status field updated to represent the current status.
E.g. Validating steps include cleaning data, de-duping, validating and foreign key check.
Data Import |
An Excel file is loaded and configured using a template. |
Scheduled Data Import |
thankQ scans a specified location at a specified time and files will be loaded using a preconfigured configuration. |
Web Sync |
Data is downloaded and logged into import tables. |
ESB |
Data is inserted into import tables. ESB is responsible for creating the import record and setting the status to Logged. |