Mass-Editing data in Salesforce is a pain. And even if tools like AppBuddy make this less click-intensive, none comes close to Excel or Google Spreadsheet.
So I was just thinking if one could push data into an empty Google Spreadsheet, let people edit it there and then synch the changes back to Salesforce.com.
It took me seconds to find and install the Google Data Toolkit for Salesforce. But it seems this is faulty. Every request to Google servers return with
The page you have requested cannot be viewed(displayed). Another site was requesting access to your Google Account, but sent a malformed request. Please contact the site that you were trying to use when you received this message to inform them of the error. A detailed error message follows:
The site "http://force.com" has not been registered.
After googleing for a while my impression is, that this Toolkit is old and Google switched authentication to Oauth.
- Isn't this something Salesforce also uses / understands or will understand when "Identitiy" is released?
- Is it true that there is no update or alternative to that outdated toolkit?
Attribution to: Robert Sösemann
Possible Suggestion/Solution #1
To answer the first question, SFDC supports OAuth today. I'm an integration noob, and certainly don't know the vaguaries of writing extensions to google apps, but at least in theory, we can support that OAuth request from google today.
For the second, I don't know the history, but (as most community toolkits are), it is opensource on code.google.com. The code timestamps for the most recent files are quite old (pushing two years), which might even predate OAuth going GA. At the very least it was in its infancy in the platform. So there might be enough to go on to build your own.
The source can be found at: http://code.google.com/p/apex-google-data/source/browse
Attribution to: pchittum
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/5091