Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Content layer
id2052901168
Content column
width100.00002%
id2052901183
Content block
id2052901173

On this page

Table of Contents
maxLevel4
minLevel3

Content block
id2052901166

Introduction

You can import data from Excel (.xls and .xlsx) or CSV (.csv and .txt) format files to your model. You are able to specify the import mapping options between file columns and element properties of the model.  Additionally, you can save your maps, collect them in groups, manage those groups, and use an entire group instead of a single map for data import. Before importing data from Excel or CSV files to model, create new or open an existing project.

Widget Connector
width800
urlhttps://www.youtube.com/watch?v=x18wXfSfeTM&feature=youtu.be
height700


You can choose the following import commands:

All Excel/CSV file import commands from the File menu.

Preparing Excel or CSV file to import

To import data from Excel or CSV files, the files must met the following prerequisites:

  • Heading is located in the first row.
  • When creating relationships, the spreadsheet must contain the source and target columns. The source and target columns contains the names/qualified names of elements respectively that are the client and supplier of the relationship.

Recommended prerequisites:

  • Eliminate merged cells.
  • Every column has a unique column name.
  • Every row has the same number and name of columns.
  • Every cell has the element name or qualified element name. 

Importing data by using a new map

To import data from an Excel or CSV file to model by using a new map


  1. Create new or open an existing project.
  2. Make sure:
     - the auto usages of Excel Import Plugin are removed. How to >>
     
    - the Excel or CSV file met the basic prerequisites. Basic Prerequisites >>
  3. In the top-left corner of the modeling tool, click the File > Import From > Excel/CSV File > Import Using New Map. The Excel/CSV Import dialog opens.
  4. Select the file and specify mapping options. How to >>

    Tip

    You must select the file in the Select Excel/CSV file area and specify the Element Type, Properties to Map, and Target Scope mapping option values to import data.

  5. In the Mapping area, create mapping between the Excel/CSV file data and modeling tool properties. How to >>
  6. (Optional) Click the Save Map button to save your map options as the Import MapHow to >>
  7. Click the Import button.
    The data from the Excel or CSV file is imported to the model according to the specified options.

Importing data by using an existing map

To import data from Excel or CSV file to model by using an existing map


  1. Create new or open an existing project.
  2. Make sure:
     - the auto usages of Excel Import Plugin are removed. How to >>
     
    - the Excel or CSV file met the basic prerequisites. Basic Prerequisites >>

  3. In the top-left corner of the modeling tool, click the File > Import From > Excel/CSV File > Import Using Existing Map.
  4. In the Select Import Map dialog, select existing Import Map. 

    Tip

    If you cannot see any Import Maps, you need to save it first. How to >>

  5. Click OK. The Excel/CSV Import dialog opens. 
  6. (Optional) Select the file, change mapping options. How to >>
  7. (Optional) Click the Save Map button to override the selected Import Map or create a new one. How to >>
  8. Click the Import button.
    The data from the Excel or CSV file is imported to the model according to the specified options.

Importing data by using an existing map group


To import data from an Excel or CSV file to model by using an existing map group


  1. Create new or open an existing project.
  2. Make sure:
     - the auto usages of Excel Import Plugin are removed. How to >>
     
    - the Excel or CSV file met the basic prerequisites. Basic Prerequisites >>

  3. In the top-left corner of the modeling tool, click the File > Import From > Excel/CSV File > Import Using Existing Map Group.
  4. In the Select Map Group dialog, choose the map group.

    Tip

    If you cannot see any map group, you need to create it first. How to >>

  5. Click OK.
    The data from Excel or CSV files are imported to the model according to Import Maps and their order in the Map Group.

    Warning

    The import of a map group can fail because of the following reasons:

    • the Excel or CSV file is missing;
    • the element type does not exist in the model;
    • properties do not exist in the selected element;
    • the target scope does not exist in the model.




Content block
id2052905962

Related pages

Children Display