AGG Software Forums

Online Help Center => Data loggers and plug-ins => Topic started by: oedge on May 24, 2016, 02:00:00 PM



Title: local database plug-in
Post by: oedge 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.


Title: Re: local database plug-in
Post by: Arthur Grasin 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.