Modify the DB of Moving Picture (1 Viewer)

[chrguy]

Hi all,

I would like to know how to modify the data base (db3) of moving picture. I would like to change in one operation the path of my movies. I have to move all my movies in an other disk (local to sever) and need to modify the path in the DB.
I have made some change with SQLITE, it's OK, but for all the data it's hard.

Did you have an idea?

Thanks.

 

[El-Loco]

Now i got the same prob and want to move all movies from different hd's to a big one.
Any help ?
Thanks in advance !

 

[cilla]

You can open the db with SQLiteBrowser.

There you can also execute an SQL Command.

So you can use an "UPDATE"-command.

Edit:
sry, it may not work quite so. you have to replace only one part of the field (that works not with an update-command, but there is a csv-table export / import function in sqlite browser.

So you can export the table as csv an can edit it with for exaple notepad++ and then you can import this modified file and save the db.

lg cilla


PS: another alternative is to mount the partition in an ntfs-folder (computer manager -> disk management)

 

[kiwijunglist]

Alternative idea

Try this

https://forum.team-mediaportal.com/moving-pictures-284/app-copy-artwork-details-movie-folder-71649/

It uses the mov pics database to copy movie info.nfo, backdrop image & dvdcover image into the movie directory.
When you reimport your movie moving pics scans the info.nfo to identify the movie, then it uses the supplied movie art, so importing is a lot quicker.
Also has option to put your movie files into indivudual folders if necessary.