DoorKing Remote Account Manager - Manual (Page 71)

Important .CSV information
In the Excel file example on the previous page, you can see that all the columns of DoorKing data were present
and were being maintained in Excel. If other columns of data were in the Excel spread sheet that did not pertain
to the DoorKing database, they would have been ignored. If you’re maintaining all columns of data from Excel or
some other program and always importing all the data and all the columns, that makes this import process fairly
simply. You can choose ‘Initiate’ every time you import, and all the data in the DoorKing account will be replaced
with the data from your import file.
However, you may not want to import all the columns of DoorKing data. Perhaps you have some other
application program where only the data you want to import to the DoorKing database is the name and phone
number. In that case, the initial time you import, only the NAME and PHONE columns would be imported and the
DoorKing import program would generate the directory codes for you. The next time you import, choose the
Update option and new names in the import file would be added to the DoorKing database. You’ll get a message
pointing out the names that are still in the DoorKing database, but no longer in the import file. It would be up to
you at that point to remove them from the DoorKing database. You could at that point enter in device numbers,
etc, into the resident screen. But be careful here. If at some later time you want to import device numbers,
the device numbers that you’ve been maintaining in the DoorKing database will be replaced with the
imported data. Messages will warn you that you’ve not imported this column of data before and this new data
will replace this column of data in the DoorKing database. Just be aware of where you are maintaining what
types of data. If you’ve maintaining device numbers from the DoorKing database, just always maintain them from
there. If you’ve using Excel to maintain all columns of data for DoorKing and whatever other application you’re
using, just keep maintaining it in that fashion.
5.6.3 Main Frame Import
This import process allows the user to import the resident data from a single comma delimited text file rather than
keying in individual residents in the DoorKing Account Manager program. The import file may contain more than
one account. This import file format is non-standard and is intended only for those who have in-house
programmers who can write a program to extract data from a large database and put the data into this
non-standard format. Most users will want to use the CSV – Excel Import that is intended for PC users.
Before the import process can begin, you must set up the account(s) in the DoorKing Remote Account Manager
program in the normal fashion. The account name(s) must match the account name(s) in the import file and is
case sensitive. Details of the import file are described later in this section.
The fields on the System Information screen (see 3.1) that need to be set correctly for the import process are:
System Memory, Num of Digits In Dir Code, Model Number and Transactions. Be careful – the fields
described above depend on the specific phone model and features you bought. You won’t be able to send or
receive data between your PC and your phone system if these fields are not set up correctly.
1835-066-N-7-13 Page 71