<!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 DG,<br>
<br>
Thank you for giving an opportunity to service you.<br>
<br>
In vtigerCRM5RC, For 'Quote
Information' blockid is 51 and tabid is 20. you have to write an
insert query for each field in '<span style="font-weight: bold;">modules/Users/DefaultDataPopulator.php</span>' file under <span style="color: rgb(0, 102, 255);">//Block51</span>. for eg: take some field say XYZ, the query is given below<br>
<br>
<span style="color: rgb(255, 0, 255);">$this->db->query("insert
into vtiger_field values
(20,".$this->db->getUniqueID("vtiger_field").",'xyz','vtiger_quotes',</span><br style="color: rgb(255, 0, 255);">
<span style="color: rgb(255, 0, 255);">1,'2','xyz','XYZ',1,0,0,100,1,51,1,'V~M',1,null,'BAS')");<br>
<br>
<span style="color: rgb(0, 0, 0);">In that query, you have take care of each field value. This entry is applicable for both editview and detailview. <br>
<br>
I hope this helps you. kindly contact me for further clarifictaions.<br>
<br>
Thanks & Regards,<br>
Minnie. </span><br>
</span><br><br>---- On Fri, 01 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 link="blue" vlink="blue">
<div class="Section1">
<div>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">As part of my project to port the features
from our fork of V4.2 to V5.0, I find I need to add some new fields to various
modules.</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">What I did in my fork (brace yourselves,
this is horribly ugly) was to create the new fields as a custom field, and then
hardcode the name of the custom field into whatever module needed that info.</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">That works for a local fork, but it is
utterly unacceptable for anything I want to have incorporated into the main vTiger
trunk – not to mention that it’s just ugly hackery.</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">So then, assume I want to add a new field
to a Quote; a checkbox Boolean value.</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">I know the field must be added to the
database schema; I know how to do that.</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">But where is the proper place to add this
field so that it shows up in the “Quote Information” block on DetailView and
EditView?</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">I’d really appreciate a little help here.</span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;"> </span></font></p>
<p class="MsoNormal"><font color="navy" face="Arial" size="2"><span style="font-size: 10pt; font-family: Arial; color: navy;">DG </span></font></p>
</div>
</div>
</div>
_______________________________________________<br>Get started with creating presentations online - <a href="http://zohoshow.com?vt" target="_blank">http://zohoshow.com?vt</a> <br></blockquote></body></html>