Kodi Community Forum
Media List Editor Examples - 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)
+---- Forum: Ember Media Manager (https://forum.kodi.tv/forumdisplay.php?fid=195)
+---- Thread: Media List Editor Examples (/showthread.php?tid=225513)

Pages: 1 2 3 4 5 6 7

RE: Media List Editor Examples - Ericbwindsor - 2022-07-22

sorry a bit confused.  are you saying MyVideos##.emm is the file i need to copy?>

RE: Media List Editor Examples - Ericbwindsor - 2022-08-24

How do you filter by actor?  i've tried actor, actors, directors, creators...can't get it to work but not sure if it's possible

RE: Media List Editor Examples - DanCooper - 2022-08-25

You can search by actor and so on if you change it on the right side of the search bar:

Image

RE: Media List Editor Examples - KevinSartori - 2022-09-11

(2015-11-27, 11:55)DanCooper Wrote:
(2015-11-27, 08:38)beesmyer Wrote:  

Example for a source called "Dokus":
 
Code:
SELECT
  movielist.*
FROM
  movielist
  INNER JOIN moviesource ON (movielist.idSource = moviesource.idSource)
WHERE
  moviesource.strName = "Dokus"

Hi Dan,

I have a separate directory source in my TV Shows settings for Anime (D:\Videos\Anime).  Can you please post an example that shows that separate source in TV Shows?  Is this possible?

Thanks!

RE: Media List Editor Examples - DanCooper - 2022-09-11

(2022-09-11, 16:50)KevinSartori Wrote: I have a separate directory source in my TV Shows settings for Anime (D:\Videos\Anime)

sql:
SELECT

  tvshowlist.*

FROM

  tvshowlist

  INNER JOIN tvshowsource ON (tvshowlist.idSource = tvshowsource.idSource)

WHERE

  tvshowsource.strPath = "D:\Shows\Anime"


RE: Media List Editor Examples - KevinSartori - 2022-09-12

Hi Dan,

Excellent!  That did it!

Can I ask you for one more?  I have movie source for Music Videos (E:\Videos\Music Video)

Thanks again!

RE: Media List Editor Examples - DanCooper - 2022-09-12 

sql:
SELECT

  movielist.*

FROM

  movielist

  INNER JOIN moviesource ON (movielist.idSource = moviesource.idSource)

WHERE

  moviesource.strPath = "E:\Videos\Music Video"


RE: Media List Editor Examples - KevinSartori - 2022-09-13

Thanks, Dan!  Greatly appreciated!

RE: Media List Editor Examples - drvid - 2023-05-28

Hello and thanks for the useful tool!
Where can I see the schema for EMM's database, to assist with me writing my own media list queries?

RE: Media List Editor Examples - DanCooper - 2023-06-11

You can use SQLite DB Browser and open the .\Ember Media Manager\Profiles\Default\MyVideos##.emm to see the current DB structure.