iBrewmaster Batches: batches.json
SQLite Queries
List Batches
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
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 |