Exporting data to other systems

Exporting data to other systems


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.

Step 1. Select Animals

  1. If you Do Not wish to involve All Animals.
  2. Select the Animals for which you wish to Export specified data, via the Current Animal listing.

Step 2. Master CSV File

  • Click on the File.
  • Export Options.
  • Master CSV File menu option.

Step 3. Animals to Export Box

Select the Animals to Export details by clicking on the radial button for either:
  1. Selected Animals (the animals you have already selected in the current animal list), or
  2. All Active Animals.

Step 4. Select Relevant Criteria

  • Select the relevant criteria that you would like to export.
  • For more details notes on selection, see other notes below.

Step 5.  Save the CSV File

  • Click on the Export Master button.
  • Save the csv file to your computer.

Step 6. Import this File

You are now able to import this file into other equipment or software.

OTHER NOTES:

Details to be exported

  • You have a number of options as to which data is to be exported. The data is divided into sections (types) e.g. weights, traits.
    To see the information available for each section, click on the '+' button to the left of each section. Similarly, click on the - button to compress the list
  • Within a section, simply tick any item you want to include in the export. To remove an item from your selection, untick it. You can include all items in a section by ticking the section name.

  • Having specified the details required, for some sections you then have the option of how many of the most recent recordings of each item you require.
    For example, if you want the 3 most recent weights, type 3 against the Weights box

  • If you are exporting electronic ID's. you can choose the EID export format. All EIDs are held in Stockbook as 3 digits, a space, 12 digits.
    If you choose the 'replace blank' option, you will be asked to indicate which character you want to use instead

Some special cases

There are some data sections that need clarification:
  • EBV's: You can specify which type of EBV is required. Only those traits that you have marked as in-use in the Setup/Performance/Traits Analysis System
     will be displayed as options for export.
    Accuracies are not included in the export.
  • Treatments: Only the most recent treatment for each required animal can be exported.

  • TraitsOnly the traits that you have marked as active (Setup/Performance/Traits) will be displayed as options for export.

  • Draft: If this section is ticked, any of the required animals that are in a user list that contains the word DRAFT followed by just a number e.g. MY DRAFT 1
    will have the number exported as the draft.

    This means that you can use all the power of Stockbook (for example the very sophisticated drafting options in the laptop screen) to create simple user lists for drafting

Explanation of buttons:

  • Cancel/Exit - Close the window.

  • Save - Remember the current settings.

  • Export Master - Create a CSV file (You will get a Save As screen appear that allows you to save the file to any location you chose with whatever name that you want), containing all the required data for the specified animals. This file will have a header record, documenting each of the data items contained in it.

  • Export Lookups - You can also create a CSV file for each of your product, breed and observation code (stage) lists. This makes it simple for them to be imported into other equipment. These files will be created in a special folder (you will be notified what it is) and will be named products.csv, breeds.csv and stages.csv respectively.

  • Reset EBV's - If you have changed the names or usage of any of the EBVs, you will need to click on this button to see the new settings.

  • Reset Traits - If you have changed the names or usage of any of the traits, you will need to click on this button to see the new settings.

  • Print - You can print your current settings, for easy faxing to your 3rd-party supplier, in case any customisation is required.

  • Transfer to Handheld Device - If you own a handheld device with supporting software to transfer data in the csv file into that device, you can load that software from within Stockbook. You will need to provide the full path to that software i.e. the folder containing the software and the name of the software. You can either type in the path and name, or click on the ellipsis button to locate the program on your computer


Article ID 1184
    • Related Articles

    • Exporting to a TSI

      Exporting Stockbook Data to a TSi Step 1. Select Animals Select the animals that you wish to export to the Gallagher TSi. Holding control allows you to select multiple random animals. Step 2. Select File Select File then click Export then click TSi ...
    • Exporting Weights to Breedplan

      Exporting weights to Breedplan Step 1. Animals can be either: selected on the basis of any animal whose performance data matches the entered criteria e.g. weight type, date range. (see Step 3), or preselected on the main animal list (see below) Click ...
    • Data Warehouse - Unknown Error.

      Receiving an "unknown error" when trying to connect to the Data Warehouse: This may be due to your Data Warehouse subscription being out of date. Annual subscription clients have the Data Warehouse included in their package. Clients who purchase ...
    • Data level errors

      Data Level Errors This error will be caused by trying to restore a backup that is from a newer version into an older version of the software. To solve this upgrade to the most recent version of the program. Step 1. Checking for Updates To Check for ...
    • Exporting contact list to excel

      Step 1. Contacts Click on the Contacts toolbar icon. The list presents basic details of every contact in your database. A Dark Green background means that you have selected the contact. You may select contacts in a continuous group by clicking on the ...