How to use ModArcPostgreSql?

[kcks66]

Hi Mikhail,

I had done configuring both as below, pls advice for what should I do next in order to see some data in database.

https://ibb.co/Fb956Xh

https://ibb.co/JH4BBGW

Thank you.

[Mikhail]

Hi,
Open the Schemas node and check what schemas are available. You should find data there.

[kcks66]

Hi Mikhail,

Yes I see new schema with table are available:

https://ibb.co/vjXVhsH

The next step is I just enable those archives with ModArcPostreSql module then Rapid SCADA will start storing data into PostgreSql database already, right?

https://ibb.co/pr40ZGV

[Mikhail]

Hi,

The next step is I just enable those archives with ModArcPostreSql module then Rapid SCADA will start storing data into PostgreSql database already, right?

Yes, if default settings are used. You should select data from the database table to make sure that data exist.

[kcks66]

Hi Mikhail,

I can see my data store in PostgreSql now.
Can I just use PostgreSql as my main and only achieves? Like below setting.

https://ibb.co/nnnLDYr

Thank you.

[Mikhail]

Hi,
Yes, you can.

[kcks66]

Hi Mikhail,

I configured PostgreSql as my main achieve now. This is great.
Thank you.

[kcks66]

Hi Mikhail,

Right now I have weeks of data in Postgresql database. I am thinking of write a script in Formula to pull past DateTime Cnl channel’s Val value from database for further processing in real-time.

Can I do that? Pls advice and thank you.

[Mikhail]

Hi,
Could you clarify your question?

[kcks66]

Hi Mikhail,

Let say I have a Real Channel (101) to read meter energy kWh data, I configure a Calculated Channel (102) to calculate how much energy used in 30 minutes. In my script when every 30 minutes interval time, I will take the Real Channel (101)’s Current reading and access PostgreSql Minute Archive database to search for the same Channel (101) but DateTime is past 30 minutes ago to get its value. Thus I can get their different to become the result.

[Mikhail]

Hi,
Channel formulas work only with current data. To calculate differences (e.g., power consumption), I suggest Elastic Report Plugin.

[kcks66]

Hi Mikhail,

I have Elastic Report but what I want to do is to use the result/value from the calculated channel (e.g., power consumption) to show in table and to plot on chart.

[Mikhail]

Hi,
I see. It would be handy. For now, there is no ready to use solution.
If there is a business need and you could sponsor that feature, I could create a prototype of the module that will become a part of Rapid SCADA.

[kcks66]

Hi Mikhail,

Noted. I try calculate power consumption by using current data at the moment.
Thank you.

[Mikhail]

Hi,
OK. I hope we will create a module to calculate consumption in the future.

[Author]

Posts