[Koha] Enquiry

[Ah Win]

Thank you, Michael and I have noted about sending to mailing list.
I will read carefully the information and try to process.

I appreciate koha community' s great effort.
Best regards,
Ah Win

On Mon, 28 Feb 2022, 15:10 Michael Kuhn, <mik at adminkuhn.ch> wrote:

> Hi Ah Win
>
> Please always answer to the mailing list.
>
> In my e-mail from 2020 that you are referring to I was talking about
> patron data.
>
> But you are asking about bibliographic data which is a completely
> different thing. You need to convert your (Excel resp. CSV) data to MARC
> or MARCXML before you can load them into your Koha database.
>
> Maybe the following articles will help you:
>
>
> https://kohageek.blogspot.com/2018/12/data-migration-unicode-from-excel-to-Koha.html
>
> https://de.scribd.com/doc/45190252/Data-Migration-Excel-or-CSV-to-MARC
>
> Best wishes: Michael
> --
> Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg. Fachausweis
> Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> T 0041 (0)61 261 55 61 · E mik at adminkuhn.ch · W www.adminkuhn.ch
>
>
>
> Am 28.02.22 um 03:31 schrieb Ah Win:
> > Dear Michael,
> >
> > Greetings from Myanmar!
> >
> > I am a librarian who is trying to use Koha.  I saw your email concerning
> > about excel to koha and I would like to request you to guide us about
> > converting from excel to koha.
> > We have one books list which has only author, title fields in excel and
> > we would like to import to koha. I know that iit is not possible to
> > convert directly.
> > Since you have a very good knowledge  of koha, please guide us for the
> > process.
> >
> > Many thanks in advance.
> > Best regards,
> > Ah Win
> >
> > On Sun, 26 Jan 2020 at 19:51, Michael Kuhn <mik at adminkuhn.ch
> > <mailto:mik at adminkuhn.ch>> wrote:
> >
> >     Hi
> >
> >       > *s their any particular sequence when you fill Excel to import
> into
> >       > Koha*
> >
> >     You cannot use MS Excel files to load data into Koha.
> >
> >     To load user data you can use a CSV file (MS Excel can deal with
> that)
> >     with a structure depending on your Koha version. The respective
> >     struchture you can find in Koha menu "Tools > Import patrons" - on
> the
> >     right side you will find the sentence "Download a starter CSV file
> with
> >     all the columns here." The HERE is clickable and downloading it will
> >     give you the structure valid for Koha 19.11:
> >
> >
>  cardnumber,surname,firstname,title,othernames,initials,streetnumber,streettype,address,address2,city,state,zipcode,country,email,phone,mobile,fax,emailpro,phonepro,B_streetnumber,B_streettype,B_address,B_address2,B_city,B_state,B_zipcode,B_country,B_email,B_phone,dateofbirth,branchcode,categorycode,dateenrolled,dateexpiry,date_renewed,gonenoaddress,lost,debarred,debarredcomment,contactname,contactfirstname,contacttitle,borrowernotes,relationship,sex,password,flags,userid,opacnote,contactnote,sort1,sort2,altcontactfirstname,altcontactsurname,altcontactaddress1,altcontactaddress2,altcontactaddress3,altcontactstate,altcontactzipcode,altcontactcountry,altcontactphone,smsalertnumber,sms_provider_id,privacy,privacy_guarantor_fines,privacy_guarantor_checkouts,checkprevcheckout,updated_on,lastseen,lang,login_attempts,overdrive_auth_token,anonymized,relationship,guarantor_id,guarantor_firstname,guarantor_surname
> >
> >     Be sure to download the correct structure for your own Koha version.
> >
> >     To load title and/or item data you will need original MARC or MARCXML
> >     files. Unlike to CSV MS Excel is not able to deal with them at all.
> >
> >     Hope this helps.
> >
> >     Best wishes: Michael
> >     --
> >     Geschäftsführer · Diplombibliothekar BBS, Informatiker eidg.
> Fachausweis
> >     Admin Kuhn GmbH · Pappelstrasse 20 · 4123 Allschwil · Schweiz
> >     T 0041 (0)61 261 55 61 · E mik at adminkuhn.ch
> >     <mailto:mik at adminkuhn.ch> · W www.adminkuhn.ch <
> http://www.adminkuhn.ch>
> >     _______________________________________________
> >     Koha mailing list http://koha-community.org <
> http://koha-community.org>
> >     Koha at lists.katipo.co.nz <mailto:Koha at lists.katipo.co.nz>
> >     https://lists.katipo.co.nz/mailman/listinfo/koha
> >     <https://lists.katipo.co.nz/mailman/listinfo/koha>
> >
>
>
>