Topic: "Swag of Tools" : Collection of Utilities for MC (Read 119383 times)

TXgary · « **Reply #150 on:** March 11, 2020, 10:48:07 pm »

I understand the last part, but not the first. How do I get the exported data out of JRiver, merged with my excel spreadsheet and back to the JRiver database? I understand that I can change the field in an exported file, but how will that field show up inside JRiver? I also understand that once inside JRiver, I can sort on that field and have my playlist songs. Just not tracking with how to go about defining the filekey field and the export/import of the data from/to JRiver. I also have 200K songs in that JRiver database.

DHF · « **Reply #151 on:** March 12, 2020, 07:36:33 am »

You create a FileKey library field by going to Tools - Options - Library and folders - Manage Library Fields and create a new one that looks like the screenshot below.

To get a list into excel - go to playlists - smartlists - and select Audio - all. Get rid of fields you wont need. And include the FileKey library field. Hit the down arrow on the Audio-All tab and select export playlist. Include only visible fields - and output range - all. This gives you a CSV file. Then do your stuff in Excel. You must save the output from excel as a text file.

To get that data back in to JRiver - use the "Swag of Tools" utility. See my previous posts as I had some difficulty the first time as well - and got help from the forum.

You basically create a text file and the utility loads that into JRiver changing the fields.

For 200,000 file Library - don't worry - it works fine for small databases.

Just for safety's sake - back up the library before making changes.....

TXgary · « **Reply #152 on:** March 12, 2020, 10:36:31 am »

Sounds like great stuff... Not a simple task but is simplified somewhat with the swag tools.

arcspin · « **Reply #153 on:** March 15, 2020, 07:47:14 am »

Quote from: jmone on January 06, 2018, 07:25:20 pm

Update: 07 Jan 2018
- MediaInfo will now let you optionally update a MC Field with selected info reported by MediaInfo and can restrict this by a Section of the report.

Eg Lepa can update his custom "Subtitles" field by using these values in order (See Pic)
- Subtitles (the name of the field in MC)
- Language (the name of the field in MediaInfo)
- Text (the name of the section in MediaInfo to restrict it to).

Hi,
I'm testing out this feature in Swag of tools and am noticing that if I run Swag of tools on the same file multiple times the subtitles text duplicates every time:

First run: English; French; Spanish;
Second run: English; French; Spanish; English; French; Spanish;
Third run: English; French; Spanish; English; French; Spanish; English; French; Spanish;

Is there a way of not making Swag of tools duplicate the Subtitles texts.

arcspin · « **Reply #154 on:** March 15, 2020, 09:00:05 am »

Got the answer

arcspin · « **Reply #155 on:** March 15, 2020, 02:09:01 pm »

Got the answer

arcspin · « **Reply #156 on:** March 21, 2020, 02:06:44 pm »

Quote from: arcspin on March 15, 2020, 07:47:14 am

Hi,
I'm testing out this feature in Swag of tools (SoT) and am noticing that if I run Swag of tools on the same file multiple times the subtitles text duplicates every time:

First run: English; French; Spanish;
Second run: English; French; Spanish; English; French; Spanish;
Third run: English; French; Spanish; English; French; Spanish; English; French; Spanish;

Is there a way of not making Swag of tools duplicate the Subtitles texts.

To add some more request to SoT

Under the Mediainfo tab.
Could there be a couple of "sets of fields" so that SoT run all the request at once.

As it is now I run SoT with these fields entered (for subtitle information):
Subtitles
Language
Text

and then I run SoT with these fields entered (for audio language information):
Audio Language
Language
Audio

and then I run SoT with these fields entered (for audio tracks information):
Audio Tracks
Title
Audio

If I could run all of these at once would be great.

//arcspin

xynoe44 · « **Reply #157 on:** April 30, 2020, 07:52:50 am »

Quote from: arcspin on March 21, 2020, 02:06:44 pm

To add some more request to SoT

Under the Mediainfo tab.
Could there be a couple of "sets of fields" so that SoT run all the request at once.

...

//arcspin

I would love this feature too.
The possibility to specify any number of MC Field/Mediainfo Data Field/Mediainfo Section per run.
Actually, info automatically populated for video files in MC fields is very poor (resolution, compression, etc...).

Thanks in advance.

jmone · « **Reply #158 on:** May 01, 2020, 11:51:32 pm »

Sorry - I've been away and since back kinda distracted on what going on in the world.

