Wow! that's fantastic. If you send me the schema of the DB, I can whip up some PHP to search the DB. Maybe you could share the source code as well? Thanks. On Mon, May 25, 2009 at 2:44 PM, Steve Obbayi <steve@sobbayi.com> wrote:
@peter. I decided to take up and do what you had been trying to do. i have mailed alex gakuru the parsed monthly archives. Now some months were missing from the archives and all i had was up to March 2009. So there are about four archive files which still need to be parsed.
To do this I developed a tool which has done this job very well. Am sending Alex the source code for the tool which can be compiled on any OS as long as it has a C++ compiler .
Now all i developed was the tool and used it to parse all the files, i have also given the schema for the data file and the query to load it into a MYSQL database. So as far as code to make the data searchable i dont think i can squeez in time for that so maybe you or someone from this list can take it up and develop one for our sakes. Steve Obbayi,
------------------------------ *From:* skunkworks-bounces@lists.my.co.ke [mailto: skunkworks-bounces@lists.my.co.ke] *On Behalf Of *Peter Karunyu *Sent:* Tuesday, April 07, 2009 6:08 PM *To:* Skunkworks forum *Subject:* Re: [Skunkworks] Skunkworks List and available resources
Hi Alex, I think its time I did what I've been waiting for someone to do; load all the past conversations into a searchable database. I had started with the text file for march, I went through it looking for unique sequences which i could then use as "markers" separating one thread from another, then use the PHP *explode* function to load the individual threads into a MySQL table.
My main motivation was to be able to search past entries.
Has someone done something similar?
On Mon, Apr 6, 2009 at 9:02 PM, Gakuru Alex <alexgakuru.lists@gmail.com>wrote:
Did we also lose all our past talk:-( I notice http://lists.my.co.ke/pipermail/skunkworks/ only has the current month's archives. On 25th last month, I downloaded the following from the previous server archives:-
2008-March.txt.gz 2008-April.txt.gz 2008-June.txt.gz 2008-July.txt.gz 2008-August.txt.gz 2008-September.txt.gz 2008-October.txt.gz 2008-November.txt.gz 2008-December.txt.gz
2009-January.txt.gz 2009-February.txt.gz 2009-March.txt.gz
5 MB in total. If needed for institutional memory/restore and KeNIC does not have the full backups just let me know to send.
regards,
Alex
On Mon, Apr 6, 2009 at 6:33 PM, Lmwangi <lmwangi@gmail.com> wrote:
Hi all, * As you may have noticed, we are on a new server. Migrating to the new box resulted in a loss of your settings (Digests/Plain text mails etc.). Please visit http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks to adjust your personal settings * We also do have an announce list for products/meeting announcements. You may want to subscribe through http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce. * my.co.ke hosts a bulletin board that you can visit at http://my.co.ke/phpbb/index.php . We intend to use it to complement the mailing list. * To find out about all the services available, my.co.ke index page has a simple listing * If you have any questions/request please reply to this thread.
Regards, Laban _______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke
_______________________________________________ Skunkworks mailing list Skunkworks@lists.my.co.ke http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks Other services @ http://my.co.ke Other lists ------------- Skunkworks announce: http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks-announce Science - http://lists.my.co.ke/cgi-bin/mailman/listinfo/science kazi - http://lists.my.co.ke/cgi-bin/mailman/admin/kazi/general