QUESTION:
I tried to link some Person Accounts to Campaigns in MassEffect, but received the following error:
- 2011-09-26T04:04:00-06:00,,"",,Insert,,,,," Message: Contact ID: id value of incorrect type: 001C000000sfk89IAA Status code: 53"
What am I doing wrong?
ANSWER:
Person Accounts are linked to Campaigns via the CampaignMember table. This table requires the Contact ID and WILL NOT ACCEPT the Person Account ID instead.
An input file containing the proxy Contact ID for the Person Account and Campaign ID will be needed to perform the insert using MassEffect.
If you do not already have this data, MassEffect can be used to export the appropriate proxy Contact id's that need to be associated with the Campaign. When exporting from the Contact table, the related Account fields can be accessed by clicking the + just below the Account ID field. Can use the Account fields to identify the Person Accounts to be linked, but since the export is being done from the Contact table the exported file will contain the proxy Contact ID in column A.
NOTE: If you already have a list of the Person Account ID's to be added, you can use DemandTools Find/Report ID's module (match to the Contact table) to get the proxy Contact ID's. Simply match the Person Account ID on the input file to the "Account ID" on the Contact table and return the proxy Contact ID. If the Person Account ID's are only 15 digits, be sure to select the "Salesforce.com ID Match" as the mapping type.
The Campaign ID can be obtained from the Salesforce URL by accessing the specific Campaign or via a MassEffect export from the Campaign table also.
- Create an input file that contains proxy Contact ID's of the records you want to link to the Campaign, and the Campaign ID.
- Using MassEffect select "Insert" as the operation on the right, and map the Contact ID and Campaign ID from the input file to the respective fields in the CampaignMember table. MAKE SURE INSERT IS SELECTED AS THE OPERATION.
- Optionally map a Status from the input file, or right click on that field and select "Add Constant" if all the records will have the same status.
