Calibre content Server and Excel

Thomas_AR · 07-08-2016, 08:30 PM

Well,
let me explain a little bit. For various reason if have my Calibre Book stock parallel in an Excel sheet. I do this by exporting the database into a CSV file and importing this into Excel. I have this nearly automated as Excel checks when opening the csv file for changes and if so it adjusts my Excel sheet with additions, changes, etc.

No i wonder if i can skip this csv exporting and connect Excel directly with the Calibre Content server local. Excel can do this with MySQL servers and a lots of other external sources.
Is there a way with Calibre content server?

Thanks
Thomas

eschwartz · 07-10-2016, 05:47 PM

The calibre metadata.db is a sqlite database, so do whatever you want I guess.

Just keep in mind that if you modify the database it is your job to make sure you don't break it horribly.

...

Does the calibre export take too long or something? Because you can just script it you know.

BetterRed · 07-10-2016, 06:26 PM

@Thomas_AR - try this ==>> SQLiteForExcel

I know nothing about it, other than it exists.

Save caveat as previous post re modifying the db. I would take a snapshot copy of metadata.db and have Excel/VBA use that.

BR

Thomas_AR · 07-10-2016, 08:10 PM

Quote:

Originally Posted by eschwartz

The calibre metadata.db is a sqlite database, so do whatever you want I guess.

Just keep in mind that if you modify the database it is your job to make sure you don't break it horribly.

...

Does the calibre export take too long or something? Because you can just script it you know.

Hm..did not thought about the danger which a direct connection to the Calibre DB means. I think i stay with the method of exporting it to an csv file.

Scripting the procedure? Interesting...where can i finde more information about that?
Thanks

eschwartz · 07-10-2016, 11:21 PM

https://manual.calibre-ebook.com/gen...cli-index.html

Especially, "calibredb catalog".

Thomas_AR · 07-11-2016, 03:55 PM

Quote:

Originally Posted by eschwartz

Especially, "calibredb catalog".

Very interesting. Thanks. Will have a closer look soon.

07-08-2016, 08:30 PM	#1
Thomas_AR Zealot Posts: 131 Karma: 10 Join Date: Jan 2015 Location: Buenos Aires Device: Android	Calibre content Server and Excel Well, let me explain a little bit. For various reason if have my Calibre Book stock parallel in an Excel sheet. I do this by exporting the database into a CSV file and importing this into Excel. I have this nearly automated as Excel checks when opening the csv file for changes and if so it adjusts my Excel sheet with additions, changes, etc. No i wonder if i can skip this csv exporting and connect Excel directly with the Calibre Content server local. Excel can do this with MySQL servers and a lots of other external sources. Is there a way with Calibre content server? Thanks Thomas Last edited by Thomas_AR; 07-09-2016 at 09:24 AM.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
calibre-sync: Automatically download books from your Calibre Content Server onto Kobo	mishagale	Related Tools	14	05-13-2019 05:18 PM
Calibre Content Server and Windows Home Server 2011	HughMcC	Calibre	8	10-01-2014 07:26 AM
500 Internal Server Error accessing content server Calibre 0.8.8	DaddyO57	Calibre	1	07-20-2012 06:08 PM
How do I use the Calibre content server	The Terminator	Devices	11	09-12-2011 08:13 PM
content server in calibre	bruceOz	Calibre	1	04-16-2010 04:23 AM

07-10-2016, 05:47 PM	#2
eschwartz Ex-Helpdesk Junkie Posts: 19,422 Karma: 85397180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	The calibre metadata.db is a sqlite database, so do whatever you want I guess. Just keep in mind that if you modify the database it is your job to make sure you don't break it horribly. ... Does the calibre export take too long or something? Because you can just script it you know.

07-10-2016, 06:26 PM	#3
BetterRed null operator (he/him) Posts: 20,565 Karma: 26954694 Join Date: Mar 2012 Location: Sydney Australia Device: none	@Thomas_AR - try this ==>> SQLiteForExcel I know nothing about it, other than it exists. Save caveat as previous post re modifying the db. I would take a snapshot copy of metadata.db and have Excel/VBA use that. BR

07-10-2016, 11:21 PM	#5
eschwartz Ex-Helpdesk Junkie Posts: 19,422 Karma: 85397180 Join Date: Nov 2012 Location: The Beaten Path, USA, Roundworld, This Side of Infinity Device: Kindle Touch fw5.3.7 (Wifi only)	https://manual.calibre-ebook.com/gen...cli-index.html Especially, "calibredb catalog".

Advert

Advert