- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-11-2023 11:15 PM
Hi All,
I am trying to export data from cmdb_ci table, CI records that we use. The total records to export as CSV is 788000,
the CSV max limit is 300000. Can anyone please help me in exporting the records, how to separate them and export as batches? How to sort and export? I have already sort ascending by name of the CI and exported first 300000 records, please suggest me some tips.
Thanks!
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2023 06:07 AM
I used the method of sorting by sys_id, exporting a batch and then using the last sys_id from first batch to create a new batch and export it again.
The following link helped.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2023 12:12 AM
Hi @Kevin Paul ,
If that the case you can change this system property that has the count of maximum number of rows.
Navigate to sys_properties.list
search for "glide.platform_ml.api.csv_max_line".
open the record and change the value from 30000 to 788000.
and save the record.
Regards,
Lithesh
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2023 01:20 AM
@Lithesh ,
Is that advisable? 300000 is the max limit I guess going above that will cause any issue?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2023 01:59 AM
It would take more time to export rather there won't be any problem.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
05-12-2023 02:01 AM
@Kevin Paul ,
Note: Increasing the export limit may impact the performance of your instance, so it is important to carefully consider the appropriate limit based on your needs.
