# 5. User database

The system ESIM110 allows entering up to 500 users (1000 optional) which will have access to controlling the gates by a phone call, but which cannot make changes to system settings.

NOTE: before entering information in the database it is NECESSARY to press the button Load From Device so that the program can read the entered numbers from device memory. Otherwise when entering new user number to the program and saving it, the program will delete previously entered user numbers from device memory and will start filling it from the beginning. NOTE: to make your changes come into effect in the device you must press the button Save.

# 5.1. Entering information and editing the database

| Database configuration: To review data of the existing database, click button Load From Device. Note: Database can be uploaded only when device is connected to the computer (Click Connect via USB button). To enter new user to the database, click button Add and enter the following information: No. - Sequence number of the user stored in the user database. User Name - User name for the specified telephone number. Length - up to 15 characters. Tel. Number - User telephone number. Output No. - Not active. Scheduler No. - The number of scheduler (referring to Scheduler No., section 7. Scheduler) according to which the specified user phone number is able to control the assigned output (-s). Delete Time - Specified user validation limit according to the set date and time. The user is automatically deleted from database as soon as the set date and time occurs. Ring Counter - Specified user validation limit according to the set quantity of phone calls to ESIM120. The user is automatically deleted from database as soon as the set value of phone calls is depleted. Maximum value is 4294967296. Ring Counter Status - Indicates the quantity of phone calls left for the specified user. To edit the information of the user that is stored in the database click the left mouse button on the data you wish to edit for the specified user. To remove existing user from the list, click on the check-box located in the last column and click Remove Selected button. To clear all data from the list, click button Remove All. To save the configurations to the database, it is necessary to click button Save.

| You can also upload the database from files .csv and .txt by clicking button Load From File. Note: File .csv can be managed or created by Microsoft Office Excel or any similar program. Please write numbers in the file as shown in the example. To save created database to file, click button Save To File. It is recommended to save in .csv format.

NOTE: all user mobile telephone numbers are entered with an international country code (for example: 44 - United Kingdom, 370 - Lithuania and etc.).

# 5.2. User data search

| To check whether a specific telephone number is entered in the database you can enter user number in the field provided in the section Numbers and press the button Find. The system automatically checks the database for the analogous user number. The section Length is used by the program for automatically counting the amount of the digits of the mobile telephone number that is entered to the table. Thus the administrator can see whether the number is entered correctly.