Windows > Third Party Plug-ins, Programs, and Skins
Guide: Data Fiddler (MC Library <-> Spreadsheet Import/Export/Update)
8139david:
Thanks.
Exporting the key would be a nice feature for JRiver itself.
This way you can select some files, and export playlist as you want, while still having the key.
8139david:
I'm trying to recreate my library of dummy movies, like I said earlier.
I have a problem when opening the txt file in Libre Office Calc: some fields are too long.
Indeed, for some reason, in some cases, all the fields are recognized as one field, and several movies are put into that single field.
Cf. pic.
Any idea to solve this problem?
8139david:
I manage all my digital media on JRiver: films and albums.
They are on some hard disc from which they can be played from JRiver.
In that sense, they are "on line" media.
Now, I also have concrete, physical media: dvds, blurays, cds, lps...
Those are not present on any hard disc accessible by JRiver.
In that sense, they are "off line" media.
I would like all my media, whether on line or off line, catalogued by JRiver.
How can I incorporate the off line media?
Answer:
- create a tabbed text file containing the relevant information about each media;
- then use Data Fiddler to update JR's library with the corresponding information.
Cf. the more detailed explanations concerning Data Fiddler given by jmone in this post:
http://yabb.jriver.com/interact/index.php?topic=102906.msg714492#msg714492
For movies in particular
JRiver's "Get Movie & TV Show Information" works really very well, using only the title of the movie.
So suppose I want to catalog my own dvds for the first time.
Then I simply create a tabbed text file like:
My dvds.txt
--- Code: ---Name
Star Wars
Startrek
--- End code ---
or
My dvds (with Type and Sub Type).txt
--- Code: ---Name Media Type Media Sub Type
Star Wars Video Movie
Startrek Video TV Show
--- End code ---
Then I use Data Fiddler: "Create/Import a MC Playlist File (from Tab TXT File)".
The MC playlist obtained from My dvds (with Type and Sub Type).txt is this:
My dvds (with Type and Sub Type)_20160131165203.mpl:
--- Code: ---<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<MPL Version="2.0" Title="MC Fiddler Import 20160131165203" PathSeparator="\">
<Item>
<Field Name="Name">Star Wars</Field>
<Field Name="Media Type">Video</Field>
<Field Name="Media Sub Type">Movie</Field>
</Item>
<Item>
<Field Name="Name">Startrek</Field>
<Field Name="Media Type">Video</Field>
<Field Name="Media Sub Type">TV Show</Field>
</Item>
</MPL>
--- End code ---
When imported in JRiver, it looks like the first attached pic of JRiver.
Remark: since Star Wars and Startrek are already tagged as Video and each given an appropriate Media Sub Type (Movie or TV Show), I can immediately do a "Get Movie & TV Show information". Otherwise, I would have to specify manually in JRiver first their Media Type "Video", then their Media Sub Type, before being able to Get Movie & TV Show Information.
Of course, this procedure also works if I have more information in my text file.
Suppose I have already collected a lot of information about my blurays (cf attached pic of excell spreasheet).
Then I have this text file:
blurays.txt
--- Code: ---Name Commentaire Genre Media Type Media Sub Type Producer Critic Rating Director Actors IMDb ID
Solaris Vu au cinéma en 1992 Drama; Science Fiction; Adventure; Mystery Video Movie Viacheslav Tarasov Tmdb 7,5 / 10 Andrei Tarkovsky Donatas Banionis; Natalya Bondarchuk Tt0069293
Jules Et Jim Vu au cinéma en 1985 Drama; Romance Video Movie François Truffaut Tmdb 7,3 / 10 François Truffaut Jeanne Moreau; Oskar Werner; Henri Serre; Marie Dubois; Sabine Haudepin; Vanna Urbino; Serge Rezvani; Anny Nelsen; Michel Subor Tt0055032
--- End code ---
This yields this mpl file -- see attached pic for imported playlist in JRiver:
blurays.mpl
--- Code: ---<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<MPL Version="2.0" Title="MC Fiddler Import 20160131171835" PathSeparator="\">
<Item>
<Field Name="Name">Solaris</Field>
<Field Name="Commentaire">Vu au cinéma en 1992</Field>
<Field Name="Genre">Drama; Science Fiction; Adventure; Mystery</Field>
<Field Name="Media Type">Video</Field>
<Field Name="Media Sub Type">Movie</Field>
<Field Name="Producer">Viacheslav Tarasov</Field>
<Field Name="Critic Rating">Tmdb 7,5 / 10</Field>
<Field Name="Director">Andrei Tarkovsky</Field>
<Field Name="Actors">Donatas Banionis; Natalya Bondarchuk</Field>
<Field Name="IMDb ID">Tt0069293</Field>
</Item>
<Item>
<Field Name="Name">Jules Et Jim</Field>
<Field Name="Commentaire">Vu au cinéma en 1985</Field>
<Field Name="Genre">Drama; Romance</Field>
<Field Name="Media Type">Video</Field>
<Field Name="Media Sub Type">Movie</Field>
<Field Name="Producer">François Truffaut</Field>
<Field Name="Critic Rating">Tmdb 7,3 / 10</Field>
<Field Name="Director">François Truffaut</Field>
<Field Name="Actors">Jeanne Moreau; Oskar Werner; Henri Serre; Marie Dubois; Sabine Haudepin; Vanna Urbino; Serge Rezvani; Anny Nelsen; Michel Subor</Field>
<Field Name="IMDb ID">Tt0055032</Field>
</Item>
</MPL>
--- End code ---
The field "Commentaire" has been ignored since it does not correspond to a Library field of JRiver.
(If I wanted to avoid that, I should either have renamed that field "Comment" in the text file, or created a new field "Commentaire" in JRiver.)
And for albums?
I haven't tried it myself. But clearly more information is needed, at least: Artist, Album, and Name for each song or piece.
PS: If the files you're cataloging are offline, then JRiver will give them some unchangeable attributes, such as zero (or empty) Duration, Dimensions, File Size. This cannot be avoided, since these attributes are read directly from available files --and in the case of off line media, there is no real file with the proper properties that JRiver can access.
jmone:
Thanks David. I had a quick look at the TXT and MPL files you sent. The TXT file opens fine in Excel so it may be just Libre Office Calc...
When I look at the files it is this section where Libre seems to be thrown:
MPL
<Field Name="Description">"The Three Ages," Buster Keaton's First Feature-Length Film After A Number Of Comedy Shorts, Is His Parody Of Griffith's "Intolerance." Keaton Tells Three Parallel Stories About The Perils Of Romance, One Set In The Stone Age, One During The Roman Empire, And One During The 20th Century.</Field>
TXT
"The Three Ages," Buster Keaton's First FeatureLength Film After A Number Of Comedy Shorts, Is His Parody Of Griffith's "Intolerance." Keaton Tells Three Parallel Stories About The Perils Of Romance, One Set In The Stone Age, One During The Roman Empire, And One During The 20th Century.
I'm wondering if it is the double Quote Marks (") around "The Three Ages," as these don't appear for me when imported into Excel (maybe Libre is seeing them as a Delimiter or an Escape Char then reading everything from there on into one cell?). Try deleting the Quotes one at a time from the start of "The Three Ages" in the txt file and importing into Libre to see what causes it?
I'm hoping to look at the multi line parsing this arvo with some luck....
jmone:
Update: 01FEB16
- Changed: Updated how the Import/Export code works to work in reading and writing multiple lines with a data field and handle embedded Tab, and Carriage Returns/LineFeeds. This should increase the compatibility with various TXT editors, Excel etc, as any field that has Tabs and Carriage Returns Line Feeds embedded in the data will be shown as {TAB}, {CR}{LF} in the exported Text File. So in Excel you may have a Description that looks like "This Movie version is:{CR}{LF}{TAB}- The Original Theatrical Release{CR}{LF}{TAB}- Filmed in Sydney Australia" all in one cell, and in MC it will appear as:
This Movie version is:
- The Original Theatrical Release
- Filmed in Sydney Australia
If editing the TXT file, you can added/remove {CR}{LF}{TAB} as needed
Let me know of any other "weird" characters that cause issues.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version