Solved

Salesforce.com automated import question!

Posted on 2013-02-01
3
469 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 52

Assisted Solution

by:Scott Fell, EE MVE
Scott Fell,  EE MVE earned 500 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

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

In this post we will learn how to connect and configure Android Device (Smartphone etc.) with Android Studio. After that we will run a simple Hello World Program.
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
Explain concepts important to validation of email addresses with regular expressions. Applies to most languages/tools that uses regular expressions. Consider email address RFCs: Look at HTML5 form input element (with type=email) regex pattern: T…
The viewer will learn how to create and use a small PHP class to apply a watermark to an image. This video shows the viewer the setup for the PHP watermark as well as important coding language. Continue to Part 2 to learn the core code used in creat…

747 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now