• Sign in to Neowin Faster!

    Create an account on Neowin to contribute and support the site.

  • 0
Sign in to follow this  

Parse Emails? (from Gmail)

Question

primexx    372

Hello,

I'm trying to get some statistics on a couple of thousand emails in Gmail, and was wondering what the best way to do this would be.

I'm thinking the first step would be to download it via POP or IMAP to a desktop client, but I'm not very familiar with desktop clients. Do they store the emails in their own database or each as a separate file? Which client would be the easiest to work with if, for example, I want to extract the Title and timestamp of each email and dump that into a csv?

Also, how would I go about that part about dumping the title and timestamp into a csv?

Thanks!

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0
johnporter29    95

Hello,

I'm trying to get some statistics on a couple of thousand emails in Gmail, and was wondering what the best way to do this would be.

I'm thinking the first step would be to download it via POP or IMAP to a desktop client, but I'm not very familiar with desktop clients. Do they store the emails in their own database or each as a separate file? Which client would be the easiest to work with if, for example, I want to extract the Title and timestamp of each email and dump that into a csv?

Also, how would I go about that part about dumping the title and timestamp into a csv?

Thanks!

You can use PHP to communicate with an IMAP Server and download the emails from there, I'm doing something similar at work at the moment. If you can wait till tomorrow, I can post some links that I used to get started..... I have also mangaed to get the code to connect to Gmail direct!

Share this post


Link to post
Share on other sites
  • 0
primexx    372

So I discovered that it's possible to export all the survey results and get the timestamps from there, instead of relying on the timestamps of the email notifications for submission. But unfortunately it's recorded in human-readable form rather than timestamps, in a different time zone ><

In any case, it'd be interesting to check out your links for grabbing emails, would be fun to play with.

Thanks!

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
Sign in to follow this  

  • Recently Browsing   0 members

    No registered users viewing this page.