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

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

<< < (5/17) > >>

8139david:

--- Quote from: jmone on January 30, 2016, 04:55:13 am ---Excellent!  On the "backup" you can always just export it as an MPL as it is the same thing.

--- End quote ---
You're right! Thanks!

jmone:
Thanks - Updated the OP re: Library Server

Also, can you test (as with my net down I can not).  If you populate the "Filename" field in a TXT file with unique data like "C:\MyDummyMovies\Movie1.MKV" (even though it does not exist) and import via a MPL with Data Fiddler, can you then create a side car file in that folder (the folder will need to exist)?

PS - I could also make Data Fiddler to auto import the MPL file (so you don't have to do it manually) but I'm wary without a user eye balling it first.  What do you think?

Arindelle:

--- Quote from: jmone on January 30, 2016, 04:44:12 am ---Nope, no need for an actual dummy file at all.

...in other words, create a Tab Delimited file (from say Excel) with all the fields (and corresponding data) you want populated, and then use Data Fiddler to create the MPL that you can then check and import.

Once it is in MC, you can then do all the "normal" stuff like Get TV and Movie Info but play the file and it will add the extra Meta Data.

The only think I'm not sure off is how the Coverart will be saved (as we have had a storm and my main Internet is down so hard to test!)

--- End quote ---
hmm just thinking out loud, as I haven't had the chance to try this, lets say I want to ONLY update certain fields for existing media .... are you saying that if I export a spreadsheet, and only want to bulk overwrite two fields, I'm assuming that I would NOT remove any of the other fields data and just update the two fields correct? If the other fields were removed, I assume it will nuke whats in them? or will it just update what is on the spreadsheet.

I'm asking that because
--- Quote ---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 the MPL and TXT files use "Key".

--- End quote ---
If the filekey is present in the spreadsheet could for example could it be possible to create say a 10 field template to share update/metadata? Is this "filekey" acting as a Unique record ID? Thinking if this could be a tool to sync metadata between non networked libraries/media files

Also, I was thinking of creating non-system Unique IDs by "track/album") -- there are posts on this in the forum, already, but using excel to populate this then reimport could be a pretty neat solution.

oh BTW -- what happens with system fields -- is this a way to overwrite ones that you normally can't (like date imported?)

jmone:
...so it will update only the fields that are present in the spreadsheet and will leave the rest as they are :)

The issue with updating another library is that the file key will need to also exist and match as it will update the data for a file key on whatever library you are connected to. If the filekey on this other library is not the same you will push data into it's fields that will not correspond.  The update function will not create an entry if it does not exist, it just updates one that does... Does that make sense?

jmone:
...and just tested on the System Field "Date Imported" and I could update it just fine!  No idea on the data format however (I just cut and past from other file... the value I used in the spreadsheet was "139493357" and MC now shows it as 16/03/2014).

Navigation

[0] Message Index

[#] Next page

[*] Previous page