Free program for accounting books in the library.

Computerization today affects more and more different industries. Not so long ago, in Ukraine, a decree was issued on the computerization of libraries educational institutions. And everything would be fine, but only, as always, by issuing the appropriate hardware and software no one in the ministries cared. And so it went - let's go ...

Who started creating library databases on a PC using office applications (in Access or Excel), and who began to look for "cracks" to various paid library management systems. However, it turns out that there are quite simple and convenient free programs for this!

Today I will introduce you to one wonderful library management system developed by our fellow countryman and a simple computer science teacher for the needs of his school. This program is called MyLib. With its help, you can quite easily create a database for the entire library and monitor the issuance of books to students, students or teachers. In terms of its capabilities, MyLib resembles the paid Book Accounting program:

Comparison of the MyLib program with a paid analogue Accounting for books

From the comparison, we can see that MyLib is somewhat behind paid applications in terms of functionality. However, the program benefits from a simple and understandable interface organization, and also compensates for some shortcomings due to direct access to the database, which can be easily edited using modern office suites.

An additional nice point is that the application does not require installation :).

In the archive downloaded from our site you will find two versions of MyLib: Russian and Ukrainian. We will consider an example with the Russian version, however, everything written below also applies to the Ukrainian version.

For greater convenience, let's unpack the archive with the required version of the application into a separate folder on the hard drive, and then run the MyLib.exe executable file. The main window of the program will open in front of us:

MyLib Interface

In the main window, we see a list of authors of books (left column) present in our library, as well as a list and description of the books of the selected author (right). At the bottom of the main window, we can also see information about the issue of the selected book. At the top of the MyLib working window there are two additional working tabs (Search and List of students), as well as a button for adding new books.

Working with MyLib

We should start by creating a database of books. To add a new book to the database, just click the "Add new book" button and enter the required information about it in the window that opens:

Unfortunately, this window does not have some fields, such as ISBN, the number of pages, and some others, however, with a special desire, such fields can be manually added to the program database (how to do this,). Of course, you will not get access through the program, however, this method is quite suitable for printing results from the database;).

Click the "Add" button and get the book you just entered in the list:

Please note that if you have several copies of a book, you will have to add them again!

By highlighting a book in the "Author's Books" catalog, you can make changes to its data, as well as give the book to a student or teacher. To do this, just click the "Issue a book" button and enter the reader's data in the text line that appears. The date of issue will be set automatically:

Now, to return the book, it will be enough for us to click the "Accept book" button.

Working with third-party databases

The student has been successfully added, however, for the convenience of working with a large number of people, I would advise creating another reader database. Unfortunately, it is impossible to create such a database using MyLib, but nothing prevents us from filling it directly using MS Access (preferably) or OO Base. To do this, open the folder into which we previously unpacked MyLib and find the data.mdb file:

We will need to open the selected database. For this, the module of the Microsoft Office Access package is best suited. When trying to open a database, Access will ask us whether to block unsafe expressions (to which we proudly answer “NO” :)) and warn us again about the unsafeness of our actions. But we are not afraid :), so we will press the "Open" button and we will see the following window:

It is easy to guess that in order to create a database of readers, we need to open the Pupils table by double-clicking on it with the left mouse button:

In the table that opens, we will first find only two lines. The first will contain the student we created earlier (in the example - Ivanov Ivan Petrovich), and the second will be empty (except for the inscription (Counter) in the first cell).

Now we need to select the line with our first reader (left-clicking on the square in front of the line) and right-clicking the context menu, select the "Copy" item. Now, in a similar way, select an empty line (with the inscription (Counter)) and select the "Insert" item in the context menu.

We will have a copy of the previous record, in which we only need to change the data in the “Name” column to the desired ones. Since MyLib does not have a special field for indicating the class in which the student is studying, it would be best if you indicate the class or group number before the student's name;).

Thus, you can quickly find all your readers in a fairly extensive database. Fortunately, MyLib sorts all entries alphabetically, so you can safely add new library users in any order.

So, we have created a database of readers. It's time to look at the fruits of your labor. To do this, launch MyLib and go to its third tab - "Students and issued books":

Here we will see a well-ordered list of all our readers, and to the right of them a number that indicates the number of books they have taken. If a student returns a book to you, it is enough to highlight him in the list, select the book he returns and click the "Accept" button. The book will again be in the public domain, and it will be possible to give it out again.

