YahooGroups Online Search Tool using MySQL

Yahoogroups online search tool based on mysql

I searched very long for a tool to make the archive available in my own database.
Yahoo2mbox did not do it’s job I wanted
PG Offline was doing half what I wanted. So I needed to extend this kind of service.
So we did.

I was not happy with the way Yahoo is providing its search functionality to its users
My mailinglist is having more than 56.000 messages starting from the year 1999. Searching this database
will take hours. Now with these scripts: seconds.

find it in my scripts folder

My First PodCast [ VOC001]

AroundMyRoom’s first podcast called VOC-001
4 minutes talking with the record functionality of the Commodore E-VIC MP3 MusicBox Player
Download file

A little experiment cause I am using also a MovableType Plugin to see if it is inserted as enclosure. Again I am one of the few dutch webloggers doing this.

Fun

Weinig fun hier momenteel.

Scrapedfeeds.com heeft momenteel een backend probleem ivm de secties (eigenbelang); maker gemailed of hij een oplossing weet

mixfreaks.nl: druk bezig met de jaarmix pagina dagelijks bijhouden

Griftstate.com: samen met vrouwtje druk bezig met voorbereidingen om te verhuizen naar ons nieuwe appartement (moet nog opgeleverd worden en volgende week is de eerste kijkdag). Lilian is vandaag al wezen kijken en heeft de eerste foto’s binnen gemaakt/

mixfans.org: Qube draait goed en de servers draaien ok.

AroundMyroom.com: weblog op wat lager pitje geen leuke items te melden.

mixfreaks.org: mailinglijst up and running. GM 90 net uit. We worden weer in de booklet genoemd. Life can be fun.

meer domeinen? euh… jawel :-)
en nee, de blockquote vind ik maar nix

Geek Stuff: Yahoogroups to Access to Mysql #2

Today with some help added some code to the AccessDatabase.
Now new stuff will be added to the database .. One-Click solution.

INSERT INTO archive ( YahooMessageID, FromUser, FromEmail, Subject, SubjectSrt, RecDate, Message, AttCount, NewMsgFlag )
SELECT tblYgr_mixfreaks.YahooMessageID, tblYgr_mixfreaks.From, tblYgr_mixfreaks.FromEmail, tblYgr_mixfreaks.Subject, tblYgr_mixfreaks.SubjectSrt, tblYgr_mixfreaks.RecDate, tblYgr_mixfreaks.Message, tblYgr_mixfreaks.AttCount, tblYgr_mixfreaks.NewMsgFlag
FROM tblYgr_mixfreaks LEFT JOIN archive ON tblYgr_mixfreaks.YahooMessageID = archive.YahooMessageID
WHERE (((archive.YahooMessageID) Is Null));