CiviCRM « Statler's Rogue Valley Views

Archive for the ‘CiviCRM’ Category

civiCASE customization

Friday, December 19th, 2014

Address appearance

Show a line for c/o or other info below the contact.addressee:

In civiCRM go to administer/localization/address settings
Move {contact.supplemental_address_1} to below {contact.addressee}
Do that for both Mailing Label Format and for Display Format

Posted in CiviCRM, General | Comments Closed

civiCASE apis and running php from command line

Thursday, December 18th, 2014

Open terminal as super user [su]

php /var/www/drupal/sites/all/modules/contrib/civicrm/bin/cli.php -e /var/www/drupal/sites/all/modules/contrib/civicrm/bin/csv/export.php contact -e contact -a get –output –contact_id=2

or, if already in the civicrm/bin directory:
cd /var/www/drupal/sites/all/modules/contrib/civicrm/bin/
php cli.php -e ../bin/csv/export.php contact -e contact -a get –output –contact_id=2

===================

following are notes that got me to this

===========

To run php code on a web site like civiCRM use the cURL program on linux.

First, civiCRM needs a site key.

Run the following in a command prompt
php -r ‘echo md5(uniqid(rand(), true)) . “\n”;’
highlight the result and right-click copy
Navigate to, as administrator,
/var/www/drupal/sites/default
open civicrm.settings.php
search for CIVICRM_SITE_KEY
Paste the result you copied into the appropriate place, as indicated by xxx’s below
define( ‘CIVICRM_SITE_KEY’, ‘xxxxxxxxxxxxxxxxxxx’ );
save the file
Save that site key somewhere safe for future use
Now you have a site key

Get cURL
sudo apt-get install curl

Test cURL by finding the definition of ‘bash’
curl dict://dict.org/d:bash

The key php file I need is for uploading csv text file data transferring from another system to civiCASE.

I found the basic import/export/delete php files in:
/var/www/drupal/sites/all/modules/contrib/civicrm/bin/csv

/**
* Import records from a csv file passed as an argument.
*
* Usage:
* php bin/csv/import.php -e <entity> –file /path/to/csv/file [ -s site.org ]
* e.g.: php bin/csv/import.php -e Contact –file /tmp/import.csv
*
**/

From http://wiki.civicrm.org/confluence/display/CRMDOC/Using+the+API

The API explorer, which is available at http://[CIVICRM_URL]/civicrm/api/explorer (or http://[CIVICRM_URL]/?q=civicrm/api/explorer if you do not use clean URLs in Drupal). This gives you the possibility to actually try out the API in action.

http://localhost/?q=civicrm/api/explorer

The API parameter list, which shows all available entities which can be manipulated by the API and is available at http://[CIVICRM_URL]/civicrm/api/doc (or http://[CIVICRM_URL]/?q=civicrm/api/doc if you do not use clean URLs in Drupal)

http://localhost/?q=civicrm/api/doc

Api examples: https://github.com/civicrm/civicrm-core/tree/master/api/v3/examples
This included an example for creating a case with php.

Some handy examples:
http://www.thegeekstuff.com/2012/04/curl-examples/
An example from civiCRM
http://wiki.civicrm.org/confluence/display/CRMDOC40/Update+Greetings+and+Address+Data+for+Contacts
And the civiCRM command-line reference page
http://wiki.civicrm.org/confluence/display/CRMDOC40/Command-line+Script+Configuration

Posted in CiviCRM, General, Linux | Comments Closed

CiviCRM import and export APIs

Tuesday, December 16th, 2014

To import data into CiviCRM, the easiest way is through APIs.

API calls require both a site key and a user API key.

The site key is at:

To create a user API key it is easier to install a civiCRM extension

Create a directory for civiCRM extensions
/var/www/drupal/sites/default/files/civicrm/custom_ext
make sure it is writable by the civicrm system
In my case it is writable by user civicrm
Import the civiCRM

/var/www/drupal/sites/all/modules/contrib/civicrm/api/v3/Group.php to create groups

http://wiki.civicrm.org/confluence/display/CRMDOC/REST+interface#RESTinterface-CreatingAPIkeysforusers

http://wiki.civicrm.org/confluence/display/CRMDOC/Extensions

http://10.0.0.27/index.php?q=civicrm/api/explorer#/index.php?q=civicrm/ajax/rest&entity=Group&action=create&debug=1&sequential=1&json=1&title=Test&description=test+group&visibility=User+and+User+Admin+Only&is_hidden=0&created_id=2&is_reserved=1

http://10.0.0.27/index.php?q=civicrm/api/explorer#explorer

http://wiki.civicrm.org/confluence/display/CRMDOC/Bootstrap+Reference

http://wiki.civicrm.org/confluence/display/CRMDOC/Using+the+API

Posted in CiviCRM, General | Comments Closed