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 06-09-2011, 11:44 AM   #1
desilva
Member
desilva began at the beginning.
 
desilva's Avatar
 
Posts: 12
Karma: 10
Join Date: Aug 2010
Device: Kindle2
Problem Creating Catalog of ISBNs

I apologize if this has already been addresses.

When exporting isbn the numbers changes. For example in calibre the isbn reads 9780758207012, however after I run the export it appears as 9.78076E+12 in the spread sheet. What am I doing wrong? I simply want to get a list of my isbns to paste them into google books.

I have read about a way to do this in calibredb command mentioned here http://www.mobileread.com/forums/showthread.php?t=67804
however I could not figure out how to do this.
desilva is offline   Reply With Quote
Old 06-09-2011, 12:47 PM   #2
GRiker
Comparer of the Ephemeris
GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.GRiker ought to be getting tired of karma fortunes by now.
 
Posts: 1,497
Karma: 424627
Join Date: Mar 2009
Device: iPad
In your spreadsheet program, change the format of the ISBN column. For example, in Excel or Numbers, change the cell format to Number with 0 decimal places.

G
GRiker is offline   Reply With Quote
 
Advertisement
Old 06-09-2011, 03:48 PM   #3
desilva
Member
desilva began at the beginning.
 
desilva's Avatar
 
Posts: 12
Karma: 10
Join Date: Aug 2010
Device: Kindle2
thanks!
desilva is offline   Reply With Quote
Old 08-09-2011, 06:35 PM   #4
TreborPugly
Member
TreborPugly has learned how to read e-booksTreborPugly has learned how to read e-booksTreborPugly has learned how to read e-booksTreborPugly has learned how to read e-booksTreborPugly has learned how to read e-booksTreborPugly has learned how to read e-booksTreborPugly has learned how to read e-booksTreborPugly has learned how to read e-books
 
Posts: 13
Karma: 954
Join Date: Jun 2010
Device: Mobipocket reader on Blackberry, XO using FBreader, Kindle
Actually, you should probably use Text as the format in excel. Alot of 10 digit isbn's start with zero, which will get lost if you use a number format.
TreborPugly is offline   Reply With Quote
Old 08-09-2011, 07:44 PM   #5
theducks
Grand Sorcerer
theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.theducks ought to be getting tired of karma fortunes by now.
 
theducks's Avatar
 
Posts: 15,287
Karma: 6022733
Join Date: Aug 2009
Location: (The original) Silicon Valley, USA
Device: Galaxy Tab 2, Astak Pocket Pro, K4NT
Quote:
Originally Posted by desilva View Post
I apologize if this has already been addresses.

When exporting isbn the numbers changes. For example in calibre the isbn reads 9780758207012, however after I run the export it appears as 9.78076E+12 in the spread sheet. What am I doing wrong? I simply want to get a list of my isbns to paste them into google books.

I have read about a way to do this in calibredb command mentioned here http://www.mobileread.com/forums/showthread.php?t=67804
however I could not figure out how to do this.
ISBN are Always Text besides your problem. Numbers will drop the leading Zero (ISBN10)
BTW there are ISBN10's that end in 'X' (valid check digit 0-9,X)
theducks is offline   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
Error creating an epub catalog pscynthetiq Library Management 1 03-23-2011 07:52 AM
Conversion Error when creating Catalog thangnh Library Management 1 02-21-2011 09:38 AM
Problem with Catalog in Calibre clockmaker Library Management 1 10-05-2010 07:27 AM
Creating an online Stanza catalog wdonne News 6 02-25-2010 04:33 PM


All times are GMT -4. The time now is 04:41 AM.


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