You need to sign in to do that
Don't have an account?

data migration in many to many relationship
Hello Everyone,
I have two Custom Objects, "Contacts" and "Events". I have multiple contacts associated with multiple Events. So I have created a new "Junction Object - ContactEvent". Now I have created a Master-Details relationship between "ContactEvent & Contacts" and other Master-Detail relationship between "ContactEvent & Events". There are no issues till now.
But I want to migrate data into the salesforce that has Many to Many relationships between Contact and Event, Can you please guide me how to do it? I studied about using Data Loader but we have to import the data and then export it to get Salesforce ID and again match it with the required field and then import it back again, this is a very lengthy process specially when we have millions of records. Is there any other way we can do it using External ID? like not exporting and we can use upsert, insert or update only the new records without exporting
Please let me know. Thank you so much.
I have two Custom Objects, "Contacts" and "Events". I have multiple contacts associated with multiple Events. So I have created a new "Junction Object - ContactEvent". Now I have created a Master-Details relationship between "ContactEvent & Contacts" and other Master-Detail relationship between "ContactEvent & Events". There are no issues till now.
But I want to migrate data into the salesforce that has Many to Many relationships between Contact and Event, Can you please guide me how to do it? I studied about using Data Loader but we have to import the data and then export it to get Salesforce ID and again match it with the required field and then import it back again, this is a very lengthy process specially when we have millions of records. Is there any other way we can do it using External ID? like not exporting and we can use upsert, insert or update only the new records without exporting
Please let me know. Thank you so much.