Importing call numbers?
Join LibraryThing to post.
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?
Not liking an answer doesn't mean you'll get a different one if you ask a second time.
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.
It doesn't matter if you post in a different place, it's the same site with the same answers.
But he might reach different users in a different talk group, and those others might have answers the first bunch didn't?
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.
>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.
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!
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?
>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.
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.
Excellent! I'm glad you were able to sort it out and get your call numbers imported. Happy to help.
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?
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.
This group does not accept members.
This topic is not marked as primarily about any work, author or other topic.