receiving emailed "form" data into FM

[jhlincoln]

Does anyone know of a method (AppleScript, standalone app, or otherwise) for taking raw "forms" data which has been received via email (using OSX's Mail.app) from a web site (e.g., name and address data), and converting it to tab-delimited text -- so that it can be imported into a FileMaker database?

[Didier]

1. I assume that you can fix the subject of the Emails without any possible modifications by the web users . This will help you trying to identify in the Mail app what mails to take into account.

2. I also assume that you can receive from the web something structured such as

[Name]

My Name ...

[/Name]

[First Name]

Didier

[/First Name]

and so on

What's in between the tags is set by the web user and the tags are yours.

3. Filemaker is able to execute Applescripts Using scriptmaker.

4. Go and see macscripter.net for scriptable applications / Mail, you will find its Apllescript vocabulary.

5. You will more than probably be able to get the content of the mails you did receive with a particular subject (cf 1) in you mail app and set a filemaker field content to the content of the body of the mail.

6. Read the contents in between each tags and fill the corresponding fields in your Db.

Hope it helps,