Koha Data Migration Marc Ubuntu
16/03/2019

Koha Data Migration | How to Import MARC file into Koha using Terminal

Koha Data Migration is very time consuming process, So you can import you Bibliographic Data into Koha Software by using Terminal Commands In the process of Koha Data Migration, You can import .mrc file into koha directly using Terminal commands. Follow the steps below and run commands one by one carefully: sudo su export PERL5LIB=”/usr/share/koha/lib” export KOHA_CONF=”/etc/koha/sites/library/koha-conf.xml” Next, Move your .mrc file into folder where […]

Koha MySQL phpMyAdmin Ubuntu
16/03/2019

Install phpMyAdmin on Ubuntu

After installing MySql/MariaDB Database Server, You can easily install phpMyAdmin on Ubuntu Machine.Follow the steps below:1. Update the package index and upgrade the system packages to the latest versions:     > sudo apt update     > sudo apt upgrade  (optional)2. Install the phpMyAdmin package     > sudo apt install phpmyadmin3. Choose apache2 by pressing Space Key and then Enter on Keyboard, when a popup screen appears.4. Next, you will be asked […]

Koha MySQL Ubuntu
16/03/2019

Reset Password in MySQL | How to fix Access denied for user ‘root’@’localhost’

Set/Reset Password in MySQL use mysql; SET PASSWORD FOR ‘root’@’localhost’ = PASSWORD(‘newpassword’); OR ALTER USER ‘root’@’localhost’ IDENTIFIED BY ‘newpassword’; OR UPDATE mysql.user SET authentication_string = PASSWORD(‘newpassword’), password_expired = ‘N’ WHERE User = ‘koha_library’ AND Host = ‘localhost’; flush privileges; Mysql(Ubuntu): How to fix Access denied for user ‘root’@’localhost’ sudo mysql -u root use mysql; update user set plugin=’mysql_native_password’ where User=’root’; flush privileges; Koha auto_increment bug […]

General Services Windows
21/01/2019

Install EXE as Windows Service

Follow below steps to install exe as Windows Service. Open Command Prompt as Administrator Run the following command: sc create service_name binpath=C:pathtobinary [option1] [option2] [optionN] Here is an example: sc create RFSERVICE binPath=”D:RFIDMultipleSocketServer.exe” ^ DisplayName=”RFSERVICE” start=auto If this worked you should see: [SC] CreateService SUCCESS You can delete a service by following command: sc delete RFSERVICE

Windows
28/11/2018

Disable Windows 10 Update | Stop Automatic Updates on Windows 10

Are you really want to disable Windows 10 Update Feature? You can stop Windows 10 Update through Group Policy The Group Policy feature is only available in Windows 10 Professional, Enterprise, or Education Editions. You have to use the Group Policy Editor to change the settings to prevent Windows 10 from automatically updating. Follow the below steps and stop updating your windows 10.  1. Press […]

Koha Ubuntu
28/11/2018

How to Install TeamViewer on Ubuntu 18.04/20.04 LTS

TeamViewer is very popular software for Remote Access. You can Install TeamViewer on Ubuntu by following the process below. Open up the Terminal and enter following command: $ sudo apt install gdebi-core Next, download the latest TeamViewer package: $ wget https://download.teamviewer.com/download/linux/teamviewer_amd64.deb Lastly, install the previously downloaded package using below command: $ sudo gdebi teamviewer_amd64.deb Answer y when prompted. The TeamViewer is now installed. Use your start menu to […]

DSpace Ubuntu
16/09/2018

Dspace Installation & Configuration on Ubuntu

Install DSpace 6.x on Ubuntu 16.04 LTS by Vimal Kumar Install DSpace 5.6 on Ubuntu 16.04 LTS by Vimal Kumar Installing DSpace 5.5 on Lubuntu/Ubuntu 14.04 LTS by DKTripathi Install DSpace 5.x on Ubuntu 14.04 LTS by Vimal Kumar

General Windows
07/08/2018

Configure a User Account to Log On Automatically on Windows 7

1. Click Start, type netplwiz, and then press Enter. 2. In the User Accounts dialog box, click the account you want to automatically log on to.If it is available, clear the Users Must Enter A User Name And Password To Use This Computer check box. 3. Click OK.  4. In the Automatically Log On dialog box, enter the user’s password twice and click OK.  The next time you restart the […]

MySQL Windows
17/07/2018

How to Uninstall MySQL from Windows 7/8/10 Completely

Follow the steps to uninstall MySQL Completely from Windows: NOTE: This method will remove/clean all MySQL databases and instances, so keep backup before going through this process, to save your existing databases. 1. First, Run Command Prompt as Administrator and execute the following command to STOP and REMOVE MySQL service. > Net stop MySQL > Sc delete MySQL 2. Now Go to Control Panel >> […]

MS Excel
11/09/2017

Excel: Convert Currency Number to Words/Text

Many times we require to change the Numbers in Words. For Example: 6734862=Sixty Seven Lakhs Thirty Four Thousand Eight Hundred Sixty Two. In Excel, there is no Formula as such to Convert Numbers in Words. I have written one UDF : User Defined Function. After using this Function, you will be able to change any numbers in Words. Now there can be two way of […]