Hello all,
In case it can be useful for others, I’ve made an Excel file to generate with macro .txt Tag files to be used by plugin TxtImporter.
I attach it below.
https://drive.google.com/file/d/1BVPZAk ... sp=sharing
The file contains a “Guide” tab having a “Full Guide” § but also a “Simple Guide” § and “What to improve” § that I copy below to give an idea.
Simple Guide
1 List in one Green Sheet the files you want to Tag with the "Music List" button. You may list files from different folder by doing it again, the new ones will be added at the end.
2 Fill the Tag value you want to generate on the corresponding Tag properties columns (green columns). Then click on "Tag" button to generate the .txt files and in MediaMonkey launch the plugin "TxtImporter" on the related files.
3 Click on "Clean Files" button to delete the .txt files previously generated. Then click on "Clear Lines" button to remove the lines from this file.
What to improve
1 Correct my broken English (in the file and in the VBA code)
2 "TxtImporter" does not work with UTF-8. By default, I've put the encoding "Windows-1252" (extended Latin) which works fine for me, but not for non-Latin characters but I did not find any way to be universal.
3 Find a way to retrieved directly the first Google lyrics result on this file.
One last thing, my macro force for multiline tag a « Platform-specific new line character » (Cr+Lf for Windows) but when importing in MediaMonkey it seems to generate only Cr (Macintosh Way). It may be related with the line (line 76) code below:
Execute("itm."&tag&" = itm."&tag&"&Chr(13)&"""&str&"""") '!
It generated in my side, issues when using the Plugin “RegExp Find and Replace”. To solve this, I had to create a Regular Expression to replace all Cr by Cr+Lf shown below (if not working, the direct link :
https://drive.google.com/file/d/1EZb_AS ... sp=sharing).
Find what (with “Regular expression” checked):
\r(?!\n)
Replace with (with “VBScrit” checked)
vbCrLf