Salesforce : Import Data with Audit Fields

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

Get in touch today to see how WDCi can help your business.