Can we overwrite the system fields (created by, created date, updated by, etc) with the input value from transform map

[udaykulal]

I am bulk importing historical Incidents. As per the client requires the created date should be back dated to the original date provided in the excel. However even though I mapped the fields properly, the created by and created date is taken as the user who is doing the action. I was able to map system fields and update via tranform map in User table. Only for incident table it doesn't seems to work? Has anybody faced this issue before ?

Regards

Uday

[acirovic1]

I'm assuming he'll be creating SLA Definitions in the future to report on the service assurance. Once he starts reporting on the task_sla table, the imported created on dates will be useless. He'll have to have one report to report on new incidents and one the imported incident.

Better way is to try to persuade the customer not to import the old incidents. If this is not possible, depending on the volume of incidents being imported, more useful approach would be to generate the task_sla entries programatically. That way it will be possible to have seamless reports across the data (imported and newly generated).

[udaykulal]

I need to do it. So how can I do it.

[rahulpandey]

I think you should the date format, check below discussion

How do you import date fields from excel?

[udaykulal]

I am passing the date field in proper format. I am also updating 'opend_at' field and that is populating properly

[acirovic1]

Create onAfter transformation script to update the sys_created_on and sys_created_by fields.