Database search

The last function we have to check is the search function. Go to the second tab of the program ("Search for books"):

Here we have two search options: by authors or by book titles. We choose the most suitable for us, fill in the appropriate text field, click the "Search" button and get the result in the list below. Please note that if there is no book corresponding to the specified search parameters in the database, then the list will remain empty, and you will not see any additional notifications.

Advantages and disadvantages of the program

• simple interface and program management;
• unlimited number of records in databases;
• direct access to the main database of the program;
• convenient system for tracking issued books;
• the presence of a convenient mechanism for searching the database of books.

• no built-in reader list editor;
• there is no function to import, export and print data from the program;
• it is not possible to add additional fields to the description of books.

conclusions

Despite the rather significant shortcomings, after skillful “file processing”, the MyLib program becomes an indispensable tool for any librarian! However, you can use the application not only in institutions, but also as a cataloger for your home library.

This use case is generally ideal, since you do not have to manually edit the database at all, and you will add new readers (friends and acquaintances who take books from you) as needed. Using MyLib, you will always know who, when and what books have been taken from you, which means that you will always have your entire library under your supervision.

P.S. It is allowed to freely copy and quote this article, provided that an open active link to the source is indicated and the authorship of Ruslan Tertyshny is preserved.

if (window.ab == true) ( ​​document.write("
The SUNTRSI high-speed MicroSD card will allow you to store a large amount of data on your device for only 320 rubles.
Delivery in Russia - free of charge! "); }

Here we have collected several links to programs for transcoding books from one text format to another, for creating and modifying books, for compiling a home library, and for reading books of various formats on a computer.

Screen readers

• ICE Book Reader FB2, EPUB, PRC, RTF, TXT, HTML, LIT, CHM
  Official website of the program.
• FBReader Supported text formats: EPUB, FB2

Since May 2015, a port of the Android version of the program for Windows has become available. As long as it the only a program for Windows XP and Windows 7 that allows you to download books from OPDS libraries (online catalogs) .

On the official website of the program, you can version the program for Windows 7. The version assembled by amateurs Cool Reader for Windows XP you can download .

All these programs are freely distributed and have a user-friendly interface. Thanks to the ability to select the color of text and background, font size, you can create the most eye-friendly reading mode. Most programs display two pages of a book on the screen at once, with a background image imitating an open book.

Text format converters

If the reader you purchased does not support reading format files FB2, it becomes necessary to convert this format to another one understandable by your device. For Sony Reader, for example, you need a converter program from FB2 in EPUB, and for Amazon Kindle- from FB2MOBI.

• Fb2ePub Converts from FB2 in EPUB
  Official website of the program.
• FB2MOBI Converts from FB2 in MOBI
  Official website of the program.
• FB2 to Any and FB2 to Any Converts from FB2 in txt, rtf, rb and lit and back.
  Official website of the program.

Universal book size converter Hamster free ebook converter completely free. This is a powerful program for interconverting FB2, EPUB, MOBI, TXT, LIT, RLF and some other formats.

The interface of the program is very simple, concise and at the same time beautiful. At the first step of working with the program, you need to select one or more files for conversion, at the next step, you need to select the manufacturer of the e-book and use it for a list of acceptable formats, or immediately select the format for conversion. Next, the process of converting files is shown, after the end, you can either open a folder with finished files, or return to the list and add new book files.

Official site of the program: http://ru.hamstersoft.com.

If the program is not downloaded from the official site, then it can be obtained on the site http://soft-file.ru/

Unfortunately, it is not possible to convert graphics files (DJVu and most PDF documents) to FB2 with a single program. If you nevertheless set yourself such a task, you will first have to recognize the text (using OSR programs), manually correct the errors, and only after that create the FB2 file in the editor.

You can also convert EPUB - FB2 - MOBI (PRC) text formats to each other with the Caliber librarian program described below.

Book editors

Fiction Book Editor- perhaps the most powerful program for creating and editing files FB2. The program provides a text mode for direct editing of a book, inserting titles, images, a code view mode and a mode for editing the information header of a file.
Official website of the program.

Sigl- visual editor of EPUB books. Allows you to compose an EPUB book using only the mouse (selecting, copying, dragging text fragments) and without going into the details of the XML code. The program interface is only in English.
Official website of the program.

Librarians (library managers)

Caliber- a fairly powerful program for creating a home library. It allows you to arrange books by shelves, authors, show duplicates of works of different formats in one item, has a built-in format converter and a book file viewer.
Official website of the program.

MyHomeLib- a program for managing collections of e-books in any format. Allows you to sort books by author or series, read books directly from the program, work with the archives of the Librusek library, convert books from format to format, search for books in the collection by several parameters. The program is absolutely free.
Official website of the program.

MyRuLib- a free (free and open) program for organizing a home library of e-books fb2, epub and other formats. The program can be used to work with network libraries, or cataloging your own collection of files.
Official website of the program.

Another converter librarian with the ability to organize a home OPDS server is freeLib. Discussion of the program and download link is on the forum The-ebook.org

Search system Book Library- a program for downloading and storing books in the home library.

TinyOPDS- OPDS server. The term "OPDS directories" is discussed in the Libraries section. This is a program for creating a home OPDS directory. It scans book files in a certain folder of the disk and arranges them by genres / authors / novelties. It is very convenient to download books to mobile devices and electronic readers with wi-fi support by running the TinyOPDS program on a desktop computer connected to a wi-fi router.

The program is a text corrector.

If you copy text from a web page into a notepad to view later on an e-book, it often contains extra line breaks, spaces, and hyphens.

The program for reading the reader with an abundance of such "garbage" in the text often begins to take individual words within a sentence for chapter headings, placing them in the center of the page. Sometimes even on each page there are only two or four words in bold type. A simple corrector program allows you to remove such "garbage" from the text.

Every user of e-books will someday be interested in the question of structuring or even creating them. electronic library all accumulated publications on your PC or laptop. As an alternative, books can be stored on the reader, but there are a number of limitations: a relatively small amount of memory, a specific interface, and hence the general inconvenience, etc. Especially before getting to the reading room (at least in Russia), the book usually transits through the computer. Accordingly, some kind of program is needed e-library, which would perform all the functions necessary for convenient use of the collection. I will make a reservation that we are talking primarily about creating an orderly home collection e-books and the term "electronic library" is used in a somewhat simplified sense.

The first digital library program that came to mind when writing this article turned out to be the brainchild of a foreign origin, caliber. True, if you translate the description from the site, the definition of caliber is somewhat different: it is a free e-book library management application developed by e-book users for e-book users. All the functionality, the completeness of which made me mention this program in the first place, is divided into 6 main categories.
1) Library management. This includes the establishment of all metadata for the book, incl. tags and comments, search for books, export of the collection to the hard disk in a systematic folder structure. It is interesting that while watching the demo video, I did not notice any hierarchical structure in the program itself. But the selection of books can be easily filtered by metadata, whether it is the author, publisher, tag, or something else.
2) Convert e-book formats
3) Synchronization with e-book readers
4) Downloading news from the Internet and converting them into an e-book format
5) E-book viewer
6) Content server for online access to your book collection
The statistics of the use of the program, given on the site, is amazing. The total number of users is 1646508, of which 2% are from Russia. Such a figure, you will agree, involuntarily impresses. You can watch a demo video, download the program on the official website.

