fishhead64
Technical User
I exported employees from MiR and opened in Excel.
Each employee has multiple entries, some as many as 4. If I filter by OrgaUnitImportKey, it filters out most of the duplicates, but not all. It leaves some blank records with the same key, assuming for the same employee.
Why does the export have duplicates, when I don't see them in the list?
Additionally, the record with the OrgaUnit, doesn't have the PBX or Extension, and only a couple of the records display the Role when everyone has at least one Role.
We've had issues with duplicate employees and we're trying to clean it up, but the export is actually making it harder as everyone has multiple entries and missing data.
Thanks!
Al Feinberg
MiCollab 9.6.0.105-01
Mitel Standard Linux 11.0.99
OVA 9.4.1.8
MiVoice Business Release level: 9.4
NuPoint Unified Messaging Build: 20.6.0.4.01
Revolutions 2022.2.1
MiCC 9.4.2
MiR 7.0.0-16.0
CCMWeb
PowerPlay
Each employee has multiple entries, some as many as 4. If I filter by OrgaUnitImportKey, it filters out most of the duplicates, but not all. It leaves some blank records with the same key, assuming for the same employee.
Why does the export have duplicates, when I don't see them in the list?
Additionally, the record with the OrgaUnit, doesn't have the PBX or Extension, and only a couple of the records display the Role when everyone has at least one Role.
We've had issues with duplicate employees and we're trying to clean it up, but the export is actually making it harder as everyone has multiple entries and missing data.
Thanks!
Al Feinberg
MiCollab 9.6.0.105-01
Mitel Standard Linux 11.0.99
OVA 9.4.1.8
MiVoice Business Release level: 9.4
NuPoint Unified Messaging Build: 20.6.0.4.01
Revolutions 2022.2.1
MiCC 9.4.2
MiR 7.0.0-16.0
CCMWeb
PowerPlay