From 617c5251b6af8f91268f279914fb13835fe3c21e Mon Sep 17 00:00:00 2001
From: Coleman Watts <coleman@civicrm.org>
Date: Tue, 30 Apr 2013 17:12:18 -0700
Subject: [PATCH] Remove van module CRM-9794

----------------------------------------
* CRM-9794: Remove API v2
  http://issues.civicrm.org/jira/browse/CRM-9794
---
 tools/drupal/modules/civicrm_van/VAN/Auth.php |  79 -----
 .../modules/civicrm_van/VAN/Contact.php       | 198 ------------
 .../drupal/modules/civicrm_van/VAN/Person.php | 142 ---------
 .../modules/civicrm_van/VAN/apiKey.php.txt    |   3 -
 .../modules/civicrm_van/civicrm_van.info      |   7 -
 .../modules/civicrm_van/civicrm_van.module    |  34 ---
 tools/drupal/modules/civicrm_van/run.php      |  11 -
 .../civicrm_van/xml/CustomGroupData.xml       | 281 ------------------
 8 files changed, 755 deletions(-)
 delete mode 100644 tools/drupal/modules/civicrm_van/VAN/Auth.php
 delete mode 100644 tools/drupal/modules/civicrm_van/VAN/Contact.php
 delete mode 100644 tools/drupal/modules/civicrm_van/VAN/Person.php
 delete mode 100644 tools/drupal/modules/civicrm_van/VAN/apiKey.php.txt
 delete mode 100644 tools/drupal/modules/civicrm_van/civicrm_van.info
 delete mode 100644 tools/drupal/modules/civicrm_van/civicrm_van.module
 delete mode 100644 tools/drupal/modules/civicrm_van/run.php
 delete mode 100644 tools/drupal/modules/civicrm_van/xml/CustomGroupData.xml

