Help needed in importing data from CSV or Excel
Hello I am new to Koha. Before using Koha we used to have an excel file in the following format. bookId, `bookName`, `author` , `totalBooks`, `booksavailable` , `edition`, `pages` , `publisher` , `type` , `cost` Now I would like to import those details into Koha. Is there any way. Please help me. Thanks -- View this message in context: http://koha.1045719.n5.nabble.com/Help-needed-in-importing-data-from-CSV-or-... Sent from the Koha - Discuss mailing list archive at Nabble.com.
you can convert by using markedit , but you have to edit all records because you may miss some features of opac I feel better to enter all details Thank you On Sat, Nov 27, 2010 at 9:07 AM, mailramk <mailramk@yahoo.co.in> wrote:
Hello
I am new to Koha. Before using Koha we used to have an excel file in the following format.
bookId, `bookName`, `author` , `totalBooks`, `booksavailable` , `edition`, `pages` , `publisher` , `type` , `cost`
Now I would like to import those details into Koha. Is there any way. Please help me.
Thanks -- View this message in context: http://koha.1045719.n5.nabble.com/Help-needed-in-importing-data-from-CSV-or-... Sent from the Koha - Discuss mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- ---------------------------------------------- Yatheesh babu Librarian Shri shakti college of Hotelmanagement Venus Plaza Begumpet Hyderabad-500 016 09966178388
Hi, You can use the excellent tool MarcEdit for this. Get it from http://people.oregonstate.edu/~reeset/marcedit/html/index.php This article used to be in the old wiki. Has disappeared in the transfer. Will update there soon, but for now see below.. How to migrate from a delimited text file to Koha : Get a nice CSV file : First get your data organized in MS-Excel. Things we had to watch out for were: date formats to match your Koha / mysql date formats, barcode, itemtype, library branch. We had to add last three to the Excel data. Also watch out for common things like quote, comma, tab marks & any unusual characters in your data. Clean up the data thoroughly. Then save the Excel file as Unicode text. Excel saves as a tab delimited file in Unicode. We need UTF-8. So you need some text editor which can save the file as UTF-8, like EditPlus or Kate (on Linux) Convert with MarcEdit : After you have saved the file as UTF-8 text, start the Delimited Text translation Wizard from the MarcEdit program group. On the second screen give imput and output (i/p and o/p) filenames, leave the delimiter to tab, put text qualifier if any in your text file, click on Edit LDR/008 select LDR dropdown appropriate to your data. Select UTF-8 encoded checkbox. On next screen you have to build a mapping from your Excel file columns to Koha marc tags. Trick is to click in the Select Field 0 drop box and while it is selected type your corresponding marc tag in the map to text box. then click apply. Once you have mapped all columns in your Excel file to Koha marc tags, click on save template so you can reuse it next time you import data in the same Excel format and click finish. It will save your template as a .mrd file and create a .mrk file of your text data. Open the .mrk file in MarcEdit by double clicking it and simply click on the Compile Records button. This will compile all your records and give you a .mrc file. Import to Koha In Koha go to tools – > Stage marc records for import, select your .mrc file set record matching rules needed and click the big button. This will import the data in staging area and take you to a summary page which will have a link to manage the imported records. Click the link select record matching conditions needed and import the staged records in to the database.. Reindex your database by running misc/migration_tools/rebuild_zebra.pl -b -w ( or by running misc/migration_tools/rebuild_nozebra.pl if not using zebra. ) Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2 On Sat, Nov 27, 2010 at 9:07 AM, mailramk <mailramk@yahoo.co.in> wrote:
Hello
I am new to Koha. Before using Koha we used to have an excel file in the following format.
bookId, `bookName`, `author` , `totalBooks`, `booksavailable` , `edition`, `pages` , `publisher` , `type` , `cost`
Now I would like to import those details into Koha. Is there any way. Please help me.
Thanks -- View this message in context: http://koha.1045719.n5.nabble.com/Help-needed-in-importing-data-from-CSV-or-... Sent from the Koha - Discuss mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
Could you please tell me the actual columns with names. That will be very nice of you. And one more question : I dont have a barcode scanner, how to issue a book without barcode scanner? Thanks -- View this message in context: http://koha.1045719.n5.nabble.com/Help-needed-in-importing-data-from-CSV-or-... Sent from the Koha - Discuss mailing list archive at Nabble.com.
can we have our own barcodes entered while importing the marc records. If so could you please explain... Thanks -- View this message in context: http://koha.1045719.n5.nabble.com/Help-needed-in-importing-data-from-CSV-or-... Sent from the Koha - Discuss mailing list archive at Nabble.com.
You put the barcode at 952$p when you create the marc records. If you have the barcodes in your csv file, assign them to 952$p when you are using Marc Edit to create your import file. Bob Birchall CALYX On 27/11/10 21:45, mailramk wrote:
can we have our own barcodes entered while importing the marc records. If so could you please explain...
Thanks
See Home › Administration › Koha to MARC Mapping Tere you will get many of the common MARC mappings used by Koha. For additional MARC info refer to http://www.loc.gov/marc/bibliographic/ While converting your data from excel / csv to MARC using marcedit, you can map your column containing barcode field to the MARC tag 952$p Regards, Koustubha Kale Anant Corporation Contact Details : Address : 103, Armaan Residency, R. W Sawant Road, Nr. Golden Dyes Naka, Thane (w), Maharashtra, India, Pin : 400601. TeleFax : +91-22-21720108, +91-22-21720109 Mobile : +919820715876 Website : http://www.anantcorp.com Blog : http://www.anantcorp.com/blog/?author=2 On Sat, Nov 27, 2010 at 4:15 PM, mailramk <mailramk@yahoo.co.in> wrote:
can we have our own barcodes entered while importing the marc records. If so could you please explain...
Thanks -- View this message in context: http://koha.1045719.n5.nabble.com/Help-needed-in-importing-data-from-CSV-or-... Sent from the Koha - Discuss mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
I created a sample record like this using marcedit. =LDR 00000nam 2200000Ia 45e0 =008 101128s9999\\\\xx\\\\\\\\\\\\000\0\und\d =020 \\$aisbn =245 $aDIGITAL SIGNAL PROCESSING $cOPENHAIM =260 \\$c1999$bPHI PUBLISHERS =300 \\$a580 =952 \\$p0000001 But the koha doesn't import it. What is the problem with my record. -- View this message in context: http://koha.1045719.n5.nabble.com/Help-needed-in-importing-data-from-CSV-or-... Sent from the Koha - Discuss mailing list archive at Nabble.com.
Hello,
I created a sample record like this using marcedit.
=LDR 00000nam 2200000Ia 45e0
=008 101128s9999\\\\xx\\\\\\\\\\\\000\0\und\d
=020 \\$aisbn
=245 $aDIGITAL SIGNAL PROCESSING $cOPENHAIM
=260 \\$c1999$bPHI PUBLISHERS
=300 \\$a580
=952 \\$p0000001
But the koha doesn't import it. What is the problem with my record.
For one your 952 tag is missing the permanent and holding branch information. Usually 952$a and 952$b. What I usually recommend is for you to enter a record through the cataloging module. Then save this record from the OPAC as MARC and have a look at the exported record using marcedit. It gives you a good idea of what tags/fields are required in your Koha setup. I hope this helps Olugbenga Adara Mobile: 234-803-3220288
Also you want to make sure you convert the file from MRK to MRC in MarcEdit when you're done making changes. Finally, this http://koha-community.org/documentation/3-2-manual/?ch=a12205#AEN12208 shows you the 952 record. I doesn't say what's required - which I'm going to add right now. You need the following if you want it to show in the catalog: 952a, 952b, 952y If you want it to circulate you also need a 952p and probably you want a 952o which is the call number. Thanks Nicole C. Engard On Mon, Nov 29, 2010 at 9:10 AM, Olugbenga Adara <gbengaadara@yahoo.com> wrote:
Hello,
I created a sample record like this using marcedit.
=LDR 00000nam 2200000Ia 45e0
=008 101128s9999\\\\xx\\\\\\\\\\\\000\0\und\d
=020 \\$aisbn
=245 $aDIGITAL SIGNAL PROCESSING $cOPENHAIM
=260 \\$c1999$bPHI PUBLISHERS
=300 \\$a580
=952 \\$p0000001
But the koha doesn't import it. What is the problem with my record.
For one your 952 tag is missing the permanent and holding branch information. Usually 952$a and 952$b. What I usually recommend is for you to enter a record through the cataloging module. Then save this record from the OPAC as MARC and have a look at the exported record using marcedit. It gives you a good idea of what tags/fields are required in your Koha setup.
I hope this helps
Olugbenga Adara Mobile: 234-803-3220288
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
The 952y is key! And make sure you use the Koha Code and not your descriptor! Hal Bright, Adult Services Manager Farmington Libraries, 6 Monteith Dr, Farmington, CT 06032 Phone: (860) 673-6791 Fax: (860) 675-7148 <a rel="nofollow" target="_blank" href="mailto:hbright@farmingtonlibraries.org">hbright@farmingtonlibraries.org</a> / <a rel="nofollow" target="_blank" href="mailto:phxmars@yahoo.com">phxmars@yahoo.com</a> ________________________________ From: Nicole Engard <nengard@gmail.com> To: Olugbenga Adara <gbengaadara@yahoo.com> Cc: mailramk <mailramk@yahoo.co.in>; koha@lists.katipo.co.nz Sent: Mon, November 29, 2010 9:27:37 AM Subject: Re: [Koha] Help needed in importing data from CSV or Excel Also you want to make sure you convert the file from MRK to MRC in MarcEdit when you're done making changes. Finally, this http://koha-community.org/documentation/3-2-manual/?ch=a12205#AEN12208 shows you the 952 record. I doesn't say what's required - which I'm going to add right now. You need the following if you want it to show in the catalog: 952a, 952b, 952y If you want it to circulate you also need a 952p and probably you want a 952o which is the call number. Thanks Nicole C. Engard On Mon, Nov 29, 2010 at 9:10 AM, Olugbenga Adara <gbengaadara@yahoo.com> wrote:
Hello,
I created a sample record like this using marcedit.
=LDR  00000nam  2200000Ia 45e0
=008 Â 101128s9999\\\\xx\\\\\\\\\\\\000\0\und\d
=020 Â \\$aisbn
=245 Â $aDIGITAL SIGNAL PROCESSING $cOPENHAIM
=260 Â \\$c1999$bPHI PUBLISHERS
=300 Â \\$a580
=952 Â \\$p0000001
But the koha doesn't import it. Â What is the problem with my record.
For one your 952 tag is missing the permanent and holding branch  information. Usually 952$a and 952$b. What I usually recommend is for  you to enter a record through the cataloging module. Then save this  record from the OPAC as MARC and have a look at the exported record  using marcedit. It gives you a good idea of what tags/fields are  required in your Koha setup.
I hope this helps
 Olugbenga Adara Mobile: 234-803-3220288
