BasicDataLogger2 sql database

[Derek]

Using BasicDataLogger2 I'm inserting a row in MySql. I wish each PLC value that's in the PLCAddressValueItems would be inserted into one row. The issue is that each row contains one PLC value that alternates between the three values.

Can I make BasicDataLogger2 insert multiple columns into sql?

The three PLC value's are (Value1, Value2, and Value3) and the three MySql columns are (c1, c2, and c3).

Here is the code I'm using:

    Private Sub BasicDataLogger21_DataReturned(sender As Object, e As Drivers.Common.PlcComEventArgs) Handles BasicDataLogger21.DataReturned
        Using t As New DataSet.logDataTable
            t.AddlogRow(t.NewRow)
            t(0).c1 = e.Values(0)
            Using ta As New DataSetTableAdapters.logTableAdapter
                ta.Update(t)
            End Using
        End Using
    End Sub

I'm using Windows 10 Pro, Visual Studio 15.3.2, and AdvancedHMI v399x.

Thanks!

[Archie]

The DataReturned is going to fire separately for each tag value. You are going to have to save the value in a class scope variable, then when the last is returned, store to the DB.

 Private Value1, Value2 as string
 Private Sub BasicDataLogger21_DataReturned(sender As Object, e As Drivers.Common.PlcComEventArgs) Handles BasicDataLogger21.DataReturned
        if e.PLCAddress=DataSubscriber2.PLCAddressValueItems(0).PLCAddress Then
                 Value1=e.Values(0)
        ElseIf e.PLCAddress=DataSubscriber2.PLCAddressValueItems(1).PLCAddress Then
                  Value2=e.Values(0)
        Else
           Using t As New sasDataSet.nwpresslogDataTable, ta As New sasDataSetTableAdapters.nwpresslogTableAdapter
               t.AddnwpresslogRow(t.NewRow)
               t(0).c1 = Value1
               t(0).c2 = Value2
               t(0).c3 = e.Values(0)
               ta.Update(t)
           End Using
       End If
 End Sub

[Derek]

Private Value1, Value2 as string
 Private Sub BasicDataLogger21_DataReturned(sender As Object, e As Drivers.Common.PlcComEventArgs) Handles BasicDataLogger21.DataReturned
        if e.PLCAddress=BasicDataLogger21.PLCAddressValueItems(0).PLCAddress Then
                 Value1=e.Values(0)
        ElseIf e.PLCAddress=BasicDataLogger21.PLCAddressValueItems(1).PLCAddress Then
                  Value2=e.Values(0)
        Else
           Using t As New DataSet.logDataTable, ta As New DataSetTableAdapters.logTableAdapter
               t.AddlogRow(t.NewRow)
               t(0).c1 = Value1
               t(0).c2 = Value2
               t(0).c3 = e.Values(0)
               ta.Update(t)
           End Using
       End If
 End Sub

Thanks Archie!

This worked great.

[PLCTech]

I know this is an old post, but I am trying to use it so that I get all of the data at once from the DataLogger2 rather than as each piece of information is fired. However I don't understand where this code needs to be set up as it fails when I build the application:

Using t As New sasDataSet.nwpresslogDataTable, ta As New sasDataSetTableAdapters.nwpresslogTableAdapter

All of the other code I can modify (it seems to build OK, except for this section). I am not really a VB programmer, ladder logic is my forte!

Thanks

[Phrog30]

If you don't know what it does, just comment it out and hope for the best.

[Archie]

I don't understand where this code needs to be set up as it fails when I build the application:

Using t As New sasDataSet.nwpresslogDataTable, ta As New sasDataSetTableAdapters.nwpresslogTableAdapter

Did you use the Data Sources tool to create a Data Source?

[PLCTech]

That is what I was thinking I would have to do, but I am lost when it comes to that!

[Archie]

It is fairly straight forward because there are wizards to walk you through the process. Start by going to Project->Add New Data Source

[Archie]

Once you select Add New Data Source, select the Database option
The next window will give you a button to add a new connection
Select that and enter the information about your database
After that, select the table you want to store the data in

The original thread used a BasicDataLogger2 which is kind of redundant if you want to store to a database. The BasicDataLogger stores to a text file. If you do not need the text file, a DataSubcriber2 is more fitting.

[PLCTech]

I would like to save it to a text file (.log). Do you still have to create a Data Source?

[Archie]

I would like to save it to a text file (.log). Do you still have to create a Data Source?

In that case, none of this stuff really applies. Simply add the BasicDataLogger2 to your form and use PLCAddressItems to list the addresses you want to log.

[PLCTech]

That is what I am currently doing. I am also using the script that I found on here that makes a new file for each day. The issue is I get multiple entries in the .log file each time one of the datapoints I am monitoring changes state. I am guessing that it is due to their location in the PLC and the scan time of the PLC. They do not all update at once.

[Archie]

The issue is I get multiple entries in the .log file each time one of the datapoints I am monitoring changes state. I am guessing that it is due to their location in the PLC and the scan time of the PLC. They do not all update at once.

Multiple lines or a comma separated list of all the values?

[PLCTech]

Multiple lines. Each line has a different value for the comma separated values and a different time stamp.

Jan-29-19 12:45:48:175,,44,72
Jan-29-19 12:45:48:284,False,44,72

In the first line the first comma separated value was not read, then in the second line it was. I am reading three separate points in a PLC. The False indicates that the machine is not running, the 44 is the Machine ID number and the 72 is the downtime reason.

[Archie]

Typically your will have a few lines with no values until it had a chance to read them all. So if you have 5 values to log, you may see up to 4 lines initially with missing values. Is this what you want to eliminate?