Import of hierarchical lists

Hierarchical lists contain entries that can have parent and child entries. These lists can consist of only one field, or multiple fields. The CSV file must contain a column header. This can be freely assigned. It is recommended to use meaningful names, because these names will be used later during mapping. If the column headers in the CSV file correspond to the internal field names in easydb, the field mapping is done automatically.

Please also note the general notes.

Example file “Places

Alternatively, the data can be structured as follows. However, it is important that each level appears in a separate line in the CSV file (lines 1, 3, 5, 6, 8 must not be omitted):

In addition, it is possible to import the hierarchies by referring to the respective parent entry. However, it is important that each level appears in a separate line in the CSV file (lines 1, 3, 5, 6, 8 must not be omitted):

When mapping here you have to select the field “id_parent” for the column “parent” and the corresponding easydb field for the column “name”. If your file contains parent entries that are not yet available in easydb, you have to perform the import twice. In the first step all entries are created and in the second import the links between parent and new child entries are created. Prerequisite is that in the import settings the “field to update” was selected over which the matching should take place (in our example e.g. “id”).

If you want to export a hierarchical list from easydb and import it afterwards, you have to select “Hierarchies as columns” when exporting.

Example “Categories

Procedure

• first open the CSV importer
• upload your CSV file
• select “1st line” for CSV field name
• 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)
• select also for all other columns in the CSV the corresponding target fields (e.g. for “Birthplace” or “Remarks”)
• switch back to the “Import Settings” tab and select the “Update field” if there are already entries in the list that should be updated if necessary
• click on “Prepare” and you will get an overview how many lines will be imported or updated
• then the import / update can be started