Dataload Modifications

This version of FaxAction provides the ability to execute standard or site-defined SQL stored procedures before processing starts, when it completes successfully, or when it fails to complete.

The initial use for this functionality is to load a full set of accounts from the host system and then remove or mark as unusable those that were not loaded. This allows the FaxAction accounts database to be kept in sync with the host system and ensures that accounts that have been removed from or deactivated in the host system cannot be used to create ads within FaxAction.

The following fields have been added to the Dataload Control record in Admin to support this functionality:

·     Pre Proc contains the stored procedure name that is executed prior to the start of processing. This field is not required to contain data and is not validated against the database.

·     Post Proc contains the name of the stored procedure that is executed after the processing has completed successfully. This field is not required to contain data and is not validated against the database.

·     Error Proc is used to specify the name of the stored procedure that is executed if the processing did not complete successfully. This procedure is only executed in the event of a catastrophic failure, such as the inability to process the input file or loss of the connection to the system that the source stored procedure is executing against. Failure to store an individual record due to database constraints (i.e. the ad type in the account is not in the list of available ad types) will not cause this procedure to be executed. This field is not required to contain data and is not validated against the database.

Standard Account Load Stored Procedures

There are three standard stored procedures that are provided for use in loading a full set of accounts from the host system. These stored procedures work together and they must all be used together. The stored procedures are: sp_fa_pre_load_account for Pre Proc; sp_fa_post_load_account for Post Proc; and sp_fa_error_load_account for Error Proc.

When these standard procedures are used, all accounts that were previously loaded from the host system but are not present in the new set of accounts have their Expired flags set. This prevents the accounts from being used to create new ads in FaxAction and authorizes the accounts to be deleted by the standard account deletion processing when it is next run (as long as there are no ads in the database for the account).