Issue with Importing 1 Lakh Incident Records from Demo2 to Demo5

[TEJAS]

Hi All,

I have two ServiceNow demo instances – Demo2 and Demo5.

• In Demo2, I have around 1,00,000 records in the Incident table.

• I exported all the incident records successfully.

• But while importing them into Demo5, only 10,000 records are getting imported.

I would like to import all the 1 lakh records, not just 10,000.

Has anyone faced this issue before?

• Is there a limitation while importing/exporting large number of records?

• Do I need to split the data into batches, or is there a configuration that allows importing all records at once?

• What would be the best practice for migrating such large datasets between instances?

Any guidance would be greatly appreciated.

Thanks in advance!

[TEJAS]

@Bhuvan   , It not happening 
I created new property but its not importing 1lakh record 

I have exported a record of incident in one instance which as 10laksh record i am trying 1 lakhs to be import but not happening , anything wrong i have done guide me.

[Bhuvan]

@TEJAS  

Can you share the steps you followed as it should work fine. I have tested in my PDI and it works fine.

Before creating the Property

After creating the property

Go to the table to import data -> Configure -> Import -> Create Excel template. Make sure the template you are trying to import from another PDI is same as exported data from demo2 instance

Once you confirm template is correct, upload the excel template file and upload. Preview imported data and import to the table.

As per community guidelines, you can accept more than one response as accepted solution. If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan

[TEJAS]

@Bhuvan  
I have the exported file in XML format not in excel format 

[Bhuvan]

@TEJAS  

Set below property to desired value and try to import again

com.glide.processors.XMLProcessor.record_count

If above does not work, can you export the data using excel template from source instance and import it in target instance.

As per community guidelines, you can accept more than one answer as accepted solution. If my response helped to answer your query, please mark it helpful & accept the solution.

Thanks,

Bhuvan