If we want to know the staff name who last updated the bibliographic data along with date and time, we need to make some changes in SLiMS. The changes are both in database and bibliography module. Let’s see how we can do this…
First we go to our slims database>biblio table. Add a new column at the end of the table biblio. Name it ‘last_update_by’ data type varchar (100) and save.
Go to your slims database and then ‘biblio’ table
Add 1 new column at the end of the table
Name the new column as ‘last_update_by’ type ‘VARCHAR’ length 100 (as user real name length is 100 in user table)
Finally the database looks like
Then go to slims folder …\admin\modules\bibliography\index.php to edit index.php file.
Add $data['last_update_by'] = $_SESSION['realname']; after line 160.
Edit index.php under bibliography folder to insert user real name to database
Edit the line number 688 as follows:
__('Last Updated by:').' '. $rec_d['last_update_by'].' '. __('on:').' '. $rec_d['last_update'].
Edit index.php under bibliography folder to show data from database
Now save the file, go to browser and your slims admin panel>bibliography module.
Edit any bibliographic data first and then go to edit mode again. See the information like below:
Final View
Thank you.
A.K.M. Nurul Alam (Apu)
Dhaka, Bangladesh.
