Welcome to the ICM Forum. If you have an account but have trouble logging in, or have other questions, see THIS THREAD.
NOTE: Board emails should be working again. Information on forum upgrade and style issues.
Podcast: Talking Images (Episode 22 released November 17th * EXCLUSIVE * We Are Mentioned in a Book!!! Interview with Mary Guillermin on Rapture, JG & More)
Polls: TV-series (Results), Directors (Jan 2nd), 1980 (Jan 24th), <50 checks (Jan 31st)
Challenges: 1000<400, Sci-Fi/Fantasy, Central American/Andean
Film of the Week: Samâ taimu mashin burûsu, February nominations (Jan 29th)
NOTE: Board emails should be working again. Information on forum upgrade and style issues.
Podcast: Talking Images (Episode 22 released November 17th * EXCLUSIVE * We Are Mentioned in a Book!!! Interview with Mary Guillermin on Rapture, JG & More)
Polls: TV-series (Results), Directors (Jan 2nd), 1980 (Jan 24th), <50 checks (Jan 31st)
Challenges: 1000<400, Sci-Fi/Fantasy, Central American/Andean
Film of the Week: Samâ taimu mashin burûsu, February nominations (Jan 29th)
IMDB Ratings / Vote History Analyzer
-
- Posts: 3
- Joined: December 3rd, 2012, 7:00 am
- Contact:
IMDB Ratings / Vote History Analyzer
Hello there,
although I have been using iCM for quite a while, I am new to this board. And it comes with a question. First, I'd like to explain what I am trying to do:
Some years ago there was an awesome website called IVHA (IMDB Vote History Analyzer). You could enter the public link to your ratings history and the website would create stats from that: how many movies from that decade have you seen, what are your top genres, who are your top actors and so forth. Due to countless IMDB redesigns the website stopped working and has been taken off some years ago.
Now I want to recreate that website. Right now I am using the ratings.csv (the exported ratings history) to get the IDs of all the movies I've rated on IMDB. With the help of IMDBPHP I am filling an SQL database with all the movies, actors, genres, keywords etc. to create stats. Unfortunately, IMDBPHP does not include a function to directly access the IMDB My Movies ratings history, which iCM does.
Now to my question: iCM does manage to directly access the rating history, as you can simply import your ratings. I don't want anyone to divulge any corporate secrets, but it would be immensely helpful to know how to do this. Then I could update all the existing data once a week or so without the user having to reupload his updated ratings.csv. When the website is finished I will of course make it publicly accessible.
I'd appreciate any help. Thanks a lot for your time, bye, Michael.
although I have been using iCM for quite a while, I am new to this board. And it comes with a question. First, I'd like to explain what I am trying to do:
Some years ago there was an awesome website called IVHA (IMDB Vote History Analyzer). You could enter the public link to your ratings history and the website would create stats from that: how many movies from that decade have you seen, what are your top genres, who are your top actors and so forth. Due to countless IMDB redesigns the website stopped working and has been taken off some years ago.
Now I want to recreate that website. Right now I am using the ratings.csv (the exported ratings history) to get the IDs of all the movies I've rated on IMDB. With the help of IMDBPHP I am filling an SQL database with all the movies, actors, genres, keywords etc. to create stats. Unfortunately, IMDBPHP does not include a function to directly access the IMDB My Movies ratings history, which iCM does.
Now to my question: iCM does manage to directly access the rating history, as you can simply import your ratings. I don't want anyone to divulge any corporate secrets, but it would be immensely helpful to know how to do this. Then I could update all the existing data once a week or so without the user having to reupload his updated ratings.csv. When the website is finished I will of course make it publicly accessible.
I'd appreciate any help. Thanks a lot for your time, bye, Michael.
You can ask The Guys directly on ICM
I really like the idea and it could be very helpful, so hopefully they'll answer you to your satisfaction.
I really like the idea and it could be very helpful, so hopefully they'll answer you to your satisfaction.
-
- Posts: 3889
- Joined: June 18th, 2011, 6:00 am
- Location: Finland
- Contact:
If the link to your IMDb ratings is http://www.imdb.com/user/ur12345678/ratings, where userid=ur12345678, then the direct link to download the CSV file is http://www.imdb.com/list/export?list_id ... ur12345678.
If that's what you're asking?
edit: And if you use Python to develop you can simply do:
If that's what you're asking?
edit: And if you use Python to develop you can simply do:
Code: Select all
import requests
url = 'http://www.imdb.com/list/export?list_id=ratings&author_id=ur12345678'
r = requests.get(url)
if r.status_code != 200:
# private list
else:
# parse csv file
Last edited by themagician on December 3rd, 2012, 1:25 pm, edited 1 time in total.
-
- Posts: 3
- Joined: December 3rd, 2012, 7:00 am
- Contact:
Do you also use the .csv-file to import the movies on iCM or is there a way to access the ratings directly? Point is, that I want to refresh the users' history and thus their stats once or twice a day via a cronjob and if I have to access every csv-file (some are over a megabyte) .. well, it's quite a lot of data going in and out.
But nevertheless, thanks a lot for that hint with the export url, I will definitely try that one out if there is no other way.
But nevertheless, thanks a lot for that hint with the export url, I will definitely try that one out if there is no other way.

