Add Album credits on Explorer view (Browse albums by Album Credits)

Discuss the powerful Explorer Templates used in the CAT programs
Post Reply
joker
Posts: 7
Joined: Mon Apr 03, 2017 9:05 pm

Add Album credits on Explorer view (Browse albums by Album Credits)

Post by joker » Mon Apr 03, 2017 9:14 pm

Can somebody tell me how I add Album Credits to the Explorer view side? I tried to edit the Index.xsl template but can't figure it out.

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

Re: Add Album credits on Explorer view (Browse albums by Album Credits)

Post by LotsOCds » Tue Apr 04, 2017 3:41 pm

Try this. Place each of the code segments with the similar code in Index.xsl.

Code: Select all

<xsl:variable name="browsealbumcredit">
  <xsl:text>@Album.AlbumCredit>@xmltemplatename=AlbumList.xsl?Album.AlbumCredit@</xsl:text>
  <xsl:text>sqldistinct=ArtistPerson.SortBy, ArtistPerson.ArtistPersonID@</xsl:text>
  <xsl:text>xmltitle=Album Credit: |operator1| |filter1|</xsl:text>
</xsl:variable>

Code: Select all

        <TR>                                                                 
          <TD WIDTH="18%" ALIGN="RIGHT" VALIGN="TOP"><B>Credit:</B></TD>    
          <TD WIDTH="*">                                                     
            <A HREF="ArtistPersonList.xsl?SortBy<A{$browsealbumcredit}"><</A><xsl:text> </xsl:text>
            <A HREF="ArtistPersonList.xsl?SortBy=A*{$browsealbumcredit}">A</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=B*{$browsealbumcredit}">B</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=C*{$browsealbumcredit}">C</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=D*{$browsealbumcredit}">D</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=E*{$browsealbumcredit}">E</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=F*{$browsealbumcredit}">F</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=G*{$browsealbumcredit}">G</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=H*{$browsealbumcredit}">H</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=I*{$browsealbumcredit}">I</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=J*{$browsealbumcredit}">J</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=K*{$browsealbumcredit}">K</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=L*{$browsealbumcredit}">L</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=M*{$browsealbumcredit}">M</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=N*{$browsealbumcredit}">N</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=O*{$browsealbumcredit}">O</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=P*{$browsealbumcredit}">P</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=Q*{$browsealbumcredit}">Q</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=R*{$browsealbumcredit}">R</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=S*{$browsealbumcredit}">S</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=T*{$browsealbumcredit}">T</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=U*{$browsealbumcredit}">U</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=V*{$browsealbumcredit}">V</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=W*{$browsealbumcredit}">W</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=X*{$browsealbumcredit}">X</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=Y*{$browsealbumcredit}">Y</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=Z*{$browsealbumcredit}">Z</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy>ZZ{$browsealbumcredit}">></A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy!={$browsealbumcredit}">*</A><xsl:text> </xsl:text>    
         </TD>                                                               
        </TR>                                                                
Cheers,
Dave

User avatar
Alex Ivanovich
Posts: 308
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

Re: Add Album credits on Explorer view (Browse albums by Album Credits)

Post by Alex Ivanovich » Tue Apr 04, 2017 5:44 pm

Dave hello
I also have customized this code, for BookCAT
for links in the database text and blue and enabled
for those not present and black and disabled

I just added this code ;)

Code: Select all

@validate=yes,1">
code complete

Code: Select all

<td class="index_table_browseby_cell1" nowrap="">Personaggio:</td>
            <td class="index_table_browseby_cell2" width="*">
              <a href="PersonList.xsl?SortBy<A{$browseauthor}"><</a><xsl:text> </xsl:text> 
              <a href="PersonList.xsl?SortBy=A*{$browseauthor}@validate=yes,1">A</a><xsl:text> </xsl:text>
Attachments
Screen Capture #029.png
Screen Capture #029.png (18.21 KiB) Viewed 655 times

joker
Posts: 7
Joined: Mon Apr 03, 2017 9:05 pm

Re: Add Album credits on Explorer view (Browse albums by Album Credits)

