Access networked thermostats and post status to db
$30-250 USD
Завершено
Опублікований over 10 years ago
$30-250 USD
Оплачується при отриманні
I have a devi-net installation of 13 room thermostats which control underfloor heating. The devicom PC pro software which comes with them does not meet my needs as I wish to have a program running continuously which will interrogate all the stats say every 60 seconds and update the results of the room temperature and relay status of each into a data base.
See the devinet API manual attached to this.
I do not particularly mind which language the software to achieve this is written in although I would prefer python27 if possible. It needs to run on Windows XP and I would like access to the source code for any small mods I may need to make. The network of stats are accessed via Com port 4.
Each stat has a node address as referred to in the API and as shown in brackets on the attached screen shot. The data base to be updated with the room temperature and relay status of each stat is a mysql db named ter with a table named terstatus. Path details as follows:
cd C:\Program Files\MySQL\MySQL Server 5.5\bin
mysql -u root -ppass
use ter
the db is already set up with the following table names: Name, State, ID, Code.
Name is the room name, State will contain the relay status, ID the node address and Code the room temperature.
So an example of the db update needed would be:
UPDATE terstatus SET State = 'On', Code = '22.5' where ID = '1ED40B';
Please let me know if you can write me a nice compact program to achieve this, the proposed language, cost and time frame to complete. If you need any more info or clarification of what I need please just ask.
Thanks
Cost and timeframe are in the bid, as for time to implement, a lot would depend on message turnaround from yourside (as i have no access to the enviroment to test)
Used language: C# (using provided libraries for devinet for fast, lowcost and reliable product)
To configure Port and database connection , an XML would be provided for easi configuration.
Problem as i understand it:
Every n seconds,
read valie from each thermostat in devinet network on COM4
and update the record in MySQL database
Python may be possible but would require more time, testing and would cost more (as there is no library for Devinet for Python).
Looking forward hearing from you
Have a nice day
$150 USD за 7 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
5 фрілансерів(-и) готові виконати цю роботу у середньому за $187 USD
Hi
I have gone through the details of your project and we find it well within our capabilities. I offer a wide range of services, including Web design, PHP/MySQL web application development, Open sources like Joomla, Os-commerce, Zen cart-Drupal I can create and deliver the project as per the information.I have skilled, expert programmers I'm very excited to assist you in making your Sites successful – please feel free to contact me directly to discuss this position further. Thanks
Hi,
Greetings from KrishnaInfotech!!
I can surely do this job for you.
Expert here on IT hardware,software ,networking,security and wireless communication.
Kindly contact to avail best quality of services.
Awaiting to hear from you soon.
Kind Regards