<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:x="urn:schemas-microsoft-com:office:excel" xmlns:p="urn:schemas-microsoft-com:office:powerpoint" xmlns:a="urn:schemas-microsoft-com:office:access" xmlns:dt="uuid:C2F41010-65B3-11d1-A29F-00AA00C14882" xmlns:s="uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882" xmlns:rs="urn:schemas-microsoft-com:rowset" xmlns:z="#RowsetSchema" xmlns:b="urn:schemas-microsoft-com:office:publisher" xmlns:ss="urn:schemas-microsoft-com:office:spreadsheet" xmlns:c="urn:schemas-microsoft-com:office:component:spreadsheet" xmlns:odc="urn:schemas-microsoft-com:office:odc" xmlns:oa="urn:schemas-microsoft-com:office:activation" xmlns:html="http://www.w3.org/TR/REC-html40" xmlns:q="http://schemas.xmlsoap.org/soap/envelope/" xmlns:rtc="http://microsoft.com/officenet/conferencing" xmlns:D="DAV:" xmlns:Repl="http://schemas.microsoft.com/repl/" xmlns:mt="http://schemas.microsoft.com/sharepoint/soap/meetings/" xmlns:x2="http://schemas.microsoft.com/office/excel/2003/xml" xmlns:ppda="http://www.passport.com/NameSpace.xsd" xmlns:ois="http://schemas.microsoft.com/sharepoint/soap/ois/" xmlns:dir="http://schemas.microsoft.com/sharepoint/soap/directory/" xmlns:ds="http://www.w3.org/2000/09/xmldsig#" xmlns:dsp="http://schemas.microsoft.com/sharepoint/dsp" xmlns:udc="http://schemas.microsoft.com/data/udc" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:sub="http://schemas.microsoft.com/sharepoint/soap/2002/1/alerts/" xmlns:ec="http://www.w3.org/2001/04/xmlenc#" xmlns:sp="http://schemas.microsoft.com/sharepoint/" xmlns:sps="http://schemas.microsoft.com/sharepoint/soap/" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:udcs="http://schemas.microsoft.com/data/udc/soap" xmlns:udcxf="http://schemas.microsoft.com/data/udc/xmlfile" xmlns:udcp2p="http://schemas.microsoft.com/data/udc/parttopart" xmlns:wf="http://schemas.microsoft.com/sharepoint/soap/workflow/" xmlns:dsss="http://schemas.microsoft.com/office/2006/digsig-setup" xmlns:dssi="http://schemas.microsoft.com/office/2006/digsig" xmlns:mdssi="http://schemas.openxmlformats.org/package/2006/digital-signature" xmlns:mver="http://schemas.openxmlformats.org/markup-compatibility/2006" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns:mrels="http://schemas.openxmlformats.org/package/2006/relationships" xmlns:spwp="http://microsoft.com/sharepoint/webpartpages" xmlns:ex12t="http://schemas.microsoft.com/exchange/services/2006/types" xmlns:ex12m="http://schemas.microsoft.com/exchange/services/2006/messages" xmlns:pptsl="http://schemas.microsoft.com/sharepoint/soap/SlideLibrary/" xmlns:spsl="http://microsoft.com/webservices/SharePointPortalServer/PublishedLinksService" xmlns:Z="urn:schemas-microsoft-com:" xmlns:st="" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=iso-8859-1"><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;}
@font-face
{font-family:"Century Gothic";
panose-1:2 11 5 2 2 2 2 2 2 4;}
@font-face
{font-family:"Segoe UI";
panose-1:2 11 5 2 4 2 4 2 2 3;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
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;}
span.StileMessaggioDiPostaElettronica17
{mso-style-type:personal;
font-family:"Century Gothic","sans-serif";
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
span.StileMessaggioDiPostaElettronica18
{mso-style-type:personal;
font-family:"Calibri","sans-serif";
color:#1F497D;}
span.StileMessaggioDiPostaElettronica19
{mso-style-type:personal-reply;
font-family:"Century Gothic","sans-serif";
color:blue;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@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-family:"Century Gothic","sans-serif";color:blue'>Hi Johan,<o:p></o:p></span></p><p class=MsoNormal><span 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 style='font-family:"Century Gothic","sans-serif";color:blue'><o:p> </o:p></span></p><p class=MsoNormal><span 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 style='font-family:"Century Gothic","sans-serif";color:blue'><o:p> </o:p></span></p><p class=MsoNormal><span 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 style='font-family:"Century Gothic","sans-serif";color:blue'><o:p> </o:p></span></p><p class=MsoNormal style='margin-left:.5in'><span 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 style='font-family:"Century Gothic","sans-serif";color:blue'><o:p> </o:p></span></p><p class=MsoNormal><span 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 style='font-family:"Century Gothic","sans-serif";color:blue'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:blue'>Hope this helps!<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:blue'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:blue'>Bye<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Century Gothic","sans-serif";color:blue'>Cristiano<o:p></o:p></span></p><p class=MsoNormal><span 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 0in 0in 0in'><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><o:p> </o:p></p><p class=MsoNormal><span style='color:#1F497D'>Hi.<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span 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 style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span 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 style='color:#1F497D'><o:p> </o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Best Regards,<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'>Johan<o:p></o:p></span></p><p class=MsoNormal><span style='color:#1F497D'><o:p> </o:p></span></p><div style='border:none;border-left:solid blue 1.5pt;padding:0in 0in 0in 4.0pt'><div><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"'> 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><span lang=SV><o:p> </o:p></span></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></body></html>