User Profile Data Loader Field Reference

Use the table below to help you correctly format the user profile data you want to import via the User Profile Data Loader.

To import user profile data, your user role must have unrestricted access to the User Profile Data Loader feature in System Roles (Manage Features > User Manager Features).

To import user group data and review previous imports, go to Manage Center > Users > User Profile Data Loader.

Table: User Profile Data Loader Field Reference

Field	Content	Data Handling
Action	Control action (either add or delete	Must be one of the following: AR (Add Relocation Interest Information) AE (Add Education Record) AW (Add Work History Record) AL (Add Language Skills Record) DR (Delete Relocation Information) DE (Delete Education Records matching criteria specified in Education columns, delete all records if no criteria set) DW (Delete Work History Records matching criteria specified in Work History columns, delete all records if no criteria set) DL (Delete Language Skills Records matching criteria specified in Language Skills columns, delete all records if no criteria set) Add actions import only the data related to the type of information being added. For example, the data loader imports only Education History data for a row with Action AE.
UserID	LMS User ID	A unique ID that conforms to the LMS ID constraints (Max field length: 85 characters). Mandatory field.
Relocation Willingness	Willingness to Relocate	Y, N or blank (Not specified).
Desired Location	Desired Relocation Location	Any text (Max field length: 250).
Financial Assistance Needed	Relocation Financial Assistance Required	Y or N.
Relocation Reason	Relocation Reason	Any text.
Education - Start Date	Education Start Date	Must be in dd-MMM-yyyy or dd-MMM-yy format, for example, 20-Jun-2021 or 20-Jun-21. A string of NONE implies no specified date. Where only two digits are specified for the year, the date will be interpreted as belonging in a range beginning 80 years before the current date, and ending 20 years after. For example, for an import performed on 20 June 2021, a value of 20-Jun-40 would be interpreted as denoting a date in the year 2040 (that is, 19 years after the import date), while a value of 20-Jun-42 would be interpreted as denoting a date in the year 1942 (that is, 79 years before the import date). Mandatory if Action = AE.
Education - End Date	Education End Date	Must be in dd-MMM-yyyy or dd-MMM-yy format, for example, 20-Jun-2021 or 20-Jun-21. A string of NONE implies no specified date. Where only two digits are specified for the year, the date will be interpreted as belonging in a range beginning 80 years before the current date, and ending 20 years after. Mandatory if Action = AE and Present Education = N.
Education - Present	Whether the education record is present	Y or N. Education End Date is mandatory is N is entered.
Education - Institution	Institution Name	Any text (Max field length: 250). Mandatory if Action = AE.
Education - Degree	Degree	Any text (Max field length: 250). Mandatory if Action = AE.
Education - Field of Study	Field Of Study	Any text (Max field length: 250). Mandatory if Action = AE.
Education - Location	Institution Location	Any text (Max field length: 250)
Work - Start Date	Work Start Date	Must be in dd-MMM-yyyy or dd-MMM-yy format, for example, 20-Jun-2021 or 20-Jun-21. A string of NONE implies no specified date. Where only two digits are specified for the year, the date will be interpreted as belonging in a range beginning 80 years before the current date, and ending 20 years after. For example, for an import performed on 20 June 2021, a value of 20-Jun-40 would be interpreted as denoting a date in the year 2040 (that is, 19 years after the import date), while a value of 20-Jun-42 would be interpreted as denoting a date in the year 1942 (that is, 79 years before the import date). Mandatory if Action = AW.
Work - End Date	Work End Date	Must be in dd-MMM-yyyy or dd-MMM-yy format, for example, 20-Jun-2021 or 20-Jun-21. A string of NONE implies no specified date. Where only two digits are specified for the year, the date will be interpreted as belonging in a range beginning 80 years before the current date, and ending 20 years after. Mandatory if Action = AW and Present Work = N.
Work - Present	Whether the work record is present	Y or N. Work End Date is mandatory is N is entered.
Work - Job Title	Job Title	Any text (Max field length: 250). Mandatory if Action = AW.
Work - Company Name	Company Name	Any text (Max field length: 250). Mandatory if Action = AW.
Work - Employment Status	Employment Status	F (Full-time), P (Part-time), or I (Intern). Mandatory if Action = AW.
Work - Key Achievements	Key Achievements	Any text.
Work - Awards	Awards	Any text.
Work - Location	Work Location	Any text (Max field length: 250). Mandatory if Action = AW.
Language	Language	Any text (Max field length: 250). Mandatory if Action = AL.
Read	Read Level	One of: 1 (Native) 2 (Fluent) 3 (Intermediate) 4 (Elementary) 5 (Not Specified)
Write	Write Level	One of: 1 (Native) 2 (Fluent) 3 (Intermediate) 4 (Elementary) 5 (Not Specified)
Speak	Speak Level	One of: 1 (Native) 2 (Fluent) 3 (Intermediate) 4 (Elementary) 5 (Not Specified)

Additional Information

Import User Profile Data

About the User Profile Data Loader