Hello,
I'm using WaterGEMS CONNECT Edition. I exported the pipe data from a large existing model to a CSV file. Using Excel, I updated the diameters then tried to import the updated excel file using ModelBuilder. I have tried using the "ID" and "Label" fields as the key fields but neither seem to be recognized, maybe 1400 of the 15000 pipes is recognized and changed while the rest are ignored.
What am I doing wrong ?
Thanks, Tracey
Hello Tracey,
What are you mentioning as the "Key Field" for the pipes? "ID" or "Label"?
Whatever you choose, ModelBuilder will search of that first, if found will update it with the new information. If not found it will create it and assign the necessary information.
Check to see if the labels in the model are matching up with the labels in your excel / CSV file. If not then it would not get updated.
You have to carefully prescribe the parameters for creating or updating your elements using ModelBuilder. See the below article for importing using ModelBuilder and focus on the section on "Specify Element Create/Remove/Update Options",
Using ModelBuilder to Import External Data
Let me know if this helps.
Regards,
Yashodhan Joshi