It is currently Wed Apr 24, 2024 6:59 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 19 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: import movies from IMDB database?
PostPosted: Sat Aug 06, 2011 4:59 pm 
Offline

Joined: Thu Oct 09, 2008 1:15 pm
Posts: 12
I have used this program before and loved it. I switched to the IMDB database and am not really happy with it. Is there a way to import my movies from the IMDB database so that I don't have to re-input all my movies over again? Thanks for your help.


Top
 Profile  
 
 Post subject: Re: import movies from IMDB database?
PostPosted: Sat Aug 06, 2011 5:14 pm 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7655
To my knowledge, MyIMDb doesn't have any export feature. Am I wrong ?

And by the way, Coollector doesn't have any import feature either, but this will change as soon as next month :yes:


Top
 Profile  
 
 Post subject: Re: import movies from IMDB database?
PostPosted: Sat Aug 06, 2011 5:18 pm 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7655
I just had another look, and in fact they seem to have an export feature. Is it new ?

Could you please mail me your csv file at this address: hector at coollector dot com

That will help me when I'll implement the import feature.


Top
 Profile  
 
 Post subject: Re: import movies from IMDB database?
PostPosted: Sun Aug 07, 2011 2:57 am 
Offline

Joined: Thu Oct 09, 2008 1:15 pm
Posts: 12
As soon as they allow me to export to an Excel file, I will do so. I should be able to then transfer all my movies into Coolector. Thanks.


Top
 Profile  
 
 Post subject: Re: import movies from IMDB database?
PostPosted: Sun Aug 07, 2011 8:05 am 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7655
deemer wrote:
As soon as they allow me to export to an Excel file, I will do so.

Below each list on IMDb, there's a link "Export this list" to download the csv file.

csv files are not Excel files. They're just "coma separated values" files.

Please send me the csv file of your list.


P.S: I'm not quite sure that we're talking about the same thing. On IMDb, I could only find a service called "Your watchlist". Is it what you're using ? I remember that, once upon a time, there was a service called "My IMDb", but I can't find it anymore.


Top
 Profile  
 
 Post subject: Re: import movies from IMDB database?
PostPosted: Sun Aug 07, 2011 8:20 am 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7655
Alright, I finally found out. The service I knew wasn't called "MyIMDb" but "MyMovies".

MyMovies doesn't allow exporting, but MyMovies will disappear in a few days and be moved to the lists service, which allow exporting...


IMDb wrote:
During this upgrade, your My Movies lists will get lots of new features:

*...
* ...
* Export lists to Excel using a csv file.
*...
* ...


Top
 Profile  
 
 Post subject: Re: import movies from IMDB database?
PostPosted: Mon Aug 08, 2011 12:05 am 
Offline

Joined: Mon Aug 08, 2011 12:04 am
Posts: 2
I'm curious, how are you going to work out the difference in the rating systems when importing ratings? 5 stars for netflix, 10 stars for imdb, 7 for coollector....


Top
 Profile  
 
 Post subject: Re: import movies from IMDB database?
PostPosted: Mon Aug 08, 2011 12:45 am 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7655
There'll be a default conversion scheme.

For instance:

10 => excellent
9 => very good
8 => very good
7 => very good
6 => good
6 => good
etc...

If you're not satisfied with it, you'll have the possibility to customize it.


Top
 Profile  
 
 Post subject: Re: import movies from IMDB database?
PostPosted: Mon Aug 08, 2011 1:05 am 
Offline

Joined: Mon Aug 08, 2011 12:04 am
Posts: 2
Sounds great, thanks! Now if we can only convince Netflix to have a neutral rating.... :p


Top
 Profile  
 
 Post subject: Re: import movies from IMDB database?
PostPosted: Mon Aug 08, 2011 1:28 am 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7655
RammsteinNicCage wrote:
Now if we can only convince Netflix to have a neutral rating.... :p

Neutral is between good and bad. Sometimes it's a good movie but you didn't enjoy it. Sometimes it's a bad movie but you enjoyed it. And sometimes it's a so-so movie.

Personally, I have a problem with stars rating. A restaurant with 1 star is a good restaurant. The same for hotels. But a movie with 1 star ? Is it a good or a bad movie ?

