ETL and Data Integration tools - Modern ETL software for everyone

Dear support

I am trying to parse email messages using Advanced ETL.
The problem I have that the messages are quite long ones.
For example I would like to extract a customer ID.
It is on the line 55 on the email starting from the character 20.
I am using splitter transformation object to get line 55 and substring function to get actual actual customer id.
But splitter object is too big and I only need one line from it.
Can you create another function called for example \"Get line\" with three parameters delimiter, quote and line number.
This will make my life much easier

John

Sound like a good idea.
We will add it to the next release of our ETL Products

BTW how did you load Emails in the database in the first place?

Peter

Since your ETL Products support OLE DB we used JET OLE DB Provider to get email messages

Below is how:

Connecting to an Outlook personal mail box using the JET OLE DB Provider

Provider=Microsoft.Jet.OLEDB.4.0;Outlook 9.0;\"MAPILEVEL=;DATABASE=C:\\Temp\\;

Replace c:\temp with any temporary folder. It will create a schema file in that folder when you open it which shows all the fields available. Blank MAPILEVEL indicates top level of folders).
Connecting to an Exchange mail box through JET:

Provider=Microsoft.Jet.OLEDB.4.0;Exchange 4.0; MAPILEVEL=Mailbox - John|;DATABASE=C:\\Temp\\;

You must replace c:\\temp with any temporary folder.

Replace John with the name of the mail box and you must keep vertical pipe character | to indicate top level of folders. Place sub folder after vertical pipe if accessing specific folder.

as a result you can enter queries against the mail store just like a database... For example:

SELECT Contacts.* FROM Contacts

For more information, see:
msdn.microsoft.com/en-us/library/aa160682%28office.11%29.aspx

John

Hm...

I did not realise that is s possible.

There reason I asked the question that we are currently working on adding SMTP as a TARGET and POP3 as source for Advanced ETL Processor

This might be useful for you as well

Mike