[prev in list] [next in list] [prev in thread] [next in thread]
List: vtigercrm-developers
Subject: Re: [Vtigercrm-developers] UITYPE & TYPEOFDATA map for vtiger 5.x
From: Holbok_István <holbok () gmail ! com>
Date: 2010-06-28 9:07:00
Message-ID: 4C286634.1040308 () gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi Joe,
Thank you for the answer.
How I can upload it to the wiki? All other notes are in the text.
Best: Istvan
2010.06.28. 1:01 keltezéssel, Joe Bordes írta:
> Hi,
>
> Nice work, you should upload it to the wiki.
> Let's see if I can shed some light on your doubts:
>
> noofemployees is an Optional Integer: I~O is correct
> qtyistock is an Optional Negative Number: NN~O is correct
> qty_per_unit is an Optional Number: N~O is correct
> *
> *
*I agree. The typeofdata is correct here. I do not understand why uitype
is 1. 1 is text if I understand well.*
>> noofemployees No Of Employees 1
>> I~O (??? text) int(50) No
>> qtyinstock Qty In Stock 1
>> NN~O (??? text) decimal(25,3) No
>> qty_per_unit No of Units 1
>> N~O (??? text) decimal(11,2) No
>>
>
>
> I agree, these are typos that will get fixed. I think I have seen a
> trac ticket about it?
*Yes, the ticket is open with the full list of typofdata contains Null
instead of O.*
>
>
>> enddate End Date 5 D~0~OTH~GE~startdate~Start Date
>> [0 Null is a possible typo]
>> date No
>> targetenddate Target End Date 23 D~0~OTH~GE~startdate~Start Date
>> [0 Null is a possible typo]
>> date No
>>
>
>
>
> Duration minutes picklist - different typeofdata for the tab_id: 9 and
> 16 ???
>
> Donˇt know what to say.
>
>
>
>
>
> This one I don't understand either. I'd say this is also an error.
>
>> createdtime Created Time 70 V~O (??? for tab_id: 32 -
>> ServiceContracts) datetime No
>>
>
>
> Picklist, mandatory entry ???
> This really is very useful, it is just a visual effect as a picklist
> always has at least the default value selected.
*Yes, its true. But non of them was mandatory with uitype 16 in the
vtiger 5.2.0 database.*
>
>
> 25, 26, 27,28 ??? missing entries
> Currency in modules - missing entries
>
> 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.
>
> Joe
> TSolucio
>
[Attachment #5 (text/html)]
<!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>
_______________________________________________
Join vtiger community at http://forums.vtiger.com
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic