<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
Hi Joe,<br>
<br>
Thank you for the answer.<br>
How I can upload it to the wiki? All other notes are in the text.<br>
<br>
Best: Istvan<br>
<br>
2010.06.28. 1:01 keltezéssel, Joe Bordes írta:
<blockquote cite="mid:4C27D83E.5000500@tsolucio.com" type="cite">
<meta content="text/html; charset=ISO-8859-1"
http-equiv="Content-Type">
Hi,<br>
<br>
Nice work, you should upload it to the wiki.<br>
Let's see if I can shed some light on your doubts:<br>
<br>
noofemployees is an Optional Integer: I~O is correct<br>
qtyistock is an Optional Negative Number: NN~O is correct<br>
qty_per_unit is an Optional Number: N~O is correct<br>
<b><br>
</b></blockquote>
<b>I agree. The typeofdata is correct here. I do not understand why
uitype is 1. 1 is text if I understand well.</b><br>
<blockquote cite="mid:4C27D83E.5000500@tsolucio.com" type="cite">
<blockquote cite="mid:4C2794E9.6080901@gmail.com" type="cite"><span
class="e" id="q_1297a44c64da0d44_3">
<div>
<div>
<table style="text-align: left; width: 100%;" border="1"
cellpadding="2" cellspacing="2">
<tbody>
<tr>
<td
style="background-color: rgb(255, 255, 204); width: 107px;">noofemployees</td>
<td
style="background-color: rgb(255, 255, 204); width: 158px;">No
Of
Employees</td>
<td
style="background-color: rgb(255, 255, 204); width: 116px;">1<br>
</td>
<td
style="background-color: rgb(255, 255, 204); width: 253px;">I~O <span
class="e" id="q_1297a44c64da0d44_3">(??? text)</span></td>
<td
style="background-color: rgb(255, 255, 204); width: 201px;">int(50)</td>
<td style="background-color: rgb(255, 255, 204);">No</td>
</tr>
<tr>
<td
style="background-color: rgb(255, 255, 204); width: 107px;">qtyinstock</td>
<td
style="background-color: rgb(255, 255, 204); width: 158px;">Qty
In
Stock</td>
<td
style="background-color: rgb(255, 255, 204); width: 116px;">1<br>
</td>
<td
style="background-color: rgb(255, 255, 204); width: 253px;">NN~O <span
class="e" id="q_1297a44c64da0d44_3"><span class="e"
id="q_1297a44c64da0d44_3">(??? text)</span></span></td>
<td
style="background-color: rgb(255, 255, 204); width: 201px;">decimal(25,3)</td>
<td style="background-color: rgb(255, 255, 204);">No</td>
</tr>
<tr>
<td
style="background-color: rgb(255, 255, 204); width: 107px;">qty_per_unit</td>
<td
style="background-color: rgb(255, 255, 204); width: 158px;">No
of
Units</td>
<td
style="background-color: rgb(255, 255, 204); width: 116px;">1<br>
</td>
<td
style="background-color: rgb(255, 255, 204); width: 253px;">N~O <span
class="e" id="q_1297a44c64da0d44_3"><span class="e"
id="q_1297a44c64da0d44_3">(??? text)</span></span></td>
<td
style="background-color: rgb(255, 255, 204); width: 201px;">decimal(11,2)</td>
<td style="background-color: rgb(255, 255, 204);">No</td>
</tr>
<tr>
<td valign="top"><br>
</td>
</tr>
</tbody>
</table>
</div>
</div>
</span></blockquote>
<br>
<br>
I agree, these are typos that will get fixed. I think I have seen a
trac ticket about it?<br>
</blockquote>
<b>Yes, the ticket is open with the full list of typofdata contains
Null instead of O.</b><br>
<blockquote cite="mid:4C27D83E.5000500@tsolucio.com" type="cite"><br>
<br>
<blockquote cite="mid:4C2794E9.6080901@gmail.com" type="cite"><span
class="e" id="q_1297a44c64da0d44_3">
<div>
<div>
<table style="text-align: left; width: 100%;" border="1"
cellpadding="2" cellspacing="2">
<tbody>
<tr>
<td
style="width: 107px; background-color: rgb(255, 255, 204);">enddate</td>
<td
style="width: 158px; background-color: rgb(255, 255, 204);">End
Date</td>
<td
style="width: 116px; background-color: rgb(255, 255, 204);">5</td>
<td style="width: 253px; background-color: rgb(255, 255, 51);">D~0~OTH~GE~startdate~Start
Date
<br>
[0 Null is a possible typo]<br>
</td>
<td
style="width: 201px; background-color: rgb(255, 255, 204);">date</td>
<td style="background-color: rgb(255, 255, 204);">No</td>
</tr>
<tr>
<td style="background-color: rgb(255, 255, 204);">targetenddate</td>
<td style="background-color: rgb(255, 255, 204);">Target
End Date</td>
<td style="background-color: rgb(255, 255, 204);">23</td>
<td style="background-color: yellow;">D~0~OTH~GE~startdate~Start
Date<br>
<span class="e" id="q_1297a44c64da0d44_3">[0 Null is a
possible
typo]</span><br>
</td>
<td style="background-color: rgb(255, 255, 204);">date</td>
<td style="background-color: rgb(255, 255, 204);">No</td>
</tr>
</tbody>
</table>
</div>
</div>
</span></blockquote>
<br>
<br>
<br>
<span class="e" id="q_1297a44c64da0d44_3">Duration
minutes picklist - different typeofdata for the
tab_id: 9 and 16 ???<br>
<br>
Don¡t know what to say.<br>
<br>
</span><br>
<br>
<br>
<br>
This one I don't understand either. I'd say this is also an error.<br>
<br>
<blockquote cite="mid:4C2794E9.6080901@gmail.com" type="cite"><span
class="e" id="q_1297a44c64da0d44_3">
<div>
<div>
<table style="text-align: left; width: 100%;" border="1"
cellpadding="2" cellspacing="2">
<tbody>
<tr>
</tr>
<tr>
<td style="background-color: rgb(255, 255, 204);">createdtime</td>
<td style="background-color: rgb(255, 255, 204);">Created
Time</td>
<td style="background-color: rgb(255, 255, 204);">70</td>
<td style="background-color: rgb(255, 255, 204);">V~O (???
for tab_id: 32 - ServiceContracts)</td>
<td style="background-color: rgb(255, 255, 204);">datetime</td>
<td style="background-color: rgb(255, 255, 204);">No</td>
</tr>
</tbody>
</table>
</div>
</div>
</span></blockquote>
<br>
<br>
<span class="e" id="q_1297a44c64da0d44_3">Picklist,
mandatory entry ???<br>
This really is very useful, it is just a visual effect as a picklist
always has at least the default value selected.<br>
</span></blockquote>
<b>Yes, its true. But non of them was mandatory with uitype 16 in the
vtiger 5.2.0 database.</b><br>
<blockquote cite="mid:4C27D83E.5000500@tsolucio.com" type="cite"><span
class="e" id="q_1297a44c64da0d44_3"><br>
<br>
</span><span class="e" id="q_1297a44c64da0d44_3">25,
26, 27,28 ??? <span class="e" id="q_1297a44c64da0d44_3">missing
entries</span></span><br>
<span class="e" id="q_1297a44c64da0d44_3">Currency in modules - <span
class="e" id="q_1297a44c64da0d44_3"> <span class="e"
id="q_1297a44c64da0d44_3">missing entries<br>
<br>
These were added in 5.1. and the UI_type page hasn't been updated. In
this same line, some uitypes have been eliminated and they haven't been
updated on the page either.<br>
<br>
Joe<br>
TSolucio<br>
</span></span></span><br>
</blockquote>
</body>
</html>