Internal ID Cards
You can use this register to track ID cards.
You can access the register with a double-click in the Card No. field in the header of the Employee Files form.
In the Internal ID cards register are following data:
| Card No. |
The number of the card. |
| ID Code |
The manufacturer's ID code of the card as a hexadecimal number. |
You can fill-in the register in two ways. You can enter the ID code manually or you can import it if the manufacturer has enclosed a database.
 |
If you want to enter cards manually, you are required to run the following script first.
CREATE TABLE [dbo].[RIS_IDCA] ( -- Table of ID cards
[CARD_NO] [smallint] NULL , -- Card number. Maximum 350. (physical restriction of the system)
[CARD_ID] [char] (8) NULL , -- manufacturer's ID code of the card as a hexadecimal number. Example: CF00DE78
[LUSER] [char] (30) NULL , -- The last user who made changes of the record
[LCHANGE] [smalldatetime] NULL -- Date and time of the last changes of the record
) ON [PRIMARY]
ALTER TABLE [dbo].[RIS_IDCA] ADD
CONSTRAINT [DF_RIS_IDCA_LCHANGE] DEFAULT (getdate()) FOR [LCHANGE]
|
Import
To import cards in the register, click the Import option in the 
Wizards menu.
The program will open a special form where you can set the path to the card database.
Once, you have selected the base, click the Open button and the base will be transferred to the register. After the completion of the procedure, a the program will display a message: XXX new entries imported!
After the procedure, check the register which will be filled with imported data.
|
If you have already defined cards to the employees and the base with ID cards is to be imported additionally, the program will assign the hexadecimal numbers to the corresponding cards. |