INTERACT FORUM

More => Old Versions => Media Center 12 (Development Ended) => Topic started by: tjenkins on October 30, 2007, 10:34:35 am

Title: Need help with Smartlist- Artists with more than 1 genre
Post by: tjenkins on October 30, 2007, 10:34:35 am

All-

I am trying to cleanup my genres. I have imported several artists over time and I want to identify and correct the Artist Genre. For example if I have a Beatles Song listed under "oldies" and also "rock", I would like to change the genre to the most commonly listed for that artist (manually).. The first step I suppose would be identifying and indvidual artist with more that one genre.

I have checked the wiki post (excellent), but my SQL programming days have faded. Any help would be greatly appreciated!

Title: Re: Need help with Smartlist- Artists with more than 1 genre
Post by: Matt on October 31, 2007, 07:36:04 pm

I don't know an easy way to do this automatically.  We need a ListCount(...) function in the expression language to handle it nicely. (which we don't have currently)

However, if you put "Genre" in your view and sort by it, it'll be pretty obvious which ones have more than one by looking.