Print

Please login or register.
1 Hour 1 Day 1 Week 1 Month Forever
Login with username, password and session length

[TXgary]

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]

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]

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

[arcspin]

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]

Got the answer

[arcspin]

Got the answer

[arcspin]

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]

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]

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]

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]

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

[jmone]

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]

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]

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]

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]

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]

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]

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]

Thanks - I'll dig in further...

[arcspin]

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]

Weird indeed.  Sent you a PM.

[arcspin]

PM returned.

[jmone]

How does this one work?

[jmone]

Nope it is broken.... more digging

[arcspin]

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]

Next test

[arcspin]

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]

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

[jmone]

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]

Still works perfect. 

[jmone]

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

[JimH]

Thanks, Nathan.

[jmone]

Thanks - it's good to be back

[cowboydude99]

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]

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

//arcspin

[jmone]

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]

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

[arcspin]

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]

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]

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]

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]

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

[cowboydude99]

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

The movies still show up as DTS-HD MA.

[jmone]

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]

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]

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]

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]

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]

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]

thanks for this tool!