How to modify/update a large XML file and then import?

[Jay_Shin]

Hi Experts,

I have an XML file of KB articles size around 300-400 MB.
I want to modify few field values from the XML file(eg. created by to XYZ, Created on to current date/time, view count to 0, etc).
Due to size of the file it's impossible to modify the field values manually and import.
I want to know is there any way I can import the XML by modifying the fields in it.  

Thanks in advance.

[Jay_Shin]

Hi Sachin,

Thanks for the quick response, but the XML is already provided by customer.
Need to work on the provided XML only 😞

Thanks.

[sachin_namjoshi]

You should break up such a huge file in small chunk before export to avoid performance issues.

https://docs.servicenow.com/bundle/orlando-platform-administration/page/administer/exporting-data/ta...

Also, instead of XML import, you can consider data source based import where you can configure transform map to manage data before import.

Regards,

Sachin 

[Jay_Shin]

Hi,

The issue was might be because of LARGE size of the XML file. I took 5-10 KB Article XMLs and imported. 

Thanks.

[sachin_namjoshi]

Great, can you mark my answer as correct so that it's helpful for others in future?

Regards,

Sachin