Export to CSV/XLS?

highwaykind · 05-22-2009, 05:15 AM

Is there, or will there be, an export function with which I can export a CSV or XLS file list with all my cataloged books?
(Very preferably with ISBN numbers; that way I can easily import them in, say, goodreads.com

)

Thanks!

user_none · 05-22-2009, 07:00 AM

XLS no. Other format such as CSV or XML maybe in the future.

highwaykind · 05-22-2009, 07:51 AM

Excellent! Thanks!

(I think all of those sites where you can import work mainly with ISBN numbers, so if I can export title/author/ISBN in some way I'm all set, csv might be easiest, but I'm obviously no programmer.)

kovidgoyal · 05-22-2009, 01:05 PM

see

calibredb list --help

highwaykind · 05-22-2009, 01:08 PM

Where can I find "calibredb list --help" ?
On this forum I can't find it..?

itimpi · 05-22-2009, 02:25 PM

What Kovid means is get into a terminal window (or a Command Window under Windows) and enter that command which will list the options available for the calibredb program.

bxrLvr · 05-30-2009, 06:46 PM

nm figured it out.

FizzyWater · 05-30-2009, 10:08 PM

This command displayed the results inside my Command window. Is there a way to make it create an actual text file?

kovidgoyal · 05-30-2009, 10:30 PM

append

> output.txt

to the command

highwaykind · 05-31-2009, 04:31 AM

DOS window:

C:\Program Files\calibre>calibredb list -f > calibrefiles.txt
Access is denied.

C:\Program Files\calibre>calibredb list >D:\calibre.txt
Traceback (most recent call last):
File "cli.py", line 553, in <module>
File "cli.py", line 550, in main
File "cli.py", line 228, in command_list
File "cli.py", line 125, in do_list
File "calibre\library\database2.pyo", line 1338, in get_data_as_dict
AttributeError: 'NoneType' object has no attribute 'split'
(does result in empty text file on D: )

