Tag Archives: Tutorials

Showing the username who last updated the bibliographic data in SLiMS

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.

01. db_table_strctr

Go to your slims database and then ‘biblio’ table

02. db_table_add

Add 1 new column at the end of the table

03. db_table_add_clmn

Name the new column as ‘last_update_by’ type ‘VARCHAR’ length 100 (as user real name length is 100 in user table)

04. looks_like_column_biblio_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.

05. Insert value to db

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'].

06. show value from db

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:

07. Final_View

Final View

Thank you.

A.K.M. Nurul Alam (Apu)
Dhaka, Bangladesh.

Advertisements