Our full technical support staff does not monitor this forum. If you need assistance from a member of our staff, please submit your question from the Ask a Question page.


Log in or register to post/reply in the forum.

How save to data table only when non zero value?


mortenx Nov 4, 2020 04:17 PM

I am using cr6 and raingauges and want to save to data table only when there is rain data and not lines with zeroes...

my prog:

DataTable(data1,True,-1)
' INTERVAL
DataInterval(0,1,Min,10)
TableFile ("CRD:data1",8,-1,500,0,Min,OutStat,LastFileName)

Totalize(1,Rain_mm_1,FP2,False)
Totalize(1,Rain_mm_2,FP2,False)
Totalize(1,Rain_mm_3,FP2,False)
Totalize(1,Rain_mm_4,FP2,False)
Totalize(1,Rain_mm_5,FP2,False)
Totalize(1,Rain_mm_6,FP2,False)
Totalize(1,Rain_mm_7,FP2,False)
EndTable


BeginProg

Scan(5,Sec,40,0)
'Default CR6 Datalogger Battery Voltage measurement 'BattV'
Battery(BattV)
'Default CR6 Datalogger Wiring Panel Temperature measurement 'PTemp_C'
PanelTemp(PTemp_C,50)
'Generic Tipping Bucket Rain Gauge measurement 'Rain_mm'
PulseCount(Rain_mm_1,1,U1,1,0,0.2,0)
PulseCount(Rain_mm_2,1,U2,1,0,0.2,0)
PulseCount(Rain_mm_3,1,U3,1,0,0.2,0)
PulseCount(Rain_mm_4,1,U4,1,0,0.2,0)
PulseCount(Rain_mm_5,1,U5,1,0,0.2,0)
PulseCount(Rain_mm_6,1,U6,1,0,0.2,0)
PulseCount(Rain_mm_7,1,U7,1,0,0.2,0)
'Call Data Tables and Store Data
CallTable data1
NextScan


mortenx Nov 5, 2020 02:23 AM

if i have multiple raingauges, can i use like this?

DataTable(vihm1,t_sum2 >0,-1)

DataInterval(0,1,Min,10)
TableFile ("CRD:vihm1",8,-1,500,0,Min,OutStat,LastFileName)
Totalize(1,Rain_mm_1,FP2,False)
Totalize(1,Rain_mm_2,FP2,False)
Totalize(1,Rain_mm_3,FP2,False)
Totalize(1,Rain_mm_4,FP2,False)
Totalize(1,Rain_mm_5,FP2,False)
Totalize(1,Rain_mm_6,FP2,False)
Totalize(1,Rain_mm_7,FP2,False)

t_sum2=Rain_mm_1+Rain_mm_2+Rain_mm_3+Rain_mm_4+Rain_mm_5+Rain_mm_6+Rain_mm_7

EndTable

Log in or register to post/reply in the forum.