[Koha] Enquiry

[Michael Kuhn]

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 · W www.adminkuhn.ch