Read from another database

Use this forum to discuss possible implementation of a new feature before opening a ticket.
A developer shall edit the topic title with "[xxx]" where xxx is the id of the accompanying tracker id.
Duplicate posts about the same id. +1 posts are not allowed.

Moderators: leecollings, remb0

Post Reply
fantilator
Posts: 28
Joined: Saturday 12 November 2016 20:52
Target OS: NAS (Synology & others)
Domoticz version: 3.5877
Contact:

Read from another database

Post 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.
User avatar
Egregius
Posts: 2582
Joined: Thursday 09 April 2015 12:19
Target OS: Linux
Domoticz version: v2024.7
Location: Beitem, BE
Contact:

Re: Read from another database

Post 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.
Last edited by Egregius on Saturday 19 November 2016 23:43, edited 1 time in total.
fantilator
Posts: 28
Joined: Saturday 12 November 2016 20:52
Target OS: NAS (Synology & others)
Domoticz version: 3.5877
Contact:

Re: Read from another database

Post by fantilator »

Thanks for the information,
Do you have any clue on how to script this?
Unfortunately Googling does not show examples.
User avatar
Egregius
Posts: 2582
Joined: Thursday 09 April 2015 12:19
Target OS: Linux
Domoticz version: v2024.7
Location: Beitem, BE
Contact:

Re: Read from another database

Post 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.
fantilator
Posts: 28
Joined: Saturday 12 November 2016 20:52
Target OS: NAS (Synology & others)
Domoticz version: 3.5877
Contact:

Re: Read from another database

Post by fantilator »

Yes, my domoticz runs on the same Syno. Database is indeed Mariadb

I have no experience in PHP.

Thank you
MauraMClark
Posts: 1
Joined: Tuesday 20 December 2016 12:35
Target OS: Linux
Domoticz version:
Contact:

Re: Read from another database

Post 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.
User avatar
jenniehaleyson
Posts: 1
Joined: Friday 04 May 2018 16:10
Target OS: Windows
Domoticz version:
Location: San Jose
Contact:

Re: Read from another database

Post 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.
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests