... | @@ -69,14 +69,14 @@ should already be correct and the folders already exist. |
... | @@ -69,14 +69,14 @@ should already be correct and the folders already exist. |
|
If you want to learn more about all settings of HOTMapper, head to our [Settings page in the wiki](../Settings)
|
|
If you want to learn more about all settings of HOTMapper, head to our [Settings page in the wiki](../Settings)
|
|
|
|
|
|
## 3. Creating your table definition
|
|
## 3. Creating your table definition
|
|
The HOTMapper tool uses two files to create a table, a json inside the table_definitions folder and a CSV present on the
|
|
The HOTMapper tool uses two files to create a table, a JSON inside the table_definitions folder and a CSV present on the
|
|
mapping_protocols folder. Both should have as name of the file: "table name + extension". Ex: table_test.json,
|
|
mapping_protocols folder. Both should have as name of the file: "table name + extension". Ex: table_test.json,
|
|
table_test.csv.
|
|
table_test.csv.
|
|
|
|
|
|
The table_definitions json has the objective of storing the table constraints and information about the source of the
|
|
The table_definitions JSON has the objective of storing the table constraints and information about the source of the
|
|
table and it's description.
|
|
table and it's description.
|
|
|
|
|
|
Let's create a json for a table_test:
|
|
Let's create a JSON for a table_test:
|
|
* Go to the table_definitions folder and create a file named table_test.json.
|
|
* Go to the table_definitions folder and create a file named table_test.json.
|
|
* Open the file with your favourite editor and create the base object as shown bellow.
|
|
* Open the file with your favourite editor and create the base object as shown bellow.
|
|
~~~json
|
|
~~~json
|
... | @@ -101,7 +101,7 @@ If you want to learn more about Table Definitions, click [here.](../Table-Defini |
... | @@ -101,7 +101,7 @@ If you want to learn more about Table Definitions, click [here.](../Table-Defini |
|
|
|
|
|
## 4. Creating your mapping protocol
|
|
## 4. Creating your mapping protocol
|
|
The map protocol file is used to store the information about the table columns and to make the link between the data
|
|
The map protocol file is used to store the information about the table columns and to make the link between the data
|
|
from the csv and the database. This file is stored inside the mapping_protocols folder and uses as name the "table name
|
|
from the CSV and the database. This file is stored inside the mapping_protocols folder and uses as name the "table name
|
|
\+ .csv"
|
|
\+ .csv"
|
|
|
|
|
|
This CSV must contain the following columns:
|
|
This CSV must contain the following columns:
|
... | @@ -115,7 +115,7 @@ from the standard one. It has the name of the column in the data csv. |
... | @@ -115,7 +115,7 @@ from the standard one. It has the name of the column in the data csv. |
|
|
|
|
|
Let's create a mapping protocol for the table_test:
|
|
Let's create a mapping protocol for the table_test:
|
|
|
|
|
|
* First create a file named table_test.csv inside the mapping_protocols folder.
|
|
* First create a file named `table_test.csv` inside the mapping_protocols folder.
|
|
* Now, in the row number 1, create the following headers for the columns A-G: Var.Lab, Novo Rótulo, Nome Banco,
|
|
* Now, in the row number 1, create the following headers for the columns A-G: Var.Lab, Novo Rótulo, Nome Banco,
|
|
Tipo de Dado, 2016.
|
|
Tipo de Dado, 2016.
|
|
* If you have any doubt, inside your mapping_protocols folder should have a file named empty_map_protocol.csv
|
|
* If you have any doubt, inside your mapping_protocols folder should have a file named empty_map_protocol.csv
|
... | | ... | |