Project Description
A simple Dynamics CRM multi-language solution that provides both a Country entity and an Option Set following the ISO 3166-1 specification.

Overview

The PMDCI’s Country/Region Solution for Dynamics CRM is a simple Dynamics CRM solution that provides both a Country entity and an Option Set (i.e.: a drop-down) listing all countries and regions identified by the ISO 3166-1 specification.

By default, Dynamics CRM provides a text field to hold country/region information. This can result in a lot of inconsistencies such as misspellings, alternative names or user interpretation, particularly in multilingual deployments.

Features

  • Country/Region global option set: The option set (aka drop-down) includes all countries, dependent territories, and special areas of geographical interest specified in the ISO 3166-1 standard. Rather than having random number as values for the entries in the option set, the value for each entry is set to match the ISO numeric code specified in the standard, which helps with the integration between Dynamics CRM and other systems.
  • Country/Region entity: The entity has been designed to support multi-language systems. Combined with the use of JScripts included in the solution, Dynamics CRM can show the localised country/region name based on the language pack being used.
  • Useful JScripts: The solution includes some useful JScripts for both the entity and the global option set, such as scripts to localise the values of a country/region entity lookup based on the user's language settings. For the option set, scripts include a state/province validation sample, and a function to parse the label of the selected option into the default country/region text field.

Data Included

The country/region global option set includes the ISO 3166-1 numeric values along with the English labels by default, whilst the country/region entity does not include any data. Users can easily import data from Excel worksheets or CSV (comma separated value) files into the entity using Dynamics CRM built-in data import functionality.

PMDCI Country/Region List Dataset

The PMDCI Country/Region List Dataset includes a list of codes for all countries, dependent territories, and special areas of geographical interest specified in the ISO 3166-1 standard, along with their coordinates (latitude, longitude) and names in multiple languages.

This dataset is perfect for those looking to add country support for systems such as CRM, ERP and e-commerce websites, as well as data warehouses. By using the data import functionality built-in into Dynamics CRM, users can have add multi-language support for their country/region entity in minutes. Alternatively, the dataset can be used as a source for localising the labels in the country/region global option set.

Languages in this version includes: English, German, French, Italian, Japanese, Lithuanian, Polish, Brazilian Portuguese, Russian and Ukrainian.

The dataset is available for purchase at Scribd for US$29.95.

Last edited Aug 23, 2014 at 2:32 PM by pinnecco, version 9