Converting a MARC file to Excel with MarcEdit (Export Koha Bibliographic Record .mrc & Convert it into Excel Format)

Steps in Koha

1. In Koha 23.05 Go to CATALOGUING MODULE

2. Click on Export Catalogue Data

3. Export Bibliographic Record of your choice

4. Click on Export Bibliographic Record Button and Save it in your desired place.

Steps in MarcEdit

1. In MarcEdit Go to Tools & Click on Export Tab Delimited Records

2. In Select File Path open your .mrc file and copy the path (Forexample) C:\Users\Dell\Desktop\kohaicp.mrc

3. Paste the Path and just change the .mrc extention into .txt (Forexample) C:\Users\Dell\Desktop\kohaicp.txt

4. Click on Next Button

5. Now add all the required fields one by one which you want to export e.g. select 020 and in subfiled type a and then click on add field and so on....

6. when you finished selecting the required bibliographic data fields the click on export button.

7. then click on ok.

8. Click on close.

Steps in Excel

1. Open Excell software 

2. Browse the exported .txt file it will not be shown by default therefore click on show all files and then select your .txt file

3. Click on Next Button

4. Click on Next Button.

5. Click on Finish Button.

6. Now Click of File and Save As an excel file.

congratulations your .mrc file has been successfully converted to .xlsx file.

...................End.......................

Source: https://www.youtube.com/watch?v=IjiMMsk3S-A

Govt. College University Library OPAC

 

The University of Faisalabad Library

 

How we can attract the Children's towards Library?

Attracting children to the library involves making the library a fun, engaging, and educational space that piques their interest and encourages a love for reading and learning. Here are some strategies to achieve this goal:

Create a Welcoming Environment:

• Design the children's section of the library to be colorful, inviting, and comfortable, with age-appropriate furniture and decorations.
• Display vibrant and appealing posters, artwork, and murals related to children's literature and favorite characters.

Interactive Programs and Activities:

• Organize interactive and engaging programs like storytelling sessions, puppet shows, craft activities, or science demonstrations.
• Host themed events, such as "Superhero Day" or "Space Adventure," to capture their imagination and interest.

Reading Challenges and Contest:

• Launch reading challenges with small rewards or certificates for reaching reading goals. Make it exciting and competitive to encourage participation.
• Hold book-related contests like drawing or writing competitions based on books they've read.

Author Visits and Book Signings:

• Invite children's authors to the library for readings, book signings, and interactive sessions.
• This can inspire children to connect with the authors and appreciate the world of books even more.

Storytime and Book Clubs:

• Conduct regular Storytime sessions for different age groups, where librarians or volunteers read age-appropriate stories to the children.
• Start book clubs for older children where they can discuss books they've read and share their thoughts.

Technology and Multimedia:

• Integrate technology by having interactive e-books, educational games, or storytelling apps available for children to explore.
• Set up computer stations with educational software related to reading, writing, and learning.

Themed Displays and Book Recommendations:

• Create visually appealing displays based on popular themes or seasonal events to showcase recommended books and grab their attention.
• Label books with recommendations or quotes from other children to make them more appealing.

Collaborations with Schools and Teachers:

• Partner with local schools to organize field trips to the library and offer library cards to students, emphasizing the importance of libraries for learning.
• Work with teachers to integrate library visits and reading into the school curriculum.

Parent Involvement:

• Encourage parents to bring their children to the library and participate in programs together.
• Provide resources and workshops for parents on how to encourage reading at home.

Special Events and Celebrations:

• Plan special events for holidays, book launches, or other significant occasions, such as a "Halloween Spooktacular" or a "Summer Reading Kickoff Party."

Flexible Hours and Accessibility:

• Consider extending library hours to accommodate parents' work schedules and offer flexibility for families to visit.

By making the library a fun, interactive, and educational space, you can attract children and cultivate a love for reading and learning from an early age.