The records export puts your logbook in files you can open in a spreadsheet, keep, or pass on to an advisor or another tool. Owners, admins and editors can export records.
Start a records export
You can start it from any of these screens:
- In Field logbook, select Export records. If the logbook is filtered by date, the window uses those dates.
- In Overview, select Export, then Export records.
- In Exports, select New export, choose All records and select Next.
Then:
- Choose the options and select Next.
- Check Summary. It shows how many rows the export will hold. If it says Nothing to export for this period., choose a longer period or more farms.
- Select Start.
When the files are ready, download them from the window or from the export's page. See Follow an export and download it.
Choose what goes in
- Scope: Whole workspace, or Farms to tick some farms. If you start from Overview with a farm chosen, the window uses that farm. From Field logbook, only the dates carry over, so choose the farms here. Select Change to pick again.
- Period: This season (the default), Last 3 months, Last 12 months or Custom. Records count by their own date, in the farm's time zone. If the period is too long, the window tells you the longest one you can choose.
- Record kinds: keep the kinds you want ticked, for example Treatment and Observation. At least one must stay ticked.
- Include a list of photos: adds a list of the photos on your observations (not offered for the PDF). Keep Observation ticked, or the list is left out. The photos themselves come only with the full export.
- README language: the language of the README file that explains the columns. For a PDF, it is the language of the summary.
Not available yet
Irrigation and task records can't be added in the logbook yet, so those record kinds export no rows for now.
Choose a format
| Format | Best for |
|---|---|
| CSV (spreadsheet) | Keeping the data or loading it into another tool. A zip with a CSV file per kind of record, the same data as NDJSON, and a README. |
| Excel (XLSX) | Opening in a spreadsheet. A workbook with a sheet per kind of record, and a README next to it. |
| PDF summary | Reading, printing or sharing. A summary to read, print or share, grouped by field. It does not replace your records. To keep or reuse the data, choose Excel or CSV. |
The CSV files use a neutral format. Neutral format: commas, decimal point, ISO dates in UTC. Open with a CSV-aware tool; do not let a spreadsheet evaluate formulas.
Note
This export contains personal data (names, tax and registration numbers). Store it securely.
What the files contain
In the CSV and Excel formats, depending on the record kinds you choose:
- treatments, with a separate file for the products of each treatment;
- observations;
- seasons, operators and equipment, always included;
- the list of photos, when you ask for it.
Rows about a field carry the field's name and tags. The README lists every column.
The PDF is a single printable summary of your records, grouped by field. It carries its own notes, so it has no README, and it has no separate lists of seasons, operators or equipment. For the column definitions and formats, see What the files contain.
When the export changes format
Some exports are too big for the format you chose. The app then switches the format for you and tells you why:
- This export is too long for a readable PDF, so it will be an Excel file instead. A shorter period or fewer fields fit in a PDF.
- This export has more rows than one Excel sheet can hold, so it will be a CSV file instead.
Common problems
- Nothing to export for this period. Nothing was recorded in that period for the farms you chose. Choose another period or more farms.
This export is too large
Choose a shorter period or fewer farms.- Your exports are already in progress. The dialog says how many of yours are running in this workspace. Wait for one to finish, then start again.
Related pages
Still stuck?Email support.truleaf@truleaf.org