[Version 2 Release] RaspberryPints - Digital Taplist Solution

[Roadrune]

The Python config.py has the same text lines, but they are at line 20 and 21, so something is different there.

I have not checked for loose wires, but i soldered it up so good that i really doubt it. (I KNOW how to solder).

I would think the error is software related, or a bad connection as you suggest since the pours are that big? 3.5l is close to 1gallon.

I get ghost pours on 2 of my three taps so far.

Only thing i know i have done different then i should is powering the UNO via USB with the PSU connected directly to the Pi since i didnt bother to change connector on the PSU.

 

[RandR+]

I would think the error is software related, or a bad connection as you suggest since the pours are that big?

What is your pulses per liter per the taps?
you may need to check the Show Pin Settings

The software records the raw pulse count and the conversion factor that it used to calculate the pour volume, you can look into the Pours table in the database to see these pour's pulses and conversions.

The Uno code for counting pulses has been proven. it uses interrupts to count the pulses.

I also was getting large ghost pours on a tap. I disconnected the wire and they went away, then when I plugged it back in they didnt start back up. Im pretty sure it was a loose connection that caused them.

 

[Roadrune]

Count pr/l is set to 6100, i have not been able to verify the measured volume as i dont abuse alchohol (not willing to throw it away), will check that on friday.

Knock on wood, but it seems the ghostpour problem went away after i changed the kick keg setting, but to read the python file i had to reconnect a mouse and keyboard, so it is possible i have "fixed" a bad connection on the board itself when i moved it. The sensors are just plugged in.

 

[RandR+]

ghostpour problem went away after i changed the kick keg setting,

did they go away or did the kegs stop disappearing? You can tell by the volume in the keg if its not 0 then they went away

 

[Roadrune]

Seams like both. To early to tell for shure, but have not seen either problem after i changed that setting. None of the kegs are empty and they are not logged as empty either.

 

[Roadrune]

When i calibrate the flowsensors and put in last poured value in ml, last time 550ml (i use metric values) and return to the main screen last poured value shown is 145,29 which is the equivalent of gallons from 550litres. What unit should i use to calibrate?

 

[beerNbikes]

Hi RandR+,
I have my pi running a screen above my home bar. There is no mouse or keyboard. When I make changes on the pi from a remote computer (add a keg, change a glass type etc.) I only know two ways of making the pi refresh its screen. I tell it to reboot, or I have to pour a beer. Is it possible to have a button on the admin page that will refresh the host's display?
Cheers!

 

[Naesstrom]

@beerNbikes if you connect a temp sensor you can set the refresh interval for the UI

 

[Roadrune]

When i calibrate the flowsensors and put in last poured value in ml, last time 550ml (i use metric values) and return to the main screen last poured value shown is 145,29 which is the equivalent of gallons from 550litres. What unit should i use to calibrate?

No one knows?

I have tried to use both ml and oz to calibrate, but both give wrong results by a lot.

 

[RandR+]

What unit should i use to calibrate?

It should be the display units you have setup. if you have it setup to display gallon/ounces then enter ounces, if you are showing liters then milliliters.

I will test locally to see if i have an issue with not converting a unit

 

[RandR+]

I only know two ways of making the pi refresh its screen. I tell it to reboot, or I have to pour a beer. Is it possible to have a button on the admin page that will refresh the host's display?

I am assuming this screen is attached to the pi and not a network screen (I have a fixed tablet that just displays the webpage)

So we could just add the following to admin\tap_list.php ~line 95

// Refreshes connected pages
if(isset($config[ConfigNames::AutoRefreshLocal]) && $config[ConfigNames::AutoRefreshLocal]){
exec(__DIR__."/../includes/refresh.sh");
}

that call a script that forces any open browser to refresh (if the config is set to do that)

 

[RandR+]

145,29 which is the equivalent of gallons from 550litres. What unit should i use to calibrate?

Can you post screenshots of the calibration page and the main page showing this?

 

[Roadrune]

Can you post screenshots of the calibration page and the main page showing this?

 

[RandR+]

145,29 which is the equivalent of gallons from 550litres. What unit should i use to calibrate?

I can see a path in the code that would output gallons if gallons were the selected display unit, but from the screenshots ml should be the selected display unit that is why everything else shows ml as the unit.

So I need some more information if you could run these 2 sql queries and report the results

