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 KZfaq 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.

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

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

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

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!

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: kzfaq.info/get/bejne/l5ydnddp2b25p6c.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.

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: kzfaq.info/get/bejne/l9CkatmlzLGyfoE.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.

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 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 ;-)

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: kzfaq.info/get/bejne/mMBxjcZ52dqqkYk.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: kzfaq.info/get/bejne/qMyAqrKl1K2zZHk.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?

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.

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

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

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.

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

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.

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.

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: kzfaq.info/get/bejne/l5ydnddp2b25p6c.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!

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.

Put esp32 in deep sleep after readings. Lion batteries, you should charge it every month, or replace it with a charged one every month. See Andreas Spiess channel on deep sleep and battery powered ESPs.

@@guatagel2454 Hi! Thanks for your feedback. I tried something like that, the issue is that I need to replace it very often, less than a month, and it's not very particle. I need something for at least 6 months. Thanks anyway :)

Thanks for the congrats. Without a permanent power supply, however, it will probably be challenging. Here in the chat others had already the topic. Of course you can test the deep sleep function of the ESP. However, as you have already written, you won't get very far with it. On the one hand, the required wake time of the ESP is quite long for this project. Unless you really want to charge the batteries every few weeks, you can probably only read a few times a day. Also, I know from my own experience that the deep sleep function is usually treated poorly by ESP developer boards. I plan to do another compact video on this myself in the next few weeks. But you can find the essential tricks in these two videos: kzfaq.info/get/bejne/qMyAqrKl1K2zZHk.html kzfaq.info/get/bejne/gJxmkpuBlZqXm6M.html I'm not quite sure if this is necessary or possible with the ESP32(-cam)s though. Further down in the chat, @Vladimir Kuznetsov also brought up the discussion of whether it wouldn't make more sense to count the pulses via IR sensor, at least for electricity meters. If that is an option for you, your chances for a battery-powered project would certainly be higher. By the way, the main power consumer is the wifi. Maybe you think about an offline solution. Or send the measurement data only once a day ... Anyway, the ESPs are not ideal when it comes to power consumption. On the other hand, complex projects like AI-on-the-edge are hardly possible with simpler MCUs. Let's see what future MCU generations bring. The RP2040-based boards already look very promising. If you successfully complete the project, I would be very happy if you also make a short video about it.

@@MakerMeik Hello! I'm really sorry for my late reply. I didn't noticed it. I will read carefully and take that in consideration. Thanks! Best Regards.

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.

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.

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

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.

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

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.

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 @Hervé Lacerre, my ESP32 cams have IPUS IPS6404LSQ installed. Since several users have now written about PSRAM problems, this could really be the cause. Do you think you can re-solder the IC? It would be interesting to see if the problem can be solved this way. Or you can ask jomjols on his Github page if he knows something about this IC or a way to fix the problem.

@@MakerMeik I have re-soldered the psram, but same error E (506) psram: PSRAM ID read error: 0xffffffff E (506) spiram: SPI RAM enabled but initialization failed. Bailing out.

And the normal CameraWebServer example works, or are there also problems with it?

Hallo Frank, was meinst du mit Tacho anzeigen? Der Ansatz auch für analoge Zeiger möglich und kann recht einfach erweitert werden. Ich bin der Entwickler der Firmware (jomjol) und tausche mich gerne mit dir aus, um neue Applikationen zu finden.

Hallo Frank, jomjol hat ja schon seine Hilfe angeboten. Mir ist auch nicht ganz klar, in welchem Zusammenhang du das mit dem Tacho meinst, aber ein Flaschenhals könnte sein, dass der ESP32 eine Weile braucht, um die Bilder zu machen und auszuwerten. Das kürzeste Intervall ist bei AI-on-the-edge darum auf derzeit 3 Minuten beschränkt. Wenn du damit das Manometer des (Haus-)Wasserdrucks ablesen willst, sollte das reichen. Auf einem Moped würde ich die Installation aber eher nicht empfehlen ;-)

​@@MakerMeik @Frank Müller Also an der Erkennungsgeschwindigkeit gibt es durchaus noch ziemlich Potential. In einer kommerziellen Variante mit nur 3 Ziffern und einigen Geschwindigkeitsoptimierungen kann ich das Bild in unter 1.5 Sekunden verarbeiten.

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

The firmware has a correction mechanism that notices when no meaningful value can be read. This place is then marked as "N". The recognized number is then e.g. 4373N.59. Based on the rules that you have defined in the PostProcessing section of the configuration, the firmware then tries to determine a reasonable value. If this does not succeed, the entire value is discarded.

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.