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 |