[TroyV23]

[TroyV23]

[img]https://i.imghippo.com/files/U9965lM.png[/img]

Is this ok?

• This reply was modified 3 weeks, 2 days ago by TroyV23.

[TroyV23]

Is this possibly an issue?

https://iili.io/CCFzeCg.md.png

• This reply was modified 3 weeks, 3 days ago by Mikhail.

[TroyV23]

This is how it is set up right now:

Running Windows Server 2019 (x64) on Web server, and 2022 (x64) on the Application Server.

[TroyV23]

I’ve made my own custom html using the API and a imported CSV to fill channel names which is working really well now.

The problem I’m still having is the polling timing, even though I have it configured to write on change, you said it should be checking status approx. 10 times a second.

My data shows it is only checking approx. every 102 to 105 seconds for changes, and then it posts a whole bunch of “changes” with identical time stamps, when in reality those events all took places many seconds apart.

Any idea what can cause this delay for checking on change status?

[TroyV23]

Im attempting a different path, so I’ve created this feed using the API:

https://i.postimg.cc/sxZ2X3B3/tmp-1de38a8b-3926-45a1-9bc3-bfc23f60969d.png

I am not able to display the channel number it always displays as undefined.

mainApi.getHistData(ARCHIVE_BIT, timeRange, “55500-55508”, function (dto) {
let outElem = $(“#divData2”);

if (dto.ok) {
outElem.html(“”);
let timestamps = dto.data.timestamps;

if (timestamps.length > 0) {

let trend = dto.data.trends[0];

let table = $(“<table></table>”);
table.append(“<tr><th>Date</th><th>Time</th><th>Channel</th><th>State</th></tr>”);

for (let i = 0; i < timestamps.length; i++) {
let timestamp = timestamps[i];
let record = trend[i];
let state = record.df.dispVal;
let channel = record.cnlNum;

// Only show On/Off
if (state !== “On” && state !== “Off”) continue;

let dt = new Date(timestamp.lt);

let day = String(dt.getDate()).padStart(2, “0”);
let month = dt.toLocaleString(“en-US”, { month: “short” });
let year = dt.getFullYear();

let hours = String(dt.getHours()).padStart(2, “0”);
let minutes = String(dt.getMinutes()).padStart(2, “0”);

let dateStr = ${day}-${month}-${year};
let timeStr = ${hours}:${minutes};

// Pick CSS class
let stateClass = state === “On” ? “state-on” : “state-off”;

table.append(
`<tr>
<td>${dateStr}</td>
<td>${timeStr}</td>
<td>${channel}</td>
<td class=”${stateClass}”>${state}</td>
</tr>`
);

• This reply was modified 5 months, 3 weeks ago by TroyV23.
• This reply was modified 5 months, 3 weeks ago by Mikhail.

[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 ?

[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?

[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.

[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!

[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!

[TroyV23]

Thanks!

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

[TroyV23]

Add your own type by analogy ON-OFF by specifying On: blue, Off:yellow for example

This worked perfectly! Thank you 🙂

[TroyV23]

On the “Table” view, can I customize the colour of the states “ON” and “OFF” ?

Right now ON is green, and OFF is red. How Do I use other colours?

[TroyV23]

I discovered the issue was that my minute archive was not set to active. The chart is populating fine now!

[Author]

Posts