Exporting to Excel gives a bad record

TalkBug Collectors

Join LibraryThing to post.

Exporting to Excel gives a bad record

1bnielsen
Edited: Nov 15, 9:39 am

Just reporting that one of my books seems to trigger a bug in the Excel export. (I'll just use one of the other export formats,)

When I try to export my library in xls format the records starting with Book ID 22204952 are missing some of the fields. When I try to export just the book with Book ID 22204952 I get a file that libre office shows as empty.

2kristilabrie
Edited: Nov 13, 11:21 am

Excel export All exports seem to be stalled out at the moment, at least on my end in Chrome (trying both your account and my own). Looking.

3kristilabrie
Nov 15, 9:25 am

Okay, ccatalfo was able to fix this Wednesday afternoon, if you want to give it another go! Let me know if you come across further issues. Thanks for your patience.

4bnielsen
Edited: Nov 15, 4:00 pm

Thanks. I can export some of my records as excel. So a filtered export of "1001 nat" gives a nice excel file. But if I try to export the whole catalog I get a 62656512 bytes file that I can't open in libre office calc and looks like it is corrupt.
A filtered export of "Generalisation af Gruppebegrebet" gives a small excel file that I can't open in libre office calc.

So I still have issues with the excel export, although I can export some of the books just fine.

ETA: my secret plan is to export as xls and save it as csv and look for any differences between that and the TSV export.
The small sample with "1001 nat" looks fine in that respect, but it is only a tiny fraction of my catalog.

5kristilabrie
Nov 18, 9:37 am

>4 bnielsen: Darn. Okay, I'm going to reopen this and bug ccatalfo about it soon. Thanks for your patience!

6bnielsen
Nov 18, 2:10 pm

>5 kristilabrie: No problem. I just like to play around with the various formats. Some of my books have large reviews and they break the Marc export. Excel seems to handle large reviews with lots of line breaks just fine, so I'm not sure what goes wrong here. I suspect some kind of programming error since it seems that an error spoils the rest of the export file? Thanks for looking into it.