Hi Iain.
Thanks you for tanking us on your journey.
I have read your posts with interest and I'm sure others have as well
So Obvious.......
-
medelec35
- Valued Contributor
- Posts: 2336
- http://meble-kuchenne.info.pl
- Joined: Wed Dec 02, 2020 11:07 pm
- Has thanked: 729 times
- Been thanked: 785 times
-
chipfryer27
- Valued Contributor
- Posts: 2040
- Joined: Thu Dec 03, 2020 10:57 am
- Has thanked: 447 times
- Been thanked: 674 times
Re: So Obvious.......
Thanks Martin
Once working it is my intent to give a block diagram of the circuit and post my chart.
Not sure yet if I'm going to do something with App Developer as MQTT Alert does what I need, although not exactly as I'd like.
Regards
Once working it is my intent to give a block diagram of the circuit and post my chart.
Not sure yet if I'm going to do something with App Developer as MQTT Alert does what I need, although not exactly as I'd like.
Regards
-
chipfryer27
- Valued Contributor
- Posts: 2040
- Joined: Thu Dec 03, 2020 10:57 am
- Has thanked: 447 times
- Been thanked: 674 times
Re: So Obvious.......
Hi
As the primary objective in all of this is to document activity within my house I need a way to store it and my RAMP is ideal. Not having used it it a while I needed to refamiliarise myself. I posted a guide ages ago and following it things quickly came back.
Biggest problems was what to name my database, what table(s) should it contain and what data should be in the tables? No doubt I'll change what I have but it will do for now. My Fields include ID number, Timestamp, Device, Location and Status which is updated by Flowcode.
Simulating it all worked relatively OK, updating both MQTT and database and any issues I saw I put down to simulation.
Before mounting everything to the wall, I thought to test the code on hardware...... Not good.......
I remember now why that ESP was sitting doing nothing..... It's truly useless.... It has a wifi range of about 50 centimetres.... I don't know why I didn't through it away when I discovered it, but it has came back to bite me now.
Too late in the day to mess further, especially as a nice red is desperately wanting to come out and play...
Regards
As the primary objective in all of this is to document activity within my house I need a way to store it and my RAMP is ideal. Not having used it it a while I needed to refamiliarise myself. I posted a guide ages ago and following it things quickly came back.
Biggest problems was what to name my database, what table(s) should it contain and what data should be in the tables? No doubt I'll change what I have but it will do for now. My Fields include ID number, Timestamp, Device, Location and Status which is updated by Flowcode.
Simulating it all worked relatively OK, updating both MQTT and database and any issues I saw I put down to simulation.
Before mounting everything to the wall, I thought to test the code on hardware...... Not good.......
I remember now why that ESP was sitting doing nothing..... It's truly useless.... It has a wifi range of about 50 centimetres.... I don't know why I didn't through it away when I discovered it, but it has came back to bite me now.
Too late in the day to mess further, especially as a nice red is desperately wanting to come out and play...
Regards