Microsoft Dynamics NAV (Archived)

Importing Zipcodes into NAV

(0) Share

Report

Posted on by Community Member

Hi,

I am newbie to this system. I need to import the zipcodes (USA and CANADA) into the software.

Any assistance would be helpful.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (0)

Suggested answer

Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

Which Version are you using?

Depending upon the version you can use rapidstart services or dataport/xmlport.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi,

I am using Dynamics NAV 2013 R2.

I used Rapidstart for initial configuration but couldn't see anything which can update the Zipcodes.

Please advise

Thanks

Was this reply helpful? Yes No
Mohana Yadav 61,005 Super User 2025 Season 2 on at

Like (0)

Report

We can create our own configurations and Packages as per our requirements..

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

In 2009 we had to locate a zipcode file, convert it to Excel, and then import it.

In 2013 I imagine it won't be that 'easy'.

In either version, it involves a consultant because after 20 years of NAV, Microsoft still hasn't realized that people use Zipcode information for anything...

Was this reply helpful? Yes No
Suggested answer

gert@lynge.org on at

Like (0)

Report

In Denmark we can get an Excel sheet with ZIP-codes from Post Danmark (the national mail handler).

I only needed to modify this Excel sheet so it contained the same columns as NAV and then I was able to copy/paste it into the page directly in RTC: right click left to the zip-code and choose "insert rows" (if my memory is correct - I was doing it in a Danish NAV, so it was probably not called "insert row" but You'll get the idea :-) ).

This was done i NAV 2013 R2 - quite easy actually.

Made a how-to for our other customers - so they can do it themselves.

Table need to be "empty" or at least not containing any rows with same primary key.

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

Hi,

Thank you for your solutions.

I finally managed to import the zip codes.

In the Role Center / Worksheets I added Zip Code table and imported the Zip Code template with all the zip codes and applied to the database and IT WORKED...

Tested the zip codes in the normal environment and its working fine.

Thanks for your support.

Was this reply helpful? Yes No
charlie111 5 on at

Like (0)

Report

If you have any problems with importing the zip codes try this product: zipcodedownload.com/.../Overview

Saved me a lot of time...

Was this reply helpful? Yes No
Suggested answer

Miguel Llorca Gómez 7,019 User Group Leader on at

Like (1)

Report

With your version you can also copy and paste from Excel. Export first and update Excel with correct ZIP codes, then paste into NAV.

Good luck!!

Was this reply helpful? Yes No