[Version 2 Release] RaspberryPints - Digital Taplist Solution

Homebrew Talk - Beer, Wine, Mead, & Cider Brewing Discussion Forum

Help Support Homebrew Talk:

mrstone14

Active Member
Joined
Aug 28, 2011
Messages
25
Reaction score
2
Location
San Diego
what pins were you using with the Mega?
Originally, I was using pin 2 to test, but that was a couple days ago before I reached out for help here. In the latest failed attempt before moving to the Nano I was on Mega pin 6, so maybe that was the issue. I might try back on pin 2 or one of the others you mentioned.

Nano pins 5 and 6 are working great, but based on the link you sent, should I use pins 2 and 3 instead? I plan to use the Nano in the final build anyway, so I am happy with the progress so far.

Thanks!
 

day_trippr

Get the shot ffs! Sheesh!
Joined
May 31, 2011
Messages
37,340
Reaction score
20,163
Location
Stow, MA
what pins were you using with the Mega? there is a limited number of pins that can be used because the logic uses interrupts to get the count for the pour.

seems like pins 2, 3, 18, 19, 20, 21 are available to use ( attachInterrupt() - Arduino Reference )

This is one downside to the logic but its more accurate to use interrupts then the loop to check for high/low state
Wait - I'm confused. This implies (strongly!) that the only Arduino pins that can be used are the ones that support external interrupts. If that was the case nobody could have more than a few meters in service, but clearly there are a ton of folks (like me) with way more meters on Unos than the 2 shown...

Cheers!
 

RandR+

Well-Known Member
Joined
Oct 5, 2015
Messages
884
Reaction score
291
way more meters on Unos than the 2 shown...
Correct so im confused as well but they are allowed to be used for now.

I will need to update the logic to handle pins that do not support interrupts to use the old logic to poll them though im not sure if there is an easy way to tell if the pin doesnt support interupts
 

beerNbikes

Supporting Member
HBT Supporter
Joined
Jul 3, 2020
Messages
30
Reaction score
5
Location
Ballarat
Wait - I'm confused. This implies (strongly!) that the only Arduino pins that can be used are the ones that support external interrupts. If that was the case nobody could have more than a few meters in service, but clearly there are a ton of folks (like me) with way more meters on Unos than the 2 shown...

Cheers!
Yeah, got six on my Uno.

2,5,6,7,8 & 9
 

beerNbikes

Supporting Member
HBT Supporter
Joined
Jul 3, 2020
Messages
30
Reaction score
5
Location
Ballarat
Hi Randr+, just randomly thought I would backup the DB, clicked the backup in the install and got this.

Validating Entries...Success!
Checking DB connectivity...Success Connecting to Database!
Checking config folder permissions...Success!
backing RaspberryPints...
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 191297792 bytes) in /var/www/html/install/includes/configprocessor.php on line 174

Is this a hardware limitation? Is there anything I can do about it?

Cheers!
 

day_trippr

Get the shot ffs! Sheesh!
Joined
May 31, 2011
Messages
37,340
Reaction score
20,163
Location
Stow, MA
Yeah, got six on my Uno.
2,5,6,7,8 & 9
Right - the pins I advised to Alamode users start out with those, followed by 10 and 11, then "maybe" 12 as that one's tied to an Alamode level-shifter.
Then 13, which also has the "Blink" LED, and which in RandR+'s version is used as a heartbeat indicator, so that one's no longer viable...

Cheers!
 

day_trippr

