Kodi Community Forum
mythicalLibrarian - a tool to build Movie and TV Show library from MythTV recordings - Printable Version

+- Kodi Community Forum (https://forum.kodi.tv)
+-- Forum: Support (https://forum.kodi.tv/forumdisplay.php?fid=33)
+--- Forum: Supplementary Tools for Kodi (https://forum.kodi.tv/forumdisplay.php?fid=116)
+--- Thread: mythicalLibrarian - a tool to build Movie and TV Show library from MythTV recordings (/showthread.php?tid=65644)



- outleradam - 2010-01-29

Oh wow that last post was invalid.
Ok- it will force xbmc to update.

Barney- change your recording dir to one which mythicallibrarian has permissions


- barney_1 - 2010-01-29

Actually, I figured it out. When I used cut and paste to fill in the user job in mythtv I must have included a carriage return character. I put my cursor at the end of the user job command and used the Delete key, then tried again. Worked like a charm


- outleradam - 2010-01-29

tim- Wrote:I still havent quit gotten this working. I havent had a whole lot of time to spend on it, but now I do.

I just upgraded to the newest version and deleted everything, started from scratch... Things seems to be working except everything is moving into my alternate move directory. A pastebin of the log is at

http://pastebin.com/m561c1b11


mythicalLibrarian determined that your alternate move dir does not have proper permissions for it to read and write

Code:
MOVEDIR:0- FREE:kB- ALTERNATEMOVEDIR:1- FREE:63216920kB-PRIMARYMOVIEDIRWRITABLE:0- FREE:1229462144kB- ALTERNATEMOVIEDIR:1- FREE:63216920kB-

[LIST=1]
[*]
[/LIST]

The flags tell you if you have permissions or not. Your primary movie and movedir are not writable, your alternates are. That username can't even see if you have any free space in that folder.

There was a problem prior when using extremely long path names, mythicalLibrarian could not read the proper information, however, that was corrected.


- outleradam - 2010-01-29

I will release a new stable today which should fix alot of problems. make sure you disable features which you do not use. The stable will have all settings reverted to defaults so you can enable what you would like to enable.


- watson540 - 2010-01-29

yeah..my "agrep" doesnt even have a -y option..but i do have fgrep and egrep..whatever those are.

watson540@Myth ~/Downloads $ eix agrep
-- Invalid line in /etc/portage/package.keywords(639): "="
Can't read category.

-- Invalid line in /etc/portage/package.keywords(652): "="
Can't read category.

-- Invalid line in /etc/portage/package.keywords(911): "="
Can't read category.

-- Invalid line in /etc/portage/package.keywords(993): "="
Can't read category.

[i] app-text/agrep
Available versions: 2.04
Installed versions: 2.04(04:19:11 PM 01/27/2010)
Homepage: ftp://ftp.cs.arizona.edu/agrep/README
Description: agrep is a tool for the fast searching of text allowing for errors in the search pattern.

watson540@Myth ~/Downloads $ agrep --help
agrep: illegal option --
usage: agrep [-#cdehiklnpstvwxBDGIS] [-f patternfile] pattern [files]

summary of frequently used options:
-#: find matches with at most # errors
-c: output the number of matched records
-d: define record delimiter
-h: do not output file names
-i: case-insensitive search, e.g., 'a' = 'A'
-l: output the names of files that contain a match
-n: output record prefixed by record number
-v: output those records containing no matches
-w: pattern has to match as a word, e.g., 'win' will not match 'wind'
-B: best match mode. find the closest matches to the pattern
-G: output the files that contain a match

watson540@Myth ~/Downloads $ agrep -Byn "agrep" "xmltv.xml"
best match has 1 error, there are 113 matches, output them? (y/n)n
watson540@Myth ~/Downloads $


- tim- - 2010-01-29

outleradam Wrote:mythicalLibrarian determined that your alternate move dir does not have proper permissions for it to read and write

Code:
MOVEDIR:0- FREE:kB- ALTERNATEMOVEDIR:1- FREE:63216920kB-PRIMARYMOVIEDIRWRITABLE:0- FREE:1229462144kB- ALTERNATEMOVIEDIR:1- FREE:63216920kB-

[LIST=1]
[*]
[/LIST]

The flags tell you if you have permissions or not. Your primary movie and movedir are not writable, your alternates are. That username can't even see if you have any free space in that folder.

There was a problem prior when using extremely long path names, mythicalLibrarian could not read the proper information, however, that was corrected.

Ahh.. yep. When I upgraded I also changed my folders that I output to. Forgot to change permissions. Let me see how that goes..


- outleradam - 2010-01-29

^^Sweet. Good to go.

Watson: You need version 3 from 1994 lol.
This is the version which is delivered when you grab the package for ubuntu
Code:
root@XBMCLive:~# agrep -V

This is agrep version 3.0, 1994.



- watson540 - 2010-01-29

wow ..i only had one version available in portage..ill hunt down a tarball for it


- tim- - 2010-01-29

Appears to be an issue with spaces still. I just made a change that I think will fix it.

MoveDirFreeSpace=`df -P $MoveDir|sed -n 2p|awk '{print $4}'`

I believe you needed quotes around $MoveDir. I have a show recording right now that will verify that for me =)


- watson540 - 2010-01-29

okay dunno whats up with debians agrep..but I had to do some searching..came upon a wiki entry for agrep..it showed a few branches (even freshmeats agrep page says its at version 2.04)
I used this version http://laurikari.net/tre/download/

no errors upon first run..ive yet to check the xbmc library to see if it added it.
Code:
mythtv@myth ~ $ ./mythicalLibrarian/mythicalLibrarian.sh "Judge Judy" "episode unknown 1" "/mnt/ntfs/mythtv/1006_20100127160300.mpg"
Accessing MythTV DataBase:
0
COMMERCIAL DATA START:10285 STOP:12090
COMMERCIAL DATA START:22938 STOP:27325
COMMERCIAL DATA START:36262 STOP:44715
RECSTART:2010-01-27 16:03:00 MOVIEYEAR:2010 SERIESDATE:
PROGRAMID:EP001887103887 ShowCategory:Episodic STARS:0 RATING:0
PLOT: An uninvited partygoer says another guest punched him in the face during a brawl.
TESTING FOR ZAP2IT SERIES ID MATCH:Judge Judy
DATABASE IS MAINTAINED. TIME IS:1264798294 NEXT UPDATE IS:1264838874
No direct Zap2it match found. Please update TheTvDb.com
USING FUZZY LOGIC FOR EPISODE RECOGNITION
Judge Judy
FUZZY LOGIC SHOW NAME: Judge Judy ID: 71221
DATABASE IS MAINTAINED. TIME IS:1264798294 NEXT UPDATE IS:1264838874
FUZZY Exx NUMBER:12
EPISODE:Seventh Season Premier ABSOLUTE NUMBER:12 S07E01
FILE SIZE:495666kB
MOVEDIR FREE SPACE: 24984348kB- WRITABLE:1
ALTMOVEDIR FREE SPACE: 67040796kB- WRITABLE:1
MOVIEDIR FREE SPACE: 24984348kB- WRITABLE:1
ALTMOVIEDIR FREE SPACE: 67040796kB- WRITABLE:1
PLOT: An uninvited partygoer says another guest punched him in the face during a brawl.
SET TARGET DIR AS: /mnt/extra/episodes
CREATING LINK IN LINK MODE
Code:
###################DEBUG MODE ENABLED####################
LISTING INTERNAL VARIABLES USED BY mythicalLibrarian.
INTERNET TIMEOUT:50- TVDB API KEY:6DF511BB2A64E0E9- mythicalLibrarian WORKING DIR:/home/mythtv/mythicalLibrarian-
MOVE DIR:/mnt/extra/episodes- USING SHOWNAME AS FOLDER:Enabled-
FAILSAFE MODE:Disabled- FAILSAFE DIR:/home/mythtv/FailSafe- ALTERNATE MOVE DIR:/mnt/ntfs/episodes-
USE ORIGINAL DIR:Disabled NOTIFICATIONS:Enabled DEBUG MODE:Enabled-
INPUT SHOW NAME:Judge Judy- LOCAL SHOW NAME TRANSLATION:- ShowName:Judge Judy
SENT TVDB SHOW NAME:Judge%20Judy-
RESOLVED SERIES ID:71221- RESOVED SHOW NAME:Judge Judy-
INPUT EPISODE NAME:episode unknown 1- ABSOLOUTE EPISODE NUMBER:12- RESOLVED EPISODE NAME:Seventh Season Premier-
SEASON:S07- EPISODE:E01- SYMLINK MODE:LINK- FILESIZE: 495666'kB'
CREATE AND DELETE FLAGS: ORIGINALDIR:1- FREE:67040796kB- WORKINGDIR:1 Free:2043832kB-
MOVEDIR:1- FREE:24984348kB- ALTERNATEMOVEDIR:1- FREE:67040796kB-
PRIMARYMOVIEDIRWRITABLE:1- FREE:24984348kB- ALTERNATEMOVIEDIR:1- FREE:67040796kB-
DATABASE INFORMATION
RECSTART:2010-01-27 16:03:00- MOVIE YEAR:2010- ORIGINAL SERIES DATE:-
PROGRAMID:EP001887103887- CHANNEL ID:1006- CATEGORY:Episodic-
EXTRAPOLATED DATA DETERMINED THIS RECORDING AS A:Series With Episode Data- STARS:0 RATING:0
ZAP2IT SERIES ID:225574937- MATCHED TVDB SERIES ID:-
####################END OF DEBUG LOG#####################
Symlink created /mnt/extra/episodes/Judge Judy/Judge Judy.S07E01 (Seventh Season Premier).mpg
@@@@@@@@@@@@@OPERATION COMPLETE Fri Jan 29 15:46:06 EST 2010 @@@@@@@@@@@@@@@@

still nothing showed up in xbmc library Sad ..everything else worked though..named the episode right..could see xbmc updating th e library as well


- tim- - 2010-01-29

Okay, so I think those problems are solved now on to new ones =)

I have had 2 shows that ended up in my movies folder..

1 - WordWorld - S02E20. The name was Dog Having a Party on TVDB, my EPG has it as Dogs Having a Party

2 - Marth Speaks E01E20. The name was Nurse Martha/TD Gets the Scoop on TVDB and my EPG has it as Nurse Martha; TD Gets the Scoop.

I am using MC2XML for the EPG - Would using SchedulesDirect fix all of that?


Here is a debug log. I am a bit confused on the NO DATABASE INFORMATION error.. and advice where to check? The user / pass are correct.


Code:
@@@@@@@@@@@NEW SEARCH INITIATED AT Fri Jan 29 15:00:10 CST 2010@@@@@@@@@@@@@
REMOVING ORPHAN FOLDER:/home/mythtv/Episodes/Cyberchase
%%%NO DATABASE INFORMATION. CHECK LOGIN/PASS OR FILE %%%%%
SEARCHING: www.TheTvDb.com SHOW NAME: Martha Speaks EPISODE: Nurse Martha
FILE NAME: /var/lib/mythtv/recordings/1101_20100129144000.mpg
creating home mythicalLibrarian and log file
SEARCH FOUND:Martha Speaks ID#: 100341
USING FUZZY LOGIC FOR EPISODE RECOGNITION
No direct Zap2it match found. Please update TheTvDb.com
SEARCH FOUND:Martha Speaks ID#: 100341
DEFINED ABSOLOUTE EPISODE NUMBER:
###################DEBUG MODE ENABLED####################
LISTING INTERNAL VARIABLES USED BY mythicalLibrarian.
INTERNET TIMEOUT:50- TVDB API KEY:6DF511BB2A64E0E9- mythicalLibrarian WORKING DIR:/home/mythtv/mythicalLibrarian-
MOVE DIR:/home/tim/media/Recorded Shows- USING SHOWNAME AS FOLDER:Enabled-
FAILSAFE MODE:Enabled- FAILSAFE DIR:/home/mythtv/FailSafe- ALTERNATE MOVE DIR:/home/mythtv/Episodes-
USE ORIGINAL DIR:Disabled NOTIFICATIONS:Disabled DEBUG MODE:Enabled-
INPUT SHOW NAME:Martha Speaks- LOCAL SHOW NAME TRANSLATION:- ShowName:Martha Speaks
SENT TVDB SHOW NAME:Martha%20Speaks-
RESOLVED SERIES ID:100341- RESOVED SHOW NAME:Martha Speaks-
INPUT EPISODE NAME:Nurse Martha; TD Gets the Scoop- ABSOLOUTE EPISODE NUMBER:- RESOLVED EPISODE NAME:Nurse Martha-
SEASON:- EPISODE:- SYMLINK MODE:MOVE- FILESIZE: 1744863'kB'
CREATE AND DELETE FLAGS: ORIGINALDIR:1- FREE:129813208kB- WORKINGDIR:1 Free:129813208kB-
MOVEDIR:0- FREE:1231613056kB- ALTERNATEMOVEDIR:1- FREE:129813208kB-
PRIMARYMOVIEDIRWRITABLE:0- FREE:1231613056kB- ALTERNATEMOVIEDIR:1- FREE:129813208kB-
DATABASE INFORMATION
RECSTART:2010-01-29 14:40:00- MOVIE YEAR:2008- ORIGINAL SERIES DATE:-
PROGRAMID:EP010727730023- CHANNEL ID:1101- CATEGORY:children-
EXTRAPOLATED DATA DETERMINED THIS RECORDING AS A:Series With Episode Data- STARS:0 RATING:0
ZAP2IT SERIES ID:103750211- MATCHED TVDB SERIES ID:-
####################END OF DEBUG LOG#####################
CREATING FOLDER: /home/tim/media/Recorded Movies/Martha Speaks
MOVING FILE: /var/lib/mythtv/recordings/1101_20100129144000.mpg to /home/tim/media/Recorded Movies/Martha Speaks/Martha Speaks (2008).mpg



- outleradam - 2010-01-29

tim- Wrote:Appears to be an issue with spaces still. I just made a change that I think will fix it.

MoveDirFreeSpace=`df -P $MoveDir|sed -n 2p|awk '{print $4}'`

I believe you needed quotes around $MoveDir. I have a show recording right now that will verify that for me =)

Hey! you're right. That was a problem that was supposed to be corrected before. I forgot about it during the 'rebuild'. I will take care of that tonight.

watson540 Wrote:okay dunno whats up with debians agrep..but I had to do some searching..came upon a wiki entry for agrep..it showed a few branches (even freshmeats agrep page says its at version 2.04)
I used this version http://laurikari.net/tre/download/

no errors upon first run..ive yet to check the xbmc library to see if it added it.
still nothing showed up in xbmc library Sad ..everything else worked though..named the episode right..could see xbmc updating th e library as well
You've got to add the /episodes/ as a source to XBMC, then you've got to make sure you have it set to scan recursively


tim- Wrote:Okay, so I think those problems are solved now on to new ones =)

