Data Export

[esawyja]

Hi
I saw an issue about exporting the data to csv format and that the feature was dropped in the 0.0.3 release
https://github.com/mycontroller-org/mycontroller/issues/361
But is there ANY way that I can export the data for a particular sensor, while we wait for the next release please, maybe some kind of script please or just some commands on how to view the H2 database?
Regards

[jkandasa]

@esawyja This request completed partially. To access database: http://forum.mycontroller.org/topic/18/forgotten-password

[esawyja]

aaah thank you once again @jkandasa

[esawyja]

Hi @jkandasa
I don't know if I'm doing something weird, but I get this below

pi@mmm_gateway:~ $ sudo -i
root@mmm_gateway:~# /opt/mycontroller/bin/stop.sh 
Termination issued for Mycontroller.org server!
root@mmm_gateway:~# ps -ef | grep myc
root     18358 18300  0 13:14 pts/0    00:00:00 grep myc
root@mmm_gateway:~# cd /opt/temp
root@mmm_gateway:/opt/temp# ls -ltr
total 30648
-rw-r--r-- 1 root root  7791840 Apr  5  2014 h2-2014-04-05.zip
root@mmm_gateway:/opt/temp# java -cp h2/bin/h2*.jar org.h2.tools.Shell

Welcome to H2 Shell 1.3.176 (2014-04-05)
Exit with Ctrl+C
[Enter]   jdbc:h2:~/test
URL       jdbc:h2:/opt/mycontroller/conf/mycontroller
[Enter]   org.h2.Driver
Driver    org.h2.Driver
[Enter]   
User      mycontroller
[Enter]   Hide
Password  mycontroller
Connected
Commands are case insensitive; SQL statements end with ';'
help or ?      Display this help
list           Toggle result list / stack trace mode
maxwidth       Set maximum column width (default is 100)
autocommit     Enable or disable autocommit
history        Show the last 20 statements
quit or exit   Close the connection and exit

sql> select * from user;
Error: org.h2.jdbc.JdbcSQLException: Table "USER" not found; SQL statement:
select * from user [42102-176]
sql> show databases;
SCHEMA_NAME
INFORMATION_SCHEMA
PUBLIC
(2 rows, 11 ms)
sql> show tables;
TABLE_NAME | TABLE_SCHEMA
(0 rows, 19 ms)
sql> quit
Connection closed
root@mmm_gateway:/opt/temp# /opt/mycontroller/bin/start.sh 
/usr/bin/java
java version: 1.8.0_65
Start issued for Mycontroller
root@mmm_gateway:/opt/temp# ps -ef | grep myc
root     18403     1 99 13:16 pts/0    00:00:08 java -Xms8m -Xmx150m -Dlogback.configurationFile=../conf/logback.xml -Dmc.conf.file=../conf/mycontroller.properties -cp ../lib/* org.mycontroller.standalone.StartApp
root     18434 18300  0 13:17 pts/0    00:00:00 grep myc
root@mmm_gateway:/opt/temp# 

Could you please point me in the right direction?

[jkandasa]

@esawyja Steps you have followed are right. You have to check which version of H2 database are you using in your MyController. Status >> About

And download suitable version from here: http://www.h2database.com/html/download.html

[esawyja]

Thanks again @jkandasa , After downloading the correct version, I got it working!