Retrieving DVD library from iDisk

[klpete]

I've had DVDpedia, CDpedia and Bookpedia (as well as Pocketpedia now) for a few years. I lost my DVD library database a while ago and was daunted by the prospect of remaking it (400+ DVDs). I recently went onto my iDisk and saw that I had saved the library there. The only problem is that it is there in .html format. I tried, but I can't import it that way into DVDpedia.

What file type does it have to be in to import? Do you know of a way to import from my current state?

Thank you in advance.

[Conor]

Hi, I reposting part of the email I sent you here. In case other users want to do a similar import.

Extract a list list of ASINs and you can use the "add multiple" in the programs to import them. The add multiple has a single field but it will take a list of new line separated values.

The links that can hold the ASIN could look like these two types:

http://www.amazon.fr/exec/obidos/ASIN/2130484190/

http://www.amazon.fr/gp/redirect.html?ASIN=2883020140

For example using the free program TextWrangler you could do a find all (with grep enabled, which uses regular expressions for a more powerful find) on multiple files for:

Code: Select all

.*ASIN=(..........).*

This matches the second type of link. You then copy paste the results into a new file and use replace all to remove the extra parts of the link:

Code: Select all

.*ASIN=(..........).*

for:

Code: Select all

\1

If you do not have the ASINs then the second best option is to extract all the titles, but these will not lead to exact matches on Amazon. If you do extract a list of titles be sure to set the search limit to "title" in the regular search window before starting the add multiple.