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 <m...@adminkuhn.ch
<mailto:m...@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 m...@adminkuhn.ch
<mailto:m...@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>