Windows > Third Party Plug-ins, Programs, and Skins
Guide: Data Fiddler (MC Library <-> Spreadsheet Import/Export/Update)
jmone:
Thanks for the testing and I'm glad it works! Given that the topic of how to manage a Off Line Media Collection in MC comes up from time to time, could I trouble you to write up a little Guide in this thread for future users?
Using Dummy Files: Before I ripped all my disks to HDD, I too used dummy files to get entries into MC... but now we can create entries without actual dummy files I've been pondering if it is worth the effort and complication at all, and it has some downsides. I've been just playing with dummy files and one of the issues is that MC will try to parse them to populate data fields (which will all be the same and not reflective of your actual library should you want to use these tags). Important things like Duration as well as technical details like Dimensions, FPS, Compression, Audio Tracks etc. These will all be wrong if you use Dummy Files.
If the only issue of NOT using dummy files is that "Update Tags from Library" will not work, I have a couple of suggestions:
- Instead of using Sidecar files, just select all the entries and use MC to create a MPL for them all
- I could make a MC Menu Item called "Update Tags from Library (with no file)" and it would create a sidecar for each of the selected (or all) items without a file path (or some other logic)
Also please let me know of any oddities or enhancements.
Thanks
Nathan
8139david:
Thanks, I will write this little guide, reusing some of my posts.
The added functionality you suggest would be nice.
Currently, JRiver allows you to export only your entire libraray as a mpl playlist.
So it would be great to export any selection, if desired with only some fields selected, as a mpl playlist.
And why not as a tabbed txt file too.
But maybe this is better integrated directly in JRiver?
Well, if you can partially add the functionality to Data Fiddler, it's great!
So that it can update the original mpl and txt files from the Library.
jmone:
Actually, you can already create a single MPL for just selected Items (but it is all fields minus the Key for some reason). Just highlight the ones you want then File--> Export Playlist then select:
- MPL
- Selection
If you want just the fields in you view (including FileKey), then use File--> Export Playlist then select:
- Text File (CSV)
- Only Visible Fields
- Selection
I'll think about the "Update Tags from Library (with no file)" option from within MC some more.... but it won't be for a couple of weeks as I'll be travelling soon. Also if the aim is to have a backup of the meta data, the better option is probably just to back up the library itself!
jmone:
--- Quote from: 8139david on January 31, 2016, 02:59:14 am ---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
--- End quote ---
...and as with all my Utils, I post both the compiled versions and the script itself. Feel free to edit the script as you please but be warned there is little (if any) notes in the scripts as I'm way to slack (though it makes it hard for me to remember why I'm doing stuff a couple of months later!)
8139david:
You're right. I had missed the option of exporting a mpl playlist for a selection.
I had seen the various options for csv. (Why not offer all of them for mpl export, in JRiver?)
Good travels!
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version