Hierarchies
Hierarchical lists contain records that can have parent and child records. These hierarchical lists can consist of only one field, or of several fields.
Last updated
Hierarchical lists contain records that can have parent and child records. These hierarchical lists can consist of only one field, or of several fields.
Last updated
The CSV file must contain a column header. This can be freely assigned. It is recommended to use meaningful names, as these names will be used later during the mapping. If the column headers in the CSV file correspond to the internal field names in FYLR, the field mapping is done automatically.
Please also check to the general information.
ID | LEVEL 1 | LEVEL 2 | LEVEL 3 |
---|---|---|---|
Alternatively, the data can also be structured as follows. However, it is important that each level appears in its own row in the CSV file (lines 1, 3, 5, 6, 8 must not be omitted):
ID | LEVEL 1 | LEVEL 2 | LEVEL 3 |
---|---|---|---|
In addition, it is possible to import the hierarchies as follows. However, it is important that each level appears in its own line in the CSV file (lines 1, 3, 5, 6, 8 must not be omitted):
In the import mapping, the field "id_parent" must be selected for the column "PARENT RECORD" and the corresponding field for the column "NAME". If your file contains parent records that are not yet available in your database, you have to perform the import twice. In the first step all records are created and in the second import run the links between parent and new child records are created. In that case it is required that in the import settings the "Field for Updates" was selected over which the matching should take place (in our example e.g. "ID").
If you want to export a hierarchical list from FYLR and import it afterwards, you have to select "Hierarchies as Columns" when exporting.
first open the CSV importer
upload your CSV file
select "1st Row" for "CSV Field Names"
select the target object type and the corresponding mask
switch to the tab "Import Mapping" and select the same target field for each column containing hierarchical data and enter the level number (attention: the first level must start with 0)
for all other columns in the CSV also select the corresponding target fields (e.g. for "Comment")
switch back to the "Import Settings" tab and select the "Update Field" if there are already records in the list that should be updated if necessary
click on "Prepare" and you will get an overview of how many rows will be imported or updated
then the actual import / update can be started
ID | PARENT RECORD | NAME |
---|---|---|
ID | LEVEL 1 | LEVEL 2 | COMMENT |
---|---|---|---|
1
Germany
2
Berlin
3
Brandenburg
4
Potsdam
5
United Kingdom
6
Scotland
7
Glasgow
8
England
9
London
10
Brighton
11
Manchester
1
Germany
2
Germany
Berlin
3
Germany
Brandenburg
4
Germany
Brandenburg
Potsdam
5
United Kingdom
6
United Kingdom
Scotland
7
United Kingdom
Scotland
Glasgow
8
United Kingdom
England
9
United Kingdom
England
London
10
United Kingdom
England
Brighton
11
United Kingdom
England
Manchester
1
Germany
2
Germany
Berlin
3
Germany
Brandenburg
4
Brandenburg
Potsdam
5
United Kingdom
6
United Kingdom
Scotland
7
Scotland
Glasgow
8
United Kingdom
England
9
England
London
10
England
Brighton
11
England
Manchester
1
Persons
This category includes, for example, employee photos or photos of events.
2
Buildings
3
Building #1
This building was the former seat of the department XYZ. Currently, the department ABC is located there.
4
Building #2
The building was built in 1986.