Detect Episode Intros

[lifujie 1]

Hello, may I ask where the data for the beginning and ending of the movie generated using the "Detect Episode Intros" function in Emby is saved in which field

[Luke 40072]

Hi, this is in the Emby Server database.

[lifujie 1]

4 minutes ago, Luke said:

您好，这是 Emby 服务器数据库中的。

Which specific database is it in? Is it "library. db"? If possible, could you please let me know which specific database and table it is? Thank you.
Because it has already been generated before, I would like to directly replace it in the new EMBY, which takes too much time to generate. Thank you

[Luke 40072]

Library.db chapters table

[sydlexius 268]

If your goal is to backup and restore intros, have you considered looking at this plugin:

 

 

[kikinjo 197]

Think that that there should be an option to save intros files in media folders also, emby gets moved , reinstalled and other things, option to save detected intros should be possible to save in meda folder with tv season, that way it always there if needed again.

[lifujie 1]

3 hours ago, sydlexius said:

If your goal is to backup and restore intros, have you considered looking at this plugin:

 

OK，thank

 

[rbjtech 4996]

I'd love to see support for proper MKV chapters - either by name (in it's simplest form) or by more advanced features such as Editions.  That way detected Intro's (and credits etc) can be written back to the actual media source (MKV).   If done properly with MKV Chapter Edition branching, then the any player that supports branching will automatically skip the intro without needing any 'support' of the bespoke emby intro markers...

All future imports or rebuilds will then simply pick up the intro's as part of the normal metadata.

Edited May 9, 2024 by rbjtech

[crusher11 976]

5 hours ago, rbjtech said:

I'd love to see support for proper MKV chapters - either by name (in it's simplest form) or by more advanced features such as Editions.  That way detected Intro's (and credits etc) can be written back to the actual media source (MKV).   If done properly with MKV Chapter Edition branching, then the any player that supports branching will automatically skip the intro without needing any 'support' of the bespoke emby intro markers...

All future imports or rebuilds will then simply pick up the intro's as part of the normal metadata.

Wouldn't that expose them on the UI, though? The whole reason I went from the plugin to the core was to get rid of the UI clutter they were generating. Well, that and it shuffling around genuine chapter markers into the wrong spot.

Very keen on that plugin version that just adds the hidden markers and doesn't mess with the embedded chapters at all.

[rbjtech 4996]

So I've gone the opposite route - and am using the mkv as the source.   Just written it in powershell today actually to write back the emby chapter points into the MKV - but it looks as if ffmpeg ignores hidden MKV chapters - which breaks the idea of having the 'intro markers' in the MKV for the reasons you give.

I highly doubt emby will want to provide any support for chapters being read as special markers by name - so I'll still trying to work around it.  

I've finally moved away from the Plugin - and I'm now using the Core Intro Skip - it was just too much hassle to keep the plugin going.

The righful place for all these markers is in the source file - but it's prooving a challenge making it work for every scenerio ...

[rbjtech 4996]

On 09/05/2024 at 10:38, rbjtech said:

I'd love to see support for proper MKV chapters - either by name (in it's simplest form) or by more advanced features such as Editions.  That way detected Intro's (and credits etc) can be written back to the actual media source (MKV).   If done properly with MKV Chapter Edition branching, then the any player that supports branching will automatically skip the intro without needing any 'support' of the bespoke emby intro markers...

All future imports or rebuilds will then simply pick up the intro's as part of the normal metadata.

.. so I've hit a bit of a roadblock on this.

I wrote a powershell script to grab the emby chapter info, write the Chapter XML and then use mkvpropedit to import the XML chapter file - all works perfectly - BUT .. 

While MKV fully supports 'marker/chapter types' (see below) - ffmpeg/ffprobe does not appear to    making the entire process of writing them to the MKV a bit redundant as there is no way to extract them again (in emby at least).   mkvinfo sees them without any issues.

The key to this was the use of the official MKV Chapter element 'ChapterSkipType'

ChapterSkipType

0 - No Skipping,
1 - Opening Credits,
2 - End Credits,
3 - Recap,
4 - Next Preview,
5 - Preview,
6 - Advertisement

This is not a well known, so emby chapter info being written to the mkv would be needed in most cases - but once done, then you have a totally portable MKV file containing all the marker data.  There is also a hide element.

@LukeWould emby be interested in adding this functionality into ffmpeg or an extension ?  If not, then I may as well abandon this idea as you would need a plugin to extract the intro data from the mkv in the event of needing a restore.  

