Kodi Community Forum
Import Library Stats - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Skins Support (https://forum.kodi.tv/forumdisplay.php?fid=67)
+---- Forum: Aeon Nox: Silvo (https://forum.kodi.tv/forumdisplay.php?fid=142)
+---- Thread: Import Library Stats (/showthread.php?tid=164203)



Import Library Stats - surfsnake2 - 2013-05-06

Is there a way to import library stats so that all my comps running xbmc show the same number of watched and unwatched movies and shows?


RE: Import Library Stats - surfsnake2 - 2013-05-06

So i created advancedsettings.xml in each userdata folder with the following

<advancedsettings>
<videolibrary>
<importwatchedstate>true</importwatchedstate>
</videolibrary>
</advancedsettings>

So if i watch a movie in one room how do i make sure the other computers update that the movie has been watched? I dont want to have to clean and reload my whole library each time I watch a movie...

So is there a way to have media files refresh from nfo at startup, or on a timer? or polling?


Import Library Stats - braz - 2013-05-06

The best way to share watched status, etc is to switch to a MySQL database for xbmc. I recently made the switch, works like a charm.

http://wiki.xbmc.org/index.php?title=HOW-TO:Share_libraries_using_MySQL


RE: Import Library Stats - surfsnake2 - 2013-05-06

So yeah, Genius, this is awesome!

Although im running into one major problem Tongue

I scan music to library, it scans.... but nothing is added, they are all under files, but when i revert to library mode it is empty


Import Library Stats - braz - 2013-05-07

Have you updated all your video sources so they are available over the network?

http://wiki.xbmc.org/index.php?title=HOW-TO:Share_libraries_using_MySQL/Setting_up_XBMC


RE: Import Library Stats - surfsnake2 - 2013-05-07

(2013-05-07, 01:11)bryanbrazil Wrote: Have you updated all your video sources so they are available over the network?

http://wiki.xbmc.org/index.php?title=HOW-TO:Share_libraries_using_MySQL/Setting_up_XBMC

Yes?

all the video came in fine, just whenever i scan the music folder, it scans through everything, but nothing is added, if i turn off library mode i can go in and see the music and play it, it just doesnt add to xbmc, debug log this is what i get

16:38:05 T:3680 DEBUG: MUSIC_INFO::CMusicInfoScanner:Big GrinoScan Skipping dir 'smb://LAZY-PC/Music/T-W/T/Tyga/Hotel California/' due to no change
16:38:05 T:892 DEBUG: CTextureCacheJob::GetImageHash - unable to stat url smb://LAZY-PC/Music/fanart.jpg
16:38:05 T:672 DEBUG: ------ Window Deinit (MusicOverlay.xml) ------
16:38:05 T:672 DEBUG: CApplication::ExecuteXBMCAction : Translating CancelAlarm(NowPlaying,true)
16:38:05 T:672 DEBUG: CApplication::ExecuteXBMCAction : To CancelAlarm(NowPlaying,true)
16:38:05 T:672 DEBUG: CApplication::ExecuteXBMCAction : Translating CancelAlarm(similarartistsmove,true)
16:38:05 T:672 DEBUG: CApplication::ExecuteXBMCAction : To CancelAlarm(similarartistsmove,true)
16:38:05 T:672 DEBUG: CApplication::ExecuteXBMCAction : Translating Skin.Reset(rotationtimer)
16:38:05 T:672 DEBUG: CApplication::ExecuteXBMCAction : To Skin.Reset(rotationtimer)
16:38:05 T:3680 DEBUG: MUSIC_INFO::CMusicInfoScanner:Big GrinoScan Skipping dir 'smb://LAZY-PC/Music/T-W/T/Type O Negative/' due to no change
16:38:05 T:3680 DEBUG: MUSIC_INFO::CMusicInfoScanner:Big GrinoScan Skipping dir 'smb://LAZY-PC/Music/T-W/T/Type O Negative/Bloody Kisses/' due to no change
16:38:05 T:3680 DEBUG: MUSIC_INFO::CMusicInfoScanner:Big GrinoScan Skipping dir 'smb://LAZY-PC/Music/T-W/T/Type O Negative/October Rust/' due to no change

from my other computer....

16:51:12 T:2420 ERROR: CMusicDatabase::SetArtForItem(32, 'album', 'thumb', 'http://userserve-ak.last.fm/serve/300x300/67116042.png') failed
16:51:12 T:2420 DEBUG: Mysql execute: update path set strHash='9E934F3D49249B83CE91EA8046E3E92B' where idPath=1128
16:51:12 T:2420 DEBUG: MUSIC_INFO::CMusicInfoScanner:Big GrinoScan Scanning dir 'smb://192.168.1.114/Music/#-C/A/Andrea Bocelli/' as not in the database
16:51:12 T:2420 ERROR: SQL: The table does not exist
Query: select * from songview where strPath='smb://192.168.1.114/Music/#-C/A/Andrea Bocelli/'
16:51:12 T:2420 ERROR: CMusicDatabase::RemoveSongsFromPath (smb://192.168.1.114/Music/#-C/A/Andrea Bocelli/) failed
16:51:12 T:2420 DEBUG: Mysql Start transaction
16:51:12 T:2420 DEBUG: Mysql commit transaction
16:51:12 T:2420 ERROR: SQL: The table does not exist
Query: select count(idSong) as NumSongs from songview
16:51:12 T:2420 ERROR: CMusicDatabase::GetSongsCount() failed
16:51:12 T:2420 DEBUG: Mysql execute: insert into path (idPath, strPath) values( NULL, 'smb://192.168.1.114/Music/#-C/A/Andrea Bocelli/' )
16:51:12 T:2420 DEBUG: Mysql execute: update path set strHash='90143D8AC787919AD4A77F255C9357E3' where idPath=1129
16:51:12 T:2420 DEBUG: MUSIC_INFO::CMusicInfoScanner:Big GrinoScan Scanning dir 'smb://192.168.1.114/Music/#-C/A/Andrea Bocelli/Passione (Deluxe Edition)/' as not in the database
16:51:12 T:2420 ERROR: SQL: The table does not exist
Query: select * from songview where strPath='smb://192.168.1.114/Music/#-C/A/Andrea Bocelli/Passione (Deluxe Edition)/'
16:51:12 T:2420 ERROR: CMusicDatabase::RemoveSongsFromPath (smb://192.168.1.114/Music/#-C/A/Andrea Bocelli/Passione (Deluxe Edition)/) failed


Import Library Stats - braz - 2013-05-07

Just checked my setup...I'm just using a local source for my music, so it's not being shared with my other computers. Not sure...