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

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

<< < (12/17) > >>

jmone:
Yup - you could mass update "unintended" data easily (esp with any Non Editable Field in MC's GUI) so always backup your library first.  Keep in mind that as it is a published I/F, MC "knows" what you are doing and hence your risk is low on actually corrupting the MC DB itself.  The worst is you roll back to your last DB backup to reverse any unintended changes (FYI - I've been in SI for a long time, when modifying data using the API calls is pretty OK... directly modifying the underling DB, now that can be risky!).

On updating the Date Imported there are valid reasons (eg if you imported with a bad system clock).  My example was more to show how to covert from a Human Readable date format to that used by MC.  The same Method could be used to change any of the Date fields.

Arindelle, I'd be interested to hear what your template does (as others would I'm sure) and if there are any tweaks I need to make.

8139david:
By the way, JRiver assigns a duration of 0 seconds to the "dummy" movies (without dummy files) I import using Data Fiddler.
And Get Movie Information (with overwrite information) doesn't change that.
Indeed, as might have been expected, all the fields which would be read from a real video file are gray and <empty> on the Tag pane.

8139david:

--- Quote from: jmone on January 30, 2016, 04:03:47 am ---- New: Added the ability to Update MC from a Tab Delimited TXT File
Updating Items in MC from a Spreadsheet:  You can now use any editor that can create a "Tab Delimited Text File" (just about anything but in particular Excel for most) and use it to update a MC Library directly. 

1. Create Your Spreadsheet (see pic) - Make sure in each cell the First Row (the Header Row) contains valid "MC Library Field" name that you want to CHANGE (non-MC Library Field names will be ignored by MC).  One of the Fields MUST be labeled "Key" and have the "FileKey" reference shown in MC.  This is an oddity, MC shows it in it's GUI as "FileKey", but Media Center Web Services (MCWS) use "Key" and hence so does the MPL and TXT files.
Add you data for each item you want to modify in the rows below.
2. Save Your Spreadsheet as a Tab Delimited Txt File
3. Run MC Data Fiddler and select "WriteInfo : Update MC Library from Tab Delimited TXT File" and when prompted select the file you created in Point 2.  Your Data should then be updated in the MC Library (see pic)

*** WARNING *** - Be careful, backup your library first as there is no Undo if something goes wrong.  Try a small update first.

--- End quote ---
I'm trying to use this function.
I've created a txt file (attached). But when I run DataFiddler, I get the error message on the attached image.
What should I do/try?

Arindelle:
should look something like this


in a spreadsheet program try saving as a *.CSV text file. Use the semi-colon as the field delimiter. JRiver uses the ";" as its default separator

you just have a text file in columns here. It can't parse anything

jmone:
Hi David, thanks for the data file.  I'll have a look and get back to you, it could be the treatment of the "-", "é", "è", "ç" characters but I'll need to test.  The rest of it looks OK to my eyes.  Try breaking the file into a couple of batches and see how that goes.  I should be able to test properly this weekend however.
Thanks
Nathan

Navigation

[0] Message Index

[#] Next page

[*] Previous page