How to import the card database directly into WinPro SQL Table and automatically install or delete from the controllers afterward

It will not work properly by just editing the Cards table.

To change the properties of a Card Holder (Add,Update,Delete), you can use the interface table:

1. Edit Server\edotpro.ini:

[Cards]

AutoSQLCardImportInterval=5 //— every 5 seconds check

2. Create Table Int_Card_Import (

Operation_CodeChar(1),

Staff_numberChar(12),

Card_numberChar(6),

NameChar(50),

DepartmentChar(25),

Job_titleChar(25),

MiscChar(20),

PinChar(4),

Access_levelChar(12),

Starting_dateChar(8),

Expiry_dateChar(8)

)

Operation code: ‘A’=Add/Update, ‘D’=Delete

* If the record (staff number) exists, other fields will be updated.

As you can see, the format is similar to standard text based card import format:

A,ABC3345,008765,John Master,Marketing,Executive,,,Acc All,20100101,20151231

The import mechanism will install/delete card from the controllers after importing the card.

______________

Thus, for new staff:

Insert into int_card_import

values(‘A’,’A123′,’012345′,’John’,’Marketing’,’Executive’,”,’0000′,’OfficeOnly’,’20210601′,’20301231′)

for staff resigned on 31 August 2021,

Insert into int_card_import

values(‘A’,’A123′,’012345′,’John’,’Marketing’,’Executive’,”,’0000′,’OfficeOnly’,’20210601′,’20210831′)