Reverse Engineer DSD from CSV Dataset - Revision history

Vmurrell at 19:03, 26 October 2020

2020-10-26T19:03:51Z

2020-10-26T18:44:04Z

‎Do the Concepts already exits?

2020-10-26T17:53:17Z

‎Reverse Engineer Wizard - Step 2 - Column Assignment

2020-10-26T17:52:49Z

‎Reverse Engineer Wizard - Step 2 - Column Assignment

2020-10-26T17:51:58Z

‎Reverse Engineer Wizard - Step 2 - Column Assignment

2020-10-26T17:40:00Z

‎Do the Codelists already exist?

2020-10-26T17:01:30Z

‎Process

2020-10-26T16:51:52Z

‎Process

2020-10-26T16:39:22Z

2020-10-26T16:24:40Z

← Older revision		Revision as of 19:03, 26 October 2020
Line 81:		Line 81:

	You will be asked to confirm and then you will be taken to the Data Structure page with the newly created DSD highlighted.		You will be asked to confirm and then you will be taken to the Data Structure page with the newly created DSD highlighted.
		+
		+	=Data=
		+	To load, validate or convert a data file against this new Data Structure, all you need to do is to add the Data Structure ID etc in accordance with the rules regarding the file format. [https://wiki.sdmxcloud.org/Category:SdmxDataFormat You can learn more about file formats here.]
		+
		+	If you intend to Publish the data you will need to create a Dataflow and a Provision Agreement. [https://wiki.sdmxcloud.org/Category:Structural_Metadata You can learn more here.]

@@ Line 14: / Line 14: @@
 [[File:RE0.PNG|1000px]]
-==Do the Concepts already exits?==
+==Concept Schemes==
 The RE process includes a step where you can link the concepts to an existing Concept Scheme owned by the same Agency as being used in the RE process. Alternatively, you can ignore this feature in which case the Concept scheme will be created for you.

← Older revision		Revision as of 17:53, 26 October 2020
Line 60:		Line 60:
	Make the appropriate selections for '''EVERY''' column as shown in the example below then click Next to continue.		Make the appropriate selections for '''EVERY''' column as shown in the example below then click Next to continue.

−	Note that if you select an Enumerated type, a codelist will be created.	+	Note that if you select an Enumerated type (Example '''ID'''), a codelist will be created.

@@ Line 56: / Line 56: @@
 [[File:RE1.PNG|1000px]]
 Make the appropriate selections as shown in the example below then click Next to continue.
 Note that if you select an Enumerated type, a codelist will be created.

← Older revision		Revision as of 17:51, 26 October 2020
Line 57:		Line 57:

	Make the appropriate selections as shown in the example below then click Next to continue.		Make the appropriate selections as shown in the example below then click Next to continue.
		+
		+	Note that if you select an Enumerated type, a codelist will be created.

@@ Line 17: / Line 17: @@
 The RE process includes a step where you can link the concepts to an existing Concept Scheme owned by the same Agency as being used in the RE process. Alternatively, you can ignore this feature in which case the Concept scheme will be created for you.
-==Do the Codelists already exist?==
+==Codelists==
-If you decide to use the RE process to create a new concept scheme note that all the concepts will be created in the DSD of type 'Free Text (String)" so if you r intention is to create an enumerated DSD you need to be aware of this.
+If you decide to use the RE process to create a new Concept Scheme, Codelists will also be created for any concepts that you specify thus in Step 2 of the Wizard (see below).
 ==Using an existing Concept Scheme==

@@ Line 49: / Line 49: @@
 ==Reverse Engineer Wizard - Step 2 - Column Assignment==
-This step allows you to define how rach of the columns are to be treated. If you click the down chevron you will see the options available:
+This step allows you to define how each of the columns are to be treated. If you click the down chevron you will see the options available:
@@ Line 62: / Line 62: @@
 Step 3 will display the Concepts that in Step 2, you chose (in this example) "Use Code ID". If you are using an existing Concept Scheme, this step is for information purposes only, however if you are creating a Concept Scheme the settings here will determine the Codelists which will be created along with the Concept Scheme.
 [[File:RE6.PNG|1000px]]

← Older revision		Revision as of 16:51, 26 October 2020
Line 50:		Line 50:

	This step allows you to define how rach of the columns are to be treated. If you click the down chevron you will see the options available:		This step allows you to define how rach of the columns are to be treated. If you click the down chevron you will see the options available:
		+

	[[File:RE1.PNG\|1000px]]		[[File:RE1.PNG\|1000px]]
		+
		+	Make the appropriate selections as shown in the example below then click Next to continue.
		+
		+
		+	[[File:RE5.PNG\|1000px]]
		+
		+	==Reverse Engineer Wizard - Step 3 - Enumerated Columns==
		+
		+	Step 3 will display the Concepts that in Step 2, you chose (in this example) "Use Code ID". If you are using an existing Concept Scheme, this step is for information purposes only, however if you are creating a Concept Scheme the settings here will determine the Codelists which will be created along with the Concept Scheme.
		+
		+	[[File:RE6.PNG\|1000px]]

← Older revision		Revision as of 16:39, 26 October 2020
Line 28:		Line 28:

	=Process=		=Process=
		+	==Reverse Engineer Wizard - Step 1 - High Level Details==
		+
		+	The RE option is available from the Data options, Data Structure, Dataflow and Provision Agreement.
		+
		+	[[File:RE3.PNG\|400px]]
		+
		+	In Step 1 of the Wizard, enter the required ID and Agency together with a suitable name.
		+
		+	If you are using an existing Concept Scheme, it MUST belong to the same Agency and use the same ID. If the Registry does not find an exact match is will create a new concept scheme using the Agency and ID.
		+
		+	If the Concept scheme ID is left blank, the Registry '''will''' create a new Concept Scheme.
		+
		+	Next, select your CSV datafile or drag it onto the panel. If successful a tick will appear as shown in the image below.
		+
		+
		+	[[File:RE4.PNG\|1000px]]
		+
		+	Click Next to continue.
		+
		+	==Reverse Engineer Wizard - Step 2 - Column Assignment==
		+
		+	This step allows you to define how rach of the columns are to be treated. If you click the down chevron you will see the options available:
		+
		+	[[File:RE1.PNG\|1000px]]

@@ Line 1: / Line 1: @@
 [[Category:How_To]]
 =Overview=
-The Registry is able to create a Data Structure Definition from a CSV file which only needs the headings to be used in the DSD. Having created the reverse engineered Data Structure you can validate and transform data.
+The Registry is able to create a Data Structure Definition from a CSV file which only needs the headings to be used in the DSD. Having created the Reverse Engineered Data Structure you can validate and transform data.
 =Preparation=
@@ Line 10: / Line 10: @@
 When done the file should be saved as an Excel CSV file ready to be used in the Reverse Engineer (RE) process.
 ==Do the Concepts already exits?==
@@ Line 19: / Line 22: @@
 ==Using an existing Concept Scheme==
 If you are planning to use an existing concept scheme you will need to be aware of how the concept scheme itself has been created.
 =Process=