[Koha] to import bulk book details - please advise

[King, Fred]

My colleague Lauren Denny and I are doing a presentation on this very thing at KohaCon in September. For more information, see
   https://koha-us.org/events/conferences/kohacon22/
(We're presenting on Thursday, 22 September, but you need to come for the other presentations, too!)

Fred King, MSLS, AHIP
Medical Librarian, MedStar Washington Hospital Center
fred.king at medstar.net
202-877-6670
ORCID 0000-0001-5266-0279
MedStar Authors Catalog: http://medstarauthors.org

By replacing your morning coffee with green tea you can lose up to 87% of what little joy you still have left in your life.
--Trad

-----Original Message-----
From: Koha <koha-bounces at lists.katipo.co.nz> On Behalf Of Bruns, Anke
Sent: Wednesday, July 13, 2022 10:11 AM
To: edward durai <aedwarddurai at gmail.com>
Cc: koha at lists.katipo.co.nz
Subject: [EXTERNAL] Re: [Koha] to import bulk book details - please advise



**ATTENTION: This email originated from outside the MedStar Health network.
 ** DO NOT CLICK links or attachments unless you recognize the sender and know the content is safe.

 

I use MarcEdit’s Delimited Text Translator to create MARC records from a .csv file exported from Excel. The template depends on what data is in which column of the table, so it has to be created by yourself according to your data. The template can be saved for future uses.

 

https://urldefense.com/v3/__https://marcedit.reeset.net/__;!!D7IIWT94AA!9-PUuvl3WiZKNaEhdCJZliOZ2ZhxxxOci4h9Xx9Ww9CpaFNiNL52QA8sqIyh5nQ2sMQJkeQx7wys9B7pPTE1G0Y$ .

 

Anke

 

 

 

Von: edward durai <aedwarddurai at gmail.com>
Gesendet: Mittwoch, 13. Juli 2022 15:55
An: Bruns, Anke <Anke.Bruns at gwdg.de>
Cc: koha at lists.katipo.co.nz
Betreff: Re: [Koha] to import bulk book details - please advise

 

its fresh entry. please share if you have excel template to import

 

On Tue, Jul 12, 2022 at 7:12 PM Bruns, Anke <Anke.Bruns at gwdg.de <mailto:Anke.Bruns at gwdg.de> > wrote:

Hi Edward,

could you please explain your request a bit more?

Do you explicitly want to import 5000 title records as duplicates of 5000 existing records, so as a result there are 10000 records? Or did you mean import the same data with deduplication in the process, so that the 5000 existing records are overwritten?

What exactly would you like to know about Excel import?

Best regards,
Anke


> -----Ursprüngliche Nachricht-----
> Von: Koha <koha-bounces at lists.katipo.co.nz 
> <mailto:koha-bounces at lists.katipo.co.nz> > Im Auftrag von edward durai
> Gesendet: Dienstag, 12. Juli 2022 13:27
> An: koha at lists.katipo.co.nz <mailto:koha at lists.katipo.co.nz>
> Betreff: [Koha] to import bulk book details - please advise
> 
> Hi Koha Team,
> We Organization has 5000 books. I just wanted to import duplicate 
> entry for
> 5000 books using import excel.
> 
> is it possible? so that we can edit and update whenever we have time.
> 
> is there any other possibility to enter 5000 books quickly?
> 
> thanks,
> edward
> _______________________________________________
> 
> Koha mailing list  
> https://urldefense.com/v3/__http://koha-community.org__;!!D7IIWT94AA!9
> -PUuvl3WiZKNaEhdCJZliOZ2ZhxxxOci4h9Xx9Ww9CpaFNiNL52QA8sqIyh5nQ2sMQJkeQ
> x7wys9B7p8oBFU2o$ Koha at lists.katipo.co.nz 
> <mailto:Koha at lists.katipo.co.nz>
> Unsubscribe: 
> https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/listinf
> o/koha__;!!D7IIWT94AA!9-PUuvl3WiZKNaEhdCJZliOZ2ZhxxxOci4h9Xx9Ww9CpaFNi
> NL52QA8sqIyh5nQ2sMQJkeQx7wys9B7pGS_qN3Q$

_______________________________________________

Koha mailing list  https://urldefense.com/v3/__http://koha-community.org__;!!D7IIWT94AA!9-PUuvl3WiZKNaEhdCJZliOZ2ZhxxxOci4h9Xx9Ww9CpaFNiNL52QA8sqIyh5nQ2sMQJkeQx7wys9B7p8oBFU2o$
Koha at lists.katipo.co.nz
Unsubscribe: https://urldefense.com/v3/__https://lists.katipo.co.nz/mailman/listinfo/koha__;!!D7IIWT94AA!9-PUuvl3WiZKNaEhdCJZliOZ2ZhxxxOci4h9Xx9Ww9CpaFNiNL52QA8sqIyh5nQ2sMQJkeQx7wys9B7pGS_qN3Q$ 

----------------------------------------------------------------------
MedStar Health is a not-for-profit, integrated healthcare delivery system, the largest in Maryland and the Washington, D.C., region. Nationally recognized for clinical quality in heart, orthopedics, cancer and GI.

IMPORTANT: This e-mail (including any attachments) may contain information that is private, confidential, or protected by attorney-client or other privilege. If you received this e-mail in error, please delete it from your system without copying it and notify sender by reply e-mail, so that our records can be corrected... Thank you.

Help conserve valuable resources - only print this email if necessary.