Managing User Data between Two Ingress Database
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.
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.
Related Articles
Troubleshooting Guide - Unable to Download User Data from AWDMS into Ingress Software
Introduction Since we have introduced new Face ID5 devices, there is a certain issue expressed by clients when they are managing their system and user data on the Ingress software and AWDMS program. One of these issues is that they cannot download ...Migrate Data from TCMSv2 to Ingress
Introduction Setting up of a new system can be cumbersome when it involves a lot of staff, departments, different working hours and conditions, and other variables. In view of this, FingerTec has created a wizard that can migrate database from TCMSv2 ...6 Things You Need to Know about Ingress MySQL Database
Introduction If you have some or absolutely no idea about MySQL database and how it works with Ingress, this is the right article for you to explore. It is well understood that by now there are countless articles written about MySQL database, and ...How to connect Ingress software using the MySQL database from another location
Introduction Within many organization, a server PC is normally restricted to data storage while accessibility is only allowed for just a few personnels. For situations such as these, you can alleviate the problem by connecting Ingress software from ...How to Merge Two User IDs in TCMS V3/Ingress Without Losing the Transaction Logs
Introduction Sometimes an Admin would mistakenly add another user ID for an employee staff who has already have a user ID. And, when the Admin wants to correct the situation, the user ID has already existed in the software. Worse, both User IDs have ...