antp.be forum

Is sounds great! I've just tested it yet. I had to change two reference from STR into SRT wink but it works great!

I definitely have some movies split in two files. So yes it has only one movie per folder but sometime there are 2 video files and 2 sub files.

When you use media import and scan the directory you have the option to assign fields to columns. I've also found the great icons on the right to load and save the field<->column association. Despite the fact that clicking load every time you open the import it's very trivial and quick I think the save settings should be loaded automatically by default. This program it's kind of personal according to the way you set it. Once you found the right association you'll always use them. So I think once this is saved it should be loaded automatically.
If you update the database every e.g. 2 weeks you might forget to click load and import messed up data. Last think you want is inconsistent info in the database. Anything that help preventing this in my opinion is welcome. Do you agree?

Finally I personally think it makes more sense to have the full size of the movie in the filesize fiels when it comes to movies made by multiple files. So a current 750+750 would be instead a simple 1500. That's easier to read and the "sort by file size" work as it's meant to be wink

You can already do this in Preferences > Movie information > Media files importation > Import size > Make a sum".

soulsnake wrote:

Take you time, I feel already very lucky to have gotten where I'm at the moment

Here is the script to find external subtitles in the folder of movie.
In: field Source to get full path of movie file
Out: field Subtitles with STR and/or SUB value if .srt and/or .sub file has been found for current movie.
I make the assumption that you have one movie by folder.
If you have more than one movie by folder, script need to be modify to search subtitles files with the same name of movie file.

Code: Select all

program FindExternalSubtitles;
var
  Value, FullPath, Path, Subtitles: string;

begin
  // Init subtitles value
  Subtitles := '';
  // Get full path from field Source
  FullPath := GetField(fieldSource);
  // Extrat path from full path
  Path := ExtractFilePath(FullPath);

  // List .str files in directory
  Value := ListDirectory(Path, '*.str');
  // If .str has been found
  if Value <> '' then
  begin
    if Subtitles <> '' then
      Subtitles := Subtitles + ', ';
    Subtitles := Subtitles + 'STR';
  end;

  // List .sub files in directory
  Value := ListDirectory(Path, '*.sub');
  // If .sub has been found
  if Value <> '' then
  begin
    if Subtitles <> '' then
      Subtitles := Subtitles + ', ';
    Subtitles := Subtitles + 'SUB';
  end;
  
  // Write subtitles value in field Subtitles
  SetField(fieldSubtitles, Subtitles)
end.

I like this! If you ask me: I think there's a need to add a "Full path" (including filename as I've found sometime different movies with same filename!!) field to the default database. This field can then be used by media import for the scope you mentioned.
If you decide to go this way can I just add a suggestion? Once the directories are scanned can you list the checked files (to be imported) first? This would simplify the management/identification of new files.

Ok, I will do it.
About just filename or full path, I will make comparison between selected field value and "just filename" of movie found + selected field value and "full path" of movie found. If one of them match, the movie will be unchecked.
In this way user you can store the full path or just the filename in a field in order to make comparison with existing movies and new movies.

I'm sure I'm not the only user of import media ;-) and I guess other users would like this PruneDatabase function to be available somehow. I do like the colours/marking of records to be manually removed, perhaps you may want to reserve a special colour for this so that users can't make mistakes marking a good record as pruned.

Or I can just give the choice to the user of color to use in script option .

I think in this thread there's a bunch of good ideas for your next beta release :-)

Yes, and a lot of work...
I will try to add these new features to the next release.

Soulsnake.

Sorry to revive an old thread. How do I define which field in the path residing in?

  // Get full path from field Source
  FullPath := GetField(fieldSource); 

Any other way to update the subtitle field during media import?

soulsnake wrote:

Sorry to revive an old thread. How do I define which field in the path residing in?

Replace fieldSource in script by the field where you store full filepath (e.g. fieldUrl)
You can find all field constants in Help > Technical Information > Script files creation.

Code: Select all

  // Get full path from field Source
  FullPath := GetField(fieldSource); 

Any other way to update the subtitle field during media import?

No sorry.

Soulsnake.