apac-jpn-import-postal-codes.md

title	description	author	ms.author	ms.topic	ms.date	ms.custom	ms.reviewer	audience	ms.search.region	ms.search.validFrom	ms.search.form	ms.dyn365.ops.version
Import postal codes for Japan	Learn how to import postal codes for Japan, including outlines and step-by-step processes for preparing the ZIP code files and creating data import projects.	EricWangChen	wangchen	article	11/22/2019		johnmichalak	Application User	Japan	2017-06-30	DirPartyTable	July 2017 update

Import postal codes for Japan

[!include banner]

In Japan, the Japan Postal Office provides a ZIP code file that you can import into Dynamics 365 Finance. This article walks you through the process for importing ZIP/postal codes. This example uses the JPMF demo data company.

Prepare the ZIP code file

1. Download the comma-separated values (CSV) file from the Japan Postal Office home page.

2. Open the file and convert the file encoding from “Shift-JIS” to “UTF-16 LE” (you can use free software such as Notepad++ for Windows to open the source file and convert the encode to UCS-2 LE BOM.)

3. Open the file for editing, and add the following row for the column headings.

   LocalAuthCode,OldZipCode,ZipCode,PrefectureName,KanaCity,KanaStreetName,State,City,StreetName,MoreZipCodeFlag,SmallerAreaFlag,StreetChomeFlag,MoreStreetFlag,UpdateFlag,Reason
   

4. In the file, add zeros before any ZIP code that has fewer than seven digits. ZIP codes that have fewer than seven digits won't be accepted.)

Create a data import project and import the data

1. Go System administration > Workspaces > Data management.
2. Click Import to create an import project.
3. Enter a name, and select ZIP Postal Code Japan as the entity name.
4. Upload the data file.
5. Set the source file format of the importing project to “CSV(Unicode)”.
6. Click Import.
7. Validate the results.

[!INCLUDEfooter-include]