Difference between revisions of "Bulk Editing Of Representation Maps"
Jump to navigation
Jump to search
(Created page with "= Overview = It is possible to export a Representation Map into Excel format, edit it and then load it back in again. This allows for bulk addition or editing of Mappings ==...") |
|||
| Line 1: | Line 1: | ||
= Overview = | = Overview = | ||
| − | It is possible to export a Representation Map into Excel format, edit it and then load it back in again. This allows for bulk addition or editing of Mappings | + | It is possible to export a Representation Map into Excel format, edit it and then load it back in again. This allows for bulk addition or editing of Mappings within a single Representation Map. |
== Exporting Excel == | == Exporting Excel == | ||
| − | On the Representation Maps page, selecting a Representation Map and clicking "Export Excel" will create the Excel spreadsheet. It is recommended to edit an existing map rather than starrting from scratch as the spreadsheet must conform to a specific format | + | On the Representation Maps page, selecting a Representation Map and clicking "Export Excel" will create the Excel spreadsheet. It is recommended to edit an existing map rather than starrting from scratch as the spreadsheet must conform to a specific format. |
== Format of Excel Spreadsheet == | == Format of Excel Spreadsheet == | ||
| + | The spreadsheet is split into 3 sections: | ||
| + | * The "header" - the first 11 rows of the Spreadsheet describe mandatory information regarding the maintainable aspects of the Representation Map. For example, the Agency, ID and version as well as optional values such as Description and Start and End Dates. | ||
| + | * Rows 13 and 14 describe the format of the Source and Target | ||
| + | * From row 16 onwards the mapped values are listed. The format of this is a little unusual, but the source is always in column A and the target always in column C | ||
| + | * A straight mapping of one value to another would have the source listed in column A and the target listed | ||
Revision as of 01:58, 15 March 2022
Overview
It is possible to export a Representation Map into Excel format, edit it and then load it back in again. This allows for bulk addition or editing of Mappings within a single Representation Map.
Exporting Excel
On the Representation Maps page, selecting a Representation Map and clicking "Export Excel" will create the Excel spreadsheet. It is recommended to edit an existing map rather than starrting from scratch as the spreadsheet must conform to a specific format.
Format of Excel Spreadsheet
The spreadsheet is split into 3 sections:
- The "header" - the first 11 rows of the Spreadsheet describe mandatory information regarding the maintainable aspects of the Representation Map. For example, the Agency, ID and version as well as optional values such as Description and Start and End Dates.
- Rows 13 and 14 describe the format of the Source and Target
- From row 16 onwards the mapped values are listed. The format of this is a little unusual, but the source is always in column A and the target always in column C
* A straight mapping of one value to another would have the source listed in column A and the target listed
