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!

Why Telecom Expense Management Matters

VINCENT FRISINA ← Back to blog home The types of costs and expenses we incur directly relate to the products and services our businesses provide. Telecom expense management encompasses the tools and methods used to minimize costs and allocate...

Managing wireless data pools is like playing the Price is Right

Telecom expense management encompasses a huge array of communications tools. One of those tools is wireless data connectivity. Mobile data continues to be a critical aspect in how employees get their jobs done. Determining how much data to buy each month can be a time-consuming and laborious process based on a previous month of billing and usage data. How do you hit a moving target each month to ensure you’re buying just the data you need without going over?

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.

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...

The Politics of Mobility Management

People-pleasing. Job-protecting. Flying under the radar. These probably aren’t phrases you’d expect to use when describing mobility managers, yet these attributes are more prevalent than you’d think.

How confirmation bias alters wireless analysis

Chances are, you’re doing a pretty good job of keeping wireless costs optimized for your customers. That’s why they continue to pay you. That’s good, very good, but our business environment demands that successful vendors provide consistently increasing returns to their customers, or they will be replaced by competitors or alternative approaches. An important aspect of this process, which you may not have considered, is how basic human cognitive biases might be affecting how you conduct your business.

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?

Increase Savings Realization by Sending Email

Visage Mobile has a lot of data about what works, and what doesn’t, when managing wireless programs. One thing that data shows us, over and over again, is the powerful impact email communication has on end-user behavior as it pertains to wireless spending and usage.

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.