Exporting library errors
Join LibraryThing to post.
I am trying to export my library to an Excel file. The export seems to go OK and allows me to download the Excel file. The file looks good except it does not include all the informtion that is stored for the records, specificlly it does not export the ASIN information for any of the records for ebooks. That info is in the library, if I open up a book's Edit page/sheet, the ASIN information is displayed in the designated location, but that info is not in the Excel file.
Is this an error, or is it a limitation as to what information can be exported, or what? My ultimate goal is to import this data into a local database on my PC (as a backup), but without the ASIN field I am unable to do that as it would require me to go through each of the 2100+ records and fill in the field manually if appropriate, an exhaustive task. Can anyone help?
I was kind of surprised that I did not receive any comments or suffesxtions on this problem. But no matter mow, I figured out a way to accomplish the job using the web views of my library and the great tools available to deal with data in Excel; I managed to get the whole lib ported to Excel in one session fo a few hours, and all the fields are included.
>2 peteb: Sorry, I missed your post the other day. I'm afraid, however, that this isn't a bug—the ASIN field is not currently editable in your LibraryThing record (though it can be added if the data source you're cataloging from has that info). I believe that currently, the only export option that captures this data is MARC format. And it's still something we need to add to our other exports.
Please forgive my atrocious spelling mistakes in my post above :=).
I understand that the ASIN may not initially be present in the LT database origination record, but it is available at some point in your processing of the database records, it appears in every Edit view and in every view of my user library as seen on the web, so that info is present, or should be available, at the time of generating the export download, which in essence is just another specific view of the database itself. But it really does not matter at this point.
Actually, once I figured out how to generate my own Excel export file from the view presented on the internet, it was rather easy to add in the ASIN field to the file itself, although somewhat tedious due to the extraneous data present but not displayed in trhe web view (such as library Dewey fields and such). The whole process of obtaining the actual Excel file data mainly consisted of deleting that unneeded information since the net view did include the ASIN field. The end result was an Excel file containing all the desired record fields that are present in my LT view and in your Excel download with an additional column showing the ASIN field extractecd from the web view, and with all the unrequested columns not specified for the web view deleted -- which is what I wanted.
Whole purpose is I want to generate my own local database on my PC as a backup for the LT and for my own use, such as instances when I am not connected to the web for example, and other such local use. I can design and build my own databases with no problem, I did it for years before I retired, but getting the data from LT is mandatory, no way I could enter all that agian from scratch.
My own local database will also allow me to make hard copy info sheets and reports for my own reference at home too. I also plan to devise a method for designating and storing the "tags" as a calculated field in the records rather than using the strings of text that LT uses, such as employing a binary value tied to a separate Tags table that is linked to the other database tables, kind of like using the bits of a binary value to encode available option settings into a single unique numeric field.
Thanlks for the reply, I do love LT.
>4 peteb: No problem! I completely understand. It's definitely something we need to add to our exports, whether it's member-editable or not.
This topic is part of LibraryThing's in-talk bug tracking.
Join or watch Bug Collectors to get "Bug Tracking" under "The World" in Talk all the time.
Assigned to all
Reported by peteb
Status: Closed by member
Oct 12, 9:41am
59 days since last change
This topic is not marked as primarily about any work, author or other topic.