Only Archive on “Status change”

[TroyV23]

Hi,

I have a digital input logger device in the field that communicates with RapidScada via modbus, and currently I am polling the device to get updated status of each input “ON” or “OFF” but this creates a lot of wasted data.

A preferred, and more efficient method would be if the archive only contained time stamps when the input status changed, and what that status changed to.

For Example…

Current setup:

Input0001 – ON – 10:00:01
Input0001 – ON – 10:00:02
Input0001 – ON – 10:00:03
Input0001 – ON – 10:00:04
Input0001 – OFF – 10:00:05
Input0001 – OFF – 10:00:06

Preferred Setup:

Input0001 – ON – 10:00:01
Input0001 – OFF – 10:00:05

Is this possible to do inside Rapidscada?
I am currently archiving to an PostgreSQL database.

Thanks in advance!

[Mikhail]

Hi,
Historical archives of the default type save data with fixed period.
To save data on change, enable PostgreSQL archives. They are disabled in the HelloWorld project. Archives can be found and configured in Instances – Default – Server – Archives.

[Mikhail]

> I am currently archiving to an PostgreSQL database.
If so, just configure the archive options.

[Mikhail]

Note that you need some intermediate points to draw a chart.

[TroyV23]

Thanks!

I will need up to seconds accuracy for the time-stamp of the status changes, how would I achieve that?

[Mikhail]

You can mix periodical writing and writing on change. If you published a screenshot of the archive options, I could advice.
Also I suggest to enable events for those channels.

[TroyV23]

These are the archive settings I chose, but unfortunately it’s still creating periodic logs every second which is too much data.

If I remove the “write with period” setting. How often will the device be checked for changes?

Also, side question. Is there a quicker way of editting multiple channels because I find myself having to edit hundreds of lines manually with every change I do. I can select multiple rows but it doesn’t let me edit them simultaneously.

Thanks!

[Mikhail]

If you untick “Write with period”, the archive will write data only when it changes.

> Is there a quicker way of editting multiple channels
Method 1
1. Optionally filter the channels in the table.
2. Use the replace feature (Ctrl + F).

Method 2
Edit a table in XML. Then reload the configuration database.

[TroyV23]

If you untick “Write with period”, the archive will write data only when it changes.

How often does rapidscada check for changes? Is it every second?

2. Use the replace feature (Ctrl + F).

How do you find & replace when the cell is blank? I wasn’t able to make that work for me.

Thank you so much for the assistance!

[Mikhail]

How often does rapidscada check for changes? Is it every second?

Approximately 10 times a second.

How do you find & replace when the cell is blank?

I think, this is not possible.

[TroyV23]

Thanks Mikhail, I have the archive working properly now.

Is there a way to make RapidScada store the Channel Name in the SQL database? Seems it only stores the Channel number.

[Mikhail]

Is there a way to make RapidScada store the Channel Name in the SQL database?

Yes. Create a new deployment profile, and set Extension to ExtDepPostgreSql. Set the parameters on the DB Connection tab.
When you deploy a project with that profile, it will be written to PostgreSQL.

[TroyV23]

I’ve made the new profile, uploaded config with the new settings successful.

However, the Historical table still does not contain the Channel name column, only channel number.

And advice to make this column?

[Mikhail]

Channels and other tables of the configuration database will appear in different tables in the project database schema.

[TroyV23]

Channels and other tables of the configuration database will appear in different tables in the project database schema.

Is it possible to get the channel name through the API ?

[Author]

Posts