/**
  * Run a CustomData file
  *
  * @param string $xml_file  the CustomData XML file path (absolute path)
  * @return bool
  */
 protected static function executeCustomDataFileByAbsPath($xml_file)
 {
     require_once 'CRM/Utils/Migrate/Import.php';
     $import = new CRM_Utils_Migrate_Import();
     $import->run($xml_file);
     return TRUE;
 }
Example #2
0
 /**
  * Run a CustomData file
  *
  * @param string $relativePath the CustomData XML file path (relative to this extension's dir)
  * @return bool
  */
 public function executeCustomDataFile($relativePath)
 {
     $xml_file = $this->extensionDir . '/' . $relativePath;
     require_once 'CRM/Utils/Migrate/Import.php';
     $import = new CRM_Utils_Migrate_Import();
     $import->run($xml_file);
     return TRUE;
 }
Example #3
0
/**
 * Implementation of hook_civicrm_install
 */
function booking_civicrm_install()
{
    require_once 'CRM/Utils/Migrate/Import.php';
    $import = new CRM_Utils_Migrate_Import();
    $extRoot = dirname(__FILE__) . DIRECTORY_SEPARATOR;
    $op = $extRoot . 'xml' . DIRECTORY_SEPARATOR . 'data' . DIRECTORY_SEPARATOR . 'OptionGroups.xml';
    $import->run($op);
    return _booking_civix_civicrm_install();
}
/**
 * Implementation of hook_civicrm_install
 *
 * @link http://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_install
 */
function gotowebinar_civicrm_install()
{
    #create custom group from xml file
    $extensionDir = dirname(__FILE__) . DIRECTORY_SEPARATOR;
    $customDataXMLFile = $extensionDir . 'auto_install.xml';
    require_once 'CRM/Utils/Migrate/Import.php';
    $import = new CRM_Utils_Migrate_Import();
    $import->run($customDataXMLFile);
    return _gotowebinar_civix_civicrm_install();
}
/**
 * Implementation of hook_civicrm_install
 *
 * @link http://wiki.civicrm.org/confluence/display/CRMDOC/hook_civicrm_install
 */
