DvdPedia: Import new collection from excel, word or html

[inoshirohonda]

Hi devs, i've a great problem. I need to import into dvdpedia one list of about 5000 dvd, but i have all titles on excel, word or html.
There are columns "Code", "Title", "Genres". How i can import this?
Please help me, add 5000 dvd manually it's too hard for me...
Best regards

[Nora]

If you have the file in Excel, add column headers to each column (for easier matching in DVDpedia and so the first entry doesn't get lost during the import), export the file in tab delimited format and use the 'Import collection' command found under the File menu in DVDpedia. That'll bring up an importer window where you can match your columns to fields available in DVDpedia.

By default all imports are placed into a library-independent collection first (marked with a grey collection icon) so you can make sure that everything went well. To make the import part of your Library, select the collection and choose 'Include collection in Library' from the File menu. After that you can delete the imported collection.

[inoshirohonda]

Done, thanks a lot
It's possible to add all info for multiple movie at the same time from "Terminal Video"?
And it's possible remove the import link from the movie? I don't like click on the picture and go to other website.

[Nora]

You can update information for more than one movie at a time, sure. Select them all and choose 'Update from > Terminal Video' from the Movie menu. Keep in mind though that with this option the first result returned will be downloaded and you won't be able to check the results until after the download has finished.
If you'd like more control over the data added, use the little gear button in the edit window instead to update each movie individually. That way if there's more than one result returned you can select the correct one from the drawer on the side of the window.

To remove the URL for all entries at once, select all and open the Edit window. In the multiple edit window that opens check the box next to 'URL' and leave the field blank. (If you don't see the URL field in your edit window, turn it on in the Preferences/Fields first.)

[inoshirohonda]

Great, thank a lot !!!