/
Importing Animal Worksheets via Universal File Import Utility (UFIU)

Importing Animal Worksheets via Universal File Import Utility (UFIU)

This article will guide you through importing Animal Worksheets via UFIU.

In this article:

It is recommended to make a backup via File → Backup Data prior to importing data.

Worksheet Import - Column in File Method

 Instructions

The instructions below assume the import file contains 2 columns: Animal Tag, Worksheet Name. If you are importing other data, you will need to modify your template and file accordingly.

  1. Start by checking the layout of your file. We will need to adjust our template to map the columns to specific data based on the columns position in the file. You can open the UFIU in HerdMASTER by going to Utilities → Import → Universal File Import Utility.

    image-20250218-025032.png

  2. For our sample data here we will need 2 columns in our template: Animal Tag and Worksheet Name. If you have an existing template you want to modify you can select edit template, or add a new one. It is usually best to add a new template for each of the different file layouts you will be working with to save time in editing them. We can click on the browse button […] to select the file and then click Load Selected File. A preview of the data will then display.

    image-20250218-030555.png
    image-20250218-025641.png

  3. You can click on the columns to be presented with a list of options to map the column to.

    image-20250218-025740.png
    image-20250218-025815.png

If your file has a row with column names, make sure to tick the box marked First Row Contains Column Names or this may import a new animal with those values.

image-20250218-030055.png

  1. Once you have mapped both columns, you can then click Save and Close.

  1. Now that our template is ready, we can select it from the list of templates and click Next. On the following screen, you will need to select the file and click on Next. You will then be presented with a preview window similar to the template window.

Make sure to verify the data is correct before clicking next on this screen.

  1. You will receive a summary on the next screen. If everything was done correctly, you should see Animals to Worksheet ticked with the number of animals in the file. Click Next and then Import to finish importing the Animals.

If you are attempting to import new animals and the box for New/Updated Animals is 0, then you may need additional columns for an Animal to be created e.g. Date of Birth

  1. Once the import is complete, you will be presented with an Import Summary screen. If any of the imports failed, you can view and export them (using the excel button) in the Import Errors tab. If you are having difficulties, you can send this file to us to analyse.

Worksheet Import - Ad-Hoc Method

 Instructions

The instructions below can be used to add animals to a worksheet as part of a regular import.

Say we have an existing template and file that is ready to import, and we want to add these animals to a worksheet.

  1. Start by going through the normal steps of importing a file until we reach the preview window before finalising the import.

  2. Click on the Add Code Column button at the bottom right of the window and select Worksheet Name

    image-20250218-032606.png
    image-20250218-032736.png

  3. Type in the worksheet name you would like the animals added to. Then proceed with the import.

This can be a new or existing worksheet name.

 Related articles

Here are some related articles on importing data