Coole Sache! Mach doch auch mal ein paar youtube Videos dazu. Würde gerne eine "tachonadelposition" auslesen... dafür wäre ein Beispiel toll! :)

Hey, vielen Dank dass du die Software geschrieben und veröffentlicht hast. Ich hatte genau nach so etwas gesucht.

@@theincapable Rechne nicht mit einem kommentar - hat auf meins seit 2 monaten nicht reagiert...

Hallo Frank, mir ist nicht ganz klar, auf wessen Kommentar du wartest. Von mir oder von Joseph Müller? Joseph, alias "jomjol", erreicht ihr besser per Github. Wenn ihr ein Thema habt, könnt ihr ja dort ja einen Feature Request machen. Ich selbst werde hier sicher noch das eine oder andere Video machen, da das aber viel aufwändiger ist, als ich zunächst dachte, wird es zum Thema AI-on-the-edge so schnell kein Video mehr geben. Insbesondere, weil ich selbst das Tachonadelposition nicht habe. Aber UKposts ist ja zum Glück offen für alle. Wenn du Lust hast, @Frank Müller, kannst du dich ja selbst in das Thema reinfuchsen und ein kurzes Video dazu machen. Wie du siehst, gibt es eine große, interessierte Community.

@@MakerMeik Vielen Dank für deine ausführliche Antwort und deinen tollen Tipp mit Github. Das weiss ich wirklich zu schätzen. Bleib gesund und weiter so, Frank

Thanks, I'm very glad you like it. In fact, I had also been looking for a solution for a while and was more than happy that jomjol launched this project.

why simplier? counting increments is a relative measurement and you need the absolute offset to know the exact value. then a foolproof way of detecting and sensing the counts over a long period of time. taking a picture (maybe saving it) and extracting numbers from it is absolute, even if your algorithm fails you have the picture as backup.

@@nyeleskettes ķìď09OK6KDLLLLKKII I

Thank you very much for your donation, I appreciate it very much 😊

@MakerMeik Ich war wohl zu voreilig. Bei mir "hängt" die WebUI immer wieder und es geht nicht weiter (Beim letzten Schritt, nachdem ich die Zahlen alle definiert habe). Wie lange muss man denn da warten ? Was kann ich tun, damit das klappt ? Werden die Nachkommastellen (die "Uhrzeiger") ebenfalls als ROI versorgt ? Woher weiss die Software, dass es sich um die Nachkommastellen handelt ? Dazu habe ich leider nichts gefunden. Ich hoffe, Du kannst mir helfen. Vg

Ok. Jetzt bin ich ein Stückchen weiter. Ich bin nun bis zur letzten Seite gekommen, bevor die Webseite gehangen hat. Ich habe dann in der config.ini einfach das "Setupmode" auf false gesetzt. Nun klappt es einigermassen. Danke nochmal für das tolle Video

Yes, definitely healthier and works with enameled wires too. I use a knife or cutters to scrape the isolation off but grinding paper is probably a better choice

And not having the leds on all the time saves energy. Eco friendly :)

I would recommend you to build a classic iot-stack. I.e. you install the Grafana service on a Raspberry Pi for graphical analysis, in addition to Mosquitto, InfluxDB and Node-RED. Alternatively, Homeassistant is also a good choice. However, the data can then only be accessed within your network, i.e. via LAN/WLAN. Therefore a additional VPN access to your network is a good idea. With the Fritzbox routers from AVM, which are widely used in Germany, you can set this up quite comfortably. Even better, although not as easy, is WireGuard on the above mentioned Raspberry Pi. The advantage of a VPN is that your smartphone then "behaves" as if you were in your own Wi-Fi network, even if you are on the road. However, if you want to share your Grafana graphs with the general public, you'll need to install Apache on your Raspi and share Grafana via reverse proxy. This all sounds more complicated than it is. You should start by setting up the iot stack (Grafana, Mosquitto, InfluxDB, Node-RED). Here is a good tutorial: ukposts.info/have/v-deo/mWaenqpvq42G2Kc.html I can highly recommend all of this and if you expect to add many more sensors, it is definitely worth the effort. Above all, these are all open source projects that no manufacturer can simply take away from you. In addition, the data is then exclusively with you on a hardware that you control yourself. But of course there are also commercial solutions. Then you can upload your data to their server and have them directly online in the web. This is certainly more convenient, but you are very tied to one provider. And if they decide to stop offering their service (for free), you will have difficulties to move your data to another place.

Wow ... I hope the effort was worth it for you. However, I must say that the exact curve of the counter is really insightful. And with your project you surely learned more than just the pure characteristic curve of the demand. The project shown here works really well. But of course you should not expect perfection. However, I think that the full potential has not yet been reached on the software side.

@@MakerMeik yes it was worth it. First it magically stopped the leak (when other inhabitants probably did what was necessary to avoid appearing on the graphs). Second I learned a lot on various plans in this project, including the fact that the moist in the basement made the motherboard age very quickly. In ~5 months or so, there were signs of advanced corrosion!

