Find Jobs
Hire Freelancers

Access networked thermostats and post status to db

$30-250 USD

Completed
Posted over 10 years ago

$30-250 USD

Paid on delivery
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
Project ID: 5343450

About the project

5 proposals
Remote project
Active 10 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
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 in 7 days
0.0 (0 reviews)
0.0
0.0
5 freelancers are bidding on average $187 USD for this job
User Avatar
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
$185 USD in 8 days
4.8 (104 reviews)
6.6
6.6
User Avatar
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
$250 USD in 15 days
5.0 (1 review)
3.5
3.5

About the client

Flag of UNITED KINGDOM
Stirling, United Kingdom
5.0
2
Member since Oct 26, 2008

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.