Error while importing data from excel to NAV 2016

(0) Share

Report

Posted on by Community Member

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 "

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

Thanks,

Bilal Haider

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (2)

Sort by

Suggested answer

Binesh 7,887 on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
Verified answer

Binesh 7,887 on at

Like (2)

Report
Copy link

Link copied!

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.

> 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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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.

Was this reply helpful? Yes No
Verified answer

Binesh 7,887 on at

Like (1)

Report
Copy link

Link copied!

Hello Bilal,

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

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No