tvdb matching throws error when trying to match the daily show episodes

All your suggestions, requests and ideas for future development
Post Reply
slugfest
Posts: 7
Joined: 24 Mar 2020, 01:42

tvdb matching throws error when trying to match the daily show episodes

Post by slugfest »

example of what happens: https://streamable.com/altys , https://i.imgur.com/Yob3DXH.jpg

The episode numbers are in this format:

Code: Select all

the.daily.show.02.01.07.dsr.xvid.kyr.proper.avi
This is the file tree structure:

Code: Select all

├───2007-01
│       the.daily.show.01.08.07.dsr.xvid.crimson.avi
│       the.daily.show.01.09.07.dsr.xvid.crimson.avi
│       the.daily.show.01.10.07.dsr.xvid.crimson.avi
│       the.daily.show.01.11.07.dsr.xvid.loki.avi
│       the.daily.show.01.15.07.dsr.xvid.crimson.avi
│       the.daily.show.01.16.07.dsr.xvid.crimson.avi
│       the.daily.show.01.17.07.tvrip.xvid.sos.avi
│       the.daily.show.01.18.07.tvrip.xvid.sos.avi
│       the.daily.show.01.22.07.dsr.xvid.loki.avi
│       the.daily.show.01.23.07.tvrip.xvid.sos.avi
│       the.daily.show.01.24.07.dsr.xvid.saints.avi
│       the.daily.show.01.25.07.dsr.xvid.dimension.repack.avi
│       the.daily.show.01.29.07.tvrip.xvid.sos.avi
│       the.daily.show.01.30.07.dsr.xvid.crimson.avi
│       the.daily.show.01.31.07.dsr.xvid.2sd.avi
│
├───2007-02
│       the.daily.show.02.01.07.dsr.xvid.kyr.proper.avi
│       the.daily.show.02.05.07.dsr.xvid.crimson.avi
│       the.daily.show.02.06.07.dsr.xvid.crimson.avi
│       the.daily.show.02.07.07.dsr.xvid.2sd.avi
│       the.daily.show.02.08.07.dsr.xvid.crimson.avi
│       the.daily.show.02.12.07.dsr.xvid.2sd.avi
│       the.daily.show.02.13.07.dsr.xvid.2sd.avi
│       the.daily.show.02.14.07.tvrip.xvid.sos.proper.avi
│       the.daily.show.02.15.07.dsr.xvid.sys.avi
│       the.daily.show.02.26.07.dsr.xvid.fpn.avi
│       the.daily.show.02.27.07.dsr.xvid.2sd.avi
│       the.daily.show.02.28.07.dsr.xvid.2sd.avi
│
├───2007-03
│       the.daily.show.03.01.07.dsr.xvid.fpn.avi
│       the.daily.show.03.05.07.dsr.xvid.saints.avi
│       the.daily.show.03.06.07.dsr.xvid.2sd.avi
│       the.daily.show.03.07.07.dsr.xvid.crimson.avi
│       the.daily.show.03.08.07.dsr.xvid.2sd.avi
│       the.daily.show.03.12.07.dsr.xvid.saints.avi
│       the.daily.show.03.13.07.dsr.xvid.2sd.avi
│       the.daily.show.03.14.07.dsr.xvid.2sd.avi
│       the.daily.show.03.15.07.dsr.xvid.crimson.avi
│       the.daily.show.03.19.07.dsr.xvid.2sd.avi
│       the.daily.show.03.20.07.dsr.xvid.kyr.avi
│       the.daily.show.03.21.07.dsr.xvid.kyr.avi
│       the.daily.show.03.22.07.dsr.xvid.2sd.avi
│       the.daily.show.03.26.07.dsr.xvid.2sd.avi
│       the.daily.show.03.27.07.dsr.xvid.2sd.avi
│       the.daily.show.03.28.07.dsr.xvid.2sd.avi
│       the.daily.show.03.29.07.dsr.xvid.saints.avi
│
├───2007-04
│       the.daily.show.04.09.07.dsr.xvid.saints.avi
│       the.daily.show.04.10.07.dsr.xvid.saints.proper.avi
│       the.daily.show.04.11.07.dsr.xvid.crimson.avi
│       the.daily.show.04.12.07.dsr.xvid.saints.avi
│       the.daily.show.04.16.07.dsr.xvid.crimson.avi
│       the.daily.show.04.17.07.dsr.xvid.crimson.avi
│       the.daily.show.04.18.07.dsr.xvid.crimson.avi
│       the.daily.show.04.19.07.dsr.xvid.crimson.avi
│       the.daily.show.04.23.07.dsr.xvid.saints.avi
│       the.daily.show.04.24.07.pdtv.xvid.2hd.avi
│       the.daily.show.04.25.07.dsr.xvid.crimson.avi
│       the.daily.show.04.26.07.dsr.xvid.dimension.avi
│       the.daily.show.04.30.07.dsr.xvid.crimson.avi
│
├───2007-05
│       the.daily.show.05.01.07.dsr.xvid.crimson.avi
│       the.daily.show.05.02.07.dsr.xvid.crimson.avi
│       the.daily.show.05.03.07.dsr.xvid.saints.avi
│       the.daily.show.05.07.07.dsr.xvid.2sd.avi
│       the.daily.show.05.08.07.dsr.xvid.saints.avi
│       the.daily.show.05.09.07.dsr.xvid.essential.avi
│       the.daily.show.05.10.07.dsr.xvid.saints.avi
│       the.daily.show.05.14.07.dsr.xvid.stfu.avi
│       the.daily.show.05.15.07.tvrip.xvid.sos.avi
│       the.daily.show.05.16.07.dsr.xvid.stfu.avi
│       the.daily.show.05.17.07.dsr.xvid.stfu.avi
│       the.daily.show.05.21.07.dsr.xvid.dimension.avi
│       the.daily.show.05.22.07.pdtv.xvid.2hd.avi
│       the.daily.show.05.23.07.pdtv.xvid.2hd.avi
│       the.daily.show.05.24.07.pdtv.xvid.2hd.avi
│
├───2007-06
│       the.daily.show.06.04.07.dsr.xvid.sys.avi
│       the.daily.show.06.05.07.pdtv.xvid.2hd.avi
│       the.daily.show.06.06.07.dsr.xvid.crimson.avi
│       the.daily.show.06.07.07.dsr.xvid.crimson.avi
│       the.daily.show.06.11.07.dsr.xvid.dimension.avi
│       the.daily.show.06.12.07.dsr.xvid.crimson.avi
│       the.daily.show.06.13.07.dsr.xvid.sys.avi
│       the.daily.show.06.14.07.dsr.xvid.crimson.avi
│       the.daily.show.06.18.07.dsr.xvid.stfu.avi
│       the.daily.show.06.19.07.dsr.xvid.crimson.avi
│       the.daily.show.06.20.07.dsr.xvid.sys.avi
│       the.daily.show.06.21.07.dsr.xvid.crimson.avi
│       the.daily.show.06.25.07.dsr.xvid.sys.avi
│       the.daily.show.06.26.07.dsr.xvid.stfu.avi
│       the.daily.show.06.27.07.dsr.xvid.sys.avi
│       the.daily.show.06.28.07.dsr.xvid.stfu.avi
│
├───2007-07
│       the.daily.show.07.16.07.dsr.xvid.sys.avi
│       the.daily.show.07.17.07.dsr.xvid.stfu.avi
│       the.daily.show.07.18.07.dsr.xvid.crimson.avi
│       the.daily.show.07.19.07.dsr.xvid.stfu.avi
│       the.daily.show.07.23.07.dsr.xvid.sys.avi
│       the.daily.show.07.24.07.dsr.xvid.sys.proper.avi
│       the.daily.show.07.25.07.dsr.xvid.stfu.avi
│       the.daily.show.07.26.07.dsr.xvid.stfu.avi
│       the.daily.show.07.30.07.dsr.xvid.crimson.avi
│       the.daily.show.07.31.07.dsr.xvid.crimson.avi
│
├───2007-08
│       the.daily.show.08.01.07.dsr.xvid.crimson.avi
│       the.daily.show.08.02.07.dsr.xvid.sys.avi
│       the.daily.show.08.07.07.dsr.xvid.crimson.avi
│       the.daily.show.08.08.07.dsr.xvid.crimson.avi
│       the.daily.show.08.09.07.dsr.xvid.crimson.avi
│       the.daily.show.08.13.07.dsr.xvid.sys.avi
│       the.daily.show.08.14.07.dsr.xvid.crimson.avi
│       the.daily.show.08.15.07.dsr.xvid.w4f.avi
│       the.daily.show.08.16.07.dsr.xvid.sys.avi
│       the.daily.show.08.20.07.dsr.xvid.iht.avi
│       the.daily.show.08.21.07.dsr.xvid.crimson.avi
│       the.daily.show.08.22.07.dsr.xvid.crimson.avi
│       the.daily.show.08.23.07.dsr.xvid.sys.avi
│
├───2007-09
│       the.daily.show.09.10.07.dsr.xvid.sys.avi
│       the.daily.show.09.11.07.dsr.xvid.crimson.avi
│       the.daily.show.09.12.07.dsr.xvid.crimson.avi
│       the.daily.show.09.13.07.dsr.xvid.crimson.avi
│       the.daily.show.09.18.07.dsr.xvid.sys.avi
│       the.daily.show.09.19.07.dsr.xvid.iht.avi
│       the.daily.show.09.20.07.dsr.xvid.crimson.avi
│       the.daily.show.09.24.07.dsr.xvid.iht.avi
│       the.daily.show.09.25.07.dsr.xvid.crimson.avi
│       the.daily.show.09.26.07.dsr.xvid.iht.avi
│       the.daily.show.09.27.07.dsr.xvid.sys.avi
│
├───2007-10
│       the.daily.show.10.01.07.dsr.xvid.crimson.avi
│       the.daily.show.10.02.07.dsr.xvid.crimson.avi
│       the.daily.show.10.03.07.dsr.xvid.stfu.avi
│       the.daily.show.10.04.07.dsr.xvid.stfu.avi
│       the.daily.show.10.08.07.dsr.xvid.stfu.avi
│       the.daily.show.10.09.07.dsr.xvid.stfu.avi
│       the.daily.show.10.10.07.dsr.xvid.sys.avi
│       the.daily.show.10.11.07.dsr.xvid.crimson.avi
│       the.daily.show.10.15.07.dsr.xvid.0tv.avi
│       the.daily.show.10.16.07.dsr.xvid.crimson.avi
│       the.daily.show.10.17.07.dsr.xvid.crimson.avi
│       the.daily.show.10.18.07.dsr.xvid.crimson.avi
│       the.daily.show.10.29.07.dsr.xvid.sys.avi
│       the.daily.show.10.30.07.dsr.xvid.sys.avi
│       the.daily.show.10.31.07.dsr.xvid.dimension.avi
│
└───2007-11
        the.daily.show.11.01.07.dsr.xvid.crimson.avi
