1bnielsen
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.
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
3kristilabrie
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
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.
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
>4 bnielsen: Darn. Okay, I'm going to reopen this and bug ccatalfo about it soon. Thanks for your patience!
6bnielsen
>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.