Preserve Created On date when migrating data using xmltoolbox data transporter

(0) Share

Report

Posted on by MR-21071937-0

Hello,

I want to migrate data from one dynamics 365 environment to another.

I've managed to migrate some sample data fine. However, I would like to preserve the Created On date from the source environment to the target environment.

I can see a field called overridecreatedon but it's greyed out and not valid for update.

Thanks in advance!

Categories:

Dynamics 365 general

I have the same question (0)

All responses (3)

Answers (1)

Sort by

Suggested answer

Websrider 2 on at

Like
a
(0)

Report
Copy link

Link copied!

This is expected behavior in D365. The Created On field is a system-managed field and can not be directly updated after a record is created.

The Override Created On field can only be populated during RECORD CREATION, not during an UPDATE.

Create Scenario: Map Source createdon field to Target overriddencreatedon and ensure you are creating the record not updating.

Update Scenario: If you have record already there in target system, then you can't not update createdon and overriddencreatedon field. in this case, create a custom field and map source created on to the custom field i.e. originalcreatedon for the reporting purpose. for all the existing records get the created on data from this field and newly created records will keep this field blank.

Hope, this will help you.

Was this reply helpful? Yes No
MR-21071937-0 4 on at

Like
a
(0)

Report
Copy link

Link copied!

Thanks for the response - makes sense.

How do I map Source createdon field to Target overriddencreatedon? The Data Transporter tool doesn't display the createdon field and I can't see how to map one field to another anywhere.

Kind regards,

MR

Was this reply helpful? Yes No
Verified answer

Assisted by AI

Riazux 19 on at

Like
a
(0)

Report
Copy link

Link copied!

Created On is a system-managed field in Dynamics 365/Dataverse and cannot be updated after the record is created.

To preserve the original Created On date during migration, the source createdon value needs to be mapped to the target overriddencreatedon field during record creation. Dataverse will then populate the actual createdon value from overriddencreatedon.

If you are using XrmToolBox Data Transporter and it does not expose createdon for mapping, then Data Transporter may not support this scenario directly. You would need to use another migration approach/tool that allows mapping system fields during create operations, such as Configuration Migration Tool, KingswaySoft, SSIS, or Dataverse Web API.

Was this reply helpful? Yes No