The CSV Import Wizard facilitates the import of InfoDrainage features from Text or Excel format files. 

Currently supported formats are:

Step-by-step guide

There is a wizard to guide the user through the feature import process. The wizard is a user interface that presents a user with a sequence of dialog boxes that lead the user through a series of well-defined steps. To progress through the steps in the wizard, press the Next button. The return to a previously completed step, press the Previous button.


You can use the Tree View to start the wizard. Right Click on the type of object that is to be imported and select 'Import from CSV'.


  1. File Selection


    This step allows you to specify the type of file to be read and to specify the file by pressing the Select button.


  2. File Details


    The number of header rows can be specified. This is the number of rows that will not data be imported as attribute data. The final header row will be the row that is considered to contain the column headings.

    There is a file preview in the bottom half of this page where the source data that can be imported is shown. 

    For CSV/Text files the column delimiter can be specified

    For Excel files the sheet to be imported can be specified


  3. Template Selection


    This step displays a list of templates that can be used to build objects from the imported data.These templates can be the predefined types or user created. The selected template will be used to build the objects for the imported features. Note that you will only be able to import properties that are valid for the selected template, for example if you wish to import SCS runoff method properties for a catchment area, ensure that the template chosen has SCS selected as the runoff method.

    This step is performed twice when importing connections. The first time to select the default connection type and the second time to select a junction type to be created at connection endpoints where objects do not currently exist in the current stage design.

    The connection or junction type to create may be overruled depending on attribute values that are imported, see info below.


  4. Property Association


    The features imported may have associated nonspatial information called attributes. These attributes can be imported with the feature and assigned to properties of the created object. For example, a collection of manholes may be imported with their names and depth assigned from the attribute table.

    This step shows a control that allows the attributes in the selected source file to be mapped or assigned to properties in the object created from the selected template. The left hand side of the control shows a tree view of the properties in the object that will be created. The right hand side of the control shows a table of attributes in the source file with an example of the data that would be imported.

     To make an association, a property can be dragged from the properties tree view and dropped in the property column of the attribute grid. Alternatively, highlight the required row and tree node and press the 'Add' button. To remove an association, highlight the attribute row and press the 'Remove' button.

    When an association has been made, if the property selected has Unit Selection, the units column in the attribute table will be populated with a combo box, containing possible units for the attribute values. On import, the attribute values will be converted from this unit to the currently selected unit in the software.

    The current association configuration can be saved by pressing the 'Save' button and a previously saved configuration can be loaded by pressing the 'Load' button.


At the final step on the wizard, pressing the 'Import' button will perform the import and create the InfoDrainage objects. When this operation is complete, you will be shown a summary of the objects created during the import. Note that if a row does not have the correct number of columns it is discarded from the import.


Location


Inflow Specific Information


Junction Specific Information


Connection Specific Information