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 |