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
• Office and member information
• Listing information
• Listing characteristics

---

Geographic information

If you 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