MANAGING USER DATA BETWEEN TWO INGRESS DATABASE

Friday, July 21, 2017 TimeTec 0 Comments

Introduction

In the case of any system, database management or database administrator are some of the important aspects to lookout for in the event of a hardware or software failures. Should any of these failures occur, the major objective is to ensure that there is no loss of data and that the supposed database is still available to the users.

In Ingress system, we provide the option or procedure where you can backup, restore and manage the users’ database. In other words, you can combine, remove or migrate the data from one Ingress system or PC to another Ingress system.

ADVANTAGES
1. If you have two Ingress database file from two different PC, you can combine or transfer information such as Device Info, User data, Door/Access Level Setting, Attendance record or Scheduling from one database to another.

2. You can remove or perform housekeeping for certain modules in Ingress like Device module, User, Door, Access Level, Monitoring all while maintaining the info within other modules.

PROCESS
A - Combining User Data from Two Ingress Database
If you happened to have 2 Ingress database and you want to combine the User Data from both of these databases, you can follow the steps below:

a) Restore the first or main database by heading to Ingress > System Setting > Database Management > Select the database and click Restore.



b) From the second system or PC where you have the second database, go to User module > Export User > select the list of Users that you want to combine with the first database > Field List by following the format of the picture below> Export (Choose either to export in Excel or TXT format).
** Please note that you can view the export format in the sample pictures.





c) To combine the User Data, transfer the Excel or TXT file that you have exported to the main PC or database. Then, User module > Import from File > Excel or TXT file (The system will verify the file format and show Parse Successful) > Match the header with the column >  Next > tick the User > Read. Once you’ve finished, the system will then combine the User Data from the second database into your main Ingress database.





B - Transferring User Data, Attendance Record, Door/Access Level Setting.
If you wish to perform housekeeping on your database, you can follow the steps below in order to manage your database:

a) To remove certain Ingress modules you can go System Setting > Database Configuration > select Initialise Database. Here, you can choose which modules you want to remove from the Ingress software.



b) In the meantime, to transfer certain modules from one database to another; first of all, restore the first or main database by heading to Ingress > System Setting > Database Management > select the database and click Restore.

c) On the second database or PC, you can select which modules to backup by heading to System Setting > Database Configuration > select Backup Option > select Module > Ok > select Backup. Please note: The system will only backup the modules that you have selected.



d) In the main PC, restore the backup database that you have selected in Step c. Once finished, the Ingress system will only capture the modules that you have selected from the second database.