aluy069

Forum Replies Created

Viewing 15 posts - 1 through 15 (of 16 total)
  • Author
    Posts
  • in reply to: Mail SMTP Set #5814
    Avataraluy069
    Participant

    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}

    in reply to: connect to microsoft SQL #5324
    Avataraluy069
    Participant

    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

    in reply to: ScadaCommShell has problem with IChildForm #5308
    Avataraluy069
    Participant

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

    thanks

    in reply to: ScadaCommShell has problem with IChildForm #5307
    Avataraluy069
    Participant

    also i gor the dll repository upgraded 8 days ago

    in reply to: ScadaCommShell has problem with IChildForm #5306
    Avataraluy069
    Participant

    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?

    in reply to: connect to microsoft SQL #5305
    Avataraluy069
    Participant

    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

    in reply to: connect to microsoft SQL #5295
    Avataraluy069
    Participant

    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

    in reply to: connect to microsoft SQL #5293
    Avataraluy069
    Participant

    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?

    in reply to: ModDBExport #5092
    Avataraluy069
    Participant

    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

    in reply to: ModDBExport #5076
    Avataraluy069
    Participant

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

    in reply to: ModDBExport #5041
    Avataraluy069
    Participant

    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?

    in reply to: ModDBExport #5031
    Avataraluy069
    Participant

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

    in reply to: ModDBExport #5023
    Avataraluy069
    Participant

    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

    in reply to: Web Application on Windows Server 2012 R2 #4943
    Avataraluy069
    Participant

    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

    in reply to: Web Application on Windows Server 2012 R2 #4938
    Avataraluy069
    Participant

    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

Viewing 15 posts - 1 through 15 (of 16 total)