Shortyspike
-
Total Posts
:
6
- Scores: 0
-
Reward points
:
0
- Joined: 2/7/2012
-
Status: offline
|
I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses
Tuesday, February 07, 2012 10:54 AM
( permalink)
These are form submissions from last year, all people who have liked our company on Facebook. We NEED these emails and have been trying to sue a brutal x-coworker who refused to show us the true location of these emails. So I need to develop a script that can pull either the email field from the emails themselves, OR find a way to import outlook emails into contacts. If anyone could point me in the right direction of scripting or KNOWS OF ONE IN EXISTENCE, that will save me some time. My company barely wants to pay me to write a script, ONLY WILL because they really want these emails and have for a year now.
|
|
|
|
59cobalt
-
Total Posts
:
973
- Scores: 91
-
Reward points
:
0
- Joined: 7/17/2011
-
Status: offline
|
Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses
Wednesday, February 08, 2012 12:34 AM
( permalink)
What kind of "inbox" are you talking about? Is this an Exchange mailbox? IMAP? POP3? Notes? Some webmailer? If you want help you need to give us something to work with.
|
|
|
|
Shortyspike
-
Total Posts
:
6
- Scores: 0
-
Reward points
:
0
- Joined: 2/7/2012
-
Status: offline
|
Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses
Wednesday, February 08, 2012 4:44 AM
( permalink)
We host our own emails on our webserver. The emails are stored there, and like I said above find a way to export the OUTLOOK emails into contacts of the "From" field. Whichever would be easiest to script either connecting to the webserver or outlook.
|
|
|
|
59cobalt
-
Total Posts
:
973
- Scores: 91
-
Reward points
:
0
- Joined: 7/17/2011
-
Status: offline
|
Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses
Wednesday, February 08, 2012 6:54 AM
( permalink)
There are no "Outlook" e-mails. There are just e-mails. Let me rephrase my question: are the e-mails in question stored locally (e.g. in a PST file), or are they stored on the server? If they are stored on the server: what kind of mail server software are you using? Exchange? An IMAP server like Cyrus or Dovecot? Something entirely different?
|
|
|
|
Shortyspike
-
Total Posts
:
6
- Scores: 0
-
Reward points
:
0
- Joined: 2/7/2012
-
Status: offline
|
Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses
Wednesday, February 08, 2012 7:13 AM
( permalink)
It is an IMAP server with a cPanel back end entry. We are hosted through "Host Gator"
|
|
|
|
Shortyspike
-
Total Posts
:
6
- Scores: 0
-
Reward points
:
0
- Joined: 2/7/2012
-
Status: offline
|
Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses
Wednesday, February 08, 2012 7:20 AM
( permalink)
I understand there are no "outlook" emails. I was simply asking would it be easier to write a script that could work WITH outlook. OR would it be easier to write one for the SERVER where the emails are ORIGINALLY, but ALSO stored.
|
|
|
|
59cobalt
-
Total Posts
:
973
- Scores: 91
-
Reward points
:
0
- Joined: 7/17/2011
-
Status: offline
|
Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses
Wednesday, February 08, 2012 8:05 AM
( permalink)
Since the mails are stored on an IMAP server, i'd say it's easier to get them from there, provided you have shell access to the server. cPanel seems to use Courier as its IMAP server component, which stores mails in Maildir format. Thus you can probably use a simple Perl script (or even grep/sed/awk) to extract the From: header from the e-mail files.
|
|
|
|
Shortyspike
-
Total Posts
:
6
- Scores: 0
-
Reward points
:
0
- Joined: 2/7/2012
-
Status: offline
|
Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses
Wednesday, February 08, 2012 8:21 AM
( permalink)
Yeah I'll take a look around at the scripts and hopefully get this done by tomorrow! Thanks for the help.
|
|
|
|
59cobalt
-
Total Posts
:
973
- Scores: 91
-
Reward points
:
0
- Joined: 7/17/2011
-
Status: offline
|
Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses
Wednesday, February 08, 2012 8:52 AM
( permalink)
You're welcome. Feel free to ask if you need help with the Perl (or shell) script.
|
|
|
|
ebgreen
-
Total Posts
:
8227
- Scores: 98
-
Reward points
:
0
- Joined: 7/12/2005
-
Status: offline
|
Re:I have 20k odd emails in an inbox that I would LOVE to extract ONLY the email addresses
Wednesday, February 08, 2012 8:56 AM
( permalink)
Or doing it in Powershell
|
|
|
|