AnsweredAssumed Answered

UFL connector .ini error [1, [Error] . Value start/end is incorrect.]

Question asked by jessica.ewy on Aug 16, 2018
Latest reply on Aug 17, 2018 by jessica.ewy

Hello,

 

I am working on setting up the UFL connector to parse a JSON file. I have a powershell script which calls for a JSON file and stores the file in a local folder when the script is run. The connector is set to parse this file when it updates.

 

I am working on the .ini file and have not been able to find an answer to the issue I am encountering. The timestamps on the incoming data are in milliseconds since unix epoch. I have tried several different configurations for the .ini file but continue getting the error [1, [Error] . Value start/end is incorrect.]. I believe this issue has to do with the timestamp pulled from my data.

 

I have tried several different configurations (one of the iterations is below), changing the data type and converting between units, even tried typing in the timestamp as a string, but continue to get the same error.

 

The final result I would like to get is to convert the milliseconds since unix epoch to seconds GMT and use this as the timestamp to send data to PI.

 

Here is a sample of my .ini file:

 

'===========Define Variables==========

                [FIELD]

                FIELD(1).Name = "OpICAO"        

                FIELD(2).Name = "Epochms"

                FIELD(2).Type = "Number"

                FIELD(3).Name = "Epochs"

                FIELD(3).Type = "Number"

                FIELD(4).Name = "Epochs2"

                FIELD(4).Type = "String"

                FIELD(5).Name = "UpdateTime"

                FIELD(5).Type = "DateTime"

                FIELD(5).Format = "SECONDS_GMT"

 

                '==============Define Message Statements========

 

                [MSG]

                MSG(1).Name = "Data"

               

                '============Extract data=============

                '==========Store PI Points======

 

                [Data]

                Data.FILTER = C1 == "*"

 

                FOREACH (JsonGetItem(__MESSAGE, "acList[]")) DO

               

                                Epochms = JsonGetValue(__ITEM, "PosTime")

                                Epochs = Epochms/1000

                                Epochs2 = Epochs

                                UpdateTime = Epochs2

 

                                OpICAO = JsonGetValue(__ITEM, "OpIcao")

                               

                                StoreEvent(OpICAO + "_" + "OpIcao",, UpdateTime, OpICAO)

 

                ENDFOR

 

 

 

And the JSON file:

 

{

"src":  1,

"acList":  [

                   {

                       "PosTime":  1534443670620,

                       "OpIcao":  "HAL"

                   },

                   {

                     "PosTime": 1534443635339,

                     "OpIcao": "HAL"

                     }

                    ],

    "stm":  1534443671895

}

 

 

Any ideas would be much appreciated.

Regards,

Outcomes