Drive Failure, Can Moving Pictures tell what was there? (1 Viewer)
- Thread starter jlr2000
- Start date
United States of America
- Moderator
- #2
The MovingPicturesXML project will output your collection details to an XML file, although it is a bit of a round about method for what you are trying to do. You could also try a program like Sqliteman which lets you directly access the Moving Pictures database, although this requires technical knowledge of SQL.
Moving Pictures itself however currently has no method to export movie details.
Moving Pictures itself however currently has no method to export movie details.
- Thread starter
- #5
Yes, they are, but unfortunately I don't have them organized by which drive they were put on. I have multiple drives and the movies were placed in no particular order (separated by "Family" or "Adult"). "Adult" are movies like "Kill Bill" and others the kiddies shouldn't have access to.....not pRon...
So I have no idea what "family" or "adult" movies are on the failed drive. I can go one by one through MP to see "not available" but I was hoping there was a better way. Luckily fforde provided some alternatives....
Thanks.
- March 10, 2006
- 4,434
- 1,897
- Moderator
- #6
jlr2000, you can also go straight to the database source. Open movingpictures.db3 (it's in the database folder of your MediaPortal data folder) in a program such as 'SQLite Database Browser' (I believe it is even included with the main MediaPortal install, can't remember now, but otherwise download it directly from: SQLite Database Browser).
Then you click on the "Browse Data" tab, adjust the table to 'local_media' and the 3rd column named 'fullpath' will give you a very easy look as to what movies you had that were on the failing drive.
Now it shows all locations, so you want to filter it down to just the failing one, so click the magnifying glass icon, adjust the first drop down box to 'fullpath', change the '=' one to 'contains' and enter the part that uniquely identifies that failing drive, such as 'E:\'.
And the result will be a nicely filtered list with all the movies you want to rerip.
Then you click on the "Browse Data" tab, adjust the table to 'local_media' and the 3rd column named 'fullpath' will give you a very easy look as to what movies you had that were on the failing drive.
Now it shows all locations, so you want to filter it down to just the failing one, so click the magnifying glass icon, adjust the first drop down box to 'fullpath', change the '=' one to 'contains' and enter the part that uniquely identifies that failing drive, such as 'E:\'.
And the result will be a nicely filtered list with all the movies you want to rerip.
- Thread starter
- #7
Wow RoChess, thanks so much for the detailed How-To! I was a little apprehensive to try SQLite as fforde had recommended, but now that I have the details of how to do what I need I'll definitely go that route.
Thanks again to fforde and RoChess for your help and direction!!
