Write a Fix script to update 1 year old records and map the fields from table1 to table2.

[Priyanka_77]

Hi,
 I need to write a fix script which will do:
1. Map the field from xml.

2. there is one responsibleID field which needs to fetched from xml and map to another table's manager field which is a refernce field which refers to sys_user table...how can i do this?

[Mark Manders]

Please elaborate? I am not sure what this question is doing in the VA forum, so assuming it is just a general ServiceNow question: what are you trying to do? 

No fix script will update an xml. So your subject and question don't align. What tables are you talking about? What fields are you mapping? What do you mean with 'map from xml'? An xml isn't a record, so how do you expect any field found from an xml? 

I think we are missing a lot of context here.

[maheshkhatal]

@Priyanka_77 What is the exact requirement? Are you saying you have an xml file and need to parse certain values which are sys ids(references to some manager field) and need to populate the target table?

Let me know what exactly you are looking for.

Thanks,

Mahesh.