web
You’re offline. This is a read only version of the page.
close
Skip to main content

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

I have the same question (0)
  • Suggested answer
    Roberto Stefanetti Profile Picture
    Roberto Stefanetti 12,998 on at

    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.

  • Theo Stock Profile Picture
    Theo Stock 191 on at

    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

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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics NAV (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans