You also can take a look at the SFDX plugin called SFDX-Data-Move-Utility. I took part in development of this plugin, which is hosted in the forcedotcom GitHub account under the BSD 3-Clause license type. This tool can be very handy for loading the data from another org or from .csv files.
The main advantages of this tool:
It can transfer or load multiple ...
You can't specify an Id that does not exist in that org, thus the import fails. This is because Id is a read-only, system generated field. If the import did work, this would imply that the Id value would no longer be unique in different orgs. The best you can do is to change the Id column to a different name (a custom External Id field), which you could do ...
Updating my anwser per Adam’s comment below:
SentEvent.SendID = Send.ID
If I am not mistaken, it should be SentEvent.SendID = Send.ObjectID.
I like to use the Describe method to get information about the metadata associated with an object, as the documentation isn’t always accurate. You can easily run it on a CloudPage using WSProxy to get all the info ...
For that, you Can raise a case with Salesforce Support, to Activate the "EDIT AUDIT FIELDS" feature
this will allow you to edit the Audit fields (LastModifiedDate, LastmodifiedbyId CreatedDate and Createdby ) when you insert or update.
then you can update/retain the old values as part of your update/upsert instead of system generated Date and ID's
NO, the workflows, process builders and triggers do NOT need to be manually activated. What the documentation is telling you (implicitly) is that the DML required to mask the data (by SFDC) will not cause any side effects via the execution of automation that normally occurs upon DML:
Lightning Flow (before update, after update)