Salesforce.com automated import question!

Hello,

I just came across a real tricky question and am really stumped.

I'm wondering if there is a way either custom built or in an app in the app exchange to receive an email with csv attachment and import the data from the the file directly in salesforce.

The scenario is that a file gets emailed from a third party system daily with a csv file with approx 1500 records.

I need a way to have salesforce receive the email parse the csv file and import the content to a custom object.

I have seen an app that allows you to receive emails but doesn't do much more than that.

Any suggestions would be appreciated.

THanks
joedfuseAsked:
Who is Participating?
 
joedfuseConnect With a Mentor Author Commented:
Actually I think it can be accomplished using the app eLoader on the app store. I havent tried it yet though
0
 
Scott Fell, EE MVEConnect With a Mentor Developer & EE ModeratorCommented:
I have never done this.  But I think you will need to grab the attachment from your email server then use one of the api's  to import from your sever to salesforce http://wiki.developerforce.com/page/Tools

I am going to try this out myself. I just found this project to read your emails from the server  https://github.com/eleith/emailjs
0
 
joedfuseAuthor Commented:
As the experts comment would have probably ended up with a good solution mine was more what I was looking for.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.