Register Guidelines E-Books Search Today's Posts Mark Forums Read

Go Back   MobileRead Forums > E-Book Software > Calibre > Library Management

Notices

Reply
 
Thread Tools Search this Thread
Old 05-05-2012, 04:02 PM   #1
Jnassise
Member
Jnassise can talk all four legs off a donkey... then persuade it to go for a walk.Jnassise can talk all four legs off a donkey... then persuade it to go for a walk.Jnassise can talk all four legs off a donkey... then persuade it to go for a walk.Jnassise can talk all four legs off a donkey... then persuade it to go for a walk.Jnassise can talk all four legs off a donkey... then persuade it to go for a walk.Jnassise can talk all four legs off a donkey... then persuade it to go for a walk.Jnassise can talk all four legs off a donkey... then persuade it to go for a walk.Jnassise can talk all four legs off a donkey... then persuade it to go for a walk.Jnassise can talk all four legs off a donkey... then persuade it to go for a walk.Jnassise can talk all four legs off a donkey... then persuade it to go for a walk.Jnassise can talk all four legs off a donkey... then persuade it to go for a walk.
 
Posts: 14
Karma: 124364
Join Date: Mar 2010
Device: Sony Reader
Help with export re: isbns

I'm interested in exporting my 4000+ book library into a csv file for import into Goodreads.

Without realizing it, I seem to have collected both isbns and Amazon ASINs automatically into the ISBN field of my database (perhaps through auto download of metadata?)

Is there a way to bulk edit the isbn field so that only one isbn is contained in it? I'd rather not do this by hand with a library of this time. (Or, conversely, is there a way to clean up the csv file so that Goodreads will accept it?)

Thanks,
Joe
Jnassise is offline   Reply With Quote
Old 05-06-2012, 01:20 AM   #2
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,863
Karma: 12755553
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
Quote:
Originally Posted by Jnassise View Post
I'm interested in exporting my 4000+ book library into a csv file for import into Goodreads.
...
Or, conversely, is there a way to clean up the csv file so that Goodreads will accept it?
Between the sample CSV file provided on this page of the Goodreads site and the create a catalog feature (see attached) that will export the data you select as a CSV file you should be good to go.

Additionally once you do the major import you can keep your calibre library and Goodreads in sync using the Goodreads Sync plugin.

Good Luck.
Attached Thumbnails
Click image for larger version

Name:	createcatalog.jpg
Views:	44
Size:	82.9 KB
ID:	86126  

Last edited by DoctorOhh; 05-06-2012 at 06:12 AM.
DoctorOhh is online now   Reply With Quote
Old 05-06-2012, 05:18 AM   #3
tilia
Addict
tilia ought to be getting tired of karma fortunes by now.tilia ought to be getting tired of karma fortunes by now.tilia ought to be getting tired of karma fortunes by now.tilia ought to be getting tired of karma fortunes by now.tilia ought to be getting tired of karma fortunes by now.tilia ought to be getting tired of karma fortunes by now.tilia ought to be getting tired of karma fortunes by now.tilia ought to be getting tired of karma fortunes by now.tilia ought to be getting tired of karma fortunes by now.tilia ought to be getting tired of karma fortunes by now.tilia ought to be getting tired of karma fortunes by now.
 
tilia's Avatar
 
Posts: 388
Karma: 1441403
Join Date: Mar 2011
Device: Kindle 3
You can remove the amazon ids using search&replace.

Select the books with amazon-ids, choose search&replace under edit metadata.

Search-mode: regular expressions
Search field: identifiers
Identifiers type: amazon
Search for: .*
and don't type anything in the replace field

This should remove Asins, and keep the isbns. But please backup your library before you try!
tilia is offline   Reply With Quote
Old 05-06-2012, 06:08 AM   #4
DoctorOhh
US Navy, Retired
DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.DoctorOhh ought to be getting tired of karma fortunes by now.
 
DoctorOhh's Avatar
 
Posts: 8,863
Karma: 12755553
Join Date: Feb 2009
Location: North Carolina
Device: Nexus 7
@Jnassise I may not have been clear in my previous post. You do not have to remove any identifiers because the create catalog feature will allow the exporting of just the ISBNs (see attached) to the CSV formatted catalog. You do not need to include all of the identifiers if you only choose isbn that is all that you will get. No amazon numbers will be in the created csv file.
Attached Thumbnails
Click image for larger version

Name:	selectcatalogitems.jpg
Views:	46
Size:	78.0 KB
ID:	86129  

Last edited by DoctorOhh; 05-06-2012 at 06:11 AM.
DoctorOhh is online now   Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problem Creating Catalog of ISBNs desilva Library Management 4 08-09-2011 06:44 PM
Exporting ISBNs for Import Into GoodReads anamardoll Calibre 3 06-12-2011 01:02 PM
Mass import of ISBNs avantman42 Calibre 9 12-03-2010 01:39 AM
Ebooks and ISBNs Nate the great News 39 12-06-2009 08:39 AM
Ebooks ISBNs and Calibre? Statch Calibre 5 11-29-2009 11:29 AM


All times are GMT -4. The time now is 11:31 PM.


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