Zikula Community

• pheski
  
  

  • Rank: Expert
  • Registered: Feb 27, 2005
  • Last visit: Apr 18, 2010
  • Posts: 1577

  Posted: Jan 21, 2006 - 08:08 AM

  I'd like some feedback from both the wiser heads here who probably know some dependable ways this can be done, as well as wild-eyed crazy-ass ideas about how to pursue this.
  
  I am moderator of a mailing list with an archive now of 8000 or so messages over 6 years, still growing. The group periodically wants to revisit a previous discussion, at which point I have to search through the archived messages and excerpt or repost. What I am curious about, is: what approaches might be usable for making this archive accessible and searchable (poster, date, subject would probably be enough, content would be superb) through PN. And would allow me to add the new list posts every month.
  
  Perhaps my search skills just weren't up to the task, but I didn't find anything that seemed to apply - though obviously the concept is not much different from the concept behind commercial modules that provide a searchable on-line catalog.
  
  If it makes a difference, the archive I have consists of Eudora(Mac) messages - but I don't think this is particularly an issue. I know that it is possible to create a Filemaker database that would hold my archive and be searchable, though I have not actually done this. I plan to in the coming week, just to learn about the process.
  
  As always, I am not asking for the answer but would be happy for pointers to sources or ideas. I even wonder as I write whether this might be an appropriate starting project for someone who is teaching himself PHP to create a new module for the community? (I'm gonna have to take the plunge somewhere and sometime.)
  
  Peter
  
  --
  Peace
  ______________________________________
  The commonest cause of problems is solutions.

  • 
  •  
• ainigma32
  
  

  • Rank: Helper
  • Registered: Jan 29, 2004
  • Last visit: Oct 21, 2009
  • Posts: 852

  Posted: Jan 22, 2006 - 01:43 AM

  Well your last option sounds fine to me: the more modules the merrier
  
  I don't have an instant solution for this but I suppose you could transfer the mail archive to a DB and search it that way. The hard part would be the import process. Something like: read e-mail -> 'disect' into poster, date, subject, content -> create SQL INSERT statement -> execute SQL statement
  This approach assumes that all e-mail files have a common structure.
  
  HTH

  • 
  •  
•  
•  

Users on-line

• slam

This list is based on users active over the last 60 minutes.