Sharing Librarian

Thursday, 7 September 2017

Google Drive offers the facility to embed your PDF document in any Blogger post or webpage. You need to upload your PDF file to Google Drive and share the document publicly.
The PDF File provides an HTML code to embed the file in your blogger post.

How to Embed the File

Sign in to your Google Drive and upload the file

Enable file sharing and select Anyone with the link can view option

Double click the file to open it. File will be opened in preview mode. Click on the More options icon (the three dots icon on the right hand side of Google Drive) and select Open in New Window.

You can also paste the sharing link in the address bar to open the file in new window.

Now you can see the option Embed item... under the More Options icon.

Click on Embed Item option and a popup window will provide you with the code to embed the file in any webpage or blog post

Select the HTML code and copy it.

In the Blogger post window, click on the HTML tab

Right-click in the Blogger post window and then click "Paste" to paste the HTML code.

Wednesday, 8 February 2017

Recently we had to convert all text in an excel file containing a list of books to uppercase. Here is an Excel macro to get this work done quickly.

Copy the code given below

Sub AllTextToUpper() Dim myRng As Range Dim celRng As Range On Error Resume Next Set myRng= Cells.SpecialCells(xlCellTypeConstants, 2) For Each celRng In myRng celRng.Value = UCase(celRng.Value) Next celRng End Sub

Open the Excel file and press Alt+F11 (Hold Alt key and then press F11). This will bring up Miscrosoft VBA editor. Paste the above code as shown in the image below.

Close VBA Editor and come back to Excel (Or press Alt+F11 again)

Now Press Alt+F8 (or Click View->Macros->View Macros). The following dialog box will be visible.

Anyflip.com provides you a free flipbook publishing platform to convert your PDF into an interactive, realistic Flash & HTML5 flipbook in minutes. It has got a free version and a pro version. The free version have certain limitations, but you will be able to create the flipbooks and publish them online free.

Now, let us see how to create a flipbook and to publish it on a blogger post.

Visit http://anyflip.com and click on Create Account or you may login with your Google or Facebook account

Once logged int, click on Quick Upload

Click on image to enlarge

In the select version, select Flash and click OK

Next, click on Upload your PDF button and select the PDF file (Your PDF must be less than 150 MB). You can add/modify the title, description, keywords and category here. Permission to download file and adding labels are available only for PRO version.

You may also select a template from the Template tab, add toolbar and set the flash display settings on the Advanced Tab

Depending on the file size uploading and converting may take some time, so please be patient.

Once finished converting, your flipbook will be displayed as in the image below.

Click on the Embed button and you will be presented with four options - IFrame Embed, Lightbox Embed, Button Embed and Text Link. Click on IFrame Embed tab, if it is not already selected and set the size of the frame below.

Now select and copy the code

Embed the Flipbook in Blogger Post

Login to Blogger account and click on New Post

Click on HTML button below the Post Title

Paste the code copied from Anyflip inside the body and click on Publish button to publish the post.

Saturday, 4 February 2017

Library Automation - School Library Management Software

Effective management and utilisation of the library resources in an School Library requires incorporation of modern technologies as the Librarian alone has to do all the tasks in the library. This always causes delays in assisting the students to get the information they require as well as circulation of books to maximum number students in library periods alloted to the classes.

To facilitate the effective use of books the School Library has started computerisation with the Library Management Software developed in house by the Librarian. The software provides facilities for catalogue search, circulation of books and magazines, reservation of books, reports, class library management, fine collection, library statistics etc. Reports on the books issued, reservation status, search book by member and accession number, book suggestion and selection, budget expenditure and more for KV Libraries are available.

All the library resources are barcoded. Access to OPAC is provided through library websites (Intranet and Internet).

If you would like to try this free software for your library, you may download it from the link given below.

Snapshots of Library Software

Data Entry for Books

Circulation of Books

Issued Books Report

The library management software is free and may be downloaded from the link below.

Wednesday, 16 March 2016

Unit.1. Library as an Social Institution
- Social & Historical foundations of Library.
- Different types of libraries- Academic, Public, Special –their distinguishing features and functions.
- Role of U.G.C. for development of Academic libraries.
- Role in Library of formal and informal education.
Shivaji University, Kolhapur

Unit.2 Normative Principles of Lib. & Inf. Science
- Five Laws of Library Science.
- Implications of five laws in Lib. & Inf. Science
- Development of Libraries with special reference to India, Baroda
Public Library system
- Library Co-operation Resource Sharing and Library Networking.