Conversion of Excel Datasheets into MARC Records | Koha Batch Cataloging with Multiple Items

[@hassanshahnawaz165]

Excellent way of explaining.

[@rifdex-8]

how do i prepare the excel sheet? i mean any template?

[@RAFLIMTS]

You can simply add a tag in each column of the first row. Like tag 100$a for the author, 245$a for the title, etc. Or share your email here, I'll send the template that I have discussed.

[@mugaioli]

@@RAFLIMTS please send excel format

[@mariteschavez5302]

@@RAFLIMTS Good day. Can we have the copy? Please send us a copy of template for batch import cataloging. Thank you so much.

[@olivajame72]

Thank you so much. Excellent explaining.

[@muhammadyasiriqbal6724]

Thanks for your great help sir. I'm facing an issue to convert Urdu books data of excelsheet into mrc file as well as to import in Koha. Please guide us about it.

[@RAFLIMTS]

Urdu books data similar work as English. You need to care of fields and tags. Use Urdu phonetic. Watch all three videos of the series for more detail.

[@bratatirudra3486]

Sir your youtube tutorial is very helpful to me. I can't understand which tags are fill-up for book & online materials(e-book) and Journals .Can you provide me the excel file?

[@RAFLIMTS]

Thank you for your kind words. After watching following four videos carefully, you will able to work easily kzbin.info/www/bejne/fIOzeIVqhKd7qpI kzbin.info/www/bejne/apLWZXafp7pqgcU kzbin.info/www/bejne/iJOpg6iYiMdprqM kzbin.info/www/bejne/aXSZiKB-hr96osU

[@Missioniastnpsc]

Sir please make video about library in out management system

[@RAFLIMTS]

What to in and out? 😉

[@kunalchakraborty4948]

Is this possible to libsys data base backup file convert in marc file

[@RAFLIMTS]

If you can bring that backup in excel or text then of course.

[@deepansangreal985]

I created marc framework with tags i need ...i don't need few tags so i like to leave empty ..i need to add that field in excel are i can leave it.. i have that empty field in marc framework but i did not add in excel .did i must need or necessary to add thay empty filed in excel

[@RAFLIMTS]

I have discussed the framework in this video, hope it will help you :) kzbin.info/www/bejne/gnPKcoppereIoas

[@RidaDania]

My MarcEdit application has stopped working. It was asking for an update, so I got our IT team to install latest version 7.5, but after I select the Excel file to convert to Marc, the application goes into (not reponding) mode, and hangs up, I have to use task manager to end it. Can you help with what to do about this?

[@RAFLIMTS]

Please give me sometime to let me check. I have no idea right now!

[@RAFLIMTS]

Marcedit 7.5 is working fine, nothing wrong at my end.

[@rehamkaram3866]

our library for primary school only so i have excel datasheets including ( author _ title - barcode ) is it ok to transfer into koha by marcedite ?

[@RAFLIMTS]

Its okay but provide upload with more data to enrich catalog such as ISBN, imprint area, branch, item type, call number, etc. Alternatively you can use copy cataloging in Koha.

[@RAFLIMTS]

kzbin.info/www/bejne/a5fTfpWEhLlkars watch this video for cataloging and copy cataloging in Koha-ILS

[@rehamkaram3866]

@@RAFLIMTS could you plz send to me excel sheet template ?

[@RAFLIMTS]

Please share your email

[@RAFLIMTS]

Please check your email.

[@samrocks10111986]

It will be very grateful if you can share the sample excel file

[@RAFLIMTS]

Sure, please email me or share your email here.

[@deepansangreal985]

I try to upload marc field everything dome correctly but when i try to upload job was in 0% nearly 2 hours even though i have good internet networkfor just 1500 marc data..

[@RAFLIMTS]

I can't say about your system :) Let's open your staff panel in new tab and check Staged MARC record management, sometime front screen stuck however it has completed from back, there you find the correct status of batch such as staging, staged, or imported.

[@deepansangreal985]

@@RAFLIMTS staged completed sir but imported is not happening

[@RAFLIMTS]

click the file name and then import this batch into catalog

[@RAFLIMTS]

Check all three parts for better understanding. kzbin.info/www/bejne/aXSZiKB-hr96osU kzbin.info/www/bejne/iJOpg6iYiMdprqM kzbin.info/www/bejne/apLWZXafp7pqgcU

[@nagarajuk2247]

Same problem i am also facing now about 4000 records staged but only 1928 are imported. How to solve this issue? Remaining records showing as importing status..,.. pls share your opinion

[@jaypeepinpin8899]

where can i get a template of the xls file

[@RAFLIMTS]

I would request to please watch the video carefully and try to create your own spreadsheet. It quite easy

[@jaypeepinpin8899]

@@RAFLIMTS yes thanks, I've research more about it and didn't expect that its easy. anyway thanks :) i learn a lot from you vids. :)

[@rifdex-8]

How do I prepare the excel before doing the 5:06?

[@RAFLIMTS]

I m not getting your question.

[@MsBlacklabel1]

hi, the download link is unavailable, where can i download it

[@RAFLIMTS]

Download link for what?

[@MsBlacklabel1]

@@RAFLIMTS marcedit. Sorry

[@MrsSamia789]

Marc update hogya to kya karyn gy

[@RAFLIMTS]

I think you need to uninstall all versions and then finally install the latest version.

[@MrsSamia789]

Assalamu alaikum

[@RAFLIMTS]

Walikum Salam

[@SeshuCreations2020]

Sir, I converted data but 952$g cost shows seperate item. Each volume shows two items. Cost shows seperate item. What is reason sir

[@RAFLIMTS]

Join the 952 in marcedit

[@RAFLIMTS]

You have missed the item joining before finish the MARC edit

[@SeshuCreations2020]

Thank you very much sir.

[@SeshuCreations2020]

Thank you very much sir. I have watched your video once again. In the video told about join.

[@SeshuCreations2020]

Very detailed explanation in your videos sir .Thank you sir

[@lloydbarja766]

Hi can you send me a copy of the excel thanks

[@RAFLIMTS]

Please email me or drop your email address here.

[@mathemagiciancreator7921]

sind this file please

[@RAFLIMTS]

Please share your email here

[@mathemagiciancreator7921]

[e-mail]

[@RAFLIMTS]

Please check your email