Importing CSV data

Step-by-step:

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.
   

5. Click File > Save As.
6. In the Save dialog box, save the new project as “Exercise 4”.
7. On the ribbon, click the Import tab to see the different types of information available to import, as well as their sources.
   
8. In the Tree View, right-click Junctions and select Import from CSV.
   
9. On the Select Source page, select CSV.
10. Click Select.
11. In the file browser, navigate to the data folder and open manhole.csv.
12. In the CSV Import dialog box, on the Select Source page, click Next.
    

10. On the File Details page, next to Number of Header Rows, enter a value of 1.
11. Select the Comma delimiter option.
    

12. Click Next.
13. On the Select Template page, enable the Manhole
14. 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.

15. To map the properties together, in the left pane, click ‘Name’.
16. Click the MH NO. heading.
17. Click Add.

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

18. Match Diameter on the left with the MANHOLE DIAMETER heading on the right.
19. Click Add.
20. Set the unit value for the manhole diameter to mm.
21. Match up the easting and northing headers from both areas, set the Units to meters, and click Add for each.
22. Click Import.
    

23. In the Import Summary dialog, click OK.
24. In the Tree View, expand the Junctions node to view the newly added data.
25. In the Toolbox, click View Extents to see a geographical representation of the imported CSV data in the Plan View.
    

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