How to bulk change coordinates or scale up or down a model

	Product(s):	WaterGEMS, WaterCAD, HAMMER, SewerGEMS, SewerCAD, StormCAD, CivilStorm
	Version(s):	08.11.XX.XX
	Area:	Modeling

Problem

After importing / creating a model (for example using Modelbuilder) I noticed that the model is in the wrong location or wrong scale (for example the wrong units were accidentally selected). Is there a way I can bulk change the model element coordinates or scale up/ down the model by a certain factor?

Solution

When importing a model, it will appear using the units selected in the Modelbuilder wizard and the X and Y coordinates stored in the data source files. If you have a need to make a bulk change to the coordinate such as multiplying them all by a certain factor, there are two possible approaches:

Option 1- Use the MicroStation or AutoCAD integrated version

If you own and have installed a compatible version of MicroStation, you can run the "<Storm or Water Product Name>... for MicroStation" shortcut, open the model file, then use native MicroStation commands to manipulate the location or scale the model. The underlying model database will change accordingly, so once you save it, you can then open it back up in the Standalone version to see the new coordinates.

If you have a compatible version of AutoCAD and have AutoCAD integration licensed in your Haestad product, you can similarly run the "...for AutoCAD" shortcut and use native AutoCAD commands.

Option 2- Export the coordinates to Excel, modify, then send them back to the model

With this approach, you use Modelbuilder to export the X and Y coordinates to a spreadsheet, use Excel to manipulate them, then bring them back into the model to update the locations.

NOTE: this process assumes that you have little to no pipe bends. This process only updates node X and Y and the bends (vertexes) are stored in the pipe.

1) Set up a spreadsheet with worksheets for each of the node types used in the model (the ones that need their X and Y changed). Each worksheet should contain column headers for Label, X and Y

2) In the Haestad product, start Modelbuilder and connect to the spreadsheet. In the first step, select the correct coordinate unit and uncheck the box for "create nodes if non found...".

3) Click Next three times until you get to the Field Mapping step. In here, select the appropriate element type for each of the worksheets on the left side, select Label as the Key field (make sure your element labels are all unique) and select the X and Y fields.

4) Click Next, then choose "no" when asked if you'd like to build the model

5) Back in the Modelbuilder Manager, click the entry in the list corresponding to the Modelbuilder run you juts configured and click the "sync out" button at the top. This will send the label, X and Y to the spreadsheet

6) Open the spreadsheet in Excel, set up functions to modify the X and Y accordingly and save

7) Back in the model, open Modelbuilder, click the same entry again and click the Build Model button. Note that if you created new columns in step 6 to store the updated coordinates, you'll need to edit the Modelbuilder run and change the field mapping accordingly.

Option 3 - Export model elements to shapefiles, manipulate, then import back into the model