Anyway, here is a new test version that I'd love some feedback on before publishing:
- Updated: the "Read Blu-ray MPLS" code to the latest I'd published earlier this year
- Updated: Media Info to use V20.03 (you will need to delete or rename the MediaInfo sub folder to get the new version)
- Fixed (Media Info): the bug where it kept adding values that were already in the list
- New (Media Info): You can now enter a delimited list of Fields for updating MC from Media Info (see pic)

Thanks
Nathan

arcspin · « **Reply #159 on:** May 02, 2020, 04:46:11 am »

Hello jmone and thank you for the update!

I have tried it out and here is what I have found.

The delimiter list works just fine when I update one movie at the time.
When I update several movies with a delimiter it will only update the fields in the first movie, not the other movies.

When I update several movies without delimiter that specific Field in MC is updated ok.

The fields that only the first movie is updated with and not the other movies (with delimiter):
Subtitles
Language
Text

Audio Language
Language
Audio

EDIT:
My own field with Different sound tracks in the MKV-movie file
Audio Tracks
Title
Audio

This field is getting updated with multiple movies and delimiter but it also adds the same information in the back of the existing information.

OK this is a little strange, I have found one movie that does the above regarding adding information, other movies do not duplicate my Audio Tracks field. Strange?

This is the information that is stored and being duplicated when I run SoT multiple times:
English ; DTS-HD Master Audio ; 5.1 ; 48 kHz ; 3 432 kbps ; 24-bit (DTS Core; 5.1 ; 48 kHz ; 1509 kbps ; 24-bit); English commentary

One suggestion I have to improve SoT is to have SoT remember what is entered in the fields for Mediainfo.
As it is now, I have to type in the same information when I start SoT.

Stay safe,

//arscpin

jmone · « **Reply #160 on:** May 02, 2020, 07:29:27 am »

Thanks for testing - I'll dig into that on Sunday.

jmone · « **Reply #161 on:** May 02, 2020, 07:42:12 pm »

Ok - here is the next test version:

- Updated: the "Read Blu-ray MPLS" code to the latest I'd published earlier this year
- Updated: Media Info to use V20.03 (you will need to delete or rename the MediaInfo sub folder to get the new version)
- Fixed (Media Info): the bug where it kept adding values that were already in the list
- New (Media Info): You can now enter a delimited list of Fields for updating MC from Media Info (see pic)
- New (Media Info): Field values will be remembered
- New: MCWS Username and Password will now be hashed in the INI File (note: you will need to reenter your User Name and Password in the Configuration Box).

arcspin · « **Reply #162 on:** May 03, 2020, 01:10:09 am »

I have done some more testing and here are my results.

Now SoT do update several movies at once using delimiter, so that problem is now solved.
SoT remember my field values in Mediainfo tab (thank you for that)
SoT do not remember my username and password, I have to type those in every time I open SoT
(In the Swag of Tools.ini file there are garbage text instead of, as it was before, my username and password written in plain text.)

I still have these duplicates when trying to import title info from the audio tracks chapter from Mediainfo and when I try more movies with information in the Audio, Title field I do get duplicates writing on several more movies.

So this is what I type in SoT:
Audio Tracks
Title
Audio

SoT then fetches all the information from the titles field in Audio as per the attached screen shots. (Duplicated.jpg and Not Duplicated.jpg)
It is this information that gets duplicated when I run SoT multiple times on several movies that I have.

From a movie that gets duplicated information, this is what is written to my MC Audio tracks field (see also attached Duplicated.jpg for comparison) :
English ; DTS-HD Master Audio ; 5.1 ; 48 kHz ; 3 432 kbps ; 24-bit (DTS Core; 5.1 ; 48 kHz ; 1509 kbps ; 24-bit); English commentary

From a movie that do not get duplicated information, this is what is written to my MC Audio tracks field(see also attached Not Duplicated.jpg for comparison) :
TrueHD Atmos 7.1; AC-3 5.1-EX; Commentary by director Andrew Niccol

(I also attach a screen shot from my Library filed to show my created Audio tracks field)

This is however not a big deal because I only run SoT once for every movie, but it is interesting that this duplication thing do not occur on every movie but only some.

jmone · « **Reply #163 on:** May 03, 2020, 01:26:45 am »

Thanks - I'll dig into this some more.

~~One quick thing, can you check that the Username and Password is not working (it is for me)~~

