*s their any particular sequence when you fill Excel to import into Koha* -- Assistant Librarian, Confucius Institute Scholar 13-14, R.D. National College, Bandra (W.)
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 · W www.adminkuhn.ch
participants (2)
-
Himanshu Aggarwal -
Michael Kuhn