Exporting A Roast: What The CSV, JSON And .alog Hold
Summary
Any roast can be downloaded from its batch page: the … menu at the right end of the page header, then Export as CSV, Export as JSON or Export as .alog. The download starts straight away and the file is named after the roast.
The CSV opens with the roast's record, one item per row, name in the first column and value in the second: batch code, roast name, when the roast started (in UTC), Machine, Roasting Plan, green coffee, Lot, roaster name, input weight, output weight, weight loss, colour reading, colour scale, the roast duration from Charge to Drop, where Charge falls on the curve's clock, charge temperature, turning point, dry end, first crack and second crack times, drop temperature, development time, DTR and notes. A blank row follows, then the curve: one column per channel the machine recorded, each headed with its unit, one row per reading.
Every record row is written even when it was never filled in, so an empty value means nothing was entered or recorded. Weights in the record are in grams and its temperatures in °C, whatever units the roaster works in. Milestone times count from Charge, as the batch page shows them; the curve's Time column counts from when recording started.
The JSON holds the same record and curve, plus the milestones, control changes and timed comments on one timeline. Control changes and timed comments are only in the JSON.
The .alog file is for profile-design tools that import roasts in that format, such as Loring's Roast Architect (File > Import), to start a new profile from a Rostoc roast. It holds the bean and environment temperatures, the milestones (Charge, dry end, first crack start and end, second crack start and end, Drop, and the turning point), the roast name, green coffee, notes, roaster name and the input and output weights in grams. Its temperatures stay in the unit the machine recorded, °C or °F. Other channels, control changes, comments, colour and the Lot are not in it. A roast with no bean temperature cannot be exported as .alog.
Steps
- Open the roast's batch page, from Batches or from Home.
- Open the … menu at the right end of the page header (labelled Actions in older versions), then choose Export as CSV for a spreadsheet, Export as JSON for the full record with control changes and comments, or Export as .alog for a profile-design tool.
- Open the CSV in a spreadsheet. The roast's record is at the top; the curve starts after the first blank row.
- If a record row is empty, the value was not entered or not recorded for that roast. Fill it in with Edit batch on the batch page (output weight, colour, notes, roaster name) or Adjust green & inventory (Roasting Plan, green coffee, Lot, input weight), then export again. Milestones come from the marks on the chart.
- For every roast at once, use Settings → Your data → Export all my data. Each roast's CSV in that ZIP opens with the same record.