function saveToCSV()
{
$csv = new CSV("./output/csv/" . $this->output . ".csv");
$csv->addArrayHeader(array("trcid", "title", "shortdescription", "longdescription", "calendarsummary", "titleEN", "shortdescriptionEN", "longdescriptionEN", "calendarsummaryEN", "types", "ids", "locatienaam", "city", "adres", "zipcode", "latitude", "longitude", "urls", "media", "thumbnail", "datepattern_startdate", "datepattern_enddate", "singledates", "lastupdated"));
foreach ($this->items as $item) {
$csv->addArray($item);
}
if ($this->append) {
$csv->append();
} else {
$csv->write();
}
$this->debug("Saved as CSV (" . $this->output . ")");
}
function saveToCSV()
{
$csv = new CSV($this->output);
$csv->addArrayHeader(array("trcid", "title", "shortdescription", "longdescription", "calendarsummary", "titleEN", "shortdescriptionEN", "longdescriptionEN", "calendarsummaryEN", "types", "ids", "locatienaam", "city", "adres", "zipcode", "latitude", "longitude", "urls", "media", "thumbnail", "datepattern_startdate", "datepattern_enddate", "singledates", "type1", "lastupdated"));
foreach ($this->items as $item) {
$csv->addArray($item);
}
if ($this->append) {
$csv->append();
} else {
$csv->write();
}
$this->debug("Saved as CSV (" . $this->output . ")");
$this->saveToJSON();
/*
$fname = substr($this->output, strrpos($this->output, "/") + 1);
//And copy to amsterdamopendata.nl/files
$domain = 'amsterdamopendata.nl';
$domain = "217.77.130.133"; //Using IP directly because amsterdamopendata.nl is known to web.redant.net and is trying to connect locally.
$user = '******';
$password = '******';
$sftp = new Net_SFTP($domain, 22, 30);
if (!$sftp->login($user, $password)) {
exit('Login Failed');
} else {
$sftp->chdir('files');
$sftp->put($fname, $csv->contents());
$this->debug("Uploaded to amsterdamopendata.nl/files (" . $fname . ")");
}
*/
}
function saveToCSV($extend_to_resources = true, $filename = null)
{
if (!$filename) {
$csv = new CSV("csv/datasets-" . date("YmdHis") . "-" . max(0, $extend_to_resources) . ".csv");
} else {
$csv = new CSV($filename);
}
if ($extend_to_resources) {
$csv->addArrayHeader(array("Thema", "Categorie", "Naam", "Titel", "Beschrijving", "Tags", "Eigenaar", "Eigenaar e-mail", "Contactpersoon", "Contact e-mail", "Webadres", "Vrijgegeven", "Aangepast", "Tijd vanaf", "Tijd tot", "Tijd detailniveau", "Updatefrequentie", "Licentie", "Dataset url", "Dataset beschrijving", "Bestandsformaat"));
} else {
$csv->addArrayHeader(array("Thema", "Categorie", "Naam", "Titel", "Beschrijving", "Tags", "Eigenaar", "Eigenaar e-mail", "Contactpersoon", "Contact e-mail", "Webadres", "Vrijgegeven", "Aangepast", "Tijd vanaf", "Tijd tot", "Tijd detailniveau", "Updatefrequentie", "Licentie", "Directe url", "Aantal datasets", "Datasets"));
}
foreach ($this->datasets as $name => $dataset) {
if ($extend_to_resources) {
foreach ($dataset->res_description as $key => $description) {
$thema = $this->themas[$dataset->groups[0]];
$categorie = $this->categorien[$dataset->groups[0]];
$item = array($thema, $categorie, $dataset->name, $dataset->title, $dataset->notes, implode(" ", $dataset->tags), $dataset->author, $dataset->author_email, $dataset->extras->contact_name, $dataset->extras->contact_email, $dataset->extras->website, $dataset->extras->publication_date, $dataset->metadata_modified, $dataset->extras->time_period_from, $dataset->extras->time_period_to, $dataset->extras->time_period_detail_level, $dataset->extras->update_frequency, $dataset->license_id, $dataset->res_url[$key], $description, $dataset->res_format[$key]);
$csv->addArray($item);
}
} else {
//Only datasets
$thema = $this->themas[$dataset->groups[0]];
$categorie = $this->categorien[$dataset->groups[0]];
$url = DATA_URL . "?dataset=" . $dataset->name;
$count = 0;
$sets = "";
$splitter = "";
foreach ($dataset->res_description as $key => $description) {
$count++;
$sets .= $splitter . $description;
$splitter = ", ";
}
$item = array($thema, $categorie, $dataset->name, $dataset->title, $dataset->notes, implode(" ", $dataset->tags), $dataset->author, $dataset->author_email, $dataset->extras->contact_name, $dataset->extras->contact_email, $dataset->extras->website, $dataset->extras->publication_date, $dataset->metadata_modified, $dataset->extras->time_period_from, $dataset->extras->time_period_to, $dataset->extras->time_period_detail_level, $dataset->extras->update_frequency, $dataset->license_id, $url, $count, $sets);
$csv->addArray($item);
}
}
$csv->write();
}
/**
* @expectedException \SlimBootstrap\CSVEncodingException
* @expectedExceptionMessage Expected array of DataObjects or one DataObject, but NULL given.
*/
public function testWriteUnencodable()
{
$this->_csvTestOutputWriter->write(null, 200);
}
