Hello,
through a System Import Set, I want to upload the sys_journal_field records for work notes on an Asset record (alm_hardware). Target: sys_journal_field.
Within the Transform Map, I set up a Transform Script with the When condition OnBefore. It just contains:
target.autoSysFields(false);
Further, I added two Field Maps targeting sys_created_by with script:
answer = (function transformEntry(source) {
mycreatedBy = source.u_created_by;
var createdBy = '';
var get_user=new GlideRecord('sys_user');
get_user.addQuery('u_te_id',mycreatedBy);
get_user.setLimit(1);
get_user.query();
while(get_user.next()){
createdBy = get_user.sys_id;
}
return createdBy; // return the value to be put into the target field
})(source);
and sys_created_on with script:
answer = (function transformEntry(source) {
timestamp = source.u_datum;
// Add your code here
return timestamp; // return the value to be put into the target field
})(source);
I just use the script there as I debugged the script for the date format.
My sys_journal_field records are looking as beautiful as they can:
However, within the alm_hardware records, they show my account and the time the record was created and not the one as I loaded it.
Any idea why not the person and the date are showing up as it is showing within the sys_journal_field records?
Thanks in advance
Jan
