Changing multiple door card formats

Issue

When a card format needs to be changed on multiple doors it can take a long time to go to each door individually to make card format changes. A way to update multiple doors at one time would save time.

Product Line

Andover Continuum

Environment

  • Continuum
  • Windows XP
  • Windows 7
  • Windows Vista
  • Windows Server 2003
  • Windows Server 2008

Cause

Editing every single door on a large access site to change the card format can take a long time.

Resolution

Before making any changes to the database, it is recommended to get a good database backup.

The card format attribute is available in the All_Doors listview, but is not available in the set attribute drop down, so unfortunately this method cannot be used. 

One way to make the change to multiple doors is to do the following:

  1. Edit the All_Doors listview and add the card format attribute
  2. Highlight the doors that you would like to change and select Object> export all or selected to a .csv (name and save the file) 
  3. Edit the .csv file to reflect the new card format for all the doors and save the file. (Textpad editor works well)
    The card format numbers are listed below:
    Inf 37=1
    AC4+4= 2
    Wiegand26=4
    CK34=8
    Custom=16
    G31 bit=32
    HIDCorp1000=64
    * If you have more than one card format selected on the door, they are added together Ex. Infinity 37 and HIDCorp1000=65
  4. Import the edited .scv file and verify the changes have been made.

It is recommended to verify this procedure on a small subset of the doors to ensure the process is working as needed before applying it to a large number of doors.