[jnaeve]

I get over 100 email alerts each week which are important to my business that contain about 12 data points pertaining to certain customer event activity. These messages are in the exact same format and content so there is little variation, in fact, you could assume they have "fields" that could be used to extract the relevant data needed.

I'm interested in using some sort of tool such as FileMaker or Crystal Reports, etc. and point to the email folder where the *.emlx files exist and have the tool import all of the relevant data then allow me to report on these 12 data points.

Is this something that someone here has done and if so, what tips can you give me to help me short-circuit the process. I'm not much of a programmer so please keep it as simple as possible.

Thanks in advance...
-- JimN

[Nivag]

Not my area of knowledge but is this what you are after?

Bits and Pieces: Use modular XSLT to simplify importing XML data into FileMaker

You might have better luck posting on Filemaker based forum site, if that's the route you choose.

here's one FileMaker and E-mail - FileMaker Pro Online Community

[besson3c]

It wouldn't be too hard to write a script that would search through the emails that grep finds as containing various patterns, and then applying regular expression pattern matching to parse out the data you are interested in.

However, this would obviously involve some programming which it sounds like you want to avoid... so....

[besson3c]

Let me know if you'd like me to lay out a skeleton script for you... I do this kind of thing all the time.

[Mithras]

If you can post a sample email (with actual sensitive content replaced by random text, obviously), I or besson3c or a dozen others could quickly work up a Ruby or Perl or Python script to parse the emails. Then it's just a question of what kind of output you want -- whether FileMaker or Crystal Reports or MySQL or a generic tab-delimited or CSV file that you could import to anything.