Announcements
I am trying to export data to a CSV file. In my XMLPort there are two datasets that I am exporting, but I need them to come out on one line. So it should look like this:
xmlport 14135103 "ExportSales" { Caption = 'Export Sales'; Direction = Export; TextEncoding = UTF8; Format = VariableText; FieldDelimiter = '"'; FieldSeparator = ''; schema { textelement(root) { tableelement(SalesInvoiceHeader; "Sales Invoice Header") { XmlName = 'SalesInvoiceHeader'; fieldattribute(Code; SalesInvoiceHeader."No.") { } fieldattribute(PostingDescription; SalesInvoiceHeader."Posting Description") { } fieldattribute(PostingDate; SalesInvoiceHeader."Posting Date") { } fieldattribute(DocumentDate; SalesInvoiceHeader."Document Date") { } } tableelement(SalesInvoiceLine; "Sales Invoice Line") { XmlName = 'SaleInvoiceLine'; fieldattribute(Type; SalesInvoiceLine."Type") { } fieldattribute(Code; SalesInvoiceLine."No.") { } fieldattribute(Description; SalesInvoiceLine."Description") { } fieldattribute(Quantity; SalesInvoiceLine."Quantity") { } fieldattribute(UnitPrice; SalesInvoiceLine."Unit Price") { } fieldattribute(Amount; SalesInvoiceLine."Amount") { } } } } }
Above is the code I have. Does anyone know how to achieve this?
Hello,
We currently do not have dedicated Dev support via the Dynamics 365 Business Central forums, but I wanted to provide you some additional resources to assist. If you need assistance with debugging or coding I would recommend discussing this on one of our communities.
dynamicsuser.net/.../developers
I will open this up to the community in case they have something to add.
Thanks.
André Arnaud de Cal... 291,359 Super User 2024 Season 2
Martin Dráb 230,370 Most Valuable Professional
nmaenpaa 101,156