Album level genre in music db (1 Viewer)

[tomma123]

Can anyone tell me how the Genre field in Album view is meant to work?

In the music database (MusicDatabaseV12.db3), the table that holds all the album related data is 'albuminfo'. One of the fields in that table is idGenre. There's also a table in the db called 'genre', that table has 2 fields, idGenre, and strGenre. My assumption was that albuminfo.idGenre = genre.genreID. So in other words, in my genre table if I have genreid 1 = Rock, and a particular album in the albuminfo table has a genreID of 1, then 'Rock' would show up in the Genre section, however, it doesn't. Actually no matter what I put in the albuminfo.genreId field, it doesn't show up. I've tried with a few different skins, StreamedMP, Backdrop, Default and DefaultWide but I get the same behavior in all of them.

I have the artist level genre working, that's just whatever is in the artistInfo.strGenres field shows up on the page, but can't seem to get it working at the album level. Am I missing something?

Thanks

 

[jameson_uk]

What are you trying to do? The albuminfo table hold album details scraped from the internet not the tagged values in the files.

Will have a look at album info table tonight but I am not sure that is what you are after

 

[tomma123]

I'm not trying to populate the database from my tags, I'm trying to get data directly into the db.

I have an existing music db that I'm trying extract data from and load into MP. So far I've been able to do just about everything I need by just exporting data from my catTraxx db into the MP music db and then just running update/insert queries on the appropriate tables. At the end of the day the database is populated with the data I need, I just got it there manually as opposed to automatically grabbing it off the web via allumusic.com

Where I'm stuck now is albumInfo.idGenre. I have the genre table setup with all the data I need, but for example, putting the number'1' into albumInfo.idGenre does not display the corresponding genre.strGenre. So far no matter what I put in that field, I don't get any output at all on the album page.

Hope that makes sense.

 

[tomma123]

Jameson_uk - Have you had a chance to review this yet?