Edit Existing Treatments – using Import/Export CSV (web)

Edit Existing Treatments – using Import/Export CSV (web)

The Import/Export CSV function can be used to add or edit Treatments in Imported, Scanned or Bulk Sessions entered via the web or the app.
Data can be added or edited in a selected Session by:
  1. Exporting a CSV of the existing Session information,
  2. Editing the desired fields and
  3. Importing the CSV file containing the updated information.

Exporting a CSV of an existing Session

  1. Select Sessions. Select the Session that needs to be added to/edited.

  2. Select Import/Export CSV, Import/Export Treatments.

  3. Select Export Treatments to CSV. A CSV file will be downloaded to your PC.
  4. To make it easier to amend details of a subset of the animal treatments in session, they can be exported to CSV separately.
    Select the required animal scans from the session the select Bulk Actions, Export Treatments to CSV. The CSV file will be downloaded to your PC.

Editing the Exported CSV Treatments file

Warning
Edit via CSV results in a complete overwrite of the field value. StockMate does not record the original value entered in the session. To maintain a copy of the data prior to Edits, it is recommended to save a copy of the Exported file before continuing.
  1. Locate the Exported Treatments CSV file on your PC, Open.


  2. Add/Edit the required information in the CSV file. Save the file in CSV format.
    For example, the Batch number of the Treatment had not been recorded at the time of the Session, and needs to be updated.
    Info
    Refer Import CSV – Input Information (web) for detailed information about the required formatting in CSV files.
    Alert
    Do not change the format of any fields in the Exported CSV file as this will cause errors when imported into StockMate.

Importing Treatments CSV into StockMate

  1. Select Sessions. Select the Session that needs to be added to/edited.

  2. Select Import/Export CSV, Import/Export Treatments.

  3. Select Browse...Locate the updated CSV file on your PC, select Open.
  4. Select Import X Records.

    Info
    If there are errors in the edited Treatments CSV file being imported, select Download Errors to view and fix errors before re-importing the CSV file.
  5. A message will flash in green in the top right hand corner of the screen to denote that the Import was completed successfully.

  6. The Session Screen will display the imported information. Select an animal to view the Batch Number imported into StockMate.

  7. Select Treatments to view the details of the treatment items imported via CSV.