Skip to main content

Notifications

Announcements

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!
News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Import multiline text ...
Small and medium business | Business Central, N...
Suggested answer

Import multiline text from Xmlport

(0) ShareShare
ReportReport
Posted on by SYLV1G 55

Dear all,

I try to import data into a multiline text field in a table.

I created an XMLport and the text field is populated but I do not have a CR LF after each line as in my source file

.BC-Text.pngxmlport.png8865.File.png

Do you have any idea ?

Thanks in advance

  • Suggested answer
    YUN ZHU Profile Picture
    YUN ZHU 84,424 Super User 2025 Season 1 on at
    RE: Import multiline text from Xmlport

    Hi, How about using TextBuilder.AppendLine([Text]) Method.

    https://docs.microsoft.com/en-us/dynamics365/business-central/dev-itpro/developer/methods-auto/textbuilder/textbuilder-appendline-method

    A simple case for export.

    https://yzhums.com/21942/

    Hope this will help.

    Thanks.

    ZHU

  • SYLV1G Profile Picture
    SYLV1G 55 on at
    RE: Import multiline text from Xmlport

    Hello,

    Thanks for your reply, 

    I changed the input file (replace CR and LF by a String [CRLF] because we generated it from another software) and I was able to read the file .

    I replaced the string by CR and LF before to write the String in Business Central

  • Suggested answer
    Inge M. Bruvik Profile Picture
    Inge M. Bruvik 1,029 Moderator on at
    RE: Import multiline text from Xmlport

    Maybe the XML port is not the right tool for this.

    I would try to read the file directly into a blob and parse the file directly from the blob.

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

Check out the New Agent Creator Community
Announcing new navigation menus and the Engage with the Community forum!

Quick Links

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
Sohail Ahmed Profile Picture

Sohail Ahmed 1,452

#2
YUN ZHU Profile Picture

YUN ZHU 1,313 Super User 2025 Season 1

#3
Gerardo Rentería García Profile Picture

Gerardo Rentería Ga... 1,083 Most Valuable Professional

Last month Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans