Error log # 1753471578 when trying to import MARC file

cberrigan
I am trying to import into Zotero from Library Thing (where I logged the hundreds of physical copies of my library over many years).

I have the option to export as JSON file, MARC, CSV, or XLS.
https://www.librarything.com/export.php?export_type=marc

I have not had success importing JSON or MARC. I submitted documentation of the error upon importing the MARC file under log # 1753471578.

thank you!
  • adamsmith
    Does this also happen if you just export a couple of your books? If so, would you mind putting the exported MARC file somewhere we can download it to take a look?
    Also, which of the two export options ('basic' or 'use existing records') are you using?
  • cberrigan
    Thanks for your response. I tried a few different things, and have uploaded exports 2, 4, and 5 to troubleshoot. You can download them here: https://we.tl/t-dMkeTbwE6O

    Export 2 is only 7 books, and they imported without errors using both 'basic' and 'existing records' settings.

    Exports 4 (basic) and 5 (existing records) include the whole library of 773 items, and neither one of them imported.

    I will note that a fair number of items do not have ISBN numbers or would not exist with a MARC record, since they are artist's books, zines, and rare items.

    Thanks for your help!
  • adamsmith
    That's an error in the MARC they're exporting. If you open this in a text editor, you'll see an error message come up a bunch (7, to be exact, for the basic export) of times:

    html>
    <head>
    <title>Bad Request</title>
    </head>
    <body>
    <h1><p>Bad Request</p></h1>
    Request Line is too large (4298 &gt; 4094)
    </body>
    </html>

    The first time this shows is right after the "Living Origami" entry -- if I see this correctly, the entry followed by that error message is broken and will cause an import error. You should be able to delete these in the MARC, but it's a bit fiddly (the first three are Living Origami, Lady Hamilton, For colored girls who have considered for )

  • cberrigan
    edited October 6, 2023
    Thanks for looking at the exports! I tried to remove all of the error entries, but it still won't import. Maybe I didn't correctly adjust where the MARC entry starts and ends? Below is the full text of a few that I removed:

    00301 2200121 i 4500001001000000003000700010005001700017020001500034040002400049245001900073520002500092923006200117159768715MePoLT20231005105920.0 a3731902699 aMePoLTcMePoLTerda00aLady Hamilton. aLady Hamilton (1970) aYour libraryaTheory & Non-fictionaTo read - Near future<html>
    <head>
    <title>Bad Request</title>
    </head>
    <body>
    <h1><p>Bad Request</p></h1>
    Request Line is too large (4538 &gt; 4094)
    </body>
    </html>

    00589 2200181 i 4500001001000000003000700010005001700017020001500034040002400049090002000073092001100093100002100104245007600125264005700201300001100258520010000269923003800369159902125MePoLT20231005105932.0 a1439186812 aMePoLTcMePoLTerda 4aPS3569.H3324 F6 4a811.541 aShange, Ntozake.10aFor colored girls who have considered suicide/When the rainbow is enuf. 1aScribner (2010), Editionb Reprint, 96 pages,c2010. a96 p. aFor colored girls who have considered suicide/When the rainbow is enuf by Ntozake Shange (2010) aYour libraryaNovels & Literature<html>
    <head>
    <title>Bad Request</title>
    </head>
    <body>
    <h1><p>Bad Request</p></h1>
    Request Line is too large (4650 &gt; 4094)
    </body>
    </html>

    00482 2200181 i 4500001001000000003000700010005001700017020001500034040002400049090002200073092001100095100002100106245002400127264005100151300001200202520004800214923003800262159916088MePoLT20231005105939.0 a031286034X aMePoLTcMePoLTerda 4aPS3553.A78278 F67 4a813.541 aCarter, Raphael.10aThe Fortunate Fall. 1aForge (1996), Editionb 1st, 288 pages,c1996. a288 p. aThe Fortunate Fall by Raphael Carter (1996) aYour libraryaNovels & Literature<html>
    <head>
    <title>Bad Request</title>
    </head>
    <body>
    <h1><p>Bad Request</p></h1>
    Request Line is too large (6922 &gt; 4094)
    </body>
    </html>

    00459 2200181 i 4500001001000000003000700010005001700017020001500034040002400049090001700073092001100090100001100101245001700112264006600129300001200195520003200207923003800239159917214MePoLT20231005105943.0 a0393089053 aMePoLTcMePoLTerda 4aPA4025.A5 F5 4a883.011 aHomer.10aThe Odyssey. 1aW. W. Norton & Company (2017), Editionb 1, 592 pages,c2017. a592 p. aThe Odyssey by Homer (2017) aYour libraryaNovels & Literature<html>
    <head>
    <title>Bad Request</title>
    </head>
    <body>
    <h1><p>Bad Request</p></h1>
    Request Line is too large (4150 &gt; 4094)
    </body>
    </html>



  • cberrigan
    Sorry... I'm not sure how to post HTML content here as plain text, but the "bad request" sections I removed are the plain text versions, as in your comment above.
  • adamsmith
    This should work:
    https://www.dropbox.com/scl/fi/t0xz5lf2dgf31pcma56s0/librarything_ceberrigan4.marc?rlkey=tsdq1tz5luskqx7382hc5zc8x&dl=0

    Looks like some items go missing -- his imported 754 for me, I removed 7 bad request tags, so that leaves 12 unaccounted for. I didn't actually remove any entry in the MARC, though, and the MARC has only 754 items, so all missing info is on LibraryThing.
  • cberrigan
    Amazing, that worked for me. It's so generous of you to help me fix the MARC export! Many many thanks. :) :) :)
Sign In or Register to comment.