Gathering info from NFO's

  Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Post Reply
snpaul22 Offline
Junior Member
Posts: 4
Joined: Oct 2013
Reputation: 0
Post: #1
I use EMM to organize all my movies before they are uploaded to my Kodi system at home. The problem is that when I stream movies when I'm at friend's houses, hotels, etc, I stream using Chromecast which doesn't support DTS audio. I would like to go through my media collection and convert the audio codecs of all DTS movies to AC3 or something. Being that I have around 1000 movies, I would prefer to not have to search manually. Are there any suggestions for doing a search that can identify all DTS movies? Can I make a custom filter in EMM that can output an XML of movie names and AudioFormatConvert tag that outputs dca? Can I search all movie nfo files for every instance of the DTS codec? Also the way my files are organized is:
> Media
>> Movies
>>> "<Folder named by movie title>"
>>>> Movie files, nfo's, jpegs, tbn's
>> TV Shows

Thanks in advanced.
find quote
Cocotus Offline
Moderator
Posts: 373
Joined: Mar 2011
Reputation: 9
Post: #2
(2015-02-27 21:25)snpaul22 Wrote:  I use EMM to organize all my movies before they are uploaded to my Kodi system at home. The problem is that when I stream movies when I'm at friend's houses, hotels, etc, I stream using Chromecast which doesn't support DTS audio. I would like to go through my media collection and convert the audio codecs of all DTS movies to AC3 or something. Being that I have around 1000 movies, I would prefer to not have to search manually. Are there any suggestions for doing a search that can identify all DTS movies? Can I make a custom filter in EMM that can output an XML of movie names and AudioFormatConvert tag that outputs dca? Can I search all movie nfo files for every instance of the DTS codec? Also the way my files are organized is:
> Media
>> Movies
>>> "<Folder named by movie title>"
>>>> Movie files, nfo's, jpegs, tbn's
>> TV Shows

Thanks in advanced.

I recently talked to Dan about this. The idea is to give the user the opportunity to build own filter in SQL language and save those as custom filter in setting. That way everyone can define own filters or share them here. I will add a feature request for this to bugtracker .
Another option would be to use the existing "Export" -> "Movies" menu in main menu of Ember as that exports the database structure of movie database in Ember to a xml file which can then be imported in Excel as XML-DataImport. Then you can use the great AutoFilter in Excel to sort data. Unfortunately this won't export the metadata of movies which is what you want - I will try to add this Smile

For a qick solution you can download "SQL Maestro" tool and open the .emm database in your Ember settings folder. Then open AMovies table and filter for Codec. Example:

[Image: emberdatabase95uet.jpg]

Then note the the corresponding ID in column "MovieID" and look for that ID in table "movies" -> you will find the name of the movie.
(This post was last modified: 2015-02-27 21:41 by Cocotus.)
find quote
snpaul22 Offline
Junior Member
Posts: 4
Joined: Oct 2013
Reputation: 0
Post: #3
Thanks for the help and very quick reply!
find quote
Cocotus Offline
Moderator
Posts: 373
Joined: Mar 2011
Reputation: 9
Post: #4
Small Update: The Export movie function in current fixed BETA1.4.08 now also exports metadata of video and audio. You can filter your movies for missing Codecs and such in Excel now.
find quote