Skip to end of banner
Go to start of banner

Region Post Code Converter

Skip to end of metadata
Go to start of metadata

You are viewing an old version of this page. View the current version.

Compare with Current View Version History

« Previous Version 3 Current »

In order to correctly handle the Zip is not unique for Post place option, we have changed the way of storing post codes and cities in the database.

Previously, a post place was identified by a post code and a country code. This required a post code to be unique to automatically identify a post place. In some countries, a post code is not unique. In this respect, it was decided to enter a post code and a post place in a single string making it impossible to identify the place.

Starting from version 2019.1, to solve the issue, a city is stored in a separate address field labeled as a post place.

In the postcode table, the primary key is expanded with a post place and consists of Country, Post Code, and City.

Functionality

To get started, switch to the Region Editor Module and click Convert Post Codes in the Control group. This causes the Region Post Code Converter dialog to appear:

First, select the country for which you want to convert a post code using one of the methods below:

  • Enter a country code ortype in just part of a word, for example, "br" and you will get all sort of results that include this word. Select a country from the hinted results.

-or-

  • SelectAll countriesif you want to handle all the postcodes in the database.


On selecting, click Load to view all the post codes available for the country(-ies) in the database:

From the Preset drop-down, select the conversion rule based on the data that the current post code and post place may consist of:

  • <Digit Post Code> <whitespaces> <Post Place>is used for numeric post codes and textual post places separated by spaces.
  • <Non-whitespace Post Code> <whitespaces> <Post Place>is used for the post codes composed of any symbols apart from spaces and textual post places. The post code and post place are separated by spaces.
  • <Post Place> <whitespaces> <Digit Post Code>is used for textual post places and numeric post codes separated by spaces.
  • <Digit Post Code with whitespaces> <whitespace> <Post Place>is used for numeric post codes with spaces and textual post places. The data is separated by a space.

You can establish your own conversion rules with the help of regular expressions. Take a chance to familiarize yourself with the regular expressions by clicking the built-in help note .


When defined, the conversion rule becomes available in the Define conversion rule field and the Preview grid displays the suggested conversion data for the new post code and post place. Carefully review all the suggested data and select only those that seem to be correct.

  • To select all the records in the Preview grid, click Tag and select the Tag all option.
  • To clear the selection, click Tag and select the Untag all option.
  • To select all the records with suggested conversion results, click Tag and select Tag non-empty new codes.


After that, click Process to initiate conversion. If the conversion is successful, the system shows the Post code is converted status:

The database is then updated with a new post code and post place.

  • No labels