Table of Contents

Exporting and importing IDs in Workforce Intelligence

In Pega Workforce Intelligence™, administrators can export information, such as data collection users, to a CSV file. 

Export users option
"Export users option"
Export users option

Programs like Microsoft Excel might change the format of your data when you open the exported CSV file. For example, values such as Primary or Alternate ID might include leading zeros that uniquely identify data collectors. If you use Excel to open and manage the exported CSV file, Excel removes leading zeros. Before you submit the file to Pega Support to import back to Workforce Intelligence, it is important to check for this issue and restore all leading zeros.

To restore leading zeros, refer to documentation for the tool you use to manage the exported data. For example, if you use Excel, consult the Keeping leading zeros and large numbers article available from Microsoft Support to resolve this issue.

This issue only applies when you export existing data and open the CSV in Excel. Leading zeros remain in place when you create and edit a CSV file directly in Excel.


Did you find this content helpful?

50% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.