--- /dev/null
+#!/bin/sh
+
+rm -Rf /tmp/export
+mkdir /tmp/export
+
+pattern='.'
+test ! -z "$1" && pattern=$1
+
+cat subvision-numbers.txt | grep "$pattern" | while read sensor pn imei name offset ; do
+ echo "# $sensor [$pn]";
+ echo "\COPY (select * from zc where pn = $pn) TO '/tmp/export/$sensor.csv' DELIMITER ',' CSV HEADER" | psql zc
+ wget -O /tmp/export/$sensor.svg https://senzori.subvision.hr/cgi-bin/by_temp.cgi?$pn
+ mkdir /tmp/export/$sensor
+ cp -v /dev/shm/by_temp.$pn*.txt /tmp/export/$sensor
+done
+