ETL and Data Integration tools - Modern ETL software for everyone

Hello

We would like to process emails

the problem is that the attachments all have the same name (and this is something that we can't control). The only way to differentiate the attachment (or which attachment should be parsed into which table) is by using the header of the e-mail.

What is the best way to approach this?
chris

Can those emails be sent to separate email accounts?

Mike

Yes, we can send the e-mails to their own pop accounts. The only control we have is the header name. All files are called landscapeopera.txt, but, each represents a different file to go into a different table.

Examples of the email headers are

OR_trans_export
OR_Guest_details_inhouse
OR_With_Room_BLock

Chris

ok since you can send the e-mails to their own pop accounts I suggest to have a look at Advanced ETL Processor Pro/Ent which supports multiple email accounts

(Visual Importer Pro can use only one email account)

Mike