Sale Catalog Data Extracts

OVERVIEW:

Time is precious when you are marketing your bulls and females, so streamlining your sale catalog preparation can give you more one-on-one time with customers.

The Red Angus Association of America (RAAA) can save you time and money with a sale catalog data extract – now offered as a FREE service to RAAA members! By utilizing the data extract service, you are also ensuring your catalog information is accurate, complete and presented in a consistent format your customers are comfortable reading.
 
RAAA members may choose which format they want:  text file (tab–separated CSV) or one of the Microsoft Word templates already formatted into a sale catalog layout. The download includes three-generation pedigrees, complete performance data and the entire EPD suite with accuracies and breed-ranking percentiles.  The tab–separated CSV text file may be imported into Microsoft Excel.  For instructions on how to do this, visit here for Excel 2003, or here for Excel 2007 and later.

INSTRUCTIONS:

1. Review the available output format samples and decide which one will work best for you.

  • The samples are EXACTLY the same format as what you will receive (but with the data for your animals, not the sample ones). Please download the sample you want to make sure that it will work for you.
  • If the available formats don't work as you need, contact a graphic designer to create a custom layout for you.

2. Create an "input file" list of Registration Numbers in ONE text file or ONE Excel sheet of the animals for which you want the data (i.e. the ones in the sale).

  • Input file must be a single column of registration #s in either ONE text file or ONE Excel sheet (see sample input files below).
  • If you need multiple output files, submit multiple input files. Multiple Excel sheets or multiple columns will not be processed.
  • Extraneous data in the list of registration #s (e.g. column headings, group headings, comments, blank lots, etc.) will result in extraneous/bad data being returned to you.
  • The data output will be in the same order as the list you submit.
  • You can optionally include Lot Numbers (4 characters maximum) in a separate column before the column of registration numbers.
  • An empty or blank lot can be included by using a "0" (zero) for the registration number.
  • “Whole Herd”s (all active animals) can be extracted, with the following conditions:
    • Lot numbers will not be included.
    • The herd's owner/manager must give written authorization (email, fax) to the RAAA National Office.

3. Email the request including: output format selection and list of registration numbers to SCDE <scde@redangus.org>.

  • If you do not have access to email, call the National Office (940-387-3502) for alternative methods.
  • Prior to submitting the request, make sure ALL of your data has finished being processed by the Member Services department (ie: name, tattoos, birth, weaning, yearling, & ultrasound data).

4. Once the data is returned to you (via email or the alternative method you used to submit the request), review for accuracy.

  • The RAAA office does not provide support on handling the data output returned to you.
  • The tab–separated CSV text file may be imported into Microsoft Excel. For instructions on how to do this, visit here for Excel 2003, or here for Excel 2007 and later.

PROCESSING TIME:

  • Normal processing of a job takes 3 business days (72 hours; Monday - Friday, 8am - 5pm CST) from the time the full & complete processing request is received. All information in #3 above as well as the authorization to begin processing the job is required before the processing time begins.

INPUT SAMPLES:

SCDE Text Input Sample SCDE Excel Input
Text Input File Microsoft Excel Input File

OUTPUT SAMPLES:

SCDE Text Output Sample

Text Output File (CSV, Tab–Separated)

The tab–separated CSV text file may be imported into Microsoft Excel.  For instructions on how to do this, visit here for Excel 2003, or here for Excel 2007 and later.

Microsoft Word Templates:

Template_A Template_B
Template A Template B
(view larger image) (view larger image)
6 per page, 3 generation pedigree 8 per page, 2 generation pedigree

CUSTOM LAYOUT:

If one of the available formats does not meet your needs, you may contact one of the following graphic designers to help create a personalized layout.  The graphic designer may use the text format to merge the data into the layout they create.