ExecuteImportTableData

Overview

Use this method to update a table when this can be done from a query using defined rules.
Audit records for these updates will be marked as external.
It uses the same functionality as the Import Table Data screen.

Visit the Import Table Data → Data File page and check that the query you create meets those requirements or the job will fail.
See User Defined Queries for instructions on writing queries for the Scheduler.

Process Page

Update the output format of a query

Add or remove report queue recipients

Parameters

These are the different parameter settings that you can set up on the Scheduler / Job tab

Parameter	Description	[table]field
Query ID	Lookup or enter the Query ID you want to use for this import. The query description is shown below.	[gb_scheduler_jobs]parameters [gb_queries]query_id [gb_queries]description
Module	Select the module that the table you want to import belongs to. E.g. [fm_contracts] will be in 'fm - Fleet Management'	[gb_scheduler_jobs]parameters
Table	Select the table you want to import. Some tables cannot be imported.	[gb_scheduler_jobs]parameters
Error If No Data	Un-checked by default. If the query returns no data when the job is run, no email will be sent, and the queue message will be blank. If checked, an email will be sent.	[gb_scheduler_jobs]parameters
Validate	Checked by default. Checks the linked query data to ensure its correct before the actual table import. Uncheck the checkbox to skip validation for long running but consistent jobs. Access to Super users only. [gb_scheduler_jobs]parameters	[gb_scheduler_jobs]parameters
Mail
Send Mail	This field is checked by default. Un-check this if you don't want to receive any emails about this job.
Sender	The stored sender will be used to create the required audit records. We recommend creating and using a user called 'scheduler'. The audit records are marked as 'X' (external).
Recipients
Recipient	Nominate a recipient to monitor this job.
Attachment Required	If checked, your email will contain an attachment that details the number of records updated in the selected table by this job when it has run. If un-checked, the email will not contain an attachment. This check box is ignored if running the job generates an Error Report. Your email will contain the Error Report as the attachment. If this happens, check the query you are using is correct and update it.

Validations and Alerts

Alert	Comments
Save
Type is required	Missing recipients and type from the scheduler
Invalid Query ID	Missing or invalid Query id
Import
Nothing to update	Duplicated file import
There was no data to import	Missing rows in the table

Messages

The messages below are shown on Scheduler / Schedule as "Last Message" and also on Scheduler / Queue as "Message".

Message	Comments
Completed
There was no data to import.	The query ran, but no records were returned.
The import has completed successfully. 1 record(s) updated OK	The number of records shown will match the number of records created or updated when the job ran.
The import has completed successfully. 0 record(s) updated. Nothing to update.	The query ran and returned records, but the data matches your table, so no updates were required.
Data validation has failed as follows: 0 record(s) found, 0 records failed to validate
Failed
Data validation has failed as follows: {count} record...	If this message is shown, an Error Report will be attached to your email. The job remains active, but you will need to review and update the query.

Support Notes

If a job like this fails, run the query in Workbench and then upload it via the Import Table Data screen.

Use the Error Report as the first step in diagnosing issues.