sysinfo:

Code: Select all

FileBot 4.9.0 (r7234)
JNA Native: 6.1.0
MediaInfo: 19.09
7-Zip-JBinding: 9.20
Chromaprint: 1.4.3
Extended Attributes: OK
Unicode Filesystem: OK
Script Bundle: 2020-03-16 (r625)
Groovy: 3.0.2
JRE: OpenJDK Runtime Environment 13.0.2
JVM: 64-bit OpenJDK 64-Bit Server VM
CPU/MEM: 12 Core / 8 GB Max Memory / 94 MB Used Memory
OS: Windows 10 (amd64)
HW: CYGWIN_NT-10.0 %PCName% 3.0.7(0.338/5/3) 2019-04-30 18:08 x86_64 Cygwin
STORAGE: NTFS [(C:)] @ 42 GB | NTFS [Docs and Games] @ 2.9 TB | NTFS [mothafuckin] @ 1.1 TB | NTFS [fireworks] @ 2.3 TB | NTFS [lawd] @ 1.0 TB | NTFS [reekis] @ 7 TB | NTFS [REEKIS] @ 7 TB | NTFS [DrivePool] @ 5 TB | NTFS [DrivePool] @ 20 TB
DATA: C:\Users\%User%\AppData\Roaming\FileBot
Package: MSI
License: FileBot License P8078393 (Valid-Until: 2020-06-03)
Done ?(?????)?
log:

