How can I do a Bulk upload of attachments?

[vkambham]

I need to migrate some change request data from another system. I have the change requests and their related attachment data ( CR, attachment name) in csv extracts. The attachments themselves are in a folder. I was planning to use import set to import the csv data but then I don't know how to handle the attachment files. What is the the best way to import these attachments and relate them to the change requests?

[Jamie_douglas]

You could try to export to xml then import - im pretty sure this carries the attachments over.

Let me know if it helps.. Maybe just try with one change first then if it works export all the changes you require and import.

Not that change tasks wont be included so you may have to export those separately.

Let me know if this works?

[John VanBruggen]

Correct, the change record and attachments are brought over.

However, other related records are not.   This would include Tasks, Approvals, & Workflows.

That said, I am not sure that the original post from this thread was taking records from one instance to another.
I interpreted that they were bringing in from another non-ServiceNow system and importing to SNOW.

[Anurag Tripathi]

Hi Venkatesh,

I doubt that direct xml export import will work.

There are 2 tables involved in handling attachments

sys_attachment - just holds the reference of the ticket and the attachment.

sys_attachment_doc - actual table that holds the data(it breaks large files into smaller chunks )

When you store an attachment to any table, a record is created in the sys_attachment table that contains attachment metadata, and the file data is stored in the sys_attachment_doc table, in 4k chunks. For example, if you attach a 12k file called My_attachment.pdf, then you would have a sys_attachment entry with 3 related sys_attachment_doc entries

Hope this gives you a better idea as to how attachments are handled in ServiceNow.

[John VanBruggen]

I did some testing around XML exports of records from ServiceNow and have found that it actually does capture the attachments to the records.   I didn't think it would either, but was relieved when I found that it did.