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.

  • 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

When the Knowledge Base version is not up to date then users and the admins get a warning message:

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

You can execute the update by selecting the necessary jar file containing the rule set and the exclusion set, and clicking on Update to selected file button.

Automatic DB update

After setting up an update server, users and admins get a warning message when a new DB version is available.
Admins can update the Knowledge Base automatically by clicking on the Download and update to latest version button.

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 legislations are included in the individual countries.

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

Editing or deleting is not available.

Groups and associations

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

Here you can check which legislations are included in the individual groups and associations.

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

Editing or deleting 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

Selecting the images/download/attachments/48673502/dbupdatehistory_icon.png Database update history button on the left navigation bar the updates 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

Batch check history

Administrators can do a search on all of the finished batch checks.

Clicking on images/download/attachments/48673502/batchcheckhistory_icon.png the Batch check history page is opened where earlier batch check data and their generated reports can be searched.

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

    • User name

    • File name

    • Upload's starting date (from-to dates)

Below that a table of the results in reverse order of 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 Generated batch check reports popup is displayed from where the generated reports can be downloaded.

images/download/attachments/48673502/batchcheckhistoryreport.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. The order of these columns can be modified also by dragging. After adding a Report template name the template has to be saved. After clicking the Save button the new template will be listed in the Report templates panel.

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

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.

Integration API

To check molecules listed in a file against regulations, the Compliance Checker API was developed with three endpoints:

1. <host>/cc-bigdata/filecheck/upload

This is a POST method. It uploads a file containing molecules and creates a job which executes the checks for each structure.
It has four parameters:

- file (mandatory): The file that contains the molecules to be checked.
- categories: Array of category ids which defines the regulations. Leaving it empty results in checking against all regulations.
- date: Should be set in case molecules need to be checked against past regulations. Expected date format is 'yyyyMMdd'. Leaving it empty is the same as setting today's date.
- description (optional): Short description can be provided for the input.

The output elements of the response:

- jobId: The identifier of the job created to process the input file.
- url: The url where the information of the generated job can be requested from.
- description: Constant description message 'Use this ID or the URL to access your job status and information'.

2. - <host>/cc-bigdata/filecheck/job/{id}

This is a POST method. It submits a report generation request for a given job.
It has five parameters:

- id: The id of the job to generate the report for.
- containsErrors: Defines whether the report should contain unsuccessful checks (true/false).
- containsHits: Defines whether the report should contain regulated molecules (true/false).
- containsPasses: Defines whether the report should contain not regulated molecules (true/false).
- formats: Array of requested report formats. Accepted values: PDF, HTML, SDF, MRV, XLSX, JSON.

3. <host>/cc-bigdata/filecheck/job/{id}

This is a GET method. Returns status information about the given job.
It has one parameter:

- id: The id of the job which we would like to get the status information of.

The output elements of the response:

- status: Status of the job. Possible values: FINISHED, PENDING, FAILED, IN_PROGRESS.
- percentage: Percentage of checked molecules.
- inputSize: Number of all molecules.
- hitCount: Number of regulated molecules.
- errorCount: Number of unsuccessful checks.
- passedCount: Number of not regulated molecules.
- reports: An array of reports generated for the given job.

reports has five fields:

- format: Format of the report. Possible values: PDF, HTML, SDF, MRV, XLSX, JSON.
- reportContent: The content of the report that has been selected before generation.
Possible values: 'full', 'hit only', 'certificate only', 'error only', 'result only', 'error and hit', 'error and passed', 'summary only'
- generated: Timestamp of the report generation.
- state: Status of the report. Possible values: FINISHED, PENDING, FAILED, IN_PROGRESS.
- url: Url of the report where it can be downloaded from.

To invoke these endpoints admin privileges are needed.

A Swagger UI for these endpoints is also available at <host>/cc-bigdata/file-api.