Our client, an international law firm, had an existing C.CURE 800 access control system that required migration into their new C.CURE 9000 system, which had been provisioned as part of a new building project. The scope of work for this project included the extraction and cleansing of personnel credentials.
Strategy/process taken during the project
QCIC undertook a cleansing analysis exercise, to establish a set of cleansing criteria for the extracted personnel database. The following data cleansing criteria were identified: disabled personnel records, disabled cards, invalid card numbers, expired cards, personnel records with empty clearances and duplicate records.
These cleansing criteria were applied to the data and a set of relevant data fields for migration.
The cleansed data from C.CURE 800 was then imported into the C.CURE 9000 system using the following filtration criteria:
- First Name
- Last Name
- Personnel type
- Client contact name
- Department or company
- Person ID
- Professional ID
- PIN number
- Card number
- Expiration date
- Facility code
The personnel database was reduced by 18 544 records, leaving 3 852 records of active personnel.
After the data cleansing, the client was able to migrate a clean and up-to-date personnel database from the legacy access control system to C.CURE 9000.
The migration went smoothly and was completed on time, allowing a seamless transition into the new building.