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-K... 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@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@adminkuhn.ch <mailto:mik@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@adminkuhn.ch <mailto:mik@adminkuhn.ch> · W www.adminkuhn.ch <http://www.adminkuhn.ch> _______________________________________________ Koha mailing list http://koha-community.org <http://koha-community.org> Koha@lists.katipo.co.nz <mailto:Koha@lists.katipo.co.nz> https://lists.katipo.co.nz/mailman/listinfo/koha <https://lists.katipo.co.nz/mailman/listinfo/koha>