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); }