Help please.

classic Classic list List threaded Threaded
3 messages Options
Reply | Threaded
Open this post in threaded view
|

Help please.

Josh Lee-2
Anyone wanna give this one a whirl?

What are quickcreate | quickcreatesequence | info_type for?

Most especially, what the heck does V~O, V~M, E~O, I~O, C~O, or T~O mean
on the field table?

mysql> select distinct typeofdata from field;
+--------------------------------------------------+
| typeofdata                                       |
+--------------------------------------------------+
| V~M                                              |
| V~O                                              |
| I~O                                              |
| E~O                                              |
| C~O                                              |
| T~O                                              |
| D~O                                              |
| D~O~OTH~GE~support_start_date~Support Start Date |
| N~O                                              |
| D~M                                              |
| D~O~OTH~GE~sales_start_date~Sales Start Date     |
| D~O~OTH~GE~start_date~Start Date                 |
| DT~M~time_start                                  |
| D~M~OTH~GE~date_start~Start Date & Time          |
| O~O                                              |
| T~M                                              |
| I~M                                              |
+--------------------------------------------------+
This just confuses the hell out of me.


--
Josh Lee
Software Engineer
Zertis Technologies, LLC
205.422.5279
[hidden email]


_______________________________________________
This vtiger.com email is sponsored by Zoho Planner. Still scribbling down your To-Do's on bits of paper & palms of your hands? Try the AJAX enabled, personal organizer online, Zoho Planner for FREE instead! http://zohoplanner.com/?vt 

jlee.vcf (231 bytes) Download Attachment
Reply | Threaded
Open this post in threaded view
|

Re: Help please.

Michel JACQUEMES
Hi Josh,

I have not the answer and I asked for explanation 2 month ago. I don't think
there is any, it is more probably some remaining thing from sugarcrm.

I worked a bit on that when migrating to mssql and found that it has to be
combined with uitype field:

 ("D","I","N")  are numeric, ("C","E","O") are not,
 "V" is numeric if uitype in (5,50,52,53,56,57)
 exceptions : tablename="contactdetails" columname="reportsto" uitype=57 ?
 "T" is numeric if uitype = 70

Not sure it helps, isn't it?

Michel

> -----Message d'origine-----
> De : [hidden email] [mailto:vtigercrm-
> [hidden email]] De la part de Josh Lee
> Envoyé : mercredi 5 avril 2006 03:51
> À : [hidden email]; vtigercrm-
> [hidden email]
> Cc : Jeremy Lowery
> Objet : [Vtigercrm-developers] Help please.
>
> Anyone wanna give this one a whirl?
>
> What are quickcreate | quickcreatesequence | info_type for?
>
> Most especially, what the heck does V~O, V~M, E~O, I~O, C~O, or T~O mean
> on the field table?
>
> mysql> select distinct typeofdata from field;
> +--------------------------------------------------+
> | typeofdata                                       |
> +--------------------------------------------------+
> | V~M                                              |
> | V~O                                              |
> | I~O                                              |
> | E~O                                              |
> | C~O                                              |
> | T~O                                              |
> | D~O                                              |
> | D~O~OTH~GE~support_start_date~Support Start Date |
> | N~O                                              |
> | D~M                                              |
> | D~O~OTH~GE~sales_start_date~Sales Start Date     |
> | D~O~OTH~GE~start_date~Start Date                 |
> | DT~M~time_start                                  |
> | D~M~OTH~GE~date_start~Start Date & Time          |
> | O~O                                              |
> | T~M                                              |
> | I~M                                              |
> +--------------------------------------------------+
> This just confuses the hell out of me.
>
>
> --
> Josh Lee
> Software Engineer
> Zertis Technologies, LLC
> 205.422.5279
> [hidden email]



_______________________________________________
This vtiger.com email is sponsored by Zoho Planner. Still scribbling down your To-Do's on bits of paper & palms of your hands? Try the AJAX enabled, personal organizer online, Zoho Planner for FREE instead! http://zohoplanner.com/?vt 
Reply | Threaded
Open this post in threaded view
|

Re: Help please.

Nolan Andres
In reply to this post by Josh Lee-2
"O" / "M" seems to mean Optional vs. Mandatory

(M means a required field, and gets the little red star)

I haven't investigated the V/E/I/C/T stuff too much, yet...when creating
my own fields, I've just mimicked something existing that's similar to
what I want...

peace,
Nokes


Josh Lee wrote:

> Anyone wanna give this one a whirl?
>
> What are quickcreate | quickcreatesequence | info_type for?
>
> Most especially, what the heck does V~O, V~M, E~O, I~O, C~O, or T~O mean
> on the field table?
>
> mysql> select distinct typeofdata from field;
> +--------------------------------------------------+
> | typeofdata                                       |
> +--------------------------------------------------+
> | V~M                                              |
> | V~O                                              |
> | I~O                                              |
> | E~O                                              |
> | C~O                                              |
> | T~O                                              |
> | D~O                                              |
> | D~O~OTH~GE~support_start_date~Support Start Date |
> | N~O                                              |
> | D~M                                              |
> | D~O~OTH~GE~sales_start_date~Sales Start Date     |
> | D~O~OTH~GE~start_date~Start Date                 |
> | DT~M~time_start                                  |
> | D~M~OTH~GE~date_start~Start Date & Time          |
> | O~O                                              |
> | T~M                                              |
> | I~M                                              |
> +--------------------------------------------------+
> This just confuses the hell out of me.
>
>
>
> ------------------------------------------------------------------------
>
> _______________________________________________
> This vtiger.com email is sponsored by Zoho Planner. Still scribbling down your To-Do's on bits of paper & palms of your hands? Try the AJAX enabled, personal organizer online, Zoho Planner for FREE instead! http://zohoplanner.com/?vt 
_______________________________________________
This vtiger.com email is sponsored by Zoho Planner. Still scribbling down your To-Do's on bits of paper & palms of your hands? Try the AJAX enabled, personal organizer online, Zoho Planner for FREE instead! http://zohoplanner.com/?vt