CSV Report

The easiest way to extract and structure data is through a CSV report. Although the functionality to export gathered data in CSV format is already available in the Session Administration of SoPHIE, there might be situations, where an individual report is necessary.

Using such a report helps formatting the data to a level, where you can directly import the information to your data analysis software. This will save a lot of time and it prevents mistakes, once the report is finished.

$groups = $groupApi->getGroupLabels();
echo 'Group;Round;' . PHP_EOL;
for ($i = 1; $i <= 5; $i++)
{
  foreach($groups as $group)
  { 
      $groupNumber = explode(".", $group);
    
      echo $group . ';';
      echo $i . ';';
      echo PHP_EOL;
  }
}