Importing an Excel File with Parent/Child Relationships into Mavim Manager

Preparing the Excel File:

To ensure a successful import:

1. When you have an Excel file like this:
   
2. Place all main topic names under the column that will be used as the topic name (e.g., Job title).
   
   
3. Add an extra column (e.g., Parent) that refers to the ID of the parent topic. This column will be used as the Parent ID.
   

Import Steps:

1. Upload the Excel file to the Mavim Manager environment.
2. Go to Modeling → Import → Excel.
   
3. Click the browse button (⋯) and select your Excel file.
   
   
4. Click Next twice to proceed to the column selection screen.
   
5. Select the columns you want to import as fields. In this example:
   • ID, Job title, and Parent are used for structure and will not be selected as fields.
     
6. In the next screen:
   • Set Job title as the Topic name.
   • Set Parent as the Parent ID.
     
7. Click Next, choose the location in the database where the import should occur, and specify the name of the main topic.
   
8. Click Import, then OK.
   

Result:

The imported data will now appear in Mavim Manager with the correct parent/child hierarchy.