« July 2008 | Main | September 2008 »

August 26, 2008

State Fair 2009 question 3

The third in our series of State Fair questions deals with the dog entries.

In the past, as with dairy cows & goats, the dog exhibitors have had to fill out entry cards which you then send along with the paper copies. We hire someone here to enter that information into the database.

We've noticed that a lot of the information on the cards is no longer necessary--different check-in processes mean that less info is really needed on the card.

We're thinking of changing the process to be more like the horse entry process--where you type in the class number and the horse's name on the electronic entry form. In the case of the dogs, you would be typing in a class number, dog name, and dog breed. The class numbers would handled in a way that would allow you to quickly go look up a number if you needed to... if the young person did not enter a correct number on their paper entry form.

What do you think? Would that be burdensome in terms of data entry? How many dog exhibitors do you have in your county--if it's only one or two, would it be a pain to do that? It looks like no exhibitor enters more than about five classes. They seem to have at most 2 dogs, which would mean a maximum of 4 classes--obedience for each dog, then handling & rally.

More blog comments on your thoughts, particularly if you are a county that has LOTS of dog exhibitors!

State Fair 2009 question 2

Yet another question about some changes we're considering for 2009... this one deals with dairy cow and dairy goat cards.

Because at least a third of the dairy cow entry cards end up being scratches or having a substitute cow entered, we have lots of opportunities to have mistakes in the catalog. Also, we have additional opportunities for mistakes because we hire someone here to pre-enter all that data into a database, and put them on a real tight schedule.

We're thinking of asking the exhibitors to bring the completed cards to the fair (fill them out as you're loading those animals on the trailer) instead of having them sent in with the paper entries in July. The kids would still mark & pay for the number of animals they intend to bring on the entry form, but would not fill out the cards on July 1. That way, they SHOULD be filling out cards only for the animals they actually decide to load up and bring.

So what's the question? I want your opinion on whether you think it'd be better for the exhibitors to get those blank cards from you at the county office, or whether we should send them in their exhibitor letters, along with instructions about filling them out and bringing them along. We're simplifying the cards as well to eliminate unnecessary information--for example, it's really not necessary for the kids to write their complete address on six cards...

Again, comment back to the blog about whether you think it'd be better for the kids to get the blank cards from your office, or in their exhibitor letter. If they lose their cards, or need a fresh one for some reason, they could always get extras from you, even if we do send them, I imagine.

State Fair 2009 question 1

State Fair 2009 already???

Actually, we're working on some changes/improvements for next year's state fair while this year's issues are still fresh in our minds--some of us lose that memory quicker than others...

One thing I'd like to run past all of you is an idea that MIGHT make the database entry just a little easier. We had an awful lot of exhibitor letters returned for incorrect addresses this year, and we totally understand how easy it is to make those input errors. Maybe the input person was a summer aide, maybe you duped a record and forgot to change the town, maybe you have Becky's Flying Fingers disease... whatever.

Anyway, what do you think about having a field in the livestock entry database that would be called "4-H ID", which would be the young person's 5-digit ID from Blue Ribbon? I can set the database up on my end to include your county ID, which would make for a unique 8-digit ID for each kid, and can then set up a relationship to import the address information from the state BR database. You would be entering only the 5-digit ID and the kid's name (along with their entries). The reason I'd have you type in their name would be for error-checking. If the ID brings up Johnny Smith, and you think it was Susie Jones that entered that dairy goat, we'd have to figure out that the ID was entered in error.

The bottom line is that you would have to have a list of those ID numbers, write them at the top of the paper entry form, and enter them in the database. The benefit to you would be that you wouldn't have to type in the address, grade, gender, phone for the exhibitor. I will have to restructure my state livestock database, and double-check the names to make sure we have the right kid, but then I should have a little more accurate info about them.

Comment back to the blog--are the costs worth the benefits? You're the ones doing the database entry. Is this "do-able" from your perspective??