_______________________________________________ Koha mailing list  http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
_______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha ¢
Kindly go through this Youtube video http://www.youtube.com/watch?v=Kp_N3ncjS7Q On Sat, Nov 27, 2010 at 9:07 AM, mailramk <mailramk@yahoo.co.in> wrote:
Hello
I am new to Koha. Before using Koha we used to have an excel file in the following format.
bookId, `bookName`, `author` , `totalBooks`, `booksavailable` , `edition`, `pages` , `publisher` , `type` , `cost`
Now I would like to import those details into Koha. Is there any way. Please help me.
Thanks -- View this message in context: http://koha.1045719.n5.nabble.com/Help-needed-in-importing-data-from-CSV-or-... Sent from the Koha - Discuss mailing list archive at Nabble.com. _______________________________________________ Koha mailing list http://koha-community.org Koha@lists.katipo.co.nz http://lists.katipo.co.nz/mailman/listinfo/koha
-- Thanks and Regards Sandeep Bhavsar Librarian Dr.V.N.Bedekar Institute of Management Studies Thane(W) 400601 MUMBAI. INDIA @@@@@@@@@@@@@@@@@@@@@@@@@@ email : sandeep.bhavsar@gmail.com Mob : 9029 345777 elibrary :http://www.vpmthane.org/im/elib/main.htm @@@@@@@@@@@@@@@@@@@@@@@@@@
participants (8)
-
Bob Birchall -
Hal Bright -
Koustubha Kale -
mailramk -
Nicole Engard -
Olugbenga Adara -
SANDEEP BHAVSAR -
Yatheesh Y