Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics NAV (Archived)

Excel does not contain XML mapping

(1) ShareShare
ReportReport
Posted on by

12744157_5F00_10209264020700449_5F00_6135115115424943707_5F00_n.jpg


I'm trying to import data from excel .

I'm searching for a simple method but i can't found it .

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Excel does not contain XML mapping

    Also all the related tables to the customer should import their related tables this is the solution because when you click to get the related tables dynamics get just the tables that the customer is related to them directly and these tables also have an other table which they conneted to it .

    Now the import works correctly.

  • Suggested answer
    Saurav.Dhyani Profile Picture
    14,314 Super User 2025 Season 1 on at
    RE: Excel does not contain XML mapping

    Yes that is true.

    IN Configuration package, when you select a table say 18.

    In Tables action, From Function Menu you can select the option to load get related tables.

    All related tables to customer will be added automatically to the list.

  • Community Member Profile Picture
    on at
    RE: Excel does not contain XML mapping

    i tested on payment terms which the id table is 3 and the import of data is done .

    so maybe the problem in customer is that the data that i added should be also exist in the relation table first .

  • Suggested answer
    Saurav.Dhyani Profile Picture
    14,314 Super User 2025 Season 1 on at
    RE: Excel does not contain XML mapping

    Hi,

    To me its not clear, do you want to import using configuration worksheet or you want to use Excel Buffer to import data?

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Excel does not contain XML mapping

    yes i fill all required fields . the first thing that i tried is adding a single line in  excel file and the second method i tried to extract all the data that exists in customer and i added a line in the final of the excel file but these 2 methodes don't worked and the same error appears.

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,094 on at
    RE: Excel does not contain XML mapping

    Do you have all required fields filled?

  • Suggested answer
    Community Member Profile Picture
    on at
    RE: Excel does not contain XML mapping

    The first thing that i'm doing is :configuration worksheet->i choose  customer then i export to template -> i fill the excel file -> i selected customer and i click on import from template.

  • Suggested answer
    Alexander Ermakov Profile Picture
    28,094 on at
    RE: Excel does not contain XML mapping

    My best guess is that you are using not a template that should have been exported first and then filled and imported, but you just use some similar template.

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

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics NAV (Archived)

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans