Windows > Third Party Plug-ins, Programs, and Skins
Guide: Data Fiddler (MC Library <-> Spreadsheet Import/Export/Update)
jmone:
Example: Updating a System Field (Date Imported). It's hard to update a System Field in MC such as "Date Imported". Here is an example of how to do it. In Excel, create a spreadsheet with just three columns as follows and enter the following data and formulae.
Use Format Cells--> Date on Col C so you can enter a Human Readable date format. Col B should remain as a Format Cells--> General but just past in the formulae "=(C2-25569)*86400" which will the convert the Excel Date Format to Epoc Date and it will be "1454284800" in this case.
A B C
Key Date Imported New Date
12345 =(C2-25569)*86400 1/02/2016
etc
etc
Save as a Unicode/Tab Delimited TXT File and use Data Fiddler to "Update MC Library" and the new date(s) will be set for those (file)Key. There is no need to delete Col C as it will be ignored given it does not match any existing MC Library Field
jmone:
--- Quote from: jmone on January 31, 2016, 11:47:02 pm ---
If editing the TXT file, you can added/remove {CR}{LF}{TAB} as needed
Let me know of any other "weird" characters that cause issues.
--- End quote ---
Ugg the joy of different progs and formats... FYI - Unlike a plain text editor, it seems Excel likes to add extra " marks around a value if you try to use " in the value (so you end up with multiple " in the TXT file that then updates MC.). It also can drop a ' at the beginning of a value
Arindelle:
@8139david
careful with messing with system fields Date Imported is one that can get tricky. There is a new expression tha will aloow you to port over the coded system field to a more useable date string
You seem to be just getting started with JRiver, so not meaning to sound condescending, but I have had some problems messing with system fields in the past .. best to leave them alone and use custom fields IMHO. This is getting into some pretty advanced stuff here
here's an example of what I'm referring to for date imported http://yabb.jriver.com/interact/index.php?topic=86834.msg713807#msg713807
PS why not rip at least the audio cds of yours?? seems to defeat the purpose a bit, no?
8139david:
@Arindelle
The system fields is entirely jmone's idea: so he should be warned, not me :)
Some don't have the time to rip all their cds, but they might want to catalog them.
Arindelle:
--- Quote from: 8139david on February 01, 2016, 03:59:39 am ---@Arindelle
The system fields is entirely jmone's idea: so he should be warned, not me :)
--- End quote ---
oh I'm sure Jmone knows all about it - he knows more about it than I do ... he's one of JRiver's Yodas
--- Quote from: Jmone ---- *BEWARE* it WILL change or add stuff to your Library and there is no "Undo".... so backup your Library before you modify it.
--- End quote ---
just trying to help. Its a third party plugin .. sort of like jail breaking an iphone :) Powerful stuff, so a heads up to you is all.
Have fun with it.
@Nathan, I've got a cool 15 field template set up ... seems to work well. Thanks for the effort
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version