Songs missing when syncing from lexicon to iTunes

Hi, I use Lexicon as my single source of truth and sync with Engine DJ without any issues however when I sync to iTunes I am finding that in my play lists there are songs missing.

For example I have the following Playlists
Tech House - 50 (Lexicon) - 46 (iTunes)
Deep House - 369 (Lexicon) - 353 (iTunes)
House - 1194 (Lexicon) - 987 (iTunes)

When I look at the XML file that Lexicon has created all the songs are there but iTunes is saying that there are songs missing however the songs are all there in the folder.

I was wondering if anyone else has experienced this and if they have been able to resolve the issue without having to manually go through each playlist and compare iTunes to Lexicon.

Do you have an idea which tracks are missing? Could it be they are streaming (Beatport etc) tracks?

Can you copy paste a few of the track locations that you see in the XML but don’t see in iTunes after that?

Thanks for the quick response. All the songs are ones that I have purchased.

In Lexicon the Tech House Playlist has 50 songs. I have exported just this single playlist and imported it into iTunes.

iTunes has listed only 45 songs. The songs which are missing are:

  • Can We Get Together - Chris Lum
  • You Know How - Colin Dale
  • From Disco To Disco - Whirlpool Productions
  • Oh Yeah - Hello
  • Leave I Pants - Superwow

I have attached the XML file but as an example

		<key>5</key>
		<dict>
			<key>Track ID</key><integer>5</integer>
			<key>Name</key><string>Can We Get Connected</string>
			<key>Artist</key><string>Chris Lum</string>
			<key>Album</key><string>Get Connected EP</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>13179244</integer>
			<key>Total Time</key><integer>547683.2653061224</integer>
			<key>Date Added</key><date>2023-04-15T14:30:00Z</date>
			<key>Bit Rate</key><integer>192</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Comments</key><string>2A - Energy 6</string>
			<key>Composer</key><string></string>
			<key>Grouping</key><string></string>
			<key>Genre</key><string>Tech House</string>
			<key>Rating</key><integer>0</integer>
			<key>Play Count</key><integer>0</integer>
			<key>Persistent ID</key><string>40A57BAE2C2C0A72</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file:///Volumes/DATA/Music%20Collection/Chris%20Lum%20-%20Can%20We%20Get%20Connected%20-%20D#m%20-%20126.0.mp3</string>
		</dict>

The path to the song is correct, so I am not sure why iTunes is saying the song is missing.
Here is an example of a song that has been successfully synced from Lexicon to iTunes. For the life of me I can’t seem to work out why this one worked but the other one didn’t.

		<key>4</key>
		<dict>
			<key>Track ID</key><integer>4</integer>
			<key>Name</key><string>Catch The Pig</string>
			<key>Artist</key><string>Art Of Tones</string>
			<key>Album</key><string>Art Of Tones - Volume 1</string>
			<key>Kind</key><string>MPEG audio file</string>
			<key>Size</key><integer>14952405</integer>
			<key>Total Time</key><integer>372349.38775510207</integer>
			<key>Date Added</key><date>2023-04-15T14:30:00Z</date>
			<key>Bit Rate</key><integer>320</integer>
			<key>Sample Rate</key><integer>44100</integer>
			<key>Comments</key><string>4A - Energy 6</string>
			<key>Composer</key><string></string>
			<key>Grouping</key><string></string>
			<key>Genre</key><string>Tech House</string>
			<key>Rating</key><integer>0</integer>
			<key>Play Count</key><integer>0</integer>
			<key>Persistent ID</key><string>407B08E426CC7349</string>
			<key>Track Type</key><string>File</string>
			<key>Location</key><string>file:///Volumes/DATA/Music%20Collection/Art%20Of%20Tones%20-%20Catch%20The%20Pig%20-%20Fm%20-%20126.0.mp3</string>
		</dict>

Please let me know if you need any more information

Lexicon_iTunes Library.xml (76.7 KB)

Interestingly enough, If I export the playlist from Lexicon as a M3u playlist and import it in iTunes all the songs are there.

Very weird but maybe it’s just an iTunes thing. At least I have a workaround to sync the music without any manual rework.

It’s probably an itunes thing… Do you delete the entire iTunes library before you import the full library XML? Because one other weird thing that I do know for sure exists is that iTunes doesn’t update tags of existing files when importing an XML. Really stupid

I did delete the entire iTunes database. I wasn’t initially sure if it was my environment given I couldn’t find anyone else having the same issue or if it something to do with iTunes itself.

Now that I have the structure in place, I can export the playlists individually as a .m3u and import them to keep things up to date.

Hello! I am also encountering the exact same issue. I’ve also examined the XML data and the results are similar to what was noted by OP. Was there a fix for this yet other than the .m3u workaround? I’m afraid that the missing tracks are also littered around other random playlists as well, so I would rather have a full fix rather than a workaround. Any clues?

The way i ended up resolving the issue reliably was to purchase a tool called DJ conversion utility.

I export from Lexicon using Rekordbox XML file and then use it to import it into Itunes/Apple Music

it is clunky and an extra cost but it works for me and syncs 100% of the time

If you give me both XMLs that Lexicon and DJCU generates, I’ll see what the difference is there and try to fix it

Cool! Thanks for the tip :slight_smile: Would it also be possible to upload your XML files as Christiaan had suggested so he may check the difference and perhaps provide a fix within Lexicon? Thanks again!

Hello, I think I may have found the culprit behind the missing tracks/playlists when syncing from Lexicon to Apple Music. I’ve played around and have narrowed down (at least in my case) that my missing songs were attributed to any song outside of my “main” folder. E.g. The missing tracks were in my Downloads folder.

My “main” folder path is: MacintoshHD/Users/username/Music/“Main Music Folder”.

Lexicon and any subsequent XML files it produces will be able to locate all my music, in ALL locations on my computer, but (after the sync) Apple Music does not. Apple Music was only able to locate the tracks in my “main” folder.

My solution: Within your Mac Privacy & Security settings, ensure that Apple Music has Full Disk Access. You can add this by clicking the “+” button. Once you’ve done this, perform the sync within Lexicon once again to produce the XML file and load it according to instructions into Apple Music. All your tracks should now appear.

I think this is the case for newer Macs, as my old one did not have full disk access for Apple Music, but could still locate all files outside the “main” folder.

Hope this will help anyone in the future that encounters this issue.