MobileRead Forums
Register Guidelines E-Books Today's Posts Search

Go Back   MobileRead Forums > E-Book Software > Calibre
Reload this Page Is there a lazy way to split a "create catalog" csv

Notices

Reply
 
Thread Tools Search this Thread
Old 11-24-2016, 06:09 AM   #1
LadyKate
Fanatic
LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.
 
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?
LadyKate is offline   Reply With Quote
Old 11-24-2016, 06:57 AM   #2
BetterRed
null operator (he/him)
BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.BetterRed ought to be getting tired of karma fortunes by now.
 
Posts: 20,995
Karma: 27620706
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
BetterRed is online now   Reply With Quote
Advert
Old 11-25-2016, 02:55 PM   #3
LadyKate
Fanatic
LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.
 
Posts: 515
Karma: 1470724
Join Date: Jul 2013
Location: Quebec CA
Device: android 4 (samsung tablet and asus tablet)
Quote:
Originally Posted by BetterRed View Post
@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
Good idea!

Thank you.
LadyKate is offline   Reply With Quote
Old 11-25-2016, 03:03 PM   #4
LadyKate
Fanatic
LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.LadyKate ought to be getting tired of karma fortunes by now.
 
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!
LadyKate is offline   Reply With Quote
Reply

« Previous Thread | Next Thread »

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sigil's Infamous "colon" Error on File Split slowsmile Sigil 24 10-27-2016 10:45 AM
What is the Xpath for "Split html at the word 'chapter" lealla Editor 5 06-26-2015 04:32 AM
Split long words using the "¬" character (small screens) DSpider Workshop 5 03-16-2012 08:09 AM
How to use "catalog CSV/XML" plugin? katsu Library Management 4 10-14-2011 12:07 PM
George R. R. Martin's "A Dance With Dragons" to be split into separate books. Exer General Discussions 4 04-02-2011 09:50 AM


All times are GMT -4. The time now is 07:11 AM.

Contact Us - FAQ - Guidelines - Privacy - Top

MobileRead.com is a privately owned, operated and funded community.