I sync WaterGEMS and SewerGEMS with a GIS with modelbuilder.
In ArcGIS (10.6.0.831), using the Bentley WaterGEMS (10.01.01.04) (64) V8I ModelBuilder i can transfert the data from the MDB DB (OLEDB personal geodatabase connected to WaterGEMS ) into the ESRI File Geodatabase through the SYNC-OUT using the "Label" as a key in SQLServer.
Its work well, but i would like to know if its possible to automate the 'Sync-IN' with a periodic execution e.g with python or ArcPy ?
It is possible to run ModelBuilder from a command prompt (search the help for ModelBuilder Batch Import), so you should be able to write a script to automate this.
For more information about batch imports in ModelBuilder, see the section at the bottom of this article: Import and export Modelbuilder connections with a Modelbuilder Connection File
What kind of information are you trying to update periodically?
Jesse DringoliTechnical Support Manager, OpenFlows ProductsBentley Communities Site AdministratorBentley Systems, Inc.
Thank you for the documentation, it is very appreciated ! The idea is actually to write a script to automate the processing it would be more robust and efficient than a manual execution.
In ArcGIS (10.6.0.831), using the Bentley WaterGEMS (10.01.01.04) (64) V8I ModelBuilder i can transfert the data from the MDB DB (OLEDB personal geodatabase connected to WaterGEMS ) into the GIS *ESRI File Geodatabase through) the SYNC-OUT tool in ModelBuilder using the "Label" as a key in SQLServer.
Its work well, but i would like to know if its possible to automate the 'Sync-IN' and the ‘Sync-OUT’ with a periodic execution e.g with python or ArcPy ?
From what i read (thanks for the documentation) ;
As of May, 2018, this feature only supports importing data (the equivalent of "Build model" (Sync in to model) in ModelBuilder). Sync out (export to an external file/database) is not yet supported.
Its supported for the SYNC-IN only.
The type of synchronization to implanted is bidirectional. The model (WaterGEMS & SewerGEMS) will be the data master (SYNC-OUT) but some element status will also be updated (SYNC-IN) with GIS applications. Finally, to make this procedure efficient, it would be nice to execute the CMD like the sync-in function on a periodic basis and on demand.
Ah - sorry, I missed the fact that you are trying to sync data from WaterGEMS to the GIS geodatabase.
Are you just exporting model results (e.g. calculated pressure, flow, etc.), or are you also exporting input data (pipe diameter, elevations, etc.)?
No problems, thank you for your support. I export both. Some informaitons will be edited by GIS applications (then sync-in into model) some information will be edited in Water / Sewer (then sync-out) into GIS,