www.bolidesoft.com

[thecoop]

Hi, I just got all my movies to try out and trying to import my movie database which I have created in excel 2007. I have all my movie titles in excel hyper linked to imdb movie pages, I would like to import all this with the hyperlinks as well so I don't have to fill them all in again.

How would I go about doing this? I have looked into creating a separate column just the imdb url trying to pull the info by macro/reference from the already hyper linked column but I have not got that working correctly in excel, I am hoping there is an easier way.

Thanks
Cooper


Edit: Fixed & Solution

To automatically have excel pull the URL as text and place it in another column to import it to All my Movies.

In Excel pres alt+F11 then go to insert and select module and paste the below code.

Function GetAddress(HyperlinkCell As Range)
GetAddress = Replace _
(HyperlinkCell.Hyperlinks(1).Address, "mailto:", "")
End Function


Close that screen and return to your excel workbook, place the below code into a free column to get the URL. Change B2 to which ever column and row your hyperlink is at. So just place it once at the top then use ctrl+D to fill down.

=GetAddress(B2)


If having trouble getting this to work you may need to save your workbook as a macro enabled then re-save again as normal once done to import it into AMM.

[Gemini]

If you managed to get URL in a separate column, you can import only these links to URL field, after which use menu "Tools-Update movie details from IMDb" to fill the rest movie details.
It must work and that is the easiest way.

Best regards,

[thecoop]

Thanks, I was hoping there was a way for AMM to just see the hyperlink and get the imdb address from that. The other method is easy enough and works fine if you have the url as text.

Though that's were my problem is with excel I can't get that url as text into another column. I tried a few different formulas and always errors, guess it's back to the excel forums for me and figure this out if not guess its either try to find another database software similar to AMM that has that support or manually fill in the url to over 4000 fields which I am trying to avoid.

[Gemini]

Unfortunately, we can't help with Excel. We also didn't manage to get url as text into a separate column. Don't even know what to do about it..

[thecoop]

I managed to get the excel formula working to automaticaly ad all the urls as text into another column and the import to AMM went fine.

Though now have another issue which currently searching the board for help as I am guessing others have run into this as well. I have close to 4000 in the list and when I run update IMDB details it never completes. I get a connection error then I have to restart it and it keeps having to redo many of the same movies and it can never complete the entire list. How do I start it at a specific point?


For those finding this post having a similar issue with the hyperlinks in excel I will ad the details in the original post.

[Gemini]

Unfortunately, the menu option "Tools - Update movie details from IMDb" works only for the whole database.
As a sort of workaround, you can try and create several smaller databases, which in the future can be united into one through the menu item "Database-Append from..."

[thecoop]

Thanks Gemini, that should do the trick.

It would be nice in future release if we could choose were to start the update imdb details and even select and highlight a batch in the list and only update those.

[OrganizeIt]

I was able to successfully import and update IMDB url links from excel. However it did not import any cover art. How do I get the cover art automatically imported as well?

[Gemini]

Hi, OrganizeIt!

To automatically import covers from IMDb, you can try to disable the option "Import large covers from" in the preferences in the tab Online databases - then the cover art will be downloaded not from a separate database set in the preferences, but from the same database you're downloading the basic movie data.