Salesforce.com automated import question!

Posted on 2013-02-01
Medium Priority
Last Modified: 2016-02-17

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.

Question by:joedfuse
  • 2
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

Accepted Solution

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

Author Closing Comment

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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

Data security in the cloud is very much like a security in an on-premises data center - only without costs for maintaining facilities and computer hardware.
The onset of year 2018 has been a usual business for IT teams still struggling to find their way out in terms of strengthening their cloud security.
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, f…
The is a quite short video tutorial. In this video, I'm going to show you how to create self-host WordPress blog with free hosting service.

624 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