Export servicenow data with attachments.

[Vedasri1]

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.

[Vedasri1]

Hi,

Do you get Exact attached file.? Which format you have exported. ?

 Regards,

Vedasri.

[rammohanraomadd]

Hi,

Yes i got the exact file and the format is text file.

Regards,

Ram M

[Vedasri1]

Hi,

Can you please explain with example how you did exported with screenshots so that I can understand where did I am making mistake. Are exporting with xml file or any other. If you are exporting with xml how you get exact attached file, But I am not getting the file instead I am getting Base64 encoded format of attached data. 

Thanks & Regards,

Vedasri.

[Vedasri1]

Hi Ram,

Could you mine please explain with small example how you exported with attachments. Thanks in advance.

Regards,

Vedasri.

[rammohanraomadd]

Hi Vedasri,

I just navigated to incident list (Open Module) and selected a record and right click on the header then clicked on Export XML option.

Then navigated to target instance and imported the XML file from list layout of incident module (no need to be incident module only). List layout is important. Click on header Import XML.

Please let me know for any queries.

Regards,

Ram M