function pcpteams_civicrm_install()
{
    //create custom group from xml file
    // Create OptionGroup, OptionValues, RelationshipType, CustomGroup and CustomFields
    $extensionDir = dirname(__FILE__) . DIRECTORY_SEPARATOR;
    $customDataXMLFile = $extensionDir . '/xml/CustomGroupData.xml';
    $import = new CRM_Utils_Migrate_Import();
    $import->run($customDataXMLFile);
    //Create Contact Subtype
    $params = array('parent_id' => 3, 'is_active' => 1, 'is_reserved' => 0);
    foreach (array(CRM_Pcpteams_Constant::C_CONTACT_SUB_TYPE_TEAM, CRM_Pcpteams_Constant::C_CONTACTTYPE_IN_MEM, CRM_Pcpteams_Constant::C_CONTACTTYPE_IN_CELEB, CRM_Pcpteams_Constant::C_CONTACTTYPE_BRANCH, CRM_Pcpteams_Constant::C_CONTACTTYPE_PARTNER) as $subTypes) {
        if (!CRM_Core_DAO::getFieldValue('CRM_Contact_DAO_ContactType', $subTypes, 'id', 'name')) {
            $params['name'] = $subTypes;
            $params['label'] = str_replace('_', ' ', $subTypes);
            CRM_Contact_BAO_ContactType::add($params);
        }
    }
    //set foreignkey
    $sql = "ALTER TABLE `civicrm_value_pcp_custom_set`\n  MODIFY `team_pcp_id` int(10) unsigned DEFAULT NULL,\n  ADD CONSTRAINT `FK_civicrm_value_pcp_custom_set_team_pcp_id` FOREIGN KEY (`team_pcp_id`) REFERENCES `civicrm_pcp` (`id`) ON DELETE SET NULL";
    CRM_Core_DAO::executeQuery($sql);
    //set foreignkey for pcp_a_b and pcp_b_a on delete make null
    $alterSql = "ALTER TABLE `civicrm_value_pcp_relationship_set`\n  MODIFY `pcp_a_b` int(10) unsigned DEFAULT NULL, MODIFY `pcp_b_a` int(10) unsigned DEFAULT NULL,\n  ADD CONSTRAINT `FK_civicrm_value_pcp_relationship_set_pcp_a_b` FOREIGN KEY (`pcp_a_b`) REFERENCES `civicrm_pcp` (`id`) ON DELETE SET NULL,\n  ADD CONSTRAINT `FK_civicrm_value_pcp_relationship_set_pcp_b_a` FOREIGN KEY (`pcp_b_a`) REFERENCES `civicrm_pcp` (`id`) ON DELETE SET NULL\n  ";
    CRM_Core_DAO::executeQuery($alterSql);
    //invite team
    $messageHtmlSampleTeamInviteFile = $extensionDir . '/message_templates/msg_tpl_invite_members_to_team.tpl';
    $messageHtml = file_get_contents($messageHtmlSampleTeamInviteFile);
    $message_params['invite_team'] = array('sequential' => 1, 'version' => 3, 'msg_title' => CRM_Pcpteams_Constant::C_MSG_TPL_INVITE_TEAM, 'msg_subject' => (string) '{$inviteeFirstName}  you have been invited to join {$teamName} and support Leukaemia and Lymphoma Research', 'is_default' => 1, 'msg_html' => $messageHtml);
    //join team
    $messageHtmlSampleTeamInviteFile = $extensionDir . '/message_templates/msg_tpl_join_request_to_team.tpl';
    $messageHtml = file_get_contents($messageHtmlSampleTeamInviteFile);
    $message_params['join_team'] = array('sequential' => 1, 'version' => 3, 'msg_title' => CRM_Pcpteams_Constant::C_MSG_TPL_JOIN_REQUEST, 'msg_subject' => (string) '{$userFirstName} {$userlastName} has requested to join Team {$teamName} please authorise', 'is_default' => 1, 'msg_html' => $messageHtml);
    //leave team
    $messageHtmlSampleTeamInviteFile = $extensionDir . '/message_templates/msg_tpl_leave_team.tpl';
    $messageHtml = file_get_contents($messageHtmlSampleTeamInviteFile);
    $message_params['leave_team'] = array('sequential' => 1, 'version' => 3, 'msg_title' => CRM_Pcpteams_Constant::C_MSG_TPL_LEAVE_TEAM, 'msg_subject' => (string) '{$userFirstName} {$userLastName} has decided to leave Team {$teamName}', 'is_default' => 1, 'msg_html' => $messageHtml);
    //decline join request
    $messageHtmlSampleTeamInviteFile = $extensionDir . '/message_templates/msg_tpl_decline_request_to_team.tpl';
    $messageHtml = file_get_contents($messageHtmlSampleTeamInviteFile);
    $message_params['decline_team'] = array('sequential' => 1, 'version' => 3, 'msg_title' => CRM_Pcpteams_Constant::C_MSG_TPL_JOIN_REQ_DECLINE_TEAM, 'msg_subject' => (string) '{$userFirstName} {$userLastName} your request to join {$teamName} has been turned down', 'is_default' => 1, 'msg_html' => $messageHtml);
    //approve join request
    $messageHtmlSampleTeamInviteFile = $extensionDir . '/message_templates/msg_tpl_approve_request_to_team.tpl';
    $messageHtml = file_get_contents($messageHtmlSampleTeamInviteFile);
    $message_params['decline_team'] = array('sequential' => 1, 'version' => 3, 'msg_title' => CRM_Pcpteams_Constant::C_MSG_TPL_JOIN_REQ_APPROVE_TEAM, 'msg_subject' => (string) '{$userFirstName} {$userLastName} your request to join {$teamName} has been approved', 'is_default' => 1, 'msg_html' => $messageHtml);
    $ogId = CRM_Core_DAO::getFieldValue('CRM_Core_DAO_OptionGroup', CRM_Pcpteams_Constant::C_OG_MSG_TPL_WORKFLOW, 'id', 'name');
    foreach ($message_params as $key => $message_param) {
        $opValue = civicrm_api3('OptionValue', 'getsingle', array('version' => 3, 'option_group_id' => $ogId, 'name' => $message_param['msg_title']));
        if ($opValue['id']) {
            $message_param['workflow_id'] = $opValue['id'];
        }
        $result = civicrm_api3('MessageTemplate', 'create', $message_param);
    }
    return _pcpteams_civix_civicrm_install();
}
/**
 * Implementation of hook_civicrm_install
 */
function civigiftaid_civicrm_install()
{
    require_once 'CRM/Utils/Migrate/Import.php';
    $import = new CRM_Utils_Migrate_Import();
    $extRoot = dirname(__FILE__) . DIRECTORY_SEPARATOR;
    $op = $extRoot . 'xml' . DIRECTORY_SEPARATOR . 'data' . DIRECTORY_SEPARATOR . 'CustomGroupData.xml';
    $import->run($op);
    // rebuild the menu so our path is picked up
    require_once 'CRM/Core/Invoke.php';
    CRM_Core_Invoke::rebuildMenuAndCaches();
    return _civigiftaid_civix_civicrm_install();
}
 /**
  * Example: Run a slow upgrade process by breaking it up into smaller chunk
  *
  * @return TRUE on success
  * @throws Exception
  */
 public function upgrade_11()
 {
     $this->ctx->log->info('Applying update v1.1');
     // PEAR Log interface
     require_once 'CRM/Utils/Migrate/Import.php';
     $import = new CRM_Utils_Migrate_Import();
     // Import custom data (flag to process DM sync) for contribution
     $file = 'xml' . DIRECTORY_SEPARATOR . 'Upgrade' . DIRECTORY_SEPARATOR . 'v1.1.xml';
     $xmlFilepath = CRM_Core_Resources::singleton()->getPath('uk.co.vedaconsulting.module.dotmailer', $file);
     $import->run($xmlFilepath);
     return TRUE;
 }
