ExamGecko
Search Search Login
Home Home / Microsoft / MB-820
Question list
Search
Search

List of questions

Search
Open VPLUS File
Convert VPLUS to PDF

Related questions

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?
You need to allow debugging in an extension to view the source code. In which file should you specify the value of the allowDebugging property?
A company plans to meet new regulatory requirements. The regulator has issued new tax tiers. You need to update the base application table by using a table extension. Which table field property can you change?
HOTSPOT You need to create the Install codeunit that is requited in the extension used for installing or updating the Housekeeping app. Which data type or declaration should you use? To answer, select the appropriate options in the answer area. NOTE; Each correct selection is worth one point.
DRAG DROP A company has the following custom permission set: You need to make the permission set visible on the Permission Sets page. Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: More than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
You ate creating a view for a Business Central app. The view requires a custom layout that displays only customer records with a balance greater than 500 in local currency. You need to configure the view to specify that it has a custom layout. Which property combination should you use?
DRAG DROP You need to implement the Issue Management module and expose the Postlssue method. Which four actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order. NOTE: Note than one order of answer choices is correct. You will receive credit for any of the correct orders you select.
HOTSPOT A company uses Business Central. The company is generating a detailed custom report. A user observes that the generated report dataset contains more Delivery Line records than expected for one specific Delivery Header. You need to generate a report that contains the accurate number of records. For each of the following statements, select Yes if the statement is true. Otherwise, select No. NOTE: Each correct selection is worth one point.
HOTSPOT You create a procedure to check if a purchase order has lines. The procedure returns false for purchase order PO-00001 even though it has purchase lines. You need to fix the code to get the correct result. For each of the following statements, select Yes if the statement is true Otherwise, select No. NOTE- Each correct selection is worth one point.
HOTSPOT You need to parse the API JSON response and retrieve each order no. in the response body. How should you complete the code segment? To answer select the appropriate options in the answer area. NOTE: Each correct selection is worth one point.

Question 95 - MB-820 discussion

Report
Export

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?

A.

Change the Direction property to Both

Answers
A.

Change the Direction property to Both

B.

Change the FormatEvaluate property to Legacy.

Answers
B.

Change the FormatEvaluate property to Legacy.

C.

Change the XmlVeisionNo property to 1.1.

Answers
C.

Change the XmlVeisionNo property to 1.1.

D.

Fill the FileName property with the Items.csv value.

Answers
D.

Fill the FileName property with the Items.csv value.

E.

Change the Format property to VariableText.

Answers
E.

Change the Format property to VariableText.

Suggested answer: E

Explanation:

XMLport Overview In Microsoft Dynamics 365 Business Central, XMLports are used for importing and exporting data in XML, CSV, or other text formats. By default, XMLports are designed to work with XML data, but they can also handle delimited text formats like CSV (Comma-Separated Values).

Requirement Clarification The requirement is to change the export format from XML to CSV. CSV is a text-based format, not an XML format. To accommodate this, you need to change how the XMLport handles data during export.

Properties of XMLport

The Format property in XMLports controls whether the output format is XML or a text-based format such as CSV.

The VariableText option of the Format property specifies that the data should be exported in a variable text format, like CSV.

The XMLports default to an XML format, but by setting the Format property to VariableText, you can change the export to CSV format or another text-delimited format.

Explanation of Correct Answer (E) To switch from XML to CSV export:

You need to change the Format property of the XMLport to VariableText.

The VariableText option allows for the export of data in a non-XML format, which is precisely what CSV represents (a comma-delimited text file).

Why Other Options Are Incorrect

Option A (Change the Direction property to Both): The Direction property controls whether the XMLport is used for Import, Export, or Both (import and export), but it does not affect the file format (XML vs. CSV). Hence, this is irrelevant to the file format change.

Option B (Change the FormatEvaluate property to Legacy): The FormatEvaluate property is not related to changing the export format. It deals with the evaluation of the data format during the processing but doesn't change the format type (XML or CSV).

Option C (Change the XmlVeisionNo property to 1.1): The XmlVersionNo property defines the XML version used for the export (such as 1.0 or 1.1). This only applies to XML exports and does not change the format to CSV.

Option D (Fill the FileName property with Items.csv): While this option would specify the name of the file being exported (i.e., 'Items.csv'), it doesn't control the format of the export itself. The actual format change is controlled by the Format property.

Developer Reference from Microsoft Documentation According to the official Microsoft documentation for XMLports in Business Central, the Format property is critical for determining how data is structured for export. To change the file format from XML to CSV, developers need to set the Format property to VariableText. This allows for export in a text-delimited format, which is ideal for CSV.

XMLport Properties - Format Property

How to: Export Data in Text Format Using XMLports

Show Answer
asked 13/10/2024
Vishal Sahare
44 questions
PreviousPreviousNextNext
User
Your answer:
0 comments
Sorted by

Leave a comment first

ExamGecko

Copyright @2023 ExamGecko | All right reserved

Mail us: [email protected]
About us
Contact us
Twitter X
Facebook
Medium
Convert VPLUS to PDF
Open VPLUS files Easily and Quickly
Privacy Policy
Disclaimer
Terms