How can i use display value instead of sysid in spreadsheet?

[Kashim Khan]

Hi Community,

My use case:--
I am importing data into the COMPUTER table, but i want if the user selects os is Windows, then the same record should be inserted into Windows Server and i did that. But the problem is when i import data into computer class, If i provide a display value while importing data for the reference field it shows blank , instead of that if i provide sysid then it shows the display value for the same field.
But i want to give display value?

is there any way to fix this problem?

I am attaching a ss for reference... in this picture, there are 3 reference fields.
Manufacturer and assignedto field remains blank while model id gives value because i provide sysid.

Thanks in advance

[Sebas Di Loreto]

@Kashim Khan 

That happens because the field in question is a reference field to another table, so the field actually contains the sys_id of that reference. 

Manufacturer and assigned_to are also reference fields.

[Kashim Khan]

hi @Sebas Di Loreto then how can i use display value instead of sysId ,is there any way?

[Sebas Di Loreto]

You are saying that when you export the records in excel format for example you are getting the sys_id of Model ID. So what you need to do is go to the Model ID table(cmdb_model) and configure the display_name with display=true.

This means that when you call a reference on that table, it will respond (display) with the display_name field.

[jaheerhattiwale]

@Kashim Khan Those are reference fields which show the display value to the user but in backend the sys id will be stored.

You can create a transform map to load the data which can take the display value instead of sys_id, then you can add the logic to convert the display value to sys_id in the field maps of transform map.

That should solve your problem.

Please mark as correct answer if this solves your issue.