Solved

Salesforce.com automated import question!

Posted on 2013-02-01
3
499 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 53

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

Containers & Docker to Create a Powerful Team

Containers are an incredibly powerful technology that can provide you and/or your engineering team with huge productivity gains. Using containers, you can deploy, back up, replicate, and move apps and their dependencies quickly and easily.

Question has a verified solution.

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

Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
Your data is at risk. Probably more today that at any other time in history. There are simply more people with more access to the Web with bad intentions.
Video by: Mark
This lesson goes over how to construct ordered and unordered lists and how to create hyperlinks.
Simple Linear Regression

695 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