Geo IPs

Abstract

How xDB Data Migration Tool maps Geo IP data from Sitecore 8.x to Sitecore 9.

In Sitecore 8.x, Geo IP data is stored in the MongoDB collection GeoIps.

The following is an example of a Geo IP record:

{
    "_id" : NUUID("850e4c07-a40b-199e-dc75-27a4df79e28b"),
    "_t" : "GeoIpData",
    "AreaCode" : "N/A",
    "BusinessName" : "The Garrison",
    "City" : "Birmingham",
    "Country" : "GB",
    "IspName" : "Birmingnet",
    "Latitude" : 52.489471,
    "Longitude" : -1.898575,
    "MetroCode" : "N/A",
    "PostalCode" : "B16",
    "Region" : "A7",
    "Classification" : 0,
    "Status" : 1,
    "Fetched" : ISODate("2018-01-01T10:00:00.000Z")
}

In Sitecore 9, Geo IP data is stored as reference data.

This section describes how Geo IP data is mapped from Sitecore 8.x to 9.

Source object

Document from the GeoIps collection

Reference data object type

Sitecore.Analytics.Model.GeoIpData,Sitecore.Analytics.Model

Field mapping definition

xDB Reference Data Mappings > MongoDB GeoIps Document to xDB Geo IP Data

Value to write to reference data object

Property on reference data object

AreaCode from source object

AreaCode

BusinessName from source object

BusinessName

City from source object

City

Classification from source object

Classification

Country from source object

Country

Fetched from source object

Fetched

_id from source object

Id

IspName from source object

IspName

MetroCode from source object

MetroCode

PostalCode from source object

PostalCode

Region from source object

Region

Status from source object

Status