How to locate the folder of the track being played from USB drive?

[simbun]

I have all the flac files with different bitrates.

With lossless you want to look at sample rates.
If you think you have duplicate (from same CD) FLAC files you can use the embedded MD5 (calculated on the decoded audio), although this isn't available through the database.

 

[vbutani]

I think sqlite3 will be installed by default on Ubuntu:

sqlite3 -header -tabs files.db "select path, title, duration, bitrate, samplerate, creator, album, channels, disc, track, date, mime from details where mime not null;" > ~/tracks.txt

Although if @vbutani wants to go down this route it may be easier to perform the dedupe in sql.

Let me share more context of the same multiple albums.

USB drive:

Folder A
> Album Dil Se

Folder B
> Downloaded
>> Album Dil Se
> Bollywood
>> Album Dil Se

In above case, For Album Dil Se, all the track details are same so unless I play on Wiim Ultra, I don't know about their bitrate and their quality which is better. If I could find the folder when I play it, I would note it and do the needful which would help organizing files as well. Sorry, if my approach is not logical.

Thanks all for the prompt response, appreciate it.

 

[rccarguy]

I have all the flac files with different bitrates.

flac files are in different bitrates, thats ok and normal, they're still all lossless.

 

[simbun]

Yeah, it does - here's an excerpt of the Details table in the wiim_cache files.db I have on a USB drive. I used the DB Browser for SQLite app from https://sqlitebrowser.org/dl/ then exported the info into a CSV file which I then loaded into Excel and truncated:

This has a chance of working, although it requires an exact match on album and artist (albumartist I believe) and assumes that all tracks are in the root of the album directory (not Disc 1/CD01 etc).

select *
  from (
         select artist||' - '||regexp_replace(album, ' \(.*\)', '') as artist_album,
                regexp_replace(path, '(?i)\/(CD|DISC) *\d*', '') as path,
                sum(1) over (partition by artist||' - '||regexp_replace(album, ' \(.*\)', '')) as count_albums
           from (
                  select distinct artist,
                         album,
                         rtrim(path, replace(path, '/', '')) as path
                    from details
                    where mime not null
                )
           group by 1, 2
       )
where count_albums > 1;

EDIT: Updated to strip (xyz) from album and CD/Disc folders from paths to help with match.
This does require a regex extension to be loaded.

sqlite> .load ./regexp

Releases · nalgeon/sqlean

The ultimate set of SQLite extensions. Contribute to nalgeon/sqlean development by creating an account on GitHub.

github.com

 

[simbun]

In above case, For Album Dil Se, all the track details are same so unless I play on Wiim Ultra, I don't know about their bitrate and their quality which is better. If I could find the folder when I play it, I would note it and do the needful which would help organizing files as well. Sorry, if my approach is not logical.

Rather than stumble upon duplicates during playback we're trying to identify them up front, although it doesn't sound as though you've spent any time standardising the tagging/storage so it may not be effective.

 

[simbun]

In above case, For Album Dil Se, all the track details are same so unless I play on Wiim Ultra, I don't know about their bitrate and their quality which is better. If I could find the folder when I play it, I would note it and do the needful which would help organizing files as well.

Just to reiterate in case it's not clear (it was a few posts ago now), it's not possible to get the track location from the WHA or any app connecting to it.
You could write down the tags (album and albumartist) and find the location from the export of lms.db

 

[TimTim]

I’d start using Musicbrainz Picard which afaik is available for Ubuntu to tag your music. It’s mostly quite effortless as it uses a rather comprehensive database and will do most of the work for you. You can tag different releases of the same album so that it would be possible to distinguish between the German release of an album and the Spanish remastered version. For the time being, unfortunately, this won’t really help you with Wiim, but maybe the software will improve eventually. If you run LMS on a cheap Raspberry Pi, it would already make your life easier.

 

[simbun]

I’d start using Musicbrainz Picard which afaik is available for Ubuntu to tag your music. It’s mostly quite effortless as it uses a rather comprehensive database and will do most of the work for you. You can tag different releases of the same album so that it would be possible to distinguish between the German release of an album and the Spanish remastered version. For the time being, unfortunately, this won’t really help you with Wiim, but maybe the software will improve eventually. If you run LMS on a cheap Raspberry Pi, it would already make your life easier.

