Before the end of 2017 the board will be down for a brief period of time for an upgrade.
Past experience says less than 30 minutes but I can't predict the future.
Also, there is a high probability that the forum will move to a different host, but that will not happen in 2017.
Thanks,
Doug

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

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

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

Postby 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: 169
Joined: Thu Aug 20, 2015 4:23 am
Location: California, USA

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

Postby 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&lt;A{$browsealbumcredit}">&lt;</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: 286
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

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

Postby 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&lt;A{$browseauthor}">&lt;</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 288 times

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

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

Postby 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&lt;A{$browsealbumcredit}">&lt;</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)

Postby 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&lt;A{$browsealbumcredit}">&lt;</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: 286
Joined: Mon Sep 07, 2015 2:24 pm
Location: Russian - Italia

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

Postby 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 15 times

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

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

Postby 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!


Return to “Explorer Templates”

Who is online

Users browsing this forum: No registered users and 1 guest