<!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 >Hi,<br><br>It is a wonderful idea.<br><br>Please have a look at the "Developer Guide" in vtiger Wiki:<br><br>http://wiki.vtiger.com/index.php/Vtiger_CRM_5_Developer_Guide<br><br>So far I have added articles on creating dashboards, related lists, language packs. <span style="font-style: italic;">Thanks to Michel Jacquemes and Richie for their valuable contributions.</span> <br><br>By the way, I have also contributed one of the articles<span class="moz-smiley-s1"><span> :-) </span></span><span style="font-style: italic;"> </span><br><br>Currently I am working with Minnie on "how to create a module in vtiger CRM 5?" article, which will open doors for new developers.<br><br><span style="font-weight: bold;"></span>Regards,<br>Gopal<br><br>---
<br>S.S.G.Gopal
<br>skype: sripadag
<br>ph: +1 877 788 4437
<br>blog: http://gopal.vtiger.com<br><br><br><br><br>---- On Tue, 05 Sep 2006 <b>Dennis Grant <dgrant@accuratetechnologies.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>
> Dear DG,<br><br>> Thank you for giving an opportunity to service you.<br><br>Heh. :)<br><br>The vTiger core team is in India, right? So English is probably a second language for a lot of the team.<br><br>Just FYI, "to service someone" is not the same thing as "to serve someone".<br><br>The correct phrase would be "Thank you for giving us an opportunity to serve you." Or, less formally (given that this is a developers' list and we're all peers here) "Here is the information you requested:"<br><br>I'm not giving you a hard time; you just might want to avoid using a phrase that implies a much more... intimate... relationship than perhaps you wanted. :) :) <br><br>> In vtigerCRM5RC, For 'Quote Information' blockid is 51 and tabid is 20. <br>> you have to write an insert query for each field in <br>> 'modules/Users/DefaultDataPopulator.php' file under //Block51. for eg: <br>> take some field say XYZ, the query is given below<br><br>OK, two quick questions: <br><br>1) What do "blockID" and "tabID" represent?<br><br>2) What is the process for registering new blockids and tabids?<br><br>> $this->db->query("insert into vtiger_field values (20,".$this->db-<br>> >getUniqueID("vtiger_field").",'xyz','vtiger_quotes',<br>> 1,'2','xyz','XYZ',1,0,0,100,1,51,1,'V~M',1,null,'BAS')");<br><br>> In that query, you have take care of each field value. This entry is <br>> applicable for both editview and detailview. <br><br>OK, so looking at the table description:<br><br>+---------------------+--------------+------+-----+---------+<br>| Field | Type | Null | Key | Default |<br>+---------------------+--------------+------+-----+---------+<br>| tabid | int(19) | NO | MUL | | <br>| fieldid | int(19) | NO | PRI | NULL |<br>| columnname | varchar(30) | NO | | | <br>| tablename | varchar(50) | NO | | | <br>| generatedtype | int(19) | NO | | 0 | <br>| uitype | varchar(30) | NO | | | <br>| fieldname | varchar(50) | NO | MUL | | <br>| fieldlabel | varchar(50) | NO | | | <br>| readonly | int(1) | NO | | | <br>| presence | int(19) | NO | | 1 | <br>| selected | int(1) | NO | | | <br>| maximumlength | int(19) | YES | | NULL | <br>| sequence | int(19) | YES | | NULL | <br>| block | int(19) | YES | MUL | NULL | <br>| displaytype | int(19) | YES | MUL | NULL | <br>| typeofdata | varchar(100) | YES | | NULL | <br>| quickcreate | int(10) | NO | | 1 | <br>| quickcreatesequence | int(19) | YES | | NULL | <br>| info_type | varchar(20) | YES | | NULL | <br>+---------------------+--------------+------+-----+---------+<br><br>You did:<br><br>tabid = 20<br>fieldid = ".$this->db->getUniqueID("vtiger_field")."<br>columnname = 'xyz'<br>tablename = 'vtiger_quotes'<br>generatedtype = 1<br>uitype = '2'<br>fieldname = 'xyz'<br>fieldlabel = 'XYZ'<br>readonly = 1<br>presence = 0<br>selected = 0<br>maximumlength = 100<br>sequence = 1<br>block = 51<br>displaytype = 1<br>typeofdata = 'V~M'<br>quickcreate = 1<br>quickcreatesequence = NULL<br>info_type = 'BAS'<br><br>Could you please break these down into what they mean, and (especially for items like uitype) the allowed values and what the values mean?<br><br>When is /Users/DefaultDataPopulator.php executed?<br><br>> I hope this helps you. kindly contact me for further clarifictaions.<br><br>It's a good start - it is nice that vTiger is making a much better effort to work with downstream developers these days; thank you for that.<br><br>Is there a Wiki somewhere where we should be capturing this conversation?<br><br>DG <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>