iBrewmaster Batches: batches.json
SQLite Queries
List Batches
| Code Block |
|---|
|
select z_pk, datetime(ZBATCHBREWDATE, 'unixepoch', '+31 years') as BREW_DATE, zbatchname, ZBATCHTYPE, ZBATCHSIZE,
ZBATCHBOILSIZE, ZBATCHBOILTIME, ZBATCHACTABV, ZBATCHACTOG, ZBATCHACTFG, ZBATCHEFFICIENCY, ZBATCHCOLOR,
ZBATCHRATING, ZBATCHNOTES from ZBATCHES order by z_pk
|
Equipment Profiles
| Code Block |
|---|
select ZEQPROFILENAME as Name , ZEQBOILOFFAMOUNT as BoilOffAmount, ZEQGRAINABSORPTION as GrainAborption, ZEQGRAINTEMP as GrainTemp, ZEQKETTLELOSS as KettleLoss, ZEQMASHTUNTEMPLOSS as MashTunTempLoss, ZEQMASHTUNVOLUMELOSS as MashTunVolumeLoss, ZEQWORTSHRINKAGE as WorkShrinkage from ZEQPROFILES |
References
| Reference | URL |
|---|
| *** Batch Export using ibrewmasterExtractor | batches.json |
| Latest SQL Lite DB | |
| Extraction using imazingapp | |
| SQL Lite DB | |
| Batch Export from iBrewmaster2 on Oct 5, 2014 | batches-10_05_2014.json |