You are currently reviewing an older revision of this page.
Where can I find the labels names for selection sets, named views, andgraphs so I can paste them into an excel spread sheet?Product: WaterGEMS V8iVersion: 08.11.XX.XXArea: Output/Results Presentation, Problem ID#: 63652, PROBLEMSOLVINGSee Also: selection set labels, label names, labels, named view labels,named views, graphs, graph labels, .wtg file, .wtg
In order to get the labels for the graphs you will have to locate the.WTG file for this project. Once you locate it you will need to open itwith a text editor like notepad, wordpad, or notepad ++. Once opened youwill need to use the programs find feature to locate area where graphsare stored. If you input in the words "GraphElement" into the findfeature it should bring you to where you'll need to be. You should seemultiple lines similar to the one below:<GraphElement ChartType="0" SeriesLabelFormat="$(Element) -$(Scenario) - $(Field)" Label="Graph - 1" ElementTypeId="-1" SelectedScenarioIDs_Count="1" ..........Here you will find the property of the XML element called 'Label' withthe name of the graph next to it. In this case the graph is just named"Graph-1". Will you will to copy and paste all these names to the excelspreadsheet if you'd like to include them.In this .WTG file you will also find the named view labels. You'll needto use the same process for find and copying them except when you usethe find feature in your text editor input the words "namedview" andyou'll be brought to the correct location. You'll look for a linessimilar to the one below:<NamedViewElement Id="0" Label="Named View - 1" ParentId="-1"NamedViewNodeType="1" LowerLeftX="-221.07142857142858" .........Labels for selection sets are a little easier to get because they arelocated in the database. All you need to do is follow the steps below:1. Open Excel2. Go to Data->Connections->Add3. Browse for More... select the MDB...4. Select "HMIModelingElement" in the list...5. once the connection is listed, click on Properties...6. Go to the Definition tab...7. Change the command type from 'Table' to 'SQL'Under "Command Text" type the following:SELECT Label FROM HMIModelingElement, HMISelectionSet WHEREHMIModelingElement.ElementID = HMISelectionSet.SelectionSetID AND HMIModelingElement.IsDeleted = False;8. Close the connections dialog...9. Go to Data tab->Existing Connections... select the connection we justcreated and click on Open...10. Excel will prompt for the location where to insert the result of thequery (as a pivot-table)...After you do this you should have all the information you need.
XXXXXXX(Add more links as needed for other relevant Be Communities content.)XXXXXXX