Internal ID Cards
Here you can monitor ID cards.
Double-click the Card No. field in Employee Files to open the corresponding register.
It includes the following data:
| Card No. |
Displays an internal card ID. |
| ID Code |
Displays a unique manufacturer's ID in hexadecimal format. |
You can enter data in register in one of the following two ways. Enter code numbers and IDs manually or import them from a disc supplied by the manufacturer.
 |
Trying to enter ID cards manually, you have to run the following script:
CREATE TABLE [dbo].[RIS_IDCA] ( -- ID Card table
[CARD_NO] [smallint] NULL , -- Card No. Največ 350. (system limitations)
[CARD_ID] [char] (8) NULL , -- manufacturer's card ID in hexadecimal format. Example: CF00DE78
[LUSER] [char] (30) NULL , -- User who made the last change
[LCHANGE] [smalldatetime] NULL -- Date and time of change
) ON [PRIMARY]
ALTER TABLE [dbo].[RIS_IDCA] ADD
CONSTRAINT [DF_RIS_IDCA_LCHANGE] DEFAULT (getdate()) FOR [LCHANGE]
|
Import
To import cards in register, click 
in wizards menu.
A window is opened where you can set file path of database. 
After selecting a database, click Open to import database. After the operation has completed, you receive a message informing you of how many cards were imported: XXX new entries imported
Then you can open the register and view imported entries:
 |
Having already set the card No for employees and imported the database subsequently, a hexadecimal number is added accordingly.
|