A new Ontoportal administration page (🎄)

[syphax-bouazzouni]

Context

Ontoportal provides an admin page, where an administrator, can go to manage ontologies, users, content(metadata), groups, categories, and now also person & organization.

Issues

Mostly the admin page is used to perform actions such as re-processing a corrupted ontology. Still, it does not provide any information or give any insight into the current state of the portal, helping the administrator know what is happening in his portal and decide the action to perform in consequence.

The paradoxical thing is that we have a lot of data/logs saved in our server, containing a lot of useful information about the usages and errors occurring in a Portal. We have just to find a way to display them.

In January of this year, we tried, to use Newrelic, to help us gather all those logs and have it ingest them to propose us useful dashboard. But until now a year later, we have not used it mostly because you need to go to another website and there is too much information and details making it complex to find things for no expert people.

Same for Google Analytics, mostly also because you need to go to another website to see.

So the ideal solution would be to integrate them directly to our Admin page, we already connect to Google Analytics to fetch ontology visits, so why not also fetch the users visits count and display them by ourselves?

For the logs, we send them to Newrelic but, why not just read them from our servers and display the by ourselves?

Goal

The Goal would be to extend the current admin page, by defining 4-5 key indicators, helping the best to follow and diagnose a deployed portal, using Google Analytics, our logs, and SPARQL queries

Roadmap (Todo)

Define our KPI (key performance indicators)

We can divide them into three groups

1. Usability KPIs
   • Evolution of the number of unique users per month and year (source: Google Analytics, type: bar chart)
   • Top 10 used features in the month and the current year (source: Google Analytics, type: table)
2. Content KPIs
   • Number of processed ontologies this month and year (source: logs, type: bar chart)
   • Current number of failed parsing (source: logs, type: number)
3. Monitoring KPIs
   • Top 10 errors occurred this month (source: logs, type: table)
   • Evolution of the usage of the server memory (source: system, type: bar chart)
   • Evolution of the usage of the CPU (source: system, type: bar chart)
   • Current usage of Disk (source: system, type: number)
   • Current code version (source: git, type: number/hash/tag)
   • Status of all our processes (source: the current sudo opstatus, type: table)

KPI prensentation proposition

Define the main features of the admin page

• Portal configuration

  • Edit the UI configuration file from the UI
  • Edit CSS variables (primary color,.....)

• Ontologies features

  • Process
  • Edit / Curate metadata
  • Delete
  • Delete submissions

• User features

  • Login as
  • Delete
  • Make admin

• Infrastructure

  • Clear caches
  • Update code
  • Restart the backend services
  • Restart UI

References

• https://github.com/igorkasyanchuk/rails_performance
• https://vulehuan.com/en/blog/2023/05/how-to-retrieve-data-from-google-analytics-ga4-using-gem-googleapiclient-and-query-explorer-with-rails-64680f9764ac40ae37cdf496.html#gsc.tab=0
• Streaming real-time data for logs: https://sinatrarb.com/contrib/streaming.html
• https://chartkick.com/

[Bilelkihal]

https://chartkick.com/

[Bilelkihal]

What do u mean by this @syphax-bouazzouni

[jonquet]

Added to agenda of Dec 22 meeting for refinement.

[syphax-bouazzouni]

What do u mean by this @syphax-bouazzouni

For version, it is the git latest tag found in the server. For the process, it is this telling if all the components of the application (databases, servers, caches) are running.

[saubin78]

Hi. In the ontology admin page, I don't see how to select the ontologies to apply an action on them (I'd like to delete test ontologies on stageportal) Shouldn't there be select boxes for each row?

[syphax-bouazzouni]

Hi. In the ontology admin page, I don't see how to select the ontologies to apply an action on them (I'd like to delete test ontologies on stageportal) Shouldn't there be select boxes for each row?

hello @saubin78 , it works by clicking on the rows that you want to perform an action, they will be selected and highlighted. and then go to the select input "Please select", choose "Delete" then click on the button "Go"

[saubin78]

monday morning... I should have noticed. Thanks