Work notes are not populated on the Form while transforming data

[Ashwini Jadhao]

Hi,

I am importing data from london to madrid by transform map.All the data is imported properly except Work notes.

Issue is on the tables list view I can able to see work notes data but when I open the record then the work notes field is empty.

[Ashwini Jadhao]

directly by field mapping

[Harsh Vardhan · Accepted solution]

try it by onBefore transform script. 

eg:

var gr= new GlideRecord('your target table');

gr.addQuery('number',source.<field name>); // here you will add filter so you can identify the record

gr.query();

if(gr.next()){

gr.work_notes= source.<work note field >;

gr.update();

}

[Talya]

Hi @Harsh Vardhan and @Ashwini Jadhao ,

I am importing the project records to pm_project table from the project template. This is first time insert to pm_project table and there are no Project number created yet. Once I import the data via import set the records will get the project number value.

All the fields are imported successfully, except the work notes field. That's how I ended at this post.

I see the data related to my records in sys_journal_field table.

I am not using any script , I have done direct field mapping only.

My source table is u_latest_project_import and target table is pm_project.

In the script you have provided, 

gr.addQuery('number',source.<field name>); // here you will add filter so you can identify the record

what field name should I provide?

I am new to ServiceNow. Pleas help me , how to populate data in work notes field of Project form.

Thanks,

Talya