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, <[email protected]> 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 [email protected] · 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 <[email protected] > > <mailto:[email protected]>> 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 [email protected] > > <mailto:[email protected]> · W www.adminkuhn.ch < > http://www.adminkuhn.ch> > > _______________________________________________ > > Koha mailing list http://koha-community.org < > http://koha-community.org> > > [email protected] <mailto:[email protected]> > > https://lists.katipo.co.nz/mailman/listinfo/koha > > <https://lists.katipo.co.nz/mailman/listinfo/koha> > > > > > _______________________________________________ Koha mailing list http://koha-community.org [email protected] Unsubscribe: https://lists.katipo.co.nz/mailman/listinfo/koha
