AnsweredAssumed Answered

Having Error storing the string Value.

Question asked by ImranPowerWater on Aug 19, 2020
Latest reply on Aug 20, 2020 by ImranPowerWater

Hi Everyone.

I am having error saying  19-Aug-20 08:38:10 PI_UFL:PI_UFL:BOM_DARWIN_AIRPORT | 45 | 0 (0)
>> [Line 120] [StoreInPI] [Error] Cannot convert ESE from String to R8. For each string in the column. Attach is the .csv file and below is the ini file. The highlighted syntax doesn't apart from everything working fine. Any kind of help would highly be appreciated and Thanks in Advance.

[FIELD]
FIELD(1).NAME="Date"
FIELD(1).TYPE="DateTime"
FIELD(1).FORMAT="d/MM/yyyy"
FIELD(2).NAME="Min_Temp"
FIELD(2).TYPE="Number"
FIELD(3).NAME="Max_Temp"
FIELD(3).TYPE="Number"
FIELD(4).NAME="Rainfall"
FIELD(4).TYPE="Number"
FIELD(5).NAME="Evaporation"
FIELD(5).TYPE="Number"
FIELD(6).NAME="Sunshine_hrs"
FIELD(6).TYPE="Number"
FIELD(7).NAME="Wind_MaxSpeed"
FIELD(7).TYPE="String"
'FIELD(8).NAME="Gust_Timing"
'FIELD(8).TYPE="Time"
'FIELD(8).FORMAT="h:m:ss"
FIELD(9).NAME="Temp_9am"
FIELD(9).TYPE="Number"
FIELD(10).NAME="RH_9am"
FIELD(10).TYPE="String"
FIELD(11).NAME="Cloud_9am"
FIELD(11).TYPE="Number"
FIELD(12).NAME="Windspeed_9am"
FIELD(12).TYPE="String"
FIELD(13).NAME="MSL_Pressure_9am"
FIELD(13).TYPE="Number"
FIELD(14).NAME="Temp_3pm"
FIELD(14).TYPE="Number"
FIELD(15).NAME="RH_3pm"
FIELD(15).TYPE="String"
FIELD(16).NAME="Cloud_3pm"
FIELD(16).TYPE="Number"
FIELD(17).NAME="Windspeed_3pm"
FIELD(17).TYPE="String"
FIELD(18).NAME="MSL_Pressure_3pm"
FIELD(18).TYPE="Number"
FIELD(19).NAME="Attributes"
FIELD(19).TYPE="Collection"
FIELD(20).NAME="TagPrefix"
FIELD(20).TYPE="String"

FIELD(21).NAME="WindDir"
FIELD(21).TYPE="String"

 

 

[MSG]
MSG(1).NAME="Header"
MSG(1).EPC="Float64"
MSG(2).NAME="MSG_2"
MSG(2).EPC="Float64"

[Header]
Header.FILTER=C1=="O"
TagPrefix=C54 - C59

[MSG_2]
MSG_2.FILTER=C1=="*"
Date=[",(*),*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*"]
Min_Temp=[",*,(*),*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*"]
Max_Temp=[",*,*,(*),*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*"]
Rainfall=[",*,*,*,(*),*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*"]
Evaporation=[",*,*,*,*,(*),*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*"]
Sunshine_hrs=[",*,*,*,*,*,(*),*,*,*,*,*,*,*,*,*,*,*,*,*,*,*"]
Wind_MaxSpeed=[",*,*,*,*,*,*,*,(*),*,*,*,*,*,*,*,*,*,*,*,*,*"]

WindDir=[",*,*,*,*,*,*,(*),*,*,*,*,*,*,*,*,*,*,*,*,*,*"]


Temp_9am=[",*,*,*,*,*,*,*,*,*,(*),*,*,*,*,*,*,*,*,*,*,*"]
RH_9am=[",*,*,*,*,*,*,*,*,*,*,(*),*,*,*,*,*,*,*,*,*,*"]
Cloud_9am=[",*,*,*,*,*,*,*,*,*,*,*,(*),*,*,*,*,*,*,*,*,*"]
Windspeed_9am=[",*,*,*,*,*,*,*,*,*,*,*,*,*,(*),*,*,*,*,*,*,*"]
MSL_Pressure_9am=[",*,*,*,*,*,*,*,*,*,*,*,*,*,*,(*),*,*,*,*,*,*"]
Temp_3pm=[",*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,(*),*,*,*,*,*"]
RH_3pm=[",*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,(*),*,*,*,*"]
Cloud_3pm=[",*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,(*),*,*,*"]
Windspeed_3pm=[",*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,(*),*"]
MSL_Pressure_3pm=[",*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,*,(*)"]

if(Windspeed_9am == "Calm" OR Windspeed_3pm == "Calm" OR Wind_MaxSpeed == "Calm")

'if(ISNUMBER(Windspeed_9am == "Calm" OR Windspeed_3pm == "Calm" OR Wind_MaxSpeed == "Calm") == 1)
THEN
Windspeed_9am = REPLACE(Windspeed_9am,"Calm","0")
Windspeed_3pm = REPLACE(Windspeed_3pm,"Calm","0")
Wind_MaxSpeed =REPLACE(Wind_MaxSpeed,"Calm","0")
ENDIF

Attributes=Clear()
Attributes=Add("excdev",0)
Attributes=Add("excdevpercent",0)
Attributes=Add("compdev",0)
Attributes=Add("compdevpercent",0)
Attributes=Add("excmax",60)
Attributes=Add("excmin",0)
Attributes=Add("compmax",0)
Attributes=Add("compmin",0)

 

StoreInPIPoints("Wind_Direction",,"Float64",Attributes)
StoreInPI("Wind_Direction",,Date,WindDir, , )

Attachments

Outcomes