Last updated on SEPTEMBER 06, 2016

Applies to:

Goal

How do you enter worker details for localizations while loading bulk data using spreadsheet loader?
Is the "Create Worker" spreadsheet designed for loading bulk data using spreadsheet loader?

When the spreadsheet is downloaded, it contains many legislative specific columns as listed below, but no instruction on what information those columns map to. Are there any instructions available for mapping application values to these columns? How does the user know what values the columns should hold?

Steps to get the Create Worker spreadsheet:

1. Navigator > Workforce Management - Data Exchange
2. Select Initiate Data Load task
3. Select the Create Worker Create Spreadsheet icon.

Spreadsheet will contain something similar to the following columns that are related to localizations:

Region 1
Region 2
Region 3

Person Legislative Information 1
Person Legislative Information 2
...
Person Legislative Information 10
Person Legislative Information Number 1
Work Relationship Legislative Information Date 1
..
Work Relationship Legislative Information Date 3
Work Relationship Legislative Information 1
...
Work Relationship Legislative Information 6
Contract Legislative Information Number 1
...
Contract Legislative Information Number 4
Contract Legislative Information Date 1
...
Contract Legislative Information Date 3
Contract Legislative Information 1
...
Contract Legislative Information 6
Assignment Legislative Information Number 1
Assignment Legislative Information Date 1
Assignment Legislative Information Date 2
Assignment Legislative Information 1
...
Assignment Legislative Information 6
Assignment Legislative Information Number 2
...
Assignment Legislative Information Number 4

Solution