Who Am I, Where’s My car?

I can’t believe it’s been 3 years! Back in the mid 80’s I found a bumper sticker “Who Am I, Where’s My car?” I put it on a friends car, she had a scattered life and was sleeping off a hangover , (thankfully she loved the sticker!). I wish I had bought two, it would totally fit my life today, less the hangover. I run 7 websites including this one, host several forums, I work for my husband in the mornings as a bookkeeper & office manager in his Mechanical Contractor business, I work for a General Contractor in the afternoons, I volunteer in the Jackson Hole Community Band as a musician, librarian, web admin, and board member, and go summer and winter outdoor activities with my family on the weekends. Even though I don’t post updates much, which I’ll try to do better, I work on inScoreOrder almost every day.

I took the volunteer Librarian position in 2004, after several weeks of the conductor announcing the need. My paid job is an office manager and bookkeeper, at the time I was a unit secretary for the surgical department. My job is filing, and seeing all that unfiled music every week was making me crazy, or maybe I just has “Sucker” written across my forehead. When I took the job I knew nothing about being a music librarian, score order, instrument keys, etc. The first thing I was assigned after getting the music put in score order and filed, was a laptop with MS Access installed and about 80 titles entered into it. However, even though it was a database program the set up was just a glorified Excel spread sheet. I built the database to work as our library and endtered all our music into it. At the time we had over 1100 charts, I took home one drawer of music at a time and entered it, a few at at time, in the mornings before work. I took the website admin position and did a redesign in 2011. I knew I wanted to put our library on line from the beginning, but I had to teach myself PHP & SQL. In 2014, after many hours of work, I decided to give my program a name and get a URL, inScoreOrder.

I work on the program nearly every morning before work. We also use it live, so I spend a lot of time with data entry and skipping around to make sure it does the things we need it to do. Many of the functions are the results of necessity and requests from the conductors and members. Please take a look at the Jackson Hole Community Band’s library hosted with inScoreOrder and sign up for emails. I can’t wait for this is available as a WordPress plug in!! I hope you feel the same.

 

Release 2.0 is here

Folders & Rehearsal Music

This program will be a tool for concert & rehearsal planning, archiving historical info, tracking lost or missing music, and a way to locate the physical paper chart in the real world. After having to put this project aside for a few months I’m excited to get the first major feature up and running.

Virtual Folders

Add new folder


Location Information

When planning a concert or concert series, the conductor or librarian creates a virtual folder to correspond with the real folder. The virtual folder dates control how the information is shared around the Library  program.

When the conductor is searching and reviewing music in the the library database he or she can add their selections to a virtual folder.

Once the chart (music) is in the virtual folder the program starts sharing the information other areas of the library program. What that means is when you are viewing info about a chart there is a note about where the real chart is located.

Conductor Tools

Add to Folder


When the list is complete the conductor tells the librarian in any manner, text, email, phone call, over beer, on the ski lift, the music list is complete and ready to go. The librarian then uses the information on the list to pull the chart (music) from the library and to stuff into folders.

Once a piece is in a virtual folder the conductor has a place to enter information for future use. The note will automatically appear on the music detail page.

 

Band Member Tools

Guest and Band Member View

Guest and Band Member View

When the band starts rehearsing the music, the librarian or conductor can email the folder URL to the  band. Members can read rehearsal notes, if any, and listen to a sample of the piece.

 

Librarian Tools

Librarian Notes


Librarian Controls

The ‘librarian’ note button under each piece will be a place to make notes of missing or reordered parts and condition pf the piece. These notes will automatically appear in the chart detail page for future use.

The librarian also has a control to add public and privates notes to a virtual folder about real folders that have not been returned. For example, we are missing the clarinet 3 folder from the Halloween 2014 concert. I added a public note that it has not been returned, all members can see this note. I put a private note telling where I think it is, I can and any notes about what we did to retrieve it, conductors and board members can only see this. In the future,  when a conductor is viewing chart info for any of the pieces that were in that missing folder there will be note saying that in fall of 2014 the clarinet 3 folder was not turned in. We can check to see if we need to order any extra parts before we pass out the music. 

The librarian has some controls that only he/she can see. Here the folder can be marked “Purged” and the program knows the music has been refiled and removes the location notes from other places.

Deleting Folders can only be done by librarians and web administrators.

When you look at the entire folder page you can see much of what I have planned, I will even have a place to keep track of the music budget within the program. BUT this takes time, things will start working one at a time.

Enjoy!

Necessity, the mother of invention

Screen shot 2014-06-13 at 2.36.10 PMAfter hours of searching and testing WordPress plugins for a perfect way to store our music library database I finally decided to write my own program. It is currently integrated with WordPress, when the functions are working it will be switched to a plug in and ready for testing.