Lookup Values Required

Can someone please provide lookup values for the columns location_browser_lang, config_browser_name,config_device_brand ? This determination is required so that anyone can easily decipher. These columns are in matomo_log_visit

Maybe @innocraft can give some hints?

Hi @Ali_Raja can you provide more context on what you are needing.

It is not Matomo who decides that, it is mostly generic

Hey Varun, I want to build a lookup table. So en is english, which is self explanatory, but there will be some scenarios in which people may not be able to accurately translate. Similarly there are other columns which need to have lookups, but I am not able to find those lookups anywhere.

@V.K any updates on this?

Hi @Ali_Raja
Thanks for your patience.

The best place for information on any of the columns in the database is the database schema documentation here: https://developer.matomo.org/guides/database-schema
This should be useful to you for all future endeavours.

For this specific case the value of these columns is set using the Device Detector library which you can find here: https://github.com/matomo-org/device-detector

In general the device detector just simply reads the User Agent and parses the information from there and inserts it into the database. For example, the browser name column is set using a shortcode with this lookup table: https://github.com/matomo-org/device-detector/blob/be1c9ef486c247dc4886668da5ed0b1c49d90ba8/Parser/Client/Browser.php

I trust this information will be useful to you.