CATraxx - Explorer Templates with Chart info

Discuss the powerful Explorer Templates used in the CAT programs
Post Reply
User avatar
DougWilliams
Site Admin
Posts: 245
Joined: Thu May 22, 2014 11:36 am
Location: Wisconsin, USA
Contact:

CATraxx - Explorer Templates with Chart info

Post by DougWilliams » Sun Apr 24, 2016 4:27 pm

Just curious if anyone has done any custom Explorer templates centered around the Chart info.
I'm starting to add that info and the default templates don't display additional chart information (peak, weeks, notes)
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

jepsternz
Posts: 3
Joined: Sun Sep 20, 2015 3:56 am

Re: CATraxx - Explorer Templates with Chart info

Post by jepsternz » Mon Apr 25, 2016 4:24 am

Hi Doug

Are you wanting to add more info than shown in the attached image which is from Album charts.
I haven't played with the template but do get paek weeks and notes. Same in the Singles view.

Regards
John

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

Re: CATraxx - Explorer Templates with Chart info

Post by DougWilliams » Mon Apr 25, 2016 10:38 am

To be honest, I don't know what I want. :oops:

The Chart Info is there (Chart, Year, Peak, Weeks, Notes) but there just seems to be more ways to display it.
The current way, if you click on the chart hyperlink will show the album list of other albums associated with that chart, but it doesn't show the chart info.

Just looking to see what other ways there may be.
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

User avatar
LotsOCds
Posts: 177
Joined: Thu Aug 20, 2015 4:23 am
Location: California, USA

Re: CATraxx - Explorer Templates with Chart info

Post by LotsOCds » Mon May 02, 2016 4:09 pm

Hi Doug,

I don't have any templates that use the chart info but the information is all there in the XML so it should be easy enough to create the necessary code. Let me know if you need some help once you have an idea how you would like to see it.
Cheers,
Dave

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

Re: CATraxx - Explorer Templates with Chart info

Post by DougWilliams » Fri Apr 28, 2017 1:31 am

Okay, I've got my ideas...

The MusicChart.xsl would display the selected chart data set.

Billboard Year End Top Pop Albums (my year end data doesn't have a "weeks" value entered but if it was there is would display)
Status - Year - Peak - Weeks - Format - Artist - Title
Own - 1987 - 1 - - LP - Bon Jovi - Slippery When Wet
Own - 1987 - 2 - - LP - Paul Simon - Graceland
.
Wanted - 1987 - 100 - LP - The Cure - Kiss Me, Kiss Me, Kiss Me

It would be nice if clicking on the header could sort but not necessary.

More conversation I'm sure is needed but that's a start...
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

User avatar
LotsOCds
Posts: 177
Joined: Thu Aug 20, 2015 4:23 am
Location: California, USA

Re: CATraxx - Explorer Templates with Chart info

Post by LotsOCds » Sat May 13, 2017 3:35 pm

Hi Doug,

I haven't had much time to look at this. Creating an XSL file is not a problem. I'm looking to do this with an AlbumList type of file. What I haven't found yet is a workable query that can filter the entire album table for a given chart and year. I'll keep looking at it as time allows.
Cheers,
Dave

Harald
Posts: 7
Joined: Thu Nov 17, 2016 9:07 pm

Re: CATraxx - Explorer Templates with Chart info

Post by Harald » Sun May 14, 2017 8:27 pm

Hi Doug,

very interesting thread. But where do you activate the MusicChart.xsl to display "Status - Year - Peak - Weeks - Format - Artist - Title"?
Wherever I look I only see "Chart Year Peek Week Notes".
I'm using Catraxx v9.49 and MusicChart.xsl(15.07.2012) is available in explorer templates.
Thank you for response

Harald

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

Re: CATraxx - Explorer Templates with Chart info

Post by DougWilliams » Sat Dec 30, 2017 4:36 pm

Harald, oops sorry, this slipped by me.
It doesn't exist yet. That's what Dave is working on.

Dave, do you need a SQL query or something else?
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

User avatar
LotsOCds
Posts: 177
Joined: Thu Aug 20, 2015 4:23 am
Location: California, USA

Re: CATraxx - Explorer Templates with Chart info

Post by LotsOCds » Sat Dec 30, 2017 9:56 pm

Hi Doug, this one slipped past me as well! The query needed is one for use in the XSL, but if you want to create an SQL it will save me having to think much. I can hopefully pattern the XSL query after it.

Happy New Year!
Cheers,
Dave

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

Re: CATraxx - Explorer Templates with Chart info

Post by DougWilliams » Sat Dec 30, 2017 10:39 pm

Hi Dave,
This is what I came up with.

Code: Select all

SELECT Status.Status, MusicChart.SortBy, AlbumChartInfo.Year, AlbumChartInfo.Peak, AlbumChartInfo.Weeks, AlbumChartInfo.Notes, Album.TitleSort, Album.ArtistSort
FROM (MusicChart INNER JOIN (Album INNER JOIN AlbumChartInfo ON Album.AlbumID = AlbumChartInfo.AlbumID) ON MusicChart.MusicChartID = AlbumChartInfo.MusicChartID) INNER JOIN Status ON Album.StatusID = Status.StatusID
ORDER BY MusicChart.SortBy, AlbumChartInfo.Year, AlbumChartInfo.Peak;
Record Collector
"You Mean I'm Supposed To Listen To 'Em?!?!?!?"

Post Reply