I have had 2 shows that ended up in my movies folder..

1 - WordWorld - S02E20. The name was Dog Having a Party on TVDB, my EPG has it as Dogs Having a Party

2 - Marth Speaks E01E20. The name was Nurse Martha/TD Gets the Scoop on TVDB and my EPG has it as Nurse Martha; TD Gets the Scoop.

I am using MC2XML for the EPG


Here is a debug log. I am a bit confused on the NO DATABASE INFORMATION error.. and advice where to check? The user / pass are correct.


Code:
@@@@@@@@@@@NEW SEARCH INITIATED AT Fri Jan 29 15:00:10 CST 2010@@@@@@@@@@@@@
REMOVING ORPHAN FOLDER:/home/mythtv/Episodes/Cyberchase
%%%NO DATABASE INFORMATION. CHECK LOGIN/PASS OR FILE %%%%%
SEARCHING: www.TheTvDb.com SHOW NAME: Martha Speaks EPISODE: Nurse Martha
FILE NAME: /var/lib/mythtv/recordings/1101_20100129144000.mpg
creating home mythicalLibrarian and log file
SEARCH FOUND:Martha Speaks ID#: 100341
USING FUZZY LOGIC FOR EPISODE RECOGNITION
No direct Zap2it match found. Please update TheTvDb.com
SEARCH FOUND:Martha Speaks ID#: 100341
DEFINED ABSOLOUTE EPISODE NUMBER:
###################DEBUG MODE ENABLED####################
LISTING INTERNAL VARIABLES USED BY mythicalLibrarian.
INTERNET TIMEOUT:50- TVDB API KEY:6DF511BB2A64E0E9- mythicalLibrarian WORKING DIR:/home/mythtv/mythicalLibrarian-
MOVE DIR:/home/tim/media/Recorded Shows- USING SHOWNAME AS FOLDER:Enabled-
FAILSAFE MODE:Enabled- FAILSAFE DIR:/home/mythtv/FailSafe- ALTERNATE MOVE DIR:/home/mythtv/Episodes-
USE ORIGINAL DIR:Disabled NOTIFICATIONS:Disabled DEBUG MODE:Enabled-
INPUT SHOW NAME:Martha Speaks- LOCAL SHOW NAME TRANSLATION:- ShowName:Martha Speaks
SENT TVDB SHOW NAME:Martha%20Speaks-
RESOLVED SERIES ID:100341- RESOVED SHOW NAME:Martha Speaks-
INPUT EPISODE NAME:Nurse Martha; TD Gets the Scoop- ABSOLOUTE EPISODE NUMBER:- RESOLVED EPISODE NAME:Nurse Martha-
SEASON:- EPISODE:- SYMLINK MODE:MOVE- FILESIZE: 1744863'kB'
CREATE AND DELETE FLAGS: ORIGINALDIR:1- FREE:129813208kB- WORKINGDIR:1 Free:129813208kB-
MOVEDIR:0- FREE:1231613056kB- ALTERNATEMOVEDIR:1- FREE:129813208kB-
PRIMARYMOVIEDIRWRITABLE:0- FREE:1231613056kB- ALTERNATEMOVIEDIR:1- FREE:129813208kB-
DATABASE INFORMATION
RECSTART:2010-01-29 14:40:00- MOVIE YEAR:2008- ORIGINAL SERIES DATE:-
PROGRAMID:EP010727730023- CHANNEL ID:1101- CATEGORY:children-
EXTRAPOLATED DATA DETERMINED THIS RECORDING AS A:Series With Episode Data- STARS:0 RATING:0
ZAP2IT SERIES ID:103750211- MATCHED TVDB SERIES ID:-
####################END OF DEBUG LOG#####################
CREATING FOLDER: /home/tim/media/Recorded Movies/Martha Speaks
MOVING FILE: /var/lib/mythtv/recordings/1101_20100129144000.mpg to /home/tim/media/Recorded Movies/Martha Speaks/Martha Speaks (2008).mpg
I don't see how that happened, could have been during the initial setup troubleshooting. Let me check some things out on this one.


