Solved

Salesforce Inputting Data

Posted on 2010-09-03
4
180 Views
Last Modified: 2016-02-10
Hi all,

I regularly update information from information  recieve through emails in Outlook. I wonder would someone be able to help me to setup a way so that I could insert this information through coding in salesforce rather than having to copy and paste it in manually each time? I could create a text file through a macro in Outlook and then perhaps could enter this information through the system log seciton of Salesforce? I would appreciate any advise on it.

The type of information I would like to update is 3-4 fields under a particular opportunity for a customer.

Thanks,

Derek
0
Comment
Question by:TLN_CANADA
[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
4 Comments
 
LVL 2

Expert Comment

by:legendary1
ID: 33601542
I would highly recommend you look at the following software.

https://www.copy2contact.com

It's what I use daily and it has saved me sooo much time and accordingly money.
0
 

Author Comment

by:TLN_CANADA
ID: 33676191
Hi legendaty1, this program does not seem suitable for me. Do you know a way I can run a script to input this data. I think the language used is APEX in salesforce. If I could get an example from someone on how to update fields in an opportunity using this language that would be great.
0
 
LVL 11

Accepted Solution

by:
techhealth earned 500 total points
ID: 33698404
You may not actually need APEX language to do it.  If you can pipe the update information from Outlook to a CSV file, you can just run the APEX Data Loader - it's just called that, you don't necessarily have to know APEX to use it - periodically to update your Opportunity records in SFDC.  The Data Loader is scriptable on the command line, so you can have it run as scheduled task along with your macro.  It can be downloaded from Salesforce.com.  Just go to Setup > Administrator Setup > Data Management > Data Loader.
0
 

Author Comment

by:TLN_CANADA
ID: 33826467
Hi techhealth, I've investigated this but it will not work for what I want it to. Can you give me an example of APEX code I would need to do, something simple like update a particular opprotunity for example?

0

Featured Post

Guide to Performance: Optimization & Monitoring

Nowadays, monitoring is a mixture of tools, systems, and codes—making it a very complex process. And with this complexity, comes variables for failure. Get DZone’s new Guide to Performance to learn how to proactively find these variables and solve them before a disruption occurs.

Question has a verified solution.

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

When CRM stops functioning propperly or mysteriously disappears then this is something you should always check. This can be useful when looking at an end users machine or your own machine if you are the end user. It may be fairly obvious to some but…
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
Suggested Courses

734 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