INTERACT FORUM
More => Old Versions => JRiver Media Center 19 for Windows => Topic started by: jelyon on May 12, 2014, 03:09:31 pm
-
Disclaimer: Searches on the boards haven't lead me to any helpful articles on the topic, but I'm willing to be directed/redirected as appropriate.
I've been messing around with custom tags, and I have some chart data in excel that I'd like to import into JRiver.
My basic understanding is that as long as the file path is in the playlist that you're importing, JRiver will update the tags when it imports the playlist.
But this has not been my experience.
I can get data out of JRiver just fine, and can do all the work in Excel, I guess I just need monkey notes that actually detail importing the data once it's ready.
TIA
-
Maybe this one: http://yabb.jriver.com/interact/index.php?topic=60993.0
-
I don't believe CSV is an importable playlist type. You have to convert it to MPL. I have a CSV -> MPL converter if that will help you.
The Filename column is the value that is used to match against MC entries, so it must be exact.
Maybe you can show a few lines of your spreadsheet.
-
@Vincent Kars - the link above. I now recall those conversations back in 2010.
This can be more readily automated. The grabbing of the chart data is easy enough, it it wouldn't be too much trouble matching the Artist / track Name to existing MC tracks and when there is a match, updating a field in MC directly. When there isn't an exact match, options could be presented for selecting the correct track using fuzzy matching, or the problematic results could be output for manual intervention.
-
You have a job to do :)
-
@MrC;
I think that CSV to MPL converter is the missing piece.
As far as the matching, that's pretty much done, and I did use a fuzzymatch plugin for Excel to match the artists. Though it strikes me I probably ought to do fuzzy match for song titles too :)
-
I think that CSV to MPL converter is the missing piece.
You'll need to install ActivePerl for your platform (32-bit (http://www.activestate.com/activeperl/downloads/thank-you?dl=http://downloads.activestate.com/ActivePerl/releases/5.16.3.1604/ActivePerl-5.16.3.1604-MSWin32-x86-298023.msi) or 64-bit (http://www.activestate.com/activeperl/downloads/thank-you?dl=http://downloads.activestate.com/ActivePerl/releases/5.16.3.1604/ActivePerl-5.16.3.1604-MSWin32-x64-298023.msi)). Let the installer modify your PATH variable, so you can find perl more easily later.
The csv2mpl script is the attached. Download, unzip and read the included README.txt file.