Keyfax - Dataview Menu Table [dbm_importfiles]
Database Management Table: [dbm_importfiles]
The dbm_importfiles table contains the filenames of the CSV synchronization files used in a synchronization process.
This is used with the Keyfax "LKupload.exe" application which will request the path to the CSV files to be synchronised.
The following list represents the table fields (columns) their data-type and brief usage instructions/description:
| Field Name | Data Type | Usage |
|---|---|---|
| ImportFileID | int | ID matching the dbm_synchronize.ImportFileID field: used to identify file which contains data to be used in synchronising process. |
| ImportFileName | nvarchar(50) | CSV Filename (without path) containing data exported from Host housing system. |