Page 1 of 1

Read from another database

Posted: Saturday 19 November 2016 19:42
by fantilator
I'm having a TE923 compatible weatherstation runnin and login onto my Synology NAS,
instead of configuring it to work with Domoticz, is it possible to pull the data from the database?

I also have a corporate database who captures data from other sensors offsite.
If the possibility is hete to pull data from the database then I can automate more stuff.

Kind regards.

Re: Read from another database

Posted: Saturday 19 November 2016 21:49
by Egregius
If you can access the database you can retrieve and sent every data you want.
just create a script that pulls the data and sends it to Domoticz and run it by cron.

Re: Read from another database

Posted: Saturday 19 November 2016 22:07
by fantilator
Thanks for the information,
Do you have any clue on how to script this?
Unfortunately Googling does not show examples.

Re: Read from another database

Posted: Saturday 19 November 2016 23:42
by Egregius
Is Domoticz on the same Syno as the database?
The database is a MySQL database in MariaDB?
Do you know something about PHP?
I can only help in PHP, that's the only language I know.

Re: Read from another database

Posted: Thursday 15 December 2016 16:44
by fantilator
Yes, my domoticz runs on the same Syno. Database is indeed Mariadb

I have no experience in PHP.

Thank you

Re: Read from another database

Posted: Tuesday 20 December 2016 12:43
by MauraMClark
I have a corporate database too. I work at https://help.plagtracker.com/resume-editing.html and I'm searching for any help to structure it. All I knew about it before does not work, thanks for ideas.

Re: Read from another database

Posted: Friday 04 May 2018 16:29
by jenniehaleyson
just create a script that pulls the data and sends it to Domoticz and run it by cron.

Please could you share at least short instructions on this item? I do not quite understand the sequence of actions.