Windows > Third Party Plug-ins, Programs, and Skins

Guide: Data Fiddler (MC Library <-> Spreadsheet Import/Export/Update)

<< < (7/17) > >>

jmone:
Update: 31JAN16
- Changed: When Files are Created the FileName will be appended with a DateStamp in the format of YYYYMMDDHHSS (24 hour) as well use the input file name where appropriate.
- Changed: The MPL playlist header is "MC Fiddler Import YYYYMMDDHHSS" so MC will see each as a unique import (else it would ignore the import) and you can now see what was imported each time in the MC --> Playlist --> Imported Playlists.

Also, Updated the OP with David's observations regarding Authentication must be on for the update library feature to work.

8139david:
Many thanks again, jmone!!!
I'll try the new version tomorrow.

jmone:
Update: 31JAN16a
- Changed: Updated the OP Instructions and the two example posts
- Changed: Updated the layout and working of the Main Menu
- Added: Added the option to import the MPL directly into MC once created from a TXT file
- Fixed: Updated the parser to handle blank lines in data sets  better (normally at the end of files)

8139david:
Very nice work!

Here are two pics for the function 'Create/Import a MC playlist (from text file)'.
I first ran it with essai.txt (with dummy vob files in the folder), then with essai2.txt (without dummy files).
As discussed, dummy files are not needed, unless one insists on creating later corresponding sidecars.

essai.txt
Name   Filename   Director   Media Type   Media Sub Type   toto   tutu
Movie61   Movie61.vob   A B   Video   Movie   a   b
Movie71   Movie71.vob   C D   Video   Movie   x   y

essai2.txt
Name   Director   Media Type   Media Sub Type   toto   tutu
Movie161   A B   Video   Movie   a   b
Movie171   C D   Video   Movie   x   y

The MC playlist obtained from essai2 is essai_2_20160131092341.mpl:

--- Code: ---<?xml version="1.0" encoding="UTF-8" standalone="yes" ?>
<MPL Version="2.0" Title="MC Fiddler Import 20160131092341" PathSeparator="\">
<Item>
<Field Name="Name">Movie161</Field>
<Field Name="Director">A B</Field>
<Field Name="Media Type">Video</Field>
<Field Name="Media Sub Type">Movie</Field>
<Field Name="toto">a</Field>
<Field Name="tutu">b</Field>
</Item>
<Item>
<Field Name="Name">Movie171</Field>
<Field Name="Director">C D</Field>
<Field Name="Media Type">Video</Field>
<Field Name="Media Sub Type">Movie</Field>
<Field Name="toto">x</Field>
<Field Name="tutu">y</Field>
</Item>
</MPL>
--- End code ---
The fields "toto" and "totu" are created in the playlist BUT they are not imported in JRiver's library, since they do not correspond to existing fields.

Since Movie 161 and Movie 171 are already tagged as Video and Movie, one can do immediately a "Get Movie & TV Show information".
Otherwise, one would have to specify manually in JRiver first their Media Type "Video", then their Media Sub Type "Movie", before being able to Get Movie Information.

8139david:
Here is some basic information about AutoHotkey, which was used to make the script and the Windows exe program:
https://autohotkey.com/
'AutoHotkey (AHK) is a free, open-source macro-creation and automation software for Windows that allows users to automate repetitive tasks. It is driven by a scripting language that was initially aimed at providing keyboard shortcuts, otherwise known as hotkeys, that over time evolved into a full-fledged scripting language.'
See also https://autohotkey.com/docs/Tutorial.htm and https://en.wikipedia.org/wiki/AutoHotkey

Navigation

[0] Message Index

[#] Next page

[*] Previous page