(OS: Vista Ultimate, I'm the only user on this PC so auto-admin)

highwaykind · 05-31-2009, 04:37 AM

Quote:

Originally Posted by bxrLvr

nm figured it out.

Would you mind editing in the solution?

itimpi · 05-31-2009, 05:06 AM

You are not allowed to write to the Program files area. Either the Command Box must be opened elsewhere, or the pathname for the output file must point to somewhere where writing is allowed.

highwaykind · 05-31-2009, 05:12 AM

I'm pretty sure I've got admin rights (single user PC) and I am very sure I can write to D:\
Bloody Vista messing things up again?

itimpi · 05-31-2009, 06:31 AM

Under Vista even admin users do not normally run with admin rights. You have to explicitly select to run the specific program with admin rights.

highwaykind · 05-31-2009, 06:50 AM

Don't think I can run "cmd" with specific admin rights.
Guess I'll just have to be patient and wait until it's implemented.
(unless there's some way to force admin in DOS, but I was happy to remember the cd and dir commands

)

05-22-2009, 05:15 AM	#1
highwaykind Connoisseur Posts: 54 Karma: 10 Join Date: May 2009 Device: Kindle Touch	Export to CSV/XLS? Is there, or will there be, an export function with which I can export a CSV or XLS file list with all my cataloged books? (Very preferably with ISBN numbers; that way I can easily import them in, say, goodreads.com ) Thanks!

05-22-2009, 01:08 PM	#5
highwaykind Connoisseur Posts: 54 Karma: 10 Join Date: May 2009 Device: Kindle Touch	Where can I find "calibredb list --help" ? On this forum I can't find it..? Last edited by highwaykind; 05-22-2009 at 01:08 PM. Reason: added text

05-30-2009, 06:46 PM	#7
bxrLvr Connoisseur Posts: 63 Karma: 102 Join Date: Mar 2009 Location: California Device: Kindle 3, iPad	nm figured it out. Last edited by bxrLvr; 05-30-2009 at 06:51 PM.

05-31-2009, 04:31 AM	#10
highwaykind Connoisseur Posts: 54 Karma: 10 Join Date: May 2009 Device: Kindle Touch	DOS window: C:\Program Files\calibre>calibredb list -f > calibrefiles.txt Access is denied. C:\Program Files\calibre>calibredb list >D:\calibre.txt Traceback (most recent call last): File "cli.py", line 553, in <module> File "cli.py", line 550, in main File "cli.py", line 228, in command_list File "cli.py", line 125, in do_list File "calibre\library\database2.pyo", line 1338, in get_data_as_dict AttributeError: 'NoneType' object has no attribute 'split' (does result in empty text file on D: ) (OS: Vista Ultimate, I'm the only user on this PC so auto-admin) Last edited by highwaykind; 05-31-2009 at 04:33 AM. Reason: added D:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Convert your my clippings.txt to .doc, csv, and html	Ericc22	Amazon Kindle	12	11-24-2022 06:00 AM
how do I export my Kobo books	Zepherious	Kobo Reader	4	05-29-2010 02:43 PM
Import/Export	Scullion	Calibre	2	08-03-2009 01:15 AM
Export Highlights	musemj6	Amazon Kindle	1	12-09-2008 10:11 PM
export text	sas	Reading and Management	4	12-02-2003 10:05 AM

05-22-2009, 07:00 AM	#2
user_none Sigil & calibre developer Posts: 2,488 Karma: 1063785 Join Date: Jan 2009 Location: Florida, USA Device: Nook STR	XLS no. Other format such as CSV or XML maybe in the future.

05-22-2009, 07:51 AM	#3
highwaykind Connoisseur Posts: 54 Karma: 10 Join Date: May 2009 Device: Kindle Touch	Excellent! Thanks! (I think all of those sites where you can import work mainly with ISBN numbers, so if I can export title/author/ISBN in some way I'm all set, csv might be easiest, but I'm obviously no programmer.)

05-22-2009, 01:05 PM	#4
kovidgoyal creator of calibre Posts: 43,860 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	see calibredb list --help

05-22-2009, 02:25 PM	#6
itimpi Wizard Posts: 4,552 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	What Kovid means is get into a terminal window (or a Command Window under Windows) and enter that command which will list the options available for the calibredb program.

05-30-2009, 10:08 PM	#8
FizzyWater You kids get off my lawn! Posts: 4,220 Karma: 73492664 Join Date: Aug 2007 Location: Columbus, Ohio Device: Oasis 2 and Libra H2O and half a dozen older models I can't let go of	This command displayed the results inside my Command window. Is there a way to make it create an actual text file?

05-30-2009, 10:30 PM	#9
kovidgoyal creator of calibre Posts: 43,860 Karma: 22666666 Join Date: Oct 2006 Location: Mumbai, India Device: Various	append > output.txt to the command

05-31-2009, 05:06 AM	#12
itimpi Wizard Posts: 4,552 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	You are not allowed to write to the Program files area. Either the Command Box must be opened elsewhere, or the pathname for the output file must point to somewhere where writing is allowed.

05-31-2009, 05:12 AM	#13
highwaykind Connoisseur Posts: 54 Karma: 10 Join Date: May 2009 Device: Kindle Touch	I'm pretty sure I've got admin rights (single user PC) and I am very sure I can write to D:\ Bloody Vista messing things up again?

05-31-2009, 06:31 AM	#14
itimpi Wizard Posts: 4,552 Karma: 950151 Join Date: Nov 2008 Device: Sony PRS-950, iphone/ipad (Marvin/iBooks/QuickReader)	Under Vista even admin users do not normally run with admin rights. You have to explicitly select to run the specific program with admin rights.

05-31-2009, 06:50 AM	#15
highwaykind Connoisseur Posts: 54 Karma: 10 Join Date: May 2009 Device: Kindle Touch	Don't think I can run "cmd" with specific admin rights. Guess I'll just have to be patient and wait until it's implemented. (unless there's some way to force admin in DOS, but I was happy to remember the cd and dir commands )

Advert

Advert