[therealjoeblow]

Hi, I have quite a large number of TV Shows that don't update the ratings with this addon because they are missing the IMDB tt####### ID's.

I know I can edit and add them manually one by one using this addon, but I'm thinking it would much faster and more efficient for me to add them by editing the database directly.  I looked through the tables and it's not readily apparent where the IMDB ID's get stored.

Could someone familar with the database structure please point me in the right direction?

Many thanks!
TRJB

[Karellen]

they are missing the IMDB tt####### ID's.

Either the IMDB ID or TMDB ID should work.

I looked through the tables and it's not readily apparent where the IMDB ID's get stored.

Stored in the unique_id table with a link to the media_id.
Probably not best to edit the db for this.
Why don't you have imdb or tmdb id's? How did you add the media to the library in the first place? Scrapers or nfo files?

[therealjoeblow]

It's some of really old stuff in my library that was scraped using whatever official scrapers were available at the time a long time ago, wayback in the "XBMC Babylon" days or thereabouts. I guess way back then TVDB didn't have IMDB links in their data.

I see what you mean, without storing them directly beside a direct reference to the show title it's not going to be any easier to edit the db directly.  I guess I'll just chug away with them one at a time with the addon in the regular UI.

I don't really want to re-scrape my stuff as I have painstakenly curated all of my artwork over the years and don't want it all to get replaced with new/other versions.

Is there a way to just rescrape all of the data and leave all of the artwork existing without touching it?

TRJB

[axlt2002]

It's some of really old stuff in my library that was scraped using whatever official scrapers were available at the time a long time ago, wayback in the "XBMC Babylon" days or thereabouts. I guess way back then TVDB didn't have IMDB links in their data.

I see what you mean, without storing them directly beside a direct reference to the show title it's not going to be any easier to edit the db directly.  I guess I'll just chug away with them one at a time with the addon in the regular UI.

I don't really want to re-scrape my stuff as I have painstakenly curated all of my artwork over the years and don't want it all to get replaced with new/other versions.

Is there a way to just rescrape all of the data and leave all of the artwork existing without touching it?

TRJB

Hello @therealjoeblow, thanks for being a user of my add-on!

Well, if your posters and fanart images are stored in the folder where the video file is, the scraper should prioritize them instead of downloading new ones from the Internet (i.e., in general, only the missing information are downloaded). @Karellen, can you confirm? In any case, to be on the safe side, I would suggest you to make a try on one single movie. 

Have a great day!

[Karellen]

., in general, only the missing information are downloaded). @Karellen,

Correct.
Locally saved artwork which is correctly named and saved has priority.

[bckspc]

First of all I want to thank you for all your hard work in this addon. I love it.

I sometimes insert the imdb id using the database directly using the query:

INSERT INTO `uniqueid` (media_id,media_type,`value`,`type`) VALUES (@MediaId, 'episode', @ImdbId, 'imdb'), where media_id is the episode id and the value is the imdb id

Using the latest version 5.1.3 of the addon and I have it set to episode update mode.

This works fine and if I update the full TV Show or a single season most of the time all the episodes get their own ratings correctly but sometimes this does not update (normally when the number of rating votes is low). I noticed that the ones that do not work if I update the episode directly it updates the rating but if I do it globally by tv show or season it doesn't.
Don't know if this is a bug or a feature but it seems updating a single episode has a different behavior than updating the full season or show.

Also I would like to suggest an improvement. I have a huge list of movies and tvshows and if I run the updater it takes hours to update all my library. Would it be possible to have another option in the addon menu just to update all TV Shows or all Movies but not both?

Also, since I now am updating 30+ episodes due to that bug I find myself doing 2 clicks for every update, one to bring up the menu and another to actually update, if we have a menu options or a keyboard shortcut just to do the update without showing the summary afterwards as well would be lovely

Again, thanks for you work!

[axlt2002]

First of all I want to thank you for all your hard work in this addon. I love it.

I sometimes insert the imdb id using the database directly using the query:

INSERT INTO `uniqueid` (media_id,media_type,`value`,`type`) VALUES (@MediaId, 'episode', @ImdbId, 'imdb'), where media_id is the episode id and the value is the imdb id

Using the latest version 5.1.3 of the addon and I have it set to episode update mode.

This works fine and if I update the full TV Show or a single season most of the time all the episodes get their own ratings correctly but sometimes this does not update (normally when the number of rating votes is low). I noticed that the ones that do not work if I update the episode directly it updates the rating but if I do it globally by tv show or season it doesn't.
Don't know if this is a bug or a feature but it seems updating a single episode has a different behavior than updating the full season or show.

Also I would like to suggest an improvement. I have a huge list of movies and tvshows and if I run the updater it takes hours to update all my library. Would it be possible to have another option in the addon menu just to update all TV Shows or all Movies but not both?

