Home » Employee data management using the user import template

Employee data management with the user import template

Screenshot of MobilityCentral's user upload screen

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!

How to cancel your CEO’s unused device without getting fired

We’ll give you a couple of strategies to minimize costs before actually going in for the disconnection kill. In fact, these strategies are so successful you may even want to deploy them to others in the company.

Did you budget for…?

Studies have shown that managing to a budget keeps costs down. But we all know that even with the best budget, the unexpected happens.

Mobility program Do’s and Don’ts for COVID-19 response

VINCENT FRISINA Many of our customers are in the midst of transitioning their in-office employees to work remotely due to the COVID-19 pandemic. Here are some of the Do's and Don'ts of deploying a work-from-home workforce as part of your disaster...

Mobile Data is the New Voice

About three years ago, mobile carriers launched wireless plans offering unlimited voice and text but pooled data. We recognized early on that we could stretch the limits of these plans for larger enterprises, and the savings were gargantuan.

Distracted Driving

We all know distracted driving is on the rise, shouldn’t be done and has the potential to be lethal. Yet how many times have you, or someone you’ve seen, read a text message, placed a call or used an app while behind the wheel?

3 of the Most Overlooked Audits

This week, Lisa helps us with overlooked wireless audits based on real data she sees every month in MobilityCentral.

T-Mobile DIGITS Reinvents the Way You Buy Wireless Service….Again

T-Mobile recently opened their DIGITS service to a public beta test. The service allows mobile numbers to be used on multiple devices at the same time, or for a single device to have multiple mobile numbers.

Why Mobility Managers Should Care About “Orange is the New Black”

What’s the number one reason why you should care about the new season of “Orange is the New Black?” Because your USERS care.

Employee data management using the user import template

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.

More and More Data Usage: How Much is Enough?

Larry Treas discusses one of the primary areas of charge-blindness in a mobility program: data usage.