Print

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

[sonata31]

Do you mean Artist and Director?  If so, I mentioned above that I've dual-mapped Director to Artist.  See:

   http://wiki.jriver.com/index.php/File_Properties_%28tags%29#Artist

Let me know if you don't want this dual mapping.
Yes

How can I know how to map Media Sub Type from the XML data available?

I'm not scanning your folders, so don't have this information.

Where is this information reliably stored?  I don't see anything that is consistent.  I mentioned above a number of fields are not mapped, because the data is not there (at least, I don't see how to reverse map it, from free-form formatting to a Series or Season).  You need to help me here.
Is it possible to use the Tag field of DVD Profiler?
Tag = Series
Tag = Season x

See attached file

When the file exists in the same directory as the media files, it should be found when you perform the import.  I tested it with an mpg file.

I've fixed an issue where only the first Credit was being included.  Grab the new (1.2) version here.

[MrC]

Is it possible to use the Tag field of DVD Profiler?
Tag = Series
Tag = Season x

This should be sufficient for Series and Season.

I don't see any values in your XML file  Edit: I was looking at the old Collection.xml file:

    <Tags>
      <Tag Name="Season 1" FullName="Season 1"/>
      <Tag Name="Series" FullName="Series"/>
    </Tags>

I presume you have not added them.  I'll need sample data.

[MrC]

In looking at your file paths, it seems your files use two forms to include season/episode:

   " - S05E01 - "
   "-S05E01-"

It would be no problem to grab the season and episode from this if it exists.  If you want me to use all the stuff before it to be the Series name, I can do that too.

[MrC]

I went ahead and made the changes:

 - Removed dual mapping of Director to Artist
 - Pull Series, Season, and Episode from Location file path using above criteria
 - Set Media Sub Type to TV Show when above match is found

See if this version (1.3) works for you.

[sonata31]

In looking at your file paths, it seems your files use two forms to include season/episode:

   " - S05E01 - "
   "-S05E01-"

It would be no problem to grab the season and episode from this if it exists.  If you want me to use all the stuff before it to be the Series name, I can do that too.

The problem is the series only available on DVD or BluRay without disk file
Hence the use of tags

[MrC]

The problem is the series only available on DVD or BluRay without disk file
Hence the use of tags

Whatever you want to use is fine with me.  I am however, confused by your statement about the series being only available ... without disk file.  Doesn't this disc file in the Location field include the Series name, Season and Episode?

        <Location>D:\series\hcsrv1\Dexter\Saison 1\Dexter - S01E01 - Dexter.vob</Location>

Your example tags above do not include an Episode number.  There would have to be multiple tags, each clearly associated with a specific Location (Filename).  How do you propose to do that?  If you don't care about this, then Season and Series values are fine anywhere in the <DVD> ... </DVD> container.

[sonata31]

I have DVD and BluRay I have not ripped to hard disk, those have not corresponding file
Hence the use of tags

[sonata31]

When I import the collection.mpl file created with the latest version of the script, nothing is displayed in JRiver

[MrC]

I'll check it out in the morning.

[sonata31]

Why in JRiver, when importing the file mpl every item with the specified Filename field, are not imported?

[sonata31]

Why in JRiver, when importing the file mpl every item with the specified Filename field, are not imported?

It seems that at the time of import, JRiver sees the file on disk, and that it is a valid video file

[MrC]

It seems that at the time of import, JRiver sees the file on disk, and that it is a valid video file

MC looks to see if the file exists.

I've added a new command line option (-a) that will export items that do not have an actual backing file (no Location entry).  By default, only entries with a Location are exported.

I still need some valid sample data for your Tags if you are going to use them.  All I have is:

 <Tags>
      <Tag Name="Season 1" FullName="Season 1"/>
      <Tag Name="Series" FullName="Series"/>
 </Tags>

I can't tell from this example if Name indicates the tag type, or if it always matches FullName.  Ideally, they would look like:

 <Tags>
      <Tag Series="some series name" Season="1"/>
 </Tags>

or if you can't change the name of the attributes:

 <Tags>
      <Tag Name="Season" FullName="1"/>
      <Tag Name="Series" FullName="some series name"/>
 </Tags>

In your example above, I can't know which one is the series Tag, since I assume it doesn't say Series once actual data is included:

 <Tags>
      <Tag Name="Season 1" FullName="Season 1"/>
      <Tag Name="some series name" FullName="some series name"/>
 </Tags>