From a foreign one, I would also like to mention Greenstone. However, this is not just a program for creating an electronic library that can be used at home, but a whole platform or framework on the basis of which electronic online libraries are built. Pretty powerful software used by many large organizations different countries peace. It was originally developed with the support of UNESCO and Human info at the Department of Computer Science at the University of Waikato in New Zealand. A complete list of such products can be found on the English wiki in the Digital libray article and the frameworks section. And how this product can be used on your computer is well described in Andrey Fedorov's blog.

For home use, you need something simpler. Consider some Russian developments. MyHomeLib is a program for managing collections of electronic books in any format. It has all the main features of this type of program: a convenient tree view, support for popular formats, simple and complex search, various ratings and reviews, connecting user scripts. Separately, it should be noted that work with the archives of the notorious library Lib.rus.ec has been implemented. You can see screenshots, full description, reviews on the developer's website.

While studying the available information on the topic, I came across an overview of two more programs that can be used to create a collection of an electronic library. They were originally intended to organize the paper home library, i.e. establishments of information about each book. For example, a shelf, a read mark, any other attribute, and so on. By adding the file attachment function, such programs became suitable for working with e-books. They are called BookSnake and Unicat. The review can be read. Of course, for users of readers, such software is of little relevance, but to create a complete collection of all books, both electronic and paper, it is very well suited.

