<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 12 (filtered medium)"><style><!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
span.EmailStyle17
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Hello again,<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Your tip about changing how photos are stored made all the difference in the world! I was able to complete my project with just one path change to my xsl file. Thanks for the help! My code and methods are ugly, but with your help, I’ve achieved the results I wanted.<br><br>Would it normally be easy to take an existing project like mine (for display in a web browser) and adjust it to display inside tellico’s “generate report” window? I’m curious whether I should work towards the goal of creating an actual report-template, or whether I should stick with the solution I have until I’ve learned more.<br><br>Basically, what I have now is the full tellico.tc XML file with the following three modifications made to it: <br>1. After the <!DOCTYPE ... > declaration, I added the following line:<br> <?xml-stylesheet type=”text/xsl” href=”nameofmy.xsl”?> <o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>2. I deleted everything after the word “tellico” in the tellico tag (for some reason, things wouldn’t work with xmlns="http://periapsis.org/tellico/" syntaxVersion="11"> in it. Is that the “namespace” entry? Why would it run without that, but not with?)<br>3. I also had to find/replace a few html tags I had in the text entry fields of my collection<br><br><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'>Those are the only changes I made to the XML...so the entire XML file just sits there - mostly unmodified. Then the xsl stylesheet applies the style and selects which entries are display in what layout in the web browser. Like I said - it might be an ugly way to get there, but it does what I need it to do for this specific project.<br><br>I understand that this isn’t a xsl/xml 101 course, so please excuse any questions which are out of line for this mailing list. I’d enjoy learning how to properly make templates to use in Tellico, and would appreciate any suggestions to specific resources which could help me obtain that goal the quickest. I did just discover the xsl portion of the w3.org website, so I’ll start there.<br><br>Is there a way to search the mailing list’s archive?<br><br>Thanks again,<br>Fuzzy<o:p></o:p></span></p><p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0in 0in 0in'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Robby Stephenson [mailto:robby@periapsis.org] <br><b>Sent:</b> Wednesday, May 13, 2020 6:38 PM<br><b>To:</b> Fuzzy<br><b>Cc:</b> Tellico<br><b>Subject:</b> Re: Hello! (and <image> tag/string question)<o:p></o:p></span></p></div><p class=MsoNormal><o:p> </o:p></p><div><div><p class=MsoNormal>Hi!<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>On Wed, May 13, 2020 at 6:30 PM Fuzzy <<a href="mailto:tuser@fuzzyjazz.com" target="_blank">tuser@fuzzyjazz.com</a>> wrote:<o:p></o:p></p></div><div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>I just joined the list, so please forgive any breach in protocol. <br><br>First...thanks for Tellico. I love it.<o:p></o:p></p></div></div></blockquote><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Thanks! Glad you like it. No protocol here, happy to help anyone who's using Tellico.<o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>The first thing I realized was: Tellico files aren’t SQL database files. Then I realized they are basically XML files (correct me if I’ve missed any nuance here...I really don’t know what I’m doing).<o:p></o:p></p></div></div></blockquote><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Yes, they're XML files, usually zipped, though they don't have to be. You can use the Export menu to get them as a .zip file with the images included.<o:p></o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div><blockquote style='border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in'><div><div><p class=MsoNormal style='mso-margin-top-alt:auto;mso-margin-bottom-alt:auto'>Well, after spending a full 24 hours learning about xml and xsl, I finally was able to successfully port the data I wanted from my <a href="http://tellico.tc" target="_blank">tellico.tc</a> file into the format I wanted...all except the “image” data. (In this case the CD cover is contained within the .tc/xml file as a string?) I haven’t been able to figure out how to turn that string back into an image (I’m simply trying to have xsl export the image as an url(“background.jpeg”) type of thing into my formatted output.) xsl correctly grabs the proper “whateverrandomcharacters.jpeg” filename, but I don’t know how to convert the actual image string back into a jpeg. <o:p></o:p></p></div></div></blockquote><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Depending on your settings within the app, the images can either be saved within the XML file, as base64 encoded data (which isn't recommended since it makes the files rather large), as image files in the same directory as the .tc file (_files used for the directory name) or in a common directory in the user's folder. For the latter, the location is likely to be $HOME/.local/share/tellico/data/ and the image filename is what it is in the Tellico file. So just concatenate the file path with the image name.<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Depending on your workflow, you can use unzip and xsltproc to automate things. A few past discussions might be helpful:<o:p></o:p></p></div><div><p class=MsoNormal><a href="https://forum.kde.org/viewtopic.php?f=200&t=137533">https://forum.kde.org/viewtopic.php?f=200&t=137533</a><o:p></o:p></p></div><div><p class=MsoNormal><a href="https://mail.kde.org/pipermail/tellico-users/2018-October/001402.html">https://mail.kde.org/pipermail/tellico-users/2018-October/001402.html</a><o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal>Let me know if you have any other questions.<o:p></o:p></p></div><div><p class=MsoNormal>Robby<o:p></o:p></p></div><div><p class=MsoNormal><o:p> </o:p></p></div><div><p class=MsoNormal> <o:p></o:p></p></div></div></div></div></body></html>