Data Export

  • Hi
    I saw an issue about exporting the data to csv format and that the feature was dropped in the 0.0.3 release
    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?


    @esawyja This request completed partially. To access database:

  • aaah thank you once again @jkandasa

  • 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/ 
    Termination issued for 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
    root@mmm_gateway:/opt/temp# java -cp h2/bin/h2*.jar
    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
    User      mycontroller
    [Enter]   Hide
    Password  mycontroller
    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;
    (2 rows, 11 ms)
    sql> show tables;
    (0 rows, 19 ms)
    sql> quit
    Connection closed
    root@mmm_gateway:/opt/temp# /opt/mycontroller/bin/ 
    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/ -cp ../lib/* org.mycontroller.standalone.StartApp
    root     18434 18300  0 13:17 pts/0    00:00:00 grep myc

    Could you please point me in the right direction?


    @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:

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

Log in to reply