[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!