Posts made by martijnperdaan

anyone experience with a photoresistor and how to translate that to a 0 to 10 volt signal?

I connected it to the analog input of a Neuron L523

is there a limit to the number of lines you can add to the ODBC database driver ?.

if I add another line, he gives a fault with everything I remove that line again, it is fine again

see here under my mysql_ioconfig.rio

ODBC {
Connection "DRIVER=MySQL;SERVER=;PORT=;DATABAS"
"E=;UID=;PWD=*******;;"
#Comment1 "Archive modes: 0=disable, 1=alarm(columns Time,Alar"
#"mID,Code,Level,Value), 2=group(columns Time,GroupID,Value1,Value2,...), 3=gro"
#"up(SQL with ? in order Time, ID, value1,...)"
#Comment2 "Group modes: 0=disable, 1=read (last ID is accepted"
#"), 2=read(last Time before now is accepted), 3=read(SQL first line is accepte"
#"d), 129=write, 130=write with Time, 131=write SQL (with ?, Time is ?T)"
#GUID *******
Group {
Name "Read"
Mode 3
SQL "SELECT Schakelaar1Uit, Schakelaar1Aan, Schakelaar"
"2Uit, Schakelaar2Aan, Schakelaar3Uit, Schakelaar3Aan, Schakelaar4Uit, Schakela"
"ar4Aan, Schakelaar5Uit, Schakelaar5Aan FROM Schakelaars WHERE ID=1"
Period 2
Items "Schakelaar1Uit,Schakelaar1Aan,Schakelaar2Uit,Scha"
"kelaar2Aan,Schakelaar3Uit,Schakelaar3Aan,Schakelaar4Uit,Schakelaar4Aan,Schakel"
"aar5Uit,Schakelaar5Aan"
Type "ssssssssss"
}
Group {
Name "Read2"
Mode 3
SQL "SELECT Schakelaar6Uit, Schakelaar6Aan, Schakelaar"
"7Uit, Schakelaar7Aan, Schakelaar8Uit, Schakelaar8Aan, Schakelaar9Uit, Schakela"
"ar9Aan, Schakelaar10Uit, Schakelaar10Aan FROM Schakelaars WHERE ID=1"
Period 2
Items "Schakelaar6Uit,Schakelaar6Aan,Schakelaar7Uit,Scha"
"kelaar7Aan,Schakelaar8Uit,Schakelaar8Aan,Schakelaar9Uit,Schakelaar9Aan,Schakel"
"aar10Uit,Schakelaar10Aan"
Type "ssssssssss"
}
Group {
Name "Read3"
Mode 3
SQL "SELECT Schakelaar11Uit, Schakelaar11Aan, Schakela"
"ar12Uit, Schakelaar12Aan, Schakelaar13Uit, Schakelaar13Aan, Schakelaar14Uit, S"
"chakelaar14Aan, Schakelaar15Uit, Schakelaar15Aan FROM Schakelaars WHERE ID=1"
Period 2
Items "Schakelaar11Uit,Schakelaar11Aan,Schakelaar12Uit,S"
"chakelaar12Aan,Schakelaar13Uit,Schakelaar13Aan,Schakelaar14Uit,Schakelaar14Aan"
",Schakelaar15Uit,Schakelaar15Aan"
Type "ssssssssss"
}
Group {
Name "Read4"
Mode 3
SQL "SELECT Schakelaar16Uit, Schakelaar16Aan, Schakela"
"ar17Uit, Schakelaar17Aan, Schakelaar18Uit, Schakelaar18Aan, Schakelaar19Uit, S"
"chakelaar19Aan, Schakelaar20Uit, Schakelaar20Aan FROM Schakelaars WHERE ID=1"
Period 2
Items "Schakelaar16Uit,Schakelaar16Aan,Schakelaar17Uit,S"
"chakelaar17Aan,Schakelaar18Uit,Schakelaar18Aan,Schakelaar19Uit,Schakelaar19Aan"
",Schakelaar20Uit,Schakelaar20Aan"
Type "ssssssssss"
}
Group {
Name "Read5"
Mode 3
SQL "SELECT Schakelaar21Uit, Schakelaar21Aan, Schakela"
"ar22Uit, Schakelaar22Aan, Schakelaar23Uit, Schakelaar23Aan FROM Schakelaars WH"
"ERE ID=1"
Period 2
Items "Schakelaar21Uit,Schakelaar21Aan,Schakelaar22Uit,S"
"chakelaar22Aan,Schakelaar23Uit,Schakelaar23Aan"
Type "ssssss"
}
Group {
Name "Read6"
Mode 3
SQL "SELECT SDimmer1Aan, SDimmer1Uit, SDimmer2Aan, SDi"
"mmer2Uit, SDimmer3Aan, SDimmer3Uit, SDimmer4Aan, SDimmer4Uit, SDimmer5Aan, SDi"
"mmer5Uit FROM Schakelaars WHERE ID=1"
Period 2
Items "SDimmer1Aan,SDimmer1Uit,SDimmer2Aan,SDimmer2Uit,S"
"Dimmer3Aan,SDimmer3Uit,SDimmer4Aan,SDimmer4Uit,SDimmer5Aan,SDimmer5Uit"
Type "ssssssssss"
}
Group {
Name "Read7"
Mode 3
SQL "SELECT SDimmer6Aan, SDimmer6Uit, SDimmer7Aan, SDi"
"mmer7Uit, SDimmer8Aan, SDimmer8Uit FROM Schakelaars WHERE ID=1"
Period 2
Items "SDimmer6Aan,SDimmer6Uit,SDimmer7Aan,SDimmer7Uit,S"
"Dimmer8Aan,SDimmer8Uit"
Type "ssssss"
}
Group {
Name "Read8"
Mode 3
SQL "SELECT Dimmer1, Dimmer2, Dimmer3, Dimmer4, Dimmer"
"5, Dimmer6, Dimmer7, Dimmer8, Dimmer9 FROM EntertainmentKnop WHERE Id=?10"
Period 2
Items "Dimmer1,Dimmer2,Dimmer3,Dimmer4,Dimmer5,Dimmer6,D"
"immer7,Dimmer8,Dimmer9,ID"
Type "sssssssssi"
}
Group {
Name "Read9"
Mode 3
SQL "SELECT Dimmer10 FROM EntertainmentKnop WHERE Id=?"
"2"
Period 2
Items "Dimmer10,ID"
Type "si"
}
Group {
Name "Read10"
Mode 3
SQL "SELECT SDimmer9Aan, SDimmer9Uit, SDimmer10Aan, SD"
"immer10Uit, SDimmer11Aan, SDimmer11Uit, SDimmer12Aan, SDimmer12Uit, SDimmer13A"
"an, SDimmer13Uit FROM Schakelaars WHERE ID=1"
Period 2
Items "SDimmer9Aan,SDimmer9Uit,SDimmer10Aan,SDimmer10Uit"
",SDimmer11Aan,SDimmer11Uit,SDimmer12Aan,SDimmer12Uit,SDimmer13Aan,SDimmer13Uit"
Type "ssssssssss"
}
Group {
Name "Read11"
Mode 3
SQL "SELECT SDimmer14Aan, SDimmer14Uit, SDimmer15Aan, "
"SDimmer15Uit, SDimmer16Aan, SDimmer16Uit, SDimmer17Aan, SDimmer17Uit, SDimmer1"
"8Aan, SDimmer18Uit FROM Schakelaars WHERE ID=1"
Period 2
Items "SDimmer14Aan,SDimmer14Uit,SDimmer15Aan,SDimmer15U"
"it,SDimmer16Aan,SDimmer16Uit,SDimmer17Aan,SDimmer17Uit,SDimmer18Aan,SDimmer18U"
"it"
Type "ssssssssss"
}
Group {
Name "Read12"
Mode 3
SQL "SELECT SDimmer19Aan, SDimmer19Uit, SDimmer20Aan, "
"SDimmer20Uit, SDimmer21Aan, SDimmer21Uit, SDimmer22Aan, SDimmer22Uit, SDimmer2"
"3Aan, SDimmer23Uit FROM Schakelaars WHERE ID=1"
Period 2
Items "SDimmer19Aan,SDimmer19Uit,SDimmer20Aan,SDimmer20U"
"it,SDimmer21Aan,SDimmer21Uit,SDimmer22Aan,SDimmer22Uit,SDimmer23Aan,SDimmer23U"
"it"
Type "ssssssssss"
}
Group {
Name "Read13"
Mode 3
SQL "SELECT ?2 FROM Schakelaars WHERE ID=1"
Period 2
Items "SchakelaarAanString,SchakelaarAan"
Type "ss"
}
Group {
Name "Write1"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=1"
Period 2
Items "Schakelaar1Satus"
Type "s"
}
Group {
Name "Write2"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=2"
Period 2
Items "Schakelaar2Satus"
Type "s"
}
Group {
Name "Write3"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=3"
Period 2
Items "Schakelaar3Satus"
Type "s"
}
Group {
Name "Write4"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=4"
Period 2
Items "Schakelaar4Satus"
Type "s"
}
Group {
Name "Write5"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=5"
Period 2
Items "Schakelaar5Satus"
Type "s"
}
Group {
Name "Write6"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=6"
Period 2
Items "Schakelaar6Satus"
Type "s"
}
Group {
Name "Write7"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=7"
Period 2
Items "Schakelaar7Satus"
Type "s"
}
Group {
Name "Write8"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=8"
Period 2
Items "Schakelaar8Satus"
Type "s"
}
Group {
Name "Write9"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=9"
Period 2
Items "Schakelaar9Satus"
Type "s"
}
Group {
Name "Write10"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=10"
Period 2
Items "Schakelaar10Satus"
Type "s"
}
Group {
Name "Write11"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=11"
Period 2
Items "Schakelaar11Satus"
Type "s"
}
Group {
Name "Write12"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=12"
Period 2
Items "Schakelaar12Satus"
Type "s"
}
Group {
Name "Write13"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=13"
Period 2
Items "Schakelaar13Satus"
Type "s"
}
Group {
Name "Write14"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=14"
Period 2
Items "Schakelaar14Satus"
Type "s"
}
Group {
Name "Write15"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=15"
Period 2
Items "Schakelaar15Satus"
Type "s"
}
Group {
Name "Write16"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=16"
Period 2
Items "Schakelaar16Satus"
Type "s"
}
Group {
Name "Write17"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=17"
Period 2
Items "Schakelaar17Satus"
Type "s"
}
Group {
Name "Write18"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=18"
Period 2
Items "Schakelaar18Satus"
Type "s"
}
Group {
Name "Write19"
Mode 131
SQL "UPDATE SchakelaarStatusNaam SET Status=?1 WHERE I"
"d=19"
Period 2
Items "Schakelaar19Satus"
Type "s"
}
}

