Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Update page to show required permission to access the admin pages of the Library tool

...

Code Block
titleAdd Library
languagesql
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (1,1,'0002-12-31 07:00:52','0002-12-31 17:00:52',1);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (2,2,'0002-12-31 07:00:52','0002-12-31 17:00:52',1);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (3,3,'0002-12-31 07:00:52','0002-12-31 17:00:52',1);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (4,4,'0002-12-31 07:00:52','0002-12-31 17:00:52',1);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (5,5,'0002-12-31 07:00:52','0002-12-31 17:00:52',1);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (6,6,'0002-12-31 07:00:52','0002-12-31 17:00:52',1);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (7,7,NULL,NULL,1);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (8,8,NULL,NULL,1);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (9,1,'0002-12-31 07:00:52','0002-12-31 17:00:52',2);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (10,2,'0002-12-31 07:00:52','0002-12-31 17:00:52',2);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (11,3,'0002-12-31 07:00:52','0002-12-31 17:00:52',2);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (12,4,'0002-12-31 07:00:52','0002-12-31 17:00:52',2);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (13,5,'0002-12-31 07:00:52','0002-12-31 17:00:52',2);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (14,6,'0002-12-31 07:00:52','0002-12-31 17:00:52',2);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (15,7,NULL,NULL,2);
INSERT INTO LIBRARY_HOUR (ID, DAY_OF_WEEK, FROM_TIME, TO_TIME, HOUR_SET_ID) VALUES (16,8,NULL,NULL,2);

Admin permissions

To be able to edit content in the library tool you will need a user to belong to the LIBRARY_ADMIN group.

The following SQL can be used to add the group to the system (if not already configured)

Code Block
languagesql
INSERT INTO KME_GROUP_T (GROUP_X, GROUP_NM) VALUES ('Library admin permission', "LIBRARY_ADMIN");

Depending on you database it might automatically add the primary key, or you have to manually add a primary key to the script.

You also have to link your user to belong to this group:

Code Block
languagesql
INSERT INTO KME_GROUP_MEMBERSHIP_T (GROUP_ID, USER_ID) VALUES (THE_GROUP_ID, THE_USER_ID);

Replace THE_GROUP_ID with the primary key of the group you created earlier, and replace THE_USER_ID with the ID of your user. Logout and log back in, and you should have access to the admin pages of the library tool.

Localising library names

To localise library names, the name has to be set as a localised property name. At the moment it will mean that your institution will have to configure a localised file which contains the names of those libraries

...