e-Granthalaya is a library automation software from National Informatics Centre, Department of Electronics & Information Technology, Ministry of Communications and Information Technology, Government of India. The software has been designed by a team of experts from software as well as Library and Information Science discipline. Using this software the libraries can automate in-house activities as well as user services. The software can be implemented either in stand-alone or in client-server mode where database and WebOPAC are installed on the server PC while the data entry program is installed on client PCs. The software provides LOCAL/LAN/WAN based data entry solutions for a cluster of libraries where a centralized database can be created with Union Catalog output. The software provides Web OPAC interface to publish the library catalog over Internet/Intranet. The software runs on Windows paltform Only, UNICODE Compliant ,thus, supports data entry in local language..
e-Granthalaya was started as an in-house project at ‘Karnataka State Centre of NIC,Bangalore’ and first version of the software was designed for the Public Libraries in the State. Later, NIC HQs ‘Library and Informatics Services Division’ took over the designing of the software where library professionals were involved in the designing process and, thus, improved the software with enhanced user interface and simplify the work-flow of library functions so that it can suit to all kinds of libraries. Following table shows the release of various versions of the software:
For Stand-Alone Mode (All the Components to be installed on a Single PC):
Hardware: P IV or above with backup device, Min 1 GB RAM, 40GB HDD
OS: Windows XP(SP2)/Vista/win 7/8
DBMS: MS SQL Server 2005/2008/R2/2012 (Express Ed) – FREE
Connectivity: LAN/Internet Connectivity
For Clietn-Server Mode:
Hardware: A Server Pc with Min 4GB RAM, 80GB HDD
OS: Windows Client OS (Win 7/8) or Windows Server 2008/R2/2012 (Standard/Enterprise Edition)
RDBMS: MS SQL Server 2005/2008/R2/2012 (Express Edition/Standard Edition)
Connectivity: LAN/Internet Connectivity
BarCode Printer (Any Model/Make) with Barcode Reader
e-Granthalaya 3.0 contains following components, some of these are installed in the Server PC while rest of these are installed in the Client PCs:
1. Database (MS SQL Server 2005/2008/R2/2012) – on Server PC (Windows xp/7/8/Server 2003/Server 2008/Latest)
2. Web OPAC – on Server PC
3. Data entry program – on client PCs
The software is provided at zero cost to the Ministries/Departments of Central Government and State Government and Centre of Excellence under Direct Control of Government. The support, training, Data Entry, Maintenance, Migration, etc are provided on Payment basis by the NICSIEmapnelment Agency. Government Libraries Hosting may also be done in NIC Server as per NIC hosting policy.
How to get the Software
The e-Granthalaya software can be get from any District/State Centres of NIC or from NIC Hqs, New Delhi by sending one official letter on letter head duly signed by Authority along with duly filled request form. The Request Form can be downloaded from here…
Runs on Windows Platform Only (Win XP/vista/7/8/Server 2003/2008)
2. M/s/ Total IT Solutions Pvt Ltd, WZ 248, Plot No.7, Inder Puri, New Delhi-12. Ph. 011-25836316. Contact: Ms Puja Mitra (09350277031). firstname.lastname@example.org
Ram Kumar Matoria
Problems with Solutions
1.Question: sir my question is how to generate OPAC. Plz tell step wise.
1.Posted Answer: Write word OPAC in alias field then give path of the folder change the setting from default apppool to classic.netapppool andthen click OK button. If still you have any doubt there is eg3 installation guide on this website which is very much clear.You can download that
2.Posted Answer: Go to control panel, click on programmes and features cliick on turn windows features on or off extend intenet information services and check all the options except cgi and then click on ok. Now restart you computer and copy eg3OPAC folder in c drive which is given in cd or download from the website.Now click on control panel click on administrative tools and then click on Internet information services manager extend the compure in left window pane, Right clickon default website and clickon add application a new window will open write OPAC in Alias, click on select button and select Classic.Net Apppool and then select the path of web OPAC folder which you have copied in c drive or whrere ever you have copied the folder and then click on ok. Now write http://localhost/opac in internet explorer address bar and click on ok.
3.Question: sir my question is how to delete the membership record of a particular member from circulation. I tried to delete by using delete button but software show a massage that u can not delete this record as the value is saved with circulation and acquisition table.What is the meaning of this massage and how to delete record of a student or member.
2.Posted Answer: First you go to circulation transaction module and delete all the transaction of that particular member and then you can delete that member record from member registration module.
4.Question: Sir, There should be provision of withdrawl Register as and when we change the status of a copy as written of it should be removed from main module and it should also not refelect in status bar or any type of search result also.
3.Posted Answer: Dear Sir, We will make this change in the next version soon – Once books are withdrawn/weed out then bookx will not be visible in OPAC, however, records will not be deleted from database and thus will be visible in Data Entry Interface to the librarian as some times some details may be required for such books from admin point of view
5.Question: dear sir,the computer i was using e-granthalaya is now formated,i want to reinstall e-granthlaya but message displaying “the current system does not meet the minimum hardware requirement for the SQL server release.See the reade me file SQL server Book online”release
4.Posted Answer: Dear Sir, In case ur OS is Windows XP then apply SP2/SP3 – Then u can try installation of SQL Server. How to install SQL Server 2005 – Plz read guide from this site.
6.Question: Respected Sir, some students passed in class XII, or TC issued. I mentioned it in member registration module. My problem is this that when I want to take class wise list, these names are reflecting. Sir in my opinion there should be provision to send these name in separate module.
Posted Answer: After giving TC – u need to CLOSE the membership of those students just selecting CLOSED from status drop-down – update these records.
7.Question: When we get approval in file for many journals to be subscribed, the approval no is same. Not able to update more journals in the same app no and it says the app no already exist. how to add more journals in the same app no
5.Posted Answer: Once u process the Approval No then same approval no can not be used for other journal titles. U must use the same approval no for adding many titles before processing it.
8.Question: Can you provide a eBOOK uploading (pdf full ebook) facility in micro document section.
6.Posted Answer: u can upload pdf file chapter wise in Micro-documents, however, now u can upload full pdf file of each book in the OPAC directly creating a Folder with the CAT NO name. For details, plz contact us as this utiltiy is not included so far in user manual. however, in the next version, we hv given this facility in better way
9.uestion: Sir, eG3 LAN client rev.26 e Book facility available?
7.Posted Answer: yes – it is there in the OPAC. plz contact us for details as this portion is not included in User Manual. This facility is added recently.
10.Question: Sir, In the th ADMIN module under Master Data Library Details if we have accidentally added another library, How can we delete it. In our software we have one main library and one more is accidentally added, it is not being displayed in the software, only one ID is displayed, but in WEBOPAC two libraries are displayed. Kindly guide how to delete another one.
8.Posted Answer: U can delete it from database only by Database administrator. give me remote access of ur pc to me.
Ram Kumar Matoria, posted answer on e-Granthalaya Discussion Forum !
9.Question: Respected Sir, Im using e-Granthala software, now i want to take bar code through this software so kindly tell me which type of printer and bar coder best for us tell me the name of some printer & barcoder, Eg: Laserjet, Hp etc
10.Posted Answer: Dear Friend, U can generate barcode labels either from Laser Printer or u can purchase Barcode Printer. In case u purchases
11.Question: The SQL Server service failed to start. For more information, see the SQL Server Books Online topics, “How to: View SQL Server 2005 Setup Log Files” and “Starting SQL Server Manually.” What this error is Sir Ji.
Posted Answer: It indicates that ur SQL Server Services are corrupted. just try once more – go to START >> ALL PROGRAMS >>Microsoft SQL Server 2005 >> Configuration Tools >> SQL Server Configuration Manager. A new windows will appear – click SQL Services – and right click stopped service and click option – START. in case it does not start then only way is to re-install MS SQL Server again and restore ur database from last backup. before doing anything plz read last chapter of User Manual – Troubleshooting.
12.Ram Kumar Matoria, posted answer on e-Granthalaya Discussion Forum !
Question: Respected sir.i formatted my computer and installed window 2007 again…i have backup of all my records in egranthalya.so kindly tell me the all process of installing egranthalya oftwarwe form cd and also how to restore backup..its urgent i have annual inspection in this week..plz tell step wise and in simple words.
Posted Answer: first install MS SQL Servr in ur pc from e-Granthalaya then restore ur GRANTH3 database with ur backup as per the steps given in a separate guide from cd/web site How to create and restore database ? then install eg3 client program and set db connectivity. in case any help is required plz give us remote access of ur pc by installing AMMYY Admin from google.com .
13.Question: Sir, Is there any option of data entry from excel file to direct e granthalaya database
Posted Answer: yes – u can use a migration program avialable at http://egranthalaya.nic.in – download it and install it in ur pc and use it as per guide available there.
14.Question: Res. Sir, How can i send reminder to users via e-mail or mobile msg
Posted Answer: u need to integrate MS Office Outlook with ur gmail account – as steps given in user manual. once ur mail accout is set proeprly in Outlook – then eGranthalaya will send mail automatically through ur sintegrated account.
15.Question: Ram kumar Sir, In the continuation of your query.. (1)Same accession is available at library (2) Also same 3 title is in th elibrary (2) Same accessin no is uploaded through your migration tool, can you guide me how can delete particular accesion no with all details
Posted Answer: As Mandakini ji wrote – in case u wish to delete only acc.no – it means u wish to delete copy/holding record – just display the catalog record either in retro or full cataloging – go to the holdings part (if full cataloging) – then press delete button. U r trying to delete catalog record directly – first delete copy record then u can delete catalog record
16.Question: Ram kumar Sir, In the continuation of your query.. (1)Same accession is available at library (2) Also same 3 title is in th elibrary (2) Same accessin no is uploaded through your migration tool, can you guide me how can delete particular accesion no with all details
Posted Answer: In case accession no belongs to two differenct libraries in the same database then u can delete individual copy after login with different library. If one library deletes its copy but another library does not delete its copy of the same title – then u cant delete the TITLE record. in eG3 – if more than one libraries are participating in the same database then u need to delete copies of the same titles from the account of all libraries.
17.Question: Res. Sir, Can I Send Reminder through SMS Service? As well as When i trying to send sms alert through NIC Server the message come “Unable to connect to the remote Server” Pl. guide me. Thanking u
18.Posted Answer: Dear Sir, U can not send remider through SMS in eG3. We will make this provision in eG4. in eG3 u can send alert through SMS during issue/return of the book. For sending alert through sms, u need to pruchase/subscribe sms service from sms provider and can send the sms Integration Script to us so that we can integrate it with eG3. u can not use nic sms service.
18.Question: Ram kumar Sir, In the continuation of your query.. (1)Same accession is available at library (2) Also same 3 title is in th elibrary (2) Same accessin no is uploaded through your migration tool, can you guide me how can delete particular accesion no with all details
19.Posted Answer: Dear Shri Matoria Sir & Ms Tripathiji….Thanks your very for valuable guidance. My problem is solved by your fruitfull guidance.
19.Question: In membership registration how to regain closed members? Is it possible to reinstate with same memembership number? when u search with same number result is nil. But if u re-enter same number the profile does not received by eg by saying “number exist”.
Posted Answer: Edit the member record ..select status as current from drop-down, change the closing date of future date – update this record.
20.Question: In circulation transaction Acc. No. field remains dead. If i wish to know a particular Acc. no. how many times issued, to whoms over a period of time then how?. In other word the transaction history sheet of a book
Posted Answer: sir if u want to know issue of a particular acc no then u hv to go circulation transaction and click on the most issued books.it will show how many times the book issued. and if u want to know who is the top borrowers i mean who issued higest no of books then u click on the most borrowers list and click on group by in report in memeber name. u got the member name with details
21.Question: im already work on granthalaya ver 3.0 how download letest ver.&run
Posted Answer: sir now only ver 3 is available if u want to change the latest revision then go to egranthalaya site download the “download latest eg3 lan client program”as per ur pc suitability i mean u have to check ur pc is 32 bit or 64 bit so u download the same revision. after downloading go to control panel and add or remove program. in this feature uninstall the egtanthalaya version. after that u install the new one. it will upgrade automatically.no need to download other things.
22.Question: i am triying to scan the barcode given on the library membership card of students in circulation section (issue/return) but it is not working …. it is difficult for us to do it manually and alll of the books though barcode are sacnned through barcode scanner but membership card cant be scanned plzz…. suggest????
Posted Answer: take mem b.c. from laser print option class wise, it will read. otherwise u mention here how u takes bc prints. befitting answer shall available.
23.Question: In circulation transaction Acc. No. field remains dead. If i wish to know a particular Acc. no. how many times issued, to whoms over a period of time then how?. In other word the transaction history sheet of a book
Posted Answer: Dear Madam, yes, whos available but it lacks the details of whens(ie dates)hopes next version of eG this may available.
24.Ram Kumar Matoria, posted answer on e-Granthalaya Discussion Forum !
Question: we have SQL 2008r.2 for our data base . Q.1-The module “Holding search” is not functioning . Even after installing revision (from 23) to 26. Any suggestion to get the list generated from Module-Holding search. Q.2 I need list from each row(stack) latest books(Yr) and earliest (yr) books? Any solution? Also I would like to link collection of two libraries to e_granthalaya (NIC-Web)(Gokhale Instituteof Publica librariy and The mythic society library.Total collection comes to 90000 books
Posted Answer: 1. Plz send ur mail so that I can send u one sql script to run in ur sql server – then holding search will work fine. 2. u can get list by Location-wise (almirah – wise) in many forms of SEARCH module including HOLDINGS Search alos. Always use option from Group By in Report where u can print same lsit by many fields. 3. Plz send ur backup to upload ur catalog on nic site.
25.Ram Kumar Matoria, posted answer on e-Granthalaya Discussion Forum !
Question: Sir, Thanks a lot for provide a eG3 for 64bits laptop. Sir, as per your guidelines for installation, eg3 is installed but database is is not connected. Show a error ” connection is failed” so how can solve the problem. I want to make a new server in laptop. can you guide me please.
Posted Answer: 1. First check whether SQL Server was installed properly in Mixed mode of Authentiation with (SQL Authentication) SA Password. 2. then Restore database manually if not already done. 3. Create database login/pw In case u fail to do above tasks then give remote access of ur pc by AMMYY Admin 3.5
26.Question: I have installed webopac in our server and was working for a week. But now we are getting message as 404-file or director not found. Pls advise.
Posted Answer: Dear Sir, If ur OPAC was working well last week and now not working – it means some settings may be modified by u. Error 404 means that u r giving wrong URL / physical path of the OPAC folder. Plz give me remote access of ur PC to check the issue.-3/30/2015
27.Question: sir my web opac not restore new data or information …not upload data…how can i restore data any other method
Posted Answer: Dear Sir, I did not understand what u say – “my web OPAC not restore new data or information…”? Plz elaborate ur problem in detail so that we can suggest solution accordingly. OPAC is always connected with read/live database and thus what records u will upload/update will be reflected over OPAC
28.Question: Sir, Database restore or database upload system in eG3, Shall make a very user friendly in eG4 version. Because that eG3 is very user friendly with all menus, only database restore is very complicated, We are trying so many time for database restore as per your user guidance but we got a error, so please make its very friendly in eG4 version.
Posted Answer: Dear Suresh, Plz give me remote access of ur Pc to restore the DB if u wish. Use AMMYY Admin for remote access.
29.Question: Sir, Database restore or database upload system in eG3, Shall make a very user friendly in eG4 version. Because that eG3 is very user friendly with all menus, only database restore is very complicated, We are trying so many time for database restore as per your user guidance but we got a error, so please make its very friendly in eG4 version.
Posted Answer: Dear Frnd, In case u r getting error during restoring of database tehn it does not mean that ther is problem in the program itself, it may be due to 1). u dont hav understanding how to restore db? b). may be problem in ur pc c). may not be haing full permission, etc. however, we system is ok and u follow the steps given it is easier to restore db. Also, database restore is a process of MS SQL server and not related with eG3. We hv given small utility in 3eg3 to simplify restore facility. In case u r still getting error then plz give me remote access of ur pc I will do it. on 2/20/2015 1:27:53 PM
30.Question: Sir, During data migration…from excel to eG3….In language column…what we write in language field, Language ID, Language CODE or Name of Language…Pl guide me
Posted Answer: You can write Language Code e.g. ENG / HIN / see full list in ISO: 639 from net or from e-Granthalaya CD. on 6/10/2015 9:44:52 AM.
31.Question: Sir, What can i do for downloading eg4?
Posted Answer: Dear Sir, eG4 is under Testing for two months and once it is clear then eG4 will be implemented. 1.) eG4 will only be available in NIC Cloud for online access so every user needs to have net connectivity in library 2. Existing users of eG3 will also be ported in phased manner to NIC Cloud for which a migration program will be added soon. on 6/1/2015 9:47:33 AM
32.Question: we have SQL 2008r.2 for our data base . Q.1-The module “Holding search” is not functioning . Even after installing revision (from 23) to 26. Any suggestion to get the list generated from Module-Holding search. Q.2 I need list from each row(stack) latest books(Yr) and earliest (yr) books? Any solution? Also I would like to link collection of two libraries to e_granthalaya (NIC-Web)(Gokhale Instituteof Publica librariy and The mythic society library.Total collection comes to 90000 books
Posted Answer: Hi, if you lost password, you may check out if http://www.recoverlostpassword.com can help with you.
33.Question: What is the Systems Requirement for e-Granthalaya version 4.0
Posted Answer: eG4 is not for local implementation. It is being implemented in NIC Cloud and u need to access it online so u need to have desktop with internet connectivity only.
34.Question: Respected Sir, I am using gGranthalaya from last 3 years and it was working very smoothly. But today it was not being start. It shows some database connection error. I have try so much but couldnt repair it. So I am writing you to kindly give me the solution for the same. I have attached the screen shots of the error in jpeg format for your kind information. Please give your valuable guideline to solve this problem
Posted Answer: 1. Firs of all, you must have read last chapter of user manual – Troubleshooting where all measures are given in case eG3 is not working. 2. Once Database connection form appears then make sure that the 4 parameters given on the form are correct. Press TEST button – if connection is succeded then SAVE it and run eG3. 3. In case Connection still failure then there may be possibility that ur SQL Server Service may be stopped due to sudden switch off of PC or virus attack – in this case u can give ur PC on remote access to us to re-install the server.