All disassembled products have their own characteristics and perform their own unique functions. I am sure that everyone will be able to find software that satisfies their requirements. If you use any other programs, write in the comments. Feedback on disassembled is also welcome!

Those who read books on a computer or on various mobile devices, for sure, more than once had to deal with the fact that as the number of saved copies increases, it becomes more and more difficult to find the books you need quickly. To solve this problem and sort a large number of e-books, you can create an e-library.

You can create your own library manually, but it is best to use special programs. One such program is the Caliber app.

Before you start working with this program, respectively, you need to install it and, at the initial stage of the installation, specify a place to store the future library.

Then you need to specify the type of device on which e-books will be read. If there are none, then just click the program to cancel.

After the program is installed, you can open it and start creating your e-book library. All books can be stored in one category called "All Books", or they can be divided into genres and other types. To do this, click on the virtual library button in the top menu of the program.

And in the submenu that opens, click on Create a virtual library.

Next, in the new window, in the first line, you need to give the name of the new catalogs, and in the second, specify the tag by which new books will fall into this catalog. Click on the OK button in the lower right corner of the window and get our new library directory.

The created catalog can be filled with various books, this is done simply, click on the add book button and find on the computer the place where our book is stored, select it and click on the open button.

Books can also be added in whole folders, archives, and in other ways, this will be done in the submenu that opens when you click on the arrow next to the "Add book" button

Once a book has been added, it will appear in the All Books section, where you can edit the title, author, publisher, rate, and so on. This is done using the "Edit metadata" button. In the window that opens, we edit the necessary data. All data of the book can be left unchanged, however, in order for the new book to get into the required library directory, in the "Tags" item, enter the same tag as the directory in which you want to place this book. After the tag is added, the book automatically gets into the appropriate library directory.

The book can be read using the Caliber program itself (if the format is supported), this is done using the browse button, or you can open it with another program. In order to find out where the desired book is stored on the computer, you need to select it in the list with the left mouse click, then right-click on it and select the “open folder” submenu. A new window will open where our book is stored and it can be opened for reading by another reader program, such as STDU Viewer. These are not tricky ways and you can create your own library.

Creating a library is not all that Caliber is capable of, besides compiling catalogs and editing book metadata, it also allows you to convert a book to another format with a change in font size and type, metadata and structure, etc. This is done using the "Convert Books" button. Along with the usual way to add books, they can be downloaded from the Internet using the "Download Books" function, where a book can be found by author's name or by title in a list of online stores and other resources. All books contained in the Caliber library can be downloaded directly from the program to a mobile device connected to a computer. To do this, select the desired book in the list with the left mouse click, then right-click on it and select the "Send to device" submenu. Another nice bonus of the program is the ability to receive news from various Internet sites, this is done in the "Collect news" menu.

Distribution: free.
Operating system: Windows XP, Windows Vista, Windows 7, Windows 8, Windows 10.
Interface: Russian.
Program website caliber-ebook.com/download

Site about e-books and tablets

Programs for working with e-books

The program is designed to store e-books in various formats in the electronic library with the ability to read them directly from the program and also convert from format to format (numerous settings allow you to interfere with styles during conversion, integrate custom fonts, etc.). Books are placed in a special library folder, a database of output data is maintained. Additional information about the book can also be downloaded from the Internet by ISBN. Support for multiple book formats including fb2, html, azw, azw1, cbr, cbz, chm, epub, imp, lit, lrf, lrx, mobi, odt, oebzip, opf, pdb, pdf, pml, pmlz, prc, rar, rb, rtf, snb, tpz, txt and zip. Books in many formats can be read directly in Caliber using the included E-book viewer application. It is possible to synchronize the program with a huge list of devices for reading e-books, including all Sony readers.

The program is free. Works under Windows, Mac OS X, Linux. There is a portable version for Windows. Russian interface is present. Download link .