Get the shot ffs! Sheesh!
Joined
May 31, 2011
Messages
37,340
Reaction score
20,163
Location
Stow, MA
For the record I have not yet switched my keezer from the "Classic 2.0.1" R'Pints but I have a recent-ish version of RandR+'s kit running on a test bed with an Alamode hat. I just verified that - through whatever implementation lies under the hood (I haven't looked yet) - it does count an SF800 on the pins I use (2 and 5 through 9), so I expect it will work for any non-conflicted digital IO pin on an Uno or Alamode.

I don't think I have a free Mega otherwise I'd check that one out as well...

Cheers!
 

ellj

New Member
Joined
Sep 21, 2021
Messages
4
Reaction score
1
Hi all, got the RandR version of RaspberryPints up and running. I am nowing adding a temperature probe. The temp probe is connected to the gpio4 and 3.3v and ground pins on the pi (no arduino). I believe I have connected it successfully and I can cat the file from the command line and get results back.

Code:
[email protected]:/sys/bus/w1/devices/28-01205fdf7e7b $ cat w1_slave
46 00 4b 46 7f ff 0c 10 12 : crc=12 YES
46 00 4b 46 7f ff 0c 10 12 t=4375
However the probe is not showing up in the Admin portal. I took a look through the logs and saw this error in error.log:

Code:
[Tue Sep 21 10:50:02.124756 2021] [php7:warn] [pid 661] [client 192.168.1.39:60301] PHP Warning:  fsockopen(): unable to connect to localhost:48866 (Connection refused) in /var/www/html/admin/trigger.php on line 45, referer: http://beerbot.local/admin/temp_probe_list.php
Any ideas?
 

RandR+

Well-Known Member
Joined
Oct 5, 2015
Messages
884
Reaction score
291
However the probe is not showing up in the Admin portal. I took a look through the logs and saw this error in error.log:
that error indicates that the web interface could not contact the python to do an update (i.e turn on Temp Probes)

Did you initially setup Rpints with Temp Probes? It needs the python to read the file. Check if you have /var/log/rpints.log if so check there for errors if not then you may not have enabled the python to read the temp probes
 

ellj

New Member
Joined
Sep 21, 2021
Messages
4
Reaction score
1
that error indicates that the web interface could not contact the python to do an update (i.e turn on Temp Probes)

Did you initially setup Rpints with Temp Probes? It needs the python to read the file. Check if you have /var/log/rpints.log if so check there for errors if not then you may not have enabled the python to read the temp probes
I didn't before.

I have redone the install by curl/sudo bash and selecting reinstall and saying Yes to wanting the temp probes but still have same issue.

I don't seem to have a /var/log/rpints.log

Any recommendations on what to try next?
 

RandR+

Well-Known Member
Joined
Oct 5, 2015
Messages
884
Reaction score
291
Any recommendations on what to try next?
I see the issue, i never put logic in the install script to install the python service if you are not using the flowmeters.

I will find time to update that but in the mean time you can rerun the installer, reconfigure Rpints and have it install Flow Meters it shouldnt hurt anything if there isnt a arduino connected to the pi
 

ellj

New Member
Joined
Sep 21, 2021
Messages
4
Reaction score
1
I see the issue, i never put logic in the install script to install the python service if you are not using the flowmeters.

I will find time to update that but in the mean time you can rerun the installer, reconfigure Rpints and have it install Flow Meters it shouldnt hurt anything if there isnt a arduino connected to the pi
Thanks for looking in to this!
 

DirtyRed07

Active Member
Joined
Feb 9, 2021
Messages
32
Reaction score
0
Probably in the wrong thread, but I tried to export a beer com file from Brewfather yesterday. When I tried to upload it, I got a “couldn’t run query” error. When I clicked on the beer, it had some parts of my recipe but left off 3 grains, it also didn’t show the style. Any help?
 

DirtyRed07

Active Member
Joined
Feb 9, 2021
Messages
32
Reaction score
0
Probably in the wrong thread, but I tried to export a beer com file from Brewfather yesterday. When I tried to upload it, I got a “couldn’t run query” error. When I clicked on the beer, it had some parts of my recipe but left off 3 grains, it also didn’t show the style. Any help?
Xml file
 

RandR+

Well-Known Member
Joined
Oct 5, 2015
Messages
884
Reaction score
291
When I tried to upload it, I got a “couldn’t run query” error. When I clicked on the beer, it had some parts of my recipe but left off 3 grains, it also didn’t show the style. Any help?
Can you send me the XML File and I will try it to see if i can find the error
 

DirtyRed07

Active Member
Joined
Feb 9, 2021
Messages
32
Reaction score
0
Can you send me the XML File and I will try it to see if i can find the error
<?xml version="1.0" encoding="ISO-8859-1"?>
<RECIPES>
<RECIPE>
<NAME>Borderline</NAME>
<VERSION>1</VERSION>
<TYPE>All&#32;Grain</TYPE>
<NOTES/>
<STYLE>
<NAME>Black&#32;IPA</NAME>
<CATEGORY>IPA</CATEGORY>
<VERSION>1</VERSION>
<CATEGORY_NUMBER>21</CATEGORY_NUMBER>
<STYLE_LETTER>B</STYLE_LETTER>
<STYLE_GUIDE>BJCP&#32;&#50;&#48;&#49;&#53;</STYLE_GUIDE>
<TYPE>IPA</TYPE>
<OG_MIN>1.05</OG_MIN>
<OG_MAX>1.085</OG_MAX>
<FG_MIN>1.01</FG_MIN>
<FG_MAX>1.018</FG_MAX>
<IBU_MIN>50</IBU_MIN>
<IBU_MAX>90</IBU_MAX>
<COLOR_MIN>25</COLOR_MIN>
<COLOR_MAX>40</COLOR_MAX>
</STYLE>
<BREWER>Brotherhood&#32;Brewing</BREWER>
<BATCH_SIZE>20.819765</BATCH_SIZE>
<BOIL_SIZE>28.39</BOIL_SIZE>
<BOIL_TIME>60</BOIL_TIME>
<EFFICIENCY>70</EFFICIENCY>
<OG>1.062</OG>
<FG>1.015</FG>
<ABV>6.17 %</ABV>
<EST_ABV>6.17 %</EST_ABV>
<IBU>70.6</IBU>
<EST_OG>1.062 SG</EST_OG>
<EST_FG>1.015 SG</EST_FG>
<EST_COLOR>38 SRM</EST_COLOR>
<CARBONATION>2.4</CARBONATION>
<HOPS>
<HOP>
<BF_ID>default-219e4a4e</BF_ID>
<NAME>Columbus&#47;Tomahawk&#47;Zeus&#32;&#40;CTZ&#41;</NAME>
<VERSION>1</VERSION>
<ALPHA>15.5</ALPHA>
<AMOUNT>0.0141</AMOUNT>
<USE>Boil</USE>
<TIME>60</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-36ce1e32</BF_ID>
<NAME>Simcoe</NAME>
<VERSION>1</VERSION>
<ALPHA>13</ALPHA>
<AMOUNT>0.014174761999999999</AMOUNT>
<USE>Boil</USE>
<TIME>20</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-7f594625</BF_ID>
<NAME>Galena</NAME>
<VERSION>1</VERSION>
<ALPHA>14.2</ALPHA>
<AMOUNT>0.014199999999999999</AMOUNT>
<USE>Boil</USE>
<TIME>10</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-36ce1e32</BF_ID>
<NAME>Simcoe</NAME>
<VERSION>1</VERSION>
<ALPHA>13</ALPHA>
<AMOUNT>0.014199999999999999</AMOUNT>
<USE>Boil</USE>
<TIME>10</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-219e4a4e</BF_ID>
<NAME>Columbus&#47;Tomahawk&#47;Zeus&#32;&#40;CTZ&#41;</NAME>
<VERSION>1</VERSION>
<ALPHA>15.5</ALPHA>
<AMOUNT>0.0070999999999999995</AMOUNT>
<USE>Boil</USE>
<TIME>10</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-7f594625</BF_ID>
<NAME>Galena</NAME>
<VERSION>1</VERSION>
<ALPHA>14.2</ALPHA>
<AMOUNT>0.014199999999999999</AMOUNT>
<USE>Boil</USE>
<TIME>5</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-36ce1e32</BF_ID>
<NAME>Simcoe</NAME>
<VERSION>1</VERSION>
<ALPHA>13</ALPHA>
<AMOUNT>0.014199999999999999</AMOUNT>
<USE>Boil</USE>
<TIME>5</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-219e4a4e</BF_ID>
<NAME>Columbus&#47;Tomahawk&#47;Zeus&#32;&#40;CTZ&#41;</NAME>
<VERSION>1</VERSION>
<ALPHA>15.5</ALPHA>
<AMOUNT>0.0070999999999999995</AMOUNT>
<USE>Boil</USE>
<TIME>5</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-ea130494</BF_ID>
<NAME>Chinook</NAME>
<VERSION>1</VERSION>
<ALPHA>13</ALPHA>
<AMOUNT>0.0567</AMOUNT>
<USE>Dry&#32;Hop</USE>
<TIME>4320</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-36ce1e32</BF_ID>
<NAME>Simcoe</NAME>
<VERSION>1</VERSION>
<ALPHA>13</ALPHA>
<AMOUNT>0.0567</AMOUNT>
<USE>Dry&#32;Hop</USE>
<TIME>4320</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
</HOPS>
<FERMENTABLES>
<FERMENTABLE>
<BF_ID>default-108df1f</BF_ID>
<NAME>Pilsner&#32;Malt</NAME>
<SUPPLIER>Avangard</SUPPLIER>
<ORIGIN>Germany</ORIGIN>
<VERSION>1</VERSION>
<TYPE>Grain</TYPE>
<AMOUNT>2.721554</AMOUNT>
<YIELD>81</YIELD>
<COLOR>1.7</COLOR>
<ADD_AFTER_BOIL>false</ADD_AFTER_BOIL>
<NOT_FERMENTABLE>false</NOT_FERMENTABLE>
<IBU_GAL_PER_LB>0</IBU_GAL_PER_LB>
</FERMENTABLE>
<FERMENTABLE>
<BF_ID>default-72225b4</BF_ID>
<NAME>Vienna&#32;Malt</NAME>
<SUPPLIER>Avangard</SUPPLIER>
<ORIGIN>Germnay</ORIGIN>
<VERSION>1</VERSION>
<TYPE>Grain</TYPE>
<AMOUNT>1.814369</AMOUNT>
<YIELD>82</YIELD>
<COLOR>3</COLOR>
<ADD_AFTER_BOIL>false</ADD_AFTER_BOIL>
<NOT_FERMENTABLE>false</NOT_FERMENTABLE>
<IBU_GAL_PER_LB>0</IBU_GAL_PER_LB>
</FERMENTABLE>
<FERMENTABLE>
<BF_ID>default-si-ryen</BF_ID>
<NAME>Rye&#32;Malted</NAME>
<SUPPLIER>Simpsons</SUPPLIER>
<ORIGIN>UK</ORIGIN>
<VERSION>1</VERSION>
<TYPE>Grain</TYPE>
<AMOUNT>0.907185</AMOUNT>
<YIELD>78</YIELD>
<COLOR>2.0304569</COLOR>
<ADD_AFTER_BOIL>false</ADD_AFTER_BOIL>
<NOT_FERMENTABLE>false</NOT_FERMENTABLE>
<IBU_GAL_PER_LB>0</IBU_GAL_PER_LB>
</FERMENTABLE>
<FERMENTABLE>
<BF_ID>default-acEyKOGQv6yLYat6Ukh6hRKz6aULo0</BF_ID>
<NAME>Blackprinz&#32;Malt</NAME>
<SUPPLIER>Briess</SUPPLIER>
<ORIGIN>US</ORIGIN>
<VERSION>1</VERSION>
<TYPE>Grain</TYPE>
<AMOUNT>0.226796</AMOUNT>
<YIELD>71.47</YIELD>
<COLOR>676.5</COLOR>
<ADD_AFTER_BOIL>false</ADD_AFTER_BOIL>
<NOT_FERMENTABLE>false</NOT_FERMENTABLE>
<IBU_GAL_PER_LB>NaN</IBU_GAL_PER_LB>
</FERMENTABLE>
<FERMENTABLE>
<BF_ID>default-a84cbb8</BF_ID>
<NAME>Chocolate</NAME>
<SUPPLIER>Briess</SUPPLIER>
<ORIGIN>US</ORIGIN>
<VERSION>1</VERSION>
<TYPE>Grain</TYPE>
<AMOUNT>0.226796</AMOUNT>
<YIELD>75.8</YIELD>
<COLOR>473.4</COLOR>
<ADD_AFTER_BOIL>false</ADD_AFTER_BOIL>
<NOT_FERMENTABLE>false</NOT_FERMENTABLE>
<IBU_GAL_PER_LB>NaN</IBU_GAL_PER_LB>
</FERMENTABLE>
<FERMENTABLE>
<BF_ID>default-c7477f7</BF_ID>
<NAME>Special&#32;B&#32;Malt</NAME>
<SUPPLIER/>
<ORIGIN>Belgium</ORIGIN>
<VERSION>1</VERSION>
<TYPE>Grain</TYPE>
<AMOUNT>0.113398</AMOUNT>
<YIELD>65.2</YIELD>
<COLOR>180</COLOR>
<ADD_AFTER_BOIL>false</ADD_AFTER_BOIL>
<NOT_FERMENTABLE>false</NOT_FERMENTABLE>
<IBU_GAL_PER_LB>0</IBU_GAL_PER_LB>
</FERMENTABLE>
</FERMENTABLES>
<YEASTS>
<YEAST>
<BF_ID>default-d33dc0</BF_ID>
<NAME>American&#32;Ale</NAME>
<VERSION>1</VERSION>
<TYPE>Ale</TYPE>
<FORM>Liquid</FORM>
<AMOUNT>2</AMOUNT>
<LABORATORY>Wyeast&#32;Labs</LABORATORY>
<PRODUCT_ID>1056</PRODUCT_ID>
<DISPLAY_AMOUNT>2 pkg</DISPLAY_AMOUNT>
<ATTENUATION>77</ATTENUATION>
</YEAST>
</YEASTS>
<MASH>
<BF_ID>default</BF_ID>
<NAME>High&#32;fermentability</NAME>
<VERSION>1</VERSION>
<GRAIN_TEMP>20</GRAIN_TEMP>
<MASH_STEPS>
<MASH_STEP>
<NAME>Temperature</NAME>
<VERSION>1</VERSION>
<TYPE>Temperature</TYPE>
<STEP_TEMP>66.7</STEP_TEMP>
<STEP_TIME>60</STEP_TIME>
<INFUSE_AMOUNT>32.06</INFUSE_AMOUNT>
</MASH_STEP>
</MASH_STEPS>
</MASH>
<EQUIPMENT>
<NAME>Red&#8217;s</NAME>
<VERSION>1</VERSION>
<BOIL_SIZE>28.39</BOIL_SIZE>
<BATCH_SIZE>20.819765</BATCH_SIZE>
<TRUB_CHILLER_LOSS>0.984207</TRUB_CHILLER_LOSS>
<LAUTER_DEADSPACE/>
<BOIL_TIME>60</BOIL_TIME>
<HOP_UTILIZATION>100</HOP_UTILIZATION>
<EVAP_RATE>20.00041563930962</EVAP_RATE>
<CALC_BOIL_VOLUME>true</CALC_BOIL_VOLUME>
</EQUIPMENT>
<BF_FERMENTATION_PROFILE_ID>default</BF_FERMENTATION_PROFILE_ID>
<BF_FERMENTATION_PROFILE_NAME>Ale</BF_FERMENTATION_PROFILE_NAME>
<FERMENTATION_STAGES>1</FERMENTATION_STAGES>
<PRIMARY_AGE>14</PRIMARY_AGE>
<PRIMARY_TEMP>18.333333</PRIMARY_TEMP>
</RECIPE>
</RECIPES>
 

DirtyRed07

Active Member
Joined
Feb 9, 2021
Messages
32
Reaction score
0
<?xml version="1.0" encoding="ISO-8859-1"?>
<RECIPES>
<RECIPE>
<NAME>Borderline</NAME>
<VERSION>1</VERSION>
<TYPE>All&#32;Grain</TYPE>
<NOTES/>
<STYLE>
<NAME>Black&#32;IPA</NAME>
<CATEGORY>IPA</CATEGORY>
<VERSION>1</VERSION>
<CATEGORY_NUMBER>21</CATEGORY_NUMBER>
<STYLE_LETTER>B</STYLE_LETTER>
<STYLE_GUIDE>BJCP&#32;&#50;&#48;&#49;&#53;</STYLE_GUIDE>
<TYPE>IPA</TYPE>
<OG_MIN>1.05</OG_MIN>
<OG_MAX>1.085</OG_MAX>
<FG_MIN>1.01</FG_MIN>
<FG_MAX>1.018</FG_MAX>
<IBU_MIN>50</IBU_MIN>
<IBU_MAX>90</IBU_MAX>
<COLOR_MIN>25</COLOR_MIN>
<COLOR_MAX>40</COLOR_MAX>
</STYLE>
<BREWER>Brotherhood&#32;Brewing</BREWER>
<BATCH_SIZE>20.819765</BATCH_SIZE>
<BOIL_SIZE>28.39</BOIL_SIZE>
<BOIL_TIME>60</BOIL_TIME>
<EFFICIENCY>70</EFFICIENCY>
<OG>1.062</OG>
<FG>1.015</FG>
<ABV>6.17 %</ABV>
<EST_ABV>6.17 %</EST_ABV>
<IBU>70.6</IBU>
<EST_OG>1.062 SG</EST_OG>
<EST_FG>1.015 SG</EST_FG>
<EST_COLOR>38 SRM</EST_COLOR>
<CARBONATION>2.4</CARBONATION>
<HOPS>
<HOP>
<BF_ID>default-219e4a4e</BF_ID>
<NAME>Columbus&#47;Tomahawk&#47;Zeus&#32;&#40;CTZ&#41;</NAME>
<VERSION>1</VERSION>
<ALPHA>15.5</ALPHA>
<AMOUNT>0.0141</AMOUNT>
<USE>Boil</USE>
<TIME>60</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-36ce1e32</BF_ID>
<NAME>Simcoe</NAME>
<VERSION>1</VERSION>
<ALPHA>13</ALPHA>
<AMOUNT>0.014174761999999999</AMOUNT>
<USE>Boil</USE>
<TIME>20</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-7f594625</BF_ID>
<NAME>Galena</NAME>
<VERSION>1</VERSION>
<ALPHA>14.2</ALPHA>
<AMOUNT>0.014199999999999999</AMOUNT>
<USE>Boil</USE>
<TIME>10</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-36ce1e32</BF_ID>
<NAME>Simcoe</NAME>
<VERSION>1</VERSION>
<ALPHA>13</ALPHA>
<AMOUNT>0.014199999999999999</AMOUNT>
<USE>Boil</USE>
<TIME>10</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-219e4a4e</BF_ID>
<NAME>Columbus&#47;Tomahawk&#47;Zeus&#32;&#40;CTZ&#41;</NAME>
<VERSION>1</VERSION>
<ALPHA>15.5</ALPHA>
<AMOUNT>0.0070999999999999995</AMOUNT>
<USE>Boil</USE>
<TIME>10</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-7f594625</BF_ID>
<NAME>Galena</NAME>
<VERSION>1</VERSION>
<ALPHA>14.2</ALPHA>
<AMOUNT>0.014199999999999999</AMOUNT>
<USE>Boil</USE>
<TIME>5</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-36ce1e32</BF_ID>
<NAME>Simcoe</NAME>
<VERSION>1</VERSION>
<ALPHA>13</ALPHA>
<AMOUNT>0.014199999999999999</AMOUNT>
<USE>Boil</USE>
<TIME>5</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-219e4a4e</BF_ID>
<NAME>Columbus&#47;Tomahawk&#47;Zeus&#32;&#40;CTZ&#41;</NAME>
<VERSION>1</VERSION>
<ALPHA>15.5</ALPHA>
<AMOUNT>0.0070999999999999995</AMOUNT>
<USE>Boil</USE>
<TIME>5</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-ea130494</BF_ID>
<NAME>Chinook</NAME>
<VERSION>1</VERSION>
<ALPHA>13</ALPHA>
<AMOUNT>0.0567</AMOUNT>
<USE>Dry&#32;Hop</USE>
<TIME>4320</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
<HOP>
<BF_ID>default-36ce1e32</BF_ID>
<NAME>Simcoe</NAME>
<VERSION>1</VERSION>
<ALPHA>13</ALPHA>
<AMOUNT>0.0567</AMOUNT>
<USE>Dry&#32;Hop</USE>
<TIME>4320</TIME>
<FORM>Pellet</FORM>
<TEMPERATURE/>
<HOP_TEMP/>
</HOP>
</HOPS>
<FERMENTABLES>
<FERMENTABLE>
<BF_ID>default-108df1f</BF_ID>
<NAME>Pilsner&#32;Malt</NAME>
<SUPPLIER>Avangard</SUPPLIER>
<ORIGIN>Germany</ORIGIN>
<VERSION>1</VERSION>
<TYPE>Grain</TYPE>
<AMOUNT>2.721554</AMOUNT>
<YIELD>81</YIELD>
<COLOR>1.7</COLOR>
<ADD_AFTER_BOIL>false</ADD_AFTER_BOIL>
<NOT_FERMENTABLE>false</NOT_FERMENTABLE>
<IBU_GAL_PER_LB>0</IBU_GAL_PER_LB>
</FERMENTABLE>
<FERMENTABLE>
<BF_ID>default-72225b4</BF_ID>
<NAME>Vienna&#32;Malt</NAME>
<SUPPLIER>Avangard</SUPPLIER>
<ORIGIN>Germnay</ORIGIN>
<VERSION>1</VERSION>
<TYPE>Grain</TYPE>
<AMOUNT>1.814369</AMOUNT>
<YIELD>82</YIELD>
<COLOR>3</COLOR>
<ADD_AFTER_BOIL>false</ADD_AFTER_BOIL>
<NOT_FERMENTABLE>false</NOT_FERMENTABLE>
<IBU_GAL_PER_LB>0</IBU_GAL_PER_LB>
</FERMENTABLE>
<FERMENTABLE>
<BF_ID>default-si-ryen</BF_ID>
<NAME>Rye&#32;Malted</NAME>
<SUPPLIER>Simpsons</SUPPLIER>
<ORIGIN>UK</ORIGIN>
<VERSION>1</VERSION>
<TYPE>Grain</TYPE>
<AMOUNT>0.907185</AMOUNT>
<YIELD>78</YIELD>
<COLOR>2.0304569</COLOR>
<ADD_AFTER_BOIL>false</ADD_AFTER_BOIL>
<NOT_FERMENTABLE>false</NOT_FERMENTABLE>
<IBU_GAL_PER_LB>0</IBU_GAL_PER_LB>
</FERMENTABLE>
<FERMENTABLE>
<BF_ID>default-acEyKOGQv6yLYat6Ukh6hRKz6aULo0</BF_ID>
<NAME>Blackprinz&#32;Malt</NAME>
<SUPPLIER>Briess</SUPPLIER>
<ORIGIN>US</ORIGIN>
<VERSION>1</VERSION>
<TYPE>Grain</TYPE>
<AMOUNT>0.226796</AMOUNT>
<YIELD>71.47</YIELD>
<COLOR>676.5</COLOR>
<ADD_AFTER_BOIL>false</ADD_AFTER_BOIL>
<NOT_FERMENTABLE>false</NOT_FERMENTABLE>
<IBU_GAL_PER_LB>NaN</IBU_GAL_PER_LB>
</FERMENTABLE>
<FERMENTABLE>
<BF_ID>default-a84cbb8</BF_ID>
<NAME>Chocolate</NAME>
<SUPPLIER>Briess</SUPPLIER>
<ORIGIN>US</ORIGIN>
<VERSION>1</VERSION>
<TYPE>Grain</TYPE>
<AMOUNT>0.226796</AMOUNT>
<YIELD>75.8</YIELD>
<COLOR>473.4</COLOR>
<ADD_AFTER_BOIL>false</ADD_AFTER_BOIL>
<NOT_FERMENTABLE>false</NOT_FERMENTABLE>
<IBU_GAL_PER_LB>NaN</IBU_GAL_PER_LB>
</FERMENTABLE>
<FERMENTABLE>
<BF_ID>default-c7477f7</BF_ID>
<NAME>Special&#32;B&#32;Malt</NAME>
<SUPPLIER/>
<ORIGIN>Belgium</ORIGIN>
<VERSION>1</VERSION>
<TYPE>Grain</TYPE>
<AMOUNT>0.113398</AMOUNT>
<YIELD>65.2</YIELD>
<COLOR>180</COLOR>
<ADD_AFTER_BOIL>false</ADD_AFTER_BOIL>
<NOT_FERMENTABLE>false</NOT_FERMENTABLE>
<IBU_GAL_PER_LB>0</IBU_GAL_PER_LB>
</FERMENTABLE>
</FERMENTABLES>
<YEASTS>
<YEAST>
<BF_ID>default-d33dc0</BF_ID>
<NAME>American&#32;Ale</NAME>
<VERSION>1</VERSION>
<TYPE>Ale</TYPE>
<FORM>Liquid</FORM>
<AMOUNT>2</AMOUNT>
<LABORATORY>Wyeast&#32;Labs</LABORATORY>
<PRODUCT_ID>1056</PRODUCT_ID>
<DISPLAY_AMOUNT>2 pkg</DISPLAY_AMOUNT>
<ATTENUATION>77</ATTENUATION>
</YEAST>
</YEASTS>
<MASH>
<BF_ID>default</BF_ID>
<NAME>High&#32;fermentability</NAME>
<VERSION>1</VERSION>
<GRAIN_TEMP>20</GRAIN_TEMP>
<MASH_STEPS>
<MASH_STEP>
<NAME>Temperature</NAME>
<VERSION>1</VERSION>
<TYPE>Temperature</TYPE>
<STEP_TEMP>66.7</STEP_TEMP>
<STEP_TIME>60</STEP_TIME>
<INFUSE_AMOUNT>32.06</INFUSE_AMOUNT>
</MASH_STEP>
</MASH_STEPS>
</MASH>
<EQUIPMENT>
<NAME>Red&#8217;s</NAME>
<VERSION>1</VERSION>
<BOIL_SIZE>28.39</BOIL_SIZE>
<BATCH_SIZE>20.819765</BATCH_SIZE>
<TRUB_CHILLER_LOSS>0.984207</TRUB_CHILLER_LOSS>
<LAUTER_DEADSPACE/>
<BOIL_TIME>60</BOIL_TIME>
<HOP_UTILIZATION>100</HOP_UTILIZATION>
<EVAP_RATE>20.00041563930962</EVAP_RATE>
<CALC_BOIL_VOLUME>true</CALC_BOIL_VOLUME>
</EQUIPMENT>
<BF_FERMENTATION_PROFILE_ID>default</BF_FERMENTATION_PROFILE_ID>
<BF_FERMENTATION_PROFILE_NAME>Ale</BF_FERMENTATION_PROFILE_NAME>
<FERMENTATION_STAGES>1</FERMENTATION_STAGES>
<PRIMARY_AGE>14</PRIMARY_AGE>
<PRIMARY_TEMP>18.333333</PRIMARY_TEMP>
</RECIPE>
</RECIPES>
It left out the rye, blackprinz, and chocolate malts. I tried two other xml files as well, and it did the same thing, left out a few ingredients and didn’t show the style/bcjp category
 

RandR+

Well-Known Member
Joined
Oct 5, 2015
Messages
884
Reaction score
291
It left out the rye, blackprinz, and chocolate malts. I tried two other xml files as well, and it did the same thing, left out a few ingredients and didn’t show the style/bcjp category
Thanks, it doesnt like the malts because the SRM is > 99
if you log into the database through the terminal (sudo mysql -D <databasename>) where database name default is raspberrypints
you can run these commands to allow > 99

ALTER TABLE fermentables MODIFY srm DECIMAL(7,1) NOT NULL ;
ALTER TABLE srmRgb MODIFY srm DECIMAL(7,1) NOT NULL ;
ALTER TABLE accolades MODIFY srm DECIMAL(7,1) NOT NULL ;


the beer style didnt add to to a lack of min abv, run these commands to remove that requirement:

ALTER TABLE beerStyles CHANGE COLUMN `abvMin` `abvMin` DECIMAL(3,1) NULL ;
ALTER TABLE beerStyles CHANGE COLUMN `abvMax` `abvMax` DECIMAL(3,1) NULL ;
ALTER TABLE beerStyles CHANGE COLUMN `ibuMin` `ibuMin` DECIMAL(3,0) NULL ;
ALTER TABLE beerStyles CHANGE COLUMN `ibuMax` `ibuMax` DECIMAL(3,0) NULL ;
ALTER TABLE beerStyles CHANGE COLUMN `srmMin` `srmMin` DECIMAL(7,1) NULL ;
ALTER TABLE beerStyles CHANGE COLUMN `srmMax` `srmMax` DECIMAL(7,1) NULL ;



I ran those on my system and the XML worked as expected. I will get those committed sometime this week so an update to the system will do them for everyone else.
 

robfar

Thomas Corcoran Brew Works
Lifetime Supporter
Joined
May 18, 2012
Messages
300
Reaction score
52
Location
Odenton
Trying to add some bottled beers, but keep running into "No Active Bottles." I was able to do this many updates ago; what am I missing?
 

RandR+

Well-Known Member
Joined
Oct 5, 2015
Messages
884
Reaction score
291
but keep running into "No Active Bottles."
it will say that till you hit save.

By default if you have no bottles it will say no active bottles and give you a row to fill in bottle information on
 

RandR+

Well-Known Member
Joined
Oct 5, 2015
Messages
884
Reaction score
291
Just tried putting in a cap number and then it worked.
Ah, yes it needs a cap number as the primary index on it, I should remove that requirement but not sure when ill get to it
 

Latest posts

Top