[aluy069]

Im would like to send an time trigger email with many Cnlname and values.

Im successfully sending an time rigger email but can you give me an example how to send many CnlNames and values in the same email

I use binary, command=1 and string=
Subject Fin de turno; {n}, {Now} Name: {CnlName}, value: {CnlVal}

[aluy069]

I include in Exporter.cs file in the private void ExportSrez the line:
“DataSource.SetCmdParam(cmd, “kpNum”, cnlData.KPNum);”

but i suppose i need to define KPNum in SrezTableLight.CnlData at: public struct CnlData, something like: Public KPNum(double val);

but the i don’t know why i can’t modify SrezTableLight.

Can you guide me if i’m right

[aluy069]

SOLVE IT
I have to switch “build configuration” from “Debug” to “Release” for every solution.

thanks

[aluy069]

also i gor the dll repository upgraded 8 days ago

[aluy069]

Hi Mikhail
in the Rapid Scada 5.6.0 im trying to build the solution but whern i build “Report” i got the error:

Severity Code Description Project File Line Suppression State
Error CS0246 The type or namespace name ‘RepBuilder’ could not be found (are you missing a using directive or an assembly reference?) RepExec D:\Rs\scada-master\Report\RepExec\FrmMain.cs 413 Active.

I saw the Reference to RedpBuilder hay an yellow triangle with exclamation.
RedpBuilder supose to be a cladss in WinControl.dll but not.

how to solve it?

[aluy069]

i got the idea and is ok, but i need to insert KpNum value in CnlData from ModDBExport. I don’t like to create another table in the SQL2017

[aluy069]

Is there possible to set the time the ModDBExport.dll insert the data to SQL2017?,

for example i would like to set the insert to a 5 seconds

[aluy069]

I’m using ModDBExport.dll to export data to SQL2017

I would like to insert the KpNum value who generate the val to the CnlData table

I’m using the regular script:
INSERT INTO CnlData (DateTime, CnlNum, Val, Stat)
VALUES (@dateTime, @cnlNum, @val, @stat)

could you tell me how to modification it?

[aluy069]

Mikhail

Give me a quote to do the programation necesarely to:

Send the data to SQL 2017 sever using db export to construct a table with the cnlnum I choose in the same line, also I beed timestamp and status

The table headers in sql should look like:

id | time | quality | oee | model | disp | stat

I need when the dbexport send the data to sql send all colloms of the row at the same time
tanks

[aluy069]

Sorry but i dont know what you mean with “Example for Postgres”

[aluy069]

i performed in SQL 2017
——————-
SELECT [DateTime],
case when cnlnum = 22 then val else 0 end as Modelo,
case when cnlnum = 26 then val else 0 end as Q,
case when cnlnum = 29 then val else 0 end as Efici,
case when cnlnum = 30 then val else 0 end as Disp,
case when cnlnum = 32 then val else 0 end as Turno,
case when cnlnum = 58 then val else 0 end as OEE,
case when cnlnum = 65 then val else 0 end as Run,
Stat

FROM CnlData

where CnlNum in (22,29, 30, 26,58,32,65) AND stat = ‘1’
—————–
it almost do what i need from SQL server but, i just need to send those CnlNum (22,29, 30, 26,58,32,65) to the SQL2017 instead all values cor CnlNum.

I need to do something in the SCADA server like this:
———-
— Insert current data CnlDataLS
INSERT INTO CnlDataLSt (DateTime, CnlNum, Modelo, Calidad, Eficiencia, Disp, Turno, OEE, Run, Stat)
VALUES (@dateTime, @cnlNum, @Val(22), @Val(29), @Val(30), @Val(26), @Val(58), @Val(32), @Val(65), @stat)
——–

my question in what should be the arguments for “INSERT INTO CnlDataLSt” and “VALUES”

May I explain myself?

[aluy069]

SQL 2017, yes si did , but how to doit?

[aluy069]

I send data to SQL using DB export with this scrip and worked fine
— Insert current data
INSERT INTO CnlData (DateTime, CnlNum, Val, Stat)
VALUES (@dateTime, @cnlNum, @val, @stat)

I need to send to SQL just the value of DateTime, plus only 7 input channels and status. I did something like but do not worked

— Insert current data CnlDataLS
INSERT INTO CnlDataLSt (DateTime, Val(1), Val(2), Val(3), Val(4), Val(5), Val(5), Val(7), Stat)
VALUES (@dateTime, @Modelo, @Calidad, @Eficiencia, @Disp, @Turno, @OEE, @Run, @stat).

I created in the SQL the table an columns. I can not figured out how to get it done

[aluy069]

Thanks i follow the win 7 setting and it worked 🙂

2-. could you please guide me how to do the data archive in SQL2018. My scenario is i have two server: Server A is the web server, it hold the configuration and is web server. Server B is the SQL 2018.

regards

[aluy069]

I say thanks you guys because you did a great piece of software.

I have 3 questions:

1-. How to install everything (Server, communicator, webstation, administrator, table editor and scheme editor) in a Windows Server 2012 R2.

2-. I have SQL 2018 installed. Can I use it instead of Microsoft SQL Server Compact 3.5.?

3-. If Yes Question number 2, how to do it? By the way is running is a different server than the one running the Rapid Scada

Regards

[Author]

Posts