there is no place like 127.0.0.1…
|
1 2 3 4 5 6 |
#!/bin/bash sqlite3 weewx.sdb << EOB .headers on .mode csv select * from archive; EOB |
|
1 |
sudo bash your_script_name.sh > your_csv_name.csv |
|
1 2 3 |
cat csv.csv | head -n 2 dateTime,usUnits,interval,altimeter,appTemp,appTemp1,barometer,batteryStatus1,batteryStatus2,batteryStatus3,batteryStatus4,batteryStatus5,batteryStatus6,batteryStatus7,batteryStatus8,cloudbase,co,co2,consBatteryVoltage,dewpoint,dewpoint1,ET,extraHumid1,extraHumid2,extraHumid3,extraHumid4,extraHumid5,extraHumid6,extraHumid7,extraHumid8,extraTemp1,extraTemp2,extraTemp3,extraTemp4,extraTemp5,extraTemp6,extraTemp7,extraTemp8,forecast,hail,hailBatteryStatus,hailRate,heatindex,heatindex1,heatingTemp,heatingVoltage,humidex,humidex1,inDewpoint,inHumidity,inTemp,inTempBatteryStatus,leafTemp1,leafTemp2,leafWet1,leafWet2,lightning_distance,lightning_disturber_count,lightning_energy,lightning_noise_count,lightning_strike_count,luminosity,maxSolarRad,nh3,no2,noise,o3,outHumidity,outTemp,outTempBatteryStatus,pb,pm10_0,pm1_0,pm2_5,pressure,radiation,rain,rainBatteryStatus,rainRate,referenceVoltage,rxCheckPercent,signal1,signal2,signal3,signal4,signal5,signal6,signal7,signal8,snow,snowBatteryStatus,snowDepth,snowMoisture,snowRate,so2,soilMoist1,soilMoist2,soilMoist3,soilMoist4,soilTemp1,soilTemp2,soilTemp3,soilTemp4,supplyVoltage,txBatteryStatus,UV,uvBatteryStatus,windBatteryStatus,windchill,windDir,windGust,windGustDir,windrun,windSpeed 1514764800,1,60,,44.7476088468686,,29.5358934975,,,,,,,,,2390.7952316639,,,,40.64,,,,,,,,,,,,,,,,,,,,,,,50.0,,,,50.0,,,,,,,,,,,,,,,,0.0,,,,,70.0,50.0,,,,,,,,0.0,,0.0,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,50.0,200.0,,,5.59235462984826,5.59235462984826 |
Nothing more to say, thank me later… 😉 Best format to import to meteobridge.
!!! you need to change the order from the csv. please check the header and compare… !!!
