Advertise on ChoralNet 
ChoralNet logo
The mission of the ACDA is to inspire excellence in choral music through education, performance, composition, and advocacy.

Church Anthem Cataloging nightmare

Hello all.  I am beginning a project of cataloging the hundreds of church anthems in my persona library which are all mixed up and need sorting and filing.  I look at this project and it overwhelms me.  I have an Excel document all set up, but it's going to take weeks/months/ bazillions of hours to load all the data.  Does anyone out there have suggestions on how to streamline this process?  Software that makes it easy?  THanks, Victoria Cole
on July 8, 2015 2:57pm
There is no magic button!  Even if it's your personal library, I would suggest you appeal to your church choir members (who will, after all, benefit from you being more organised). Plan your categories, get a few musically-savvy folks able to analyse, and several people with laptops, have a music-filing party and make it as fun an activity as you can.
on July 8, 2015 6:24pm
Are there any reasonably responsible teenagers in your life who can be added to a production line system?  Pay them in pizza while they work and give them each one teeny, distinct task to do of labeling or filing while you man the laptop with the spreadsheet.  (Teeny and distinct tasks so they can eat pizza and chat at the same time without causing chaos.)  When it's all done you take them to the movies or beach or what have you as a thank you.  
on July 8, 2015 6:49pm
Have a choir member help you. He/she can read off the title, composer, and voicing while you type that into an excel spreadsheet. I am doing that over the next 2 weeks. I expect my process will take a total of 8 - 10 hours, spread over 4 - 5 sessions. I can only handle 2 hours at a time!
on July 9, 2015 6:06am
In truth, I purchased a program that is set up with all kinds of cross-referencing {10-15 cr's}...which is good.  But alas, I cannot recommend the program {which will remain un-named) because it has of late handed us a whole lot of glitches.  We contacted the manufacturer many times, and quite often he/she {don't want to identify} was at a loss as to how to correct our problems. Point is, we've made hundreds of entries over the years and are not about to start all over again with another system.  I will tell you this, however...instead of doing it all by myself I had a very reliable helper to actually make the keyboard entries while I examined a music copy and dictated the precise info I wanted in the file.  That has saved a huge amount of time as we have created many hundreds of files. What appealed to me about this program is that it asks for so much precise info...from title, to voicing, to copyright, to a sound file, to meter, scripture reference, season, first line, to publisher & name it...all cross-referenced. It has a great title search, also. Mostly this program has been wonderful to work with...but lately there have been some "glitches".  Yes, it most certainly can take weeks/months and hundreds of hours to do the work. But the result will make your job so much easier!  If you want more specific info, you can contact me. Good luck!
on July 9, 2015 6:59am
I'm an expert.  Depending on where you are, I'll just do the whole thing for you (for a fee, of course).  Carol
on July 9, 2015 7:00am
One more tip: don't file alphabetically. Enter everything onto your spreadsheet and assign a number. When you are finished entering you select all and hit A to Z. You'll pull your file by number. On your spreadsheet, the title will be the first column and its number the second. Everything else, composer, arranger, etc  goes after. I've done this at all three schools I taught at. 
  • You must log in or register to be able to reply to this message.