- watson540 - 2010-01-30

beatufil thank you..now it works great!

now..if only this stupid xbox would skip commercials


Working some of the time - okiekyle - 2010-01-30

Last one I tried, I got this:

Code:
@@@@@@@@@@@NEW SEARCH INITIATED AT Fri Jan 29 12:22:39 CST 2010@@@@@@@@@@@@@
PERFORMING MAINTENANCE ROUTINE
SEARCHING: www.TheTvDb.com SHOW NAME: The View EPISODE:
FILE NAME: /home/mythtv/Episodes/1081_20100129095800.mpg
creating home mythicalLibrarian and log file
SEARCH FOUND:The View ID#: 72104
creating home mythicalLibrarian and log file
SEARCH FOUND:The View from River Cottage ID#: 81975
creating home mythicalLibrarian and log file
SEARCH FOUND:The View from Daniel Pike ID#: 75012
SEARCH FOUND:The View ID#: 72104
DEFINED ABSOLOUTE EPISODE NUMBER:
###################DEBUG MODE ENABLED####################
LISTING INTERNAL VARIABLES USED BY mythicalLibrarian.
INTERNET TIMEOUT:120- TVDB API KEY:6DF511BB2A64E0E9- mythicalLibrarian WORKING DIR:/home/mythtv/mythicalLibrarian-
MOVE DIR:/home/mythtv/Videos/TVShows- USING SHOWNAME AS FOLDER:Enabled-
FAILSAFE MODE:Enabled- FAILSAFE DIR:/home/mythtv/FailSafe- ALTERNATE MOVE DIR:/home/mythtv/Episodes-
USE ORIGINAL DIR:Disabled NOTIFICATIONS:Disabled DEBUG MODE:Enabled-
INPUT SHOW NAME:The View- LOCAL SHOW NAME TRANSLATION:- ShowName:The View
SENT TVDB SHOW NAME:The%20View-
RESOLVED SERIES ID:72104- RESOVED SHOW NAME:The View-
INPUT EPISODE NAME:- ABSOLOUTE EPISODE NUMBER:- RESOLVED EPISODE NAME:-
SEASON:- EPISODE:- SYMLINK MODE:MOVE- FILESIZE: 5297080'kB'
CREATE AND DELETE FLAGS: ORIGINALDIR:1- FREE:324428636kB- WORKINGDIR:1 Free:324428636kB-
MOVEDIR:0- FREE:171469480kB- ALTERNATEMOVEDIR:1- FREE:324428636kB-
PRIMARYMOVIEDIRWRITABLE:1- FREE:324428636kB- ALTERNATEMOVIEDIR:1- FREE:324428636kB-
DATABASE INFORMATION
RECSTART:2010-01-29 09:58:00- MOVIE YEAR:- ORIGINAL SERIES DATE:2010-01-29-
PROGRAMID:EP002253953154- CHANNEL ID:1081- CATEGORY:Talk-
EXTRAPOLATED DATA DETERMINED THIS RECORDING AS A:Series With Episode Data- STARS:0 RATING:0
ZAP2IT SERIES ID:EP00225395- MATCHED TVDB SERIES ID:-
####################END OF DEBUG LOG#####################
%%%%%%%%%%www.TheTvDB.com information is incomplete The View,
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%Please consider helping out and adding to thetvdb%%%%%%%%%%%%
%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%%
%%%%%%%%%%%%%%OPERATION FAILED Fri Jan 29 12:22:42 CST 2010 %%%%%%%%%%%%%%%%%

