OVERVIEW:
The Red Angus Association of America is pleased to provide sale catalog data extracts in a variety of formats. You may choose a tab-delimited text file, a Microsoft Excel spreadsheet, or one of the Microsoft Word templates in sale catalog format.
INSTRUCTIONS:
- 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 one of the graphic designers to create a custom format for you.
- 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).
- Multiple files, multiple Excel sheets, or multiple columns of registration #s will be run as multiple jobs and charged accordingly. Multiple Excel sheets or multiple columns may be missed and not processed at all. If you need multiple output files, submit multiple input files.
- 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” (active animals) extracts can be done for an additional fee, but will not include Lot Numbers.
- Email the request including: output format selection, list of registration numbers, and account # to be billed to SCDE (scde@redangus.org).
- If you are requesting data for animals that you do not own, the owner will need to email or fax a statement of authorization to the RAAA National Office granting the release of their data.
- If you do not have access to email, please 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 Registration department (ie: name, tattoos, birth, weaning, yearling, & ultrasound data).
- Verify ALL Data is accurate in our system before requesting a Data Extract.
- Contact the Registration department at the National Office to verify.
- Once the data is returned to you (via email or the alternative method you used to submit the request), review for accuracy. Processing errors will be corrected at no additional charge. Modifications, additions, or other reprocessing of the request, however, will be treated as separate jobs, and billed accordingly (e.g. incorrect or additional registration or lot numbers, reprocessing to pick up new data or changes entered/processed by the Registration department, format or template changes).
- The RAAA office does not provide support on handling the data output returned to you.
- Files sent via email will be zipped to make it faster to send/receive & use less bandwidth. Zip files can be extracted using utilities bundled with most current operating systems. If you have an older version of Windows, you can install a zip program (such as ZipGenius or another application) in order to unzip the file.
PRICES / FEES:
The charge for the service is based off the time it takes to process the job, and is not affected by the number of registration numbers submitted. The price is the same whether the list contains 1 registration number or 1,000. Note that additions or modifications are treated as separate jobs, and will be charged accordingly. The prices are as follows:
- Tab-Delimited Text and/or Microsoft Excel: $25 (flat fee)
- Microsoft Word Template: $50 (flat fee)
- Custom Pre-Print Format: $100/hour
- This option is for experienced graphic designers. Contact the National Office to discuss further details.
- Optional Fees (in addition to the above prices):
- Whole Herd Extracts (all active animals you own): $25
- Rush Charges:
- Next Day: $50
- Same Day: $100
PROCESSING TIME:
- Normal processing of a job takes 3 business days (72 hours) 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.
- Rush Jobs can be requested, and will be processed as such given available resources. An additional “rush fee” will be added to the bill, but only if the job is completed within the “rush” timeframe.
- “Next Day” jobs will be processed and returned to you the next business day. Job request must be received before 3pm CST.
- “Same Day” jobs will be processed and returned to you the same business day. Job request must be received before 12pm CST.
INPUT SAMPLES:
OUTPUT SAMPLES:
Microsoft Word Templates:
CUSTOM PRE-PRINT FORMATS:
- If one of the available formats does not meet your needs, RAAA recommends contacting one of the following graphic designers to help create a personalized format:
|
