Difference between revisions of "Reverse Engineer DSD from CSV Dataset"
| 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]] | ||
Revision as of 09:39, 26 October 2020
Contents
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.
Preparation
Source data
For this process to work, the first step is to obtain the dataset that you wish to use.
Next, ensure that all unnecessary data is removed and that the individual concepts all appear in the top row with each concept in its own cell.
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?
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?
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.
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
Reverse Engineer Wizard - Step 1 - High Level Details
The RE option is available from the Data options, Data Structure, Dataflow and Provision Agreement.
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.
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:
