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

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

<< < (6/17) > >>

jmone:
FYI - the date format of Value 1 = 1/1/1970 so seems to be using Unix/POSIX/Epoch time in MC incremented by seconds

Edit - I notice if you stuff up a field value like "Date Imported" MC then shows in this field "not imported"

8139david:

--- Quote from: jmone on January 30, 2016, 05:05:00 am ---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?

--- End quote ---

I tried. Then I can see only a few tags, I suppose it categorize it as Data by default. So it seems problematic.
Even if I add a Media Type before hand, it just imports a playlist, without accompanying movie.

I tried all the options.
You get a sidecar only by Update Tags from Library, and this works only if you have an existing, non-empty dummy file.

Concerning your PS:
I tend to think like you.
But maybe you could add this as a 5th option?

Arindelle:

--- Quote from: jmone on January 30, 2016, 05:23:33 am ---...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?

--- End quote ---
thats terrific !... of course you'd need the same key, but if you create an external library from a restore originally, this would be the same .. I'l try to test later today

thanks this could be very cool for me

8139david:
Concerning edit first post:
Try it yourself, but I think you must be authenticated for update library from txt file to work.

Also, it would be nice if the name of the mpl file was more varied.
Thus, if toto.txt is taken as input, the output would be toto.mpl.
And if JRLibrary is exported, then it's given a unique name, eg JRLibrary-2016-01-39-13-49 (including date with hours, perhaps even seconds).

ferday:
Thanks for the effort jmone!

Navigation

[0] Message Index

[#] Next page

[*] Previous page