*Import and Export with iProtect™.
- Tom Polman
- Lennert
How To Article | HTA-20220531-LG-24 iProtect Access / Security | How To Articles |  |  |
In iProtect™ it is possible to import bulk data from a csv file into iProtect™.
When using import/export iProtect will only work with 'Employee' because it is using the unique employee_salarynr …
The import/export function can be found at:
General > Import/export > Employee data
To start it is best to make a employee, person and card in iProtect™ and export it. So you will have a good starting point.
Now use the export to get a file to work with.
With the Export button a file (default.txt) will be downloaded. If you open the file in notepad you will see in the first line a lot of names, the most used are explained below. The red highlighted are mandatory.
Columbnames | Explanation | examples |
|---|---|---|
OPERATION | 1=add 2=change 3=remove |
|
EMPLOYEE_SALARYNR
| Unique string |
|
EMPLOYEE_BIRTHDATE | Date of birth | 2010-12-31 00:00:00 |
EMPLOYEE_HIREDATE | Date in service | 2010-12-31 00:00:00 |
EMPLOYEE_TERMINATIONDATE | Date out of service | 2010-12-31 00:00:00 |
EMPLOYEE_LANGUAGE | 1=NL 2=ENG 3=D |
|
PERSON_NAME | Last name |
|
PERSON_FIRSTNAME | Sir name |
|
PERSON_PREFIX | Prefix |
|
PERSON_HOMEADDRESS | Home Address |
|
PERSON_HOMECITY | Home City |
|
PERSON_HOMEZIP | ZIP/Postal code |
|
DEPARTMENT_NAME | Department |
|
ACCESSKEY_ACCESSKEYID | assigned by system, leave empty with import |
|
ACCESSKEY_RCN | Card number |
|
ACCESSKEY_CARDCLASSID | card number presentation ID | KP MAGSTRIPE / RCN 1 |
DEFAULTKEYGROUPCODE | Standard keygroup (max 1 group) |
|
ACCESSKEY_VALID | Valid card | 1=valid 0=invalid |
ACCESSKEY_UNLIMITED | Unlimited valid/invalid | 1=valid 0=invalid |
ACCESSKEY_STARTDATE | Start date card validation | 2010-12-31 00:00:00 |
ACCESSKEY_ENDDATE | End date card validation | 2010-12-31 00:00:00 |
CARDCLASS_CARDCLASSNAME | Name cardcoding |
|
FREESELECT1 / FREESELECT14 | Free selection field |
|
SELECTID1 / SELECTID8 | Free selection field time registration |
|
FREETEXT1 / FREETEXT14 | Free text field |
|
The DEFAULTKEYGROUPCODE can only be inserted initially with the first import for only 1 KEYGROUP. The KEYGROUPCODE refers to the Code manually entered in the keygroup:
ACCESSKEY_CARDCLASSID can only be found when you make an export. Create a new card with the wanted card number presentation and check the export for the corresponding number.
The Employee_salarynr must be a unique string. And note that 01234 is a different number then 1234.
The file in CSV format must be a standard Ascii file. This means that the text must not be formatted, for example in a word processing program such as MsWord.
Fields containing text data must be placed between double quotes. A field may be empty, in which case only a comma will appear.
The import file must contain a header with the field names so that the meaning of the data entered is clear. It is important that the English names are used in this header, such as "personid", "name", "prefix", etc.
When a date or time is entered, the format here is year-month-day (yyyy-mm-dd) and hours:minutes:seconds(hh:mm:ss) respectively.
With this export you can add lines to create, modify or delete items in iProtect™ (cards, persons and employees). Change the operation of a line in 2 (modify) and change the sir name of that person. Import this file and check the name of the person in iProtect™, it should be changed.