DoorKing Remote Account Manager - Manual (Page 70)

Below (Fig 70) is the Lakeside.csv file opened with Microsoft Excel. This is the file we imported into the DoorKing
Remote Account Manager program. Note the column headings here. You need to use these column headings so
the DoorKing import program can recognize the data. Notice that it’s not necessary to have a ‘T’ or type column
since the type of device is determined by the Device Enable screen on the System Info screen.
Figure 70
The ACCOUNT column in the Excel spread sheet put all of the residents in the Lakeside Apartments account in
the DoorKing database. Different account names in this column would have directed the data on that line to the
account in the Remote Account Manager program with the same name. The ‘N’ in the VENDOR column of the
Excel spreadsheet made all of the entries residents. A ‘Y’ would make the data on that line a vendor.
HINT: To easily setup the proper columns in the spreadsheet program, create an account in the Remote
Account Manager program and EXPORT it to Excel (5.6.1). You do not need to enter any resident data – just
export the “empty” account. When you open it in the spreadsheet program, the columns will be setup and you
need only to enter the resident data. You can also create columns of your own choice (address, for example).
When importing the file to the DoorKing program, these columns are simply ignored.
The import process checks for errors in the data just as if you were entering them in manually from the resident
screen. If you encounter errors, a message is displayed informing you that error details can be found in the
summary or events.log file by pulling down the file menu in the upper left hand corner. It is important that you
understand the data restrictions for residents. For example, the maximum number of characters in a resident
name is 15 (spaces count as a character), the directory code length, etc.
Page 70 1835-066-N-7-13