Uploading Extended User Information – Employee Central

[former_member225892]

As Successfactors consultant we come across some situation for which there aren't detailed information available on Web or in documents.  I am Successfactors Employee Central and Payroll Consultant I am came accross such scenario.

This article will help you understand how to upload extended user information in EC. It can save some time; unlike me breaking my head to find a simple thing.

In a recent migration, from legacy system to EC; the employee had some additional information about certification and License. The need arose because the customer is in business of home care service. Due to regulations, every employee needs to have an updated license and certification and they should be able to maintain it themselves.

Standard EC has a functionality to display and maintain the data. However, data for this is not loaded via Import Employee data but via extended user information.  We faced some issue in understanding on how to load the data as there was not much information about it on forums.

 

Some of user personal information like Certificate and Licences can be uploaded in EC and displayed in the Employee portal; for bulk upload, data can be loaded via Import Extended User Information.

 

The template can be downloaded using ‘Download Data Import File Template’

The template once downloaded will look something like this. Delete the unwanted Rows and Cells and create your data file

^UserId	insideWorkExperience	startDate	endDate	title	department
^UserId	outsideWorkExperience	startDate	endDate	startTitle	employer	businessType
^UserId	education	grad	formalcountry	school	degree	major
^UserId	courses	course	institution	instructionType	length	enddate
^UserId	certificates	startDate	endDate	description	licencenumber
^UserId	awards	name	description	institution	issueDate
^UserId	languages	language	speakingProf	readingProf	writingProf
^UserId	funcExperience	experience	years	comments
^UserId	leadExperience	experience	years	people	dollars	comments

 

Data file to look some thing like this

^UserId	certificates	startDate	endDate	description	licencenumber
10000	certificates	07/11/2017	07/11/2018	Driving Licences	1234567
10000	certificates	07/11/2017	07/11/2018	First Aid	Active

 

the second column differentiates the kind of data you are loading for employee within extended information.  Once your file is ready save it in a CSV format and load the same

 

You can either load incremental data or full purge

Incremental – Import by incrementally adding data

Full Purge – Import by re-loading all data with your new changes

Select your file and click on Import Extended User Information.  If your file has any errors that it will display on the same screen after you click on import extended user Data File.

Note that there is no option to validate the data before uploading it.

 

E.g.

1. If your second column does not have any data. In this case, it is ‘certificates’

Section ID missing

2.  If the User id does not exist

Invalid/Unknown user ID

3.  If there is an inconsistency between the start date and end date

Start date cannot be AFTER end date

Once the data is corrected you can load the file and check employee records. It is easy to understand the process and load the data. Hopefully I am been of some help.

 

About me - I am predominantly SAP payroll consultant with some knowledge and experience in EC.  w