Skip to main content

Notifications

Small and medium business | Business Central, N...
Suggested answer

Trying to export 2 datasets in 1 line

(0) ShareShare
ReportReport
Posted on by Microsoft Employee

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:

pastedimage1648141246747v2.png

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?

  • Suggested answer
    Marco Mels Profile Picture
    Marco Mels on at
    RE: Trying to export 2 datasets in 1 line

    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.

    www.yammer.com/dynamicsnavdev

    dynamicsuser.net/.../developers

    I will open this up to the community in case they have something to add.

    Thanks.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

News and Announcements

Announcing Category Subscriptions!

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Verified Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,359 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,370 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans