[Koha] Enquiry

[Michael Kuhn]

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