[Clipart] tags issues

[Brian Bucknam]

On Feb 12, 2008, at 1:43 PM, Greg Bulmash wrote:
> If it's agreed that all instances where "birds" occurs should be
> "bird", then the most efficient method is to do an SQL query to remove
> "birds" from any image where the author submitted both "bird" and
> "birds" (this may require a script depending on how things are laid
> out), then another to change all instances of "birds" to "bird".

Then John Olsen wrote:
> I think it's simpler than that.  I found the section in the admin  
> area for TAGS and all one needs to do is use the alias function to  
> make all instances of birds into bird by the scheme birds=>bird.   
> ccHost then let's you run a tag update through the database and it  
> apparently fixes them all.  We just have to periodically run it.  I  
> just tried it.  Takes few minutes to run but appears to work fine.

That sounds handy. I've enclosed below a mapping list that covers a  
bunch of mis-spellings, plurals, and internationalization-type issues  
that we use with our clip art browser. These all affected more than  
one clip art item.

Cheers,
Brian
-----------------------------
		"animal", "animals",
		"button", "buttons",
		"architect", "architetto",
		"country", "countries",
		"callout", "callouts",
		"alps", "alpes",
		"cactus", "kaktus",
		"activity", "activities",
		"tool", "tools",
		"ear", "ears",
		"continent", "continents",
		"eye", "eyes",
		"country", "countries",
		"america", "americas",
		"logo", "logos",
		"raisin", "raisins",
		"cat", "cats",
		"bug", "bugs",
		"folder", "folders",
		"seal", "seals",
		"clipper", "clippers",
		"symbol", "symbols",
		"phone", "phones",
		"house", "houses",
		"plant", "plants",
		"unicorn", "unicorns",
		"bird", "birds",
		"pirate", "pirates",
		"flag", "flags",
		"flower", "flowers",
		"tree", "trees",
		"pincer", "pincers",
		"wing", "wings",
		"sign", "signs",
		"art", "arts",
		"sport", "sports",
		"vegetable", "vegitable",
		"vegetable", "vegetables",
		"skeleton", "squeleton",
		"automobile", "atuomobile",
		"transporter", "trasporter",
		"transport", "transportation",
		"silhouette", "silhouet",
		"africa", "afrika",
		"african", "afrikan",
		"elephant", "oliphant",
		"elephant", "olifant",
		"elephant", "elefant",
		"ukraine", "ukrane",
		"color", "colour",
		"coloring", "colouring",
		"mechanic", "mecanic",
		"mechanical", "mecanical",
		"frog", "froggy",
		"frog", "froggies",
		"vehicle", "vechicle",
		"car", "voiture",
		"cup", "mug",
		"bulb", "lightbulb",
		"scissors", "scissor",
		"anatomy", "bodypart",
		"telescope", "spyglass",
		"leaf", "leaves",
		"fire-station", "firestation",
		"refrigerator", "refridgerator",
		"clothing", "clothes",