Welcome to the ICM Forum. If you have an account but have trouble logging in, or have other questions, see THIS THREAD.
Polls: Favorite Movies (Results), 1945 (Results), 1929 awards (Apr 4th), South Asia (Apr 25th), Doubling the Canon (Ratings Apr 30th)
Challenges: Doubling the Canon, Nordic, 1950s
Film of the Week: Valkoinen peura, May nominations (May 1st)
World Cup S4: Round 1 schedule, 1F: Brazil vs Greece vs Japan vs Poland (Apr 5th), 1G: Germany vs Pakistan vs Ukraine vs USA (Apr 22nd)

All official checks filtering question.

Post Reply
User avatar
Mochard
Posts: 2134
Joined: May 13, 2011
Location: California
Contact:

All official checks filtering question.

#1

Post by Mochard » November 21st, 2019, 3:46 am

I am trying to list all official checks and then filter / sort them by runtimes but I can't seem to find a way! Is it even possible to filter by runtime? I can't seem to find a way that works.

The only thing I can think of doing is to export every list then remove duplicates and then I can sort by runtime.

If this is the only way then I'm asking if anyone happens to have already created a spreadsheet with all official checks on it that they are willing to share?

Or if anyone knows of something I am missing? It would be nice if rather than seeing all movies - you see all official movies as an option then you can sort by runtimes etc.

Exporting the lists doesn't show runtimes so that's out! Maybe an imdb list exists as that would have runtimes on if exported.

Thanks

User avatar
maxwelldeux
Donator
Posts: 7796
Joined: Jun 07, 2016
Location: Seattle-ish, WA, USA
Contact:

#2

Post by maxwelldeux » November 21st, 2019, 5:16 am

What are you looking for?

If you're looking for shorts, joachimt and mjf314 are your best friends:
All Shorts on iCM Lists
Short features: official checks from 46 to 69 minutes

If you're looking for longs, I don't have that at my fingertips.

But more generally (and I'm speaking from memory, so forgive me if I'm wrong on details), there's no way to filter only official checks, and it's not possible to export ICM search results. Also, ICM has a list limit of 5000 titles, and there are ~17000+ official checks.

But in this respect, Tim2460 is your best friend:
Films on 3+ Official lists
Films on 2 Official lists
Films on 1 Official list p1
Films on 1 Official list p2

That distills all official checks down to four lists (data are updated monthly). If you want to do more from there, that's on you. :P

User avatar
Tim2460
Posts: 1513
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

#3

Post by Tim2460 » November 21st, 2019, 8:40 am

Using both icm and imdb export is indeed the way to go.

It's not that difficult but i have develop some excel skill over the years so enjoy :
https://we.tl/t-nUcjtMgTBZ

User avatar
Mochard
Posts: 2134
Joined: May 13, 2011
Location: California
Contact:

#4

Post by Mochard » November 21st, 2019, 5:14 pm

Thank you guys so much.

Yeah i was fine for shorts - oh I didn't see mjf's short features though - thats cool.

