vtiger

[edgarecayce]

Is there a document that describes the tables, relationships and fields for vTiger? Some of it I have figured out but some is pretty cryptic. I am trying to rearrange the fields in my forms so things are a little easier.

I ahve a support agreement if that helps.

[edgarecayce]

oops forgot to mark topic as watched

[Lukas]

Hi edgarecayce,

i have this experience with vtiger DB documentation:

best is just looooking/learning into database and try read some tips from wiki and forums. Nothing more.

p.s. concrete question = concrete answer ... what do you want to do ? ...

Regards,

LN

[edgarecayce]

Thanks Lukas.

What I am trying to do right now is reorganize the layout of fields in the Leads, Accounts, and Contact modules. I have a number of custom fields and they are all jumbled around.

I know that vtiger_field has info on fields, and I figured out that "block" refers to the display block, and "sequence" is the order in which they appear. I used this to move some fields out of the "custom fields" block and into the top block, and to reoder them.

What I would like to do is add my own blocks of fields. I see that vtiger_blocks has info on blocks, but I am unsure of what fields in this table mean. For instance, in "blocklabel" there are a lot of LBL_xxx constants - where are these defined? Can I make my own label?

Ed

[Lukas]

Hi Ed, i don't know exactly, sorry.

I hope atleast this can help you :

1 -> something about blocklable
2 -> something about UI types
3 -> There is attached a data schema
4 -> ER diagram generated by Aqua data studio attached
5 -> Try analyze modules/Users/DefaultDataPopulator.php

Regards,

LN

[edgarecayce]

Holy crap! nice ER diagram...

Thanks for the help - I will check these out.

Ed