Hi,
Im using Xdbedit and now i need to export a CSV. So hopefully somebody can help.
In my registuser.grid.js it call the button:
{
xtype: 'buttongroup',
title: 'Excel (CSV)',
columns: 1,
defaults: {
scale: 'large'
},
items: [{
text: _(Xdbedit.customconfigs.task + '.export_selected') || _('xdbedit.export_selected')
,handler: this.csvExport
,enableToggle: false
,scope: this
}]
},
.
.
.
csvExport: function(btn,e) {
var cs = this.getSelectedAsList();
if (cs === false) return false;
MODx.Ajax.request({
url: this.config.url
,params: {
action: 'mgr/'+Xdbedit.customconfigs.task+'/export'
,task: 'export'
,configs: this.config.configs
}
});
return true;
},
And my export.php:
<?php
header('Content-type: text/comma-separated-values');
header('Content-Disposition: attachment; filename="Anmeldung_event.csv"');
$config=$modx->xdbedit->customconfigs;
$prefix = $config['prefix'];
$packageName = $config['packageName'];
$tablename = $config['tablename'];
$packagepath = $modx->getOption('core_path') . 'components/'.$packageName.'/';
$modelpath = $packagepath.'model/';
$modx->addPackage($packageName,$modelpath,$prefix);
$classname = $modx->xdbedit->getClassName($tablename);
$region = $modx->getOption('region',$scriptProperties,'all');
if ($region != 'all'){
$c->where(array($classname.'.region' => $region));
}
if($modx->isBackend()){
$query = 'SELECT modx_registevent_'.$tablename.'.id, DATE_FORMAT( sent, \'%d.%m.%Y um %H:%i\' ) as eventdate, region, gender, title, firstname, name, email, phone, adress, zipcode, city WHERE '.$region.' FROM `modx_registevent_'.$tablename.'`;';
$event = $modx->query($query);
$output .= '"ID";"Veranstaltung";"Veranstaltungsdatum";"Geschlecht";"Titel";"Vorname";"Nachname";"Straße";"PLZ";"Ort";"Telefon";"Email"'."\r\n";
while( $row = $modx->db->getRow( $event ) ) {
$output .= '"'.$row['id'].'";"'.$row['eventdate'].'";"'.htmlspecialchars($row['region'], ENT_QUOTES).'";"'.htmlspecialchars($row['eventdate'], ENT_QUOTES).'";"'.htmlspecialchars($row['gender'], ENT_QUOTES).'";"'.htmlspecialchars($row['title'], ENT_QUOTES).'";"'.htmlspecialchars($row['firstname'], ENT_QUOTES).'";"'.htmlspecialchars($row['name'], ENT_QUOTES).'";"'.htmlspecialchars($row['adress'], ENT_QUOTES).'";"'.htmlspecialchars($row['zipcode'], ENT_QUOTES).'";"'.htmlspecialchars($row['city'], ENT_QUOTES).'";"'.htmlspecialchars($row['phone'], ENT_QUOTES).'";"'.htmlspecialchars($row['email'], ENT_QUOTES).'"'."\r\n";
}
}
return $output;
?>
Nothing happen. I dont know whats missing. So please can somebody help?