| Author |
 Topic  |
|
|
yan00s
Moderator
405 Posts |
 Posted - 18 Nov 2012 : 19:37:24
|
I'm trying to create a nfo export template I may be able to use together with jRiver Media Center so I can add all the info collected within XMM to my Media Library there.
(1) SOLVED Minor Bug (which doesn't really affect me right now): when using "Add this string before extension" in the export dialog like this:
_SomeText_
I end up with an .nfo file named like this:
MovieFileNameWithoutExtension.x_SomeText_.nfo
where x is the first letter of the original files' extension.
(2)
The basic structure of jRiver sidecar xml files looks like this (contains custom fields):
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<MPL Version="2.0" Title="JRSidecar">
<Item>
<Field Name="Filename">[...]\C\Chameleon (1998)\Chameleon (1998).avi</Field>
<Field Name="Rating">2</Field>
<Field Name="Producer">Bennett Cohen; Brian Burgess; Jeff Henry; Michael Lake</Field>
<Field Name="Music By">Wendy Blackstone</Field>
<Field Name="Places">Filming Location: Queensland, Australia</Field>
<Field Name="Compression">avi video (video: XVID, audio: mp3)</Field>
<Field Name="Original Title">Chameleon</Field>
<Field Name="Bitrate">[...]</Field>
<Field Name="Catalogue ID">1971</Field>
<Field Name="Bit Depth">16</Field>
<Field Name="Country">Australia; United States</Field>
<Field Name="Language">English</Field>
<Field Name="Screenwriter">Bill Butler</Field>
<Field Name="Genre Subcategory">Action; Sci-Fi</Field>
<Field Name="Collection Media">HDD</Field>
<Field Name="Genre">Drama</Field>
<Field Name="IMDb ID">tt0174543</Field>
<Field Name="Actors">Bobbie Phillips; Eric Lloyd; Anthony Simcoe; Philip Casnoff</Field>
<Field Name="FPS">23,9760400000000012</Field>
<Field Name="Director">Stuart Cooper</Field>
<Field Name="Collection Status">transfered</Field>
<Field Name="Stack Top">-1</Field>
<Field Name="Notes">Not reviewed yet.</Field>
<Field Name="Channels">2</Field>
<Field Name="Description">A super-killer female cyborg with chameleon-like powers discovers maternal instincts when she protects a child [shortened for readability].</Field>
<Field Name="Tag Line">Saving a Boy</Field>
<Field Name="Keywords">Boy; Cyborg; Guarding a Boy</Field>
<Field Name="Media Sub Type">Movie</Field>
<Field Name="Stack View">0</Field>
<Field Name="Cinematographer">John Stokes</Field>
<Field Name="Studios">Wilshire Court Productions</Field>
<Field Name="Gross Revenue">??</Field>
<Field Name="Distributor">United Paramount Network (UPN)</Field>
<Field Name="Comment">Not yet commented on</Field>
<Field Name="Date">36090</Field>
<Field Name="Name">Chameleon</Field>
<Field Name="Sample Rate">48000</Field>
<Field Name="Get Metadata Info"><XMLPH version="1,0">
<Item Name="LastFailedDate"/>
</XMLPH></Field>
<Field Name="Critic Rating">7,5 / 10</Field>
<Field Name="Duration">5349</Field>
<Field Name="Catalog #">1971</Field>
</Item>
</MPL>
Since a few values are up to jRiver to create (like media specific stuff) I'm trying to create an additional file I can later merge into jRivers sidecar file. What makes it difficult is:
- I would need different separators (semicolon instead of comma)
- I want to keep multiple values (like language, producers and other people information, countries) so jRiver can pick those up as single values too.
- I need proper utf8 support
A test with this template:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<MPL Version="2.0" Title="JRSidecar">
<Item>
<Field Name="Filename">_MOVIE_MOVIEFILE1_</Field>
<Field Name="Rating">_MOVIE_PERSONALRATING_</Field>
<Field Name="Producer">_MOVIE_PRODUCER_</Field>
<Field Name="Music By">_MOVIE_MUSIC_</Field>
<Field Name="Original Title">_MOVIE_ORIGINALTITLE_</Field>
<Field Name="Catalogue ID">_MOVIE_ID_</Field>
<Field Name="Country">_MOVIE_COUNTRY_</Field>
<Field Name="Language">_MOVIE_LANGUAGE_</Field>
<Field Name="Screenwriter">_MOVIE_WRITER_</Field>
<Field Name="Genre Subcategory">_MOVIE_SUBGENRE_</Field>
<Field Name="Collection Media">_MOVIE_MEDIA_</Field>
<Field Name="Genre">_MOVIE_GENRE_</Field>
<Field Name="IMDb ID">tt _IMDB_IDONLY_</Field>
<Field Name="Director">_MOVIE_DIRECTOR_</Field>
<Field Name="Collection Status">_MOVIE_STATUS_</Field>
<Field Name="Notes">_MOVIE_COMMENT_</Field>
<Field Name="Description">_MOVIE_PLOT_</Field>
<Field Name="Tag Line">_MOVIE_TAGLINE_</Field>
<Field Name="Cinematographer">_MOVIE_PHOTOGRAPHER_</Field>
<Field Name="Studios">_MOVIE_STUDIO_</Field>
<Field Name="Gross Revenue">_MOVIE_REVENUE_</Field>
<Field Name="Distributor">_MOVIE_DISTRIBUTOR_</Field>
<Field Name="Name">_MOVIE_TITLE_</Field>
<Field Name="Catalog #">_MOVIE_CDBOXID_</Field
<Field Name="Actors">
<!--BEGIN_ACTORS-->
_MOVIE_ACTORS_NAME_;
<!--END_ACTORS-->
</Field>
</Item>
</MPL>
just brought me:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<MPL Version="2.0" Title="JRSidecar">
<Item>
<Field Name="Filename">[...]\C\Chameleon (1998)\Chameleon (1998).avi</Field>
<Field Name="Rating">0</Field>
<Field Name="Producer">Brian Burgess, Bennett Cohen, Jeff Henry, Michael Lake</Field>
<Field Name="Music By">Wendy Blackstone</Field>
<Field Name="Original Title">Chameleon</Field>
<Field Name="Catalogue ID">1971</Field>
<Field Name="Country">USA Australia</Field>
<Field Name="Language">English</Field>
<Field Name="Screenwriter">Bennett Cohen</Field>
<Field Name="Genre Subcategory">Action</Field>
<Field Name="Collection Media">NAS</Field>
<Field Name="Genre">Drama</Field>
<Field Name="IMDb ID">tt _IMDB_IDONLY_</Field>
<Field Name="Director">Stuart Cooper</Field>
<Field Name="Collection Status">23</Field>
<Field Name="Notes">Bobbie Phillips Saved the Show<br><br> Bobbie Phillips made the day for this movie. She portrayed smart, strong, sexy Kam projecting her quite [shortened for readability] shows.<br><br></Field>
<Field Name="Description">A super-killer female cyborg with chameleon-like powers discovers maternal instincts when she protects a child from government operatives in this science fiction tale set in the year 2028. </Field>
<Field Name="Tag Line"></Field>
<Field Name="Cinematographer">John Stokes</Field>
<Field Name="Studios">Wilshire Court Productions</Field>
<Field Name="Gross Revenue"></Field>
<Field Name="Distributor">Argentina Video Home CIC V#966;deo RTL Klub Telev#966;zi#8804; United Paramount Network (UPN)</Field>
<Field Name="Name">Chameleon</Field>
<Field Name="Catalog #">1971</Field
<Field Name="Actors">
Eric Lloyd;
Bobbie Phillips;
John Adam;
... shortened for readability ...
</Field>
</Item>
</MPL>
UPDATE 12-12-15: Fixed (2.1) Even so I had "Clear all HTML Tags from Text" checked, it didn't seem to work (see <br> -tags marked red.
(2.2) UTF8? No way - see distributors (also note that they are not separated at all even so those are actually three different distributors).
NOTE 12-12-15: There's still the "good ole UTF8" issue. Since the values are correct in the database it must be the export conversion.
(2.3) Multiple value fields (in this example only producers) are separated with , ... I would need a ;
The latter could be achieved if I could choose a field separator in the export dialog.
UPDATE 12-12-15: custom entry separator works for fields constructed out of multiple data rows (like people), but not for multiple values stored in a single field (separated by | in XMM db ... like countries).
(2.4) UPDATE 12-12-15: Solved thru the new "_MOVIE_ALL_ACTORS_NAME_" value What's kinda dirty are all those empty lines between the actors. It would make merging the files later on (jRiver xml + nfo from XMM) more difficult.
Of course my dream would be to have an export tool within XMM, that reads (!) and writes jRiver Sidecar files directly and enables a field mapping. It might even be a fine argument for the marketing department  . Since dreams won't come true in 2 out of 3 cases, I would like to have the issues addressed I did mention above - maybe with an updated (?) wiki reference on how to handle it. Pretty please.
-
edit (forgot to wish for it too): My purpose would also require a file naming convention matching that of jRiver, which is
MovieFileNameBeforeextension_Extension_JRSidecar.xml
--
Post updated to reflect 8.0.3.4 improvements / additions. |
. |
Edited by - yan00s on 15 Dec 2012 18:03:44 |
|
|
yan00s
Moderator
405 Posts |
Posted - 12 Dec 2012 : 02:43:00
|
Bump. 
Can something be done about this?
I take no for an answer, too. Then I'd know that I've to find a different way to get my data into jRiver... |
. |
 |
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
|
tdemis
Starting Member
5 Posts |
Posted - 13 Dec 2012 : 22:51:04
|
I ve experimented myself too with this feature in the past with EMM 7
Yes the auto export tool for jriversidecar.xml is an excellent idea but it will only contain the default library fields of Jriver.Since we can make custom fields in jriver I think it is better to do it manually with our own .nfo template from EMM 8
For example this is the nfo template i ve used for EMM 7 (i dont know how much have changed in version 8,I will experiment again)
this contains pretty much everything for movie information and contains custom tags also
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<MPL Version="2.0" Title="JRSidecar">
<Item>
<Field Name="Filename"><![CDATA[_MOVIE_MOVIEFILE1_]]></Field>
<Field Name="MPAA Rating"><![CDATA[_MOVIE_MPAA_]]></Field>
<Field Name="Producer"><![CDATA[_MOVIE_PRODUCER_]]></Field>
<Field Name="Music By"><![CDATA[_MOVIE_MUSIC_]]></Field>
<Field Name="Compression"><![CDATA[_MOVIE_VIDEOMODE_ (video: _MOVIE_MEDIA_, audio: _MOVIE_AUDIOFORMAT_)</Field>
<Field Name="Original Title"><![CDATA[_MOVIE_ORIGINALTITLE_]]></Field>
<Field Name="Bitrate"><![CDATA[_MOVIE_BITRATE_]]></Field>
<Field Name="Country"><![CDATA[_MOVIE_COUNTRY_]]></Field>
<Field Name="Language"><![CDATA[_MOVIE_LANGUAGE_]]></Field>
<Field Name="Screenwriter"><![CDATA[_MOVIE_WRITER_]]></Field>
<Field Name="Genre"><![CDATA[_MOVIE_GENRE_;_MOVIE_SUBGENRE_]]></Field>
<Field Name="Genres"><![CDATA[_MOVIE_GENRE_;_MOVIE_SUBGENRE_]]></Field>
<Field Name="FPS"><![CDATA[_MOVIE_FPS_]]></Field>
<Field Name="Director"><![CDATA[_MOVIE_DIRECTOR_]]></Field>
<Field Name="Decription"><![CDATA[_MOVIE_PLOT_]]></Field>
<Field Name="Cinematographer"><![CDATA[_MOVIE_PHOTOGRAPHER_]]></Field>
<Field Name="Media Sub Type">Movie</Field>
<Field Name="Studios"><![CDATA[_MOVIE_STUDIO_]]></Field>
<Field Name="Distributor"><![CDATA[_MOVIE_DISTRIBUTOR_]]></Field>
<Field Name="Budget"><![CDATA[_MOVIE_CUSTOMFIELD5_]]></Field>
<Field Name="Name"><![CDATA[_MOVIE_TITLE_]]></Field>
<Field Name="Sample Rate"><![CDATA[_MOVIE_SRATE_]]></Field>
<Field Name="Channels"><![CDATA[_MOVIE_CHANNELS_]]></Field>
<Field Name="Duration"><![CDATA[_MOVIE_LENGTH_ sec]]></Field>
<Field Name="Copyright"><![CDATA[_MEDIA_YEAR_]]></Field>
<Field Name="Date (year)"><![CDATA[_MOVIE_YEAR_]]></Field>
<Field Name="Plot"><![CDATA[_MOVIE_CUSTOMFIELD11_]]></Field>
<Field Name="Dimensions"><![CDATA[_MOVIE_RESOLUTION_]]></Field>
<Field Name="Gross Revenue"><![CDATA[_MOVIE_CUSTOMFIELD6_]]></Field>
<Field Name="Nominations"><![CDATA[_MOVIE_CUSTOMFIELD7_]]></Field>
<Field Name="IMDBrating"><![CDATA[_MOVIE_RATED_]]></Field>
<Field Name="Comment"><![CDATA[_MOVIE_COMMENT_]]></Field>
<Field Name="Rating"><![CDATA[_MOVIE_PERSONALRATING_]]></Field>
<Field Name="Tag Line"><![CDATA[_MOVIE_TAGLINE_]]></Field>
<Field Name="TrailerURL"><![CDATA[_MOVIE_TRAILERFILE1_]]></Field>
<Field Name="Web Media Info"><![CDATA[_MOVIE_OFFICIALWEB_]]></Field>
<Field Name="Awards"><![CDATA[_AWARDS_]]></Field>
<Field Name="Web Media URL"><![CDATA[_MOVIE_WEBLINK_]]></Field>
<Field Name="Release Dates"><![CDATA[_MOVIE_CUSTOMFIELD2_]]></Field>
<Field Name="Goofs"><![CDATA[_MOVIE_CUSTOMFIELD10_]]></Field>
<Field Name="Web Media Search"><![CDATA[_MOVIE_CUSTOMFIELD8_]]></Field>
<Field Name="Editor"><![CDATA[_MOVIE_CUSTOMFIELD3_]]></Field>
<Field Name="Top250"><![CDATA[_MOVIE_CUSTOMFIELD1_]]></Field>
<Field Name="Aspect Ratio"><![CDATA[_MOVIE_SCREENRATIO_]]></Field>
<Field Name="Name"><![CDATA[_MOVIE_TITLE_]]></Field>
<Field Name="Actors">
<!--BEGIN_ACTORS-->
_MOVIE_ACTORS_NAME_;
<!--END_ACTORS-->
</Field>
</Item>
</MPL>
|
Edited by - tdemis on 13 Dec 2012 22:53:05 |
|
|
|
yan00s
Moderator
405 Posts |
Posted - 14 Dec 2012 : 00:10:24
|
Hi Ale,
here's a copy of the xml jRiver creates for movies with the most used fields.
Note: It's possible to create custom fields in jRiver MediaCenter. In the example, I've marked my custom fields blue.
Example:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<MPL Version="2.0" Title="JRSidecar">
<Item>
<Field Name="Filename"> ... path to ... \Chameleon (1998).avi</Field>
<Field Name="Rating">2</Field>
<Field Name="Producer">Bennett Cohen; Brian Burgess; Jeff Henry; Michael Lake</Field>
<Field Name="Music By">Wendy Blackstone</Field>
<Field Name="Places">Filming Location: Queensland, Australia</Field>
<Field Name="Compression">avi video (video: XVID, audio: mp3)</Field>
<Field Name="Original Title">Chameleon</Field>
<Field Name="Bitrate">1094</Field>
<Field Name="Catalogue ID">1971</Field>
<Field Name="Bit Depth">16</Field>
<Field Name="Country">Australia; United States</Field>
<Field Name="Language">English</Field>
<Field Name="Screenwriter">Bill Butler</Field>
<Field Name="Genre Subcategory">Action; Sci-Fi</Field>
<Field Name="Collection Media">HDD</Field>
<Field Name="Genre">Drama</Field>
<Field Name="IMDb ID">tt0174543</Field>
<Field Name="Actors">Bobbie Phillips; Eric Lloyd; Anthony Simcoe; Philip Casnoff</Field>
<Field Name="FPS">23,9760400000000012</Field>
<Field Name="Director">Stuart Cooper</Field>
<Field Name="Collection Status">transfered</Field>
<Field Name="Stack Top">-1</Field>
<Field Name="Notes">Not reviewed yet.</Field>
<Field Name="Channels">2</Field>
<Field Name="Description">A super-killer female cyborg with chameleon-like powers discovers maternal instincts when she protects a child from government operatives in this science fiction tale set in the year 2028.</Field>
<Field Name="Tag Line">Saving a Boy</Field>
<Field Name="Keywords">Boy; Cyborg; Guarding a Boy</Field>
<Field Name="Media Sub Type">Movie</Field>
<Field Name="Stack View">0</Field>
<Field Name="Cinematographer">John Stokes</Field>
<Field Name="Studios">Wilshire Court Productions</Field>
<Field Name="Gross Revenue">??</Field>
<Field Name="Distributor">United Paramount Network (UPN)</Field>
<Field Name="Comment">Not yet commented on</Field>
<Field Name="Date">36090</Field>
<Field Name="Name">Chameleon</Field>
<Field Name="Sample Rate">48000</Field>
<Field Name="Get Metadata Info"><XMLPH version="1,0">
<Item Name="LastFailedDate"/>
</XMLPH></Field>
<Field Name="Critic Rating">7,5 / 10</Field>
<Field Name="Duration">5349</Field>
<Field Name="Catalog #">1971</Field>
</Item>
</MPL>
All the file / codec related information is not important here since jRiver MC handles this perfectly well.
For Series / Episodes (and Music) there are additional tags. Here's an overview:
Is there a current list of available fields for NFO generation? I could try to draft a mapping table then.
|
. |
|
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
|
yan00s
Moderator
405 Posts |
Posted - 14 Dec 2012 : 19:58:18
|
quote:
Originally posted by Alessio Viti
What about the Pictures? I mean Covers, Photos, Fanarts? I would like to make the export as much complete as possible.
Ale
To my current knowledge the already existing function to copy existing covers (and fanart) to the movie file location will be sufficient.
I have to investigate how fanart stuff works because currently I do not use this in jRiver.
Also I'm not aware of a function to display people photos for movies in jRiver so this is not relevant (yet), too. I will ask about this at jRiver and report back. Since it would require a separate export to work sufficiently it shouldn't matter much right now. |
. |
|
|
|
yan00s
Moderator
405 Posts |
Posted - 15 Dec 2012 : 21:53:07
|
In addition to the issues mentioned in my edited initial post here are yet a few more (minor) thingies not working correctly:
<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<MPL Version="2.0" Title="JRSidecar">
<Item>
...
<Field Name="Producer">Brian Burgess;Bennett Cohen;Jeff Henry;Michael Lak</Field>
<Field Name="Music By">Wendy Blackston</Field>
...
<Field Name="Screenwriter">Bennett Cohe</Field>
...
<Field Name="Director">Stuart Coope</Field>
...
<Field Name="Cinematographer">John Stoke</Field>
...
<Field Name="Catalog #">1971</Field
<Field Name="Actors">Eric Lloyd;Bobbie Phillips;John Adam;Jerome Ehlers;Nicholas Bell;Anthony Simcoe;Philip Casnoff;Mark Lee;Inge Hornstra;Antony Neate;Frederick Miragliotta;Frank Whitten;Laurie Foell;Cormac Costello;Tara Jakszewicz;Mick Roughan;Gavin Coleman;Arthur Hoadley;Bob Bowles;Josef Schwaiger;Neil Fanning;Angela Moore;Michael Corrigan;Darren Andrew Mitchell;John Fogwell;Scott O'Donnell;Joanne Fraser;Brit Sooby;Ryan Morgan;Chris Hargreaves;Vic Wilson;Mick Van Moorsel;Robin Menzies;Yasca Sinigaglia;Darce Florio;</Field>
</Item>
</MPL>
FIXED with 8.0.3.6 [1] The last letter of the name gets cut off for all the people (except acors). If there are more than one it only happens with the last entry (see producers) 
FIXED with 8.0.3.6 [2] For the Catalog # NFO field the closing > tag is missing.
[3] After the last actor entry, there is no need for another ; (but that's really really minor)
---
A thought: since there are yet a few other issues to solve I'd suggest not to spent too much time with this stuff. Me can wait for perfection regarding jRiver sidecar files for a while.
As long as there's no full unicode / utf-8 support the function is of limited use anyway. |
. |
Edited by - yan00s on 21 Dec 2012 05:36:00 |
|
|
|
Alessio Viti
Forum Admin
Italy
9171 Posts |
|
| |
Topic |
|
NFO Export: Issues with custom template
)