The board has been upgrade to the latest version. Please let me know of any problems.
Also, there is a high probability that the forum will move to a different host, but that will happen in 2018.
Thanks, Doug

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: 289
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 312 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: 289
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 16 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