[Version 2 Release] RaspberryPints - Digital Taplist Solution

[RandR+]

is there some type of tweak I can do or is there a better quality reader ??

you probably need a different reader, but my quick search didn't come up with one that looked like you could just swap out.

 

[Benjamin Carlisle]

@Benjamin Carlisle Looks like your settings and configuration seems reasonable.

How long is the wire from the meter to the Pi? Do you have a pullup resistor on the data line?

How big are the ghost pours? Do they always happen or is random?

Does it happen on every tap or just one?
Have you tried swapping flowmeters and do the problem follow the meter or the tap?

10ft cat5 wires (3 for flowmeter / 2 for valve) with no pullup resister

I only have 1 tap installed right now.

I have not swapped.

The pours are small to very large...mostly large 50 -300 oz after conversion. random...but consistent. The flowmonitor service also fails most days.

What size should the pull up resister be ? would it change with cable length ??

 

[Benjamin Carlisle]

you probably need a different reader, but my quick search didn't come up with one that looked like you could just swap out.

Do you use RFID ? what is your experience?

 

[ba-brewer]

10ft cat5 wires (3 for flowmeter / 2 for valve) with no pullup resister

I only have 1 tap installed right now.

I have not swapped.

The pours are small to very large...mostly large 50 -300 oz after conversion. random...but consistent. The flowmonitor service also fails most days.

What size should the pull up resister be ? would it change with cable length ??

I believe the recommended value for the pull up is 2.2K, would not change cable length.
[Version 2 Release] RaspberryPints - Digital Taplist Solution

Even if you don't have taps setup for the other meters it might be helpful to still hook them up dry to see if you get random pours from those meters too.

The connections in your valve box look modular could try swapping cables to see if problem follows a cable.

Could try swapping flowmeters to try and isolate it too.

Maybe use an ohm meter or voltmeter to make sure you don't have any shorts or open in your connection. A short to another pin is more likely.

 

[ba-brewer]

Ok...thank you so much for asking the questions...you believed me when I said...I don't know where to start.....

so...I have 4 swissflow with valves...

keg---2 foot 1/4' hose ---valve/flowmeter ---12 foot trunk line w/glycol to tap.

pour message delay 300
pour trigger count 400
kick trigger count 500
update trigger count 350
pour shutoff count 0
valve on time 2
number of taps 4

did calibration...and got 21865 count per gallon....that part is awesome and consistent...

I don't see any air at all...

Hope the pictures help.

I am not running rand's code actively, but I did a testbed of some of the early code and had issues with using pin 13. If it is easy rewire maybe try a different pin.

@RandR+ are there any arduino pins that should be avoided?

 

[Benjamin Carlisle]

I am not running rand's code actively, but I did a testbed of some of the early code and had issues with using pin 13. If it is easy rewire maybe try a different pin.

@RandR+ are there any arduino pins that should be avoided?

pin 13 is connected to RPi not arduino...it's for the valve

 

[RandR+]

Do you use RFID ? what is your experience?

I use the same RFID reader and I have to press the card against it to register. Mostly because the cards are passive meaning they get their power from the RFID reader and power doesn't travel that far yet.

I mounted mine to the keezer collar by making a rectangle hole for the pins and wires to go through, maybe not the best looking but highly functional

 

[RandR+]

are there any arduino pins that should be avoided?

There was one pin I had issues with on the alamode I think it was 13 trying to get the LED to blink, but that also may have been when I was working on the RFID logic because 13 is also the SCK.

 

[day_trippr]

Alamode has a few no-go pins imo.
0 & 1 are tied up with the uart, of course.
2 is reliable, been using it for years.
3 is used for the Alamode TOY clock (PD3_SQW) square wave output. I had trouble with that one as I installed the TOY clock support.
4 should be ok. I thought I had a problem with it on my original build back in May 2014 so I skipped that one, never went back.
5 through 9 are bulletproof, which with 2 are enough for my six taps and I've been using those for 6+ years.
10, 11 and 12 are connected via translator to the RPi SPI signals SS, MOSI and MISO, but those are only enabled if the jumper mentioned below is installed. Otherwise they should work fine.
13 is indeed the "Blink" gpio and is also the translated RPi SPI clock SCK if the "enable communication" jumper for the translator chip is enabled. If jumper isn't installed it should work ok though the LED blinking might be distracting

I would urge folks considering a new build to not use the Alamode unless they are space constrained and need to go "up". The price is ridiculous compared to being able to pick up functionally legit R3 Uno clones for $5, and it's a bit awkward to use compared to an Uno spaced to one side of the RPi...

Cheers!

 

[Benjamin Carlisle]

This was pour history last night after I did "good" pour once....
Why so high...it can't really be flow...can it ?

