Help Csv export settings

cmplus · 01-19-2018, 09:25 AM

Hello, greetings to all those present in the forum, and I apologize for any errors, I am Italian and translate with google translator. I wanted to ask if anyone can help me do an operation with calibers. I also want to export the caliber library in a format, also containing links not only to images but also to ebooks. Currently I can export all the information but I miss the link of the book. Example the link of the cover even if written with cover, but exists of the book no. Is it possible to export the epub or mobi or pdf file link etc? Can you change cover with the name of the book?

theducks · 01-19-2018, 02:22 PM

Quote:

Originally Posted by cmplus

Hello, greetings to all those present in the forum, and I apologize for any errors, I am Italian and translate with google translator. I wanted to ask if anyone can help me do an operation with calibers. I also want to export the caliber library in a format, also containing links not only to images but also to ebooks. Currently I can export all the information but I miss the link of the book. Example the link of the cover even if written with cover, but exists of the book no. Is it possible to export the epub or mobi or pdf file link etc? Can you change cover with the name of the book?

Simple answer: No!
Calibre has a standard file name for the cover and the OPF (metadata backup file)

cmplus · 01-19-2018, 06:42 PM

Thank you for answering. So there are no solutions? Not even an alternative solution to do this?

BetterRed · 01-19-2018, 08:03 PM

Quote:

Originally Posted by cmplus

Thank you for answering. So there are no solutions? Not even an alternative solution to do this?

I'm guessing you want a CSV file that has cells containing links to the format files (i.e. the EPUB, PDF etc) for each book, I don't know of any way to do this.

Unfortunately the person who wrote the catalogue feature is no longer active, so it is more or less frozen. You could change the source for your own usage.

Maybe Kovid would consider adding a --format_links option to the calibredb list command. You could post an Enhancement request here ==>> Bugs : calibre

BR

cmplus · 01-19-2018, 08:12 PM

It's what I want to do, ok thanks I try to do it, too bad that there is no way to do it at present.
I have tried between the various plugins but I have not found anything like that

sammayor · 01-19-2018, 10:04 PM

Well You can create custom column using template. There is template for format path. Then you can include that column when generating catalog.

cmplus · 01-19-2018, 10:19 PM

Quote:

Originally Posted by sammayor

Well You can create custom column using template. There is template for format path. Then you can include that column when generating catalog.

Thanks for the info, do you have any guide to see how to create this column? It would be amazing to be able to do it

sammayor · 01-19-2018, 10:45 PM

https://www.mobileread.com/forums/sh...76&postcount=4

You can use whatever lookup name and column heading you want. Note that there may be some delay in starting calibre as all values need to be calculated.

Divingduck · 01-20-2018, 06:24 AM

@sammayor

@cmplus, don't hesitate to ask if you need help using the command line tools.

cmplus · 01-20-2018, 08:13 AM

Quote:

Originally Posted by Divingduck

@sammayor

@cmplus, don't hesitate to ask if you need help using the command line tools.

Thank you so much, I have never used the command line tools, so I thank your help
where do I see going to start?

Divingduck · 01-20-2018, 08:26 AM

First setup a custom column as shown in the linked post (Preferences -> Interface -> Add your own columns) and after restarting calibre you can use the cmd string:

calibredb list --fields=authors,title,*pathfilename >testpath.txt

in your command line window. In the post you will find a link to calibre's help section too.

Remark: I just recognize there was a little typo in my linked post. author need to be change to authors

cmplus · 01-20-2018, 08:45 AM

Thanks, here I did. Thanks to you for your support

cmplus · 01-20-2018, 08:46 AM

Quote:

Originally Posted by Divingduck

First setup a custom column as shown in the linked post (Preferences -> Interface -> Add your own columns) and after restarting calibre you can use the cmd string:

calibredb list --fields=authors,title,*pathfilename >testpath.txt

in your command line window. In the post you will find a link to calibre's help section too.

Remark: I just recognize there was a little typo in my linked post. author need to be change to authors

Thanks, here I did. Thanks to you for your support

cmplus · 01-20-2018, 09:40 AM

But can the images replace the links from cover to book name?
Now the link that is saved in the csv is path \ cover.jpg. Can you replace cover.jpg with the path name?

Divingduck · 01-20-2018, 10:59 AM

