xl is unneeded, see following posts
I have many duplicates with different titles/artists (all with different hash). Most of my tags are from MusicBrainz, but what is no guarantee for unanimous titles since titles can be different on different releases because whoever decided of the design of physical release.
Before I start to clean up (delete and transfer PlayStat) with the amazing Advanced Duplicate Find & Fix my first step is to make sure they all have same title and artist. To do this I use xl and GenPUID with MusicDNS web-service, which returns a PUID (PUID could also be returned with MusicBrainz or MusicIPmixer).
Start to download GenPuid from MusicDNS, you need an account to be able to download GenPUID 1.4 and to get your key.
You start GenPuid from Windows Command Line. I prefer to use a batch file. I have two bat files one for writing PUID to tags and one for creating an XML file to be used with xl (they could be combined but...).
MyGenPUID - Write PUID.bat
Code: Select all
genpuid e10...[key from MusicIP] "G:\Music MP3\By Artist" -r -archive -xml=temp.xml
-r
Recursively processes all sub-directories.
-archive
Write MusicIP tags into the song files as they are identified.
-xml=temp.xml
Generate output in XML format
It can takes hours to run GenPUID depending on number of tracks, so be careful and don't start with your entire collection, just start with a testing directory. Even if there are only a few tracks it can takes 10 minutes per track if a track doesn't exist in MusicDNS. Normal time is 2-3 sec per track (25000 tracks = ~20h ...). If you store PUID in tags you don't have to run GenPUID again, so there is a good idea to have new tracks in a temp directory before they are moved to correct directory. If you don't receive a PUID check status for each track in the XML file and search for Pending.
Pending
The server has not yet generated a PUID for this track, which can take up to 24 hours. If you have submitted a fingerprint for PUID creation, you will need to re-request it from GenPUID after that time frame has lapsed.
MyGenPUID - Create MyCollectionXML.bat
Code: Select all
genpuid e10...[key from MusicIP] "G:\Music MP3\By Artist" -r -rmd=1 -xml=MyCollection.xml
Returns extra metadata. (1: Include basic artists name and track title metadata)
I don't know why but GenPuid doesn't currently cope with Unicode filenames and will generate invalid XML. But it's simple to correct just open MyCollection.xml in notepad and save it as UTF-8 (UTF-16 ?).
With PUID stored in extended tag MUSICIP PUID export your collection using i.e. Mp3Tag -export (CSV)
Code: Select all
$filename(csv,utf-16)Album;Title;Artist;MusicIP PUID;Path
$loop(%_filename_ext%)%album%;%title%;%artist%;%MUSICIP PUID%;%_folderpath%
$loopend()
Rename artist and title (move feat. Kesha to title)
With xl it's also easy to check your tags (Artist, Title). Import your library CSV file and MyCollection.xml wish contains tags from MusicDNS (not the best source for tags, but to find big mistakes it's OK), sort them both by PUID and compare the tables.
Since GenPUID can create an XML file maybe someone want to develop a script so PUID could be stored in a MM Custom field. And in the future be an option in Advanced Duplicate Find & Fix or Magic Nodes. No need for xl