Employee headcount data importer
[disclosr.git] / admin / importDirectoryUUIDs.php
blob:a/admin/importDirectoryUUIDs.php -> blob:b/admin/importDirectoryUUIDs.php
--- a/admin/importDirectoryUUIDs.php
+++ b/admin/importDirectoryUUIDs.php
@@ -1,13 +1,37 @@
 <?php
+
 // http://gold.gov.au/reports/department/index.xml
 require_once '../include/common.inc.php';
-try {
-    $server->create_db('disclosr-agencies');
-} catch (SetteeRestClientException $e) {
-    setteErrorHandler($e);
+$db = $server->get_db('disclosr-agencies');
+$rows = $db->get_view("app", "byName")->rows;
+$nametoid = Array();
+$sums = Array();
+foreach ($rows as $row) {
+    $nametoid[trim($row->key)] = $row->value;
 }
-$db = $server->get_db('disclosr-agencies');
-createAgencyDesignDoc();
 
+if (file_exists('index.xml')) {
+    $xml = simplexml_load_file('index.xml');
+
+    foreach ($xml as $agency) {
+        $names = Array();
+        $names[] = "".$agency->name;
+        
+        if (isset($agency->shortName)) {
+             $names[] = "".$agency->shortName;
+        }
+       foreach ($names as $name) {
+           if (!in_array($name, array_keys($nametoid))) {
+               echo "$name missing".PHP_EOL;
+               print_r($names);
+               echo $agency->dn;
+               echo PHP_EOL;
+               echo PHP_EOL;
+           }
+       }
+    }
+} else {
+    exit('Failed to open test.xml.');
+}
 ?>