Device Detector: SQL values

Aglaron · March 31, 2018, 1:55pm

Hi!

I got an overview of values for the variables config_device_type and config_browser_name of the piwik_log_visit table.
Now I can’t assign the values to real device types and browser names. I have no access to the Matomo-/Piwik-Database, just these values.

The config_device_type values are 0, 1 and 2 and I guess this means mobile etc.
The config_browser_name values are CH (Chrome ?), CI, FF (Firefox ?), IE (Internet Explorer ?), MF, PS and SF (Safari ?).

It would be nice if anyone can help me!

Thanks in advance!

Lukas · March 31, 2018, 8:13pm

Hi,

while I can’t help much with the rest, I know about the shortnames.

You can find the mappings in the device-detector repository:

github.com

matomo-org/device-detector/blob/master/Parser/Client/Browser.php#L29


class Browser extends ClientParserAbstract
{
protected $fixtureFile = 'regexes/client/browsers.yml';
protected $parserName = 'browser';


/**
 * Known browsers mapped to their internal short codes
 *
 * @var array
 */
protected static $availableBrowsers = array(
    '36' => '360 Phone Browser',
    '3B' => '360 Browser',
    'AA' => 'Avant Browser',
    'AB' => 'ABrowse',
    'AF' => 'ANT Fresco',
    'AG' => 'ANTGalio',
    'AL' => 'Aloha Browser',
    'AM' => 'Amaya',
    'AO' => 'Amigo',
    'AN' => 'Android Browser',

github.com

matomo-org/device-detector/blob/master/Parser/OperatingSystem.php#L30


class OperatingSystem extends ParserAbstract
{
protected $fixtureFile = 'regexes/oss.yml';
protected $parserName = 'os';


/**
 * Known operating systems mapped to their internal short codes
 *
 * @var array
 */
protected static $operatingSystems = array(
    'AIX' => 'AIX',
    'AND' => 'Android',
    'AMG' => 'AmigaOS',
    'ATV' => 'Apple TV',
    'ARL' => 'Arch Linux',
    'BTR' => 'BackTrack',
    'SBA' => 'Bada',
    'BEO' => 'BeOS',
    'BLB' => 'BlackBerry OS',
    'QNX' => 'BlackBerry Tablet OS',

Aglaron · April 2, 2018, 3:36pm

Hi Lukas,

that’s all I want to know.

Thanks a lot!