2020-12-23 00:25:00 AM	2		Loon Lake Porter	89.41
2020-12-23 00:07:49 AM	2		Loon Lake Porter	66.68
2020-12-22 23:48:54 PM	2		Loon Lake Porter	16.33
2020-12-22 20:48:47 PM	2		Loon Lake Porter	86.28
2020-12-22 20:44:55 PM	2		Loon Lake Porter	11.35
2020-12-22 20:38:13 PM	2		Loon Lake Porter	69.69
2020-12-22 19:36:47 PM	2		Loon Lake Porter	252.21
2020-12-22 18:37:48 PM	2		Loon Lake Porter	250.67
2020-12-22 18:10:57 PM	2		Loon Lake Porter	68.04
2020-12-22 17:48:40 PM	2		Loon Lake Porter	16.73
2020-12-22 14:39:29 PM	2		Loon Lake Porter	13.12	Benjamin

 

[Benjamin Carlisle]

Does it matter which side i put the resistor on? ie. closer to meter or closer to Arduino, knowing there is 10 ft between.

 

[ba-brewer]

I would put it close to the flowmeter if it is easy to do. There is a weak pullup in the arduino so you are protected from a floating input in case the meter got disconnected. I think some of the flowmeters had pretty long cables on the meter so the actual location might not be too critical.

If you have a voltmeter it might be helpful to measure the voltage at the arduino pin when idle.

 

[barrooze]

Well, after much tinkering, I’ve got my RPints back up and running. Thank you, @RandR+, for all the help in getting it set up!!

Here’s a video of it in action.

Now to BACKUP my card in case my card goes corrupt again and I lose all my customizations!! Thanks again!

 

[kxavier_23]

I am having this strange issue where the Tx and RX lights on my R3 stop alternately flashing and go solid on.

When this happens, no pours register. If I restart everything, it will work for random amounts of time. i.e. a week, a few hours etc.

Any idea what to even check or maybe someone has come across this issue as well.

I am using a breadboard with 2.2k resistors for pull up. I have also checked the resistance on all the flowmeter wiring, both through and not through all my cabling. The resistances are the same either way.

 

[day_trippr]

I would suspect a comms problem over the USB link, or insufficient power to the UNO.

If using USB for power, try using a 9V DC supply to the barrel connector instead. If already doing that, try a better USB cable...

Cheers!

 

[kxavier_23]

I would suspect a comms problem over the USB link, or insufficient power to the UNO.

If using USB for power, try using a 9V DC supply to the barrel connector instead. If already doing that, try a better USB cable...

Cheers!

I am already powering off a separate power supply based on other recommendations in this thread, I am also on my 3rd USB cable. I can try that again.

Any suggestions on proven brands of USB cables?

 

[garzlok]

Quick question @RandR+ . Whenever I make a pour, userid -1 is credited with the pour. How and where do I change that so the default is userid 1 (sans the -)?

 

[RandR+]

Whenever I make a pour, userid -1 is credited with the pour. How and where do I change that so the default is userid 1

the Arduino sketch uses -1 to indicate no user RFID scanned. If you want to change it I would actually change the PHP to override -1 to 1 in includes/pours.php by adding this above line 43:

if( $RFID == -1) $RFID =1;

 

[garzlok]

the Arduino sketch uses -1 to indicate no user RFID scanned. If you want to change it I would actually change the PHP to override -1 to 1 in includes/pours.php by adding this above line 43:

if( $RFID == -1) $RFID =1;
View attachment 713029

Awesome! Thanks for that! ....and if I do ever incorporate RFID, I don’t think I have to remove that line if I always want to take credit for a non-RFID pour.

 

[Cruz1n]

Hi all
Happy new year! I thought from memory someone had printed up a case for the PIR on a 3D printer. Finally have myself a 3d printer and want to tidy up my setup and can't find anything through thread search. Anyone point me in the right direction?

 

[Kevbud]

i am building my rpints system and plan to use the SF800 flow meters. I am using EVABarrier Double Wall Draft Tubing - 4 mm ID x 8 mm OD for my beer line. Can you point me in the right direction for what fittings I need for the flowmeters. Thanks in advance. Also thanks to RandR+ and others on the code and script. I ran the script and was a huge help. No way I would have figured all that out on my own.

 

[day_trippr]

