How to set reference fields when importing data from Excel sheet to Job table[sn_hr_core_job].

[Winny]

Hi,

I have a question. How to set the reference field value?  

Currently I'm using the HRSD. I'm trying to import data from excel sheet and transform it into Job table [sn_hr_core_job].

In the excel sheet i have User column(reference : sys_user) and HR Profile column(reference :sn_hr_core_profile), Position, Department, etc.. . 

The job record has been created. I can import all fields except the HR profile. Since there is no HR profile data in the job,

I cann't make relation between the HR Profile and the job.

Any suggestions!

Thanks

[Musab Rasheed]

Hello,

My suggestion is to ignore entire record if HR profile is not present because since you are creating entries in HR job table so it doesn't make sense to create record if HR profile is not present. For that you can make use of 'Choice action' in transform map and select 'Reject' option. here is brief about choice action

This field is available if the target field is a choice list or reference field. This field specifies what to do if the import set contains a reference or choice value other than those available. Select one of these options:

• create: Create a new choice or record in the reference table.
• ignore: Ignore the new value from the source table.
• reject: Skip the entire row (record) containing the new value and continue to the next row.

Mark my answer as correct if that helps

Regards

[Musab Rasheed]

Hello,

If you are fine with my reply kindly mark my answer as correct and close the thread.

Regards

[Susan Britt]

For the HR Profile field in your transform map, you should be able to map from the User in your file (assuming it's there, since it's mapped in your screenshot) to HR Profile as the target field and referenced value field name "user".  If the User field is already being mapped, it won't let you select it again.  You can then script the HR Profile mapping to read and find the appropriate profile based on the provided user.