Export servicenow data with attachments.

Vedasri1 · ‎03-20-2018

Hi,

I am trying to exporting a table with attachment, I created "database view" with sys_attachment, sys_attachment_doc and incident table. But after exporting the table I am getting name of a attached file instead of the attached file. Can anyone explain how to export the a data (records) from servicenow with attachment.

Thanks & Regards,

Vedasri.

rammohanraomadd · ‎03-22-2018

Hi,

Apart from the integration will not be achievable unless it is a service now instance. Through integration as well you need to check if attachments are getting inserted or not.

Regards,

Ram M

View solution in original post

rammohanraomadd · ‎03-20-2018

Hi,

You can export the data separately. For suppose if you are trying to export the data related to incident and related attachments. Please find below

1. Export all the incident records in an xml

2. Export the attachment data related to incident via xml

Regards,

Ram M

Vedasri1 · ‎03-20-2018

Hi Rammohanrao,

I exported incident and attachment tables separately but I got base64 encoded chunck data of attached table, how can I convert base64 encoded data to original file. I tried with all possibilities, but i have not get. Do you have any idea. Is their anyway to export with attachment.

Regards,

Vedasri.

rammohanraomadd · ‎03-20-2018

Hi,

Do you want to store the information in other instance?

What exactly the requirement was?

Regards,

Ram M

Vedasri1 · ‎03-20-2018

Hi,

Yes Rammohan, I have to export all the data from servicenow with attachments. And import it (data) into other instance.