![]() |
#1 |
Fanatic
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 515
Karma: 1470724
Join Date: Jul 2013
Location: Quebec CA
Device: android 4 (samsung tablet and asus tablet)
|
Is there a lazy way to split a "create catalog" csv
I have way more lines of books than the average spreadsheet will accept. Is there an easy way to indicate a maximum number of lines to a "create catalog" request? Or should I be selecting books in chunks?
Is there a way to automate selecting the entire library in sections that would fit into a spreadsheet? |
![]() |
![]() |
![]() |
#2 |
null operator (he/him)
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 20,772
Karma: 27405072
Join Date: Mar 2012
Location: Sydney Australia
Device: none
|
@LadyKate - do you really need a full function spreadsheet, if not try CSVFileView - CSV/Tab-delimited file viewer and converter, it has an option called String Interning that can reduce memory usage on large tables.
Otherwise chunk your library into blocks of say 30,000 books using the Reading list PI, and create csv files for each Reading list. Then discard the reading lists. BR |
![]() |
![]() |
Advert | |
|
![]() |
#3 | |
Fanatic
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 515
Karma: 1470724
Join Date: Jul 2013
Location: Quebec CA
Device: android 4 (samsung tablet and asus tablet)
|
Quote:
Thank you. |
|
![]() |
![]() |
![]() |
#4 |
Fanatic
![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() ![]() Posts: 515
Karma: 1470724
Join Date: Jul 2013
Location: Quebec CA
Device: android 4 (samsung tablet and asus tablet)
|
Just found this csv file splitter! Putting the link to the program here in case someone else has the same problem. https://sourceforge.net/projects/splitcsv/
and the best thing is it is freeware too! |
![]() |
![]() |
![]() |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Sigil's Infamous "colon" Error on File Split | slowsmile | Sigil | 24 | 10-27-2016 09:45 AM |
What is the Xpath for "Split html at the word 'chapter" | lealla | Editor | 5 | 06-26-2015 03:32 AM |
Split long words using the "¬" character (small screens) | DSpider | Workshop | 5 | 03-16-2012 07:09 AM |
How to use "catalog CSV/XML" plugin? | katsu | Library Management | 4 | 10-14-2011 11:07 AM |
George R. R. Martin's "A Dance With Dragons" to be split into separate books. | Exer | General Discussions | 4 | 04-02-2011 08:50 AM |