Add CSV data export
[contractdashboard.git] / exportData.csv.php
blob:a/exportData.csv.php -> blob:b/exportData.csv.php
--- a/exportData.csv.php
+++ b/exportData.csv.php
@@ -1,7 +1,7 @@
 <?php
 
 include_once("./lib/common.inc.php");
-
+setlocale(LC_CTYPE, 'C');
 // source: http://stackoverflow.com/questions/81934/easy-way-to-export-a-sql-table-without-access-to-the-server-or-phpmyadmin#81951
 $result = mysql_query('
 SELECT CNID,contractnotice.agencyName,agency.abn as agencyABN,publishDate,contractStart,contractEnd,value,description,procurementMethod,category,categoryUNSPSC
@@ -22,6 +22,10 @@
     header('Expires: 0');
     fputcsv($fp, $headers);
     while ($row = mysql_fetch_assoc($result)) {
+	foreach ($row as &$colvalue) {
+			$colvalue =  preg_replace( '/[^[:print:]]/', '',
+			 utf8_encode($colvalue));
+		}
         fputcsv($fp, array_values($row));
     }
     die;