bulk import/ export of data (including attachments);
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-22-2016 01:44 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-22-2016 03:54 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-24-2016 11:16 PM
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?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-24-2016 11:41 PM
Hi Akram,
All attachments are stored in "data" field in sys_attachment_doc table in chunks of 4k, and base64 encoded.
Regards,
Sergiu
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎01-25-2016 02:00 AM
Thanks Sergiu