<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=us-ascii">
<meta name=Generator content="Microsoft Word 12 (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;}
/* 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;}
p
        {mso-style-priority:99;
        mso-margin-top-alt:auto;
        margin-right:0in;
        mso-margin-bottom-alt:auto;
        margin-left:0in;
        font-size:12.0pt;
        font-family:"Times New Roman","serif";}
span.EmailStyle18
        {mso-style-type:personal-reply;
        font-family:"Calibri","sans-serif";
        color:windowtext;}
.MsoChpDefault
        {mso-style-type:export-only;}
@page Section1
        {size:8.5in 11.0in;
        margin:1.0in 1.0in 1.0in 1.0in;}
div.Section1
        {page:Section1;}
-->
</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=Section1>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>I’ll
look at /sor also.<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><o:p> </o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>William
Schaepe<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>Lenox
Web<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>646-213-6427
(Office)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>718-766-7480
(Fax)<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>wschaepe@LenoxWeb.net<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'>www.LenoxWeb.net<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-size:11.0pt;font-family:"Calibri","sans-serif"'><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"'>
consulting-bounces@drupal.org [mailto:consulting-bounces@drupal.org] <b>On
Behalf Of </b>David Hazel<br>
<b>Sent:</b> Wednesday, March 25, 2009 11:36 AM<br>
<b>To:</b> kb@2bits.com; A list for Drupal consultants and Drupal
service/hosting providers<br>
<b>Subject:</b> Re: [consulting] Need a Drpual consultant to write a custom
Search module<o:p></o:p></span></p>
</div>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>I was going to say try /solr or
/apachesolr<br>
<br>
DrupalCon DC Session<br>
<a
href="http://dc2009.drupalcon.org/session/more-search-how-apachesolr-changes-way-you-build-sites">http://dc2009.drupalcon.org/session/more-search-how-apachesolr-changes-way-you-build-sites</a><br>
<br>
Also I think the video of the session is up here:<br>
<a
href="http://aaronwinborn.com/video/more-search-how-apachesolr-changes-way-you-build-sites">http://aaronwinborn.com/video/more-search-how-apachesolr-changes-way-you-build-sites</a><br>
<br>
-dave<o:p></o:p></p>
<div>
<p class=MsoNormal>2009/3/25 Khalid Baheyeldin <<a href="mailto:kb@2bits.com">kb@2bits.com</a>><o:p></o:p></p>
<p class=MsoNormal style='margin-bottom:12.0pt'>Looks like a job for Sphinx.<br>
<br>
Check out these as the basis for your project:<br>
<br>
<a href="http://drupal.org/project/sphinxsearch" target="_blank">http://drupal.org/project/sphinxsearch</a><br>
<a href="http://drupal.org/project/sphinx" target="_blank">http://drupal.org/project/sphinx</a><o:p></o:p></p>
<div>
<p class=MsoNormal>2009/3/25 William Schaepe <<a
href="mailto:wschaepe@earthlink.net" target="_blank">wschaepe@earthlink.net</a>><o:p></o:p></p>
<div>
<div>
<div>
<div>
<p>I need a Drupal consultant to write a custom Search module:<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>My client has a Drupal installation running multiple sites (four) on the
same server. In each site there are non-drupal MySQL tables that contain
thousands of HTML pages. Currently there are three such tables, but more will
be added in the future.<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>The search module needs to search through the non-Drupal tables for keywords
and keyword phrases and generate a page(s) of prioritized results. The
viewer needs to be able to click on a result and view the HTML page within the
Drupal page.<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>Many (most) of the HTML pages have hyperlinks to other pages. These
links were generated when all the files were in folders and have relative
addressing. Now the page they will be pointing to will be some record in
the table.<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>Regards,<o:p></o:p></p>
<p>Bill Schaepe<o:p></o:p></p>
<p> <o:p></o:p></p>
<p>William Schaepe<o:p></o:p></p>
<p>Lenox Web<o:p></o:p></p>
<p>646-213-6427 (Office)<o:p></o:p></p>
<p>718-766-7480 (Fax)<o:p></o:p></p>
<p>wschaepe@LenoxWeb.net<o:p></o:p></p>
<p><a href="http://www.LenoxWeb.net" target="_blank">www.LenoxWeb.net</a><o:p></o:p></p>
<p> <o:p></o:p></p>
</div>
</div>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'>_______________________________________________<br>
consulting mailing list<br>
<a href="mailto:consulting@drupal.org" target="_blank">consulting@drupal.org</a><br>
<a href="http://lists.drupal.org/mailman/listinfo/consulting" target="_blank">http://lists.drupal.org/mailman/listinfo/consulting</a><o:p></o:p></p>
</div>
<p class=MsoNormal style='margin-bottom:12.0pt'><span style='color:#888888'><br>
<br clear=all>
<br>
-- <br>
Khalid M. Baheyeldin<br>
<a href="http://2bits.com" target="_blank">2bits.com</a>, Inc.<br>
<a href="http://2bits.com" target="_blank">http://2bits.com</a><br>
Drupal optimization, development, customization and consulting.<br>
Simplicity is prerequisite for reliability. -- Edsger W.Dijkstra<br>
Simplicity is the ultimate sophistication. -- Leonardo da Vinci<br>
</span><br>
_______________________________________________<br>
consulting mailing list<br>
<a href="mailto:consulting@drupal.org">consulting@drupal.org</a><br>
<a href="http://lists.drupal.org/mailman/listinfo/consulting" target="_blank">http://lists.drupal.org/mailman/listinfo/consulting</a><o:p></o:p></p>
</div>
<p class=MsoNormal><br>
<br clear=all>
<br>
-- <br>
Email is not a secure form of communication!<br>
<br>
Technologist<br>
<a href="http://www.hazelconsulting.com/">http://www.hazelconsulting.com/</a><br>
253.686.0296<br>
<a href="mailto:dave@hazelconsulting.com">dave@hazelconsulting.com</a><br>
skype: hazelconsulting<br>
gtalk:kananii<br>
ICQ: 366587185<o:p></o:p></p>
</div>
</body>
</html>