Excel Sites sheet

This sheet aims at defining the correspondence between the columns in the Master Data Upload file and the Opinum Data Hub sites.

Have a look at the general structure for a description of the sites sheet.

Site mapping row

The mapping row defines the mapping between Master Data Upload file columns and a sites properties. One and only one mapping cell must contain the string ''_opKey'' to indicate that the corresponding column in Master Data Upload file contains the business key of the site, which will then be used to uniquely retrieve the site among all others. The business key definition gives detailed information about this topic.

Is it possible to map one column to multiple site properties and also multiple columns to a single site property

Here are the site system properties that you can specify in a mapping cell.

This definition tells the MDE to map the content of the column ''POSTAL_CODE'' in the Master Data Upload file to the property ''PostalCode'' of the site and to map the content of the column ''CITY'' to property ''City''.

It is also possible to map a column to one or more Form(s) by specifying ''_opSiteForm.'' followed by a form definition

This definition tells the MDE to map the content of the column ''STORE_RANGE'' in the Master Data Upload file to the site's form ''Master Data.Technical Identifiers.Range'' and to map the content of the column ''STORE_SURFACE'' to the site's form ''Master Data.Technical Identifiers.Surface''.