.sqlite in calibre

quarkpott · 07-10-2017, 10:26 AM

Hello,

is there any possibility for me to import an .sqlite database to calibre. I have a db with all books, but i like to manage them now with calibre but I dont want to make it new.

Sorry for my bad english

jhowell · 07-10-2017, 10:32 AM

The Import List plugin can do it if you can convert your database into a format it understands, such as CSV.

quarkpott · 07-10-2017, 10:35 AM

Thanks.

How can I convert an sqlite to CSV?

davidfor · 07-10-2017, 10:49 AM

Most of the SQLite database management tools I have used have an option to save the results of a query as a CSV file. Or an export option for the contents of a table.

quarkpott · 07-10-2017, 10:51 AM

I'm looking for this. Thanks

jhowell · 07-10-2017, 10:53 AM

There are instructions on the web. For example, http://www.sqlitetutorial.net/sqlite-export-csv/.

The details of the export to CSV and the import to calibre will depend on your database schema. (If you don't know what that means then you have a lot more to learn in order to accomplish this.)

quarkpott · 07-10-2017, 10:59 AM

I really know nothing.

But now I have an CSV, Import List and no idea why it doesnt work.

quarkpott · 07-10-2017, 11:06 AM

It's done. All books are in Calibre.

Thanks all

07-10-2017, 10:26 AM	#1
quarkpott Member Posts: 22 Karma: 10 Join Date: Jul 2017 Device: none	.sqlite in calibre Hello, is there any possibility for me to import an .sqlite database to calibre. I have a db with all books, but i like to manage them now with calibre but I dont want to make it new. Sorry for my bad english

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Aura H2O sqlite collections	elwyn5150	Kobo Reader	5	03-07-2017 06:22 PM
SQLite FTS3/4 & Calibre 2.0+	DaltonST	Development	6	08-28-2014 12:02 PM
SQLite	Meeky	Kindle Developer's Corner	2	01-01-2013 12:02 PM
Kindle SQLite DB	akira.spb	Kindle Developer's Corner	2	10-18-2010 11:20 PM

07-10-2017, 10:32 AM	#2
jhowell Grand Sorcerer Posts: 7,162 Karma: 92500001 Join Date: Nov 2011 Location: Charlottesville, VA Device: Kindles	The Import List plugin can do it if you can convert your database into a format it understands, such as CSV.

07-10-2017, 10:35 AM	#3
quarkpott Member Posts: 22 Karma: 10 Join Date: Jul 2017 Device: none	Thanks. How can I convert an sqlite to CSV?

07-10-2017, 10:49 AM	#4
davidfor Grand Sorcerer Posts: 24,905 Karma: 47303824 Join Date: Jul 2011 Location: Sydney, Australia Device: Kobo:Touch,Glo, AuraH2O, GloHD,AuraONE, ClaraHD, Libra H2O; tolinoepos	Most of the SQLite database management tools I have used have an option to save the results of a query as a CSV file. Or an export option for the contents of a table.

07-10-2017, 10:51 AM	#5
quarkpott Member Posts: 22 Karma: 10 Join Date: Jul 2017 Device: none	I'm looking for this. Thanks

07-10-2017, 10:53 AM	#6
jhowell Grand Sorcerer Posts: 7,162 Karma: 92500001 Join Date: Nov 2011 Location: Charlottesville, VA Device: Kindles	There are instructions on the web. For example, http://www.sqlitetutorial.net/sqlite-export-csv/. The details of the export to CSV and the import to calibre will depend on your database schema. (If you don't know what that means then you have a lot more to learn in order to accomplish this.)

07-10-2017, 10:59 AM	#7
quarkpott Member Posts: 22 Karma: 10 Join Date: Jul 2017 Device: none	I really know nothing. But now I have an CSV, Import List and no idea why it doesnt work.

07-10-2017, 11:06 AM	#8
quarkpott Member Posts: 22 Karma: 10 Join Date: Jul 2017 Device: none	It's done. All books are in Calibre. Thanks all