Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics NAV (Archived) / XML Port in NAV 2013 R...
Microsoft Dynamics NAV (Archived)

XML Port in NAV 2013 R2 does not Handle Format Variable Length correctly

(0) ShareShare
ReportReport
Posted on by Theo Stock 191

I have moved an XML Port from NAV 2009 R2 to NAV 2013 R2 and encounter an error when importing a Flat File of Format Variable Text.

The XML Port Properties are:

Format - Variable Text

FieldDelimiter - <">

FieldSeparator - <,>

RecordSeparator  - <<NewLine>>

TableSeparator - <<NewLine><NewLine>>

If my File contains data which includes Field Delimiter Characters ("), then the import fails, e.g.

"Field1 Data","Field 2 Data","Field 3 Data"

But if I remove the Field Delimiters, e.g.

Field1 Data,Field 2 Data,Field 3 Data

..then the import works correctly.

Although this is a work-around, it is obviously a hassle for the NAV customer to first edit the Import files prior to importing.

Please could the XML Port be corrected (or is there a Hotfix for this?)

*This post is locked for comments

  • Theo Stock Profile Picture
    Theo Stock 191 on at
    RE: XML Port in NAV 2013 R2 does not Handle Format Variable Length correctly

    Hi Roberto,

    Thanks for your input.

    I created two other XML Ports from Scratch in NAV 20013 R2:

    a. The first just imported a CSV file with both Field Separators (Commas) and Field Delimiters (Quote), and It imported 100%.

    b. Re-created the XML Port for the specific Customer File Import, and it failed in exactly the same way as the original one.

    I now believe it has to do with the file format, which is unusual, because it has some header rows before it gets into the actual data.

    I hope this is not too detailed for this forum, but here goes:

    The File looks like this (NOTE: two blank rows (NewLine NewLine) either side for Column Caption Row:

    TRIAL BALANCE: 03/2013-10/2013 vs 03/2013-09/2013

    "Ledger","Account Name","Category","Type","Debit","Credit","","Company","Report Per","Comp Per","Abs Diff","Rel Diff"

     

     

    "0001","Fixed Capital","","B",142163362.26,0,"","00102613",142163362.26,139832988.98,2330373.28,1.66654042

    "0012","Equipment","","B",7965,0,"","00102613",7965,7965,0,0

    "0016","Furniture & Fittings","","B",22760,0,"","00102613",22760,22760,0,0

    "2000","Working Ledger Loan Account","","B",956667.27,0,"","00102613",956667.27,960129.44,-3462.17,-.36059409

    It must have something to do with the way I'm Handling the File Header and Caption Rows that is causing it to fail in the new R2 version. Will have to do some experimenting, I think.

    Thanks again for the help.

    Regards,

    Theo

  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at
    RE: XML Port in NAV 2013 R2 does not Handle Format Variable Length correctly

    hi,

    I checked all the knowledge base, there is no hotfix on this topic or functionalities changed by design.

    The xml ports have been recently modified to improve time to import \ export already in the NAV 2013 R1.

    But someone had already reported problems of limiters and management of large files (crash RTC client etc.)

    look at this podt: "XMLPorts and text files"

    www.mibuso.com/.../viewtopic.php

    In your case (to replicate bug if exist):

    > Try to create a new xml port from on NAV 20130 R2 (not migrated from NAV 2009) on demo environment Cronus

    > Then open a support ticket to Microsoft reporting exactly the case, if there is a fix is (​​​​not yet made ​​public) they send it directly.

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

Quick Links

Daivat Vartak – Community Spotlight

We are honored to recognize Daivat Vartak as our March 2025 Community…

Announcing Our 2025 Season 1 Super Users!

A new season of Super Users has arrived, and we are so grateful for the daily…

Kudos to the February Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 292,516 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 231,409 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans