Employee data management with the user import template
Employee Data and Charge-Back Reports
MobilityCentral is most frequently used for generating cost center reports (also known as ‘charge-back reports.’) These reports rely on tying employee wireless expense data to other systems such as HR and accounting.
MobilityCentral makes the charge-back process easy, but HR and accounting systems sometimes complicate matters. When the component parts of an employee’s profile are stored across multiple systems, it’s up to the MobilityCentral administrator to combine disparate employee data sets for use in generating accurate charge-back reports.
In the past, Excel’s vLookup feature was probably your best option in compiling all your user data each month. MobilityCentral’s user import process lets you choose how to import data employee based on how you populate the User Import Template. Let’s look at this in more detail.
Ignore Blank Values
MobilityCentral includes a User Import Template processing option which tells the system to “ignore blank values”. If you select this option when uploading your User Import Template, MobilityCentral will only take action on employee record fields populated with data, ignoring cells which have no data.
For example, if you need to add employee data from the accounting system to employee information already in MobilityCentral, simply copy and paste the accounting data into the User Import Template, select the “Ignore blank values…” option, and upload. Voila!
Use Blanks to Delete Existing Values
This option enables mobility administrators to bulk delete data from fields in MobilityCentral. For example, a company may need to temporarily remove all managers for all its employees during a reorganization. All they need to do is: export the current employee data into the User Import Template, delete the values in the Reporting Manager Email field, and then upload the template using the “Use blanks to delete” option.
Remember, it’s always best to take a backup of any user data before making bulk changes of any kind!
Director, Customer Marketing & Programs
Vincent Frisina has worked for Visage since 2010. He has a Masters in Business Administration from Bellevue University in Nebraska. Having lived in the Cornhusker state since 2008, Vincent has adopted Omaha as home and lives there with his dog, Leia.