AnsweredAssumed Answered

Having Error Storing String Values.

Question asked by ImranPowerWater on Aug 19, 2020

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