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

Reference

Format Property (XMLports)
EVALUATE Function
Temporary Property (XMLports)