?
Solved

Salesforce.com automated import question!

Posted on 2013-02-01
3
Medium Priority
?
507 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 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

Secure Your WordPress Site: 5 Essential Approaches

WordPress is the web's most popular CMS, but its dominance also makes it a target for attackers. Our eBook will show you how to:

Prevent costly exploits of core and plugin vulnerabilities
Repel automated attacks
Lock down your dashboard, secure your code, and protect your users

Question has a verified solution.

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

This article was originally published on Monitis Blog, you can check it here . Today it’s fairly well known that high-performing websites and applications bring in more visitors, higher SEO, and ultimately more sales. By the same token, downtime…
There’s a movement in Information Technology (IT), and while it’s hard to define, it is gaining momentum. Some call it “stream-lined IT;” others call it “thin-model IT.”
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
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…
Suggested Courses

777 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