[dev.icinga.com #13201] Boolean values are not shown in import source preview table

[icinga-migration]

This issue has been migrated from Redmine: https://dev.icinga.com/issues/13201

Created by tobiasvdk on 2016-11-15 12:27:36 +00:00

Assignee: (none)
Status: New
Target Version: (none)
Last Update: 2016-11-25 14:04:02 +00:00 (in Redmine)

---

When I use the property modifier "Convert to a boolean value" this new value is not shown in the "Preview" table. The column is just blank. I would expect to see something like, e.g. "true" / "TRUE" / ... But how do I know if it's a string or a boolean then?

My use case is that I import host states from a CMDB and map them to "true" or "false". Afterwards I need to modify them to a boolean value to be able to set the "disabled" property of a host.

[icinga-migration]

Updated by tobiasvdk on 2016-11-25 12:49:18 +00:00

It looks like converting to boolean FALSE does not work at all. TRUE is disabled as "1" in the table.

[icinga-migration]

Updated by tgelf on 2016-11-25 14:00:07 +00:00

Does this only affect the preview, or also imported (synced) data?

[icinga-migration]

Updated by tobiasvdk on 2016-11-25 14:04:02 +00:00

tgelf wrote:

Does this only affect the preview, or also imported (synced) data?
I just checked the database, also imported data is affected:

> select disabled from icinga_host where object_name = 'my-enabled-host';
+----------+
| disabled |
+----------+
| y        |
+----------+
1 row in set (0.00 sec)