567 views

Import Set Transform is formatting numeric data with a comma 



Description


When an import is run from a data source, an integer field is wrongly formatted with a comma.

For example, if an SQL data source contains a five-digit asset number, such as 12345, it becomes 12, 345 when transformed into the ServiceNow configuration management databases (CMDB).

 

Solution


Automatic number formatting can be disabled on a per field basis by adding an attribute to the field's dictionary entry: format=none.

For additional information, refer to Dictionary Attributes in the ServiceNow product documentation.

Article Information

Last Updated:2016-10-26 07:55:05
Published:2013-07-31