Code: Select all

Mar 23, 2020 9:39:10 PM net.filebot.ui.rename.RenamePanel$AutoCompleteAction$1 done
WARNING: LookupException: Invalid Lookup: {data={id=183951, seriesId=, seriesName=null, aliases=[Ljava.lang.Object;@70908535, season=1, poster=posters/183951-1.jpg, banner=, fanart=, status=Ended, firstAired=2007-07-21, network=Arte, networkId=387, runtime=45, language=en, genre=[Ljava.lang.Object;@51ed4b4, overview= , lastUpdated=1573797600, airsDayOfWeek=, airsTime=, rating=null, imdbId=tt1070259, zap2itId=, added=2010-08-21 08:15:57, addedBy=16731, siteRating=7, siteRatingCount=28, slug=183951}} [183951]
java.util.concurrent.ExecutionException: java.util.concurrent.ExecutionException: java.util.concurrent.ExecutionException: net.filebot.web.LookupException: Invalid Lookup: {data={id=183951, seriesId=, seriesName=null, aliases=[Ljava.lang.Object;@70908535, season=1, poster=posters/183951-1.jpg, banner=, fanart=, status=Ended, firstAired=2007-07-21, network=Arte, networkId=387, runtime=45, language=en, genre=[Ljava.lang.Object;@51ed4b4, overview= , lastUpdated=1573797600, airsDayOfWeek=, airsTime=, rating=null, imdbId=tt1070259, zap2itId=, added=2010-08-21 08:15:57, addedBy=16731, siteRating=7, siteRatingCount=28, slug=183951}} [183951]
	at net.filebot.ui.rename.RenamePanel$AutoCompleteAction$1.done(Unknown Source)
	at net.filebot.ui.rename.EpisodeListMatcher.lambda$selectSearchResult$8(Unknown Source)
	at net.filebot.util.ui.SwingUI.lambda$showInputDialog$2(Unknown Source)
Caused by: java.util.concurrent.ExecutionException: java.util.concurrent.ExecutionException: net.filebot.web.LookupException: Invalid Lookup: {data={id=183951, seriesId=, seriesName=null, aliases=[Ljava.lang.Object;@70908535, season=1, poster=posters/183951-1.jpg, banner=, fanart=, status=Ended, firstAired=2007-07-21, network=Arte, networkId=387, runtime=45, language=en, genre=[Ljava.lang.Object;@51ed4b4, overview= , lastUpdated=1573797600, airsDayOfWeek=, airsTime=, rating=null, imdbId=tt1070259, zap2itId=, added=2010-08-21 08:15:57, addedBy=16731, siteRating=7, siteRatingCount=28, slug=183951}} [183951]
	at net.filebot.ui.rename.EpisodeListMatcher.match(Unknown Source)
	at net.filebot.ui.rename.RenamePanel$AutoCompleteAction$1.doInBackground(Unknown Source)
	at net.filebot.ui.rename.RenamePanel$AutoCompleteAction$1.doInBackground(Unknown Source)
Caused by: java.util.concurrent.ExecutionException: net.filebot.web.LookupException: Invalid Lookup: {data={id=183951, seriesId=, seriesName=null, aliases=[Ljava.lang.Object;@70908535, season=1, poster=posters/183951-1.jpg, banner=, fanart=, status=Ended, firstAired=2007-07-21, network=Arte, networkId=387, runtime=45, language=en, genre=[Ljava.lang.Object;@51ed4b4, overview= , lastUpdated=1573797600, airsDayOfWeek=, airsTime=, rating=null, imdbId=tt1070259, zap2itId=, added=2010-08-21 08:15:57, addedBy=16731, siteRating=7, siteRatingCount=28, slug=183951}} [183951]
	at net.filebot.ui.rename.EpisodeListMatcher.fetchEpisodeSet(Unknown Source)
	at net.filebot.ui.rename.EpisodeListMatcher.matchEpisodeSet(Unknown Source)
	at net.filebot.ui.rename.EpisodeListMatcher.lambda$match$3(Unknown Source)
Caused by: net.filebot.web.LookupException: Invalid Lookup: {data={id=183951, seriesId=, seriesName=null, aliases=[Ljava.lang.Object;@70908535, season=1, poster=posters/183951-1.jpg, banner=, fanart=, status=Ended, firstAired=2007-07-21, network=Arte, networkId=387, runtime=45, language=en, genre=[Ljava.lang.Object;@51ed4b4, overview= , lastUpdated=1573797600, airsDayOfWeek=, airsTime=, rating=null, imdbId=tt1070259, zap2itId=, added=2010-08-21 08:15:57, addedBy=16731, siteRating=7, siteRatingCount=28, slug=183951}} [183951]
	at net.filebot.web.TheTVDBClient.getSeriesInfo(Unknown Source)
	at net.filebot.web.TheTVDBClient.fetchSeriesData(Unknown Source)
	at net.filebot.web.AbstractEpisodeListProvider.lambda$getSeriesData$1(Unknown Source)
	at net.filebot.Cache.computeIf(Unknown Source)
	at net.filebot.Cache$TypedCache.computeIf(Unknown Source)
	at net.filebot.Cache.computeIfAbsent(Unknown Source)
	at net.filebot.Cache$TypedCache.computeIfAbsent(Unknown Source)
	at net.filebot.web.AbstractEpisodeListProvider.getSeriesData(Unknown Source)
	at net.filebot.web.AbstractEpisodeListProvider.getEpisodeList(Unknown Source)
	at net.filebot.ui.rename.EpisodeListMatcher.lambda$fetchEpisodeSet$6(Unknown Source)
User avatar
rednoah
The Source
Posts: 22923
Joined: 16 Nov 2011, 08:59
Location: Taipei
Contact:

Re: tvdb matching throws error when trying to match the daily show episodes

Post by rednoah »

1.
Please provide the complete file path. I can't seem to reproduce the issue with just the file name.


EDIT: Possibly fixed with FileBot r7256 based on stack trace information.



2.
It works for me, though it does get the match wrong:

Code: Select all

$ filebot -rename the.daily.show.02.01.07.dsr.xvid.kyr.proper.avi --db TheTVDB -non-strict --action TEST
[TEST] from [the.daily.show.02.01.07.dsr.xvid.kyr.proper.avi] to [The Daily Show - 2x01 - David Faustino.avi]
:arrow: You might need to batch pre-rename files to make the date pattern DD-MM-YYYY: viewtopic.php?t=2072

:idea: Since your files are already in order, you may want to consider using Manual Matching. See Getting Started, Page 2 for details.
:idea: Please read the FAQ and How to Request Help.
slugfest
Posts: 7
Joined: 24 Mar 2020, 01:42

Re: tvdb matching throws error when trying to match the daily show episodes

Post by slugfest »

1. Here is the path:

Code: Select all

Z:\downloads\complete\The.Daily.Show.2007.PDTV.XviD-BTN\
under which are all the folders and files I listed in the file tree in my first post.

2. Unfortunately it wouldn't be a good idea for me to rename the files in my download folder, since that would prevent the files from being seeded. My intent was to use the keeplink function
and manual matching just wouldn't be very efficient, since I have around 600 episodes to process, and to make it worse the filenames don't include the episode title for me to check if my manual matching is correct
slugfest
Posts: 7
Joined: 24 Mar 2020, 01:42

Re: tvdb matching throws error when trying to match the daily show episodes

Post by slugfest »

This is all meant to be picked up by plex btw
User avatar
rednoah
The Source
Posts: 22923
Joined: 16 Nov 2011, 08:59
Location: Taipei
Contact:

Re: tvdb matching throws error when trying to match the daily show episodes

Post by rednoah »

slugfest wrote: 24 Mar 2020, 06:01 manual matching just wouldn't be very efficient, since I have around 600 episodes to process, and to make it worse the filenames don't include the episode title for me to check if my manual matching is correct
Since your files are already in order (presumably) you just need to copy in the episode list (which presumably also already matches the order of your files). You just need to start copying the episode list starting the your first file, and then the rest will align naturally.


:idea: Interval Selection via SHIFT+CLICK and Copy & Paste via CTRL+C / CTRL+V are your friends here, when copying & pasting selected items from Episodes panel into New Names.


If you're lucky, then everything will align perfectly without you having to do anything. Since your files are badly named, you definitely want to double-check all the matches anyway though.
:idea: Please read the FAQ and How to Request Help.
slugfest
Posts: 7
Joined: 24 Mar 2020, 01:42

Re: tvdb matching throws error when trying to match the daily show episodes

Post by slugfest »

So even without filebot giving me errors, it's not possible to automatically match based on air dates? thetvdb doesn't provide that info via their api?
User avatar
rednoah
The Source
Posts: 22923
Joined: 16 Nov 2011, 08:59
Location: Taipei
Contact:

Re: tvdb matching throws error when trying to match the daily show episodes

Post by rednoah »

slugfest wrote: 24 Mar 2020, 08:17 So even without filebot giving me errors, it's not possible to automatically match based on air dates? thetvdb doesn't provide that info via their api?
FileBot does use the airdate for matching, but the MM.DD.YY pattern in particular is tricky, because MM and DD is the wrong way around in your case.

Here's some of the supported date patterns from my test data:

Code: Select all

2010-10-24
2009/6/1
1.1.2010
01/06/2010
2015.October.05
2015.Oct.6
25 July 2014
8 Sep 2015
20140408
:idea: Please read the FAQ and How to Request Help.
slugfest
Posts: 7
Joined: 24 Mar 2020, 01:42

Re: tvdb matching throws error when trying to match the daily show episodes

Post by slugfest »

I see. I'll have to mess around with changing the date format in the filename to something appropriate, then change them back to their original name after keeplinking the episodes with filebot.

Thank you for the help
User avatar
rednoah
The Source
Posts: 22923
Joined: 16 Nov 2011, 08:59
Location: Taipei
Contact:

Re: tvdb matching throws error when trying to match the daily show episodes

Post by rednoah »

Well, since you're using the GUI, I'd stick to Manual Matching which is near-zero effort in your case:


Image


Image



Conceptually, that's the same as linear rename via -list -rename using --filter for episode interval selection:

Code: Select all

filebot -list --db TheTVDB --q "The Daily Show" --filter "airdate >= /2007-01-08/" -rename -r . --format "{plex.name}" --action TEST --log INFO
[2020-03-25 02:20:58.850] [TEST] from [the.daily.show.01.08.07.dsr.xvid.crimson.avi] to [The Daily Show - S12E01 - Louis C.K.avi]
[2020-03-25 02:20:58.851] [TEST] from [the.daily.show.01.09.07.dsr.xvid.crimson.avi] to [The Daily Show - S12E02 - Harry Frankfurt.avi]
:idea: Please read the FAQ and How to Request Help.
slugfest
Posts: 7
Joined: 24 Mar 2020, 01:42

Re: tvdb matching throws error when trying to match the daily show episodes

Post by slugfest »

Yup, I considered that, and it would be near-zero effort given that my files are already alphabetically sorted properly, but I'm pretty sure i have plenty of missing episodes so I would have to manually untick those matches from the episode list
User avatar
rednoah
The Source
Posts: 22923
Joined: 16 Nov 2011, 08:59
Location: Taipei
Contact:

Re: tvdb matching throws error when trying to match the daily show episodes

Post by rednoah »

slugfest wrote: 24 Mar 2020, 20:27 but I'm pretty sure i have plenty of missing episodes
Yep, that puts a spanner in the works there. I'm out of ideas.
:idea: Please read the FAQ and How to Request Help.
slugfest
Posts: 7
Joined: 24 Mar 2020, 01:42

Re: tvdb matching throws error when trying to match the daily show episodes

Post by slugfest »

No worries, I appreciate the attention you've given me, so thank you.
kim
Power User
Posts: 1251
Joined: 15 May 2014, 16:17

Re: tvdb matching throws error when trying to match the daily show episodes

Post by kim »

why not prename files in F2 mode ?

Code: Select all

{'the.daily.show.02.01.07.dsr.xvid.kyr.proper.avi'.replaceAll(/(.*)(\d{2}).(\d{2}).(\d{2})(.*)/), '$1$3.$2.20$4$5'}

Code: Select all

{fn.replaceAll(/(.*)(\d{2}).(\d{2}).(\d{2})(.*)/), '$1$3.$2.20$4$5'}
output:
the.daily.show.01.02.2007.dsr.xvid.kyr.proper
Post Reply