[Version 2 Release] RaspberryPints - Digital Taplist Solution

[DuncB]

@day_trippr
Thank you very helpful as always.

"It is also recommended to provide each flow meter data circuit with a 2.2Kohm pull-up resistor to 5VDC,"

So yellow data wire I attach the resistor to and then other side of resistor goes to a clean 5V DC or the same wire as the 5V DC powering the flow meter?
The yellow data wire also splits to continue back to the shield?

Close as possible to kegs for the flow meter I'm guessing from your picture.

 

[day_trippr]

Yes, the yellow signal lead connects to a digital pin on the UNO and to one side of the pull-up resistor, with the other side of the resistor connected in some way to 5VDC. The location is non-critical but the voltage must be the same that the Uno uses (ie: don't use 5VDC from the RPi).

I found putting the meters as close to the keg Out posts provides the best quality pours. I think others have found locating the meters at the other end of the beer lines becomes problematic, probably due to temperature difference (warmer) than the keg...

Cheers!

 

[DuncB]

Thank you think I've finally understood this pull up resistor thing.
One sensor per digital input on the shield ? and I don't use the I2C connections for any sensors?
You have a lot of inputs to your setup so I'm assuming digital sensors can be distinguished from each other.

 

[day_trippr]

Yup, one meter data lead per digital pin, no I2C involved.
When you set up R'Pints you'll assign the meters by their digital pin connection, then you can either set the ticks per gallon or use the Calibrate function.

I have six meters using digital IO pins 2 and 5 through 9 as this is an Alamode and IOs 0, 1, 3 and 4 are shared with on-Alamode functions. With an UNO you won't have that problem...

Cheers!

 

[DuncB]

@day_trippr
Very helpful picture thank you.

I'm aiming to record my efforts for a step by step guide so daft questions aren't needed anymore.

 

[day_trippr]

On this day in 2014, at 12:09 AM, I poured four ounces of an ESB from my keg #4 via tap #4, the first properly registered pour with my RaspberryPints taplist up and running

Cheers!

 

[DuncB]

I will update with my first successful pour.
@day_trippr
A running total of oz poured since then?

 

[day_trippr]

I was pouring a hazy today when I realized what day it is and why it was significant, and as I'm running the same R'Pints database since Day 1, I dug into the Pours table, found the first entry which provided the tapID, pinID, amountPoured, etc, then vectored to the Taps table to figure out which Beer entry was used, then inspected the Beers table to determine which style was in the keg.

Back when the consumption rate was higher than it is today and I actually felt the need to "plan" on what I was brewing to keep everyone happy I used the database to produce graphs of Keg Volume vs Time of various beers to find which styles were consumed the fastest (IPAs. Duh). So the data is all there, and theoretically I could pull all of the amountPoured values from every single Pours entry into a CSV file then bang it into Excel to calculate a total.

Or, I can just use the value of the last entry in the Taps table - 272 - and multiply that by 5 gallons, for a running total of 1360 gallons since September 1, 2014 (when this set of kegs kicks). It would be a bit less accurate - not all kegs were filled to exactly 5 gallons - but it wouldn't be off by a lot as my habit actually is to put 5.0 gallons in every keg...

Cheers!

 

[RandR+]

So the data is all there, and theoretically I could pull all of the amountPoured values from every single Pours entry into a CSV file then bang it into Excel to calculate a total.

sudo mysql
SELECT sum(amountPoured) FROM pours;

i believe that will give you ounces but this will give you gallons
SELECT sum(amountPoured)/128 FROM pours;

 

[day_trippr]

Thanks!
The classic R'Pints registers pours in gallons so the first command is proper (after logging in and actually connecting to the database).
To wit:

root@bpints:~# sudo mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.

mysql> connect raspberrypints
Current database: raspberrypints

mysql> SELECT sum(amountPoured) FROM pours;
+-------------------+
| sum(amountPoured) |
+-------------------+
| 1342.939 |
+-------------------+
1 row in set (0.00 sec)

mysql>

That's a lot o' pours!

Cheers!

 

[DuncB]

Okay finally starting my go at an installation with flow meters.
Pi4 8Gb, Uno R3 and seeed base shield V2, arduino flowmeter yfs201.
All assembled and updated and rpints installed. Selected flowmeters but no sign of the meter or any idea where to look for it.
I have it plugged into D2 on the shield also tried on D3. But no joy.
Realised that the resistor I attached is 220 K ohm which could be the issue.

So will change that but what is and where is the calibration procedure?

What does the motion detector do?

Do I connect temp sensors to the pi or the base shield I2C connections? I saw earlier that it said pi but that was for @day_trippr who uses / used an alamode.

Thank you

 

[day_trippr]

Temperature sensors: the ds18b20 data lead(s) all connect to an RPi GPIO. I use GPIO4 (GPIO header pin 7) with a pull-up to 3.3VDC, I use 4.7K. Settings are found under Advanced Hardware - Temperature Probes

The Motion Sensor "unblanks" a directly attached display and can also execute system commands. I have mine play a short mp3 when the screen unblanks. The sensor I use is an inexpensive PIR (passive infrared sensor) associated with Arduino and RPi projects. It's connected to GPIO22 (RPi pin 15) and should not need a pullup. Settings are found under Advanced Hardware - Motion Detectors

Flow meter data leads connect to the Arduino, your UNO in this case, using digital IO pins. You can use digital IO 2 on up to at least 11 (IO 0 and 1 are used for RX/TX comms either using serial or USB or a Bluetooth adapter). On my Alamode I use digital IO pins 2 and 5 through 9 for my six flow meters to avoid on-Alamode features that use some of the IOs I'm avoiding. Flow meter data leads should have pull-ups to 5V, I use 2.2K. Settings are found under Basic Setup - Taps.

Note many functions also require enabling via the Personalization - Configuration table. And the flow meter ticks per volume will have to be set in Basic Settings - Taps (hint: enable "Show Pin Settings"). I use 21888 ticks per gallon based on my SwissFlow SF800 meters.

Cheers!

 

[DuncB]

@day_trippr
Thank you.
I've got the Shield set for 5v, changed to 2.2K resistor.
So in basic settings taps do I assign a new tap and tell it to look at pin D2?
I found the bit that has calibrate on it to enter the ticks but is there somewhere that I pour a known volume and can see the ticks generated by that to input the numbers?
I'll track down a pir and get a couple of ds18b20 for the future.
Think I need to go through the settings sans a beer in hand.

 

[day_trippr]

So in basic settings taps do I assign a new tap and tell it to look at pin D2?

Yes. Here's an example setup for six faucets using the example data built into the original installation.

I have not used the Calibrate function. I should give that a try some time

The PIR type I use (a lot) is the HC-SR501...

https://www.amazon.com/HC-SR501-Sensor-Infrared-Arduino-Raspberry/dp/B07KBWVJMP
Cheers!

 

[DuncB]

Thank you.
I've put that pin on for Darth Vader.
Not getting any changes to keg contents.
Should I see flow meter as an option in advanced hardware?
Using a Uno R3 am I meant to be adjusting or entering anything in alamode parts?
There isn't an equivalent menu for the R3, should there be?
I wonder if the R3 is detected or loaded, it has 9V psu, green light on and orange light flashing.

 

[DuncB]

i reckon this is the problem

2023-10-05 10:48:44 RPINTS: No such device - Sleeping to try again
2023-10-05 10:48:50 RPINTS: No such device - Sleeping to try again
2023-10-05 10:48:55 RPINTS: Could not import RFID Reader, RFID disabled. Assuming SPI not installed/configured
RPINTS: reflashing Arduino failed, moving on anyways, error was: Command '/usr/share/arduino/hardware/tools/avrdude -C/usr/share/arduino/hardware/tools/avrdude.conf
-patmega328p -calamode -P/dev/ttyACM0 -b115200 -D -Uflash:w:/var/www/html//arduino/raspberrypints/raspberrypints.cpp.hex:i' returned non-zero exit status 127.
2023-10-05 10:49:00 RPINTS: starting WS server
2023-10-05 10:49:00 RPINTS: starting device monitors...
2023-10-05 10:49:00 RPINTS: starting command server
2023-10-05 10:49:00 RPINTS: starting fan control
2023-10-05 10:49:00 RPINTS: Fan Control fanControl1 is Running
2023-10-05 10:49:00 RPINTS: Not Configured to run Fan



not sure from here, i selected usb connection.

will try another usb cable

 

[day_trippr]

[edit - as I didn't see the above first]

It seems it's looking for an Alamode instead of an UNO.

[end edit - original post follows]

Check the big list of enables under Personalization - Configuration. You need to enable Use Flow Monitoring, for one. You'll find that setting near the bottom.

There are other settings you probably need to set and others you probably want to set.
For what it's worth, here is my configuration table...

Cheers!

 

[day_trippr]

I checked my build log and there is a point in the installation where you specify USB or Serial communications.
The former applies to an UNO while the latter applies to an Alamode.
So, it appears you have to repeat the installation to change Arduino modes...

Cheers!

 

[day_trippr]

Actually, you may be able to change the Arduino configuration by editing /var/www/html/rpints/python/Config.py and change the value of
config['flowmon.port'] =

from '/dev/ttyS0'
to '/dev/ttyACM0'

as implied by a familiar looking list found near the top of the file

That would preclude the need to rerun the whole installation, I believe.

Once you get the Arduino loaded you will noticed the "blink" LED will pulse at roughly 1 hz...

Cheers!

 

[DuncB]

I checked my build log and there is a point in the installation where you specify USB or Serial communications.
The former applies to an UNO while the latter applies to an Alamode.
So, it appears you have to repeat the installation to change Arduino modes...

Cheers!

ive redone the install this am and confirmed that i did select usb. the log sent is after that was done but it was the same before i did reinstall as well.

 

[DuncB]

Actually, you may be able to change the Arduino configuration by editing /var/www/html/rpints/python/Config.py and change the value of
config['flowmon.port'] =

from '/dev/ttyS0'
to '/dev/ttyACM0'

as implied by a familiar looking list found near the top of the file

That would preclude the need to rerun the whole installation, I believe.

Once you get the Arduino loaded you will noticed the "blink" LED will pulse at roughly 1 hz...

Cheers!

it is already set as you mention above.

 

[DuncB]

charitable to let me get post 8000

 

[DuncB]

i think there is an issue loading the instructions to the arduino

 

[day_trippr]

charitable to let me get post 8000

I stopped sniping milestones years ago

i think there is an issue loading the instructions to the arduino

I agree, the question is why.

-patmega328p -calamode -P/dev/ttyACM0 -b115200

I guess "-calamode" doesn't mean what I thought it meant given the -P(port) is pointing to a USB device and not a serial one.
I think we may need to try to summon the author known as @RandR+ to weigh in on your conundrums...

Cheers!

 

[DuncB]

I think the orange flashing light on the arduino is from a loaded sketch called blink.
I also came across an arduino program in the menu list. I've updated the firmware to 1.8.6.
This has made no difference.
I've also confirmed no change with a new USB lead and that the 9V psu is working correctly.

 

[day_trippr]

You are correct that many UNOs ship with the "Blink" sketch installed, but I'm looking at my desktop RPi3+ running @RandR+'s R'Pints and the "Blink LED" is blinking at 1 hz...

Cheers!

 

[day_trippr]

I also came across an arduino program in the menu list. I've updated the firmware to 1.8.6.

What do you see on the UNO if you restart the Flowmonitor service?
You should see the UNO rx and tx leds flash a few times, then the Blink LED should start its 1 hz blink...

Cheers!

 

[DuncB]

When I restart flowmonitor service.

I see no change at all on the UNO, green light stays on, orange light flashes at same rate throughout and no rx tx led flash.

Log is exactly as copied in previous post except different time stamp.
I've tried rebooting from off with and without power supply to the UNO and there is no difference in the log messages or behaviour.

 

[day_trippr]

Ok, then there's definitely a lack of proper dialog between your UNO, your RPi, and R'Pints.
If I was confronted with this I'd install the Arduino IDE on the RPi, connect the UNO to it, and see if it communicates properly...

Cheers!

 

[DuncB]

THe arduino ide is on the pi, that's how I managed to update the firmware.

What should I do in the IDE to see if the communication is open?