You need to sign in to do that
Don't have an account?
Salesforce Blitz
need to insert event and event relation when inserted through dataloader
Created a staging object similar to Event.
Have FROM and TO emailID's of salesforce users loaded from outlook into SF Staging Object fields through DataLoader CLI.
Ex:
Staging Object name: Event Staging
Fields:From,To,Date,Duration,Subject,Location...
FROM(field type:email) field will have single email id,
TO(field type:Text) field will have multiple email ids.
Once a record is created in Event staging, FROM field(Salesforce users email ex:sridher.sharma@apple.com) need to fetch UserID(15 digit SF ID of user) and needs to create a Single Event record with details(Date,Duration,Subject,Location...).
As soon as the Event is created,the Event ID will be generated.
The TO field(Salesforce Users email) needs to fetch userID and create multiple Event relation records mapped to above created Event (based on number of emailID's in To).
Could someone help me in the way as how to approach the coding part.
Thanks & regards
Have FROM and TO emailID's of salesforce users loaded from outlook into SF Staging Object fields through DataLoader CLI.
Ex:
Staging Object name: Event Staging
Fields:From,To,Date,Duration,Subject,Location...
FROM(field type:email) field will have single email id,
TO(field type:Text) field will have multiple email ids.
Once a record is created in Event staging, FROM field(Salesforce users email ex:sridher.sharma@apple.com) need to fetch UserID(15 digit SF ID of user) and needs to create a Single Event record with details(Date,Duration,Subject,Location...).
As soon as the Event is created,the Event ID will be generated.
The TO field(Salesforce Users email) needs to fetch userID and create multiple Event relation records mapped to above created Event (based on number of emailID's in To).
Could someone help me in the way as how to approach the coding part.
Thanks & regards