Salesforce : Import Data with Audit Fields
September 11, 2013 /
Posted in Salesforce Corner
Salesforce by default does not allow the importing of audit fields into SF. However, there is situation where the customer say, requires the created date to be imported for accurate reporting. For e.g.:
Customer ABC needs lead records to be migrated into SF from another application. The SF lead created date needs to take the exact date from when the Lead was first created in the application it was migrated from. This is because the historical lead creation needs to be accurate in SF.
Solution:
Open a case with SFDC Support and request it
List of audit fields:
- CreatedById
- CreatedDate
- LastModifiedById
- LastModifiedDate (direct update from the user)
- SystemModstamp (similar to LastModifiedDate but it marks the last updated time by other processes – workflow, trigger etc)
Note:
- You can set all the audit fields except SystemModstamp
- Not all standard objects’ audit field can be set
Supported objects:
- Some standard objects (refer to the table below)
- No custom objects
Supported Standard Object |
---|
Account |
Case |
Contact |
Event |
Lead |
Opportunity |
Pricebook |
Task |
Campaign Member |
Case Comment |
Content |
Idea |
IdeaComment |
FeedComment |
FeedItem |
Vote |