[inpelsa]

Well… it would help, for sure, but it will be more/less visible depending on the amount of text on the label.

It would be best to place label below or left to cursor, but if that is so complex let’s try transparent! 🙂

[inpelsa]

Label is over graph, I can see values but not the graph, with many channels either you can not see values or you can not see graph, never both (useful to see correlation between values)

More tips… Chart period: add [Today], last 3 days, last week and last month buttons

• This reply was modified 7 years, 5 months ago by inpelsa.

[inpelsa]

Ok, working now! thanks!

Some tips…:

– pointing to the right side of the graph I can not see the graph, the floating label covers it! set it to the left of the mouse if it can not fit on the window.

– if I point too high I can not see the floating label, but if I point low I can not see the graph! maybe better always below or dynamic?

– right now as I can see values on the floating label… why the list of channels at the bottom? It will be mandatory for chart list (as you can not point to all charts at the same time) but without chart list… Or if at least channels were splitted on several columns…

Try it plotting 10-15 channels.

[inpelsa]

Few months… Mmm… Then I would be happy if that memory-eater bug gets fixed in current release 🙂

[inpelsa]

Seems I wrongly modified permissions when installing beta web…

working again, thanks!

[inpelsa]

Nop, it doesn’t work, but you don’t notice it until you restart web service.

Changes are not saved to RepChartListPresets.xml

[inpelsa]

Not too much slower but… it will be annoying on slower computers than intel core i3. Don’t know in tablets/smartphones

Schemes were quite slow to design and I stopped that part.
As my devices are mostly data “read only”, commands are not needed.
Maybe I will never use them.

[inpelsa]

briefly tested:

– Tables with ~100 channels is slower to draw (don’t worry, it’s early to improve this)
– schemes not used
– commands not used

It works, but without advanced features… not too much to test.

Seems it doesn’t eats RAM.

[inpelsa]

Does http://rapidscada.org/download/scada_web_beta.zip include charts already?

And CharLists?

[inpelsa]

Please, feel free to add it yourself with nice code 😉

Even more, if you add a 2nd textbox for the status value (plus some program logic to modify data only in case a value is written) and a way to select a range of days to modify… it should be more than enough!!!

[inpelsa]

To anyone interested…

Taking the source code of Scada server (building /solving references) and doing following modifications you got it!:

In FrmSrezTableEdit.cs set:
– datagridview1.multiselect = true
– Add a label, textbox and command button near the SQL filter
– Add this code on Update command button:

       private void btnUpdate_Click(object sender, EventArgs e)
        {
            Int32 numloops = 0;

            foreach (DataGridViewRow row1 in dataGridView1.SelectedRows)
            {
                dataGridView1.CurrentCell = dataGridView1.Rows[row1.Index].Cells[0];

                foreach (DataGridViewRow row2 in dataGridView2.Rows)
                {
                    row2.Cells[1].Value = txtNewValue.Text;
                    dataTable2.AcceptChanges();
                }

                if (numloops % 10 == 0) { Application.DoEvents(); }
                numloops++;

            }
        }

It will allow you to select a datetime range, a channel/value filter and update all data valuees at a time.

Not nice (even more if I’m not an expert on C#), but will reduce any update task from hours to minutes…

• This reply was modified 7 years, 9 months ago by inpelsa.

[inpelsa]

On the performance… not sure, maybe it’s faster because you only access sequential data without filtering, grouping… but I’m curious to see a performance benchmark between both solutions. Current databases can get profit of new technologies, and if they are worth, it can make the difference.

I’m on Arduino, I understand that point, on those platforms it’s a completely different situation and at some point they will use newer technologies.

There is SQLite for the Pi, but dependencies will be still there.

That ability is the best, for sure, but I think in 1-2 years will not be needed anymore as said. Just switch to SQL at the right moment 🙂

[inpelsa]

Yahooo !!

About 15 channels by now. but who knows in the future?

20 channels, 15 days, works perfectly (but with that [show data] function disabled)

I wonder if you are already using SQL Server lite for objects/channels… why not for data too?

I’m sure it will be mandatory soon or after for a number of data related reasons.
Sending several days data together to the graph will make it even faster.

[inpelsa]

I already fixed data but I’m curious…

On http://rapidscada.org/integration-with-rapid-scada/ section “First Way. Direct File Access” you talk about loading data:

using Scada.Data;
...
SrezTableLight snapshotTable = new SrezTableLight();
SrezAdapter adapter = new SrezAdapter();
adapter.FileName = @"C:\SCADA\ArchiveDAT\Cur\current.dat";
adapter.Fill(snapshotTable);

foreach (SrezTableLight.Srez snapshot in snapshotTable.SrezList.Values)
{
    int cnlCnt = snapshot.CnlNums.Length;
    Console.WriteLine("Snapshot {0}, number of channels is {1}:", 
        snapshot.DateTime, cnlCnt);

    for (int i = 0; i < cnlCnt; i++)
    {
        Console.WriteLine("    Channel[{0}] = {1}, {2}", snapshot.CnlNums[i],
            snapshot.CnlData[i].Val, snapshot.CnlData[i].Stat);
    }
}

As I see a .Fill() that would not keep linked adapter and table data objects…

How can data be modified ?
I cannot see any update/save method. Is SaveToFile the only way?

Thanks!

[inpelsa]

well… I just saw it was for 4 hours…

[Author]

Posts