Re: [Koha] to import bulk book details - please advise

2022-07-12 Thread Bruns, Anke
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 1 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  Im Auftrag von edward durai
> Gesendet: Dienstag, 12. Juli 2022 13:27
> An: koha@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  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] to import bulk book details - please advise

2022-07-12 Thread MASTeR Library
How to Book Bibliography Data Convert Excel to MARC format
https://www.youtube.com/watch?v=92bdWN054R0

On Tue, Jul 12, 2022 at 7:13 PM Bruns, Anke  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 1 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  Im Auftrag von edward durai
> > Gesendet: Dienstag, 12. Juli 2022 13:27
> > An: koha@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  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
> ___
>
> Koha mailing list  http://koha-community.org
> Koha@lists.katipo.co.nz
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>


-- 
 Thanking you..

Librarian,
MAMCET 
Trichy-Chennai Trunk Road,
Siruganur, Tiruchirappalli-621 105.
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] to import bulk book details - please advise

2022-07-13 Thread edward durai
its fresh entry. please share if you have excel template to import

On Tue, Jul 12, 2022 at 7:12 PM Bruns, Anke  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 1 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  Im Auftrag von edward durai
> > Gesendet: Dienstag, 12. Juli 2022 13:27
> > An: koha@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  http://koha-community.org
> > Koha@lists.katipo.co.nz
> > Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
>
___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] to import bulk book details - please advise

2022-07-13 Thread Bruns, Anke
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://marcedit.reeset.net/.

 

Anke

 

 

 

Von: edward durai  
Gesendet: Mittwoch, 13. Juli 2022 15:55
An: Bruns, Anke 
Cc: koha@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 mailto:anke.br...@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 1 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  <mailto:koha-boun...@lists.katipo.co.nz> > Im Auftrag von edward durai
> Gesendet: Dienstag, 12. Juli 2022 13:27
> An: koha@lists.katipo.co.nz <mailto:koha@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  http://koha-community.org
> Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> 
> Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha

___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha


Re: [Koha] to import bulk book details - please advise

2022-07-13 Thread 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.k...@medstar.net
202-877-6670
ORCID -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  On Behalf Of Bruns, Anke
Sent: Wednesday, July 13, 2022 10:11 AM
To: edward durai 
Cc: koha@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 
Gesendet: Mittwoch, 13. Juli 2022 15:55
An: Bruns, Anke 
Cc: koha@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 mailto:anke.br...@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 1 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  <mailto:koha-boun...@lists.katipo.co.nz> > Im Auftrag von edward durai
> Gesendet: Dienstag, 12. Juli 2022 13:27
> An: koha@lists.katipo.co.nz <mailto:koha@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@lists.katipo.co.nz 
> <mailto:Koha@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@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.


___

Koha mailing list  http://koha-community.org
Koha@lists.katipo.co.nz
Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha