Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_Feed Topic RSS sp_TopicIcon
Add programmatically items and group
September 27, 2022
11:37, EEST
Avatar
mgrenier
Member
Members
Forum Posts: 11
Member Since:
February 4, 2021
sp_UserOfflineSmall Offline

Hello,
it is possible to add programmatically items and group in OPC UA Historian (like we did with the configurator) ?
Thank you

September 27, 2022
13:14, EEST
Avatar
Matti Siponen
Moderator
Members

Moderators
Forum Posts: 222
Member Since:
February 11, 2020
sp_UserOfflineSmall Offline

Hello,

Historian does not support adding Collection Groups or Collection Items programmatically.

If this feature would be important to you, contact sales@prosysopc.com

September 27, 2022
17:55, EEST
Avatar
mgrenier
Member
Members
Forum Posts: 11
Member Since:
February 4, 2021
sp_UserOfflineSmall Offline

Hello,

Thank you. We are currently testing your product. I will do that if needed.

October 3, 2022
17:19, EEST
Avatar
mgrenier
Member
Members
Forum Posts: 11
Member Since:
February 4, 2021
sp_UserOfflineSmall Offline

Hello,
To add dynamically an item we made the following test.

We create a collection group in prosys historian configurator
We insert a row in collectionitem (with an sql insert statement) with the information of an existing node (nodeId)

We see that:
* this nodes appears now in the collection item list of the Historian Configurator.
* the values of this node appears in valuehistory

Can we make this to use historian and add item dynamically ?

thank you

October 4, 2022
10:28, EEST
Avatar
Bjarne Boström
Moderator
Moderators
Forum Posts: 860
Member Since:
April 3, 2012
sp_UserOfflineSmall Offline

Hi,

“Yes”, but doing it like that will not be officially supported. The application should be the only one writing to the database, however some consideration was made to enable reading the data directly from the database.

Also I would assume in practice the historian service component must be shut down before doing any changes, otherwise the results might be undefined. Plus note that nothing prevents setting values manually which might be otherwise limited by the UI, which might cause a scenario that the UI could stop working, show wrong data or cause some other undefined result. But if you just make it so that the database would look exactly same as-if written from the UI while both the Configurator UI + the service component are shut down everything like should work.

NOTE!
Do not edit the schema however, all tables and columns need to be as they are, they are versioned (via liquibase lib) and basically any changes not made by the application itself to the schema will most likely cause it to not start (and in practice the schema must be dropped or reverted to the state it was before so that it is the application itself making the changes). Also this would most likely happen much later than doing schema edits, i.e. if a newer version of the application needed to do changes, it must be itself the one doing them (it will do checksums etc.).

October 4, 2022
11:53, EEST
Avatar
mgrenier
Member
Members
Forum Posts: 11
Member Since:
February 4, 2021
sp_UserOfflineSmall Offline

Hi,
I understand what you say. I fully agree and understand that it is not officially supported.
Thank you

Forum Timezone: Europe/Helsinki

Most Users Ever Online: 267

Currently Online:
9 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

hbrackel: 124

pramanj: 86

ibrahim: 74

rocket science: 65

kapsl: 57

Sabari: 51

gjevremovic: 49

Xavier: 43

fred: 41

TimK: 41

Member Stats:

Guest Posters: 0

Members: 1759

Moderators: 15

Admins: 1

Forum Stats:

Groups: 3

Forums: 15

Topics: 1323

Posts: 5649

Newest Members:

LenkaLok, seoninet, justinevillanuev, namtrott5457, DonaldWibip, AlfredoEthix, andreidla, everangel7021, Larryhed, agustincatts6

Moderators: Jouni Aro: 960, Otso Palonen: 32, Tuomas Hiltunen: 5, Pyry: 1, Petri: 0, Bjarne Boström: 860, Heikki Tahvanainen: 402, Jukka Asikainen: 1, moldzh08: 0, Jimmy Ni: 25, Teppo Uimonen: 21, Markus Johansson: 42, Niklas Nurminen: 0, Matti Siponen: 222, Lusetti: 0

Administrators: admin: 1