thankQ Help

•Ensures the Import record has status of “Records Updated” or above. If the status is “Records Updated”, sets Import record to have a status of “Importing”.

•Only runs on records that have an Import Status of “OK to Post”.

•If the record has a deletion flag field and if it is set to “Yes”, mark the record as “Requires Deletion”. This will cause these records to not continue through the rest of the logic in this step.

•Can be turned off for certain Configurations.

•A stored procedure is available per import table.

•If the record does not exist in thankQ, the SQL mandatory fields are inserted, as well as the Created and Created By fields.

•An update is run to update all information in the system. The update will not change the primary key.

•Ensure all business rules are catered for.

•Make sure stats are updated (i.e. fundraising stats).

•If the record has an Archive Record field set, the record is given the Import Status “Requires Archiving”.

•If the import was successful the record’s Import Status is set to “Posted to Live”.