Will I always have this problem when there's no episode name in the guide?
Wondering if there could be an option to "Move the file anyway" and tack on the show date-time so it's more likely to be a unique name.Huh


- outleradam - 2010-01-30

tim- Wrote:Appears to be an issue with spaces still. I just made a change that I think will fix it.

MoveDirFreeSpace=`df -P $MoveDir|sed -n 2p|awk '{print $4}'`

I believe you needed quotes around $MoveDir. I have a show recording right now that will verify that for me =)
fixed

Using schedulesDirect would stop errors. However, I want to add processing for MC2XML.

I will need you to run a movie, a episode, and a generic show like the news or sports through mythicalLibrarian in this state so that I can see if mythicalLibrarian is getting all the information it needs.

Then, I need you to go into mysql. Drop to the terminal and type the following
Code:
adam@adam-desktop:~$ mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 151
Server version: 5.1.37-1ubuntu5 (Ubuntu)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql> use mythconverg
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
At this point you will want to make your terminal very very very wide. just keep making it wider and moving it to the left so that the data does not get cut off.

Then you will need to substitute the basename for those three recordings for the basename in this example:
Code:
mysql> mysql> select * from recorded where basename like "5008_20100125090000.mpg";
+--------+---------------------+---------------------+---------------+--------------------+------------------------------------------------------------------------------------------------------+----------+--------------+----------+---------+---------+------------+-------------+----------+----------+------------+----------------+---------------------+------------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+-------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+
| chanid | starttime           | endtime             | title         | subtitle           | description                                                                                          | category | hostname     | bookmark | editing | cutlist | autoexpire | commflagged | recgroup | recordid | seriesid   | programid      | lastmodified        | filesize   | stars | previouslyshown | originalairdate | preserve | findid | deletepending | transcoder | timestretch | recpriority | basename                | progstart           | progend             | playgroup | profile | duplicate | transcoded | watched | storagegroup |
+--------+---------------------+---------------------+---------------+--------------------+------------------------------------------------------------------------------------------------------+----------+--------------+----------+---------+---------+------------+-------------+----------+----------+------------+----------------+---------------------+------------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+-------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+
|   5008 | 2010-01-25 09:00:00 | 2010-01-25 10:00:00 | Sesame Street | The Counting Booth | Elmo and Abby stand in for the Count at the Counting Booth and learn to count in pairs and by fives. | Children | adam-desktop |        0 |       0 |       0 |          1 |           1 | Default  |       18 | EP00003786 | EP000037861952 | 2010-01-25 10:00:30 | 1453799112 |     0 |               0 | 2010-01-25      |        0 |      0 |             0 |          0 |           1 |           3 | 5008_20100125090000.mpg | 2010-01-25 09:00:00 | 2010-01-25 10:00:00 | Default   | Default |         1 |          0 |       0 | Default      |
+--------+---------------------+---------------------+---------------+--------------------+------------------------------------------------------------------------------------------------------+----------+--------------+----------+---------+---------+------------+-------------+----------+----------+------------+----------------+---------------------+------------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+-------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+
1 row in set (0.01 sec)

mysql>
the basename is only the name of the file, without directory and you can find it in the 4th line of each mythicalLibrarian log entry.

If you can find me 3 of those, then I should be able to write some sort of processing to correctly identify episodes and movies.

Also, tim-, let's move this to the feature request since your guide data is unsupported and we're basically creating a whole new processing method and maybe even adding database requests. http://forum.xbmc.org/showthread.php?tid=65769