[Ericbwindsor]

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

[Ericbwindsor]

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

[DanCooper]

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

[KevinSartori]

 

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!

[DanCooper]

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"

[KevinSartori]

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!

[DanCooper]

sql:
SELECT

  movielist.*

FROM

  movielist

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

WHERE

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

[KevinSartori]

Thanks, Dan!  Greatly appreciated!

[drvid]

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?

[DanCooper]

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