Monday, June 7, 2010

Bells and Whistles, Part 1

by Drew Bennett


There are lots of neat little bells and whistles inside MusicMaster and I want to cover one that I found to be especially handy once I set it up in my first MusicMaster for Windows database. I’ve always liked adding trivia to my songs. Call me old school, but I’ll include a birthday, a new tour or new CD information so my jocks know what’s going on. If your jocks don’t do their own show prep, MusicMaster makes it really easy to do it for them and it looks great when you show off your data to someone.

Today, I’m going to walk you through setting up your songs to display the band’s website when your cursor has the band selected in Library Maintenance and/or the Schedule Editor. It’s like having a personal assistant pull up artist information on the fly and precisely when you need it. When we’re done, it should look something like this:



The first thing you want to do is decide which field you’re going to use to hold the band’s web address. To make a choice, choose Dataset, Library, Fields.



In the example above, I’ve selected a field I called URL. It is a text field and the field length is 255. That will be plenty of space for web addresses. When choosing a field in the Database Field Editor, make sure you choose a Text field. If the length of the field is over, say, 100 characters, that should be plenty of space to hold a web address. If you find a Text field that you do not use, and the length of the field is long enough to hold your web addresses, you can rename that field to something like URL or Web Address and begin using it for the purposes of this tutorial. Once you find a field to use, hit OK. If you do not find a Text field that has a length to accommodate web addresses, consult your Music Scheduling Consultant to see about having a field added to your database.

Next, let’s set up MusicMaster to display a web browser inside the software. To do this, go to Tools, Options, External Database Links.



I use Firefox as a web browser so in the External Link Path, I typed in the path to firefox.exe, which is the executable file that Firefox uses when it launches a web browser for me. You can add any path in that links to the executable file for your favorite browser. Below that field you will see another field for Valid File Types. This field can be left alone or you can add in file types that can be played within your browser. Finally, you will use the dropdown box at the bottom of this screen to tell MusicMaster where you will be putting the web address for each artist in your database. You can see in my example that I’ve chosen URL as my Auto Link Field. Click Apply and OK.

Now, you will head to your first Song Card and bring your new web address field into your layout. You’ll type the artist’s web address into your new web address field.

 

Now it’s time to show it off. At the top of the software, choose View, Web Browser. If you’ve set everything up correctly, you should see your artist’s web page in MusicMaster’s browser window. Once you have web pages associated with all of the songs in your database, you can find artist information instantly when you’re maintaining the library or scheduling a day’s worth of music. Not only that, it looks really sharp when you’re showing off your data to the rest of the programming department or your consultant. All of a sudden, you have an assistant that pulls up artist information based on the web address you have in the song card. To enter that information into Trivia, click on the Trivia icon. (Hint: It looks like a folder with paperclip on top of it.) Finding and entering trivia and artist information was never easier.





Good luck with it! If you have any questions about how to set up this or anything else in MusicMaster for Windows, please don’t hesitate to call your assigned Music Scheduling Consultant. Happy Scheduling!

No comments: