Editing object properties in a grid view

Step-by-step guide

When working with an open network, along with adjusting single network object properties from the property sheets, view and edit the properties of multiple network objects using grid views. Grids are spreadsheet-style data tables of objects in the network that are divided into groups, and each group contains grids for one class of object and related sub-objects.

To complete this exercise, import 1D Sewer Network.isfm and open it on the GeoPlan, or use an available existing network.

There are several methods to open a grid view for all the nodes in this network:

1. From the Windows toolbar, expand the Grid windows drop-down and click New nodes window.

2. Select Window > Grid Windows, and then select the type, New nodes window.

3. In the Modelling Grid Windows toolbar, select New nodes window.

Regardless of the method used, all of the nodes from the network display in a spreadsheet-style grid window. The list of object classes is at the top of this menu, and it includes nodes, links, subcatchments, polygons, lines, points, and results.

If an object or objects are already selected, hold down the CTRL key while opening the relevant object grid window, and it will only contain the selected objects.

Note: When a grid window is active, in the menu bar, the Grid menu also becomes active and contains some additional features.

In the Grid window, columns can be reordered, and whole columns or sections of data can be cut, copied, or pasted. Values can be modified individually or in bulk.

For example, to increase all values in a column by 5%:

4. Click the column header to select the entire column.
5. Right-click anywhere in the column and select Current Cell(s) > Adjust current value(s) for cell(s).
6. In the Adjust cell(s) value dialog box, enter a Value of 5.
7. Enable Adjust by a percentage.

8. Click OK.

In the grid, the values adjust accordingly.

If Auto-flagging is turned on in the toolbar, the column just modified now has the flag color. To change a flag:

9. Select the relevant cells or column.
10. Right-click the selection and click Flags.
11. In the flyout, select the new flag.
12. Close the Node grid window.

As another example of easily adjusting values, increase the pipe width by 150mm:

13. Open a links grid by selecting Window > Grid Windows > New links window.

Notice at the bottom of the window that tabs for different types of links appear.

14. Find and click the header of the Width column to select the column.
15. Right-click in any highlighted cell and select Current Cell(s) value > Adjust current value(s) for cell(s).
16. In the Adjust Cell(s) dialog box, enter a Value of 150.
17. Enable Adjust by an absolute value.
18. Select Add.
19. Click OK.

This can be useful to quickly test the impact of upsizing pipes.

In large grids, the Find tool makes it easier to locate specific columns:

20. Open the node grid again to change the flood type.
21. Right-click any column header and select Find Column.
22. In the Find Column in Grid dialog box, select Flood Type.

23. Click OK to locate the column.
24. Click the header to select the column.
25. Right-click a cell, and select Current Cell(s) value > Set New Value(s) for Cell(s).
26. In the New Cell Value dialog box, select Stored.

27. Click OK.

These functions can be carried out on the entire column, a selection, or an individual field.

Note: Use the Undo button to revert any changes that have been made. To remove all changes since the last commit, there is a Revert all changes option, which can be found by right-clicking on the network icon. Changes cannot be recovered once this option has been selected.