[steppedup]

Edit: The best way appears to be via my second post below - via SQL Lite Browser.

After struggling to find any good answers after losing a hard drive and not know what movies were on that hard drive, I finally found this method. Decided to post this here as I've had this happen once before and I'm sure it'll happen again - so I'll always be able to find it from my postings .

One way is via SQLLiteSpy, a free download from: http://www.yunqa.de/delphi/doku.php/prod...espy/index

Download it and install it to its own folder. Run it, and then with open MyVideos75.db in:

C:\Users\buddy\AppData\Roaming\XBMC\userdata\Database\MyVideos75.db

replace buddy above with your username.

Then click on Views/ and doubleclick on Movie views. In the right window, if you scroll to the right you'll see column C22 -that will be your paths.

Then back on the left, you'll find by clicking on each column that you'll be able to find column 22 (otherwise known as C22). And there are your file paths!



I haven't found a way to export that list yet

[steppedup]

How to repopulate a hard drive with all of your missing movies from a particular hard drive (assuming you have multiple) by pulling a list of all of your movies directly from the XBMC database using the SQL Lite Browser, using Open Office to build a list of url's, and then using James Marshall's test bed to generate a web page to run CouchPotato's bookmarklet to semi-automatically rebuild your movie.

This method takes a little bit of prep, but lets you decide what kind of quality of movie you want - and you even want that movie again.

What's more important, you don't have to mess with formatting/ renaming etc. Just a little quick prep work, and then off to the races.

Prep Google Chrome
In google chrome, open the url to your couchpotato and go to the automation page screen. Drag the bookmarklet to your bookmark bar -shown by the big red arrows below.




Exporting your movie list from XBMC:
Download and install SQL Lite Browser: http://sourceforge.net/projects/sqlitebrowser/ which is discussed here: http://sqlitebrowser.sourceforge.net/

Extract the files to a folder you make somewhere on your C: drive. Then open sqllitebrowser up, and then select the same file as before:
C:\Users\buddy\AppData\Roaming\XBMC\userdata\Database\MyVideos75.db

replace buddy above with your username.

Go to File, Export, Table as CSV. Table name is movies. Save it to your desktop as movies.csv.


Import into Open Office - goal is to get your data.
Open the .csv file in Open Office, and you'll have all of your movies listed. It may prompt you to select the format - make sure you have comma as a delimiter selected.

The far left column will be the title of the movie. Column 22 will the path of the movies.

You may have to order based on the path name to get a good selectable range of cells. Basically, you just want all of your files from that particular hard drive, right?

Copy that selection and paste it into a new fresh spreadsheet.

Manipulation of Data in Open Office - goal is to get a bunch of links to the IMDB Pages.
Right-click on column L - this is the column directly to the left of the IMDB tt number...for example..(http://www.imdb.com/title/tt1611224/) tt1611224. You will get a context menu - click on Insert column.

In the first row of that empty inserted column, you will put

Code:

<a href="

. Then, hover your mouse just over the lower right border of that cell. It will turn in a bolded cross (or plus sign). Click and draw all the way down the column to the bottom of your desired column. The italicized section is called "the hover and copy" procedure here on out.

Right-click on the column next to your column of <a href =". Insert column. Paste this into the cell:

Code:

http://www.imdb.com/title/

Hover and copy.

Column N should be your tt Numbers. Right click and insert a column to the right. Insert

Code:

">

into the cell. Hover and copy.

Right click and insert a column to the right of your "> column. Type

Code:

</a>

into that cell. Hover and copy.

Right click and insert a column to the right of your </a> column. Click on the formula bar, and type in this:

Code:

=CONCATENATE(L1;M1;N1;O1;C1;P1)

. Hover and copy. This will concatenate your columns together. The result is going to be this:

Code:

[b]<a href="http://www.imdb.com/title/tt1972663">  Into the Abyss</a>[/b]

Copy this last column and go to a url generating page like: http://www.jmarshall.com/easy/html/testbed.html.

Between the body statements, paste your list of URLs. Click Display.



This will generate a page like this:



Now, you can click on the movie, which will open in IMDB. Then, you can click on your CouchPotato bookmark, and select your quality...and it will get added.

You can see the CouchPotato bookmarklet by the left red arrow - when it works, you'll see the pop-up on the lower right in the second red arrow:



BTW, couch potato is working on a way to download a list of movies: https://couchpota.to/forum/viewtopic.php...79daed6d97