• InfoDrainage
  • Civil 3D

Importing CSV data

Understand the import data source options that InfoDrainage can accommodate, and how to import a CSV file.



Data can be imported into InfoDrainage from several different sources and in different orders, allowing you to customize the process of building a drainage model.

  1. Click File > New to start a new project.
    The InfoDrainage File menu with New selected.
  1. Click File > Save As.
  2. In the Save dialog box, save the new project as “Exercise 4”.
  3. On the ribbon, click the Import tab to see the different types of information available to import, as well as their sources.
    The ribbon with the Import tab active and highlighted.
  4. In the Tree View, right-click Junctions and select Import from CSV.
    The Tree View with the Junctions submenu displayed, and Import from CSV selected
  5. On the Select Source page, select CSV.
  6. Click Select.
  7. In the file browser, navigate to the data folder and open manhole.csv.
  8. In the CSV Import dialog box, on the Select Source page, click Next.
    The CSV Import dialog with a CSV file selected and the Next button called out.
  1. On the File Details page, next to Number of Header Rows, enter a value of 1.
  2. Select the Comma delimiter option.
    The CSV Import dialog with the File Details page configured.
  1. Click Next.
  2. On the Select Template page, enable the Manhole
  3. Click Next.

This opens the Map Properties page, where you must map the properties in the file to the item values being used. In the left window, the tree view shows the information InfoDrainage requires, and on the right is the information from the imported CSV file.

  1. To map the properties together, in the left pane, click ‘Name’.
  2. Click the MH NO. heading.
  3. Click Add.

Note that the column heading does not need to exactly match the junction information headings on the left.

  1. Match Diameter on the left with the MANHOLE DIAMETER heading on the right.
  2. Click Add.
  3. Set the unit value for the manhole diameter to mm.
  4. Match up the easting and northing headers from both areas, set the Units to meters, and click Add for each.
  5. Click Import.
    The CSV Import dialog with the Map Properties configured and the Import button called out.
  1. In the Import Summary dialog, click OK.
  2. In the Tree View, expand the Junctions node to view the newly added data.
  3. In the Toolbox, click View Extents to see a geographical representation of the imported CSV data in the Plan View.
    The Toolbox with View Extents called out and the Plan View with the imported CSV data mapped.

Note: importing different datasets does not need to happen in a certain order.