Post by joker » Tue Apr 04, 2017 6:25 pm

LotsOCds wrote:Try this. Place each of the code segments with the similar code in Index.xsl.

Code: Select all

<xsl:variable name="browsealbumcredit">
  <xsl:text>@Album.AlbumCredit>@xmltemplatename=AlbumList.xsl?Album.AlbumCredit@</xsl:text>
  <xsl:text>sqldistinct=ArtistPerson.SortBy, ArtistPerson.ArtistPersonID@</xsl:text>
  <xsl:text>xmltitle=Album Credit: |operator1| |filter1|</xsl:text>
</xsl:variable>

Code: Select all

        <TR>                                                                 
          <TD WIDTH="18%" ALIGN="RIGHT" VALIGN="TOP"><B>Credit:</B></TD>    
          <TD WIDTH="*">                                                     
            <A HREF="ArtistPersonList.xsl?SortBy<A{$browsealbumcredit}"><</A><xsl:text> </xsl:text>
            <A HREF="ArtistPersonList.xsl?SortBy=A*{$browsealbumcredit}">A</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=B*{$browsealbumcredit}">B</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=C*{$browsealbumcredit}">C</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=D*{$browsealbumcredit}">D</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=E*{$browsealbumcredit}">E</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=F*{$browsealbumcredit}">F</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=G*{$browsealbumcredit}">G</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=H*{$browsealbumcredit}">H</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=I*{$browsealbumcredit}">I</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=J*{$browsealbumcredit}">J</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=K*{$browsealbumcredit}">K</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=L*{$browsealbumcredit}">L</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=M*{$browsealbumcredit}">M</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=N*{$browsealbumcredit}">N</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=O*{$browsealbumcredit}">O</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=P*{$browsealbumcredit}">P</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=Q*{$browsealbumcredit}">Q</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=R*{$browsealbumcredit}">R</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=S*{$browsealbumcredit}">S</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=T*{$browsealbumcredit}">T</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=U*{$browsealbumcredit}">U</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=V*{$browsealbumcredit}">V</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=W*{$browsealbumcredit}">W</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=X*{$browsealbumcredit}">X</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=Y*{$browsealbumcredit}">Y</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=Z*{$browsealbumcredit}">Z</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy>ZZ{$browsealbumcredit}">></A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy!={$browsealbumcredit}">*</A><xsl:text> </xsl:text>    
         </TD>                                                               
        </TR>                                                                
Thank you Dave.

I replaced:
<xsl:variable name="browsealbumcredit">
<xsl:text>@Album.AlbumCredit>@xmltemplatename=AlbumList.xsl?Album.AlbumCredit@</xsl:text>
<xsl:text>sqldistinct=ArtistPerson.SortBy, ArtistPerson.ArtistPersonID@</xsl:text>
<xsl:text>xmltitle=Album Credit: |operator1| |filter1|</xsl:text>
</xsl:variable>

with this:
<xsl:variable name="browsealbumcredit">
<xsl:text>@Album.AlbumCredit>@xslparam:templatefile=AlbumList_Cover.xsl?Album.AlbumCredit@</xsl:text>
<xsl:text>sqldistinct=ArtistPerson.SortBy, ArtistPerson.ArtistPersonID@</xsl:text>
<xsl:text>xmltitle=Album Credit: |operator1| |filter1|</xsl:text>
</xsl:variable>

Now it's working! Thanks again!

joker
Posts: 7
Joined: Mon Apr 03, 2017 9:05 pm

Re: Add Album credits on Explorer view (Browse albums by Album Credits)

Post by joker » Tue Apr 04, 2017 6:36 pm

LotsOCds wrote:Try this. Place each of the code segments with the similar code in Index.xsl.

Code: Select all

<xsl:variable name="browsealbumcredit">
  <xsl:text>@Album.AlbumCredit>@xmltemplatename=AlbumList.xsl?Album.AlbumCredit@</xsl:text>
  <xsl:text>sqldistinct=ArtistPerson.SortBy, ArtistPerson.ArtistPersonID@</xsl:text>
  <xsl:text>xmltitle=Album Credit: |operator1| |filter1|</xsl:text>
