You need to sign in to do that
Don't have an account?
Rudolph Scott
Mass upload previous activity data with excel connector or Dataloader using a CSV file
Hi all. I saw AMartins reply to Jennatta question on this and this is ok, but can I ask how to get the data in the form Salesforce requires? i.e
Activity ID - has to be the first column in the Excel worksheet, the value of the field is "NEW".
Subject - populate with an appropriate value
Status - populate with appropriate value (ex. "Completed")
Due Date - populate with appropriate value
Assigned To ID - the name of the Account Manager or the person with a sfdc license who is responsible for the mailout.
Contact/Lead ID - the sfdc id of Contact who received the mailout
At the monment my Spreadsheet data is as follows
Contacts ID Activity1 Name Activity1 Name..etc .
Is there a way using Excel or VBA to change the data I have so it matches whats actually needed? For example each ContactID I have has 20 different Activities so I need something like;
Contacts ID Subject Status, etc
1 Activity 1 Name
2 Activity 2 Name
" "
It would be good to do this I have 5000 records and I dont really want to nmanually maniputlate the spreadsheet for this process! Thanks in advance.
Activity ID - has to be the first column in the Excel worksheet, the value of the field is "NEW".
Subject - populate with an appropriate value
Status - populate with appropriate value (ex. "Completed")
Due Date - populate with appropriate value
Assigned To ID - the name of the Account Manager or the person with a sfdc license who is responsible for the mailout.
Contact/Lead ID - the sfdc id of Contact who received the mailout
At the monment my Spreadsheet data is as follows
Contacts ID Activity1 Name Activity1 Name..etc .
Is there a way using Excel or VBA to change the data I have so it matches whats actually needed? For example each ContactID I have has 20 different Activities so I need something like;
Contacts ID Subject Status, etc
1 Activity 1 Name
2 Activity 2 Name
" "
It would be good to do this I have 5000 records and I dont really want to nmanually maniputlate the spreadsheet for this process! Thanks in advance.
What i am saying is like
Contact Id | Activity
0045nsj2 Your activity 1
0045nsj2 your activity 2
0045nsj2 your activity 3
0045nsj2 your activity 4
0045nsj2 your activity 5
If you format your data this way, it should be simple to upload it into sfdc.
how did you get this data? If this is extracted via data loader, it already comes in a format that you could use it.