Out of the ground the LORD God formed every beast of the field and every bird of the air, and brought them to Adam to see what he would call them. And whatever Adam called each living creature, that was its name. So Adam gave names to all cattle, to the birds of the air, and to every beast of the field… (Genesis 2:19-20a NKJV)
Today I want to share a little behind the scene helps that really make updating a blog and your files. As you may be aware, we use the I.O.C.’s list of world bird names here. About every quarter, they (IOC) delete, add, and revise the species names and positions in the list of all the birds in the world. If you are nutty enough to have had the bright idea, like I did several years back, to list ALL THE BIRDS, then you have a headache every quarter.
Each update they (IOC) provide files you can download with all the birds listed. Most of these are in the Excel format. Spreadsheets like Excel and others can greatly speed up fixing the list to update my site. I use simple (and I mean simple) formulas to combine the bird’s name and its scientific name together with the parenthesis around it. Then just copy the formula down the 10,000 plus birds and “wa laa” you have a
Black-headed Ibis (Threskiornis melanocephalus) instead of a
“Black-headed Ibis” and a “Threskiornis melanocephalus“ with no parenthesis to be found.
E796 is the cell of the English name and G796 is the cell of the Scientific name. The ,” (, and the ,”)” tells it to add a space and parenthesis, and a parenthesis at the end.
I also came up with a naming system to help find the photos of birds on the hard drives. I use a 3-letter code – All Caps – for the Order of birds, a dash(-), followed by a 4-letter code to represent the Family of the birds. It really helps in aiding to find bird photos or to rename them. (that is next)
Another great program, this one is free, is ReNamer from Den4B.com. I use this a lot. ReNamer lets you change the name of files enmasse. File explorer will let you rename a group of files, but you cannot go in there and just change parts of it like ReNamer can do. As I mentioned in the last post about I.O.C. Version 5.3, the Parrot family was split into two families. Fixing the pages that list all the birds was tedious enough, but having to separate the photos on my hard drive was another situation.
My Code for the original Parrot family was PSI-Psit (PSITTACIFORMES order and Psittacidae family) and now with the new Psittaculidae family I came up with PSI-Pstt. So how am I suppose to rename over 200 photos in the new family to the new code? Easy with ReNamer. Drag the files you want to rename into ReNamer, add a new Rule (Replace PSI-Psit with PSI-Pstt), then press the “Rename” button and 200 plus photos are renamed. There are lots of other options. It is a fantastic program in my opinion.
I know for some of you, this was a little more technical than normal, but thought you might find something in it you can use on your projects. The CONCATENATE (combining) feature of Excel and the ReNamer program are both very useful.
Because of health issues and other events going on, the update to I.O.C. Ver. 5.3 has not moved as fast as other versions. I am working on it and here are the families updated so far. I have been making a change to the pages as I work on them. I am adding a slideshow at the bottom of each page. Stay tuned!
‘I have made the earth, the man and the beast that are on the ground, by My great power and by My outstretched arm, and have given it to whom it seemed proper to Me. (Jeremiah 27:5 NKJV)
I.O.C. Version 5.3
Tinamous – Tinamidae
Ostriches – Struthionidae
Rheas – Rheidae
Cassowaries – Casuariidae
Emu – Dromaiidae
Kiwis – Apterygidae
Screamers – Anhimidae
Magpie Goose – Anseranatidae
Ducks, Geese and Swans – Anatidae
Megapodes – Megapodiidae
Chachalacas, Curassows and Guans – Cracidae
Guineafowl – Numididae
New World Quail – Odontophoridae
Pheasants and allies – Phasianidae
Loons – Gaviidae
Penguins – Spheniscidae
Austral Storm Petrels – Oceanitidae
Albatrosses – Diomedeidae
Northern Storm Petrels – Hydrobatidae
Petrels, Shearwaters – Procellariidae
Diving Petrels – Pelecanoididae
Grebes – Podicipedidae
Flamingos – Phoenicopteridae
Tropicbirds – Phaethontidae
Storks – Ciconiidae
Ciconiidae – Storks
* The Parrots
Strigopidae – New Zealand Parrots
Cacatuidae – Cockatoos
Psittacidae – African and New World Parrots
Psittaculidae – Old World Parrots