Importing Weights Data from CSV file

Importing Weights Data from CSV file

Importing a Weights Data CSV file into Stockbook  


Until you are confident in importing the values please make sure to take a Backup before importing the data.
If you have the CSV file open, please close it. Stockbook will not import data from a CSV file which is open.

1. Importing the Data File

  1. Select File
  2. Import Options
  3. Details From Data File


  1. Browse for the required file by selecting the yellow folder 
  1. Step 1. Select the file to import.
  2. Step 2. leave the file as '<Standard CSV file>'
  3. Step 3. Set the date format as per the image below




1B. Checking for Identification errors in Stockbook before importing the weights

  1. Set the default observation date to today's date
  2. Step 4. match the primary ID field by selecting 'Life Data' in Data Type and 'ID' in the Stockbook Field
  3. Select OK
  4. Stockbook will then import the data file and find any missing IDs
  5. If there are any errors it will provide you with a data file to view and update the Primary Id's on the CSV so that it imports correctly. 

1C. Tips for Successful Data Imports

  1. The key to success is to do the data import in small blocks so it is easy to spot errors.
  2. You will need to fix these on the CSV file before the data will import in full.
  3. Additionally, Stockbook will tell you how many animals have been imported.
  4. Once you are happy with the data lining up you can line up the fields you can proceed to Importing the Weights.

2. Importing the Weights

Once the above data is correct the weights can be imported into Stockbook. 

Please note that in this example data is imported against the animal's ID (VID).

Setting the import criteria 

In Step 3 Set your import options:-
  1. select the Default Obs. (Observation) Date on which the weights were collected.
  2. Select the Default Obs. Code. Note: If the Default Obs. (Observation) Code you are after is not in the drop down,
  3. click on the “ + “ to add your desired Obs code.
In Step 4. Match the Fields : - 
  1. Primary ID:       Data Type > Life Data      Stockbook Field > ID
  2. Weight:             Data Type > Weight      Stockbook Field> Weight
  3. If the file has multiple dates, do not select the Default Obs Date in Step 3, rather assign the data type and stockbook file in step 4 to your date.
Date:       Data Type > Date      Stockbook Field > Observation Date
  1. Select OK and Close 



3.  Locate and View the Imported Data

In the Animals Home Screen type last import in the Yard Sheets/User list Filter
Select Tab on your keyboard. This will display the animal you have just imported.


  1. Highlight an Animal
    1. Click on Weights (blue hyperlink at the bottom of the screen)
    2.  This will show the imported Weights and Weights History

  2. Using the Prior or Next buttons check that the other Animals have the latest weights data.



    • Related Articles

    • Import a CSV File

      Importing a CSV File Importing CSV files allows the user to bring animals and associated data into Stockbook. Before you begin Always take a backup of your Stockbook data before importing CSV files. CSV files can corrupt so it is advisable to create ...

    • Importing Carcase Data

      Stockbook provides an option that allows you to import carcass feedback data from Abattoirs. If the meat-works can supply you with a carcase feedback file in CSV format, you are able to import this information directly into Stockbook, which saves you ...

    • Exporting Data (Master CSV)

      Stockbook provides you with an easy method of creating a master .CSV (comma-separated variable) file, containing selected information, for easy transfer to other equipment or loading into other software. 1. Select Animals If you Do Not wish to ...

    • How to Save an Excel File as a CSV File

      Always create a copy of a .csv file before opening to avoid loss of data If you are importing data from excel into Stockbook the file must be in a Comma Delimited file otherwise known as a .csv file. If you have long numbers in your file (e.g. Sheep ...

    • Importing from Allflex Greenstick

      Import data directly from my Allflex Greenstick RS420 Note: Your reader must be connected to Stockbook for this process to work. Click here for instructions on connecting an Allflex Green stick reader. Once your reader is connected to Stockbook: ...