I've never understood how we're supposed to rate with stars. Is there a consensus ? Or everyone just use the system with his own interpretation ?


Top
 Profile  
 
 Post subject: Re: import movies from IMDB database?
PostPosted: Mon Aug 08, 2011 1:33 am 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7655
A 5 stars hotel is quite exceptional. A movie with 5 stars on IMDb is just average :roll:


Top
 Profile  
 
 Post subject: Re: import movies from IMDB database?
PostPosted: Mon Aug 08, 2011 3:49 am 
Offline
User avatar

Joined: Thu Jan 06, 2011 2:29 am
Posts: 707
Location: Jamaica
(cool) Hector wrote:
For instance:

10 => excellent
9 => very good
8 => very good
7 => very good
6 => good
6 => good
etc...


Wouldn't it be more accurate to use a simple mathematical function instead, considering that it has already been established that these forms of ratings don't really have any set standards and are subject to personal interpretation. To represent a rating out of 5 as a rating from %100 you multiply by 20. So in this situation why not multiply by 1.40 for a five star rating?Or multiply by 0.7 for a rating out of 10?

That's something that really has me baffled. Is it more accurate to use numerical operations or is it better to come to an agreement on the meaning of each rating on the various scales?

... Something to think on


Top
 Profile  
 
 Post subject: Re: import movies from IMDB database?
PostPosted: Mon Aug 08, 2011 8:07 am 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7655
kakashi wrote:
Wouldn't it be more accurate to use a simple mathematical function instead, considering that it has already been established that these forms of ratings don't really have any set standards and are subject to personal interpretation.

Well, the default conversion scheme isn't very important. The most important is that it'll be customizable.


kakashi wrote:
To represent a rating out of 5 as a rating from %100 you multiply by 20. So in this situation why not multiply by 1.40 for a five star rating?Or multiply by 0.7 for a rating out of 10?

That's something that really has me baffled.

I'm baffled too :wacko: :D

What conversion scheme would you suggest for a scale of 10 ? For a scale of 5 ?


Top
 Profile  
 
 Post subject: Re: import movies from IMDB database?
PostPosted: Mon Aug 08, 2011 8:33 am 
Offline
User avatar

Joined: Thu Jan 06, 2011 2:29 am
Posts: 707
Location: Jamaica
(cool) Hector wrote:
What conversion scheme would you suggest for a scale of 10 ? For a scale of 5 ?

I'd probably go with multiplication but that would be taking the easy way out.
kakashi wrote:
multiply by 1.40 for a five star rating or multiply by 0.7 for a rating out of 10

The best possible solution (though quite inconvenient :( ) would probably be to compare ratings from each source with the ratings given by users in coollector for a few sample movies then use those values to do this:
(cool) Hector wrote:
10 => excellent
9 => very good
8 => very good
7 => very good
6 => good
6 => good
etc...

That way there's a wider data pool and the results are less likely to reflect any one person's interpretation of the ratings.
... I'd say go with the latter if you think it's worth the effort. i.e. Your idea except you would need to sample ratings from a few users to help with accuracy.


Top
 Profile  
 
 Post subject: Re: import movies from IMDB database?
PostPosted: Mon Aug 08, 2011 8:57 am 
Offline
User avatar

Joined: Tue Sep 27, 2005 2:28 am
Posts: 7655
kakashi wrote:
The best possible solution (though quite inconvenient :( ) would probably be to compare ratings from each source with the ratings given by users in coollector for a few sample movies

I don't know how Coollector users rate the movies. I don't have access to that data.

Also, as I said, I won't go into a lengthy process to fix a default conversion scheme. That's not that important. The most important is that it'll be customizable, to adapt to each person's way of rating.


kakashi wrote:
... I'd say go with the latter if you think it's worth the effort. i.e. Your idea except you would need to sample ratings from a few users to help with accuracy.

A quick poll on this forum will be enough.

What is the conversion scheme that you (anyone who reads this) would suggest ?


Top
 Profile  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 19 posts ]  Go to page 1, 2  Next

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 42 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  


Powered by phpBB © 2024 phpBB Group