DoorKing Remote Account Manager - Manual (Page 68)

5.6 Exporting / Importing Database Files
DoorKing’s Remote Account Manager software has import / export functions that can be used to get resident
data into and out of the DoorKing database. Transactions can also be exported with this feature. The Export
function exports the database in the popular CVS (comma separated values) file format. This file format is easily
read by many common spreadsheet programs, such as Microsoft Excel.
The import function recognizes two file formats. One format is CSV that many spreadsheet programs, such as
Microsoft Excel, can generate. This makes it very easy to import data into a DoorKing Account from a
spreadsheet. The other import format is only intended for users
who have in house programmers.
5.6.1 Exporting Data
1. From the FILE pull down menu, click EXPORT. The
export window will appear (Fig 65).
2. Create a file name being sure to include the extension
.CSV. This file will be saved in the current DoorKing
folder, or you can save it in any folder on your hard drive
that you choose. In this example, the file will be saved
in the DoorKing32 folder with the file name
DKEXPORT.CSV.
3. Check the account that you want to export data for.
4. Click OK or cancel. Once the export file has been
created, the activity status window will display and
advise if your export was successful (Fig 66).
Figure 65
The file will automatically load into the excel spreadsheet when
you open it from excel (be sure to select “all files” in the file type).
Note the extra ACCOUNT column (Fig 70). This has the account
name in this column. If another account had been included in the
export file from the Export Now screen, you would have seen that
account name in the account column with resident data next to it.
Also note the VENDOR column. This simply has an ‘N’ if this line
is a resident, or a ‘Y’ if this line is a vendor. Note also that the ‘T’
column did not export. This is because the ‘type’ of device is
determined by the Device Enable screen on the System Info
screen. It’s not data that the user types in or exports or imports.
Figure 66
Figure 67
Page 68 1835-066-N-7-13