EnglishУкраїнськаmRussian
Login/New
Topic with no new replies

data source address import csv


Author Message
Written on: 20. 05. 2020 [08:12]
trayor
trevor kenyon
Topic creator
registered since: 14.05.2020
Posts: 8

Hi,

When considering the following section....

4.3 Complex object-tag of the signal
connecting the data source as an apparatus object


Some other SCADA packages allow data item / data tags / data source to be imported from csv text files.

Is there a method for importing the data sources / apparatus objects into the database?


Thanks,
Trevor
Written on: 21. 05. 2020 [08:56]
roman
Roman Savochenko
Moderator
Contributor
Developer
registered since: 12.12.2007
Posts: 3750
"trayor" wrote:

Some other SCADA packages allow data item / data tags / data source to be imported from csv text files.

Is there a method for importing the data sources / apparatus objects into the database?

Write yourself a needed one service procedure for specified for your data sources, like the ones in the service procedures library!

Learn, learn and learn better than work, work and work.
Written on: 18. 07. 2020 [11:55]
trayor
trevor kenyon
Topic creator
registered since: 14.05.2020
Posts: 8
Hi,

Reviewing the the service procedures library!

I download the library archive file.. OscadaLibs.db.gz
Extract the OscadaLibs.db sqlite file
Upon reviewing the sqlite file I see sample scripts in the formula column.

using Special.FLibSYS;
arh = vArh("Archive.va_"+addr);

//Stage 0: Main values fill: "1,1,10,10,100,100,1000,1000,10000,10000,EVAL"
if(step < 0 || step == 0) {
buf = vArhBuf(1, 10, per*1000000, true, true);


With my current knowledge of OSCADA I dont know how to
1) implement or run the sample scripts eg perform the tests
2) Write a new script to achieve the building of the data sources / apparatus objects into the database?

More reading for me. But figured I post my progress.

Thanks.
Written on: 18. 07. 2020 [12:23]
trayor
trevor kenyon
Topic creator
registered since: 14.05.2020
Posts: 8
Hi,

Can the modbus nodes, and variables to read/write be specified in the file

http://oscada.org/wiki/Documents/Program_manual#TransportOut

reference
4.10 Configuration file and command line parameters

Configuration file of OpenSCADA is provided to store the generic configuration of OpenSCADA-station. Only in the configuration file and through the command-line options you can specify the part of the key parameters of the station, so familiarity with the structure of the configuration file is necessary for professionals who make peculiar solutions based on OpenSCADA. More information on how to startup and execution OpenSCADA can be found in the section "Startup and execution".

Structure of the configuration file based on the extensible markup language XML. Correspondingly, strict compliance with XML syntax rules is required. An illustrative example of an OpenSCADA configuration file with examples of the configuration of most OpenSCADA components is given below:


Sample sections of the config file are:

<?xml version='1.0' encoding='UTF-8' ?>
<OpenSCADA>
<!--
This is the OpenSCADA configuration file.
-->
<station id="SimulatorStation">



<tbl id="Transport_out">
<fld
ID="testModBus"
MODULE="Sockets"
NAME="Test ModBus"
NAME_uk="Тест ModBus"
NAME_ru="Тест ModBus"
DESCRIPT="ModBus protocol exchange test."
DESCRIPT_uk="Тест обміну за протоколом ModBus."
DESCRIPT_ru="Тест обмена по протоколу ModBus."
ADDR="TCP:localhost:10502"
START="1"/>
</tbl>-->



<node id="mod_ModBus">
<!--
<tbl id="DAQ">
<fld ID="test2" NAME="Test 2" NAME_uk="Тест 2" NAME_ru="Тест 2" DESCR="" ENABLE="1" START="1"
PRM_BD="test2prm" PERIOD="1000" PRIOR="0" TRANSP="Sockets" ADDR="exlar.diya.org" NODE="1"/>
</tbl>
<tbl id="test2prm">
<fld SHIFR="test2" NAME="Test 2" NAME_uk="Тест 2" NAME_ru="Тест 2" DESCR="" EN="1"
ATTR_LS="321:0:tst:Test"/>
</tbl>-->
</node>

Written on: 20. 07. 2020 [14:07]
roman
Roman Savochenko
Moderator
Contributor
Developer
registered since: 12.12.2007
Posts: 3750
"trayor" wrote:

I download the library archive file.. OscadaLibs.db.gz

Use "supplied with a ready and proper package of the Linux distribution like to "openscada-libdb-main", "openscada-LibDB.Main";"

"trayor" wrote:

With my current knowledge of OSCADA I dont know how to
1) implement or run the sample scripts eg perform the tests

Tab "Execute" on Figure 1: http://oscada.org/wiki/Special:MyLanguage/Modules/JavaLikeCalc

"trayor" wrote:

2) Write a new script to achieve the building of the data sources / apparatus objects into the database?

http://oscada.org/wiki/Special:MyLanguage/Documents/User_API

Learn, learn and learn better than work, work and work.
Written on: 20. 07. 2020 [14:12]
roman
Roman Savochenko
Moderator
Contributor
Developer
registered since: 12.12.2007
Posts: 3750
"trayor" wrote:

Can the modbus nodes, and variables to read/write be specified in the file

"In addition to the database configuration, the information may be contained in the OpenSCADA configuration file, and passed through the command line parameter's when you call OpenSCADA. Saving configuration in the configuration file is the same as the database."

Learn, learn and learn better than work, work and work.



15404