Skip contact that exists

ATTENTION: This forum is no longer active. Please navigate to our new support site at https://support.starfishetl.com/
Viewing 1 posts (of 1 total)
Anosh Wadia
User - Author
Post count: 19
#1

I'm importing data from Goldmine to Salesforce.

My Salesforce database already has contacts in it. I'm trying to figure out a way to only import contacts from Goldmine where the Salesforce contact does not exist. The field i'm using to match the data is the "Social Security Number" field.
Is there a way I can setup a Starfish map so that it ONLY imports Contacts from Goldmine where the Social Security Number does not already exist in Salesforce?

Comments (1)

Aron Hoekstra's picture Aron Hoekstra
Administrator
Post count: 2
#2

Anosh,

Ah, I see your dilemma. Whereas typically the Match functionality will be expecting the data to already exist, you want to insert ONLY when it DOES NOT exist. To achieve this, I'd use the SmartLookup function per each row. You would create a Exec Before VBScript Procedure like below....

Sub VBScriptProcedure
dim id
id = SmartLookup("Contact", "Id", "SSN__c = '@@ORG:SSN@@'")
if id <> "" then
Starfish.GotoNextRow
end if
End Sub

You'll have to change the field names to match yours, but this will perform a search for the current row's SSN and return the Id for the record. If the search returns a blank, this means the SSN does not exist in Contacts and the job will continue normally and perform the Insert. If it returns a non-blank, this means it did find a record. Since we don't want to process this row, we issue a GotoNextRow command which will skip to the next row.

Let me know if this helps.

Log in to post comments
Viewing 1 posts (of 1 total)

Forum Login

Login or sign up for our forums to connect to the user community.

Reply

You must log in to post.

Not a Member? Register.