Post

Migration guide - SIIQ 4.2a

Introduction

Before reading this migration guide, make sure to read the Getting Started.

This document is a reference to compare previous data mappings with new ones.


Geographic information

A StateRegion has multiple CityOrTownships which itself has multiple Neighborhoods.

Geographic information is available directly on the properties (e.g. Property.Township) but to get the translations you should use these resources by using Property.CityOrTownshipKey or its matching navigation field Property.CityOrTownship.

If you were receiving files by FTP, you can change the extension of a given file to CSV (e.g. Bureaux.txt to Bureaux.csv) and open it with a software such as Microsoft Excel, you should see matching columns for each field (A, B, C, etc.).

StateRegion (Régions)

Now part of the StateRegion resource.

  Before After Comments
A CODE StateRegionKey  
B NOM_FR StateRegionName  
C NOM_AN StateRegionName  

CityOrTownship (Municipalités)

Now part of the CityOrTownship resource, also accessible via StateRegion.CitiesOrTownships.

  Before After Comments
A CODE CityOrTownshipKey The value may be different from what you currently have.
B DESCRIPTION CityOrTownshipName  
C REGION_CODE StateRegionKey  

Neighborhood (Quartiers)

Now part of the Neighborhood resource, also accessible via CityOrTownship.Neighborhoods.

  Before After Comments
A MUN_CODE CityOrTownshipKey The value may be different from what you currently have.
B CODE NeighborhoodCode  
C DESCRIPTION_FRANCAISE NeighborhoodName See Translations
D DESCRIPTION_ANGLAISE NeighborhoodName See Translations