function readOnly(count){ }
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
+ Start a Discussion
ctzompanakisctzompanakis 

Looking to do an upsert & establish a relationship

I am looking to merge data from two other CRMs into our salesforce account. What I used to when beforming this action was upload accounts, then redownload the new accounts with their new salesforce id's and then create Vlookups in excel to upload the contacts to and establish the proper relationship. Obviously this is a pretty long process especially to ensure that the names are correct for the Vlookup to work. 

 

Now I believe that there might be a quicker way to do this but I can never seem to map to a field that pulls the data from the account to the contact level. I have tried formula fields, relationship fields and nothing seems to do the trick. 

 

Can anyone help?

 

Thanks!