Discuss using and your tips/tricks for CATraxx
-
Cally
- Posts: 37
- Joined: Wed Sep 16, 2015 6:25 am
- Location: Germany
Post
by 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
Post
by 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: 37
- Joined: Wed Sep 16, 2015 6:25 am
- Location: Germany
Post
by 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).
-
DougWilliams
- Site Admin
- Posts: 283
- Joined: Thu May 22, 2014 11:36 am
- Location: Wisconsin, USA
-
Contact:
Post
by 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: 37
- Joined: Wed Sep 16, 2015 6:25 am
- Location: Germany
Post
by 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