07-09-2012, 03:23 PM | #1 |
Member Retired
Posts: 7
Karma: 10
Join Date: Jul 2012
Device: Sony prs-t1
|
CSV column question ('comments')
Hi all,
I've been trying to create a catalogue in .csv to have a simple list of all the books I have. I include the title, author, comments, and identifiers. I've figured out how to work with the UTF-8 code. My question: In the column "comments", I have a brief summary of the book. When I create a catalog, I get the columns in this order: author, comments, identifier, title. I assume this is because it's alphabetic. However, the last two columns then appear on the second line, which makes it impossible for me to have an overview. I think this has something to do with the comments column, because there, the text is quite long. When I make a list excluding the comments column, everything is fine and I can create a nice spreadsheet. Is there something I'm doing wrong? Perhaps it would help if I could mark that the comments column should be last? Thanks for your help! Michelle |
07-09-2012, 07:27 PM | #2 |
Comparer of the Ephemeris
Posts: 1,496
Karma: 424697
Join Date: Mar 2009
Device: iPad
|
As you observed, calibre exports the columns in alphabetic order. To change the column order after exporting, open the CSV file in your spreadsheet program and rearrange the columns as you want them.
G |
Advert | |
|
07-10-2012, 09:18 AM | #3 |
Member Retired
Posts: 7
Karma: 10
Join Date: Jul 2012
Device: Sony prs-t1
|
@GRiker
Thanks for your reply. I understand that I can do that normally, but I can't do that when I use the 'comments' column. Then, because the input per book is so long, the 2 columns that come after 'comments', are put on the next line. I can't cut/paste anything then, because I would also be doing that to other data. |
07-10-2012, 09:32 AM | #4 | |
Well trained by Cats
Posts: 29,804
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
Your other choice is to try the Command Line Interface (See Calibre online Help): http://manual.calibre-ebook.com/cli/...calibredb-list |
|
07-10-2012, 01:55 PM | #5 |
Member Retired
Posts: 7
Karma: 10
Join Date: Jul 2012
Device: Sony prs-t1
|
@theducks
Hi! I'm not sure I understand exactly what you mean. If you mean that this happens because there are commas in the summaries, then I can tell you that is not a problem. For some reason the program sees this and doesn't use it as a marker to put the rest of the text in a new column. (You can't see that in the attachment I put in above but I've tried this with many entries!) |
Advert | |
|
07-10-2012, 02:43 PM | #6 | |
Well trained by Cats
Posts: 29,804
Karma: 54830978
Join Date: Aug 2009
Location: The Central Coast of California
Device: Kobo Libra2,Kobo Aura2v1, K4NT(Fixed: New Bat.), Galaxy Tab A
|
Quote:
|
|
08-27-2012, 05:53 PM | #7 |
Dedicated
Posts: 441
Karma: 11279376
Join Date: Jun 2012
Location: Amarillo, TX
Device: iPad Mini 1 & 4, Nook ST, Dell 11-3000, iPhone 5s
|
Hi Michelleh312,
I'm probably 6 weeks too late, but I just noticed your post when I was doing some browsing in the forum. Have you solved your problem? Do you use Excel? In the unlikely event that you still need some help ... In Excel, go to: Format > Cells > Alignment and see if "Wrap Text" is checked. If it is, remove the check and see if that helps. |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
question on column coloring | Jade Aislin | Library Management | 3 | 07-09-2012 09:54 AM |
Question about column coloring | bulldogmo | Calibre | 7 | 05-06-2012 10:50 AM |
Bulk Edit Comments column | Jade Aislin | Library Management | 0 | 10-27-2011 03:18 AM |
User column based on part of "Comments" ? | pchrist7 | Calibre | 76 | 01-23-2011 07:14 AM |
Question about Column Sorting | danwdoo | Calibre | 8 | 03-05-2009 11:59 AM |