Issue with Template Import – Incorrect Interpretation of Decimal Fields - Support and Troubleshooting

Issue with Template Import – Incorrect Interpretation of Decimal Fields Issue: While importing data using templates, decimal values are being incorrectly interpreted due to mismatched locale settings. Specifically, the system is misreading decimal and grouping separators, causing data corruption or unexpected formatting.

Root cause:

The issue arises from the system's current locale configuration controlled by the glide.system.locale property.

In this case, the instance is configured with the Italian locale ( it.IT ), where:

Decimal Separator = , Grouping Separator = . However, the incoming data uses:

Decimal Separator = . Grouping Separator = , This mismatch causes the platform to interpret numbers incorrectly during import operations.

How to Validate:

Run the following script in the background scripts module to verify the current locale separators:

var locale = GlideLocale.get(); gs.print("DecimalSeparator = " + locale.getDecimalSeparator()); gs.print("GroupingSeparator = " + locale.getGroupingSeparator());

Expected Output for it.IT Locale:

*** Script: DecimalSeparator = , *** Script: GroupingSeparator = .

Solution: To resolve this issue, you have two options:

Option 1: Modify the Locale Setting

Change the glide.system.locale system property to a locale that matches the format of your incoming data (e.g., en.US for decimal . and grouping , ). Navigate to: System Properties > System Locale Set: glide.system.locale = en.US Option 2: Pre-process the Data

Modify the incoming data to match the current system locale settings. Replace all , used as grouping separators with . if you are retaining the it.IT locale. Additional Notes: Changing the locale may have broader UI and formatting implications across the instance. Review and test in lower environments before implementing changes in production.