edit: Nope I broke something!

jmone · « **Reply #164 on:** May 03, 2020, 02:07:20 am »

Here is a version where the Username / Password should be working

I'm struggling to find an example in my Library with anything with Audio/Title to see what is happening. Do you have some movie names or a sample of one?

arcspin · « **Reply #165 on:** May 03, 2020, 02:28:24 am »

Yes, the username and password are now saved

I'll attach the Mediainfo file for two movies that I was referring to in my previous post.
Duplicates = Zodiaz Directors Cut
Not Duplictaes = Lord of War

jmone · « **Reply #166 on:** May 03, 2020, 02:39:08 am »

So how the script should work using Audio Tracks / Title / Audio on the Zodiac example:

1st Instance of the match = "English / DTS-HD Master Audio / 5.1 / 48 kHz / 3 432 kbps / 24-bit (DTS Core: 5.1 / 48 kHz / 1509 kbps / 24-bit)"
2nd Instance of the match = "English" but that is already in the string so we ignore that
3rd Instance of the match = "English" but that is already in the string so we ignore that
4th Instance of the match = "English commentary" and since that is unique we add that to the string

SoT changes "/" to ";" so what should be written to MC is then
English ; DTS-HD Master Audio ; 5.1 ; 48 kHz ; 3 432 kbps ; 24-bit (DTS Core; 5.1 ; 48 kHz ; 1509 kbps ; 24-bit); English commentary

Are you saying if you run SoT multiple times on Zodiac you get multiple versions of this string being written or is it that there is "English" and "English commentary"?

arcspin · « **Reply #167 on:** May 03, 2020, 02:49:24 am »

Hi,
This is what is written into MC Audio Tracks field:

First run with SoT
English ; DTS-HD Master Audio ; 5.1 ; 48 kHz ; 3 432 kbps ; 24-bit (DTS Core; 5.1 ; 48 kHz ; 1509 kbps ; 24-bit); English commentary

Second run with SoT
English ; DTS-HD Master Audio ; 5.1 ; 48 kHz ; 3 432 kbps ; 24-bit (DTS Core; 5.1 ; 48 kHz ; 1509 kbps ; 24-bit); English commentary; English ; DTS-HD Master Audio ; 5.1 ; 48 kHz ; 3 432 kbps ; 24-bit (DTS Core; 5.1 ; 48 kHz ; 1509 kbps ; 24-bit)

And so on...

jmone · « **Reply #168 on:** May 03, 2020, 02:51:07 am »

Thanks - I'll dig in further...

arcspin · « **Reply #169 on:** May 03, 2020, 02:54:20 am »

Mind you that this duplication thing is not for every movie that has Audio/Title, only some.
Some movies like Lord of war does not duplicate but others like Zodiac duplicates.

Weird!

jmone · « **Reply #170 on:** May 03, 2020, 03:22:27 am »

Weird indeed. Sent you a PM.

arcspin · « **Reply #171 on:** May 03, 2020, 04:11:41 am »

PM returned.

jmone · « **Reply #172 on:** May 03, 2020, 05:10:53 am »

How does this one work?

jmone · « **Reply #173 on:** May 03, 2020, 05:16:36 am »

Nope it is broken.... more digging

arcspin · « **Reply #174 on:** May 03, 2020, 05:25:56 am »

Yup,
I do not post the MC fields as you have noticed that it writes a lot more info in Audio tracks, Audio language and subtitles

jmone · « **Reply #175 on:** May 03, 2020, 05:26:39 am »

Next test

arcspin · « **Reply #176 on:** May 03, 2020, 05:35:12 am »

BINGO!

It works as it should, no duplication with any of my movies files that before hade duplicates written in MC Audio Tracks field.

Great work!!!

jmone · « **Reply #177 on:** May 03, 2020, 05:38:49 am »

XLNT! I'll clean up some code and post a new version. Thanks for all the testing

jmone · « **Reply #178 on:** May 03, 2020, 05:51:52 am »

Update: 02 May 2020 - Latest files in the First Post of this thread
- Updated: the "Read Blu-ray MPLS" code to the latest I'd published earlier this year
- Updated: Media Info to use V20.03 (you will need to delete or rename the MediaInfo sub folder to get the new version)
- Fixed (Media Info): the bug where it kept adding values that were already in the list
- New (Media Info): You can now enter a delimited list of Fields for updating MC from Media Info (see pic)
- New (Media Info): Field values will be remembered
- New: MCWS Username and Password will now be hashed in the INI File instead of being in Clear Text (note: you will need to reenter your User Name and Password in the Configuration Box).

