<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta content="text/html;charset=UTF-8" http-equiv="Content-Type"></head><body >
Dear joebordes,<br>
<br>
I apologize for delay in reply. <br>
<br>
Here is the information you requested:<br>
<br>
Following changes should be done in <span style="font-weight: bold;">modules/Users/DefaultDataPopulator.php</span> files.<br>
<br>
1) To insert into vtiger_tab table<br>
use value greater than 29 for tabid. values from 1 to 29 already occupied for modules in vtigerCRM. <br>
<span style="font-weight: bold;">Syntax:</span>
$this->db->query("INSERT INTO vtiger_tab VALUES
(<tabid>,'<name>',<presence>,<tabsequence>,'<tablabel>',<modifiedby>,<modifiedtime>,<customized>)");<br>
<br>
<span style="font-weight: bold;"> Example:</span> $this->db->query("INSERT INTO vtiger_tab VALUES (7,'Leads',0,4,'Leads',null,null,1)");<br>
[example given with respect to Leads module.]<br>
<br>
2) To insert into vtiger_blocks table<br>
use value greater than 83 for blockid. values from 1 to 83 are already occupied.<br>
Syntax: $this->db->query("insert into vtiger_blocks values <br>
(<blockid>,<tabid>,'<blocklabel>',<sequence>,<show_title
>,<visible>,<create_view>,<edit_view>,<detail_view>)");<br>
<br>
<span style="font-weight: bold;">Example: </span> $this->db->query("insert into vtiger_blocks values (13,7,'LBL_LEAD_INFORMATION',1,0,0,0,0,0)");<br><br>
3) To insert into vtiger_field table<br>
value for fieldid will be generated dynamically using getUniqueID method of PearDataBase class. <br>
<span style="font-weight: bold;">Syntax: </span>$this->db->query("insert into vtiger_field values<br>
(<tabid>,<fieldid>,<columnname>,<tablename>,<generatedtype>,<uitype>,<fieldname>,<fieldlabel>,
<br>
<readonly>,<presence>,<selected>,<maximumlength>,<sequence>,<block>,<displaytype>,<typeofdata
>,<br>
<quickcreate>,<quickcreatesequence>,<info_type>)");<br>
<br>
<span style="font-weight: bold;">Example: </span>$this->db->query("insert into vtiger_field values<br>
(7,".$this->db->getUniqueID("vtiger_field").",'salutation','vtiger_leaddetails',1,'55','salutationtype',<br>
'Salutation',1,0,0,100,1,13,3,'V~O',1,null,'BAS')");<br>
<br>
<br>
This is a small part in module creation. As you asked about block,tab and
field id, I've given that. kindly wait for some time to get full
documentation for module creation. We will provide it soon.<br>
<br>
If you have any query or any difficulty in the above statements, kindly feel free to mail me(email address: minnie@vtiger.com)<br>
<br>
Thanks & Regards,<br>
Minnie.<br><br>---- On Thu, 07 Sep 2006 <b>Joe Bordes <joe@tsolucio.com></b> wrote ---- <br><br><blockquote style="border-left: 1px solid rgb(160, 154, 255); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div>
Hi All,<br><br>I asked a question on the forum a few days ago but nobody answered. The<br>thread is:<br><br><a href="http://forums.vtiger.com/viewtopic.php?t=9516">http://forums.vtiger.com/viewtopic.php?t=9516</a><br><br>It is about what numbers I should use when adding vtiger_block,<br>vtiger_tab and vtiger_field. Do I just invent whatever numbers I want<br>and hope they don't clobber/get clobberd? Or is there somewhere I can<br>get my own "reserved" numbers?<br><br>I'm asking because I just let out a patch to a project on the forge that<br>has this problem. Or I make an install script for the project and<br>generate te numbers dinamically so they can adapt to each installation<br>or I used some reserved numbers.<br><br>Please put me in the right direction.<br><br>Thanks, Joe.<br><br>BTW: If anybody has some time to test the project, all feedback is<br>welcome (tsolucio::tttimecards).<br><br>_______________________________________________<br>Get started with creating presentations online - <a href="http://zohoshow.com?vt">http://zohoshow.com?vt</a> <br>
</div>
</blockquote></body></html>