Keyfax - Dataview Menu Table [dbm_synchronize]
Database Management Table: [dbm_synchronize]
The dbm_synchronize table contains SQL statements used to update the Dataview database information tables with CSV data exported from another data source.
This contains SQL statements which are used for both the initial upload of data, and the subsequent weekly synchronisation of data.
The following list represents the table fields (columns) their data-type and brief usage instructions/description:
| Field Name | Data Type | Usage |
|---|---|---|
| ID | int (identity) | Unique ID: is used internally and is not updatable from the application. |
| ImportFileID | smallint | Associates Filename specified in the dbm_importfiles.ImportFileID, indicating the CSV file to be used in SQL INSERT and UPDATE statements. |
| SQLcount | nvarchar(255) | SQL statement used in initial upload function. If this statementd returns > 0 then initial INSERT for that table will not proceed. |
| SQLinitial | ntext | SQL statement used in the Keyfax "LKupload.exe" application's initial upload function. If SQLcount returns 0 then this INSERT statement will be used for all CSV records in associated file. Statement contains values in the following format: [n] where the 'n' represents the CSV record field to substitute in the SQL INSERT statement. |
| SQLselect | ntext | SQL statement used in the Keyfax "LKupload.exe" application's synchronization function. If SQLselect returns 1 then the SQLupdate statement will be used to modify existing data, otherwise the SQLinsert will insert a new record from the CSV data. Statement contains WHERE values in the following format: [n] where the 'n' represents the CSV record field to substitute in the SQL statement's WHERE clause value. |
| SQLinsert | ntext | SQL statement used in the Keyfax "LKupload.exe" application's synchronization function. If SQLcount returns 0 then this INSERT statement will be used for the current CSV record in associated file. Statement contains values in the following format: [n] where the 'n' represents the CSV record field to substitute in the SQL INSERT statement. |
| SQLupdate | ntext | SQL statement used in the Keyfax "LKupload.exe" application's synchronization function. If SQLselect returns 1 then this UPDATE statement will be used to modify existing data from the current record from the CSV data. Statement contains WHERE values in the following format: [n] where the 'n' represents the CSV record field to substitute in the SQL statement's WHERE clause value. |