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.
)
