sql-Question

Discuss using and your tips/tricks for CATraxx
Cally
Posts: 23
Joined: Wed Sep 16, 2015 6:25 am
Location: Germany

sql-Question

Postby Cally » Wed Aug 16, 2017 10:52 am

Hello to the sql-specialists ;)
If I add new albums I would like to see which tracks of it are already in the database with attached audio and which new tracks I have to rip.
Or in other words how can I mark the tracks of the new album which are not in the database available with audio.

Greets from germany
Martin

Azol
Posts: 82
Joined: Wed Sep 09, 2015 11:44 am

Re: sql-Question

Postby Azol » Wed Aug 16, 2017 12:38 pm

1) You add the New Album
2) There are no tracks by default in the album you created
3) So you have to add some New Tracks
These new tracks have no audio attached.
Maybe you have some duplicate tracks (compilations etc), but the only way to find out is look for existing tracks with similar title.

Cally
Posts: 23
Joined: Wed Sep 16, 2015 6:25 am
Location: Germany

Re: sql-Question

Postby Cally » Wed Aug 16, 2017 6:46 pm

Because I have many compilations I often have duplicate tracks.
When added new album I check data of each track and use the copy track data function. With this I get a list of tracks which have same title (maybe with different artists). I imagine it must be possible to find or mark duplicate tracks of whole album with one action (one sql statement).

User avatar
DougWilliams
Site Admin
Posts: 207
Joined: Thu May 22, 2014 11:36 am
Location: Wisconsin, USA
Contact:

Re: sql-Question

Postby DougWilliams » Wed Aug 16, 2017 11:37 pm

Hi Cally,

While it's likely a sql query could do what you're asking, I'm wondering if a custom Track View for the Copy Track Data be a better idea.

The problem I have with the sql query is there could be unexpected variances.
The song title "Heaven" has many artists. How would you determine the artist for the attached file. Yes artist could be added to the query but that adds more complicated "what if's". What if it's "Hall and Oates" vs "Daryl Hall and John Oates" vs "Hall & Oates" vs "Daryl Hall/John Oates", etc.

The custom track view could show any matching titles with needed information.

Just my thought...
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

Cally
Posts: 23
Joined: Wed Sep 16, 2015 6:25 am
Location: Germany

Re: sql-Question

Postby Cally » Fri Aug 18, 2017 6:17 pm

Hi Doug,

it seems really not so easy as I thought.
The custom track view I'm using already.
There I can see, if a track with same artist is available and if audio file is attached. If not, I can mark custom field in track "has to be ripped".
Unfortunately I often forget to mark the field. That's the main reason why I would prefer a sql-automatic-marking.

Greets from germany
Martin


Return to “Using CATraxx”

Who is online

Users browsing this forum: No registered users and 1 guest