Format-Evaluate Property
Sets the data that is being imported or exported as XML data types or as the standard C/SIDE data types.
Applies To
XMLports
Property Values
C/SIDE Format/Evaluate (default)
XML Format/Evaluate
Remarks
Importing
If the XML document that you want to import contains data that corresponds to the standard C/SIDE data types, use C/SIDE Format/Evaluate (default value). The data is then evaluated before being inserted into the database.
If the XML document that you want to import contains data that uses the standard XML data types, use the XML Format/Evaluate setting. This ensures that the data is evaluated and converted to the C/SIDE data types before being inserted into the database.
If the data that you want to import does not follow either the Standard C/SIDE formats or the XML formats, import the data into a temporary table in text format. You can then use C/AL code to convert the data before inserting it into the database.
Exporting
If you want to export data that uses the standard C/SIDE data types to an XML document and use these data types in the XML document, use C/SIDE Format/Evaluate (default value). The data from the database is then formatted according to the standard rules for C/SIDE data types.
If you want to export data in the standard XML formats to an XML document, use the XML Format/Evaluate setting. This ensures that the data you export from the database is formatted and exported in the standard XML formats.
The following XML Data types require evaluation.
| XML Data Type | Microsoft Dynamics NAV Data Type |
|---|---|
| Decimal Float Double |
Decimal |
| Boolean | Boolean |
| Datetime | DateTime |
| Time | Time |
| Date | Date |
| Integer | Integer |
| Duration | Duration |
This is an XMLport property and therefore applies to all the data that is being streamed. It cannot be applied only to specific fields.
For more information about formatting C/SIDE data types, see Format Property. For more information about evaluating variables, see EVALUATE Function. For more information about using temporary tables, see Temporary Property (XMLports).
See Also
Format Property (XMLports)
EVALUATE Function
Temporary Property (XMLports)