Populating choice field ("Install status") on printer form using integration hub ETL

Thota Naga Jyo1
Tera Contributor

Hello,

I am using Integrationhub etl for mapping the printer data. I imported the data from excel sheet. In excel sheet, I have a field called state having choices Installed and in stock. Iam mapping this field to "Install status" on cmdb_ci_printer form. But its not populating as its type is integer.

Can anyone help me with this.

2 REPLIES 2

Chetan Mahajan
Kilo Sage
Kilo Sage

Hi @Thota Naga Jyo1 ,

                                        

As you mentioned, the "state" field in your Excel sheet has choices of "Installed" and "In stock," which likely means it's a text field. However, the "Install status" field on the "cmdb_ci_printer" form is an integer field, which means it can only accept numeric values.

To resolve this issue, you'll need to map the "state" field to a corresponding numeric value that matches the choices in your Excel sheet. For example, you could map "Installed" to the value 1 and "In stock" to the value 0.

 

Kindly Mark correct and helpful if applicable

     

how can we map choices