<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body text="#000000" bgcolor="#FFFFFF">
<p>This might be off-topic, but I would like suggestions as to how Tellico handles cover images in creating an XML export file. I am trying to create an XML file I can use as import to a Tellico Video collection.
<br>
</p>
<p>My source data is coming from a MySQL database (VideoDB web applicaiton) which includes an element that includes a file path; for example:
<br>
</p>
<p><style type="text/css">p { margin-bottom: 0.1in; line-height: 120%; }a:link { }</style></p>
<p style="margin-left: 0.49in; line-height: 100%"><imgurl>cache/img/1045.jpg</imgurl></p>
<p>Whereas Tellico XML export file includes the <cover> element which points to an <image> element with contents that have been encoded to a Base64 string; example:
<br>
</p>
<p><style type="text/css">p { margin-bottom: 0.1in; line-height: 120%; }a:link { }</style></p>
<p style="line-height: 100%"><cover><font color="#000099">f4910a966f8a3b0c2a4ea2e68d15ab5a.jpeg</font></cover></p>
<p style="line-height: 100%">and at the end of the Tellico XML file is the <images/> data
<br>
</p>
<p style="line-height: 100%"><style type="text/css">p { margin-bottom: 0.1in; line-height: 120%; }a:link { }</style></p>
<p style="line-height: 100%"><images></p>
<p style="line-height: 100%"><image width="77" format="JPEG" height="140" id="<font color="#000099"><font color="#000099">f4910a966f8a3b0c2a4ea2e68d15ab5a</font>.jpeg</font>">/9j/4AAQSkZJRgABAQEAYABgAAD/2wBDAAgGBgcGBQgHBwcJCQgKDBQNDAsLDBkSEw8UHRofHh0aHBwgJC4nICIsIxwcKDcpLDAxNDQ0<br>
bytes removed for simplicity <br>
yfyrS0u/vtMu40vb67gUKHV0RZ0C4yD3OPcVs+M72abwZZIxAWSWJmwMZOxj//2Q==</p>
<p style="line-height: 100%"></image></p>
<p style="line-height: 100%"></images></p>
<p style="line-height: 100%">I am using XSLT 1.0; and cannot find a way to tell XSLT to reach out to run the Encode action and return the base64 string that can be set to the contents of the <image> element. Tellico seems to be able to do that; but probably
uses C++ code and appropriate library functions. I am by no means an expert on XML/XSLT. If there is a better way I am open to suggestions.
<br>
</p>
<p style="line-height: 100%">I have over 1,000 videos in my collection; I might have to chop my conversion into small groups, but I would prefer to not have to Encode all my cover images manually to individual files that get saved to disk and then fetch one
at a time for an <image> element. The encode string only needs to exist long enough to get placed into the <image> element.
<br>
</p>
<p style="line-height: 100%">Thanks in advance for any ideas<br>
</p>
</body>
</html>