For the SF800, the fittings for EVAbarrier tubing (which is 8mm or 5/16" OD) need to be 3/8" BSP female to 8mm (or 5/16") OD fitting.

For John Guest, that's part number PM450813E. When I was kitting up 13 months ago nobody carried this part in the USA.
For DMfit, that's part number AFAB0506C, which I found at freshwatersystems.com

Cheers!

 

[Kevbud]

thanks so much. found a 10 pack on amazon. Freshwater only had a 150 pack. Go figure. One more question. any issues or complications if I use these much cheaper flow meters by Digiten. Do I need to update any setting files in Rpints or install any resistors or just plug them into the right sockets on the ardunio?

 

[day_trippr]

Yes, you have to change the calibration value (essentially, what fraction of a gallon each tick represents).
I went right with the sf800s back in 2014 with the original 2.0.1 release and have no other experience, but there have been folks using similarly inexpensive meters to that shown that may be able to relate their settings...

Cheers!

 

[kxavier_23]

its setup so that if the keg is on tap it cannot be set to empty otherwise you would have a empty keg on tap and that doesn't make sense and changing it from serving to something else doesn't remove it from the tap you have to do that from the tap list

I think I see why there are beers assigned.

I loaded the test data on install and then deleted the extra taps and kegs. Now I seem to be stuck where I go into the Keg maintenance and I don't have a way to select no beer on kegs #8 and 10...

I can see there are kegs assigned though via the Taps maintenance.

 

[kxavier_23]

I wonder if there is a data inconstancy here like the tap isn't assigned a keg but the keg is assigned a tap.

Can you run the following from the terminal (where <DatabaseName> is your database name, default is raspberrypints):
sudo mysql
use <DatabaseName>
select * from kegs where onTapId > 0;

that should return the kegs that think they are on tap. If the number of rows is not equal to the number you have configured on tap or you see a keg that you know you don't have on tap in the list then that is the issue

I also ran the sql you suggested and yes, there are kegs assigned to taps that are not correct.

| 1 | 1 | 1 | Cornelius | Super Champion | 84000259 | Pepsicola Bottling Co | Fargo, ND | NULL | SERVING | 41.4613 | NULL | 8.9960 | lb | 5.0000 | oz | 5.00000 | oz | 2.82672 | oz | 11.00 | psi | 42.00 | F | 1 | 15 | 1 | 0 | 2020-11-24 22:10:18 | 2021-01-07 15:09:23 |
| 2 | 2 | 1 | Cornelius | Super Champion | 81175979 | Joyce Bev | Washington D.C. | NULL | SERVING | 44.1495 | NULL | 8.1571 | lb | 5.0000 | oz | 5.00000 | oz | 3.25149 | oz | 11.00 | psi | 42.00 | F | 2 | 16 | 1 | 0 | 2020-11-24 22:10:18 | 2021-01-07 15:09:23 |
| 4 | 4 | 1 | Cornelius | Super Champion | 77320513 | Binghamton Btlg Co | (Unknown) | NULL | SERVING | 34.9994 | NULL | 8.1571 | lb | 5.0000 | gal | 5.00000 | oz | 3.20210 | oz | NULL | psi | 46.00 | F | 5 | 14 | 1 | 0 | 2020-11-24 22:10:18 | 2021-01-07 15:09:23 |
| 5 | 5 | 1 | Cornelius | Super Champion | 80224203 | Pepsi Btlg Co | Southern CA | Green handles | SERVING | 12.5100 | NULL | 8.1571 | lb | 5.0000 | oz | 5.00000 | oz | -0.06661 | oz | NULL | psi | NULL | F | 3 | 13 | 1 | 0 | 2020-11-24 22:10:18 | 2021-01-07 15:09:23 |
| 8 | 8 | 1 | Cornelius | Super Champion | 78143233 | Pepsi Cola Btlg Co | Parkersburg WVA | NULL | SANITIZED | 8.1571 | NULL | 8.1571 | lb | 5.0000 | oz | 5.00000 | oz | 0.00000 | oz | 12.00 | psi | 42.00 | F | 8 | 8 | 1 | 0 | 2020-11-24 22:10:18 | 2021-01-07 15:09:24 |
| 9 | 9 | 1 | Cornelius | Super Champion | 112620585 | Pepsi Cola Btlg Co | Aleghany, NY | Blue handles | SERVING | 29.0696 | NULL | 8.1571 | lb | 5.0000 | oz | 5.00000 | oz | 2.46465 | oz | NULL | psi | 42.00 | F | 4 | 11 | 1 | 0 | 2020-11-24 22:10:18 | 2021-01-07 15:09:24 |
| 10 | 10 | 1 | Cornelius | Super Champion | 82217553 | Pepsi Cola Seven Up | Mpls St Paul | NULL | SANITIZED | 8.1571 | NULL | 8.1571 | lb | 5.0000 | oz | 5.00000 | oz | 5.00000 | oz | NULL | psi | NULL | F | 10 | 10 | 1 | 0 | 2020-11-24 22:10:18 | 2021-01-07 15:09:24 |

How do I fix them?

 

[RandR+]

How do I fix them?

from MySQL run this update

update kegs set onTapId = null where onTapId is not null and onTapId not in (SeLECT id from taps WHERE active = 1);

that should reset the kegs to not be on tap anymore

 

[kxavier_23]

from MySQL run this update

update kegs set onTapId = null where onTapId is not null and onTapId not in (SeLECT id from taps WHERE active = 1);

that should reset the kegs to not be on tap anymore

Seems to have fixed it. THANK YOU.

Do I need to be concerned that the 4 new kegs I just added to inventory are numbered 25-11, 25-12 etc?

In the mean time I looked into the other fields in the db and I assume that active = 1 means they are active? The test data I deleted has active = 0. So I am assuming that when the test data was 'deleted', it was really only making them inactive (active =0)?

 

[RandR+]

Do I need to be concerned that the 4 new kegs I just added to inventory are numbered 25-11, 25-12 etc?

no its just <ID>-<LABEL> if there isn't a label then it will just be <ID>

Yes most things when they are deleted they are just marked inactive, this allows historical data without data inconsistencies

 

[Kevbud]

electronics noob here. For my flow meter 2k2 ohm pull-up resistor, do I install one for each single wire between the 5 volt power line and the signal line

thanks

never mind. I found my answer