Discussion Locked

Extract Email Info to Database

0 helpful
7 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Clients go online to various websites and submit their contact information. The information is emailed to us in text or XML format. I need export/extract the contact information to a database or file type that can be imported into a database. I have 1 week to identify a solution and implement. HELP!

7 replies

by brian

Microsoft makes a tool called the xml parser.
Here is a link to an article titled

Unlocking Office XML Data Through the XML Document Object Model

It is Microsofts explanation of how to do this.

http://msdn.microsoft.com/
library/default.asp?url=/
library/en-us/dnxpwst/html/
odc_ofusingxdom.asp

by johnfriz

Hi,

I recently had to do something very similar to this.

When you receive the email with the contact details, is there an identifier in the email that appears before every contact name address.

For example, the emails I was dealing with had the text
-textareaname :
before every name/address.

If you have a situation like this, it is quite easy to write an application that will open each email and parse it for the identifier, then strip out the contact details.

I would suggest using VB if you are going to do this, because it has good file handling and string manipulation. Also it would be possible to connect to your database and automatically populate it with the details.

I can give you some more information if you are interested.

Regards,
John.

by rrv

Check for EDI standards. If the sender can send in EDI universal standard, you can program to read the cryptic EDI document, parse it and upload to your database.
RV

This discussion is closed to new replies.