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

Notifications

Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Small and medium business | Business Central, N... / Data Migration Navisio...
Small and medium business | Business Central, N...
Unanswered

Data Migration Navision 2015 - Language codes to ISO

(0) ShareShare
ReportReport
Posted on by GenericName555 5

Background: I'm doing some preliminary work for migrating Navision 2015 data to Dynamics CE.

objective: i'm writing some tSQL in which i transform some Navision data so it can be integrated in Dynamics CE. For this particular attribute i'm looking to end up with [Languagecode.iso2]-[Countrycode.iso2]

Issue: I can't map the Navision Language codes, it does not seem to be using ISO codes at all. It seems to reference some sort of stand alone windows code for indexing languages.

Question: Can I get some background on this? Where are these country codes coming from? Does anybody have a table in which I can convert these to proper standards? 

Path I took to take this image: Navision 2015 (demo) - Customer card - Foreign Trade - Language code 

screen001.png

I have the same question (0)
  • THE Italian Profile Picture
    THE Italian on at

    You have to involve a NAV experts in such project or you will risk to have wrong data moved into CRM.

    For languages we have a virtual table Language table 8 that you can run it from CSIDE. Same thing for Country/Region table 9 that you can run it from CSIDE.

    Up to you what you want to do with these.

  • GenericName555 Profile Picture
    GenericName555 5 on at

    Dear Duilio Tacconi,

    Thank you for leaving a reply. However, I don't believe you properly understood the question. The idea is to find out where Navision gets it's ISO language/country codes from so we can map them.

    You mention maps in your post from a different source but I could not find a link to any.

    I'm sorry but your answer:

    - Did not give a descriptive background of what is going on, so I cannot continue to fix it

    - The table you said I should have a look at, was not present

    Please update you answer with appropriate information?

    thank you

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

News and Announcements

Sign Up for Ask a Community Pro Today!
Introducing our New Video Series: Community Spotlight

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the December Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Small and medium business | Business Central, NAV, RMS

#1
OussamaSabbouh Profile Picture

OussamaSabbouh 2,202

#2
Dhiren Nagar Profile Picture

Dhiren Nagar 1,210

#3
YUN ZHU Profile Picture

YUN ZHU 1,115 Super User 2025 Season 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans