<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<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 name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@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;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
@font-face
{font-family:"Century Gothic";
panose-1:2 11 5 2 2 2 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-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;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.EmailStyle17
{mso-style-type:personal;
font-family:"Century Gothic","sans-serif";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Century Gothic","sans-serif";
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.EmailStyle20
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
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=SV link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Hi Cristiano.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Thanks for your reply.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>It seems like your attached zip file was removed somewhere on the way, probably in your end, since it is missing both in your mail to me and in the one to rt-users. It has been replaced by a text file containing “This attachment was removed by Edge3 Transport Agent”. Is it a lot of code, or could you add it to the wiki as well?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>/Johan<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> Guadagnino Cristiano [mailto:guadagnino.cristiano@creval.it] <br><b>Sent:</b> den 11 januari 2011 12:22<br><b>To:</b> Johan Sjöberg<br><b>Cc:</b> rt-users@lists.bestpractical.com<br><b>Subject:</b> R: Sphinx full-text search engine in RT<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'>Hi Johan,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'>I am attaching the missing files to this message.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'>You'll also find "sorttable-RT.js", which we implemented after I wrote the article: with this you can sort the results table by clicking on the field names in the table header (like other tables in RT). It still lacks feedback when you hover the table headers, but it works very well otherwise.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'>To enable table sorting you have to modify sphinx.php and insert the following code in the <b><i><head></i></b> section (obviosuly you'll have to adapt the path):<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:36.0pt'><span lang=EN-US style='font-family:"Courier New";color:blue'><script src='JavaScript/sorttable-RT.js' type='text/javascript'></script><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'>Before doing this, please reget the sphinx.php script from the wiki because I'm going to add a few lines of necessary code there.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'>Hope this helps!<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'>Bye<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'>Cristiano<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='font-family:"Century Gothic","sans-serif";color:blue'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=IT style='font-size:10.0pt;font-family:"Segoe UI","sans-serif"'>Da:</span></b><span lang=IT style='font-size:10.0pt;font-family:"Segoe UI","sans-serif"'> Johan Sjöberg [mailto:johan.sjoberg@deltamanagement.se] <br><b>Inviato:</b> Tuesday, January 11, 2011 10:39 AM<br><b>A:</b> Guadagnino Cristiano; rt-users@lists.bestpractical.com<br><b>Oggetto:</b> RE: Sphinx full-text search engine in RT<o:p></o:p></span></p></div></div><p class=MsoNormal><span lang=EN-US><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Hi.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Thanks for your great work. I am currently trying to follow your documentation to integrate sphinx in our RT setup, and I have run into some problems.<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>In sphinx.php, you include MySql.class.php and Timer.class.php. What are these? Have you written them yourself, or are they available for download somewhere?<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Best Regards,<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'>Johan<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-US style='color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0cm 0cm 0cm 4.0pt'><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span lang=EN-US style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> rt-users-bounces@lists.bestpractical.com [mailto:rt-users-bounces@lists.bestpractical.com] <b>On Behalf Of </b>Guadagnino Cristiano<br><b>Sent:</b> den 13 september 2010 15:22<br><b>To:</b> rt-users@lists.bestpractical.com<br><b>Subject:</b> [rt-users] Sphinx full-text search engine in RT<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal><span lang=IT style='font-family:"Century Gothic","sans-serif"'>Hi all,<o:p></o:p></span></p><p class=MsoNormal><span lang=IT style='font-family:"Century Gothic","sans-serif"'>I just wanted to let everyone know that I have finished integrating the Sphinx search engine in our RT.<o:p></o:p></span></p><p class=MsoNormal><span lang=IT style='font-family:"Century Gothic","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span lang=IT style='font-family:"Century Gothic","sans-serif"'>It is simply great: full-text searches on the whole RT db in just fractions of a second!<o:p></o:p></span></p><p class=MsoNormal><span lang=IT style='font-family:"Century Gothic","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span lang=IT style='font-family:"Century Gothic","sans-serif"'>I am slowly documenting the whole thing on the RT wiki. You can find it by looking for "IntegratingSphinx". It is not yet complete though.<o:p></o:p></span></p><p class=MsoNormal><span lang=IT style='font-family:"Century Gothic","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span lang=IT style='font-family:"Century Gothic","sans-serif"'>I hope it will be useful to somebody else.<o:p></o:p></span></p><p class=MsoNormal><span lang=IT style='font-family:"Century Gothic","sans-serif"'><o:p> </o:p></span></p><p class=MsoNormal><span lang=IT style='font-family:"Century Gothic","sans-serif"'>Bye<o:p></o:p></span></p><p class=MsoNormal><span lang=IT style='font-family:"Century Gothic","sans-serif"'>Cris<o:p></o:p></span></p><p class=MsoNormal><span lang=IT style='font-family:"Century Gothic","sans-serif"'><o:p> </o:p></span></p></div></div></div></body></html>