bulk import/ export of data (including attachments);

jmadhuri
Kilo Explorer

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

11 REPLIES 11

Hi sergiu,


I have one last question,please bear with me.When you say chunks of 4k is it 4000 bytes or is it has some other unit.Also division in to chunks of 4k performed after file transferred to base64 encoding?


Hi Akram,



I am referring indeed to bytes. When an attachment is added to a record, ServiceNow platform splits the attachment in 4k chunks (4000 bytes) and then does a base64 encoding:



Administering Attachments - ServiceNow Wiki



Regards,


Sergiu


Hi Sergiu.


Thanks for Prompt reply.I go through your link for administering Attachments.This gives me another question.Is there a way in Servicenow to extract the Actual file rather than getting base 64 encoded 4k chunks.


You can't get directly the file, unless platform rebuilds it, as it's stored in chunks (so for each chunk you get a row in sys_attachment_doc table).



Regards,


Sergiu


Hi Sergiu,



I observed that a text file of size of 12 bytes is getting divided in to 2 chunks of data in Servicenow.each chunk length 16 and 18 respectively.If servicenow is dividing the file in to 4k chunks ideally there should be only one chunk.And also observed that each chunk holding max length of 3736.Can you please explain the process of chunking in brief or point me to any useful resources.you can find sample file image which I am referring to.file_image.png