Tim - I can't download your link atm as I'm at work (I shouldn't really be on this forum either but whatever!) but thank-you again. I really appreciate it. I'll grab it on my lunch.

User avatar
Mochard
Posts: 2134
Joined: May 13, 2011
Location: California
Contact:

#5

Post by Mochard » November 21st, 2019, 8:06 pm

Tim2460 wrote:
November 21st, 2019, 8:40 am
Using both icm and imdb export is indeed the way to go.

It's not that difficult but i have develop some excel skill over the years so enjoy :
https://we.tl/t-nUcjtMgTBZ
Just downloaded it - it's perfect - just what I was looking for

Thanks

User avatar
maxwelldeux
Donator
Posts: 7796
Joined: Jun 07, 2016
Location: Seattle-ish, WA, USA
Contact:

#6

Post by maxwelldeux » November 21st, 2019, 11:36 pm

Mochard wrote:
November 21st, 2019, 8:06 pm
Tim2460 wrote:
November 21st, 2019, 8:40 am
Using both icm and imdb export is indeed the way to go.

It's not that difficult but i have develop some excel skill over the years so enjoy :
https://we.tl/t-nUcjtMgTBZ
Just downloaded it - it's perfect - just what I was looking for

Thanks
Hot diggity damn... that's even better than I expected. Thanks for sharing!

User avatar
blueboybob
Donator
Posts: 1726
Joined: Mar 11, 2013
Location: DC
Contact:

#7

Post by blueboybob » November 22nd, 2019, 12:03 am

There is also a less up to date 80 minutes list https://www.icheckmovies.com/lists/offi ... adatriste/

User avatar
Ebbywebby
Posts: 2903
Joined: Sep 10, 2012
Location: Orange County, CA
Contact:

#8

Post by Ebbywebby » November 22nd, 2019, 12:07 am

maxwelldeux wrote:
November 21st, 2019, 5:16 am
What are you looking for?

If you're looking for shorts, joachimt and mjf314 are your best friends:
All Shorts on iCM Lists
Short features: official checks from 46 to 69 minutes
Mochard wrote:
November 21st, 2019, 5:14 pm

I didn't see mjf's short features though - thats cool.
It's not really JoachimT's or mjf314's short features list...it's mine. JoachimT started hosting it as a favor when non-paying users couldn't share multiple lists and, well, it has stayed that way.

I'm your best friend too. ;)

User avatar
maxwelldeux
Donator
Posts: 7796
Joined: Jun 07, 2016
Location: Seattle-ish, WA, USA
Contact:

#9

Post by maxwelldeux » November 22nd, 2019, 12:33 am

Ebbywebby wrote:
November 22nd, 2019, 12:07 am
maxwelldeux wrote:
November 21st, 2019, 5:16 am
What are you looking for?

If you're looking for shorts, joachimt and mjf314 are your best friends:
All Shorts on iCM Lists
Short features: official checks from 46 to 69 minutes
Mochard wrote:
November 21st, 2019, 5:14 pm

I didn't see mjf's short features though - thats cool.
It's not really JoachimT's or mjf314's short features list...it's mine. JoachimT started hosting it as a favor when non-paying users couldn't share multiple lists and, well, it has stayed that way.

I'm your best friend too. ;)
Best friends all around! :P

But yeah - thanks for putting that together!

User avatar
joachimt
Donator
Posts: 30941
Joined: Feb 16, 2012
Location: Netherlands
Contact:

#10

Post by joachimt » November 22nd, 2019, 5:55 am

Indeed. EbbyWebby keeps track of 46 to 69 minutes, but I update the list.
I keep track of 45 minutes and less, but mjf314 updates the list.
It's confusing, I know, but we're all best friends indeed. :hug:
ICM-profile
Fergenaprido: "I find your OCD to be adorable, J"

User avatar
Tim2460
Posts: 1513
Joined: Oct 01, 2018
Location: Dijon, France
Contact:

#11

Post by Tim2460 » November 22nd, 2019, 8:10 am

Glad the excel is usefull !

User avatar
Ebbywebby
Posts: 2903
Joined: Sep 10, 2012
Location: Orange County, CA
Contact:

#12

Post by Ebbywebby » November 22nd, 2019, 8:50 am

joachimt wrote:
November 22nd, 2019, 5:55 am
Indeed. EbbyWebby keeps track of 46 to 69 minutes, but I update the list.
I keep track of 45 minutes and less, but mjf314 updates the list.
So now I need to find some underappreciated newbie to mentor and host a list for. :)

User avatar
Coryn
Posts: 1104
Joined: Dec 05, 2018
Contact:

#13

Post by Coryn » November 22nd, 2019, 5:45 pm

Tim2460 wrote:
November 21st, 2019, 8:40 am
Using both icm and imdb export is indeed the way to go.

It's not that difficult but i have develop some excel skill over the years so enjoy :
https://we.tl/t-nUcjtMgTBZ
(l) (l) (l)
I saved Latin, what did you ever do ?

Post Reply