2011-02-10, 18:42
Sranshaft, I think you missed my point. I already know that streamdetails is not getting populated. I can use sqlite browser to view the data in the database and execute sql queries against it. Here is the link to it for anyone that wants to look at how XBMC stores the data. http://sqlitebrowser.sourceforge.net/.
1. What we need is to query the movie and episode tables and get all the idFiles.
2. Next check if each idFile in 1 has a corresponding record in streamdetails, we need to get a list of all idFiles not in streamdetails but are in movie and episode tables.
3. Loop through this idFile list and execute some code to grab the video information using ffmpeg
4. insert video information into streamdetails for the idFile
Just to rule out that this is an issue with my XBMC install, I am going to completely blow away my current installation and start with a fresh install of Dharma. I will then verify the Extract thumbnail and video information is enabled. Then add my video sources and have XBMC scan the content. After the scan is completed in a day or two, I will copy the database and look at the data in the tables and report. I will also work on the sql code to gather the data to determine which movie and episode idFiles are not in streamdetails table.
I'll report my findings as soon as I have completed the test.
1. What we need is to query the movie and episode tables and get all the idFiles.
2. Next check if each idFile in 1 has a corresponding record in streamdetails, we need to get a list of all idFiles not in streamdetails but are in movie and episode tables.
3. Loop through this idFile list and execute some code to grab the video information using ffmpeg
4. insert video information into streamdetails for the idFile
Just to rule out that this is an issue with my XBMC install, I am going to completely blow away my current installation and start with a fresh install of Dharma. I will then verify the Extract thumbnail and video information is enabled. Then add my video sources and have XBMC scan the content. After the scan is completed in a day or two, I will copy the database and look at the data in the tables and report. I will also work on the sql code to gather the data to determine which movie and episode idFiles are not in streamdetails table.
I'll report my findings as soon as I have completed the test.