Bulk Editing Of Representation Maps - Revision history

Vmurrell at 08:36, 12 September 2023

2023-09-12T08:36:20Z

2023-09-07T08:06:11Z

2023-04-14T11:14:36Z

‎Regular Expression Examples

2023-04-14T11:10:56Z

‎Regular Expression Examples

2023-04-14T11:09:26Z

‎Regular Expression Examples

2023-04-14T11:06:13Z

‎Mapped Values

2022-03-15T10:53:11Z

2022-03-15T10:47:01Z

‎Overview

2022-03-15T10:45:13Z

‎Format of Excel Spreadsheet

2022-03-15T10:44:39Z

← Older revision		Revision as of 08:36, 12 September 2023
Line 1:		Line 1:
		+	[[Category:How_To]]
	= 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 within a single Representation Map.		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.

@@ Line 6: / Line 6: @@
 == Format of Excel Spreadsheet ==
-The spreadsheet is split into 3 sections sepaerated by blank rows:
+The spreadsheet is split into 3 sections separated by blank rows:
 [[File:00-Example-Mapping-Excel.png||An example Mapping Spreadsheet]]

@@ Line 30: / Line 30: @@
 * regex::^.*W2.*$ - will match if the input contains "W2" at any point
 * regex::^[0-9]*$ - will match the input if it is numerics only
-* regex::^.*N[0-9].* - will match the input if a capital N is followed by any numeric anywhere in the input
+* regex::^.*W[0-9].* - will match the input if a capital W is followed immediately by any numeric, and this can occur anywhere in the input
 == Loading Excel ==
 Once the Excel file has been succesfully edited, it can be re-submitted via the structure upload service which is found on the front page of the Registry.

@@ Line 25: / Line 25: @@
 [[File:03-Mapping-Substring.png]]
 === Regular Expression Examples ===
-* regex::W2 - states to match if the input is the phrase "W2"
+The following specifies some simple examples of how to use Regular Expressions in an Excel Spreadsheet
-* regex::^W2.* - states to match if the input starts with "W2" but can then be optionally followed by any other characters
+* regex::W2 - will match if the input is the phrase "W2"
-* regex::^.*W2.*$ - states to match if the input contains "W2" at any point
+* regex::^W2.* - will match if the input starts with "W2" but can then be optionally followed by any other characters
-* regex::^[0-9]*$ - states to match the input if it is numerics only
+* regex::^.*W2.*$ - will match if the input contains "W2" at any point
 == Loading Excel ==
 Once the Excel file has been succesfully edited, it can be re-submitted via the structure upload service which is found on the front page of the Registry.

@@ Line 25: / Line 25: @@
 [[File:03-Mapping-Substring.png]]
 === Regular Expression Examples ===
 == Loading Excel ==
 Once the Excel file has been succesfully edited, it can be re-submitted via the structure upload service which is found on the front page of the Registry.

← Older revision		Revision as of 10:53, 15 March 2022
Line 26:		Line 26:

	== Loading Excel ==		== Loading Excel ==
−	On the ~~front page of the Registry the modified~~ Excel ~~spreadsheet~~ can be submitted to the Registry.	+	Once the Excel file has been succesfully edited, it can be re-submitted via the structure upload service which is found on the front page of the Registry.

← Older revision		Revision as of 10:47, 15 March 2022
Line 24:		Line 24:
	* A '''Substring Mapping''' is where a substring of the input is used to map to the output. This has the format substr( <start position>, <end position>, <value> ). The following example illustrates how the first 2 characters from "IND" map to the value "KFTB"		* A '''Substring Mapping''' is where a substring of the input is used to map to the output. This has the format substr( <start position>, <end position>, <value> ). The following example illustrates how the first 2 characters from "IND" map to the value "KFTB"
	[[File:03-Mapping-Substring.png]]		[[File:03-Mapping-Substring.png]]
		+
		+	== Loading Excel ==
		+	On the front page of the Registry the modified Excel spreadsheet can be submitted to the Registry.

@@ Line 8: / Line 8: @@
 The spreadsheet is split into 3 sections sepaerated by blank rows:
-[[File:00-Example-Mapping-Excel.png|An example Mapping Spreadsheet]]
+[[File:00-Example-Mapping-Excel.png||An example Mapping Spreadsheet]]
 * 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.

@@ Line 7: / Line 7: @@
 == Format of Excel Spreadsheet ==
 The spreadsheet is split into 3 sections sepaerated by blank rows:
 * 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.
 * The "source to target" statement - this next "block" Rows 13 and 14 describe the format of the Source and Target
 * The mapped values is the final section. The format of this is a little complex so requires explanation.
-[[File:00-Example-Mapping-Excel.png]]