Notes / Comments Tag

[tomx2]

Hello, I for the life of me i can't seem to figure out how to get my comment tag to display when exporting to HTML. Is there anyone willing to help a struggling user with this issue? In other words (for clarity), i can get the web page to display roughly as i would like (we'll not really!), but can't seem to figure out a way to display my comment tag, other than psychically copying my comments tag text into the notes tab for each and every file! I have searched here and the web in general about how to point catraxx v9 to my "comment" tags, but have been unable to find any info on this.

Thanks Tom

[DougWilliams]

I'm not familiar with "Comments Tag" field.
Can you include a screenshot of the field? Maybe it's a Custom field?

[tomx2]

Thanks Doug,
I'm still somewhat of a newbie (moving over from music collectorz). By "comment" i mean text i have attached via Mp3Tag.

comments.jpg (147.71 KiB) Viewed 965 times

[DougWilliams]

Is the info in CATraxx? Export to HTML needs to have the data in the CATraxx database.

[tomx2]

We'll like i said, i'm new to this, not sure! All i really have is my meticulously tagged collection/files, and all i have done so far is import my collection. So, not exactly sure what you mean, but their in Catraxx as much as, say, my album art, track names or any of the other tags that show up after importing into catraxx. I guess what i'm after is a way to tell (a setting?) Catraxx when exporting to html to read the "comment tag" and display it.

PS- Thanks for your help. By the way in looking at your collection on your web site i noticed you were missing an image for Jerry Dallman, here is it if you like (attached).

[LotsOCds]

Are the mp3 Comments tags properly being read in to the Track Notes field? Confirm this setting under Tools>Audio File Options. The Comment tags must be read in to the Notes field before they can show in the HTML export. If necessary, open the album edit window and click Audio>Read from tag (or hit Shift F8) to re-read the tags.

Screenshot - 1_2_2017 , 4_21_50 PM.png (56.72 KiB) Viewed 940 times

Now, which HTML Export report are you using? If it happens to be Track List Details the Track Notes should already be on the Details page.

Screenshot - 1_2_2017 , 4_27_35 PM.png (120.06 KiB) Viewed 940 times

If instead you are using another report, like one of the Album Index reports, a little code must be added to display the Track Notes.

On the detail page highlight Album.Tracks and click on Field Properties.

Screenshot - 1_2_2017 , 6_03_40 PM.png (114.35 KiB) Viewed 940 times

Now click on the three dots next to the XSL Code field.

Screenshot - 1_2_2017 , 6_05_13 PM.png (35.33 KiB) Viewed 940 times

Copy the code below and paste it into the Edit XSL Code page. Click the OK's and then export.

Code: Select all

<table style="font-family: Arial, Verdana, Helvetica, sans-serif; font-size: 10pt; background-color: #ffffff;">
    <xsl:for-each select="/data/record/trackdata/disc/side/track">
        <tr>
            <td nowrap="" align="right" valign="top"  style="color: #000000; background-color: #ffffff;">
                <xsl:if test="/data/record/trackdata/@sides = 2">
                    <xsl:value-of select="../sideno"/>
                </xsl:if>
                <xsl:value-of select="index"/>.
            </td>
            <td width="*"  style="color: #000000; background-color: #ffffff;">
                <xsl:value-of select="fulltitle"/>
                <xsl:if test="artists/@sort != /data/record/albumdata/artists/@sort">
                    <xsl:text> / </xsl:text>
                    <xsl:call-template name="format-artist">
                        <xsl:with-param name="artists" select="artists"/>
                    </xsl:call-template>
                </xsl:if>
                <xsl:text> (</xsl:text><xsl:value-of select="length"/>)
                <xsl:if test="count(authorcredits/authorcredit) > 0">
                    <br/>
                    <xsl:text>(</xsl:text>
                    <xsl:call-template name="format-authorcredits">
                        <xsl:with-param name="authorcredits" select="authorcredits/authorcredit"/>
                        <xsl:with-param name="showsortby" select="'false'"/>
                        <xsl:with-param name="incrole" select="'false'"/>
                        <xsl:with-param name="newline" select="'false'"/>
                        <xsl:with-param name="separator1" select="'/'"/>
                        <xsl:with-param name="separator2" select="'/'"/>
                    </xsl:call-template>
                    <xsl:text>)</xsl:text>
                </xsl:if>
                <xsl:if test="string-length(notes_plaintext)>0">
                    <br/>
                    <xsl:value-of select="notes_plaintext"/>
                </xsl:if>
                <xsl:if test="position() < last() ">
                    <br/>
                </xsl:if>
            </td>
        </tr>
    </xsl:for-each>
</table>

Screenshot - 1_2_2017 , 6_06_45 PM.png (67.98 KiB) Viewed 940 times

Let us know how it goes. I'm not available for the next several days and may be slow to answer any questions but I will be back...

[tomx2]

Incredible! Excellent info Dave, just what i needed. I'm on it, i'll report back with the result of my adventure.

Update: I might be in trouble, as i received an error that the database can't exceed 2GB. Still working on it....

- Tom

[DougWilliams]

Great news! Thanks Dave.

Thanks for the image!

The 2GB limit may be temporarily resolved by compacting the database (FILE > COMPACT DATABASE).

If that doesn't resolve AND you store images in the database then you need to look at extracting the images and linking to them instead. TOOLS > DATABASE MAINTENANCE > EXTRACT IMAGES...

Once images are extracted you will need to compact the database.

Be sure to back up your database before attempting changes.. just to be safe!