Import a CSV of Barcodes

DiscussieFrequently Asked Questions

Sluit je aan bij LibraryThing om te posten.

Import a CSV of Barcodes

1trl_path
jan 23, 2018, 4:07 pm

I am sure that I have done this before - but I can't remember how, and now I can't get it to work!

I have a csv file of barcodes, how do I import it into librarything? I.E. what do I label the barcode column on the import CSV?

Many thanks

2kristilabrie
jan 24, 2018, 10:20 am

Sorry for the trouble—you can't import barcodes via .csv import (https://www.librarything.com/import) at this time. Generally, our import is due for a revamp (particularly closing the import-export loop on LT), and I'm sure other members will chime in to agree.

In the meantime, I'm unsure how many barcodes you need to import/if this helps, but you can import custom call numbers, if you follow our sample .csv file on our Universal Import page above. Importing your barcodes as custom call numbers could at least get your barcodes into the system for you, and then you could work on moving them over to your "Barcode" field where you want them.

If this sounds like a good option for you, you can check out our Help page on .csv imports for more info: https://wiki.librarything.com/index.php/HelpThing:Import. I hope this helps!

3trl_path
jan 24, 2018, 10:47 am

Thanks - Just to be clear - these aren't my barcodes, rather the one printed on the book - does that make a difference? As I said I am sure that I managed to do this previously.

4.Monkey.
jan 24, 2018, 10:55 am

Are you talking about ISBNs?

5trl_path
jan 24, 2018, 11:02 am

Sorry - Yes I am, have just tested and realised the number generated is an ISBN - Sorry! I didn't have internet connection so I was using Barcode to Sheets on a phone. All sorted, many thanks for the help.

6kristilabrie
Bewerkt: jan 24, 2018, 11:49 am

Ah, gotcha! Sorry for the confusion. Yeah, you can definitely import books based on ISBNs to Universal Import. Glad you're sorted.

7lorannen
jan 24, 2018, 12:23 pm

>5 trl_path: Glad to hear it! Let us know if you run into any further trouble.

8HGC_Library
jan 25, 2022, 5:09 pm

is this still the case? That custom barcodes cannot be imported into my catalog?

9kristilabrie
jan 26, 2022, 9:57 am

With our .csv import, that's correct. If you have MARC records you can map and import custom barcodes to LibraryThing via our MARC Import: https://www.librarything.com/more/importmarc. I hope this helps.

Please let me know if there's anything else I can do to help,

Kristi at LT


10HGC_Library
feb 5, 2022, 1:34 pm

Kristi
Thanks for reply. I've been working with MarcEdit software. I'm hoping that you can help with working with the exported MARC file from LT. It's downloaded as a *.MARC file but the marcedit software works with *.MRK and *MRC files.
when i open my LT MARC export in notepad, it's not formatted like other mrc files.
This is how one record looks in my MARC export:
2200205 i 4500001001000000003000700010005001700017020001500034040002400049090001600073092001100089099000900100100001900109245006600128264002300194300001200217520008800229920001200317923001700329209820471MePoLT20220205125230.0 a1620331195 aMePoLTcMePoLTerda 4aTT848 .P424 4a746.43 a11451 aPatrick, Jane.10aWoven Scarves: 26 Inspired Designs for the Rigid Heddle Loom. 1bInterweave,c2014. a160 p. aWoven Scarves: 26 Inspired Designs for the Rigid Heddle Loom by Jane Patrick (2014) ascarves aYour library00549

11kristilabrie
feb 7, 2022, 12:16 pm

>10 HGC_Library: Let me know if you're still having any trouble! I believe you emailed me to let me know your issue was resolved, but let me know if there's anything else you still need.