Page 1 of 1

CATraxx - Explorer Templates with Chart info

Posted: Sun Apr 24, 2016 4:27 pm
by DougWilliams
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)

Re: CATraxx - Explorer Templates with Chart info

Posted: Mon Apr 25, 2016 4:24 am
by jepsternz
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

Re: CATraxx - Explorer Templates with Chart info

Posted: Mon Apr 25, 2016 10:38 am
by DougWilliams
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.

Re: CATraxx - Explorer Templates with Chart info

Posted: Mon May 02, 2016 4:09 pm
by LotsOCds
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.

Re: CATraxx - Explorer Templates with Chart info

Posted: Fri Apr 28, 2017 1:31 am
by DougWilliams
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...

Re: CATraxx - Explorer Templates with Chart info

Posted: Sat May 13, 2017 3:35 pm
by LotsOCds
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.

Re: CATraxx - Explorer Templates with Chart info

Posted: Sun May 14, 2017 8:27 pm
by Harald
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

Re: CATraxx - Explorer Templates with Chart info

Posted: Sat Dec 30, 2017 4:36 pm
by DougWilliams
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?

Re: CATraxx - Explorer Templates with Chart info

Posted: Sat Dec 30, 2017 9:56 pm
by LotsOCds
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!

Re: CATraxx - Explorer Templates with Chart info

Posted: Sat Dec 30, 2017 10:39 pm
by DougWilliams
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;