Excel Upload file
This file must contains maximum one sheet per Opinum Data Hub entity: site, source and user. All columns defined in the Master Data Template file must exist in the Master Data Upload file but the Master Data Upload file may contain additional columns, which are discarded by the MDE. The sheets in Master Data Upload are all optional: one can provide a single sheet for Sites and no sheet for Sources/Users if the master data is aimed at site management only.
In every Master Data Upload sheet, there could be multiple rows with the same business key, representing different versions/updates of the rows. Any of these sheet may contain additional columns that define rows validity. The supported column headers are:
- START_DATE
- START_TIME
- END_DATE
- END_TIME
The active row is selected as follow (first match applies):
- If any row contains a start date (START_DATE plus optional START_TIME), the elected row is the one having the highest start date.
- If any row contains an end date (END_DATE plus optional END_TIME), the elected row is the one having the highest end date.
- The elected row is the latest one in the sheet (higher row index)
Template included in data file
