[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 202
  • Last Modified:

eml file report with hyperlinks

I have a bunch of individual EML files (emails) that were exported from a mailbox to a windows file share. I need some software or script that can scan the files and create a report I.e.( csv/HTML) to list the sent and received dates within the EML files, and ideally the distribution list (i.e. senders and receivers), and ideally the report should create a hyper-link to the eml file on disc. Is this possible?
0
pma111
Asked:
pma111
  • 6
  • 5
1 Solution
 
Joe Winograd, EE MVE 2015&2016DeveloperCommented:
I don't know of software that does this, but it wouldn't be very difficult to write such a program. If you can't find an existing product that does it, you may want to look in member profiles here at EE for folks with the Hire Me button.

Some questions on the specs:

o  Do you want a graphical user interface, command line interface, or both?

o  Do you want all recipients (TO, CC, BCC) in the same cell or in different cells?

o  If there's a very large number of recipients (e.g., a hundred addresses on the TO line), do you want all of them, or do you want to be able to specify a maximum number?

o  Do you want the display name, the email address, or both? For example, consider the FROM line:

From: Experts Exchange <noreply@experts-exchange.com>

Possibilities for the CSV file are:

(1) Experts Exchange <noreply@experts-exchange.com>
(all in one cell)

(2) Experts Exchange noreply@experts-exchange.com
(all in one cell with angle brackets removed)

(3) Experts Exchange

in one cell and

<noreply@experts-exchange.com>

or

noreply@experts-exchange.com

in another cell.

There are surely other design issues that need to be specified, but those are off the top of my head. Regards, Joe
0
 
pma111Author Commented:
Hi Joe,

Thanks for the reply...

No GUI neccesary, command line/script would be fine

Either same cell or split is fine, whichever is easier

Ideally all - think there is a policy in place on max number of receipients for standard users anyway so shouldnt be an issue

Both would be ideal

Thanks
0
 
Joe Winograd, EE MVE 2015&2016DeveloperCommented:
> No GUI neccesary, command line/script would be fine

Would a GUI be ok (rather than a CLI)?

> a windows file share

Are all the EML files in a single folder or will the program need to look in subfolders?
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
pma111Author Commented:
Gui fine and we can run it many times over different folders and a report per folder would be great
0
 
Joe Winograd, EE MVE 2015&2016DeveloperCommented:
> the sent and received dates within the EML files

The EML files I looked at (File>Save As>File from Thunderbird 31.0 with POP mail) have a "Delivery-date:" line and a "Date:" line. Those are the dates I would propose to put in the CSV file. I'm not an expert on the internal format of EML files, but web research indicates that dates can be problematic sometimes (and that there are differences in the EML files created from POP and IMAP emails). Look at a few of your EML files in a text editor (Notepad is fine) and let me know if the "Delivery-date:" line and "Date:" lines are there. Thanks, Joe
0
 
pma111Author Commented:
Will do joe thanks they are basically exported from an exchange pst file
0
 
Joe Winograd, EE MVE 2015&2016DeveloperCommented:
I just did an Export from Outlook 2013 (IMAP, not Exchange) and the only file type choices are CSV and PST — not EML. I also tried Save As, but the only choices there are TXT, OFT, MSG, HTML, and MHT — again, not EML. How did you export/save EML files from an Outlook PST file?
0
 
pma111Author Commented:
Its through a 3rd party forensics software called intella 10
0
 
Joe Winograd, EE MVE 2015&2016DeveloperCommented:
Ah, that explains it!
0
 
pma111Author Commented:
I presume nothing in this area exists at present?
0
 
Joe Winograd, EE MVE 2015&2016DeveloperCommented:
Not that I'm aware of, but, as I mentioned earlier in <http:#a40246257>, it wouldn't be very difficult to develop a custom program for it.
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 6
  • 5
Tackle projects and never again get stuck behind a technical roadblock.
Join Now