Hello,

I'm new to forums, not sure this is the proper place. We have a project we need help on. We are seeking people who can create Talend Jobs as explained below.

Business Purpose
By doing this we intend to automate the process of moving attachments from the Gmail account to the correct directory on the FTP server. File attachments are sent by email each day. The format for the data in the attachments is different for each sender. We use the sender to identify what data format to expect. Additionally, we hard code some data values based upon the sender. The data will be inserted into Salesforce accounts. This Job will be used about twenty times with different email and Salesforce accounts. Hard-coding the login credentials is fine.

Requirements
When the work is complete we will have received a ETL Job that we can import. The Job will retrieve the emails from a Gmail account and capture the attachments.

Senders
The “Sender” will be used to determine the Schema. We need to use different Schemas depending on the “Sender” email address. We can create the Schemas. The Schemas are to be used for the data in the attachments.

So the Job should use different Schemas depending on the Sender. The attachment must be used with the correct Sender.

Errors
If errors are detected, an email should be sent to help@honey.travel describing the file which errored or where the error occurred. The process should be able to be re-run upon error. So, if there are emails that won’t be read again, we need to know which emails.
Salesforce Insert

The data in the attachments will be inserted using a common Schema. We can give that Schema when you’re ready. Again, if this fails for any reason, we want an email sent to help@honey.travel and we need to be able to get the file out of the email inbox. If it makes more sense to move the email that is causing a problem to another folder, do that.