bulk import/ export of data (including attachments);

[jmadhuri]

Hi,

Could you please let me know if there is a tool for doing bulk import/ export of data (including attachments);?

We have a scenario where we need to bulk export all the records one Service Now instance to another along with attachments (if any). Do we have an option to do this?

Thanks,

Jaya

[sergiu_panaite]

When you export records from a list view as XML format, the attachment will be included as well.

For example, go to your incidents list, use a filter for number=<an incident you know that has an attachment> to display one only incident then right click on the columns name -> Export -> XML. This will give you an XML file with that incident and the associated attachment.

You can apply same procedure for an entire table. Be aware that there are some limitations with the number of records you can export in one go, but you can read more here:

Exporting Data - ServiceNow Wiki

Exporting and Importing XML Files - ServiceNow Wiki

Regards,

Sergiu

[akram6]

Hi Sergiu,

When I export the incident records with attachments as u mentioned in your previous comment.I can see the attachment content is stored in <data> XML tag.Can you please tell the format of this attachment is it base 64 encoded or some other format?

[sergiu_panaite]

Hi Akram,

All attachments are stored in "data" field in sys_attachment_doc table in chunks of 4k, and base64 encoded.

Regards,

Sergiu

[akram6]

Thanks Sergiu