Mochabomb

Web Design and Technical notes

Mochabomb header image 4

Entries from March 2007

VTiger - sort by custom columns

March 19th, 2007 10:13 pm · 3 Comments

Today I added a custom column to our vtiger install we use at Direct Finance - a custom data field: Loan Purpose. I added this custom field to Accounts, Leads and Contacts and Potentials - then mapped them to eachother (so data was kept as lead was converted).

Now in looking at leads, accounts, or [...]

[Read more →]

Tags: vTiger

Installing vtiger on Dreamhost and Ace-host.net

March 17th, 2007 12:24 am · No Comments

Dreamhost: Had to try a couple times - here is what worked:

my .htaccess file:

# use custom php.ini, but not fcgi
Options +ExecCGI
AddHandler php5-cgi .php
Action php5-cgi /cgi-bin/php5.cgi

If the install failed with “table creation failed”, then wipe out all tables in db, remove vtiger dir and start over with fresh copy of vtiger dir code. [...]

[Read more →]

Tags: Dreamhost · vTiger

Useful software

March 15th, 2007 10:46 pm · No Comments

http://www.squidguard.org/index.html - linux firewall
http://www.ipcop.org/index.php - traffic firewall

[Read more →]

Tags: Uncategorized

Vtiger - add invoice ID to custom view field list

March 15th, 2007 7:03 pm · 1 Comment

Needed to create custom views that included the Invoice ID - seems to make sense.
The user “rexkenley” fixed it and posted here (Thanks!!!)
Just ensure that the field label is blank when inserting this into the vtiger_field table
INSERT INTO `vtiger_field` ( `tabid` , `fieldid` , `columnname` , `tablename` , [...]

[Read more →]

Tags: vTiger

Run shell_exec in Wordpress and Drupal

March 5th, 2007 2:49 am · No Comments

I found this out on accident - use nested includes to use shell_exec in Wordpress and Drupal posts without any issues - I am using the Exec-PHP plugin.
* Tested with Wordpress 2.1.2
* Wordpress: Only works in Blog posts - not in a “page” - the PHP will not work.
* Wordpress: Must use file path, not [...]

[Read more →]

Tags: Drupal · PHP · Wordpress