Skip to main content

Notifications

Microsoft Dynamics NAV (Archived)

Error while importing data from excel to NAV 2016

Posted on by Microsoft Employee

Hi,

I am setting up a new company in NAV 2016 using rapid start but I need to import master data from NAV 2009. I have exported data from NAV 2009 in excel (.xlsx) format. Now when I try to use the option "import from excel" for a table in the configuration package following error occurred. 

" A DotNet variable has not been instantiated. Attempting to call MapInfo in CodeUnit Config. Excel Exchange: ExtractXMLSchema "

forum.PNG

Anyone know about this error please reply. 
Looking forward towards you.

Thanks,

Bilal Haider

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error while importing data from excel to NAV 2016

    Thanks a lot GURU g. Its really very much helpful for a beginner like me. Thumbs up for you (Y)

  • Verified answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: Error while importing data from excel to NAV 2016

    Hello Bilal,

    Go thru this article DATA MIGRATION IN NAV 2016 FROM NAV 2009

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error while importing data from excel to NAV 2016

    That is so nice of you. Kindly tell me the proper way of exporting for nav 2009 because I think there can be problems in the exported files. And again thanks for your help and support.

  • Verified answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: Error while importing data from excel to NAV 2016

    Okay  fine

    I'll prepare a article and share with you, but it takes some times.

    Here is a sample, you can go yourself.

    > You have to Add a Field "Package Code" in Tables ID - 8613, 8614, 8615, 8616
    And in Table 8613 you have to add code from screen shot.
    package.png
    > In Form 8614 "Migration Overview" you have to add Package Code field.

    > In CodeUint 8611 "Migration Management" you have to update code in Functions:
    ExportSetupDataToExcel
    CreateRecordNodes

    > In XMLPort 8610 "Setup Data Schema" you have to add packageCode like NAV 2016.

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Error while importing data from excel to NAV 2016

    thanks @binesh. But kindly tell me further about the customization in objects. It'll be great.

  • Suggested answer
    Binesh Profile Picture
    Binesh 7,885 on at
    RE: Error while importing data from excel to NAV 2016

    Hello Bilal,

    In NAV 2016 configuration package has been changed.

    Here is a new field added something Package Code

    You need to customize NAV 2009 Objects:

    XMLport 

    8610 Setup Data Schema

    Tables:

    8613 Migration Table
    8614 Migration Record
    8615 Migration Data
    8616 Migration Table Field

    Codeunit:

    8611 Migration Management

    Form:

    8614 Migration Overview

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

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Community AMA December 12th

Join us as we continue to demystify the Dynamics 365 Contact Center

Leaderboard

#1
André Arnaud de Calavon Profile Picture

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

#2
Martin Dráb Profile Picture

Martin Dráb 230,149 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans