General discussion

Locked

Extract Email Info to Database

By sarah ·
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!

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Extract Email Info to Database

by brian In reply to Extract Email Info to Dat ...

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

Collapse -

Extract Email Info to Database

by sarah In reply to Extract Email Info to Dat ...

The question was auto-closed by TechRepublic

Collapse -

Extract Email Info to Database

by johnfriz In reply to Extract Email Info to Dat ...

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.

Collapse -

Extract Email Info to Database

by sarah In reply to Extract Email Info to Dat ...

The question was auto-closed by TechRepublic

Collapse -

Extract Email Info to Database

by RRV In reply to Extract Email Info to Dat ...

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

Collapse -

Extract Email Info to Database

by sarah In reply to Extract Email Info to Dat ...

The question was auto-closed by TechRepublic

Collapse -

Extract Email Info to Database

by sarah In reply to Extract Email Info to Dat ...

This question was auto closed due to inactivity

Back to Web Development Forum
7 total posts (Page 1 of 1)  

Related Forums