Overview:
Our software allows users to import XML files into a Word template to create a Data Model. By default, the system determines data types based on the values found within the XML, such as strings, doubles, and datetime formats.
New Feature: XML to JSON Conversion
With the introduction of a new feature flag, users can choose to convert XML data into JSON format during import. This ensures that all imported data field values are treated as strings, regardless of their original format in XML.
How to Enable XML to JSON Conversion:
To enable this feature, an environment variable must be set on the users machine:
- Environment Variable Name: DF_EnableXmlToJsonConversionOnDataModelImport
- Value: True
Once this variable is set, XML imports will automatically convert to JSON format, ensuring that all data values are stored as strings.
Limitations:
- This feature only supports XML files that contain elements. It does not work with XML files that include attributes.
- Data type inference will be disabled, and all values will be imported as strings.
Use Case:
This feature is useful for scenarios where data consistency is critical, and data types should not be inferred automatically from XML values.
For any issues or further assistance, please contact support.