some series name

[sonata31]

See the attached file

[MrC]

Attached is version 1.4, which includes the following changes:

 - Uses the Tag values to set Series and Season (Path/filename patterns "Series Name- S##E## - " will override)
 - added -a option to also export DVD entries without a Location (i.e Filename) value (these are not output by default)

[sonata31]

I tested it as soon as possible

thank you again

[sonata31]

A priori it works well

It remains to map from DVD Profiler :
ProductionYear: is it Date? How is this calculated?

Does JRiver could manage sagas like the series:
Example:
Saga: Terminator
Episode 1: The Terminator
Episode 2: Terminator 2
Episode 3: Terminator 3

[MrC]

Production Year gets mapped to Date (this is what you specified in your DVD_Profiler_to JRiver.rtf file).  The value stored in the Date field in the mpl is the number of days between the MC date epoch which is 1899/12/31 and the Production Year from the xml file.  If you want another field to be used, that's fine.

Many folks use Series for "saga".  You could create your own Saga field and use it for the grouping.

[sonata31]

Production Year gets mapped to Date (this is what you specified in your DVD_Profiler_to JRiver.rtf file).  The value stored in the Date field in the mpl is the number of days between the MC date epoch which is 1899/12/31 and the Production Year from the xml file.  If you want another field to be used, that's fine.
Map is ok
For example, for 2000, taking January 1 or December 31?

Many folks use Series for "saga".  You could create your own Saga field and use it for the grouping.

[MrC]

Year-only dates will be Jan 1.

If you have examples that aren't working, let me know which entries and I'll take a look.  The conversion may not be perfect.

[sonata31]

I would look in detail each field

Again thank you for this great job

[MrC]

Great, glad its working so far.

Some food for thought - since you have much data that isn't currently being collected/stored, it could be combined into MC's comments field.  At least that way, you have it internally, and it can be pulled piecemeal into other fields rather easily.

[sonata31]

Great, glad its working so far.

Some food for thought - since you have much data that isn't currently being collected/stored, it could be combined into MC's comments field.  At least that way, you have it internally, and it can be pulled piecemeal into other fields rather easily.

An example ?

[MrC]

Oh, there are things like:

CaseType>Keep Case</CaseType
<CollectionType>Owned</CollectionType>
<UPC>0-044005-374926</UPC>
<MediaTypes>
        <DVD>true</DVD>
        <HDDVD>false</HDDVD>
        <BluRay>false</BluRay>

etc.

I don't know what data you and others care about.  So, if you want this imported in to MC, it just has to be mapped.

For simple mappings like a string or list from one XML field to an MC field, you can add to the @path_to_MC_field array in the program.  The format is trival: the first column is the DVD Profiler XML path, the second column is the MC field name (stock, or your own), and the third column is a  reference to one of the two functions add_list_item() or add_single_item().

Code: [Select]

