--- a/import.php +++ b/import.php @@ -9,10 +9,10 @@ $db = $server->get_db('disclosr-agencies'); createAgencyDesignDoc(); $conn = new PDO("pgsql:dbname=contractDashboard;user=postgres;password=snmc;host=localhost"); -$namesQ = 'select agency.abn, string_agg("agencyName",\',\') as names from agency inner join agency_nametoabn on agency.abn::text = agency_nametoabn.abn group by agency.abn;'; +$namesQ = 'select agency.abn, string_agg("agencyName",\'|\') as names from agency inner join agency_nametoabn on agency.abn::text = agency_nametoabn.abn group by agency.abn;'; $abntonames = Array(); foreach ($conn->query($namesQ) as $row) { - $abntonames[$row['abn']] = explode(",", $row['names']); + $abntonames[$row['abn']] = explode("|", $row['names']); } $result = $conn->query("select * from agency"); while ($agency = $result->fetch(PDO::FETCH_ASSOC)) {