diff --git a/tools/drupal/modules/civicrm_van/VAN/Auth.php b/tools/drupal/modules/civicrm_van/VAN/Auth.php
deleted file mode 100644
index 09be71ca0c..0000000000
--- a/tools/drupal/modules/civicrm_van/VAN/Auth.php
+++ /dev/null
@@ -1,79 +0,0 @@
-<?php
-/*
- +--------------------------------------------------------------------+
- | CiviCRM version 4.1                                                |
- +--------------------------------------------------------------------+
- | Copyright CiviCRM LLC (c) 2004-2011                                |
- +--------------------------------------------------------------------+
- | This file is a part of CiviCRM.                                    |
- |                                                                    |
- | CiviCRM is free software; you can copy, modify, and distribute it  |
- | under the terms of the GNU Affero General Public License           |
- | Version 3, 19 November 2007.                                       |
- |                                                                    |
- | CiviCRM is distributed in the hope that it will be useful, but     |
- | WITHOUT ANY WARRANTY; without even the implied warranty of         |
- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
- | See the GNU Affero General Public License for more details.        |
- |                                                                    |
- | You should have received a copy of the GNU Affero General Public   |
- | License along with this program; if not, contact CiviCRM LLC       |
- | at info[AT]civicrm[DOT]org. If you have questions about the        |
- | GNU Affero General Public License or the licensing of CiviCRM,     |
- | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
- +--------------------------------------------------------------------+
-*/
-
-/**
- *
- * @package CRM
- * @copyright CiviCRM LLC (c) 2004-2011
- * $Id$
- *
- */
-class VAN_Auth {
-  static $_header;
-
-  static $_client;
-  CONST DATABASE_NODE = 'MyVoterFile', WSDL_URL = 'https://secure.securevan.com/Services/V3/PersonService.asmx?wsdl', VAN_NS = 'https://api.securevan.com/Services/V3/';
-
-  static
-  function initialize() {
-    static $initialized = FALSE;
-
-    if ($initialized) {
-      return;
-    }
-
-    require_once 'van/apiKey.php';
-
-    $initialized = TRUE;
-    $headerParams = array('APIKey' => new SOAPVar(VAN_API_KEY,
-        XSD_STRING, NULL, NULL, NULL,
-        self::VAN_NS
-      ),
-      'DatabaseMode' => new SOAPVar(self::DATABASE_NODE,
-        XSD_STRING, NULL, NULL, NULL,
-        self::VAN_NS
-      ),
-    );
-    self::$_header = new SOAPHeader(self::VAN_NS,
-      'Header',
-      new SOAPVar($headerParams,
-        SOAP_ENC_OBJECT
-      )
-    );
-
-    self::$_client = new SOAPClient(self::WSDL_URL,
-      array('trace' => TRUE)
-    );
-    self::$_client->__setSoapHeaders(array(self::$_header));
-  }
-
-  static
-  function invoke($method, &$params) {
-    self::initialize();
-    return self::$_client->$method($params);
-  }
-}
-
diff --git a/tools/drupal/modules/civicrm_van/VAN/Contact.php b/tools/drupal/modules/civicrm_van/VAN/Contact.php
deleted file mode 100644
index b940671824..0000000000
--- a/tools/drupal/modules/civicrm_van/VAN/Contact.php
+++ /dev/null
@@ -1,198 +0,0 @@
-<?php
-/*
- +--------------------------------------------------------------------+
- | CiviCRM version 4.1                                                |
- +--------------------------------------------------------------------+
- | Copyright CiviCRM LLC (c) 2004-2011                                |
- +--------------------------------------------------------------------+
- | This file is a part of CiviCRM.                                    |
- |                                                                    |
- | CiviCRM is free software; you can copy, modify, and distribute it  |
- | under the terms of the GNU Affero General Public License           |
- | Version 3, 19 November 2007.                                       |
- |                                                                    |
- | CiviCRM is distributed in the hope that it will be useful, but     |
- | WITHOUT ANY WARRANTY; without even the implied warranty of         |
- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
- | See the GNU Affero General Public License for more details.        |
- |                                                                    |
- | You should have received a copy of the GNU Affero General Public   |
- | License along with this program; if not, contact CiviCRM LLC       |
- | at info[AT]civicrm[DOT]org. If you have questions about the        |
- | GNU Affero General Public License or the licensing of CiviCRM,     |
- | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
- +--------------------------------------------------------------------+
-*/
-
-/**
- *
- * @package CRM
- * @copyright CiviCRM LLC (c) 2004-2011
- * $Id$
- *
- */
-class VAN_Contact {
-  function findContact(&$person) {
-    require_once 'CRM/Core/DAO.php';
-
-    // first see if there is a VAN ID match
-    $sql = "
-SELECT entity_id
-FROM   civicrm_value_van
-WHERE  van_id = %1
-";
-    $params = array(1 => array($person['custom']['van_id'], 'Integer'));
-    $cid = CRM_Core_DAO::singleValueQuery($sql, $params);
-    if ($cid) {
-      return array($cid);
-    }
-
-    // ok, how about we search on
-    // first_name AND last_name AND street_address AND zip_code
-    $sql = "
-SELECT  contact_id
-FROM    civicrm_contact c,
-        civicrm_address a
-WHERE   a.contact_id = c.id
-AND     c.first_name     = %1
-AND     c.last_name      = %2
-AND     a.postal_code    = %3
-AND     a.street_address = %4
-";
-    $params = array(1 => array($person['first_name'], 'String'),
-      2 => array($person['last_name'], 'String'),
-      3 => array($person['address'][0]['street_address'], 'String'),
-      4 => array($person['address'][0]['postal_code'], 'String'),
-    );
-    $dao = CRM_Core_DAO::executeQuery($sql, $params);
-    if ($dao->N == 1) {
-      $dao->fetch();
-      return array($dao->contact_id);
-    }
-    elseif ($dao->N > 1) {
-      $cids = array();
-      while ($dao->fetch()) {
-        $cids[] = $dao->contact_id;
-      }
-      return $cids;
-    }
-
-    // ok did not find it
-    // run a simpler query
-    // first_name AND last_name AND street_address AND zip_code
-    $sql = "
-SELECT  contact_id
-FROM    civicrm_contact c,
-        civicrm_address a
-WHERE   a.contact_id = c.id
-AND     c.first_name     = %1
-AND     c.last_name      = %2
-AND     a.postal_code    = %3
-";
-    $dao = CRM_Core_DAO::executeQuery($sql, $params);
-    if ($dao->N == 1) {
-      $dao->fetch();
-      return array($dao->contact_id);
-    }
-    elseif ($dao->N > 1) {
-      $cids = array();
-      while ($dao->fetch()) {
-        $cids[] = $dao->contact_id;
-      }
-      return $cids;
-    }
-
-    return NULL;
-  }
-
-  function createOrUpdateContact(&$person, $cid = NULL) {
-    if (!$cid) {
-      $cids = self::findContact($person);
-      if (is_array($cids) &&
-        count($cids) == 1
-      ) {
-        $cid = $cids[0];
-      }
-      // did not find a contact or too many matching contacts
-      // lets create a new one :)
-    }
-
-    $person['contact_type'] = 'Individual';
-
-    // format address params
-    if (isset($person['address'])) {
-      $locationTypes = CRM_Core_PseudoConstant::locationType();
-      foreach ($person['address'] as $key => $value) {
-        $person['address'][$key]['location_type_id'] = array_search($person['address'][$key]['location_type'], $locationTypes);
-        unset($person['address'][$key]['location_type']);
-        if ($cid) {
-          $person['address'][$key]['contact_id'] = $cid;
-        }
-      }
-    }
-
-    // format phone params
-    if (isset($person['phone'])) {
-      $phoneTypes = CRM_Core_PseudoConstant::phoneType();
-      foreach ($person['phone'] as $key => $value) {
-        $person['phone'][$key]['phone'] = $person['phone'][$key]['phone_number'];
-        unset($person['phone'][$key]['phone_number']);
-        $person['phone'][$key]['location_type_id'] = $person['address'][0]['location_type_id'];
-        $person['phone'][$key]['phone_type_id'] = array_search($person['phone'][$key]['phone_type'], $phoneTypes);
-        unset($person['phone'][$key]['phone_type']);
-        if ($cid) {
-          $person['phone'][$key]['contact_id'] = $cid;
-        }
-      }
-    }
-
-    require_once 'api/v2/Contact.php';
-    if (!$cid) {
-      $params = $person;
-      $contact = civicrm_contact_create($params);
-      if ($contact['is_error']) {
-        CRM_Core_Error::fatal();
-      }
-
-      $cid = $contact['contact_id'];
-    }
-    else {
-      $person['contact_id'] = $cid;
-      $params = $person;
-      $contact = civicrm_contact_update($params);
-      if ($contact['is_error']) {
-        CRM_Core_Error::fatal();
-      }
-    }
-
-    // now add all the custom fields
-    $sql = "
-REPLACE INTO civicrm_value_van
-       ( entity_id, van_id, party, county, precinct, congressional,
-         assembly, state_senate, municipality, ward, supervisor_dist,
-         portion, zip5 )
-VALUES
-       ( %1, %2, %3, %4, %5, %6,
-         %7, %8, %9, %10, %11,
-         %12, %13 )
-";
-
-    $custom = &$person['custom'];
-    $params = array(1 => array($cid, 'Integer'),
-      2 => array($custom['van_id'], 'Integer'),
-      3 => array($custom['party'], 'String'),
-      4 => array($custom['county'], 'String'),
-      5 => array($custom['precinct'], 'Integer'),
-      6 => array($custom['congressional'], 'Integer'),
-      7 => array($custom['assembly'], 'Integer'),
-      8 => array($custom['state_senate'], 'Integer'),
-      9 => array($custom['municipality'], 'String'),
-      10 => array($custom['ward'], 'Integer'),
-      11 => array($custom['supervisor_dist'], 'Integer'),
-      12 => array($custom['portion'], 'String'),
-      13 => array($custom['zip5'], 'String'),
-    );
-    $dao = CRM_Core_DAO::executeQuery($sql, $params);
-  }
-}
-
diff --git a/tools/drupal/modules/civicrm_van/VAN/Person.php b/tools/drupal/modules/civicrm_van/VAN/Person.php
deleted file mode 100644
index 77f17a86f6..0000000000
--- a/tools/drupal/modules/civicrm_van/VAN/Person.php
+++ /dev/null
@@ -1,142 +0,0 @@
-<?php
-/*
- +--------------------------------------------------------------------+
- | CiviCRM version 4.1                                                |
- +--------------------------------------------------------------------+
- | Copyright CiviCRM LLC (c) 2004-2011                                |
- +--------------------------------------------------------------------+
- | This file is a part of CiviCRM.                                    |
- |                                                                    |
- | CiviCRM is free software; you can copy, modify, and distribute it  |
- | under the terms of the GNU Affero General Public License           |
- | Version 3, 19 November 2007.                                       |
- |                                                                    |
- | CiviCRM is distributed in the hope that it will be useful, but     |
- | WITHOUT ANY WARRANTY; without even the implied warranty of         |
- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
- | See the GNU Affero General Public License for more details.        |
- |                                                                    |
- | You should have received a copy of the GNU Affero General Public   |
- | License along with this program; if not, contact CiviCRM LLC       |
- | at info[AT]civicrm[DOT]org. If you have questions about the        |
- | GNU Affero General Public License or the licensing of CiviCRM,     |
- | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
- +--------------------------------------------------------------------+
-*/
-
-/**
- *
- * @package CRM
- * @copyright CiviCRM LLC (c) 2004-2011
- * $Id$
- *
- */
-class VAN_Person {
-  static
-  function &getPersonDetails($vanID) {
-    $params = array('PersonID' => $vanID,
-      'PersonIDType' => 'VANID',
-      'options' => array('ReturnSections' => 'Address,Phone,District'),
-    );
-
-    require_once 'van/Auth.php';
-    $details = van_Auth::invoke('GetPerson', $params);
-
-    return self::formatPersonDetails($details->GetPersonResult);
-  }
-
-  static
-  function &formatPersonDetails(&$person) {
-    $map = array('FirstName' => 'first_name',
-      'LastName' => 'last_name',
-      'Sex' => 'Gender',
-      'Email' => 'email',
-      'Party' => 'custom_party',
-      'VANID' => 'custom_van_id',
-      'DateOfBirth' => 'birth_date',
-    );
-    $values = self::mapInfo($map, $person);
-
-    $map = array('StreetAddress' => 'street_address',
-      'City' => 'city',
-      'State' => 'state_province',
-      'Zip5' => 'postal_code',
-      'Zip4' => 'postal_code_suffix',
-      'AddressType' => 'location_type',
-      'IsPreferred' => 'is_primary',
-    );
-    self::extractInfo('Addresses', 'Address', $person, $values, $map, 'address');
-
-    $map = array('Number' => 'phone_number',
-      'PhoneType' => 'phone_type',
-      'IsPreferred' => 'is_primary',
-    );
-    self::extractInfo('Phones', 'Phone', $person, $values, $map, 'phone');
-
-    /***
-     $map = array( 'Email'      => 'email',
-     'IsPreferred' => 'is_primary' );
-     self::extractInfo( 'Emails', 'Email', $person, $values, $map, 'email' );
-     ***/
-
-    self::extractDistricts($person, $values);
-
-    return $values;
-  }
-
-  function mapInfo(&$map, &$object) {
-    $value = array();
-    foreach ($map as $k => $v) {
-      if (isset($object->$k)) {
-        $value[$map[$k]] = $object->$k;
-      }
-    }
-    return $value;
-  }
-
-  function extractInfo($primary, $secondary, &$object, &$values, &$map, $key) {
-    if (isset($object->$primary) &&
-      isset($object->$primary->$secondary)
-    ) {
-      $values[$key] = array();
-      $actual = $object->$primary->$secondary;
-      if (is_array($actual)) {
-        foreach ($actual as $a) {
-          self::extractInfoSingle($map, $a, $values[$key]);
-        }
-      }
-      else {
-        self::extractInfoSingle($map, $actual, $values[$key]);
-      }
-      if (empty($values[$key])) {
-        unset($values[$key]);
-      }
-    }
-  }
-
-  function extractInfoSingle(&$map, &$object, &$values) {
-    $value = self::mapInfo($map, $object);
-    if (!empty($value)) {
-      $values[] = $value;
-    }
-  }
-
-  function extractDistricts(&$person, &$values) {
-    $values['custom'] = array('van_id' => $values['custom_van_id'],
-      'party' => $values['custom_party'],
-    );
-    unset($values['custom_van_id']);
-    unset($values['custom_party']);
-
-    if (isset($person->Districts) &&
-      isset($person->Districts->District)
-    ) {
-      foreach ($person->Districts->District as $district) {
-        $values['custom'][preg_replace('/\s+|\W+/', '_',
-          strtolower($district->DistrictType)
-        )] = $district->Name;
-      }
-    }
-  }
-}
-
diff --git a/tools/drupal/modules/civicrm_van/VAN/apiKey.php.txt b/tools/drupal/modules/civicrm_van/VAN/apiKey.php.txt
deleted file mode 100644
index fd3e14e30c..0000000000
--- a/tools/drupal/modules/civicrm_van/VAN/apiKey.php.txt
+++ /dev/null
@@ -1,3 +0,0 @@
-<?php
-
-define( 'VAN_API_KEY', 'PUT YOUR VAN API KEY HERE' );
diff --git a/tools/drupal/modules/civicrm_van/civicrm_van.info b/tools/drupal/modules/civicrm_van/civicrm_van.info
deleted file mode 100644
index 77d31eace6..0000000000
--- a/tools/drupal/modules/civicrm_van/civicrm_van.info
+++ /dev/null
@@ -1,7 +0,0 @@
-name = CiviCRM <-> VAN Integration 
-description = CiviCRM <-> VAN Integration 
-version = 3.4
-dependencies[] = civicrm
-package = CiviCRM
-core = 6.x
-php = 5.2
diff --git a/tools/drupal/modules/civicrm_van/civicrm_van.module b/tools/drupal/modules/civicrm_van/civicrm_van.module
deleted file mode 100644
index 33485a39fd..0000000000
--- a/tools/drupal/modules/civicrm_van/civicrm_van.module
+++ /dev/null
@@ -1,34 +0,0 @@
-<?php
-/*
- +--------------------------------------------------------------------+
- | CiviCRM version 4.1                                                |
- +--------------------------------------------------------------------+
- | Copyright CiviCRM LLC (c) 2004-2011                                |
- +--------------------------------------------------------------------+
- | This file is a part of CiviCRM.                                    |
- |                                                                    |
- | CiviCRM is free software; you can copy, modify, and distribute it  |
- | under the terms of the GNU Affero General Public License           |
- | Version 3, 19 November 2007.                                       |
- |                                                                    |
- | CiviCRM is distributed in the hope that it will be useful, but     |
- | WITHOUT ANY WARRANTY; without even the implied warranty of         |
- | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.               |
- | See the GNU Affero General Public License for more details.        |
- |                                                                    |
- | You should have received a copy of the GNU Affero General Public   |
- | License along with this program; if not, contact CiviCRM LLC       |
- | at info[AT]civicrm[DOT]org. If you have questions about the        |
- | GNU Affero General Public License or the licensing of CiviCRM,     |
- | see the CiviCRM license FAQ at http://civicrm.org/licensing        |
- +--------------------------------------------------------------------+
-*/
-
-/**
- *
- * @package CRM
- * @copyright CiviCRM LLC (c) 2004-2011
- * $Id$
- *
- */
-
diff --git a/tools/drupal/modules/civicrm_van/run.php b/tools/drupal/modules/civicrm_van/run.php
deleted file mode 100644
index 08024241b1..0000000000
--- a/tools/drupal/modules/civicrm_van/run.php
+++ /dev/null
@@ -1,11 +0,0 @@
-<?php
-require_once 'VAN/Person.php'; $details = VAN_Person::getPersonDetails('5402891');
-
-//require_once '/Users/lobo/svn/crm_v3.0/civicrm.settings.php';
-require_once '/Users/kurund/svn/civicrm30/civicrm.settings.php';
-require_once 'CRM/Core/Config.php';
-$config = CRM_Core_Config::singleton();
-
-require_once 'VAN/Contact.php';
-VAN_Contact::createOrUpdateContact($details);
-
diff --git a/tools/drupal/modules/civicrm_van/xml/CustomGroupData.xml b/tools/drupal/modules/civicrm_van/xml/CustomGroupData.xml
deleted file mode 100644
index 8a2ae86806..0000000000
--- a/tools/drupal/modules/civicrm_van/xml/CustomGroupData.xml
+++ /dev/null
@@ -1,281 +0,0 @@
-<?xml version="1.0" encoding="iso-8859-1" ?>
-
-<CustomData>
-  <CustomGroups>
-    <CustomGroup>
-      <name>VAN</name>
-      <title>VAN</title>
-      <extends>Individual</extends>
-      <style>Tab</style>
-      <collapse_display>0</collapse_display>
-      <help_pre></help_pre>
-      <help_post></help_post>
-      <weight>2</weight>
-      <is_active>1</is_active>
-      <table_name>civicrm_value_van</table_name>
-      <is_multiple>0</is_multiple>
-      <collapse_adv_display>1</collapse_adv_display>
-      <created_date>2009-09-18 10:15:04</created_date>
-    </CustomGroup>
-  </CustomGroups>
-  <CustomFields>
-    <CustomField>
-      <label>VAN ID</label>
-      <data_type>Int</data_type>
-      <html_type>Text</html_type>
-      <is_required>1</is_required>
-      <is_searchable>1</is_searchable>
-      <is_search_range>1</is_search_range>
-      <weight>1</weight>
-      <is_active>1</is_active>
-      <is_view>0</is_view>
-      <text_length>255</text_length>
-      <date_parts>M:;:;:;d:;:;:;Y</date_parts>
-      <note_columns>60</note_columns>
-      <note_rows>4</note_rows>
-      <column_name>van_id</column_name>
-      <custom_group_title>VAN</custom_group_title>
-    </CustomField>
-    <CustomField>
-      <label>Party</label>
-      <data_type>String</data_type>
-      <html_type>Select</html_type>
-      <is_required>0</is_required>
-      <is_searchable>1</is_searchable>
-      <is_search_range>0</is_search_range>
-      <weight>2</weight>
-      <is_active>1</is_active>
-      <is_view>0</is_view>
-      <text_length>4</text_length>
-      <date_parts>M:;:;:;d:;:;:;Y</date_parts>
-      <note_columns>60</note_columns>
-      <note_rows>4</note_rows>
-      <column_name>party</column_name>
-      <option_group_label>Party</option_group_label>
-      <custom_group_title>VAN</custom_group_title>
-    </CustomField>
-    <CustomField>
-      <label>County</label>
-      <data_type>String</data_type>
-      <html_type>Text</html_type>
-      <is_required>0</is_required>
-      <is_searchable>0</is_searchable>
-      <is_search_range>0</is_search_range>
-      <weight>3</weight>
-      <is_active>1</is_active>
-      <is_view>0</is_view>
-      <text_length>255</text_length>
-      <date_parts>M:;:;:;d:;:;:;Y</date_parts>
-      <note_columns>60</note_columns>
-      <note_rows>4</note_rows>
-      <column_name>county</column_name>
-      <custom_group_title>VAN</custom_group_title>
-    </CustomField>
-    <CustomField>
-      <label>Precinct</label>
-      <data_type>Int</data_type>
-      <html_type>Text</html_type>
-      <is_required>0</is_required>
-      <is_searchable>1</is_searchable>
-      <is_search_range>1</is_search_range>
-      <weight>4</weight>
-      <is_active>1</is_active>
-      <is_view>0</is_view>
-      <text_length>255</text_length>
-      <date_parts>M:;:;:;d:;:;:;Y</date_parts>
-      <note_columns>60</note_columns>
-      <note_rows>4</note_rows>
-      <column_name>precinct</column_name>
-      <custom_group_title>VAN</custom_group_title>
-    </CustomField>
-    <CustomField>
-      <label>Congressional</label>
-      <data_type>Int</data_type>
-      <html_type>Text</html_type>
-      <is_required>0</is_required>
-      <is_searchable>1</is_searchable>
-      <is_search_range>1</is_search_range>
-      <weight>5</weight>
-      <is_active>1</is_active>
-      <is_view>0</is_view>
-      <text_length>255</text_length>
-      <date_parts>M:;:;:;d:;:;:;Y</date_parts>
-      <note_columns>60</note_columns>
-      <note_rows>4</note_rows>
-      <column_name>congressional</column_name>
-      <custom_group_title>VAN</custom_group_title>
-    </CustomField>
-    <CustomField>
-      <label>Assembly</label>
-      <data_type>Int</data_type>
-      <html_type>Text</html_type>
-      <is_required>0</is_required>
-      <is_searchable>1</is_searchable>
-      <is_search_range>1</is_search_range>
-      <weight>6</weight>
-      <is_active>1</is_active>
-      <is_view>0</is_view>
-      <text_length>255</text_length>
-      <date_parts>M:;:;:;d:;:;:;Y</date_parts>
-      <note_columns>60</note_columns>
-      <note_rows>4</note_rows>
-      <column_name>assembly</column_name>
-      <custom_group_title>VAN</custom_group_title>
-    </CustomField>
-    <CustomField>
-      <label>State Senate</label>
-      <data_type>Int</data_type>
-      <html_type>Text</html_type>
-      <is_required>0</is_required>
-      <is_searchable>1</is_searchable>
-      <is_search_range>1</is_search_range>
-      <weight>7</weight>
-      <is_active>1</is_active>
-      <is_view>0</is_view>
-      <text_length>255</text_length>
-      <date_parts>M:;:;:;d:;:;:;Y</date_parts>
-      <note_columns>60</note_columns>
-      <note_rows>4</note_rows>
-      <column_name>state_senate</column_name>
-      <custom_group_title>VAN</custom_group_title>
-    </CustomField>
-    <CustomField>
-      <label>Municipality</label>
-      <data_type>String</data_type>
-      <html_type>Text</html_type>
-      <is_required>0</is_required>
-      <is_searchable>1</is_searchable>
-      <is_search_range>0</is_search_range>
-      <weight>8</weight>
-      <is_active>1</is_active>
-      <is_view>0</is_view>
-      <text_length>255</text_length>
-      <date_parts>M:;:;:;d:;:;:;Y</date_parts>
-      <note_columns>60</note_columns>
-      <note_rows>4</note_rows>
-      <column_name>municipality</column_name>
-      <custom_group_title>VAN</custom_group_title>
-    </CustomField>
-    <CustomField>
-      <label>Ward</label>
-      <data_type>Int</data_type>
-      <html_type>Text</html_type>
-      <is_required>0</is_required>
-      <is_searchable>1</is_searchable>
-      <is_search_range>1</is_search_range>
-      <weight>9</weight>
-      <is_active>1</is_active>
-      <is_view>0</is_view>
-      <text_length>255</text_length>
-      <date_parts>M:;:;:;d:;:;:;Y</date_parts>
-      <note_columns>60</note_columns>
-      <note_rows>4</note_rows>
-      <column_name>ward</column_name>
-      <custom_group_title>VAN</custom_group_title>
-    </CustomField>
-    <CustomField>
-      <label>Supervisor Dist</label>
-      <data_type>Int</data_type>
-      <html_type>Text</html_type>
-      <is_required>0</is_required>
-      <is_searchable>1</is_searchable>
-      <is_search_range>1</is_search_range>
-      <weight>10</weight>
-      <is_active>1</is_active>
-      <is_view>0</is_view>
-      <text_length>255</text_length>
-      <date_parts>M:;:;:;d:;:;:;Y</date_parts>
-      <note_columns>60</note_columns>
-      <note_rows>4</note_rows>
-      <column_name>supervisor_dist</column_name>
-      <custom_group_title>VAN</custom_group_title>
-    </CustomField>
-    <CustomField>
-      <label>Portion</label>
-      <data_type>String</data_type>
-      <html_type>Text</html_type>
-      <is_required>0</is_required>
-      <is_searchable>0</is_searchable>
-      <is_search_range>0</is_search_range>
-      <weight>11</weight>
-      <is_active>1</is_active>
-      <is_view>0</is_view>
-      <text_length>8</text_length>
-      <date_parts>M:;:;:;d:;:;:;Y</date_parts>
-      <note_columns>60</note_columns>
-      <note_rows>4</note_rows>
-      <column_name>portion</column_name>
-      <custom_group_title>VAN</custom_group_title>
-    </CustomField>
-    <CustomField>
-      <label>Zip5</label>
-      <data_type>String</data_type>
-      <html_type>Text</html_type>
-      <is_required>0</is_required>
-      <is_searchable>1</is_searchable>
-      <is_search_range>0</is_search_range>
-      <weight>12</weight>
-      <is_active>1</is_active>
-      <is_view>0</is_view>
-      <text_length>10</text_length>
-      <date_parts>M:;:;:;d:;:;:;Y</date_parts>
-      <note_columns>60</note_columns>
-      <note_rows>4</note_rows>
-      <column_name>zip5</column_name>
-      <custom_group_title>VAN</custom_group_title>
-    </CustomField>
-  </CustomFields>
-  <OptionGroups>
-    <OptionGroup>
-      <name>party_20090918102033</name>
-      <label>Party</label>
-      <is_active>1</is_active>
-    </OptionGroup>
-  </OptionGroups>
-  <OptionValues>
-    <OptionValue>
-      <label>Declined</label>
-      <value>DS</value>
-      <name>Declined</name>
-      <is_default>0</is_default>
-      <weight>3</weight>
-      <is_optgroup>0</is_optgroup>
-      <is_reserved>0</is_reserved>
-      <is_active>1</is_active>
-      <option_group_label>Party</option_group_label>
-    </OptionValue>
-    <OptionValue>
-      <label>Democrat</label>
-      <value>D</value>
-      <name>Democrat</name>
-      <is_default>0</is_default>
-      <weight>1</weight>
-      <is_optgroup>0</is_optgroup>
-      <is_reserved>0</is_reserved>
-      <is_active>1</is_active>
-      <option_group_label>Party</option_group_label>
-    </OptionValue>
-    <OptionValue>
-      <label>Green</label>
-      <value>G</value>
-      <name>Green</name>
-      <is_default>0</is_default>
-      <weight>4</weight>
-      <is_optgroup>0</is_optgroup>
-      <is_reserved>0</is_reserved>
-      <is_active>1</is_active>
-      <option_group_label>Party</option_group_label>
-    </OptionValue>
-    <OptionValue>
-      <label>Republican</label>
-      <value>R</value>
-      <name>Republican</name>
-      <is_default>0</is_default>
-      <weight>2</weight>
-      <is_optgroup>0</is_optgroup>
-      <is_reserved>0</is_reserved>
-      <is_active>1</is_active>
-      <option_group_label>Party</option_group_label>
-    </OptionValue>
-  </OptionValues>
-</CustomData>
-- 
2.25.1