This site uses cookies to deliver our services, improve performance, for analytics, and (if not signed in) for advertising. By using LibraryThing you acknowledge that you have read and understand our Terms of Service and Privacy Policy. Your use of the site and services is subject to these policies and terms.
  • LibraryThing
  • Book discussions
  • Your LibraryThing
  • Join to start using.

Exporting library errors

Bug Collectors

Join LibraryThing to post.

Oct 7, 12:18pm Top

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?

Pete B

Oct 11, 6:50pm Top

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.

Pete B

Oct 11, 9:15pm Top

>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.

Oct 12, 9:41am Top

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.

Pete B

Oct 12, 1:46pm Top

>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.

Oct 12, 6:48pm Top

Yes, it is important that the ASIN be added. After all, just myself, I have over 500 ebooks, and that is the way they are tracked nowadays, having no ISBN in most cases. That is the reason I made a posting on this, it is vital information.

Pete B

Group: Bug Collectors

886 members

91,115 messages

Bug Tracking

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.

Bug (edit)

ID: 297201

Category: Uncategorized

Assigned to all

Reported by peteb

Status: Closed by member

Oct 12, 9:41am

59 days since last change

By peteb

Status log

Reported. peteb (Oct 7, 12:18pm)

Closed by staff. lorannen (Oct 11, 9:15pm)

Closed by member. peteb (Oct 12, 9:41am)


This topic is not marked as primarily about any work, author or other topic.


No touchstones

About | Contact | Privacy/Terms | Help/FAQs | Blog | Store | APIs | TinyCat | Legacy Libraries | Early Reviewers | Common Knowledge | 130,692,375 books! | Top bar: Always visible