Example #8
0
/**
 *
 * @package CRM
 * @copyright CiviCRM LLC (c) 2004-2014
 * $Id$
 *
 */
function run()
{
    session_start();
    if (!array_key_exists('file', $_GET) || empty($_GET['file'])) {
        echo "Please send an input file to import<p>";
        exit;
    }
    require_once '../../civicrm.config.php';
    require_once 'CRM/Core/Config.php';
    $config = CRM_Core_Config::singleton();
    // this does not return on failure
    CRM_Utils_System::authenticateScript(TRUE);
    require_once 'CRM/Utils/Migrate/Import.php';
    $import = new CRM_Utils_Migrate_Import();
    $import->run($_GET['file']);
    echo "Import Done!";
}
 /**
  * @param $customGroupParams
  * @param $fieldParams
  * @param $expectedXmlFilePath
  * @dataProvider basicXmlTestCases
  */
 function testBasicXMLImports($expectCustomGroup, $expectCustomField, $inputXmlFilePath)
 {
     $this->assertDBQuery(0, 'SELECT count(*) FROM civicrm_custom_group WHERE title = %1', array(1 => array($expectCustomGroup['title'], 'String')));
     $importer = new CRM_Utils_Migrate_Import();
     $importer->run($inputXmlFilePath);
     $customGroups = $this->callAPISuccess('custom_group', 'get', array('title' => $expectCustomGroup['title']));
     $this->assertEquals(1, $customGroups['count']);
     $customGroup = array_shift($customGroups['values']);
     foreach ($expectCustomGroup as $expectKey => $expectValue) {
         $this->assertEquals($expectValue, $customGroup[$expectKey]);
     }
     $customFields = $this->callAPISuccess('custom_field', 'get', array('label' => $expectCustomField['label']));
     $this->assertEquals(1, $customFields['count']);
     $customField = array_shift($customFields['values']);
     foreach ($expectCustomField as $expectKey => $expectValue) {
         $this->assertEquals($expectValue, $customField[$expectKey]);
     }
 }
Example #10
0
/**
 * Implementation of hook_civicrm_postInstall
 *
 * Note: This hook only runs in CiviCRM 4.4+.
 */
function hrcase_civicrm_postInstall()
{
    //disable example case types
    hrcase_example_caseType(FALSE);
    // Import custom group
    require_once 'CRM/Utils/Migrate/Import.php';
    $import = new CRM_Utils_Migrate_Import();
    $files = glob(__DIR__ . '/xml/*_customGroupCaseType.xml');
    if (is_array($files)) {
        foreach ($files as $file) {
            $import->run($file);
        }
    }
    $scheduleActions = hrcase_getActionsSchedule();
    foreach ($scheduleActions as $actionName => $scheduleAction) {
        $result = civicrm_api3('action_schedule', 'get', array('name' => $actionName));
        if (empty($result['id'])) {
            $result = civicrm_api3('action_schedule', 'create', $scheduleAction);
        }
    }
}
Example #11
0
 protected static function _populateDB($perClass = FALSE, &$object = NULL)
 {
     if (!parent::_populateDB($perClass, $object)) {
         return FALSE;
     }
     //populate vacancy_status of type Application
     $result = civicrm_api3('OptionGroup', 'create', array('name' => 'vacancy_status', 'title' => ts('Vacancy Status'), 'is_reserved' => 1, 'is_active' => 1));
     $vacancyStatus = array('Draft' => ts('Draft'), 'Open' => ts('Open'), 'Closed' => ts('Closed'), 'Cancelled' => ts('Cancelled'), 'Rejected' => ts('Rejected'));
     $weight = 1;
     foreach ($vacancyStatus as $name => $label) {
         $statusParam = array('option_group_id' => $result['id'], 'label' => $label, 'name' => $name, 'value' => $weight++, 'is_active' => 1);
         if ($name == 'Draft') {
             $statusParam['is_default'] = 1;
         } elseif ($name == 'Open') {
             $statusParam['is_reserved'] = 1;
         }
         civicrm_api3('OptionValue', 'create', $statusParam);
     }
     $import = new CRM_Utils_Migrate_Import();
     $import->run(CRM_Extension_System::singleton()->getMapper()->keyToBasePath('org.civicrm.hrrecruitment') . '/xml/auto_install.xml');
     return TRUE;
 }