what is wrong here it is a normal CNR block with the value 1680 I place it outside the subsystem block directly on the output Extentons__xS51_1_AO1 I measure 4.2 volts I place the CNR block in the subsystem block it gives no output to the output Extentons__xS51_1_AO1

how do I Fix this error

pi@raspberrypi:~ $ sudo apt-get install neuron-kernel unipi-firmware
Reading package lists... Done
Building dependency tree
Reading state information... Done
Some packages could not be installed. This may mean that you have
requested an impossible situation or if you are using the unstable
distribution that some required packages have not yet been created
or been moved out of Incoming.
The following information may help to resolve the situation:

The following packages have unmet dependencies:
neuron-kernel : Depends: raspberrypi-kernel (= 1.20190819~stretch-1) but 1.20200811-1 is to be installed
E: Unable to correct problems, you have held broken packages.
pi@raspberrypi:~ $

Can anyone help me

I would like to install rexygen on a Neuron L523
i follow this guide
https://www.rexygen.com/doc/ENGLISH/MANUALS/RexygenGettingStarted_UniPi/RexygenGettingStarted_UniPi_ENG.html

but can't get the plc up and running

is there a special way or maybe you need to install extra stuff with rexygen on a Neuron L523

whatever I try I can't get it to work

get this error code

12-8-2020 21:53:30.432 Error MBDRV: Socket receive error (idx=0, code=111)
12-8-2020 21:53:30.432 Error MBDRV: Error while receiving data(ignore, code=-309)

