2010-05-18, 20:13
In my home network I don't have consistent path names to the file server from all client machines. The linux htpc boots via nfs and accesses the media files via nfs mount, so media files are located at /some/mount/point, but from windows clients the same files can only be addressed via smb:// or a drive letter. Impossible to share the existing xbmc profile/database.
My first try was to clone the database using sqlite terminal frontend and rewriting path names with sed on the fly, but then I learned that thumbnails are tied to path names too. Therefore I wrote a script which not only clones the database, rewriting path names as necessary, but also recalculates all thumb and fanart file names accordingly and builds a copy of the thumbnail cache matching the cloned database.
If someone is interested I can clean up the script somewhat and share it here.
My first try was to clone the database using sqlite terminal frontend and rewriting path names with sed on the fly, but then I learned that thumbnails are tied to path names too. Therefore I wrote a script which not only clones the database, rewriting path names as necessary, but also recalculates all thumb and fanart file names accordingly and builds a copy of the thumbnail cache matching the cloned database.
If someone is interested I can clean up the script somewhat and share it here.