[contractdashboard.git] / exportData.csv.php
--- a/exportData.csv.php
+++ b/exportData.csv.php
@@ -17,9 +17,9 @@
 EXTRACT(EPOCH FROM "contractStart") as "contractStart",
 EXTRACT(EPOCH FROM "contractEnd") as "contractEnd",
 value,description,"procurementMethod",category,"categoryUNSPSC",
-(substr( "categoryUNSPSC"::text, 0, 2 ) || \'0000000\'::text) as "cat1",  
- (substr( "categoryUNSPSC"::text, 0, 3 ) || \'000000\'::text) as "cat2",
- (substr( "categoryUNSPSC"::text, 0, 4 ) || \'00000\'::text) as "cat3",
+(substr( "categoryUNSPSC"::text, 0, 2 ) || \'000000\'::text) as "cat1",  
+ (substr( "categoryUNSPSC"::text, 0, 4 ) || \'0000\'::text) as "cat2",
+ (substr( "categoryUNSPSC"::text, 0, 6 ) || \'00\'::text) as "cat3",
  "supplierABN","supplierName",
 (
  case when "supplierABN" != 0 THEN "supplierABN"::text ELSE "supplierName" END) as supplierID,