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

---

Office and member information

You have access to all Offices that have their OfficeStatus set to Active and their OfficeType set to Realtor Office or Realtor Firm.

You have access to all Members that have their MemberStatus set to Active and their MemberType set to REALTOR Salesperson.

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.).

Office (Bureaux)

Now part of the Office resource.

	Before	After	Comments
A	CODE	OfficeKey
B	FIRME_CODE	AgencyMlsId
C	NOM_LEGAL	OfficeBranchName	See also OfficeFullName
D	NO_CIVIQUE	OfficeStreetNumber	See also OfficeAddress1
E	NOM_RUE	OfficeStreetName	See also OfficeAddress1
F	BUREAU	OfficeAddress2
G	MUNICIPALITE	OfficeCity
H	PROVINCE	OfficeStateOrProvince
I	CODE_POSTAL	OfficePostalCode
J	TELEPHONE_1	OfficePhone
K	POSTE_1	OfficePhoneExt
L	TELEPHONE_2	OtherPhones(OtherPhoneType = Second).OtherPhoneNumber	Using the $expand operator
M	POSTE_2	OtherPhones(OtherPhoneType = Second).OtherPhoneExt	Using the $expand operator
N	TELEPHONE_FAX	OfficeFax
O	COURRIEL	OfficeEmail
P	SITE_WEB	OfficeSocialMedia(SocialMediaType = Website).SocialMediaUrlOrId	Using the $expand operator
Q	DIRECTEUR_CODE	OfficeManagerKey	The value may be different from what you currently have.
R	URL_LOGO_BUREAU	Media(MediaCategory = OfficeLogo).MediaURL	Using the $expand operator

Office (Firmes)

Now part of the Office resource.

	Before	After	Comments
A	CODE	OfficeKey
B	NOM_LEGAL	OfficeName	See also OfficeFullName
C	NO_CERTIFICAT	OfficeCorporateLicense
D	TYPE_CERTIFICAT	OfficeCorporateLicenseType
E	BANNIERE_CODE	FranchiseAffiliation
F	FIRME_PRINCIPALE	MainOfficeKey
G	COURTIER_CODE	OfficeBrokerKey	The value may be different from what you currently have.

Member (Membres)

Now part of the Member resource.

	Before	After	Comments
A	CODE	MemberKey	The value may be different from what you currently have.
B	BUR_CODE	OfficeKey
C	NO_CERTIFICAT	MemberStateLicense
D	TYPE_CERTIFICAT	MemberStateLicenseType
E	NOM	MemberLastName	See also MemberFullName
F	PRENOM	MemberFirstName	See also MemberFullName
G	TITRE_PROFESSIONNEL	JobTitle
H	N/A	N/A
I	TELEPHONE_1	MemberPreferredPhone
J	TELEPHONE_2	MemberOtherPhone(OtherPhoneType = Second).OtherPhoneNumber	Using the $expand operator
K	TELEPHONE_FAX	MemberFax
L	COURRIEL	MemberEmail
M	SITE_WEB	MemberSocialMedia(SocialMediaType = Website).SocialMediaUrlOrId	Using the $expand operator
N	N/A	N/A
O	CODE_LANGUE	MemberPreferredLanguage
P	PHOTO_URL	Media(MediaCategory = Agent Photo).MediaURL	Using the $expand operator
Q	DATE_MODIFICATION	ModificationTimestamp	This date is in UTC.
R	NOM_SOCIETE	MemberCorporation
S	TYPE_SOCIETE_DESC_F	MemberCorporationType	See Lookup.Translations
T	TYPE_SOCIETE_DESC_A	MemberCorporationType	See Lookup.Translations
U	LIEN_VIDEO_F	Media(MediaCategory = Video)	See Translations
V	LIEN_VIDEO_A	Media(MediaCategory = Video)	See Translations
W	PRESENTATION_F	MemberIntroduction	See Translations
X	PRESENTATION_A	MemberIntroduction	See Translations

SocialMedia (Membres Médias Sociaux)

Now part of the SocialMedia resource, also accessible via Member.MemberSocialMedia.

	Before	After	Comments
A	MEMBRE_CODE	ResourceRecordKey	The ResourceName will be Member
B	TYPE_MEDIA_SOCIAL	SocialMediaType
C	LIEN_MEDIA_SOCIAL	SocialMediaUrlOrId