hi alan,<br><br>looks like migration is handling the cases that is why this is happening.<br><br>with respect presence value, the valid values are 0,1 and 2 which are interpreted as always visible, hidden and user controlled visible by default respectively.<br>
<br>Regards,<br>MAK<br><br><div class="gmail_quote">On Thu, Nov 18, 2010 at 2:14 PM, Alan Lord (News) <span dir="ltr"><<a href="mailto:alanslists@gmail.com">alanslists@gmail.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
Hi all,<br>
<br>
We've been doing a bit of consulting for a business which has a rather<br>
old, but large, vtiger system built/hacked by a company called OnTAP.<br>
<br>
It looks like it was based on a vtiger 4.x version.<br>
<br>
Our client has software engineering skills in house and they have<br>
successfully migrated most, if not all, of their data into a clean<br>
vtiger 5.2 installation. :-)<br>
<br>
One thing came up yesterday however when we looked at the custom fields<br>
which they'd migrated...<br>
<br>
On the old database these fields had the "presence" value set to 0 and<br>
all seemed to work fine from a user's and an admin perspective.<br>
<br>
On vtiger 5.2, these fields (especially picklists) were "not available"<br>
to users but were if you logged in as admin. Also, in the module<br>
manager, when editing a custom field, the "active" checkbox is greyed<br>
out (yet looks to be ticked) but you can't edit it; even as admin.<br>
<br>
Creating a new custom field in 5.2 the only difference I could see is<br>
the value of the presence field in the vtiger_field table.<br>
<br>
The old ones all had it set to "0". The new one we created set it to "2".<br>
<br>
Can someone explain what this field is for and what the values indicate?<br>
I assume that this value's meaning has changed over time too, as on<br>
their old vtiger system they all appear to be set to "0" but work fine.<br>
<br>
Cheers<br>
<br>
Al<br>
<br>
PS: I noted the comment on the wiki here<br>
<a href="http://wiki.vtiger.com/index.php/Creating_New_Fields_in_Existing_Modules" target="_blank">http://wiki.vtiger.com/index.php/Creating_New_Fields_in_Existing_Modules</a><br>
but it doesn't mention a value of "2". (Whilst I was there I added the<br>
masseditable and helpinfo fields to the wiki page.)<br>
<font color="#888888"><br>
<br>
--<br>
The Open Learning Centre<br>
<a href="http://www.theopenlearningcentre.com" target="_blank">http://www.theopenlearningcentre.com</a><br>
<br>
_______________________________________________<br>
<a href="http://www.vtiger.com/" target="_blank">http://www.vtiger.com/</a><br>
</font></blockquote></div><br>