?
Solved

Salesforce.com automated import question!

Posted on 2013-02-01
3
Medium Priority
?
538 Views
Last Modified: 2016-02-17
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
0
Comment
Question by:joedfuse
  • 2
3 Comments
 
LVL 54

Assisted Solution

by:Scott Fell, EE MVE
Scott Fell,  EE MVE earned 2000 total points
ID: 38846968
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
 

Accepted Solution

by:
joedfuse earned 0 total points
ID: 38847063
Actually I think it can be accomplished using the app eLoader on the app store. I havent tried it yet though
0
 

Author Closing Comment

by:joedfuse
ID: 38870782
As the experts comment would have probably ended up with a good solution mine was more what I was looking for.
0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In real business world data are crucial and sometimes data are shared among different information systems. Hence, an agreeable file transfer protocol need to be established.
As managed cloud service providers, we often get asked to intervene when cloud deployments go awry. Attracted by apparent ease-of-use, flexibility and low computing costs, companies quickly adopt leading public cloud platforms such as Amazon Web Ser…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.

839 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question