Thanks,

  1 <?xml version="1.0" encoding="ISO-8859-1"?>
    2 
    3 <!DOCTYPE Chapters SYSTEM "matroskachapters.dtd">
    4 
    5 <!-- A simple example. The movie in question contains four parts: -->
    6 <!-- The intro starting at the beginning, the first act, the second -->
    7 <!-- act, and the credits. -->
    8 
    9 <!-- Note that the end timestamps are optional. -->
   10 
   11 <!-- The timestamps use the normal format of HH:MM:SS.mmm with -->
   12 <!-- HH beging the hour, MM the minute, SS the second and -->
   13 <!-- mmm the milliseconds. -->
   14 
   15 <Chapters>
   16   <EditionEntry>
   17     <EditionDisplay>
   18       <EditionString>Example movie</EditionString>
   19       <EditionLanguageIETF>en</EditionLanguageIETF>
   20     </EditionDisplay>
   21     <ChapterAtom>
   22       <ChapterTimeStart>00:00:00.000</ChapterTimeStart>
   23       <ChapterDisplay>
   24         <ChapterString>Intro</ChapterString>
   25         <ChapterLanguage>eng</ChapterLanguage>
   26       </ChapterDisplay>
   27       <ChapterSkipType>1</ChapterSkipType>
   28     </ChapterAtom>
   29     <ChapterAtom>
   30       <ChapterTimeStart>00:01:00.000</ChapterTimeStart>
   31       <ChapterDisplay>
   32         <ChapterString>Act 1</ChapterString>
   33         <ChapLanguageIETF>en</ChapLanguageIETF>
   34       </ChapterDisplay>
   35       <ChapterSkipType>0</ChapterSkipType>
   36     </ChapterAtom>
   37     <ChapterAtom>
   38       <ChapterTimeStart>00:05:30.000</ChapterTimeStart>
   39       <ChapterDisplay>
   40         <ChapterString>Act 2</ChapterString>
   41         <ChapLanguageIETF>en</ChapLanguageIETF>
   42       </ChapterDisplay>
   43       <ChapterSkipType>0</ChapterSkipType>
   44     </ChapterAtom>
   45     <ChapterAtom>
   46       <ChapterTimeStart>00:12:20.000</ChapterTimeStart>
   47       <ChapterTimeEnd>00:12:55.000</ChapterTimeEnd>
   48       <ChapterDisplay>
   49         <ChapterString>Credits</ChapterString>
   50         <ChapLanguageIETF>en</ChapLanguageIETF>
   51       </ChapterDisplay>
   52       <ChapterSkipType>2</ChapterSkipType>
   53     </ChapterAtom>
   54   </EditionEntry>

 

Edited May 10, 2024 by rbjtech

[crusher11 976]

21 hours ago, rbjtech said:

I've finally moved away from the Plugin - and I'm now using the Core Intro Skip - it was just too much hassle to keep the plugin going.

 

Didn't you only just resume working on the plugin a couple of weeks ago?

The plugin still blows away the core. Better detection, editing features, end credits detection, etc etc. It just has no way of telling Emby where the markers need to go, without editing the existing chapter points.

[rbjtech 4996]

17 minutes ago, crusher11 said:

Didn't you only just resume working on the plugin a couple of weeks ago

 

Yes but have now decided that for the very small number of users that still use it - it is not worth my time.  Refactoring the code is a huge job.

My time is better spent 'adding' features to the Core that everybody can use.

18 minutes ago, crusher11 said:

The plugin still blows away the core. Better detection, editing features, end credits detection, etc etc. It just has no way of telling Emby where the markers need to go, without editing the existing chapter points.

Yep - some of these features will come back as supplements/plugins to the core - that way, both work in harmony as opposed to the current Plugin which uses a brute force way of writing it's data to 'work' with the core feature set.

[crusher11 976]

So it's more accurate to say that you're starting from scratch with a different plugin?

[elpoolet 21]

Hello all !

I discovered a couple of weeks ago these specs of <ChapterSkipType> in mkv !

I tried to create dummy episodes withe thez markers, but the ChapterAPI doesn't recognize those.

@rbjtechdid you manage to "upload" these informations inside the Emby DB ?

@LukeDo you think it could be a improvement soon ?

What are your thoughts @TeamB?

 

It could be a great improvement, cause it can reduce the time needed to update library when the intro detection is on. The rule could be : if theres no chapter inside the DB (for the intro), look inside the mkv, if theres ChapterSkipType chapters, use them for intro Start and Intro End timestamps... Else, use autodetection ...

 

Any thoughts ?

 

Thanks

[rbjtech 4996]

See https://emby.media/community/index.php?/topic/128900-detect-episode-intros/&do=findComment&comment=1355082

Until ffmpeg supports reading the markers (in the MKV) then it's a non-starter.

[elpoolet 21]

On 11/10/2024 at 4:11 AM, rbjtech said:

See https://emby.media/community/index.php?/topic/128900-detect-episode-intros/&do=findComment&comment=1355082

Until ffmpeg supports reading the markers (in the MKV) then it's a non-starter.

If I understand well, the Emby programs are not able to extract (mkv extract) the "chapters.xml" and parse it when the library is updated ? The chapter info could be one-way only (from the mkv to the DB)

 

https://ffmpeg.org/ffmpeg-formats.html#Metadata-2 doesn't present "ChapterSkipType", but it could be a subject asked to the dev community of ffmpeg ? Am I right ?

[Luke 40072]

On 11/12/2024 at 3:56 PM, elpoolet said:

If I understand well, the Emby programs are not able to extract (mkv extract) the "chapters.xml" and parse it when the library is updated ? The chapter info could be one-way only (from the mkv to the DB)

 

https://ffmpeg.org/ffmpeg-formats.html#Metadata-2 doesn't present "ChapterSkipType", but it could be a subject asked to the dev community of ffmpeg ? Am I right ?

HI, Emby uses ffmpeg to extract this information, and for now at least it doesn't appear to support chapters.xml.