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.

Importing call numbers?

Talk about LibraryThing

Join LibraryThing to post.

Oct 22, 2016, 8:23am Top

I am trying to import a large group of records (2300+) with Universal Import, and I have been experimenting with a small batch of books to begin with. I really would like to be able to import our customized call numbers. Has anyone else found a way to do this? Any suggestions?

Oct 22, 2016, 11:36am Top

>1 GenSocHenryClayton: Yesterday, when you asked this, I thought you'd been given an answer, here:


Oct 22, 2016, 2:53pm Top

Ugh, that is not a good solution.

Oct 22, 2016, 2:58pm Top

Not liking an answer doesn't mean you'll get a different one if you ask a second time.

Oct 24, 2016, 6:40am Top

That was uncalled for. I didn't mean to post it in that first forum, so I thought I would try a more appropriate forum. I was hoping someone had come up with a fabulous technical solution, not a time-consuming workaround.

Oct 24, 2016, 7:56am Top

It doesn't matter if you post in a different place, it's the same site with the same answers.

Oct 24, 2016, 11:13am Top

>6 .Monkey.:
But he might reach different users in a different talk group, and those others might have answers the first bunch didn't?

Oct 24, 2016, 11:38am Top

If you ask a technical question, not for opinions, and get told "no that's not a thing," fishing for an answer you like better doesn't really work.

Oct 24, 2016, 1:19pm Top

>1 GenSocHenryClayton: The Recommended Site Improvements group is really for requesting features. It's a fair place to discuss a feature like this, as it doesn't currently exist, but you're right—it's not really a place to look for suggestions on how to do things.

I'm sorry to report that there's currently no way to import call numbers along with your books into LibraryThing. It's certainly on our list of features to add in the long term, but I don't have anything approaching an ETA at this point. Your best bet is going to be either importing them into the Comments or Tags field, as suggested here: https://www.librarything.com/topic/236879#5772333, and then copying them over to Call Number. Alternatively, importing your books first, and then copy/pasting call numbers in directly from a spreadsheet to your library would also work.

I'm sorry I don't have a better solution for you at this point.

Edited: Oct 24, 2016, 1:20pm Top

This message has been deleted by its author.

Oct 24, 2016, 2:33pm Top

It makes no sense to build TinyCat, give us a spot for call numbers, improve the excel import/export, but not make call numbers importable! Tap, tap, tap!

Edited: Nov 6, 2017, 7:51am Top

When you say 'copy call numbers across from tags' do you mean one at a time for all of my 4300 entries.. (double click - copy - cancel - double click - paste - save; 4300 times??!!) That's 1720 wrist actions, 10320 finger actions, and 34400 eye movements! And no doubt days seated at a screen.

Can I copy all of the call numbers over with a single piece of code, in one action?

Nov 6, 2017, 8:47am Top

>12 FHQuakers: If we did have the ability to move tags to call numbers in one action, it would be through "Your books" Power Edit (Help page: https://www.librarything.com/wiki/index.php/HelpThing:Your_Books/Power_Edit). Unfortunately, we don't have that function in Power Edit at this time.

You can now import call numbers with our MARC Import (https://www.librarything.com/topic/267790), but not through Universal Import (yet). — We bring this request up fairly regularly at meetings with developers, and we'll let you know if there's any update on this front. I'm sorry for the inconvenience in the meantime.

Edited: Nov 10, 2017, 5:58pm Top

I managed to populate my call number fields (in one Action); by converting my spreed sheet into a 'marc' file using 'Marc Editor 6' (Opensource I think).

(And then populating Library Thing with a Marc Import)

The process was fairly simple. I followed youtube videos. This help page: http://www.librarything.com/wiki/index.php/HelpThing:MARC_export. (Using the information in there on Marc Tags)

And further information on Marc Tags in the Library of Congress web pages.

Thank you for your help.

Nov 13, 2017, 10:20am Top

Excellent! I'm glad you were able to sort it out and get your call numbers imported. Happy to help.

Mar 28, 12:06am Top

I saw on the Web Service API page that it mentions you can use an HTTP POST, but I didn't see any documentation or Web Service methods for doing a Post. Is it possible to use the Web Services API to post data, and could that be a solution for doing a mass update of the Other Call Number field?

Apr 10, 12:21am Top

Actually, the Universal Import has been updated to include Other Call Number - go to More>Import & Export>Universal Import; download the sample database at the bottom of the right sidebar. Create a CSV file of the books you want to import that matches the sample database, but leave out any ISBNs you have. It will import the books with the data you have in the spreadsheet; if you already have the book (and it notices - it misses, sometimes) it will ask you what to do with duplicates, tell it to add them. The Other Call Number should show up in the book record - it did for me.

I'd advise doing it in relatively small sections (50-100 books at a time) so you can check through them and make sure they came out right. I did a multiple-hundreds import a while ago and I'm still working through it...finding duplicates that didn't end up matched, etc.

Group: Talk about LibraryThing

159,493 messages

This group does not accept members.


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 | 128,999,675 books! | Top bar: Always visible