</xsl:variable>

Code: Select all

        <TR>                                                                 
          <TD WIDTH="18%" ALIGN="RIGHT" VALIGN="TOP"><B>Credit:</B></TD>    
          <TD WIDTH="*">                                                     
            <A HREF="ArtistPersonList.xsl?SortBy<A{$browsealbumcredit}"><</A><xsl:text> </xsl:text>
            <A HREF="ArtistPersonList.xsl?SortBy=A*{$browsealbumcredit}">A</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=B*{$browsealbumcredit}">B</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=C*{$browsealbumcredit}">C</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=D*{$browsealbumcredit}">D</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=E*{$browsealbumcredit}">E</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=F*{$browsealbumcredit}">F</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=G*{$browsealbumcredit}">G</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=H*{$browsealbumcredit}">H</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=I*{$browsealbumcredit}">I</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=J*{$browsealbumcredit}">J</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=K*{$browsealbumcredit}">K</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=L*{$browsealbumcredit}">L</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=M*{$browsealbumcredit}">M</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=N*{$browsealbumcredit}">N</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=O*{$browsealbumcredit}">O</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=P*{$browsealbumcredit}">P</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=Q*{$browsealbumcredit}">Q</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=R*{$browsealbumcredit}">R</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=S*{$browsealbumcredit}">S</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=T*{$browsealbumcredit}">T</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=U*{$browsealbumcredit}">U</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=V*{$browsealbumcredit}">V</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=W*{$browsealbumcredit}">W</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=X*{$browsealbumcredit}">X</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=Y*{$browsealbumcredit}">Y</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy=Z*{$browsealbumcredit}">Z</A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy>ZZ{$browsealbumcredit}">></A><xsl:text> </xsl:text>     
            <A HREF="ArtistPersonList.xsl?SortBy!={$browsealbumcredit}">*</A><xsl:text> </xsl:text>    
         </TD>                                                               
        </TR>                                                                
Thank you Dave.

I replaced your code:

<xsl:variable name="browsealbumcredit">
<xsl:text>@Album.AlbumCredit>@xmltemplatename=AlbumList.xsl?Album.AlbumCredit@</xsl:text>
<xsl:text>sqldistinct=ArtistPerson.SortBy, ArtistPerson.ArtistPersonID@</xsl:text>
<xsl:text>xmltitle=Album Credit: |operator1| |filter1|</xsl:text>
</xsl:variable>

with this:

<xsl:variable name="browsealbumcredit">
<xsl:text>@Album.AlbumCredit>@xslparam:templatefile=AlbumList_Cover.xsl?Album.AlbumCredit@</xsl:text>
<xsl:text>sqldistinct=ArtistPerson.SortBy, ArtistPerson.ArtistPersonID@</xsl:text>
<xsl:text>xmltitle=Album Credit: |operator1| |filter1|</xsl:text>
</xsl:variable>

Now it's working. Thanks again!

User avatar
Alex Ivanovich
Posts: 308
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

Re: Add Album credits on Explorer view (Browse albums by Album Credits)

Post by Alex Ivanovich » Wed Apr 05, 2017 8:34 am

Hello joker

you must enter all of the code to work :)
here it is ;)
Attachments
Index.rar
(5.89 KiB) Downloaded 36 times

joker
Posts: 7
Joined: Mon Apr 03, 2017 9:05 pm

Re: Add Album credits on Explorer view (Browse albums by Album Credits)

Post by joker » Wed Apr 05, 2017 4:42 pm

Alex Ivanovich wrote:Hello joker

you must enter all of the code to work :)
here it is ;)
Hello Alex, thank you for your input. I had entered all the code, but I had to change the line: <xsl:text>@Album.AlbumCredit>@xmltemplatename=AlbumList.xsl?Album.AlbumCredit@</xsl:text>
with this:
<xsl:text>@Album.AlbumCredit>@xslparam:templatefile=AlbumList_Cover.xsl?Album.AlbumCredit@</xsl:text>. Because it was not possible to display the albums of the creditpeople.
Have a nice day!

Post Reply