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
If you Do Not wish to involve All Animals.
Select the Animals for which you wish to Export specified data, via the Current Animal listing.
Step 2. Master CSV File
Step 3. Animals to Export Box
Select the Animals to Export details by clicking on the radial button for either:
Selected Animals (the animals you have already selected in the current animal list), or
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
Step 6. Import this File
You are now able to import this file into other equipment or software.
OTHER NOTES:
Details to be exported
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.
Traits: Only 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
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 ...
Data Warehouse connection problems.
Getting a 'data warehouse connection lost' or 'timed out' error message when trying to save/retrieve data to and from the Data Warehouse. If you receive this type of error, there could be a problem with your internet connection. Please check that you ...