Administration GUI

Administration GUI of Compliance Checker allows users with administrator privileges to execute the following:

  • Update legislation's Database.

  • Monitor running services.

  • Check default categories and create / edit user defined levels.

  • Search in Database update history.

  • Search in Batch check history.

  • Search in Single check history.

  • Create and edit report templates.

Login

Administration GUI is available after login as administrator on the web GUI of Compliance Checker and clicking on the Administration button in the upper right corner.

images/download/attachments/48673502/adminstart.png

Update legislations

After setting up an update server, users and admins get a warning message when the Knowledge Base version is not up to date:

images/download/attachments/48673502/warning2updateDB.png

Admins can update the legislations from the Administration page by clicking on the images/download/attachments/48673502/updatelegislation_icon.png Update legislations button.
Actual legislations are covered by a rule set and an exclusion set which are sets of special chemical query structures confirming the actually valid relevant legal rules.
The scope of the legal relevancy depends on the scope of the Compliance Checker license you have.

Two ways are provided for the update:

Manual DB update

  • Admins can execute the update by selecting your own jar file containing the appropriate database by clicking on Update to selected file button.

  • Or the Knowledge Base can be updated automatically - if the update server was configured - by clicking on the Download and update to latest version button.

Automatic DB update

  • Automatic update can be configured that monitors if there is a newer update on the update server and updates the Knowledge Base automatically.

images/download/attachments/48673502/dbinfo2.png

System monitor

Click images/download/attachments/48673502/servicemonitor_icon.png to open the System monitor page where you can check the actual status of the system and the running services.

System status

The System status shows the details of the MongoDB, the System user, the Eureka services, the Config service and Settings. There are settings which can be applied only after restart and another group of settings that can be changed on the fly. If the latter settings were changed, they should be reloaded by clicking on the Reload settings from config file button.

images/download/attachments/48673502/systemmonitor_system.png

Available services

Three types of services can be monitored here:

  • cc-backend

  • cc-bigdata

  • cc-web

images/download/attachments/48673502/servicemonitor.png

Check level editor

Click images/download/attachments/48673502/checkleveleditor_icon.png to open the Check level editor page.

This page lists the Available categories in three groups:

    • Countries

    • Groups and associations

    • User defined levels

These Countries and User defined levels will be displayed on the Compliance Checker User Interface in the Regulation categories section as 'Available countries' and as 'Available check levels'.

images/download/attachments/48673502/categorymonitor.png

Default categories

Countries

The displayed 'Countries' are in accordance with your license file.

Here you can check which regulations are included in the individual countries.

You can clone the available countries and the created clone will become a new User defined level.

Editing or deleting 'Countries' is not available.

Groups and associations

The displayed 'Groups and associations' are in accordance with your license file.

Here you can check which regulations are included in each individual group.

You can clone the available 'Groups and associations'. The created clone will be a new User defined level.

Editing or deleting 'Groups and associations' is not available.

User defined levels

'User defined levels' can be created, edited and deleted as well.

    • Create: creates a new level, named and defined by the admin.

    • Edit: opens the Edit level page displaying the actual composition of the selected 'User defined level' and makes possible to make changes.

    • Delete: deletes the selected 'User defined level'.

Create new Level

The Create new level button on the page showing the Available categories opens the Create new Level page.
To narrow the search in the Available rules you can use the Countries & Groups drop-down and/or the Quick search field.

images/download/attachments/48673502/leveleditorcreate.png

Name: enter the name of the new level

ID: unique identifier

Available rules: By default, all the rules are listed here. Two filters are provided to help to select the needed rules for the new level. The set values of these two filters are combined and taken into account with AND logic.

Countries & Groups: one country or group or association can be selected

Quick Search: text filtering is available here

Select all: moves all pre-filtered rules to the right side Selected rules panel

Selected rules: lists the already selected rules

Clear: moves all selected rules back to the left side Available rules panel

Save: saves the new level

Cancel: cancels the creation of the new level

Edit Level

When you click on one of the User defined levels you can check which legislations are included in this definition.

images/download/attachments/48673502/leveleditoreditdelete.png

There are 3 available options: Close, Edit and Delete this level.

Close: Closes this level's drop-down

Edit: Opens the Edit level page displaying the actual composition of the selected User defined level and makes possible to make changes in the selected rules.

After the changes you have to click on the Save button to save these changes. Clicking on the Cancel button or opening another page results in to discarding the changes.

images/download/attachments/48673502/leveleditoredit.png

Delete

To delete the selected User defined level. This has a confirmation pop-up:

images/download/attachments/48673502/leveleditordelete.png

Database update history

Clicking on the images/download/attachments/48673502/dbupdatehistory_icon.png History button on the left navigation bar opens the History page. Selecting the Database update history tab the updates are listed and they can be searched.

The following filters are available to narrow the search:

Legislation code (from-to numbers)

Update date (from-to dates)

