Export all or only specific columns using XML - Support and Troubleshooting

Export all or only specific columns using XML Description  Export all or only specific columns using XML

Overview When exporting using the default export XML of a list or record, all columns from the table are included. This article explains how to export only specific columns and the sys_id of the record. Importing those XMLs in a target instance when there already is a record with the sys_id in the export file will only update the column(s) included in the export file while leaving the other columns as they are. If there is no record for that sys_id, it will be created. When exporting large amounts of data you may need to review the following:

Export Limits

Breaking up Large Exports

Other articles that may be helpful with debugging are:

Enable export debug logging

Process Open up form view for the intended table https:// .service-now.com/ .do Right-click on the form window and select Configure > Form Layout . In Form View and section , click in the View name field and select New . Create a new form layout adding only the columns you want to export. Click Save . To test the new view, click the menu icon and select View > . Only the columns you specified and want to export are displayed. To obtain the record XML, add the following URL to your instance adjusting the three listed variables: Use this for all records without view: https:// .service-now.com/ .do?XML&useUnloadFormat=true .service-now.com/ .do?XML&sysparm_view= "> Use this for all records without filter: https:// .service-now.com/ .do?XML&useUnloadFormat=true&sysparm_view= .service-now.com/ .do?XML&sysparm_view= "> .service-now.com/ .do?XML&sysparm_view= ">Use this for all records with a filter: https:// .service-now.com/ .do?XML&useUnloadFormat=true&sysparm_view= &sysparm_query= myinstance = Name of your instance TableName = Name of the table you would like to export ViewName = Name of the view you just created

The XML export of these records is displayed.

In browser click S ave page as . Save the file as an XML file. The file is now ready to import into an instance. It should only contain the sys_id of the record and the columns from the list view. Note: The generated file should have a quick spot check done on it to confirm it only contains the intended fields. A typo in the view name, or the view being created on a different table than the one being exported may lead to all rows being exported instead of just the expected ones. If your browser crashes when using the "XML&useUnloadFormat=true" flag even after splitting the data into chunks, try KB1646225 as the workaround.

Example On Instance A, create a new field named Test on the incident table and added data. Create the same field on Instance B. Need to add the populated data from Instance A into Instance B without changing all of the other fields on the incident table. Navigate to the Incident table in List view incident_list.do Select a record. Clicked the menu icon and selected Configure > Form Layout . Created a form named Migrate . Added only the Test field to the form. Saved the form. Navigate to the following link:

https://instanceA.service-now.com/incident.do?XML&useUnloadFormat=true&sysparm_view=Migrate

Saved the file as import.XML. Logged in to Instance B. Right-clicked on List view and selected Import XML . Selected XML file. Imported data. Confirmed the data was now located in Instance B with no changes to other fields.