Songs with accents or special characters in the titles missing on Sonos Controller App when imported from a playlist on macOS.
For Windows users I found this topic that will give you more information about this problem.
For those who are on the macOS side here’s the way I used to fix it. I’m running macOS12 « Monterey » but it should work with many mores. My Sonos Controller is 17.2 and the Sonos OS is S2.
First create *m3u file and locate the songs in the playlist with a text editor. I use TextEdit but you can choose whatever floats your boat.
Depending on the app you used to create the playlist (I use Mp3tag) you’ll find the path of the songs as:
/Users/polo/Music/Jean Jacques Goldman/En Public/CD1/Pas l'indifférence.mp3
Where polo is my username.
Now we have to modify the path of each song in the playlist to be accessed by the Sonos Controller app as follows:
In macOS the url location doesn’t (at least for me) work like in Windows. I’ve found that you have to change it with the name showing in your file sharing preferences.
You can see the name after clicking the System Preferences Pane and accessing the Sharing folder.
/Users/polo/Music/ becomes in my case
//MacBook-Pro-de-Polo/Musique/
So the structure /Users/yourusername/ becomes //name-of-your-mac.local but without the .local
/Musique/ as my system is french localized.
The path to the song in the playlist should be something like:
//MacBook-Pro-de-Polo/Musique/Jean Jacques Goldman/En Public/CD1/Pas l'indifférence.mp3
In Excel, use the encodeurl function
The problem is that this function is not available on macOS 12 Monterey with Microsoft Excel for mac version 16.88
Notes:
- The ENCODEURL function is not available in Excel for the web or Excel for Mac.
- The ENCODEURL function may appear in Excel for Mac's function gallery, but it relies on Windows operating system features, so it will not return results on Mac.
If they fixed this situation in the latest release good for you otherwise you have to implement this function manually.
I’ve used this VBA macro kindly shared on GitHub: https://gist.github.com/jvarn/
It’s called URLEncode but it offers the same result as the ENCODEURL found in the Excel version for Windows and works very well.
There is also an online site that does the job if you don’t use Excel for mac: https://www.urlencoder.org
Here is the output after using the function:
%2F%2FMacbook-Pro-de-Polo%2FMusique%2FJean%20Jacques%20Goldman%2FEn%20Public%2FCD1%2FPas%20l%27indiff%C3%A9rence.mp3
Then substitute ‘%2F%2F’ for ‘//’ and substitute ‘%2F’ for ‘/’
You get:
//MacBook-Pro-de-Polo/Musique/Jean%20Jacques%20Goldman/En%20Public/CD1/Pas%20l%27indiff%C3%A9rence.mp3
Then add in front of it ‘x-file-cifs:’
And then you get, at last, the correct path:
x-file-cifs://MacBook-Pro-de-Polo/Musique/Jean%20Jacques%20Goldman/En%20Public/CD1/Pas%20l%27indiff%C3%A9rence.mp3
Repeat for each song of the playlist and save it as an *.m3u file.
And Voilà! Import it in SONOS and enjoy your music.
