Solved

Salesforce Inputting Data

Posted on 2010-09-03
4
173 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
  • 2
4 Comments
 
LVL 2

Expert Comment

by:legendary1
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

I showed you how to use console view (HERE (http://www.experts-exchange.com/articles/18379/Getting-Started-and-Using-the-Salesforce-com-Console.html)) -– but how do you set it up on the admin side of Salesforce? Note that you have to have Admin leve…
In our personal lives, we have well-designed consumer apps to delight us and make even the most complex transactions simple. Many enterprise applications, however, are a bit behind the times. For an enterprise app to be successful in today's tech wo…
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

762 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

14 Experts available now in Live!

Get 1:1 Help Now