[fix] Manual artist thumb/fanart selection when scraper can't find them
#2
I have figured out a workaround for this issue.

There is a table in the music database labelled 'artistinfo'. When you select 'Artist Information' for any given artist, if a record exists in the 'artistinfo' table, then XBMC will bring you to the artist info screen. If a record does not exist, then XBMC will try to scrape, and if it cannot recognize the artist, will return you to the OSD keyboard to enter the name manually, and this loop will continue for unrecognized artists.

The solution is to create a record in this table for every artist. Here is how I did it.

1) Make a copy of the music database (working copy) and open using a sqlite editor/browser. A complete list of artists is found in the 'artist' table. If I knew the SQL commands to add records to the 'artsistinfo' table for every artist in the 'artist' table, I could do that here and be done, but I have no SQL skillz so on to step two....

2) Export the 'artist' table to csv file, and open in EXCEL

3) Delete all but the artist column.

4) Add a column full of <artist><name> before the artist column

5) Add a column full of </name></artist> to the right

6) Copy all and paste into text editor (notepad++)

7) Clean up using find & replace (remove extra spaces)

8) Replace special characters (& and ') with (&amp; and &apos) (not sure if this is needed, but took the safe route)

9) Add <musicdb></musicdb> tags. Result looks like;

<musicdb>
.
<artist><name>Leon Redbone</name></artist>
<artist><name>Levon Helm</name></artist>
<artist><name>Little Charlie &amp; The Nightcats</name></artist>
<artist><name>Big Smoo &amp; the Trailer Park Kings</name></artist>
.
.
</musicdb>


10) Save as musicdb.xml

11) Back to XBMC, settings-->import music library. Import musicdb.xml

This will append your database and force a record for every artist into the 'artistinfo' table. Now when you request artist info for any artist, you are taken to the artist info screen, regardless of whether it has scraped or not.

Now I can use the existing GUI to add thumbs and fanart for un-scrapable artists.
Reply
 
Thread Rating:
  • 0 Vote(s) - 0 Average


Messages In This Thread
RE: Manual artist thumb/fanart selection when scraper can't find them - by whitebelly - 2013-06-07, 13:34


Logout Mark Read Team Forum Stats Members Help
[fix] Manual artist thumb/fanart selection when scraper can't find them00
This forum uses Lukasz Tkacz MyBB addons.