[Vtigercrm-developers] Adding a new Activity Type

Callum Macdonald lists.vtigercrm.com at callum-macdonald.com
Thu Dec 21 18:35:12 PST 2006

Hey Guys,

We're making a couple of mods to vtiger to add some custom mail merging 
stuff. For anyone interested, the solution we're using is to use 
Microsoft Word (we'd prefer to use OpenOffice, but that's another story) 
and merging directly against a MySQL database. So the mod to vtiger 
exports the required data to a new table in another database, and then 
our word processor merges against that directly. It's not without 
complications, but it delivers a very powerful solution.

Anyway, my question is about activity types. I've added an activity type 
called Mail Merge in the vtiger_activitytypes table, but when I manually 
change an activity type in the table vtiger_activity, it disappears from 
the Contact's view.

I'm assuming the Call and Meeting activity types are hard coded. Can 
anyone shed any light on how we'd go about modifying this to add a new 
activity type? With my limited knowledge I'd guess we need to:
1) Find and update all queries that explicitly use Call or Meeting
2) Modify the smarty views for that field to add the new types to the 

Is there anything I'm missing?

Any feedback or suggestions most appreciated.



More information about the vtigercrm-developers mailing list