I really loved IVHA and was heartbroken when it stopped working, so if you manage to recreate it you'll be my hero burdenofhope!
- St. Gloede
- Moderator
- Posts: 11825
- Joined: May 6th, 2011, 6:00 am
- Contact:
I loved it too. Only problem was that it didn't seperate between TV eps and movies, causing the actor listing to be particularly skewed.kingink on Dec 3 2012, 06:54:22 AM wrote:I really loved IVHA and was heartbroken when it stopped working, so if you manage to recreate it you'll be my hero burdenofhope!
Because of ivha I never voted on imdb any episodes or all the greek movies I've seen. I didn't want my stats to be a total mess. And I still keep that rule hoping for another ivha to make it's appearance
Maybe you can set it so that users have to click a button to refresh their ratings histories (and if necessary limit it to 2 or 3 times per user per week), so then you won't be downloading every csv every day.burdenofhope on Dec 3 2012, 06:39:34 AM wrote:Do you also use the .csv-file to import the movies on iCM or is there a way to access the ratings directly? Point is, that I want to refresh the users' history and thus their stats once or twice a day via a cronjob and if I have to access every csv-file (some are over a megabyte) .. well, it's quite a lot of data going in and out.
But nevertheless, thanks a lot for that hint with the export url, I will definitely try that one out if there is no other way.![]()
Last edited by mjf314 on December 3rd, 2012, 7:05 pm, edited 1 time in total.
Loved that site, hope this works!
-
- Posts: 3
- Joined: December 3rd, 2012, 7:00 am
- Contact:
Just wanted to let you guys know that it is looking good. themagician's idea works fine, let's just hope that IMDB does not make any other questionable design and structural changes. I might have something to show for in two weeks.
Bye, Michael.
Bye, Michael.
- St. Gloede
- Moderator
- Posts: 11825
- Joined: May 6th, 2011, 6:00 am
- Contact:
- mightysparks
- Site Admin
- Posts: 31256
- Joined: May 5th, 2011, 6:00 am
- Location: Perth, WA, Australia
- Contact:
Squee! I missed out on the original site and was saddened, so it'll be nice to get a go at it 

- St. Gloede
- Moderator
- Posts: 11825
- Joined: May 6th, 2011, 6:00 am
- Contact:
If there's a way to exclude TV eps it would be even more awesome.
My top rated year is 1908, followed by 1927 and 1952.
At the bottom of the top-rated genre (lowest rated) is westerns.
At the bottom of the top-rated genre (lowest rated) is westerns.
Ha, I see I'm not the only one who had the same idea. On the facebook group I recently posted very proud how I imported my imdb csv to a mysql database and from there I could of course querry it whatever way I wanted.
What's suggested here would be of course the logical next step for me too.
But when someone else does that work, there is more time for me to watch films. ;)
What's suggested here would be of course the logical next step for me too.
But when someone else does that work, there is more time for me to watch films. ;)
I've seen things you people wouldn't believe. Attack ships on fire off the shoulder of Orion. I watched C-beams glitter in the dark near the Tannhäuser Gate. All those moments will be lost in time, like tears in rain. Time to die.
IMDB has a new feature now that does all the work for you.metaller on Feb 15 2013, 03:16:34 AM wrote:Ha, I see I'm not the only one who had the same idea. On the facebook group I recently posted very proud how I imported my imdb csv to a mysql database and from there I could of course querry it whatever way I wanted.
What's suggested here would be of course the logical next step for me too.
But when someone else does that work, there is more time for me to watch films. ;)


Where is this feature hiding?allisoncm on Feb 15 2013, 02:23:57 PM wrote:IMDB has a new feature now that does all the work for you.metaller on Feb 15 2013, 03:16:34 AM wrote:Ha, I see I'm not the only one who had the same idea. On the facebook group I recently posted very proud how I imported my imdb csv to a mysql database and from there I could of course querry it whatever way I wanted.
What's suggested here would be of course the logical next step for me too.
But when someone else does that work, there is more time for me to watch films. ;)At first it didn't work because I had so many votes.
But now it does.

- brokenface
- Donator
- Posts: 13753
- Joined: December 29th, 2011, 7:00 am
- Contact:
click on your account and then View Your Achievements.
Thanks! I would have never noticed that link on my own.
My four highest rated genres are really just one genre: film noir, crime, mystery, thriller! I don't have the most diverse of tastes
My four highest rated genres are really just one genre: film noir, crime, mystery, thriller! I don't have the most diverse of tastes


