To change an XMLport export from XML to CSV, set the Format property to VariableText

Design and create an XMLport
Answer Correct answer: E - set the XMLport Format property to VariableText to export delimited CSV text instead of XML.

You have an XMLport that exports items from a database to an XML file. You need to change the export format from XML to CSV. What should you do?

  1. Change the Direction property to Both.
  2. Change the FormatEvaluate property to Legacy.
  3. Change the XmlVersionNo property to 1.1.
  4. Fill the FileName property with the Items.csv value.
  5. Change the Format property to VariableText. Correct Answer

Community Votes

E
100%

100% of anonymous learners picked answer E. Votes are pick records left by other test-takers — they are not the verified answer.

Community Insight

Only the Format property needs to change to switch the output format; the node definitions remain valid for both XML and CSV output. The Direction, XmlVersionNo, and FileName properties do not change the format.

The XMLport Format property controls the serialization format. Setting Format to VariableText produces comma-separated, delimited text (CSV) instead of XML, while keeping the same node structure defined in the XMLport.

Do not change Direction to Both, set FormatEvaluate to Legacy, or change XmlVersionNo, as none of those convert the output to CSV. The FileName property only names the file, not its format.

Community Discussion (4 comments)

z_safar 👍 2
Correct answer is E See https://learn.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/properties/devenv-format-property
AutomateFlo 👍 3 Selected: E
E is correct
edbb578 👍 4 Selected: E
Format = VariableText;
Rahila_Amir 👍 1
I guess the correct answe is E.

Comments & Corrections

No comments yet — spotted an error or have a note? Share it below.

Log in to comment, report an error, or add a note about this question.

Submitted for moderation before publishing. Keep it helpful and respectful.

Expert Analysis

Why the Answer Is Correct

Option E is correct because the XMLport Format property, when set to VariableText, makes the XMLport export delimited CSV text rather than XML. This is the single property that controls the output format. Community voting is unanimously E (100 votes), and edbb578 confirms 'Format = VariableText'.

Why the Other Options Are Wrong

Option A (Direction = Both) controls import/export direction, not the format. Option B (FormatEvaluate = Legacy) relates to evaluable format handling, not XML versus CSV. Option C (XmlVersionNo = 1.1) sets the XML version, and Option D (FileName = Items.csv) only names the output file without changing its format.

Community Comment Notes

z_safar points to the official Format property documentation and AutomateFlo states 'E is correct,' both supporting the answer.

Official Reference

Related Analysis

← Back to MB-820 Study Guide