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

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

<< < (15/17) > >>

jmone:
David - glad it works!  had me stumped for a bit as well :) I had no idea the call needed more than one field.

Arindelle - no probs.  My script breaks the text file into fields by TAB delimited so I'd be surprised if anything else works (as it would be just part of the the data to be imported into MC).

Ferdi:
@Jmone - thanks, this utility is great fun to work with and helped me to finally enhance my collection of classical music!
Combining the downloaded library file with a data base of composers and the era they were active, I can now browse much my collection by era like Baroque, Renaissance etc. Love it!
I found two quirks with the program:

* Update of fields in MC: In my local CSV, I maintain the composers data as, for example, "Georges Bizet (1838–1875)". When uploaded to MC, this is changed to "Georges Bizet (1838 311875)". This is easily fixed in MC itself (find/replace on the 'composer' fiel), so no big concern. Curious though why that would happen.
* Special characters: the downloaded library text file can not handle special characters, in particular letters that are often used in other languages. In the world of classical music, names that contain such characters are quite commen (e.g., Frédéric Chopin, Antonín Dvořák). I haven't figured out how to deal with these entries during download and upload. Probably by living by the 80/20 rule and be happy with what I have :)
Again - great tool, and I already have many other ideas how I can now enhance my library!

jmone:
Thanks for the feedback.  I know...


--- Quote ---- It does not handle some extended characters sets well, so keep an eye on your files
--- End quote ---

...but I've not had the time to go through to find a better way of handling extended character (for example your "-" is probably a long dash or "Unit Separator" symbol not a minus sign).  One day... maybe :)

Nathan

jmone:
Update: 14AUG16

Updated the OP with an new version that should handle Unicode chars better.  Please let me know of any issues esp if the Unicode chars are now working correctly.

Notes on Changes:
- Will now work with just one Field (needed at least two previously)
- Better support for Unicode Characters
- Better support for handling commas in a field
- If you make a field blank in an Update it will now make that field blank in MC (instead of ignoring it)
- Added a CheckBox in the Menu to only Export items that are Selected in the MC Menu (instead of the Whole Library)


"Export the Library From MC (Creates TXT File)" : This will download the MC Library (in UTF-8) format then ask if you want to create a TXT Files (with a UTF-16 Header so it will open in Excel Correctly).  You should be able to just drag this TXT file into Excel for editing and it will be recognised as a "Unicode" File.  When you save in Excel you should see a MSG saying "Some features in your workbook might be lost if you save it as Unicode Text, Do you want to keep using that format".  The answer is Yes.

Creating a Blank Spreadsheet : If you are creating a Spreadsheet in Excel manually (not from a Library Export) and have Unicode chars then in the Save As box select "Save as Type: Unicode Text (*.txt)"

jmone:
Update: 20AUG16

Notes on Changes:
- Increased Max Memory Limit to handle larger library (can now use up to the Max Available memory for a 32-Bit App if needed, eg 4GB)
- Fixed typo that had broken the creation of the TXT file correctly

Navigation

[0] Message Index

[#] Next page

[*] Previous page