Populating choice field ("Install status") on printer form using integration hub ETL
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-27-2023 02:16 AM
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.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-27-2023 02:26 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-27-2023 03:28 AM
how can we map choices