A program for managing collections of e-books in various formats. View and search collections of books in a tree-like list. Work with lists of books sorted by any column. Ability to read fb2, html, doc, txt without installation additional programs(uses included in the distribution program AlReader). MyHomeLib supports fb2 import from folders and zip archives, the ability to work with any type of file. Search by author, book title, series, genre, etc. Export of fb2-books in fb2.zip, txt, lrf format, it is possible to connect e-pub and pdf converters. Support for custom collection formats in xml and inpx format. Working with Lib.rus.ec and Flibusta.net library archives.

This application allows you to convert files from the fb2 format, the most common in Russia, to the ePub format, which understands most e-books from various manufacturers. After installation, the program can work as in the mode command line, and with the help of a graphical shell. Added to the context menu: by right-clicking on a file with an fb2 extension, you can select "convert to ePub", and after a few seconds an ePub file is generated with an entry in the same folder as the source. Russian fonts are integrated by default. Files with Russian-language books are easily read on Sony PRS-T1 and PRS-T2 devices.

The Fb2ePub program is distributed under a "freeware-artistic" license (together with the source code), which means free use and distribution, subject to attribution. The Windows operating system is supported, there are separate versions of the program for 32-bit and 64-bit systems. Russian interface. Download link .

This application can be used to rename, move and transcode fb2 files. Fast recognition of FB2 file metadata. Working with nested directories Support for character/string replacement tables for each profile (for example, for transliteration). Support for an unlimited number of encodings for transcoding files (everything supported by the Windows operating system, from Unicode to KOI8-r, at the user's choice). Renaming genres. Working with fb2 and fb2.zip format files. The most common use of this program is to check the compliance of the fb2 format book that the user has for compliance with the standard (fb2 validation).

The program is designed to work with the Windows operating system, the Russian interface is present. The FB2Toolbox program is free. Download link .

Allows you to create pdf documents from almost any Windows programs(any graphic and text editors, any database management systems, any browsers, any scientific and system programs, etc.). The main thing is that the program menu has the ability to print a document. The program is convenient to use for converting to pdf from any other format. To convert, it is enough to select Bullzip Free PDF Printer in the proposed list of printers when sending a document for printing (or mark it as the default printer in the system, then you do not need to select anything).

Absolutely correct work with Cyrillic. Depending on the settings, the application allows you to write pdf documents to one file or to different ones. It is possible to view the document immediately after its generation. Convenient graphical interface for settings. A large number of various settings: text resolution, image quality, print area size (virtual sheet of paper), it is possible to protect received documents with a password, 128-bit encryption. You can specify transparency, add watermarks. In addition to pdf, you can create files in graphic formats bmp, jpg, pcx, png, tiff. Convenient application of the program - converting doc files and others to pdf format with setting the parameters corresponding to the screen of the Sony PRS-1, PRS-T2 e-book and any other that understands this format.

Bullzip Free PDF Printer is running operating system Windows (including the 64-bit version), there is a Russian interface. The program is free. Download link .

Program for creating and editing fb2 files. There is access to editing the text of the book and the information header of the file, the ability to insert headers, images. There is a code view mode. Fiction Book Editor on Windows Vista and Windows 7 requires MSXML 4.0 pre-installed. The graphical interface of the application is a working window, in the upper part of which there is a standard menu and a toolbar. Below them is a working panel, with which you can assign labels to book elements, as well as make links and footnotes. Most of the working window is occupied by the main text editing window, in which you can work in one of three modes: description editing, book text editing (WYSIWYG - all formatting is displayed), source mode (access to all tags and file structure). At the bottom is a message line that displays the structure of the currently edited element or validator message.

Program for creating and editing electronic books in ePub format. Working with the program is visually intuitive, the user does not need knowledge of ePub and XML formats. Full support for UTF-8 encoding and the EPUB 2 standard is provided. Sigil has a user-friendly graphical interface that allows you to work in visual book editing mode and in code mode. It is possible to validate the file being edited (verifies compliance with the ePub standard) using the built-in FlightCrew EPUB validator application.

If you know of other programs that you are used to using when working with e-books, write to us about it. We plan to replenish this section with interesting, free Russian-language programs in the future.

Asking a question for the first time? Read How to ask the right question. Be sure to include the model name, firmware version, application package name and version. Describe what actions led to incorrect work devices.