DataMap Description: Migrate your customer information from GoldMine CRM to your SalesForce.com account with a push of a button! All you need to do is just enter your details, and then run execution. The process of creating this DataMap is described at Apatar's wiki page here.
I have download the Apatar program and this datamap. I have tried to load this map into Apatar and there is nothing that shows up in the grid. Shouldn't I see the connectors and tables?
Hi Debora,
You're absolutely right. You should be seeing the connectors and tables.
Thanks from dropping a note on this issue. Looking at it now. The fixed datamap should be available by afternoon EST on Monday.
In the meantime please try the one at http://apatar.com/GoldMine_to_SFDC_data_integration.html
It does the same thing. The zip file will also contain the version of Apatar that works with Salesforce PE
Deborah Atkinson 2010-04-23 09:46:15
Thank you, that looks better. I had to edit the .bat file to GM_SF but now it looks good.
I am so disappointed with this. I was hoping to be able to recommend this to my client who is moving to SFDC. First, I get an error that the Billing Street is required, so I needed to add those fields to the Transform for the Account. Then, it does create a new account but does not create a contact linked to that account. I have looked over the guides and the maps and it seems to be set up correctly but when I run it, the joinnode is created and then 0 records processed. If the contacts datamap worked I was going to buy the history datamap. Can someone help with getting the primary contacts into SF and linked to the Account?
Deborah,
Please try downloading the file again. We fixed the Join node and could write data successfully. I will also send you the link to get a newer version of Apatar that has one issue with Salesforce connector fixed.
As for the billing street error, I double checked Salesforce API docs and by default this field is not required. I guess this is a custom setting of the account you're working with. If there are required fields other than Last Name for contacts, make sure to add them to the mapping. But even if you do have them mapped, if a record in GoldMine has not value in a related field, Salesforce will through an error (that will be shown by Apatar).
Also, I guess you noticed but only the company name is transferred to Accounts by default. But you can easily add more fields.
As you migrate contacts, you might want to first check if the emails in GoldMine have a valid format. Salesforce is very picky and won't let you write anything but a valid email (in terms of format)
And if you plan to move other type of data from GoldMine to Salesforce using Apatar, I'd recommend creating a custom field in Contacts (and Leads if you're writing to them too) and write GoldMine's ACCOUNTNO there. You will be able to use it later to link records.
Steve 2010-06-24 08:56:04
I get the following error. What does it mean? Network error IOException: Connection refused: connect
Steve 2010-06-24 09:03:51
Sorry, I wasn't clear before. I'm trying to begin migrating Goldmine into Salesforce. I'm entering the Goldmine authentification details and I'm getting this error:
Network error IOException: Connection refused: connect
Can you tell me what it means and what I have to do to fix it?
I tried sample GM to Salesforce migration. I am able to run the mashup but my salesforce sandbox is not reflecting the records that I inserted.
I checked in error_output to see the log. No error got. Got this message, "Start Reading from CONTACT1"
Any idea why the data is not inserting into salesforce.
I tried with Dev/Staging sandbox. with Insert/Synchronization options.