arcspin · « **Reply #179 on:** May 03, 2020, 05:58:39 am »

Still works perfect.

jmone · « **Reply #180 on:** May 03, 2020, 06:00:37 am »

Thanks again! Let me know if there are other things that are needed.
Nathan

JimH · « **Reply #181 on:** May 03, 2020, 06:48:07 am »

Thanks, Nathan.

jmone · « **Reply #182 on:** May 03, 2020, 07:39:17 pm »

Thanks - it's good to be back

cowboydude99 · « **Reply #183 on:** May 11, 2020, 08:55:18 pm »

Hi there,
Does the MediaInfo work with DTS X? My MC is never updated to show DTS X. It does update for Atmos and DTS-HD MA.

In MediaInfo, the track shows as ObjectBased DTS XLL.

I'm running the most up to date MediaInfo.

arcspin · « **Reply #184 on:** May 11, 2020, 10:41:23 pm »

Hi,
This is how it looks, for me, in Mediainfo when SoT finds a DTS:X movie.
See attachment

//arcspin

jmone · « **Reply #185 on:** May 11, 2020, 10:41:38 pm »

Thanks for the report. Looks like "Media Info" changed how they report DTS:X in the latest version so I was not picking it up
oldversion: X / MA / Core
newversion: DTS XLL X

Here is a test version that should find both examples (if they exist) and update MC's Compression Field with "+DTS:X".

Thanks
Nathan

Note: I also see there is an open ticket over at MediaInfo regarding some issues with correctly identifying some DTS:X audio tracks

cowboydude99 · « **Reply #186 on:** May 11, 2020, 10:48:55 pm »

Awesome! I’ll give it a shot in the AM!

arcspin · « **Reply #187 on:** May 11, 2020, 11:40:33 pm »

HI,
When I look into the movies I have and what movies are being recognized as DTS:X on my Marantz SR-7011 I come across for example Jumanji The Next Level.
It is being labeled in Mediainfo as per the attachement.

jmone · « **Reply #188 on:** May 12, 2020, 01:12:34 am »

Yup, I checked my and it to has DTS:X but the latest version of Media Info is not displaying that info either, I get:
Audio #1
ID : 4352 (0x1100)
Menu ID : 1 (0x1)
Format : DTS XLL
Format/Info : Digital Theater Systems
Commercial name : DTS-HD Master Audio
Muxing mode : Stream extension
Codec ID : 134
Duration : 2 h 3 min
Bit rate mode : Variable
Channel(s) : 8 channels
Channel layout : C L R LFE Lb Rb Lss Rss
Sampling rate : 48.0 kHz
Frame rate : 93.750 FPS (512 SPF)
Bit depth : 24 bits
Compression mode : Lossless
Language : English
Source : 00001.m2ts

The author of MediaInfo has acknowledged the issue and has an open bug report.... but is is not sure how/when/if it can be addressed

jmone · « **Reply #189 on:** May 12, 2020, 02:10:16 am »

Of the 66 UHD's that I have with DTS, 28 are marked as having DTS:X and 38 without. Of the 38 it looks like the only one that should have been marked with DTS:X is Jumanji The Next Level. So it's a bug but not a big one.... but still annoying.

jmone · « **Reply #190 on:** May 12, 2020, 02:30:44 am »

So to "Fix" Jumanji The Next Level, I used the folllowing in SoT (as the Compression Field is locked in the MC GUI):
- Highlighted "Jumanji The Next Level" in MC
- In SoT when to Data Fiddler
- In SoT selected "Export Selected Items Only from the MC Library (Creates a TXT File)"
- Opened the TXT file with Notepad++ and changed "bdmv video (video: HEVC, audio: dts-hd)" to "bdmv video (video: HEVC, audio: dts-hd)+DTS:X"
- In SoT selected "Update MC Library (From TXT File)
= Fixed!

jmone · « **Reply #191 on:** May 13, 2020, 04:05:50 am »

I got Bad Boys for Life today on UHD and while it is DTS:X it is only identified as DTS-HD MA

cowboydude99 · « **Reply #192 on:** May 13, 2020, 09:55:55 am »

The latest SOT (uploaded a few posts ago), doesn't fix the issue.

The movies still show up as DTS-HD MA.

