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.