AGG Software Forums
September 20, 2024, 01:27:27 AM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Welcome on our forum!
 
   Home   Help Search Login Register  

Pages: [1]
  Print  
Author Topic: local database plug-in  (Read 12396 times)
oedge
Newbie
*

Karma: +0/-0
Posts: 4


View Profile
« on: May 24, 2016, 02:00:00 PM »

If I use the Create All button, two bad things happen.

1. All item are named OPC item..what's wrong with item1, item2, item3, etc?
2. Parser item names , which become the database field names, use dotted separation even though field names can't have dots in them, e.g.,DSGL.PLC.022 is an invalid field name. To get around this problem I can assign another name under OPC settings the problem is that I have hundreds of items so this only adds time to configuration.

I have hundreds of data points I want to log and to manually enter each item one by one would take days. The Create All button should create usable items.
Logged
Arthur Grasin
Tech. Support
Administrator
Hero Member
*****

Karma: +0/-0
Posts: 806



View Profile WWW
« Reply #1 on: November 23, 2011, 08:33:50 AM »

I would you suggest you to change a table structure. In your case the table may contain 3 columns only:

TIMESTAMP
ITEM_NAME
ITEM_VALUE

and this is optimal.
Logged
Pages: [1]
  Print  
 
Jump to:  

Powered by SMF 1.1.21 | SMF © 2015, Simple Machines