'import' => true,
'where' => 'civicrm_contact.do_not_email',
'headerPattern' => '/d(o )?(not )?(email)/i',
- 'dataPattern' => '/^\d{1,}$/',
+ 'dataPattern' => '/^\\d{1,}$/',
'export' => true,
),
'do_not_phone' => array(
'import' => true,
'where' => 'civicrm_contact.do_not_phone',
'headerPattern' => '/d(o )?(not )?(call|phone)/i',
- 'dataPattern' => '/^\d{1,}$/',
+ 'dataPattern' => '/^\\d{1,}$/',
'export' => true,
),
'do_not_mail' => array(
'title' => 'Do Not Mail',
'import' => true,
'where' => 'civicrm_contact.do_not_mail',
- 'headerPattern' => '/^(d(o\s)?n(ot\s)?mail)|(\w*)?bulk\s?(\w*)$/i',
- 'dataPattern' => '/^\d{1,}$/',
+ 'headerPattern' => '/^(d(o\\s)?n(ot\\s)?mail)|(\\w*)?bulk\\s?(\\w*)$/i',
+ 'dataPattern' => '/^\\d{1,}$/',
'export' => true,
),
'do_not_sms' => array(
'import' => true,
'where' => 'civicrm_contact.do_not_sms',
'headerPattern' => '/d(o )?(not )?(sms)/i',
- 'dataPattern' => '/^\d{1,}$/',
+ 'dataPattern' => '/^\\d{1,}$/',
'export' => true,
),
'do_not_trade' => array(
'import' => true,
'where' => 'civicrm_contact.do_not_trade',
'headerPattern' => '/d(o )?(not )?(trade)/i',
- 'dataPattern' => '/^\d{1,}$/',
+ 'dataPattern' => '/^\\d{1,}$/',
'export' => true,
),
'is_opt_out' => array(
'size' => 20,
'import' => true,
'where' => 'civicrm_contact.legal_identifier',
- 'headerPattern' => '/legal\s?id/i',
- 'dataPattern' => '/\w+?\d{5,}/',
+ 'headerPattern' => '/legal\\s?id/i',
+ 'dataPattern' => '/\\w+?\\d{5,}/',
'export' => true,
),
'external_identifier' => array(
'size' => 8,
'import' => true,
'where' => 'civicrm_contact.external_identifier',
- 'headerPattern' => '/external\s?id/i',
- 'dataPattern' => '/^\d{11,}$/',
+ 'headerPattern' => '/external\\s?id/i',
+ 'dataPattern' => '/^\\d{11,}$/',
'export' => true,
),
'sort_name' => array(
'size' => 30,
'import' => true,
'where' => 'civicrm_contact.nick_name',
- 'headerPattern' => '/n(ick\s)name|nick$/i',
- 'dataPattern' => '/^\w+$/',
+ 'headerPattern' => '/n(ick\\s)name|nick$/i',
+ 'dataPattern' => '/^\\w+$/',
'export' => true,
),
'legal_name' => array(
'size' => 30,
'import' => true,
'where' => 'civicrm_contact.legal_name',
- 'headerPattern' => '/^legal|(l(egal\s)?name)$/i',
+ 'headerPattern' => '/^legal|(l(egal\\s)?name)$/i',
'export' => true,
),
'image_URL' => array(
'size' => 45,
'import' => true,
'where' => 'civicrm_contact.preferred_communication_method',
- 'headerPattern' => '/^p(ref\w*\s)?c(omm\w*)|( meth\w*)$/i',
- 'dataPattern' => '/^\w+$/',
+ 'headerPattern' => '/^p(ref\\w*\\s)?c(omm\\w*)|( meth\\w*)$/i',
+ 'dataPattern' => '/^\\w+$/',
'export' => true,
'pseudoconstant' => array(
'optionGroupName' => 'preferred_communication_method',
'title' => 'Preferred Mail Format',
'import' => true,
'where' => 'civicrm_contact.preferred_mail_format',
- 'headerPattern' => '/^p(ref\w*\s)?m(ail\s)?f(orm\w*)$/i',
+ 'headerPattern' => '/^p(ref\\w*\\s)?m(ail\\s)?f(orm\\w*)$/i',
'export' => true,
'default' => 'Both',
'enumValues' => 'Text, HTML, Both',
'size' => 30,
'import' => true,
'where' => 'civicrm_contact.first_name',
- 'headerPattern' => '/^first|(f(irst\s)?name)$/i',
- 'dataPattern' => '/^\w+$/',
+ 'headerPattern' => '/^first|(f(irst\\s)?name)$/i',
+ 'dataPattern' => '/^\\w+$/',
'export' => true,
),
'middle_name' => array(
'size' => 20,
'import' => true,
'where' => 'civicrm_contact.middle_name',
- 'headerPattern' => '/^middle|(m(iddle\s)?name)$/i',
- 'dataPattern' => '/^\w+$/',
+ 'headerPattern' => '/^middle|(m(iddle\\s)?name)$/i',
+ 'dataPattern' => '/^\\w+$/',
'export' => true,
),
'last_name' => array(
'size' => 30,
'import' => true,
'where' => 'civicrm_contact.last_name',
- 'headerPattern' => '/^last|(l(ast\s)?name)$/i',
- 'dataPattern' => '/^\w+(\s\w+)?+$/',
+ 'headerPattern' => '/^last|(l(ast\\s)?name)$/i',
+ 'dataPattern' => '/^\\w+(\\s\\w+)?+$/',
'export' => true,
),
'prefix_id' => array(
'import' => true,
'where' => 'civicrm_contact.prefix_id',
'headerPattern' => '/^(prefix|title)/i',
- 'dataPattern' => '/^(mr|ms|mrs|sir|dr)\.?$/i',
+ 'dataPattern' => '/^(mr|ms|mrs|sir|dr)\\.?$/i',
'export' => true,
'pseudoconstant' => array(
'optionGroupName' => 'individual_prefix',
'import' => true,
'where' => 'civicrm_contact.suffix_id',
'headerPattern' => '/^suffix$/i',
- 'dataPattern' => '/^(sr|jr)\.?|i{2,}$/',
+ 'dataPattern' => '/^(sr|jr)\\.?|i{2,}$/',
'export' => true,
'pseudoconstant' => array(
'optionGroupName' => 'individual_suffix',
'size' => 20,
'import' => true,
'where' => 'civicrm_contact.job_title',
- 'headerPattern' => '/^job|(j(ob\s)?title)$/i',
+ 'headerPattern' => '/^job|(j(ob\\s)?title)$/i',
'dataPattern' => '//',
'export' => true,
),
'title' => 'Birth Date',
'import' => true,
'where' => 'civicrm_contact.birth_date',
- 'headerPattern' => '/^birth|(b(irth\s)?date)|D(\W*)O(\W*)B(\W*)$/i',
- 'dataPattern' => '/\d{4}-?\d{2}-?\d{2}/',
+ 'headerPattern' => '/^birth|(b(irth\\s)?date)|D(\\W*)O(\\W*)B(\\W*)$/i',
+ 'dataPattern' => '/\\d{4}-?\\d{2}-?\\d{2}/',
'export' => true,
),
'is_deceased' => array(
'title' => 'Is Deceased',
'import' => true,
'where' => 'civicrm_contact.is_deceased',
- 'headerPattern' => '/i(s\s)?d(eceased)$/i',
+ 'headerPattern' => '/i(s\\s)?d(eceased)$/i',
'export' => true,
),
'deceased_date' => array(
'title' => 'Deceased Date',
'import' => true,
'where' => 'civicrm_contact.deceased_date',
- 'headerPattern' => '/^deceased|(d(eceased\s)?date)$/i',
+ 'headerPattern' => '/^deceased|(d(eceased\\s)?date)$/i',
'export' => true,
),
'household_name' => array(
'size' => 30,
'import' => true,
'where' => 'civicrm_contact.household_name',
- 'headerPattern' => '/^household|(h(ousehold\s)?name)$/i',
- 'dataPattern' => '/^\w+$/',
+ 'headerPattern' => '/^household|(h(ousehold\\s)?name)$/i',
+ 'dataPattern' => '/^\\w+$/',
'export' => true,
),
'primary_contact_id' => array(
'size' => 30,
'import' => true,
'where' => 'civicrm_contact.organization_name',
- 'headerPattern' => '/^organization|(o(rganization\s)?name)$/i',
- 'dataPattern' => '/^\w+$/',
+ 'headerPattern' => '/^organization|(o(rganization\\s)?name)$/i',
+ 'dataPattern' => '/^\\w+$/',
'export' => true,
),
'sic_code' => array(
'size' => 8,
'import' => true,
'where' => 'civicrm_contact.sic_code',
- 'headerPattern' => '/^sic|(s(ic\s)?code)$/i',
+ 'headerPattern' => '/^sic|(s(ic\\s)?code)$/i',
'export' => true,
),
'user_unique_id' => array(
'size' => 45,
'import' => true,
'where' => 'civicrm_contact.user_unique_id',
- 'headerPattern' => '/^Open\s?ID|u(niq\w*)?\s?ID/i',
- 'dataPattern' => '/^[\w\/\:\.]+$/',
+ 'headerPattern' => '/^Open\\s?ID|u(niq\\w*)?\\s?ID/i',
+ 'dataPattern' => '/^[\\w\\/\\:\\.]+$/',
'export' => true,
'rule' => 'url',
),
'type' => 256,
'title' => 'Created Date',
'required' => '',
- 'default' => 'UL',
+ 'default' => 'NULL',
),
'modified_date' => array(
'name' => 'modified_date',
'type' => 256,
'title' => 'Modified Date',
'required' => '',
- 'default' => 'URRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAM',
+ 'default' => 'CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP',
),
'source' => array(
'name' => 'source',
'size' => 30,
'import' => true,
'where' => 'civicrm_contact.source',
- 'headerPattern' => '/(S(ource\s)?o(f\s)?C(ontact\s)?Data)$/i',
+ 'headerPattern' => '/(S(ource\\s)?o(f\\s)?C(ontact\\s)?Data)$/i',
'export' => true,
'uniqueName' => 'contact_source',
),
'date_format' => '',
'time_format' => '',
'name' => 'custom_1',
+ 'type' => 2,
'options' => array(
'1' => 'Label1',
'2' => 'Label2',
'current_employer' => array(
'title' => 'Current Employer',
'description' => 'Name of Current Employer',
+ 'type' => 2,
),
'dupe_check' => array(
'title' => 'Check for Duplicates',
* This example has been generated from the API test suite. The test that created it is called
*
* testCustomFieldCreateWithOptionValues and can be found in
-* http://svn.civicrm.org/civicrm/trunk/tests/phpunit/CiviTest/api/v3/ContactTest.php
+* https://github.com/civicrm/civicrm-core/blob/master/tests/phpunit/api/v3/ContactTest.php
*
* You can see the outcome of the API tests at
-* http://tests.dev.civicrm.org/trunk/results-api_v3
+* https://test.civicrm.org/job/CiviCRM-master-git/
*
* To Learn about the API read
-* http://book.civicrm.org/developer/current/techniques/api/
+* http://wiki.civicrm.org/confluence/display/CRMDOC/Using+the+API
*
-* and review the wiki at
-* http://wiki.civicrm.org/confluence/display/CRMDOC/CiviCRM+Public+APIs
+* Browse the api on your own site with the api explorer
+* http://MYSITE.ORG/path/to/civicrm/api/explorer
*
* Read more about testing here
* http://wiki.civicrm.org/confluence/display/CRM/Testing
*
* API Standards documentation:
* http://wiki.civicrm.org/confluence/display/CRM/API+Architecture+Standards
-*/
\ No newline at end of file
+*/