Skip to content

Instantly share code, notes, and snippets.

@chicks
chicks / greppage.sh
Last active December 11, 2015 06:28
Zend Framework Library Usage in SugarCRM
# grep -R require * | grep -i zend | grep -v '^Zend'
custom/modules/Schedulers/ConnectionsActivityStreamPublisherJob.php: require_once('Zend/Http/client.php');
include/externalAPI/Google/ExtAPIGoogle.php:require_once('Zend/Gdata/Docs.php');
include/externalAPI/Google/ExtAPIGoogle.php:require_once('Zend/Gdata/Docs/Query.php');
include/externalAPI/Google/ExtAPIGoogle.php:require_once('Zend/Gdata/ClientLogin.php');
include/externalAPI/Google/ExtAPIGoogle.php:require_once('Zend/Gdata/Contacts.php');
include/SugarCache/SugarCacheZend.php: * requirements.
include/SugarCache/SugarCacheZend.php:require_once('include/SugarCache/SugarCacheAbstract.php');
include/SugarOauth.php: require_once 'Zend/Oauth/Consumer.php';
modules/OAuthKeys/OAuthKey.php:require_once 'Zend/Oauth/Provider.php';
@chicks
chicks / create_user.rb
Created December 10, 2012 20:59
Example of how to create a SugarCRM User via REST
#! /usr/bin/env ruby
require 'digest/md5'
require 'rubygems'
require 'sugarcrm'
SugarCRM.connect("http://localhost:8888/sugarcrm", "admin", "letmein", :debug => true)
user = SugarCRM::User.new
user.email1 = "[email protected]"
@chicks
chicks / db2_test.php
Last active October 13, 2015 15:48
SugarCRM on DB2
<?php
// Use this to test connectivity to db2. Useful for checking IIS permissions
$database = 'DATABASE=SUGARCRM;HOSTNAME=localhost;PORT=50000;PROTOCOL=TCPIP;UID=db2admin;PWD=Sugar123!;';
$conn = db2_connect($database, '', '');
if ($conn) {
echo "Connection succeeded.";
db2_close($conn);
#! /usr/bin/env ruby
string = "6_7_0-nutmeg-build_fix"
regex = /([0-9])_([0-9])_([0-9])-([^-].*)-([^-].*)/
string =~ regex
puts [$1,$2,$3].join("_") + ("-",$4,".dev").join('')
@chicks
chicks / get_entry.rb
Created October 26, 2012 04:28
SugarCRM REST API Relationship Traversal
get_entry: Request:
{
"session": "c8866a5a2d855a774c5609d45f3a2906",
"module_name": "Opportunities",
"id": "10635fec-bb2e-2260-d8f7-4ffc80aeef8d",
"select_fields": ["id","name","date_entered","date_modified","modified_user_id","modified_by_name","created_by","created_by_name","description","deleted","assigned_user_id","assigned_user_name","team_id","team_set_id","team_count","team_name","opportunity_type","account_name","account_id","campaign_id","campaign_name","lead_source","amount","amount_usdollar","currency_id","currency_name","currency_symbol","date_closed","next_step","sales_stage","probability"],
"link_name_to_fields_array": []
}
get_entry: JSON Response:
@chicks
chicks / gist:3866904
Created October 10, 2012 16:59
Convert an array of hashes into a CSV
array_of_hashes = [{:a => 1, :b => 2}, {:a => 3, :b => 4}]
csv = array_of_hashes.inject([]) {|csv, hash| csv << hash.values.join(",")}
csv.join("\n")
@chicks
chicks / APC Install Instructions
Created September 21, 2012 03:51
Install APC on RHEL 5.5
# Option 1 (from EPEL)
sudo rpm -Uvh http://mirrors.servercentral.net/fedora/epel/5/i386/epel-release-5-4.noarch.rpm
sudo yum install php-pecl-apc
# Option 2 (from PECL), use this if you compiled a custom version of PHP...
sudo yum install php-devel php-pear httpd-devel
sudo pecl install apc
@chicks
chicks / gist:3709839
Created September 12, 2012 20:53
SugarCRM on SLES Baseline Cheat Sheet
#! /bin/bash
pkg=../pkg/sugarshell-SLES-6.2.1.tar.gz
host=$1
key=../files/ibmcloud_imagebuilder_rsa
user=idcuser
ssh="ssh -i $key $user@$host"
chkconfig=/sbin/chkconfig
@chicks
chicks / EmailUI.php
Created July 25, 2012 20:57
Tree Control
///////////////////////////////////////////////////////////////////////
//// FOLDERS & TreeView
$this->smarty->assign('groupUserOptions', $ie->getGroupsWithSelectOptions(array('' => $app_strings['LBL_EMAIL_CREATE_NEW'])));
$tree = $this->getMailboxNodes();
// preloaded folder
$preloadFolder = 'lazyLoadFolder = ';
$focusFolderSerial = $current_user->getPreference('focusFolder', 'Emails');
if(!empty($focusFolderSerial)) {
@chicks
chicks / LoginRequest.json
Created July 24, 2012 23:33
Login request
{
"user_auth": {
"user_name": "admin",
"password": "0d107d09f5bbe40cade3de5c71e9e9b7",
"version": 4
},
"application": "sugarcrm_java"
}