Also, since I now am updating 30+ episodes due to that bug I find myself doing 2 clicks for every update, one to bring up the menu and another to actually update, if we have a menu options or a keyboard shortcut just to do the update without showing the summary afterwards as well would be lovely

Again, thanks for you work!

Hi @bckspc, thanks a lot for your post and for using my add-on.

Concerning the "bug", it would be great if you can provide a complete update log in order to understand better the behavior and identify eventual issues. Please refer to the first post of this thread for the details.

Secondly, if you go in the add-on settings, you can exactly find the options you are looking for updating Movies or TV Shows libraries only.

Finally, the pop-up window is basically used to edit the IDs and to check if the rating has been correctly update afterwards. I was not taking into account that someone could update more than 30 episodes using the manual update from the context menu (this is not a normal way of using the add-on)   Anyway, a setting to disable such pop-window seems a nice idea to speed up the process in case you are confident of the episode's IDs, etc.. I will take into consideration it in a next release...when it will come the time!  

[bckspc]

Thanks for your reply. Unfortunately I manually updated all buggy entries for the time being so would not be easy to reproduce the bug. As soon as I have a similar issue I'll post here.

Just a clarification, regarding the update only Shows or Movies I know about the settings but by default I want to update all if on a schedule, etc. But if I manually just want to update Shows, I need to go to the settings, disable Movies, run the update, wait for it for finish and then enable Movies again. Again this was just a nice to have, nothing major.

Regarding the feature for single episode update of not showing the Update window before and after the update would love to have that and although I understand that probably this is not the regular use of the add-on, if I have 3 TV shows that just release a new episode I'll go to each show and update the last episode on each. I normally do this because updating the full show if it's too big could take a while.

I'll keep you posted as soon as I get some buggy episodes to get the logs

[axlt2002]

Thanks for your reply. Unfortunately I manually updated all buggy entries for the time being so would not be easy to reproduce the bug. As soon as I have a similar issue I'll post here.

Just a clarification, regarding the update only Shows or Movies I know about the settings but by default I want to update all if on a schedule, etc. But if I manually just want to update Shows, I need to go to the settings, disable Movies, run the update, wait for it for finish and then enable Movies again. Again this was just a nice to have, nothing major.

Regarding the feature for single episode update of not showing the Update window before and after the update would love to have that and although I understand that probably this is not the regular use of the add-on, if I have 3 TV shows that just release a new episode I'll go to each show and update the last episode on each. I normally do this because updating the full show if it's too big could take a while.

I'll keep you posted as soon as I get some buggy episodes to get the logs

Thanks for your further reply and clarifications.

I see now what you mean with updating Movies or TV Shows libraries separately. It could be the case to add a pop-up window that appears when the user runs the add-on manually from the icon asking for what to update (i.e., Movies, TV Shows, or both libraries).

The above, coupled with the pop-up window appearing when updating through the context menu, makes me think about adding a "silent mode" that when is enabled no pop-up window is displayed. I know that this is mixing a bit your requests (you want the possibility to choose what to update in general but at the same time no prompt for the context menu update) but I would prefer to have a coherent approach managing the pop-up windows in the same way through all the entry points of the add-on.

Let me know your thoughts. Feedbacks from the other users are also welcome.

Ciao!

[Pluxified]

Hi there, absolutely loving the addon. It has been very helpful in optimizing my low interaction/high information user interface for kodi.

The only issue i have is the frequency of the updates. Weekly updates of the ratings are fine for a static library, but less so for a frequently updated library.

Would there be a possibility to update the ratings daily? Perhaps by running the addon from command line and scheduling it as a task? Or are there drawbacks i cannot see for running the ratings update more frequently than once a week?

Even more perfect would be if the addon could update incrementally. So that when a new file shows up in recent episodes it will only update the rating for that specific new addition to the library rather than doing a full scan of all entries in the library. That way i could have it check for new entries every few minutes and only update the new content, and the library will show a rating quickly after it is added.

It is just a minor issue, the addon is still great as is. I am just on a mission to get a squeaky clean interface and an instant user experience. Using kodi with arctic zephyr minimal interface.

[axlt2002]

Dear @bckspc and @Pluxified, regarding the ratings update for the recently added movies, TV shows, single episodes, etc., please keep in mind that the Kodi movies/TV shows information scrapers can exactly retrieve the IMDB rating, so everything is up to date from the scratch. Therefore, this add-on serves just to keep such information updated afterwards. With respect to this, I don't think there is a need to have an overall update of the ratings less than one week time frame sine the ratings basically changes anyway quite slowly, especially for the oldest items. Finally, if you really need to update the ratings according to your needs, you can always run the add-on manually. 

Have a great day!