i would like to have the rexgen software running on a Unipi Neuron L523

if I am correct I have to edit the file neuron_cfg.rio to assign all digital inputs and relay outputs

where can I find the data that I have to enter there such as this for example
Item {
Name "RO3_1"
SlaveAdr 0
RegisterAdr 3001
Type 0x00000144
Count 2
}

@martijnperdaan said in Database:

Schakelaars

the input SwitchOn is variable sometimes it is Switch1On and sometimes Switch2On and sometimes Switch3On

so he has to read the value of for example Switch1On from the tablet Switches
for example, he should get back 01101010 as answer because it is stored underneath but he returns Switch1On in response

the system does not log an error because the SQL command line must be normal

what is wrong with this how can I read that value correctly from the database.

my idea says i have to add ?1 but where

Group {
Name "Read13"
Mode 3
SQL "SELECT ?2 FROM Schakelaars WHERE Id=1"
Period 2
Items "SchakelaarAanString,SchakelaarAan"
Type "ss"
}

I would like to have a checkbox 3 times in my hmi. but how do you set that only 1 can be turned on? .. if you click another button the one that was on goes off again. like checkbox 1 or checkbox 2 or checkbox 3 not and

is there a way that you can make the HMI page that if you press an LED there will be a popup containing whith a SliderHorizontal in it and then you can change the SliderHorizontal

I solved it with a REXLANG block

that is not what is search that is a kind of dropdown menu I really want to do that with separate buttons on the page

Can you give me an example how to do that with that function block I can't figure it out myself?

@jaroslav_sobota said in analoog output 0 until 100 %:

si

yes I do want to be able to dim the light by means of a single push button

can you give me an example how to use the INTE block so far it gives block only a very high signal up

I want it to go from 0 to 100 and back again

like this i just want to have it that if i press the button again it will pick up where it left off (for example 40%) and not start at zero

and is this perhaps easier what I have now made?

Have you developed the SignalSweeper block yourself?

otherwise where can I find it

yes like it does go back and forth as long as signal is high

only that if the signal then stops at, for example, 40%, it also remains at 40% with the output signal and if the input becomes high again, it starts again at 40% and then goes up again to 100%

@jaroslav_sobota

No I mean that if the input goes high, it goes slowly from where it left to 100% and that the input is still high then slowly back to 0%, the input is still high again slowly to 100% and so on through

Is there also a function block that if the input is high it will bring the analog output to 100% if it is still high then counts back to 0% and if it is still high it will go back to 100%?

if not

can you give me an example of how this is possible