Not sure if I understand your question correct. Lets see.

Within the calibre library the cover file is always called cover.jpg. You can't change or modify this as it is a structural convention of the library.

In case you want to copy all book and cover files into an other file structure you can do what ever you want. In this case you need post processing your csv file or the cover file outside calibre.

01-19-2018, 09:25 AM	#1
cmplus Member Posts: 12 Karma: 10 Join Date: Jan 2018 Device: none	Help Csv export settings Hello, greetings to all those present in the forum, and I apologize for any errors, I am Italian and translate with google translator. I wanted to ask if anyone can help me do an operation with calibers. I also want to export the caliber library in a format, also containing links not only to images but also to ebooks. Currently I can export all the information but I miss the link of the book. Example the link of the cover even if written with cover, but exists of the book no. Is it possible to export the epub or mobi or pdf file link etc? Can you change cover with the name of the book?

01-20-2018, 08:26 AM	#11
Divingduck Wizard Posts: 1,166 Karma: 1410083 Join Date: Nov 2010 Location: Germany Device: Sony PRS-650	First setup a custom column as shown in the linked post (Preferences -> Interface -> Add your own columns) and after restarting calibre you can use the cmd string: calibredb list --fields=authors,title,pathfilename >testpath.txt in your command line window. In the post you will find a link to calibre's help section too. Remark: I just recognize there was a little typo in my linked post. author need to be change to authors Last edited by Divingduck; 01-20-2018 at 08:32 AM.*

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Is there a way to export a list of all authors to a csv file?	LadyKate	Library Management	4	02-01-2022 01:10 PM
How to export settings to another computer?	Dars Veider	Library Management	10	06-13-2018 03:38 AM
Export CSV of specific view?	sweth	Library Management	2	07-21-2017 06:09 PM
export list of books in a csv file	jcarlier	Conversion	8	09-07-2013 09:59 PM
Export to CSV/XLS?	highwaykind	Calibre	19	05-31-2009 02:35 PM

01-19-2018, 06:42 PM	#3
cmplus Member Posts: 12 Karma: 10 Join Date: Jan 2018 Device: none	Thank you for answering. So there are no solutions? Not even an alternative solution to do this?

01-19-2018, 08:12 PM	#5
cmplus Member Posts: 12 Karma: 10 Join Date: Jan 2018 Device: none	It's what I want to do, ok thanks I try to do it, too bad that there is no way to do it at present. I have tried between the various plugins but I have not found anything like that

01-19-2018, 10:04 PM	#6
sammayor Enthusiast Posts: 31 Karma: 81732 Join Date: Feb 2014 Device: KPW3	Well You can create custom column using template. There is template for format path. Then you can include that column when generating catalog.

01-19-2018, 10:45 PM	#8
sammayor Enthusiast Posts: 31 Karma: 81732 Join Date: Feb 2014 Device: KPW3	https://www.mobileread.com/forums/sh...76&postcount=4 You can use whatever lookup name and column heading you want. Note that there may be some delay in starting calibre as all values need to be calculated.

01-20-2018, 06:24 AM	#9
Divingduck Wizard Posts: 1,166 Karma: 1410083 Join Date: Nov 2010 Location: Germany Device: Sony PRS-650	@sammayor @cmplus, don't hesitate to ask if you need help using the command line tools.

01-20-2018, 08:45 AM	#12
cmplus Member Posts: 12 Karma: 10 Join Date: Jan 2018 Device: none	Thanks, here I did. Thanks to you for your support

01-20-2018, 09:40 AM	#14
cmplus Member Posts: 12 Karma: 10 Join Date: Jan 2018 Device: none	But can the images replace the links from cover to book name? Now the link that is saved in the csv is path \ cover.jpg. Can you replace cover.jpg with the path name?

01-20-2018, 10:59 AM	#15
Divingduck Wizard Posts: 1,166 Karma: 1410083 Join Date: Nov 2010 Location: Germany Device: Sony PRS-650	Not sure if I understand your question correct. Lets see. Within the calibre library the cover file is always called cover.jpg. You can't change or modify this as it is a structural convention of the library. In case you want to copy all book and cover files into an other file structure you can do what ever you want. In this case you need post processing your csv file or the cover file outside calibre.

Advert

Advert