- brokenface
- Donator
- Posts: 13753
- Joined: December 29th, 2011, 7:00 am
- Contact:
if you have other people's imdb account and go to it, it now gives you a comparison as well (how many ratings the same/higher/lower and a similarity score), check the Lounge thread a page or two back.
e.g. try mine: http://www.imdb.com/user/ur5409488/
e.g. try mine: http://www.imdb.com/user/ur5409488/
You also like film noirbrokenface on Feb 15 2013, 05:03:39 PM wrote:if you have other people's imdb account and go to it, it now gives you a comparison as well (how many ratings the same/higher/lower and a similarity score), check the Lounge thread a page or two back.
e.g. try mine: http://www.imdb.com/user/ur5409488/

Here is mine:
http://www.imdb.com/user/ur3840633/
My "Count by Title Year" graph would make a nice city skyline


- brokenface
- Donator
- Posts: 13753
- Joined: December 29th, 2011, 7:00 am
- Contact:
Sure do like noir 
1943 is your Empire State Building!

1943 is your Empire State Building!
I think someone posted the info here on the board recently, but I forget which thread, so I posted it in this one.frbrown on Feb 15 2013, 05:01:11 PM wrote:Thanks! I would have never noticed that link on my own.
My four highest rated genres are really just one genre: film noir, crime, mystery, thriller! I don't have the most diverse of tastes![]()

Still a matter close to my heart.
Are the Criticker stats any comparable? I think some of you guys mentioned them for the Directors poll, but I'm not registered there yet.
Are the Criticker stats any comparable? I think some of you guys mentioned them for the Directors poll, but I'm not registered there yet.
- Armoreska
- Posts: 12700
- Joined: November 1st, 2012, 6:00 am
- Location: Ukraine, former Free Territory
- Contact:
mine looks like a stage to Mont Ventouxfrbrown on Feb 15 2013, 05:20:59 PM wrote:You also like film noirbrokenface on Feb 15 2013, 05:03:39 PM wrote:if you have other people's imdb account and go to it, it now gives you a comparison as well (how many ratings the same/higher/lower and a similarity score), check the Lounge thread a page or two back.
e.g. try mine: http://www.imdb.com/user/ur5409488/![]()
Here is mine:
http://www.imdb.com/user/ur3840633/
My "Count by Title Year" graph would make a nice city skyline![]()

he or A. or Armo or any

currently working towards a vegan/free world + thru such film lists: ELIO PETRI,
imaginary awards | youtube channels | complaint lounge | explain how big a fan of slavery you are here, ..viewtopic.php?f=12&t=1535 and here: ..viewtopic.php?f=12&t=4484

currently working towards a vegan/free world + thru such film lists: ELIO PETRI,
Spoiler
ANARCHISTS, 2010s bests, Yasujiro Ozu, Visual Effects nominees, kid-related stuff, great animes (mini-serie or feature), very 80s movies, 17+ sci-fi lists on watchlist, ENVIRO, remarkable Silent Films and Pre-Code (exploring 1925 atm) and every shorts and docu list I'm aware of and
/forum.icmforum.com/viewtopic.php?f=1&t=1434
and "Gordon" Liu Chia-Hui/Liu Chia-Liang and Yuen Woo-ping and "Sammo" Hung Kam-bo
/forum.icmforum.com/viewtopic.php?f=1&t=1434
and "Gordon" Liu Chia-Hui/Liu Chia-Liang and Yuen Woo-ping and "Sammo" Hung Kam-bo
- xianjiro
- Donator
- Posts: 8710
- Joined: June 17th, 2015, 6:00 am
- Location: Kakistani Left Coast
- Contact:
So, not sure where else to put this, but for those interested in the IMDb Top 1000's effect on ratings, here's a really good example. https://www.imdb.com/title/tt0205963/ratings
"213 IMDb users have given a weighted average vote of 6.5 / 10"
and
"Arithmetic mean = 7.2 Median = 8"
but the next page
https://www.imdb.com/title/tt0205963/ra ... 000_voters
"14 IMDb users have given a weighted average vote of 2.1 / 10"
and
"Arithmetic mean = 2.1 Median = 1"
I leave it to the mathematicians to figure out the formula and please not, I just rated this title so time in the next few hours the numbers will change.
"213 IMDb users have given a weighted average vote of 6.5 / 10"
and
"Arithmetic mean = 7.2 Median = 8"
but the next page
https://www.imdb.com/title/tt0205963/ra ... 000_voters
"14 IMDb users have given a weighted average vote of 2.1 / 10"
and
"Arithmetic mean = 2.1 Median = 1"
I leave it to the mathematicians to figure out the formula and please not, I just rated this title so time in the next few hours the numbers will change.