great. I thought removing the led was too extreme. it can easily covered with something.

Thanks for your feedback and estimation. In the meantime, Andreas Spiess has made a great video that sheds some more light on the brownout issues: ukposts.info/have/v-deo/mZqla6yrnoF_r4E.html

The 50 ohm of a coax cable is the wave resistance of this cable, not a "real" resistance you can measure with an ohm meter.

I just had to try this out immediately. Unfortunately, it has not worked with my copper enamel wire and my wife's nail polish remover, although this is actually acetone-based. So it may depend on the varnish of the wire. Nevertheless, a great tip and I will test it again with my next spool ;-)

Freut mich sehr, dass dir mein Video gefällt. Als ich jomjols Projekt entdeckt hatte, habe ich auch direkt ein paar ESP32-cams bestellt. Die müssten jomjol eigentlich am Gewinn beteiligen ;-)

I think just use IR and phototransistor both facing the black rotating wheel will do or the needle.it will give you a pulsing voltage .but you need to cover the whole to avoid external light. Maybe its possible use hall effect sensor because i torn a meter ,it uses a magnetic coupling .

​@@pinoyenginerd1091 it might be better to use a reed switch and a magnet. In such a case MCU might deep sleep till interrupt.

There is a solution with an IR sensor shown on the Bitbastelei channel. The video is unfortunately only available in German, but maybe you can help yourself with the subtitles. Actually, the pictures already show most of it: ukposts.info/have/v-deo/mopyjpl_q6p3wok.html Battery powered solutions are always difficult. Especially because the standard D1 minis don't support real deep sleep. But with a little trick you can do it. If you don't know this yet, Andres Spiess showed it in one of his videos: ukposts.info/have/v-deo/qpaBq4Wrpn2AlXk.html To achieve the longest possible battery life, I would perhaps not connect the MCU every time with the Wifi but only briefly wake up to log. And then e.g. only every 15 min via Wifi to send the data.

@@MakerMeik In general, the modification should be not invasive because the meter is a certified device. www.instructables.com/Monitoring-residential-water-usage-by-reading-muni/

@Vladimir Kuznetsov Sure, you are not allowed to modify the official meter, of course. The method with the magnetic field and the reed- or hall-effect-sensor did not work with my water meter. Maybe the magnetic field was just too weak. If it is really important to you, you could of course consider installing your own water meter behind the official one, which is capable of reading the water consumption electronically. But then it will certainly be more expensive and more complex ...

Unfortunately, I have no experience in this regard. But fisheye lenses for the ESP32 cam currently cost about 6 EUR. I would say just try it and share your experience. With the standard lens, the distance to the number display is about the same as the horizontal image width. So if your counter display is 80 mm wide, the focus point of the lens must also be about 80 mm away from it. That's why I would have been able to reduced the distance a little bit for my meters.

If You have the luxury of a 3D printer You could incorporate a 45° mirror in the design, why not two it the meter stands out from the wall :)

Hehe ... i can hardly wait until you upload the first videos of your ballerina skills on youtube 😂

@@MakerMeik no way!)))

It's like I showed in the video: SELECT cumulative_sum(difference(last("value"))) FROM "onemonths"."meter" WHERE ("loc" = 'water') AND $timeFilter GROUP BY time(5m) fill(null) This causes that only the relative values of the currently selected period are considered.

Hi Anatoly, how did you do the HA integration?

Indeed, you are absolutely right. My shown kromschroeder gas meter has indeed this recess and I just tried it with a reed switch, it gives magnetic pulses for the second decimal place. That would have been the less complex approach indeed. Fortunately, the cam solution also runs quite reliably for me and if the MCU ever runs out of power, it still continues with the correct value at a later time, whereas with a pulse-driven approach you have to reset the base value. Nevertheless, I have added this important hint to the video description.

As I found out only recently, my shown kromschroeder gas meter actually also has a recess where magnetic pulses can be read with a reed switch. These are given at each zero crossing of the second decimal place of the counter. This would certainly have been the simpler approach. Thank you for your advice.

@@MakerMeik I would prefer to read the digits to make sure pulses aren't missed, even if it's a sledge hammer to the problem. If we've got the technology - why not use it?

@@sssxxxttt technology is a tool, use one which fits more

Unfortunately, I only use the old version of the firmware here, where this was not yet possible. If you haven't figured it out yourself by now, it's best to contact the developer on Github with your questions.

I think you have misinterpreted that. As far as I know, a LAN connection is not possible with the ESP32-cam microcontroller. The connectivity is always done via WiFi. A fixed IP only means that your router does not assign a new address each time via DHCP, but instead the IP address is fixed. This must be set in the router as well as in the configuration of the ESP. For this project this should not make a big difference, but it helps e.g. with installations, where the ESP is regularly woken up from the deep sleep. If you have a fixed IP, the connection will be established much faster. If you have a battery-powered system and the ESP is immediately put to sleep again, this can significantly extend the lifetime until the next recharge of the battery is required. If the background of your question is only a shaky WiFi, you should rather fix its cause. For example, by repositioning your WiFi router or adding a repeater. If it's just a matter of selective IOT connections, this project might also help you: github.com/martin-ger/esp_wifi_repeater