SELECT * FROM raspberrypints.pours where tapId = 1 order by createdDate desc Limit 1;
SELECT configValue FROM config WHERE configName ='DisplayUnitVolume';

Either through phpmyadmin or through the terminal
for the terminal run
sudo mysql
use <databasename>
SELECT * FROM raspberrypints.pours where tapId = 1 order by createdDate desc Limit 1;
hit enter
SELECT configValue FROM config WHERE configName ='DisplayUnitVolume';
hit enter

 

[Roadrune]

I am really sorry, but you lost me at sql...
Could you descibe this in more detail please?

 

[RandR+]

I am really sorry, but you lost me at sql...
Could you descibe this in more detail please?

Open the terminal (command line)

-NOTE: instructions to type are surrounded by " do not type the "
type "sudo mysql"
hit enter
type "show databases;"
hit enter
(this will list all available databases, one should be called something like RaspberryPints)
type use "<the name of the database like RaspberryPints (capitalization matters)>"
hit enter
type "SELECT * FROM raspberrypints.pours where tapId = 1 order by createdDate desc Limit 1;"
hit enter
Screen shot the output and post here
type "SELECT configValue FROM config WHERE configName ='DisplayUnitVolume';"
hit enter
Screen shot the output and post here

Here is the process on my test environment

 

[Roadrune]

Like this?

 

[RandR+]

Like this?

perfect I figured out what is happening and will have a fix tomorrow.

Its that the tap has a metric unit but the calibration assumes imperial. so it was saving 550ml as .15 gallons then displaying .15gal as liters which is 150 ml

 

[day_trippr]

A breakthrough about to happen! Awesome!

MAJOR props to @RandR+ for the level of dedication and effort he's consistently provided from the jump on this project

Cheers!

 

[RandR+]

145,29 which is the equivalent of gallons from 550litres. What unit should i use to calibrate?

The fix is in. The issue specifically only affect the last pour logic and not the calibration logic.

You can rerun the script and select the Update option or try hitting the Get Latest RPints button on the install page on the Admin section

 

[Roadrune]

Thank you for your effort!

Superquick update, just a couple of seconds, have not tried to calibrate yet, propably not untill the weekend.

But take a look at the top and the bottom keg, those are all 5gallon/19litre kegs:

 

[RandR+]

those are all 5gallon/19litre kegs:

hmm that doesnt look right, but those values are set directly from the start amount and current amount on the tap page. If those match that then you need to adjust if they dont match then i need to look into what is setting them seperately

 

[Roadrune]

I adjusted them fine now, but those where changed by the update.

Still getting some ghost pours aswell, and cannot see where it could be a bad connection.

Maybe loadcells is a better solution?

 

[day_trippr]

See if you get ghost pours from a meter with its beer QD disconnected from the keg...

Cheers!

 

[cripplecreek]

Howdy everyone! I wanted to thank @RandR+ , @day_trippr , and everyone in this thread for all of the awesome work!!
I'm currently using Kegbot and I'm looking to move away from it. I've got RPints installed and running. I was wondering if anyone can help getting my Particle Photon working? I selected the correct prompts during the install script. My logs show that MQTT is up and running without issue. I've never worked with MQTT so I have no idea if any additional steps are needed there. I've searched this thread and google and have come up empty in terms of getting this Photon configured. I see this post #4926 by @bscuderi but there isn't much detail in how he got it working. Any and all help is GREATLY appreciated!

-Cheers!

 

[RandR+]

those where changed by the update.

THanks for the heads up, i will review my update script to see if it has a bad update in it

 

[Roadrune]

I am back with another stupid question

For the temp sensor and PIR, does it matter which GPIO i connect them to?
Have to make holes in the case for the connectors, so it would be easier and look better if i could connect everything in the same area.

 

[RandR+]

temp sensor and PIR, does it matter which GPIO i connect them to?

PIR you can specify which pin to use

temp sensor by default needs to be on GPIO pin 4 (pin 7)
That cannot be changed in RPints but you can change it in the Pi settings
https://pinout.xyz/pinout/1_wire

 

[Roadrune]

Thanks, gpio4 is fine, then i can just use 14 for the PIR and everything is golden with 3.3v and 5v plus ground being in the same area.

 

[Roadrune]

Is it possible to use EBC for color instead of SRM?