WiseLib

WiseLib is a physical library management program using SQLite and Winforms

Getting Started

• Install WiseLib and Launch

First Setup

• Follow first setup steps

• Enter your library logo and name

• WiseLib will create a local database and launch

Adding a new member

• You can use "new member" button on top-left or you can add a new member in members in right panel > add new member

• You have to enter your member's name and surname. You can select a photo or use your camera

• After confirming your new member is added and their card is generated, you can print it with print button on bottom-right

• Your member is added succesfully. You can view member details but cannot edit name, surname and photo. So be careful when entering new member

Adding a new book

• Enter books on right-panel, here you can manage your books

• Click add book button and enter your book info

• You can check ISBN with pasting or writing and clicking "check ISBN" button

• You can also get your book info online. WiseLib will use open library api search for fetching info

• After fetching your book info will be filled

• You can add book category just by typing category and confirming book. You can use "unknown" for your unknown category books

• After confirming your book is succesfully added

Lending Book

• Enter your member id

• Confirm your member

• Select your book on right grid

• Click lend button

• And book is lended, book return date will be displayed and your member cannot borrow anymore book untill return

• For returning book type and confirm your member and click "return"

Managing Members

• Click members on your right-panel, here you can manage your members

• Click view or double click on your member for detailed info

• You can quickly create a report for your selected member for any problems

• After confirming member score will be decreased by 1. All members have 3 points default, if you ban member score will drop to -1. Also if a member's credit score drops to -1 it will be banned automatically. You can also edit credit score manually.

• If your selected member has any active reports "view report" button will be displayed

• You can also regenerate member's card

• You can see your member's log. Borrowed and returned books will be displayed here

• You can ban your members for 15 days

Importing Books

• In books section you can import your books from excel file. Here is an example excel file:
• You have to add name, surname and join date. If you add any book borrow info you have to enter all of them

• After you set your excel, click Select File button on bottom-left and select your excel file

• You have to select your columns on comboboxes to preview output

• After clicking preview your output will be displayed on right grid

• Click "Check Members" for checking wheter members are in your database or not

• Click "Add Members" for adding members, empty lines will be skipped. You can see the progress in STATE columns for each row

• After that your members will be added automatically, you check in members section

• Currently imported members do not have any member cards or images, will be ad in future updates

Managing books

• You can use quick searches for quickly seeing overdue/missing etc. books

• In your book details you can quickly create a report for your book's problems

• You can also see your book's log

• You can edit your book's info and set book missing status

Importing Books

• You can also import your books from an excel file. example excel file:

• You need ISBN,TITLE,AUTHOR,PAGE,PUBLISHER,PUBLISH DATE info, you can also add category
• Select your columns from comboboxes and click "preview"

• First check your books, wheter books in excel are in your database or not

• Click "Add Books" for adding all your books from selected excel

• You can get your book covers from open library api search but it may not be accurate

• Images will be added one by one and it may take a while

• After adding all your book, you can check your books in books section

Reporting

• In reports you can manage your reports with details

• You can create a report manually, it will automatically create a report no, so you don't need to enter by hand

• You can also edit a created book and set as "solved"

• In your notifications, you can see your license, overdue members, ending member bans, active reports. More will be added in future

• In history on your right-panel, you can see transaction log, here you can see what you done with details. it may take some time to load. Will be improved in future

• In right-panel you have a green connection button, if it goes red that means your database connection is lost. Here you can manage your connection settings

• You can select a previous database backup freely, but it will delete your current database

More about WiseLib

WiseLib will backup everytime you quit your app and it uses SQLite for quick and simple managing. This is my first devexpress-winforms project and not totally finished yet. Since it's not totally finished you might encounter with some bugs. Some more features will be added in future. You can contribute freely.