Hello !
I've been trying to input a .xlsx file with pressure data at a model's node.
I created a table where each row has one pressure data for a given time and data. I has 1 week data, measured each 15 minutes.
However the SCADA Connector seem not to well read the information, as I am not able to assign any SCADA Signals. It also does not recognize any Table NAme, as the only option that appears to me is "<none>"
Would anyone have a clue about what is going on?? I thank you all very much!
Hello Vitor,
Are you saying it does not recognize the date column, or the whole table? Can you provide more details/screenshots to clarify?
From the screenshot it looks like you might have some rows frozen/hidden - try removing that and also try selecting the date column in Excel and make sure the format is set to one of the date types. Also, make sure you are using an up-to-date version of WaterGEMS. Check under File > Help > About. The latest is currently 10.04.00.108 and you can find information on upgrading here.
If that does not help, please provide a copy of the spreadsheet and any steps needed to reproduce. If you need to provide a copy of the model to go with it, go to File > Save to package, then upload the resulting ZIP file using the information here: Sharing Hydraulic Model Files on the OpenFlows Forum
Regards,
Jesse DringoliTechnical Support Manager, OpenFlowsBentley Communities Site AdministratorBentley Systems, Inc.
Answer Verified By: Vitor Tonzar Chaves
Thank you, Jesse!
I updated my WaterGems and it worked.
Best Regards
Glad to hear it. Happy modeling!