Migrate Talent data from manual CSV to Workday connector
This guide is for Talent EAP customers who have already put data into Talent from their CSV uploads who need to migrate their data to a Workday custom report. This includes mapping their data from CSV fields to the custom report fields, which is important to maintain the existing focus area allocations and other relationships already built with the existing data from CSV.
Configure Workday custom reports to match CSV values
When migrating from manual CSV uploads to Workday Connector HRIS syncs, it's essential that the fields in the Workday custom reports are mapped precisely to the corresponding CSV column headers.
For example, the positionId in the Workday Positions report must match the external id in the Positions CSV, and the workerId in the Workday Workers report must match the external id in the Workers CSV.
This alignment is critical because Talent relies on these unique identifiers to maintain existing relationships, such as focus area allocations and position assignments. If the data does not match, Talent will interpret the migrated records as entirely new entities, which can result in the loss of historical allocations and disrupt the organizational structure. Therefore, ensuring that the data fields are accurately mapped and consistent between the Workday reports and CSV files is key to a smooth and seamless migration process, preserving data integrity and minimizing operational disruptions.
Positions CSV headers to custom report field mappings
It's important that the values for the positionId of the Workday RaaS report match the values for the external id of the CSV so that Focus Area Allocations and Position Ids can be preserved throughout the migration. Otherwise, Talent will treat all the migrated positions as new positions and the Focus Area allocations will be reset.
CSV column | Custom report field |
|---|---|
|
|
| N/A |
|
|
|
|
|
|
|
|
|
|
|
|
| N/A (use |
|
|
|
|
N/A (use |
|
Example Workers CSV to Workday custom report JSON output
CSV | Custom report |
|---|---|
external id,work email,country,job family,level,preferred name,timezone,title,most recent hire date
W-1234,worker@hris.com,USA,Design,Principal,John Doe,GMT-08:00 Pacific Time (Los Angeles),Principal Designer,2025-05-08 | {
"Report_Entry": [
{
"workerId": "W-1234",
"employeeEmailAddresses": "worker@hris.com",
"country": "USA",
"jobFamily": "Design",
"level": "Principal",
"employeeName": "John Doe",
"localTimeZone": "GMT-08:00 Pacific Time (Los Angeles)",
"title": "Principal Designer",
"hireDate": "2025-05-08"
}
]
} |
For next steps to fully configure your Workday setup, follow the documentation linked below in order:
この内容はお役に立ちましたか?