Mass import from Salesforce to Drupal
aaronbauman - May 18, 2009 - 14:59
| Project: | Salesforce |
| Version: | 6.x-2.x-dev |
| Component: | Code |
| Category: | feature request |
| Priority: | normal |
| Assigned: | aaronbauman |
| Status: | postponed |
Description
I have brewed a lightweight module that uses your site's existing salesforce_api fieldset mappings, drupal batch api, and a simple node_save to run mass imports of your SalesForce data.
Features:
- Updates existing data based on SalesForce Id, if it exists, rather than duplicating.
- Accepts additional "Where" clause for imports, in case you want to import only a subset of SalesForce records.
Is anyone interested in this? If so, I'll clean it up and upload it.
#1
Hi
I would like to evaluate your module. I will be working on salesforce Drupal integrationin an upcoming project. Will be good to have this handy.
Many thanks
Jay
#2
I think this would also be useful for a project we are working on and I'd be glad to help test or whatever is needed.
#3
I think this is a great idea... our current thinking is that salesforce would be the authoritative/master source for data, it makes sense to be able to do this. Having this tool would be great for people who have a salesforce org and want to add drupal and all its benefits as a community/customer front end.
#4
VERY interested !
Would be awesome to share this !
#5
The attached is module will add a "Import" local task to your menu in Admin > Settings > Salesforce.
It works by querying Salesforce and running a Drupal batch job to import your records one by one using an existing salesforce.module field map. Make sure you set up the field mapping for the content you want to import before you try to import it.
You should be able to follow the on-screen prompts after you install the module and figure out what is what, or go to http://example.com/admin/settings/salesforce/import to get started.
<shameless plug>Also, please check out this other contrib for your reviewing pleasure: #500052: Allow salesforce to initiate imports</shameless plug>
#6
I can't seam to have this working.
I have two content type. One contact, one Lead, they both have a long list of fields, matching Salesforce fields. The fields are mapped on the fieldmap setting page of Salesforce.
I installed the Import module you provided, but when I go to the IMPORT tab, it says that I have no fieldmap defined yet ("You have not yet defined any fieldmaps.")
I find this confusing as I have two fieldmaps listed under the "Fieldmaps" tab.
Am I doing something wrong here ?
#7
This is a candidate for inclusion in salesforce API core once it is RTBC.
#8
There are a lot of patches floating around, and I'm working on compiling a list of patch dependencies and an update for this feature. It would be nice to get some of the more basic, critical patches RTBC and rolled into HEAD...
Anyway, the most recent error reported in #6 relates to the overhaul of the fieldmaps system - moved from the variables table to drupal cache / salesforce_field_maps table...
#9
postponing this awaiting #476978: Implement "Object Setup" Feature
#10
A patch to update the import to use the overhauled fieldmap system