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!

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

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?

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.

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.

International Savings

International roaming expense come in a variety of flavors. Similarly, international savings opportunities abound when you know what to look for.

Are your users giving away corporate data?

In her article “Report: Holiday Upgrades Ripe for BYOD Privacy Risks,” Diana Goovaerts at WirelessWeek.com runs down a research study by Blanco Technology Group (BTG).

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.

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.

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.