Hi there,
I wish to import my IMDb ratings on TMDb. But I've noticed the current CSV file exported from IMDb is not formatted exactly as the example_import.csv file required by TMDb for import. Has anybody used the import feature recently and can confirm it works anyway? I have almost 6,000 ratings to import and I wouldn't like to end up with messed up ratings here.
فیلم و نمایش تلویزیونی را نمیتوانید پیدا کنید؟ به سیستم وارد شوید تا آن را ایجاد کنید.
آیا میخواهید به این مورد امتیاز دهید یا به فهرست اضافه کنید؟
عضو نیستید؟
پاسخ توسط Travis Bell
در تاریخ ژانویه 24, 2018 ساعت 8:20 ب.ض
I believe IMDb has 2 different formats they export and we support both of them. So unless there's a third format that I'm not aware of you should be good to go.
پاسخ توسط Francis
در تاریخ ژانویه 25, 2018 ساعت 2:15 ق.ض
Thanks, Travis. I'll give it a try then.
پاسخ توسط Francis
در تاریخ ژانویه 25, 2018 ساعت 3:42 ق.ض
It looks like it worked! Well, more or less... Some 600 ratings got lost in the process. It makes sense for about 50 of them (TV series episodes, unknown shorts, ...), but I can't figure out what happened to the others, nor which titles are missing.
پاسخ توسط Travis Bell
در تاریخ ژانویه 25, 2018 ساعت 9:06 ق.ض
If you head back to the import list section, you can view your import history, and on the list, it will show which items didn't make it.
پاسخ توسط Francis
در تاریخ ژانویه 25, 2018 ساعت 9:57 ق.ض
Yes, I can see why the system kept 5,131 movies(+ratings) out of the 5,145 it detected. But I still don't understand why it detected only 5,145 out of the 5,847 in my file (which is more like 700 missing, actually ).
پاسخ توسط Travis Bell
در تاریخ ژانویه 25, 2018 ساعت 10:13 ق.ض
Ah, I understand now. It's that they weren't detected in your list in the first place.
When I wrote the importer and tested a bunch of different files I learned that IMDb's files are not very well formatted and have a lot of little issues that make it very hard to build a parser that handles everything. There were some cases that I came cross where I simply had to skip the row because the CSV formatting was so wonky. I would suspect that's the problem.
پاسخ توسط Francis
در تاریخ ژانویه 25, 2018 ساعت 12:32 ب.ض
Yes, it's probably the character encoding standard used for IMDb's export file that's to blame. I've checked a few movies with non-standard characters in their original titles: none have been imported.
پاسخ توسط ticao2 🇧🇷 pt-BR
در تاریخ ژانویه 25, 2018 ساعت 3:51 ب.ض
Sorry for my meddling.
Maybe a RegEx? Leave the Title and the name of the Director blank?
What are the required fields for an import?
پاسخ توسط Travis Bell
در تاریخ ژانویه 25, 2018 ساعت 3:57 ب.ض
I only use the IMDB id, rating and date. The problem isn't the actual data I try to import, it's the CSV parsers ability to iterate over rows because of badly placed and quotes and escape characters and the like. In my case, I am using Ruby's standard library CSV parser.
پاسخ توسط Francis
در تاریخ ژانویه 26, 2018 ساعت 12:19 ب.ض
I managed to make it work! Here's what I had to do:
پاسخ توسط Travis Bell
در تاریخ ژانویه 28, 2018 ساعت 12:04 ب.ض
Good job Francis! It doesn't surprise me that a solid commercial product like Excel could clean those files up. That's a very useful tip to know about. Thanks for looking into it some more.