WiiM Amp USB Album Artist / Compilation issue

[slartibartfast]

Right everyone. I've received a reply from WiiM to my ticket and the response is...underwhelming.

"Dear [***],

Thank you for reaching out, and we apologize for the inconvenience.

The issue you're experiencing is due to the categorization being based on 'artist' tags rather than 'album artist' tags. What you're observing is expected behavior. We have noted your request and will consider it in future updates.

We appreciate your patience and understanding.

Best Regards,
WiiM Support"

So there you have it everyone, the App is operating as designed with no functionality to read the Album Artist tags. Seems poor to me. @goodmore @Djinn @pbutler68 : WiiM now have my feedback on the issue, so feel free to add your voices to the conversation too by submitting a problem/Feature Request here: submit a ticket or make a request.

Thanks to @simbun and @Steve Woodhouse for ably assisting with the troubleshooting. Hopefully this thread will help provide an answer and relevant links for anyone else suffering from the same issue.

In the meantime, I'll just leave this here: Raspberry Pi - Media Centre Forum.

So what happens if you only have the Album Artist tag and no Artist tag?

 

[simbun]

WiiM stores the metadata in a sqlite database in the root of the USB drive (WiiM_Cache/files.db I think).

If you fancied tinkering, you could update the ARTIST field with the value from CREATOR for those records in the DETAILS table associated with music tracks - assuming it's not the indexing that's broken.

 

[middleagedgrump]

So what happens if you only have the Album Artist tag and no Artist tag?

The Tag Police come and take you away for being so naughty.

 

[Djinn]

WiiM stores the metadata in a sqlite database in the root of the USB drive (WiiM_Cache/files.db I think).

If you fancied tinkering, you could update the ARTIST field with the value from CREATOR for those records in the DETAILS table associated with music tracks - assuming it's not the indexing that's broken.

Could you elaborate? What tables are involved? Is the MySQL client valid for this operation? Finally, could you put an example with the needed SQL sentences?

Thanks