Substance ID (from-to numbers)

Legislation name (free text search)

Update type (ADD/UPDATE/DELETE drop-down)

images/download/attachments/48673502/dbupdatehistory.png

This table is sorted by the Substance id and clicking on a line opens the Database update history data popup with the details: Example, Name, Synonyms, CAS#, Legislation, Reference, DEA# and the Query molecule. Titles of modifications are highlighted in red.

images/download/attachments/48673502/dbupdatehistorypopup.png

Batch check history

Clicking on the images/download/attachments/48673502/dbupdatehistory_icon.png History button on the left navigation bar opens the History page. Selecting the Batch check history tab the latest Batch checks are listed.
Data of earlier batch checks can be searched and their generated reports can be downloaded.

The following filtering parameters can be set on the input panel to narrow the search:

    • User name

    • File name

    • Upload starting date (from-to dates)

Below that a table of the latest results sorted by their Upload started date. Above the last column the actually displayed row numbers of total are shown.

images/download/attachments/48673502/batchcheckhistory.png

Clicking on a row the Batch check details popup is displayed from where the generated reports can be downloaded.

images/download/attachments/48673502/batchcheckhistorypopup.png

Delete all data of an individual Batch check from the system

The administrator can now delete all (e.g. confdential) data from the system of a user's batch check by clicking on the Delete button - in the Action column - on the Batch check history page. (See above.)

Before the delete operation is started a confirmation dialog is dislplayed:

images/download/attachments/48673502/batchcheckdeleteconfirm.png

This action is irreversible, so all data of an earlier batch check is deleted.

Delete the Batch check history periodically

In the application.properties file the batch.cleanup.scheduler function can be configured to periodically delete the Batch check history, the reports and the uploaded files from the server.

Settings of batch.cleanup.scheduler can be modified according to the following examples:

# Enables to schedule the removal of all batch report related data from the database.
# The value should be a cron-like expression, which extends the usual UN*X definition to include triggers
# on the second as well as minute, hour, day of month, month and day of week.
# Example patterns:
# "0 0 * * * *" = the top of every hour of every day.
# "*/10 * * * * *" = every ten seconds.
# "0 0 8-10 * * *" = 8, 9 and 10 o'clock of every day.
# "0 * 6,19 * * *" = 6:00 AM and 7:00 PM every day.
# "0 0/30 8-10 * * *" = 8:00, 8:30, 9:00, 9:30 and 10 o'clock every day.
# "0 0 9-17 * * MON-FRI" = on the hour nine-to-five weekdays
# "0 0 0 25 12 ?" = every Christmas Day at midnight
 
# batch.cleanup.scheduler=0 0/30 15-17 * * *

Single check history

Clicking on the images/download/attachments/48673502/dbupdatehistory_icon.png History button on the left navigation bar opens the History page. Selecting the Single check history tab the latest Single checks are listed.
Data of earlier single checks can be searched and their generated reports can be downloaded.

The following filtering parameters can be set on the input panel to narrow the search:

    • User name

    • Check date (from-to dates)

images/download/attachments/48673502/singlecheckhistory.png

Clicking on a row the Single check details popup is displayed from where the generated reports can be downloaded.

images/download/attachments/48673502/singlecheckhistorypopup.png

Report template editor

Admins can create and customize Report templates from the Administration page by clicking on the images/download/attachments/48673502/reporttemplate-icon.png Report template button.

The available Report templates are listed on the left side in the Report templates panel.

images/download/attachments/48673502/reporttemplate.png

Selecting a Report template from the list it's content will appear on the right side. The default template can be selected by clicking the Set as default button and will be marked with a checkbox on the Report templates panel.
The templates can be deleted - except the Default template.

New templates can be created by clicking the Create new button and drag-and-drop the required fields from the Available columns to the Selected columns panel.

These are the Available columns:

  • Input #

  • Input molecule image

  • Input molecule source

  • Input data fields

  • Controlled?

  • What is controlled?

  • Legislation

  • Example molecule image

  • Example molecule source

  • Synonyms

  • CAS #

  • DEA #

The order of these columns can be modified also by dragging. After adding a Report template name the template has to be saved. When the new template is saved then it will be listed in the Report templates panel - and the User can select it at the Batch check report generation.

The listed templates can be edited and modified the same way as above. After editing the template it has to be Saved.

images/download/attachments/48673502/reporttemplate-drag.png

When Input molecule source is moved from Available columns to Selected columns then the Input molecule source format can be selected from a dropdown:
MRV/MOL/SMILES/NAME.

images/download/attachments/48673502/inputsourceformatdropdown.png

Before starting a Batch check users can select a template from the Report template dropdown list :

images/download/attachments/48673502/batchcheck-reporttemplate1.png

And also before generating a new report from an earlier Batch check:

images/download/attachments/48673502/batchcheck-reporttemplate2.png

Selection of a Report template is not available for Single check, so the report will be generated according to the default Report template.