The onCSVOutput handler is called when LiveWhale exports a CSV, allowing you to filter or customize it however you like. The example module below adds a new custom column to an exported CSV of event registrations.
Parameter | Description |
---|---|
$data_type | “event_registrations”, “users”, or “quickaccess” |
$rows | An array of every row of the CSV |
<?php
$_LW->REGISTERED_APPS['my_app']=[
'title'=>'My App',
'handlers'=>['onValidateUpload'],
];
class LiveWhaleApplicationMyApp {
public function onCSVOutput($data_type, $rows) { // formats CSV output
global $_LW;
if ($data_type=='event_registrations') { // if these are event RSVPs
foreach($rows as $key=>$val) {
if ($key===0) { // add custom column to the header row
$rows[$key][]='Appointment Time';
$custom_column_key=sizeof($rows[$key])-1;
}
else { // add custom value to each row, in that column
$custom_value = ''; // you could run a db query, load custom values, or make a calculation based on other column values
$rows[$key][$custom_column_key]=$custom_value; // add the value to this row
};
};
};
return $rows;
}
}
?>