Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MiR - Export employees

Status
Not open for further replies.

fishhead64

Technical User
Apr 25, 2007
110
US
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.

MiR_export_lqyjm2.jpg






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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top