#!/bin/sh
# File	: post_sunny_beam_data_to_pvoutput.sh
# By	: MaartenDeBoer.nl, 2015-01-17
# Subject	: script to upload SunnyBream data to PVoutput.org
#set -x
PGM="`basename $0|cut -d\. -f1`"
TMP="/tmp/${PGM}.$$"
LOG="${HOME}/log/${PGM}.log"
RESULT=""
UPLOADED="${HOME}/data/${PGM}.uploaded"

DATADIR="/media/SBEAM/SBEAM"

CURLTIMEOUT=60
PVOUTPUTKEY="1673227d21b19ecc40be377923276447b2a0a17d"
PVOUTPUTSID="25735"
PVOUTPUTURL="http://pvoutput.org/service/r2/addoutput.jsp"

#FILENAME="2014-12.CSV"
#FILENAME="2014-01.CSV"
FILENAME="2014-02.CSV"
FILENAME="2014-03.CSV"

echo "`date` ${PGM} started."|tee -a ${LOG}

# DAY-files
FILENAME="`ls -1 ${DATADIR}/20??-??.CSV|egrep -vf ${UPLOADED}| head -1`"
echo "  Uploading file: ${FILENAME}"|tee -a ${LOG}

cat ${FILENAME}|grep '\-20'|while read LINE
do
  YR="`echo ${LINE}|cut -d\; -f1|cut -d\- -f3`"
  MON="`echo ${LINE}|cut -d\; -f1|cut -d\- -f2`"
  DAY="`echo ${LINE}|cut -d\; -f1|cut -d\- -f1`"
  GEN="`echo ${LINE}|cut -d\; -f3|sed 's/,//g'`"

  echo "  ${YR}${MON}${DAY} ${GEN}"|tee -a ${LOG}

# d=Output Date [yyymmdd, date]
# g=Generated [number, watt hours]
  RESULT=$(/usr/bin/curl -s -S --max-time $CURLTIMEOUT  -d "d=${YR}${MON}${DAY}" -d "g=${GEN}" -H "X-Pvoutput-Apikey: $PVOUTPUTKEY" -H "X-Pvoutput-SystemId: $PVOUTPUTSID" $PVOUTPUTURL 2>&1)

  echo "  ${RESULT} "|tee -a ${LOG}

done  # cat

echo ${FILENAME} | tee -a ${HOME}/data/${PGM}.uploaded

echo "`date` ${PGM} finished."|tee -a ${LOG}
exit 0

# Hour-/status-files
# ... und hoch zu pvoutput.org
#result=`curl  -s  -d "d=$date" -d "t=$time" -d "v1=$etotal" -d "v6=$uac" -d "c1=1"  -H "X-Pvoutput-Apikey: $PV_API_KEY" -H "X-Pvoutput-SystemId: $PV_SYS_ID" http://pvoutput.org/service/r2/addstatus.jsp`
#
# d	Date	Yes	yyyymmdd	date	20100830	r1	
# t	Time	Yes	hh:mm	time	14:12	r1	
# v1	Energy Generation	No1	number	watt hours	10000	r1	
# v2	Power Generation	No	number	watts	2000	r1