← Back to Help Center

Importing feed mixer CSV files into GanFarm: step-by-step

Prepare a feed mixer CSV, map pen and ration names, preview errors and safely import delivery records without duplicates.

1. Prepare a CSV/TXT file

Download the CSV template in Livestock > Feedlot > Import mixer file. Populate it using an export that represents actual feed unloaded at each pen, not only planned loads. This imports files; it is not a live hardware connection.

Required columns include Pen, Ration, Date/time and Delivered kg; Farm disambiguates duplicated pen codes. Operation ID and Notes are optional. Codes and ration names must match GanFarm records.

Supported separators include semicolon, comma, tab and pipe; headers may be Spanish, English or Portuguese. Use UTF-8 CSV/TXT up to 2 MB, with at most 100 deliveries per file.

  1. Create pens, assign animals and register rations in GanFarm first.
  2. Download the template and replace the entire example row; do not import it as real data.
  3. For every drop, enter local date/time, pen, ration and actual kg; include an operation reference when available.
  4. Save in UTF-8 and check the decimal and thousands format.
  5. Compare total kilograms with the original operator or mixer report.

2. Preview, validation and timezone

Select the timezone of the file's local timestamps. Uruguay is normally UTC−03:00. For different locations or historical daylight-saving periods, choose the correct fixed offset; the same offset applies to every row.

Press Preview file. GanFarm checks pens, recipes, dates and quantities within the current company. Empty pens, ambiguous names and invalid quantities produce row errors. Nothing can be confirmed until all errors are resolved.

With Deduct stock selected, the preview also checks kilogram units and available inventory. Preview does not create deliveries or alter inventory. Do not deduct when stock has not been reconciled.

  1. Match record count and total kilograms to the source file.
  2. Verify delivery timestamps and timezone.
  3. Resolve errors in the file or GanFarm catalogue, then preview again.
  4. Confirm only after all rows validate.
  5. Inspect import history and the feeding report per pen.

3. Avoid duplicates and understand stock deductions

GanFarm identifies files by content and company. Uploading the identical file again does not recreate deliveries or deduct stock twice. A modified file has a different fingerprint and may duplicate real-world operations; reconcile older imports first.

Confirmation stores an audited import batch, its deliveries and the pen's current animal membership. Optional ingredient deductions run in the same transaction, so a failure should not partially save the batch.

Head counts are captured at import time, not reconstructed for historical dates. Kg/head are administrative allocations, not measured intake; costs use current inventory prices and exclude other production expenses.

  • Never import corrected versions without reconciling prior deliveries.
  • Do not publish private animal or farm records.
  • Import does not submit official traceability events or alter RFID weights.

4. FAQ and next steps

Pen not found: verify its farm and code. Ration not found: create the formula in Feedlot. Stock insufficient: check ingredients, kg units and quantities in Inventory.

Can I upload XLSX or connect via Bluetooth? This phase only accepts CSV/TXT, not XLSX or live mixer connections. Export XLSX to UTF-8 CSV first; hardware connectors need model-specific tests.

Open Feedlot > Feeding reports to filter by date, compare kilograms and estimated costs per pen and export CSV. This is not a dry-matter or feed-conversion calculation.

If an imported batch is incorrect, do not upload a corrected file without first reviewing the existing records. Individual deliveries can be voided with an audit reason and reversal of deducted stock. Whole mixer import batches are not automatically rolled back; reconcile before importing a corrected file.