May i know the different options available in servicenow while import/export large data??

Manikantahere
Tera Contributor

if any one can answer how we do import/export with out effecting the system performance what are the ways available/ how to break the data into chunks etc .

4 REPLIES 4

Ravi Chandra_K
Kilo Patron
Kilo Patron

Hello @Manikantahere 

There will be export limits on rows/size in ServiceNow.

for exporting huge data

refer the below article 

https://davidmac.pro/posts/2021-07-02-sn-bulk-export/

 

Please mark the answer as helpful and correct if helped. 

Kind Regards,

Ravi Chandra  

Hello @Manikantahere 

Please refer the below thread on import:

https://www.servicenow.com/community/devops-forum/what-is-the-maximum-size-limit-of-excel-file-that-....

 

Please mark the answer as helpful and correct if helped. 

Kind Regards,

Ravi Chandra  

Sandeep Rajput
Tera Patron
Tera Patron

@Manikantahere There are multiple ways using which huge chunks of data can be imported. Some of these ways are.

1. API Calls (Sync data with an external system using Batch API calls)

2. CSV/Excel Bulk import can be done via CSV or excel file

3. Data can also be imported using XML 

 

can we import data as chunks when I am trying to import from excel if yes may I know how ?

does importing through CSV or XML don't have any restrictions? can I create one 1 lakh records CSV or XML?

btw  what about export same were the ways?