AGG Software Forums

Allo,

I am using Advanced TCP-IP data Logger, Sample configuration below.
My question is about DATE_TIME_STAMP and DATA_SOURCE_FULL_NAME, I would like to be able to calculate the elapsed time between the last data received and of the same DATA_SOURCE_FULL_NAME.

For example I received Data at 6/24/2013 1:58:29 PM from 172.24.129.1:10003
and previously received Data at 6/24/2013 1:56:03 PM from 172.24.129.1:10003

I would love to be able to do the calculation as I receive this data. In this case 6/24/2013 1:58:29 PM - 6/24/2013 1:56:03 PM = 00:02:26 or 156 seconds.

Is this possible? Then I can just send this up to the sql server.

Thanks.


Name=SQL#1
SQL=insert+into+DATA%0D%0A(FULL_DATA_PACKET%2C+DATA_PACKET%2C+DATE_TIME_STAMP%2C+DATA_SOURCE_ID%2C+DATA_SOURCE_NAME%2C+DATA_SOURCE_FULL_NAME%2C+CLIENT_ID%2C+PART_%23%2C+P_TYPE%2C+PROBE%2C+AX0%2C+AZ0%2C+AX1%2C+AZ1%2C+AX2%2C+AZ2%2C+AX3%2C+AZ3%2C+AX4%2C+AZ4%2C+AX5%2C+AZ5%2C+AX6%2C+AZ6%2C+BX0%2C+BZ0%2C+BX1%2C+BZ1%2C+BX2%2C+BZ2%2C+BX3%2C+BZ3%2C+BX4%2C+BZ4%2C+COUNTER)+%0D%0AVALUES++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++%0D%0A(%3AP1%2C+%3AP2%2C+%3AP3%2C+%3AP4%2C+%3AP5%2C+%3AP6%2C+%3AP7%2C+%3AP8%2C+%3AP9%2C+%3AP10%2C+%3AP11%2C+%3AP12%2C+%3AP13%2C+%3AP14%2C+%3AP15%2C+%3AP16%2C+%3AP17%2C+%3AP18%2C+%3AP19%2C+%3AP20%2C+%3AP21%2C+%3AP22%2C+%3AP23%2C+%3AP24%2C+%3AP25%2C+%3AP26%2C+%3AP27%2C+%3AP28%2C+%3AP29%2C+%3AP30%2C+%3AP31%2C+%3AP32%2C+%3AP33%2C+%3AP34%2C+%3AP35)+++++++++++++++++++%0D%0A%0D%0A
QueryType=No
SendBack=No
IgnoreErrors=No
Parameter=P1|FULL_DATA_PACKET (Full data packet)|String|
Parameter=P2|DATA_PACKET (Data packet)|String|
Parameter=P3|DATE_TIME_STAMP (Datetime stamp)|DateTime|
Parameter=P4|DATA_SOURCE_ID (Data source ID)|Integer|
Parameter=P5|DATA_SOURCE_NAME (Data source name)|String|
Parameter=P6|DATA_SOURCE_FULL_NAME (Data source full name)|String|
Parameter=P7|CLIENTID (Client ID)|Integer|
Parameter=P8|PART_A (Part_# (PART_A))|String|
Parameter=P9|PROD_TYPE (Prod_type (PROD_TYPE))|Integer|
Parameter=P10|PROBE (Probe (PROBE))|Float|
Parameter=P11|AX0 (AX0)|Float|
Parameter=P12|AZ0 (AZ0)|Float|
Parameter=P13|AX1 (AX1)|Float|
Parameter=P14|AZ1 (AZ1)|Float|
Parameter=P15|AX2 (AX2)|Float|
Parameter=P16|AZ2 (AZ2)|Float|
Parameter=P17|AX3 (AX3)|Float|
Parameter=P18|AZ3 (AZ3)|Float|
Parameter=P19|AX4 (AX4)|Float|
Parameter=P20|AZ4 (AZ4)|Float|
Parameter=P21|AX5 (AX5)|Float|
Parameter=P22|AZ6 (AZ6)|Float|
Parameter=P23|AX6 (AX6)|Float|
Parameter=P24|AZ6 (AZ6)|Float|
Parameter=P25|BX0 (BX0)|Float|
Parameter=P26|BZ0 (BZ0)|Float|
Parameter=P27|BX1 (BX1)|Float|
Parameter=P28|BZ1 (BZ1)|Float|
Parameter=P29|BX2 (BX2)|Float|
Parameter=P30|BZ2 (BZ2)|Float|
Parameter=P31|BX3 (BX3)|Float|
Parameter=P32|BZ3 (BZ3)|Float|
Parameter=P33|BX4 (BX4)|Float|
Parameter=P34|BZ4 (BZ4)|Float|
Parameter=P35|COUNTER (Counter (COUNTER))|Integer|

It is possible with help of the Script Execute plugin. You'll need to create a script that will hold a previous value of DATE_TIME_STAMP for each data source and calculate the difference. Please, look at examples at the plugin folder.