Yes, the SD card is required as far as I know because images, config and log files are cached there. The problem with the case has already been pointed out to me and in fact I just updated it today. Sorry you ran into this problem. As you can see from my pictures, I had just made a small cut with a pocket knife in the location for the SD card. I had forgotten about the problem in the meantime when uploading, otherwise I would have fixed it right away. The video was made a few months after my installation on the water meter.

Most likely to deal with reflections. Placing the LEDs externally allows you to adjust for bad reflections.

I have built the soldering iron according to the construction proposal "Maiskolben". There is an article about this in the German "Make" (unfortunately only in German) www.heise.de/make/artikel/Platine-fuer-DIY-Loetstation-Maiskolben-3569923.html The developer also has a store where you can order the PCB. But these are often not in stock. hannio.org/en/produkt/maiskolben/ The soldering station uses the professional soldering tips from Weller, I use e.g. the Weller RT 1, and it controls them via an Arduino. The total sum of the components is about 80 EUR. However, in the meanwhile I also bought a Miniware TS80P, which has a similarly good handling and costs similarly much, but without the tinkering effort.

Yes, that is exactly how I do it. The ESP32-cam sends its data via MQTT, which is passed on to Node-RED by the MQTT broker Mosquitto. In Node-RED I then write the data to an InfluxDB database, which I then evaluate with Grafana. This sounds much more complicated than it actually is. And when it's up and running, you can control all kinds of IOT-data with it. By the way, this constellation is called the classic IOT stack. If you start from scratch, you can watch the video of Andreas Spiess, in which he explains how you can install exactly these services on a Rapsberry Pi with very little effort: ukposts.info/have/v-deo/mWaenqpvq42G2Kc.html

@@MakerMeik thank you so much, i have installled node red, grafana, mosquitto broker, influx in ubuntu in a virtual machine, i have problems in node red with de mqtt broker, it connect and disconnect all the time, do you experience something like that? any special configuration in mosquitto?, thank you for your time!

Do you already have an MQTT broker running on a server? If so, even an ESP8266 is enough to subscribe and process the MQTT messages. However, if your question is that you would like to use an ESP32 as MQTT broker, you should have a look at the corresponding libraries. I have no own experience with it, but the sMQTTBroker library sounds promising for example.

Cool, do you have a video or a website where we can see how you did it? I would also be interested to know how you take the meter reading and put it into a digital form.

@@MakerMeik On the site, you can select photos that came during testing. And use the button at the bottom of the picture to recognize the numbers. out.mtom.by:5000

Hi, thank you very much. Unfortunately, I have not yet dealt with this. But sooner or later I have to deepen that. When the time comes, I might make a video about it.

@@MakerMeik thank you very much. I hope you make the video soon.

Found it, it' must be the cheapest 70 degree angle lens for the espcam. Mine is a 160 degree wide angle lens, also widely available on Ali for a few euros more My first testing is promising, and i'll be using the 160 degree lens, It all makes of breaks it by the picture quality without glass reflections. That can be quite tricky to setup..

If the light reflects on the digits in an unfavorable way, the recognition may suffer. You can also play with the size of the ROIs. If all this does not help, it may just be the font of your digits. I think Jomjol will implement new fonts in the firmware updates if you ask him kindly on his Github page ;-) Wenn das Licht ungünstig auf den Ziffern reflektiert, kann es passieren, dass die Erkennung darunter leidet. Außerdem kannst du mit der Größe der Ausschnitte (ROIs) spielen. Wenn alles nicht hilft, kann es auch einfach nur an der Schriftart der Ziffern liegen. Ich glaube Jomjol lässt neue Schriftarten in die Firmware-Updates einfließen, wenn du ihn auf seiner Github-Seite freundlich darum bittest ;-)

@@MakerMeik Thank you so much for the fast reply. I will do this.

Great idea. Maybe you would like to make a remix of my models!? I have also shared my FreeCAD files on Thingiverse. I would be very happy about it and link your model here.

I could well imagine that. But the developer jomjol also trains the ML-algorithm if you send him pictures of the digits.

I'm not a network expert, but I would guess that network devices always require a MAC address. Maybe I just misunderstood your question. If you want changes to the code or the functionality of AI-on-the-edge, you can kindly ask jomjol on Github. Feature requests are certainly welcome there.

@@MakerMeik understood thanks

or can I run on arduino mega?

A Raspberry Pi has potentially much more power and could of course easily do that. However, there is a lot of development effort in this project and I think you won't find a comparable project for the Raspi at the moment, unless you want to program and train it yourself. But of course, the Raspi is a full-fledged small computer and the ESP32 only a microcontroller with limited resources.

Thanks for the valuable tips. It worked for me in all three cases, but depending on the amount of glue, I can well imagine that this may be a problem. By the way, the (OV2640) cameras can also be ordered separately. But they are quite expensive in relation to the total price including ESP32.