populating data from excelsheet into servicenow table for reference field?

sourav3
Mega Guru

Hi ,

I have table and I need to add data into that table from excel sheet. But I am facing 

issues for reference field? The data for the reference field is not coming from excel 

to servicenow table.

Thanks,

Sourav

3 REPLIES 3

sachin_namjoshi
Kilo Patron
Kilo Patron

You need to provide sys_id in your excel sheet to import data for reference fields.

e.g if you excel contains sys_user reference, then you need to populate user sys_id  in your excel spreadsheet.

 

Regards,

Sachin

Rajesh M1
Giga Guru

Hi Sourav,

 

For populating reference fields through excel you can follow below steps:

 

1. Open the reference field mapping of the transform map

 

find_real_file.png

 

 

2. In the "Reference Value field name" field mention the variable name to which the data in the excel column match.

 

For example if you want to populate user data into an reference field "Assigned to" and the excel sheet has emailids of user then in the "Reference Value field name" we need to mention 'email'. So that the data comparison between excel and email field of user table is established.

 

3. In "Choice action" field there are different options

 

1. CREATE : If the data value from excel sheet is not present in the reference table then create a new record  in the reference table and set the same record to the reference field.

 

2. IGNORE :  If the data value from excel sheet is not present in the reference table, ignores to populate value in the reference field. 

 

3. REJECT:  If the data value from excel sheet is not present in the reference table, it stops the transformation of that entire row of the excel in the target table (i.e., no update/insert action takes place for that row)

 

Mark answer as correct/helpful if it resolves your issue.

 

Regards,

Rajesh M.

Deepak Ingale1
Mega Sage

If your reference field contains display value, system should take care of it.

You need to provide the display value ( i assume it is unique value for your table )

Else, you have to build a logic to identify what value in EXCEL for reference field belongs to what record in ServiceNow in onBefore transform map script.