kim_purcell
Kilo Explorer
Options
- Subscribe to RSS Feed
- Mark as New
- Mark as Read
- Bookmark
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
11-06-2014
02:15 PM
If you are trying to export a list of incidents with their attachments, you'll run into a slight issue — the current platform is not set up to do your bulk-export-attachment trick unless you are exporting to XML. This is because your attachments are in a different table from your incident list. If you need export to another file type, you can do this successfully by exporting the attachments one by one.
To find the correct attachments, go to the sys_attachment table:
- In the navigation filter, enter sys_attachment.list
- Search by Table name > Incident.
- Use a filter to find the attachments you need. For example: Created > on > Today. This will give you a list of attachments for incidents in a specific date range:
Link the attachments to their incidents by renaming the attachment's file name to match the sys_id of the incident:
- Open the incident.
- Right-click the header, and select Copy sys_id.
- Copy the sys_id number.
- Click Manage Attachments.
- Under Current file attachment, rename the attachments with the sys_id number. For multiple attachments, add -1, -2 to the end of the sys_id:
- Repeat the steps above for the other incidents.
- Go back to your attachment table. Your newly renamed files are ready for export:
- Download the attachments, and then re-export your list of incidents. You should now be able to view your incidents with their corresponding attachments.
For more information, see: When I export a list of incidents, attachments are not included?
- 14,771 Views
9 Comments
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.