|
Title: Advanced OPC Datalogger w/local db module Post by: oedge on November 16, 2011, 08:51:19 PM With local database type set to MS Access, on the Columns Order screen, I add the first item as Datetime (Parser item name = DATE_TIME_STAMP), and the second as TankTemp1 (Parser item name = AutomationDirect.KEPDirect.V5.Temp1). The database starts sucessfully with a table named SERIAL_DATA, which has two fields named Datetime Stamp, and OPC item.
If I add a third item named Temp2 (Parser item name = AutomationDirect.KEPDirect.V5.TankTemp2) the database field is create but it has no table. Instead I get an error: Local database Could not write to file (Cannot define field more than once). It seems to me that the local db module has a bug that tries to set all field names to OPC item. Is this correct or am I doing something wrong? Title: Re: Advanced OPC Datalogger w/local db module Post by: Arthur Grasin on February 24, 2016, 02:00:00 PM Could you please, create a backup of your current configuration (from the "File" menu) and attach it here? I'll verify it.
Title: Re: Advanced OPC Datalogger w/local db module Post by: oedge on March 22, 2016, 02:00:00 PM OK here it is....
Title: Re: Advanced OPC Datalogger w/local db module Post by: Arthur Grasin on April 01, 2016, 02:00:00 PM The problem with duplicate columns has been fixed. Please, download the update here:
http://www.aggsoft.com/download/localdb.exe Also, I would recommend to make the following changes: 1. In the OPC group settings disable the "Add server name" option (because the access doesn't allow long names). 2. In the "Local database" plugin change parser names to new values (without the server name). Title: Re: Advanced OPC Datalogger w/local db module Post by: oedge on April 22, 2016, 02:00:00 PM Great. Thanks a lot.
|