+ Post New Thread
Results 1 to 5 of 5
General Chat Thread, e-mail to database or spreadsheet in General; Can anyone help me.... I've got over a 10000 e-mails to go through all which have come in from a ...
  1. #1
    bert113's Avatar
    Join Date
    Feb 2009
    Location
    Gloucestershire
    Posts
    22
    Thank Post
    16
    Thanked 1 Time in 1 Post
    Rep Power
    0

    e-mail to database or spreadsheet

    Can anyone help me....

    I've got over a 10000 e-mails to go through all which have come in from a standard form, just the titles vary, I want to extract certain fields and import them into preferably a spreadsheet or a database.

    Is there a freely available script which could do this (via outlook or windows mail etc..) , or am I going to have to purchase something.

    At the moment I have all e-mails held as web-mail via horde

    (this is for a football league website I run as a "hobby")

    Any help or advice would be appreciated

  2. #2

    Join Date
    Aug 2005
    Location
    London
    Posts
    3,144
    Thank Post
    113
    Thanked 518 Times in 447 Posts
    Blog Entries
    2
    Rep Power
    121
    Can you give an example of the content. I'd say it's unlikely that anything exists (free or paid for) which will do the job for you directly but it's the sort of thing which might be easy to script or use sed/awk/grep to work with, particularly if they're reasonably nicely formatted.

    If you can read them with Outlook then I'd guess you can use VBA - it's possible to step through each message in a folder, get the content and "do stuff" with it. If not, I think you will need to get them into text files which you can process.

    Next year it would be worth thinking about "what will I do with the data I collect" before you start :-) It would almost certainly be easier to have people fill in a simple web form which submits the results straight into a database but it's very easy for me to say that after the event ...

  3. Thanks to srochford from:

    bert113 (7th May 2010)

  4. #3
    bert113's Avatar
    Join Date
    Feb 2009
    Location
    Gloucestershire
    Posts
    22
    Thank Post
    16
    Thanked 1 Time in 1 Post
    Rep Power
    0
    Thank you, I know.... I should have thought about it, all I want is three fields

    The e-mails come in like this.... (all I need are the fields: other_team, player_of_the_match and sportsmanship)

    submit: submit your results

    date_played: 04/05/10

    your_team: Norton Eagles

    your_score: 1

    other_team: Abbeymead Rovers

    other_score: 3

    home_away: Home

    player_of_the_match: fred flintstone

    sportsmanship: 10

    referee: 10

    player1: name1

    player8: name2

    player2: name3

    player3: name4

    player4: name5

    player5: name6

    player6: name7

    player7: name8
    Last edited by bert113; 6th May 2010 at 06:57 PM.

  5. #4
    limbo's Avatar
    Join Date
    Aug 2005
    Location
    Birmingham
    Posts
    460
    Thank Post
    2
    Thanked 41 Times in 36 Posts
    Rep Power
    24
    If you are using Microsoft Outlook as your mail client and you have got a copy of Microsoft Access then you can set up an imported table in Access from Outlook folders and then set up queries / filters to extract the info.

    For MSAccess 2007 you go to the external data on the ribbon, in the import section click on more - one of the options is Outlook Folders. This will take you through a wizard to get the data into a table.

    You could then use the INSTR command to find specific data within the contents field of each message.

    Might take a while to get the commands right to grab each piece of data, and a vb solution might be quicker, but it depends on what you are most comfortable with.

  6. Thanks to limbo from:

    bert113 (7th May 2010)

  7. #5

    Join Date
    Oct 2007
    Location
    Lincolnshire
    Posts
    133
    Thank Post
    0
    Thanked 22 Times in 22 Posts
    Rep Power
    17
    It's easy to do this in perl. If you have the emails in individual files just pipe them through this program and get the output in csv format. Let me know if you need any help.

    Code:
    while (<>) {
    	tr/,/ /;
    	$oteam = $1 if /^other_team: (.*)$/;
    	$pom = $1 if /^player_of_the_match: (.*)$/;
    	$sports = $1 if /^sportsmanship: (.*)$/;
    	}
    print "$oteam,$pom,$sports\n";

  8. Thanks to keithu from:

    bert113 (7th May 2010)

SHARE:
+ Post New Thread

Similar Threads

  1. Anyone got a printer cost spreadsheet
    By SimpleSi in forum General Chat
    Replies: 5
    Last Post: 7th February 2010, 06:21 AM
  2. Replies: 1
    Last Post: 20th May 2008, 11:09 AM
  3. Easy spreadsheet function
    By park_bench in forum MIS Systems
    Replies: 1
    Last Post: 19th March 2008, 10:20 AM
  4. Excel - Spreadsheet Manipulation
    By danIT in forum Windows
    Replies: 1
    Last Post: 3rd July 2007, 01:28 PM
  5. google spreadsheet
    By russdev in forum Educational Software
    Replies: 15
    Last Post: 15th June 2006, 06:42 AM

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •