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.
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.