MusicMaster Scheduling
Your viewing experience of the MusicMaster website, as well as the web as a whole, would be much improved if you upgraded your browser.

MusicMaster Blog

2 Tips 2 Spring Cleaning Your Database posted on May 26th, 2023

by Vicky James

It’s that time of year where we swap all of our winter fleece ‘n furs for our bright colorful florals! I typically will do a purge of things that I haven’t worn for years, pieces that are dated or things that I should’ve gotten rid of five years ago! Well ironically, this blog isn’t about old clothes, but it is about the stuff that’s sitting in your database that you’ve overlooked monthly, if not daily!

Here’s your guide to Spring Cleaning your database:

Tip 1: Cleaning Clocks

There is a way to clean up your clocks without “guessing” which clocks aren’t being used and to avoid accidentally deleting something needed!

Here’s how:

1. Click on the Clock Icon in the toolbar to open the Format Clock Maintenance

2. Click “Select” on the right

3. Select “Assigned Clocks”, then select “Assigned to Any Clock Grid”. This checks only the clocks that are being used in any assignment grid.

4. Then go back to “Select” again and click “Invert Selection”. Now only unused clocks will remain checked.

5. I suggest reviewing the checked clocks to be sure that you want to delete them.

5. After you’ve reviewed the clocks, Click delete and the unused clocks are all gone!

Rule of thumb… Anytime that you are making a mass change such as deleting clocks ALWAYS make a backup first so you can revert if needed.

And that’s how you would clean up your clocks!

Tip 2: Cleaning Keywords

It’s not uncommon for title keywords to accidentally get entered with an error or duplicate titles with different spellings. This is often found with Christmas titles, as you see pictured below.

A picture containing text, font, screenshot, line

Description automatically generated

In this example, we’re looking at the Title Keyword for “All I Want For Christmas”. Here, I’d like to have the Mariah Carey title match the other entries. Going to the Keyword Maintenance will allow us to quickly make the update.

Now, let’s navigate to finding your keywords. Click on Dataset, Library and Keywords.  Use the dropdown menu to select the keywords that you would like to check, be it your Artist Keywords, Title Keywords, Album Keywords, or any other field that utilizes a keyword. As I mentioned, in this case we will update the Title Keywords. Use Find to start typing “All I want for Christmas” and it should find both versions of the keywords shown above: “All I want for Christmas” and “All I want for Christmas is You”

Now, you can edit the keyword you want to change to match the other one. In this case, I’ve added “is You” to the end of “All I want for Christmas”. You’ll be prompted with a message that indicates there are now two identical keywords, asking “Would you like to combine these entries?” Select Yes and it will combine the two Title Keywords and update any songs that had the keyword that was changed.

A screenshot of a computer

Description automatically generated

Also in Keyword Maintenance, you can also use the Tools drop down menu to select “Remove Unused Keywords”. This would delete any incorrect or leftover keywords that aren’t currently assigned to any songs.

For more on Keyword Maintenance, check out this blog: https://musicmaster.com/index.php?p=7817

As a Bonus Spring Cleaning Tip… You can use Purge to declutter your databases of old deleted items that were removed from your database, like library, clocks, keywords, etc. Think of it like emptying the Recycle Bin. Purging is found under the Tools menu and if you look closely in the left corner as the resulting process completes, you’ll see how much of your database was cleaned up.

Should you have any questions please reach out to your MusicMaster Scheduling Consultant.

Artist Keyword Maintenance posted on February 13th, 2017

By Paul Ziino

I know we’ve talked about it before.  However, I regularly am asked “why are my artists playing so close to themselves, but not indicating any rule violation?”  In 90% of these cases, the issue is that the songs either have no Artist Keywords or have the wrong Artist Keywords.

Artist Keywords are what MusicMaster uses to keep the same artist apart from themselves.

Let’s use these examples:

BEATLES
THE BEATLES
BEATLES, THE

As far as MusicMaster is concerned, those are three unique keywords and thus they wouldn’t be separated.

There is an easy way to clean these up.  Go to Dataset/Library/Keywords, then select Artist Keywords in the dropdown.  This is a list of all the Artist Keywords in the database.  Any changes you make in this list immediately update throughout the database.

Below we see the keyword “Christina Aguilera.”  If I wish to change it to “Aguilera, Christina,” just type right over the top of it.

When I do, MusicMaster alerts me that there is another keyword listed that matches and asks if I’d like to combine them.  I will click Yes, and now any song that had the “Christina Aguilera” keyword on it will be updated to the “Aguilera, Christina” keyword.

A quick suggestion:  For groups, enter the keyword as the group’s name, “LED ZEPPELIN.”  For solo artists enter the keyword last, first, “PLANT, ROBERT.”  Now when you sort your library by artist keyword, it will appear as desired.  Also, I suggest not including the leading “THE”, so just “BEATLES” or “WHO” or “EAGLES” and so on.

Once you’ve cleaned up your keywords you’ll notice that artist separation rules work better.  When artist separation is working, your whole station will sound better because you’ll have the desired rest between plays of the same artist.

 

Cleaning up your Keywords posted on June 27th, 2016

By Jerry Butler

I get calls from time-to-time from programmers saying that their artist, title or composer separation isn’t working correctly.  Call numbers increase on this issue in the weeks leading up to Christmas with title separation.  Keep in mind separation rules look at your artist keywords, title keyword and composer keywords.  After analyzing the data, we often find that some of the entries are spelled just a bit different.  In order for the keyword separation to work correctly, all spellings in the specific  keyword have to be exactly the same.  How can you check this quickly?  Many programmers including myself would go through the library, sort and compare the artists or titles on each song card.

Here is an easier, faster, more thorough way to correct your keywords:  make those changes in your keyword maintenance window.

Click on Dataset, Library and Keywords.   Use the dropdown menu to select the keyword that you need to check.  For demonstration purposes, we will check the Title keyword.

Keyword Maintenance 1

I’ve highlighted entries for “O Holy Night” and “Oh Holy Night”.  In order for the title separation rules to work correctly, these need to be exactly the same.  Rather than changing every single song card, you can make the change for all songs right here.  I’m going to change “Oh Holy Night” to “O Holy Night”.  To do this, just click on the line and type the change. When I press [enter], I receive a prompt letting me know the keyword already exists and asking me if I would like to combine the two.  Click yes and any songs with ”Oh Holy Night” will be updated to “O Holy Night” and your rule will separate the titles correctly.

Keyword Maintenance 2

Check your keywords today and make sure your station’s artist, title and composer or any other keyword separation is running the way you want it to.