Example #12
0
/**
 * Helper function to load data into DB between iterations of the unit-test
 */
function _hrjob_phpunit_populateDB()
{
    $import = new CRM_Utils_Migrate_Import();
    $import->run(CRM_Extension_System::singleton()->getMapper()->keyToBasePath('org.civicrm.hrjob') . '/xml/option_group_install.xml');
    $import->run(CRM_Extension_System::singleton()->getMapper()->keyToBasePath('org.civicrm.hrjob') . '/xml/job_summary_install.xml');
    //create option value for option group region
    $result = civicrm_api3('OptionGroup', 'get', array('name' => "hrjob_region"));
    $regionVal = array('Asia' => ts('Asia'), 'Europe' => ts('Europe'));
    foreach ($regionVal as $name => $label) {
        $regionParam = array('option_group_id' => $result['id'], 'label' => $label, 'name' => $name, 'value' => $name, 'is_active' => 1);
        civicrm_api3('OptionValue', 'create', $regionParam);
    }
}
Example #13
0
 public function executeCustomDataTemplateFile($relativePath)
 {
     $smarty = CRM_Core_Smarty::singleton();
     $xmlCode = $smarty->fetch($relativePath);
     //x dpm($xmlCode);
     $xml = simplexml_load_string($xmlCode);
     require_once 'CRM/Utils/Migrate/Import.php';
     $import = new CRM_Utils_Migrate_Import();
     $import->runXmlElement($xml);
     return TRUE;
 }
Example #14
0
/**
 * Helper function to load data into DB between iterations of the unit-test
 */
function _hrvisa_phpunit_populateDB()
{
    $import = new CRM_Utils_Migrate_Import();
    $import->run(CRM_Extension_System::singleton()->getMapper()->keyToBasePath('org.civicrm.hrvisa') . '/xml/auto_install.xml');
    // this had to be done as demographics consists of is_visa_required field (used in unit test)
    $import->run(CRM_Extension_System::singleton()->getMapper()->keyToBasePath('org.civicrm.hrdemog') . '/xml/auto_install.xml');
}
Example #15
0
/**
 * Helper function to load data into DB between iterations of the unit-test
 */
function _hrrecruitment_phpunit_populateDB()
{
    //populate vacancy_status and case_status of type Application
    $result = civicrm_api3('OptionGroup', 'create', array('name' => 'vacancy_status', 'title' => ts('Vacancy Status'), 'is_reserved' => 1, 'is_active' => 1));
    $vacancyStatus = array('Draft' => ts('Draft'), 'Open' => ts('Open'), 'Closed' => ts('Closed'), 'Cancelled' => ts('Cancelled'), 'Rejected' => ts('Rejected'));
    $weight = 1;
    foreach ($vacancyStatus as $name => $label) {
        $statusParam = array('option_group_id' => $result['id'], 'label' => $label, 'name' => $name, 'value' => $weight++, 'is_active' => 1);
        if ($name == 'Draft') {
            $statusParam['is_default'] = 1;
        } elseif ($name == 'Open') {
            $statusParam['is_reserved'] = 1;
        }
        civicrm_api3('OptionValue', 'create', $statusParam);
    }
    $stages = array('Apply' => ts('Apply'), 'Ongoing_Vacancy' => ts('Ongoing'), 'Phone_Interview' => ts('Phone Interview'), 'Manager_Interview' => ts('Manager Interview'), 'Board_Interview' => ts('Board Interview'), 'Group_Interview' => ts('Group Interview'), 'Psych_Exam' => ts('Psych Exam'), 'Offer' => ts('Offer'), 'Hired' => ts('Hired'));
    $count = count(CRM_Core_OptionGroup::values('case_status'));
    foreach ($stages as $name => $label) {
        $count++;
        $caseStatusParam = array('option_group_id' => 'case_status', 'label' => $label, 'name' => $name, 'value' => $count, 'grouping' => 'Vacancy', 'filter' => 1);
        civicrm_api3('OptionValue', 'create', $caseStatusParam);
    }
    $import = new CRM_Utils_Migrate_Import();
    $import->run(CRM_Extension_System::singleton()->getMapper()->keyToBasePath('org.civicrm.hrrecruitment') . '/xml/auto_install.xml');
}
 /**
  * Run a CustomData file
  *
  * @param string $xml_file  the CustomData XML file path (absolute path)
  * @return bool
  */
 protected static function executeCustomDataFileByAbsPath($xml_file)
 {
     $import = new CRM_Utils_Migrate_Import();
     $import->run($xml_file);
     return TRUE;
 }