my @path_to_MC_field = (
    # list types
    [ 'Collection::DVD::CountryOfOrigin',                       'Country',                      \&add_list_item ],
    [ 'Collection::DVD::Genres::Genre',                         'Genre',                        \&add_list_item ],
    [ 'Collection::DVD::Audio::AudioTrack::AudioContent',       'Language',                     \&add_list_item ],
    [ 'Collection::DVD::Studios::Studio',                       'Studios',                      \&add_list_item ],

    # single value
    [ 'Collection::DVD::Format::FormatAspectRatio',             'Aspect Ratio',                 \&add_single_item ],
    [ 'Collection::DVD::Format::FormatVideoStandard',           'Video Standard',               \&add_single_item ],
    [ 'Collection::DVD::OriginalTitle',                         'Original Title',               \&add_single_item ],
    [ 'Collection::DVD::Rating',                                'MPAA Rating',                  \&add_single_item ],
    [ 'Collection::DVD::RatingSystem',                          'MPAA Rating Description',      \&add_single_item ],
    [ 'Collection::DVD::Title',                                 'Name',                         \&add_single_item ],
    [ 'Collection::DVD::Overview',                              'Description',                  \&add_single_item ],
    [ 'Collection::DVD::RunningTime',                           'Duration',                     \&add_single_item ],

Separate code routines are required to handle transformations to any data, or to handle values that are stored in XML attributes.

[sonata31]

For mediatypes we can create the field Media Support
UPC -> UPC
OriginalTitle -> Original Title
CountryOfOrigine -> Country
Subtitles.Subtitle -> Subtitles (field created)
Events.EvenType -> Watched (field created = Yes if Watched)

[MrC]

This new version 1.5 maps the above requested fields.  UPC, OriginalTitle, and CountryOfOrigin were already mapped in previous versions.

I've also added the channel mappings using the table below (5.1 was the only one being set in previous versions). Let me know if any of these need correcting.

        'Mono'                     => 1
        '2-Channel Stereo'    => 2
        '3.1'                        => 4
        '5.0'                        => 5
        'Dolby Surround'      => 5
        '5.1'                        => 6
        '5.1 (Matrixed 6.1)'   => 7
        '6.1 (Discrete)'         => 7
        '7.1'                        => 8

We're still not dealing with the multiple AudioTracks (currently only the first-found is used).

It is about 1/3 faster too.  The path_to_MC_field structure has changed (to a hash instead of an array), but the change is trivial and self-explanatory.

[sonata31]

What is the mapping of "MPA Rating Description"
Ok for channel mapping

For Media Support : one only is saved

[sonata31]

With Language : Exemple
French (Dolby Digital 5.1);English (DTS-HD Master Audio 5.1)

[sonata31]

What is the difference between "Composer" and "Music By"

[MrC]

What is the difference between "Composer" and "Music By"

Composer might be Mozart, but Music By would be the person who compiled, scored, or re-arranged the soundtrack.  These types of single value properties break down easily, and are to be used for your own needs, not pedantic categorization.  They are currently mapped as the same (via the dual mapping mentioned previously).

What is the mapping of "MPA Rating Description"

This is mentioned above.

With Language : Exemple
French (Dolby Digital 5.1);English (DTS-HD Master Audio 5.1)

You're saying you want to include the AudioFormat and AudioChannels with respective AudioContent (i.e. language) into the Langauge mapping per language?

For Media Support : one only is saved

There are three possibilities DVD, HDDVD, BluRay.  I only saw one set to "true" for a single DVD entry; the remaining ones are "false".  Are there entries where more than a single value is True?

[sonata31]

Composer might be Mozart, but Music By would be the person who compiled, scored, or re-arranged the soundtrack.  These types of single value properties break down easily, and are to be used for your own needs, not pedantic categorization.  They are currently mapped as the same (via the dual mapping mentioned previously).

This is mentioned above.

You're saying you want to include the AudioFormat and AudioChannels with respective AudioContent (i.e. language) into the Langauge mapping per language?
Yes

There are three possibilities DVD, HDDVD, BluRay.  I only saw one set to "true" for a single DVD entry; the remaining ones are "false".  Are there entries where more than a single value is True?
Yes

[MrC]

Here is version 1.6.

Changes:
    - AudioFormat and AudioChannels are now included in Language.
    - For Media Support, the following combinations were found; all combinations are now handled, including the CustomMediaType value:

      <Field Name="Media Support">BluRay; HD Disk</Field>
      <Field Name="Media Support">BluRay</Field>
      <Field Name="Media Support">DVD; BluRay; HD Disk</Field>
      <Field Name="Media Support">DVD; HD Disk</Field>
      <Field Name="Media Support">DVD; HDDVD</Field>
      <Field Name="Media Support">DVD</Field>
      <Field Name="Media Support">HD Disk</Field>
      <Field Name="Media Support">HDDVD; HD Disk</Field>

How did you define the Media Support type in MC (a list or a single value?)

[sonata31]

I defined "Media Support" as a string
What would be the advantage of defining such a list?

[MrC]

As a list type, you can add/delete individual items with list checkboxes, and in panes or categories views, items are automatically separated.  It's no big deal either way.

[sonata31]

For Actor : Example
Jennifer Garner (Sydney Bristow);....

[MrC]

I'll give these to you as:

   Jennifer Garner=Sydney Bristow; ...

This way, you can separate them more easily in MC for lists, etc..  Is that OK?  If so, the change is done.

[sonata31]

I'll give these to you as:

   Jennifer Garner=Sydney Bristow; ...

This way, you can separate them more easily in MC for lists, etc. much more easily.  Is that OK?  If so, the change is done.

It's OK

[sonata31]

For the saga to be grouped under Theater View we have to manage them as the series
In the Theater view they appear with the series, then they should be with movies

How do I change this behavior?

[sonata31]

Before an up-to-date of the library (import of a new file mpl) we must make a clear of the library to avoid double
The problem is that this empty all : audio, images and video
How to avoid this?

[MrC]

Here's version 1.7:

Changes:
1. Include charcter name with each Actor.
2. Some internal cleanups.

[sonata31]

Great, we can recover most of the information
The only problems remaining are those mentioned in my two previous posts

[MrC]

Before an up-to-date of the library (import of a new file mpl) we must make a clear of the library to avoid double
The problem is that this empty all : audio, images and video
How to avoid this?

It depends. 

If you are using DVD Profiler as your management tool, then you could delete all the video entries that were imported from DVD Profiler.  Detection of these records could be facilitated by adding a value such as "Converted to MC MPL from DVD Profiler XML on <date>" to some tag such as Comment.

I haven't checked, but didn't think MC would duplicate records for entries where Filename exists.  I thought the duplicates were only for those where no Filename exists.

If you're wanting to do a one-time import, and no longer use DVD Profiler, this shouldn't be an issue generally.

[MrC]

For the saga to be grouped under Theater View we have to manage them as the series
In the Theater view they appear with the series, then they should be with movies

How do I change this behavior?

Probably this question belongs in an MC 18 thread, where others can help you define views that suit your needs.  There will be more eyes there, and it won't pollute the essence of this DVD Profiler thread.

[sonata31]

It depends. 

If you are using DVD Profiler as your management tool, then you could delete all the video entries that were imported from DVD Profiler.  Detection of these records could be facilitated by adding a value such as "Converted to MC MPL from DVD Profiler XML on <date>" to some tag such as Comment.
I do not really understand how?

I haven't checked, but didn't think MC would duplicate records for entries where Filename exists.  I thought the duplicates were only for those where no Filename exists.

If you're wanting to do a one-time import, and no longer use DVD Profiler, this shouldn't be an issue generally.

I always use DVD Profiler to manage my movies, this for the following reasons:
- This is the only way to manage the movies that do not have a file on disk
- This is the only way to manage Collection Number

On the other hand my library is synced with my iPad, which allows me to prepare a session even if JRiver is not active

[sonata31]

It depends. 

If you are using DVD Profiler as your management tool, then you could delete all the video entries that were imported from DVD Profiler.  Detection of these records could be facilitated by adding a value such as "Converted to MC MPL from DVD Profiler XML on <date>" to some tag such as Comment.

I haven't checked, but didn't think MC would duplicate records for entries where Filename exists.  I thought the duplicates were only for those where no Filename exists.
I checked, that is what behavior

If you're wanting to do a one-time import, and no longer use DVD Profiler, this shouldn't be an issue generally.

[Mikkel]

Hi MrC,

I was wondering if this neat tool works for any person who has DVDProfiler and would like to merge it with the JRiver video collection?


Best regards,
Mikkel

[MrC]

It will read your DVD Profiler XML file* and create a file that MC can import.  This will update the entries in MC for the files that exist in both DVD Profiler and in MC, or import them if they do not already exist in MC.

DVD Profiler has a higher-level abstraction than MC.  It manages collections of things (such as multi-disc sets), whereas MC is file-oriented.  So the import will be somewhat lossy, but I tried to grab and use as much useful information as possible to store in the MCs records.

It would be useful to read through this thread, so you can understand what can and can't be done, and how to use the tool.

* Note: I do not use DVD Profiler, so don't know how the XML file is created.  It might be DVD Profiler's database file, or it might be that you need to export it.  So you'll have to follow-up on that.

[gschaben1]

MrC,
 This looks like it will do exactly what I've been hoping for (populating aspect ratio, cinematographer, editor, etc. fields), if I can get it work. When running the PERL script from a DVD Profiler .xml file of about 100 titles, the .mpl file is created, but is empty, except for
                 <?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
                 <MPL Version="2.0" Title="JRSidecar">
                </MPL>
So, no titles. Any ideas?
Thanks for all your work on this by the way.

[MrC]

I'm not sure what is going wrong, but you are correct, not titles are being output.  Can you PM me a zip'd XML file?

[gschaben1]

MrC,
 I don't seem to be able to add the attachment to PM, so I have attached it to this reply. Let me know if you need any further information.

[MrC]

That's fine, thanks.  See reply #61:

    http://yabb.jriver.com/interact/index.php?topic=78625.msg538482#msg538482

Use -a.