jmone · « **Reply #193 on:** May 13, 2020, 04:59:07 pm »

What are the movies that don't show as DTS:X that should? ....and if you use MediaInfo directly on them what does MediaInfo say?
Thanks
Nathan

cowboydude99 · « **Reply #194 on:** May 13, 2020, 07:02:50 pm »

Upon a closer look, it doesn't seem to be that wide-spread as I thought.

The handful of the 60 I looked at is all there is...

E.T
Jurassic Park
Jurassic World Fallen Kingdom
Bad Boys for Life

I can fix these manually, but what happens when you select to update the entire library? I guess just don't do that!

jmone · « **Reply #195 on:** May 14, 2020, 01:17:59 am »

So SoT will not remove the +DTS:X or Atmos if it is there. It will only ever add it. If you run MC's "Update Library from Tags" then it will be removed as MC does a full replace.

I have both Jurassic Park discs and DTS:X is being correctly identified for me using the latest version of SoT:

Code: [Select]

Audio #1
ID                                       : 4352 (0x1100)
Menu ID                                  : 1 (0x1)
Format                                   : DTS XLL X

We know BB for Life is not being picked up and I don't have E.T to test.

What does your MediaInfo info file look like for the Jurrasic Park's? (note: in MC you can Right Click on them --> View Extras --> View index_MediaInfo.txt to auto open the MediaInfo info file.

jmone · « **Reply #196 on:** July 02, 2020, 02:09:16 am »

Update: 02 July 2020 - Latest files in the First Post of this thread
- Fixed (Media Info): Will update MC for DTS:X on both the new (DTS XLL X) and old format (X / MA / Core) used by MediaInfo. Note: there is still an open bug at MediaInfo where some DTS:X tracks are not correctly detected
- New (Setup): Thanks to a MCWS change from Matt, SOT will now automatically create the calculated field "FileKey" during configuration (so users don't have to do it manually). Requires MC V26.0.95 or latter.

jmone · « **Reply #197 on:** October 10, 2020, 12:23:37 am »

Update: 10 October 2020
- Fixed: Found a bug in the MPLS Chapter code where the first 9 chapters could be mis-numbered. Just removed the bit of code that was padding these with a leading "0".
- New (Setup): As suggested earlier, I've moved the code and release onto Git Hub - https://github.com/jmone1/Swag-of-Tools/releases - Unless there is a need to attach the files in this thread, you can download the releases there from now on.

Thanks
Nathan

Mans · « **Reply #198 on:** December 27, 2020, 10:12:09 am »

Greatday all, hoping you're safe and well,

Question concerning the working of MediaInfo and the amazing SoT:

It seems i can't grab the subtitle language from a bigger part of my movies collection inside MC.
Talking about .TS rips mostly.

After setting the config file - and working - I did create a additional field in MC and 'linked thisone to 'Languages' from MediaInfo and using "text".

P.e. DVD: The man with the golden gun, has a multiple subtitles, but not repported by MediaInfo. I mean not pushed into the MC field neither the log says getting the languages or subs scrapped.

As I'm using some other 3thP program to scrape for film posters, banners etc, I've got also the streamdetails as .nfo from the latter one which does include the languages and subs, see list below.

I'm sure I'm missing some setting or detail, thanks for pointing me into the right direction :-)

fileinfo>
<streamdetails>
<video>
<durationinseconds>7189</durationinseconds>
<codec>mpeg2</codec>
<aspect>1.778</aspect>
<width>720</width>
<height>576</height>
</video>
<audio>
<language>fra</language>
<channels>2</channels>
</audio>
<audio>
<language>ita</language>
<channels>2</channels>
</audio>
<audio>
<language>eng</language>
<channels>2</channels>
</audio>
<audio>
<language>eng</language>
<channels>2</channels>
</audio>
<subtitle>
<language>fra</language>
</subtitle>
<subtitle>
<language>ita</language>
</subtitle>
<subtitle>
<language>eng</language>
</subtitle>
<subtitle>
<language>dut</language>
</subtitle>
<subtitle>
<language>hun</language>
</subtitle>
<subtitle>
<language>gre</language>
</subtitle>
</streamdetails>

zxsix · « **Reply #199 on:** December 30, 2020, 10:36:33 am »

thanks for this tool!

INTERACT FORUM

Author Topic: "Swag of Tools" : Collection of Utilities for MC (Read 119383 times)