How to Download a CSV with more than 1 Lakh Records

[M Lohith Datta]

Hi All,

I have to take a back up of all incidents in the incident table but there are around 2Lakh Incidents in it, every time when i export a CSV i am able to get first 50K records only, is there any way to download all the incidents and their sys_id's in one CSV ? Kindly let me know.

@Ankur Bawiskar I have seen a post where you said you we able to take a back up of 3 lakh records in CSV format , How did you able to achieve it kinldy let me know, I also need sys_id's along with incidents while taking CSV to local machine.

Its open for all anyone can help,

Thanks 

Datta

[Ankur Bawiskar · Accepted solution]

@M Lohith Datta 

why not use mid server and use export set and it would send all the data from that table in csv to mid server location?

OR

divide it in chunks of 1 lakh and do it 3 times.

Also ensure export csv limit is increased

If my response helped please mark it correct and close the thread so that it benefits future readers.

[M Lohith Datta]

Hi Ankur,

Increasing the limit will help me but problem is i am not able to get sys_Id while exporting and we dont have a midserver

what is other approach I can do

Kindly let me know

Thanks

Datta

[Ankur Bawiskar]

@M Lohith Datta 

check this link

Exporting data with Sys ID/GUID (Globally Unique ID)