Musicbrainz Picard, effortless, LMS and life easier - not words I thought I'd ever see used together

 

[slartibartfast]

Musicbrainz Picard, effortless, LMS and easier - not words I thought I'd ever see used together

Many LMS users make a point of removing Musicbrainz tags due to issues they cause .

 

[Steve Woodhouse]

So, switch to folder view - this is presuming you know where the various copies of the album are - and play each one at each location, and note the details from there.

Just in general, and for future reference, keep an orderly and well-labelled folder structure.

 

[Steve Woodhouse]

I'm on Ubuntu Desktop and don't use any software for tagging. Just stored all the music on it, and copied to USB drive for directly playing on Wiim Ultra.

There must be some tags on the files or you wouldn’t be able to see their names on the WiiM app.

 

[slartibartfast]

I'm on Ubuntu Desktop and don't use any software for tagging. Just stored all the music on it, and copied to USB drive for directly playing on Wiim Ultra.

Where did the music come from then? You should really take control of tagging yourself.

 

[harkpabst]

There must be some tags on the files or you wouldn’t be able to see their names on the WiiM app.

The WiiM Home app would still display the file name in case there are no tags at all.

 

[Steve Woodhouse]

The WiiM Home app would still display the file name in case there are no tags at all.

I was presuming (perhaps incorrectly) that, if there are no tags, the tracks will also be called "001", "002", etc.

 

[TimTim]

Many LMS users make a point of removing Musicbrainz tags due to issues they cause .

I never knew. Sometimes certain releases are missing from the database but apart from that it’s the fastest solution for tagging and naming files that I’m aware of. Any recommendations that might be better?

 

[slartibartfast]

I never knew. Sometimes certain releases are missing from the database but apart from that it’s the fastest solution for tagging and naming files that I’m aware of. Any recommendations that might be better?

Some users are happy with Musicbrainz. Others try to keep tagging as basic as possible. If you use Musicbrainz tags to differentiate versions of the same album how do you know which version is which in the album list?
There are current threads about Musicbrainz in LMS in the Lyrion forum.

 

[TimTim]

Some users are happy with Musicbrainz. Others try to keep tagging as basic as possible. If you use Musicbrainz tags to differentiate versions of the same album how do you know which version is which in the album list?
There are current threads about Musicbrainz in LMS in the Lyrion forum.

That I don’t know unless I manually add that to the title which, for me at least, is less work than manually tagging everything. At the end of the day it’s the compromise that works best for me. Musicbrainz takes care of the tedious work and I only do minor adjustments.

But if I had, say, three different versions of Pet Sounds all tagged according to whichever CD they were sourced from, there’d at least be three different versions of Pet Sounds showing up in LMS whereas if I plug a harddrive into the Ultra, it’s just one.

Which leads to the question of who in his right mind needs three different versions of an album. But that would be something to discuss with a therapist.

 

[rccarguy]

That I don’t know unless I manually add that to the title which, for me at least, is less work than manually tagging everything. At the end of the day it’s the compromise that works best for me. Musicbrainz takes care of the tedious work and I only do minor adjustments.

But if I had, say, three different versions of Pet Sounds all tagged according to whichever CD they were sourced from, there’d at least be three different versions of Pet Sounds showing up in LMS whereas if I plug a harddrive into the Ultra, it’s just one.

Which leads to the question of who in his right mind needs three different versions of an album. But that would be something to discuss with a therapist.

Original release
Mono (ie beatles)
Stereo (ie beatles)
Remaster
Expanded Editions
16 bit / 44khz
24 bit/96khz
24 bit/192khz

 

[TimTim]

Original release
Mono (ie beatles)
Stereo (ie beatles)
Remaster
Expanded Editions
16 bit / 44khz
24 bit/96khz
24 bit/192khz

I was just making fun of my own hoarding. I wouldn’t keep different versions of the same master and just stick to the highest available bitrate. But different masters, unless they sound truly dreadful, can be fun.

 

[slartibartfast]

I was just making fun of my own hoarding. I wouldn’t keep different versions of the same master and just stick to the highest available bitrate. But different masters, unless they sound truly dreadful, can be fun.

DSD, CD, vinyl