Difference between revisions of "Talk:VTiger"

From Organic Design wiki
m
 
(5 intermediate revisions by 3 users not shown)
Line 1: Line 1:
Document all changes to Vtiger here
+
while not an ERP, vtiger actually has a good database structure that could work well with it. what exactly are you trying to do/looking for? --[[User:Phalseid|Phalseid]] 05:24, 7 August 2007 (NZST)
for example:
+
:Since the nodal model is moving far too slowly we need an online business organisation package. It needs to handle accounts/budgetting, stock, time management, workflow etc. WebERP does it, but is a really crappy interface, TinyERP does it too, but is too hard to install so we haven't been able to check it out properly yet. --[[User:Nad|Nad]] 10:14, 7 August 2007 (NZST)
*/index.php got rid of logo
+
::I'll check out vTiger when I get it installed on our server - I'm trying to integrate it in the same way as the wikia. --[[User:Nad|Nad]] 10:32, 7 August 2007 (NZST)
 
+
:::alrighty. be interested to see what you find, andrew and I are using the backend for ourselves, and have written (and are currently writing) quite a few "widgets" to facilitate work orders, product orders, time management, and project managementThere is no "project management" ''per se'' in vtiger, but if you copy over the account module, and use that, it works quite well. you can use a new "account" for each project -which can be linked back to other projects (accounts), and then use the ticket system for tasks and time tracking.  you can build invoices from that, but there is no link to accounting packages yet. I have a prospect who has expressed interest in that, so keep all that in mind.... --[[User:Phalseid|Phalseid]] 10:43, 7 August 2007 (NZST)
 
+
::::[http://www.osfinancials.org/ OSFinancials] looks like it may be pretty good too and recently is able to integrate into vTiger --[[User:Nad|Nad]] 11:29, 7 August 2007 (NZST)
 
+
::::Thanks for the info - what are the widgets you've made for vTiger? is there a place with info about all the addons like MW has? --[[User:Nad|Nad]] 17:02, 7 August 2007 (NZST)
*loaded a few hundred contacts from local area
+
:::::The only working widget (out in the field, geting paid for each transaction) is what we call orderdot. I am currently working on timedot. the widgets are basically discrete tasks that do not require the full interface, or, the user is too dumb or just needs a simple interface to VT, if that makes sense. Here is a list of all the current modules (for better or worse) in vtiger: http://www.vtiger.com/products/crm/module-owners.html  --[[User:Phalseid|Phalseid]] 04:20, 8 August 2007 (NZST)
*added tony and restricted his view to tickets/calendar etc. to make it easy
 
*loaded my clients from freshbooks, i think this will work for invoicing! :)
 
 
 
= Ticketing =
 
*loaded CRM module (/crm/portal) to test out ticketing system.
 
**Very limited ticketing system.
 
**Cannot email tickets in
 
**Must create each user and give them "portal" access to view their own tickets
 
**Cannot parse tickets based on rules
 
**the current installation did not send out registration emails, something wrong with vtiger config on this server, but I did not troubleshoot futher.
 
**the /portal  extension may be a very good basis to do program invoicing where clients can log in and see their invoices and total. freshbooks has this part LICKED.
 
*adding a combo box to custom fields in ticket caused ticket module to crash
 
Fatal error: Call to undefined function: str_ireplace() in /home/sequoia/public_html/crm/include/utils/DetailViewUtils.php on line 129
 
 
 
*Conclusion: vtiger is not a good ticketing system at this point.  
 
 
 
 
 
= Outlook =
 
*outlook extension synced calendar items fine
 
*crashed on tasks. i am running outlook on exchange, does it work standalone?
 
::no, doesn't matter if it is exchange or standalone.  synching is not currently workgint with vtiger 5.02 + outlook 2003 --[[User:Phalseid|Phalseid]] 08:33, 9 Nov 2006 (NZDT)
 
 
 
 
 
 
 
=====
 
 
 
So this is the major issue at hand. Some companies like SCC and the rental business have work orders that need to have calendaring and scheduling available to them. 
 
 
 
Right now, the crms only show meetings and tasks on the calendar. I cannot use the purchase order or sales order to do work orders since both of those need products to be assigned at creation. A work order stays open until work is completed and charges are assigned. In the rental world the work order can be open for years and have accruing charges and periodic billing.
 
 
 
AHHHHHHHHHHHHHHHHHHHHHRRRRRRRRRRRRRRRRRRRRGGGGGGGGGGGGGGGGGGGGGG
 
 
 
[[User:Aregularjoe|Aregularjoe]] 08:09, 9 Nov 2006 (NZDT)
 
 
 
 
 
----
 
phalseide: im in...gotta leave at 7:00 sharp.!
 
GG720InTheBooks: hey
 
GG720InTheBooks: ok
 
GG720InTheBooks: I am looking at making the column count vary by block on the screen
 
GG720InTheBooks: fyi, terminoloy is
 
GG720InTheBooks: each page is a tab
 
GG720InTheBooks: so tabs have blocks and blocks have details(rows) and details have fields
 
GG720InTheBooks: all elements are explicitly defined in the database
 
GG720InTheBooks: woo hoo
 
GG720InTheBooks: so i plan to add a field to blocks called columncount to indicate how may columns of data to display
 
phalseide: got it.
 
GG720InTheBooks: not to sure how this affects tab order, i am investigating
 
phalseide: okay, i have found groups. i can assign a contact to either a user or a group. now, for example, should i assign "smart carpet care" to group Adeft or should we make groups like this: Adeft\Marketing Group Adeft\Sales Group Adeft\Team Selling?
 
GG720InTheBooks: i think os
 
GG720InTheBooks: so
 
GG720InTheBooks: lets do this
 
GG720InTheBooks: do a Adeft/sales
 
GG720InTheBooks: Adeft/Administrative
 
GG720InTheBooks: Adeft/Field Service
 
phalseide: okay. this is cool, we can assign levels of users, like all CEO's can see adeft.com
 
GG720InTheBooks: sure
 
phalseide: "ROLES"
 
phalseide: can we add roles?
 
GG720InTheBooks: remeber there is two options
 
GG720InTheBooks: yes
 
GG720InTheBooks: roles and groups
 
GG720InTheBooks: issue is you have to repeat a role
 
GG720InTheBooks: for every business
 
phalseide: right, so Sales
 
phalseide: has to be X\Sales
 
phalseide: right?
 
GG720InTheBooks: yes
 
phalseide: k
 
phalseide: np
 
GG720InTheBooks: hold one
 
phalseide: this is pretty slick then
 
GG720InTheBooks: on
 
GG720InTheBooks: let me see again
 
phalseide: k
 
GG720InTheBooks: i get confused
 
GG720InTheBooks: i am looking at various table css right now
 
GG720InTheBooks: http://icant.co.uk/csstablegallery/index.php?css=40#r40
 
phalseide: i think we need to modify orgization in roles, not the groups
 
GG720InTheBooks: right
 
phalseide: groups will be the "same"
 
GG720InTheBooks: i am relearning
 
phalseide: sales, marketing, etc
 
phalseide: right now you have the org set up with CEO\BLAH
 
GG720InTheBooks: this needs to be for us
 
GG720InTheBooks: something like
 
phalseide: i guess we have to duplicate in one or the other, the decision is which way...
 
phalseide: what impacts the calendar
 
GG720InTheBooks: Streamline Gurus
 
GG720InTheBooks: then businesses under that
 
phalseide: without looking, logic tells me we need to do it in roles.
 
GG720InTheBooks: then Adeft Administration
 
phalseide: okay, im gonna set up roles like that
 
GG720InTheBooks: Then Adeft Customer Support on the same level
 
GG720InTheBooks: yes roles looks like it
 
GG720InTheBooks: roles is people focused
 
GG720InTheBooks: profiles are software and module focused
 
GG720InTheBooks: roles and profiles meet up in groups
 
phalseide: yep
 
phalseide: what was the name you saw on that truck in denver?
 
GG720InTheBooks: i forgot
 
phalseide: crap!
 
GG720InTheBooks: something cool
 
phalseide: yeah...
 
phalseide: okay, so relating this to smart carpet care...
 
phalseide: in his franchise, he has complete control over the "groups". each franchise has to have the same "groups", which he dictates universally.
 
phalseide: for roles, he can see that for all of his different franchieese, right?
 
GG720InTheBooks: right
 
phalseide: so if he adds denver, it goes into roles
 
GG720InTheBooks: so Franchisor >>>Franchisee>>>Business Administration
 
phalseide: if he adds "carpet cleaner"
 
phalseide: it goes into groups
 
phalseide: got it.
 
phalseide: yep
 
 
 
GG720InTheBooks: and Field Tech in that same level
 
phalseide: okay. let me create some more stuff for us
 
GG720InTheBooks: hey
 
phalseide: and then i will play with some events and the calenar to make sure that what we see is what we want
 
GG720InTheBooks: one more level
 
phalseide: yeah?
 
GG720InTheBooks: under Franchisor
 
GG720InTheBooks: there needs to be regional mgmt
 
phalseide: right.
 
phalseide: like if he has a "super franchise"
 
phalseide: well, this looks pretty well thought out and extensible.
 
GG720InTheBooks: no he plans on having regional people to oversee a region of franchisees
 
phalseide: back to work/.
 
phalseide: ok
 
GG720InTheBooks: the regional people report to him
 
phalseide: yt
 
phalseide: ?
 
GG720InTheBooks: yep
 
phalseide: how do you add a module?
 
GG720InTheBooks: painfully
 
phalseide: yikes.
 
GG720InTheBooks: doable
 
GG720InTheBooks: we dont want to do that soon do we
 
phalseide: not a biggy now,
 
GG720InTheBooks: good
 
phalseide: no, i just was wishin;
 
GG720InTheBooks: we will need to later
 
phalseide: i can see how modules tie into display
 
phalseide: so yeah
 
phalseide: lets wait till someobody at tiger pays us to do it
 
GG720InTheBooks: right
 
phalseide:
 
GG720InTheBooks: they are working on making it easier
 
phalseide: the error messages need a lot of help. looks like bhaskar at 7-11 wrote most of them
 
GG720InTheBooks: he did
 
phalseide: i guess language files are a big deal in the works?
 
GG720InTheBooks: french and german done
 
GG720InTheBooks: i read that
 
phalseide: when will they finish english?
 
phalseide: ;)
 
phalseide: so they got hindi and punjabi nailed
 
GG720InTheBooks: when we finish evolving it
 
phalseide: maliallam is next
 
phalseide: then catoneses, then madarin
 
GG720InTheBooks: so english is behind the 100 plus dialects in india
 
phalseide: im sur
 
phalseide: sure
 
GG720InTheBooks: i'll work on the pig latin
 
phalseide: okay, help me build a test case...
 
phalseide: i want to create an event for adeft
 
GG720InTheBooks: or maybe the navajo
 
phalseide: sorry, a sales order
 
phalseide: in adeft
 
phalseide: that sequoiais cant see
 
phalseide: right?
 
phalseide: but that admin can see
 
GG720InTheBooks: right
 
GG720InTheBooks: right
 
phalseide: same for an event in the calendar?
 
GG720InTheBooks: yes
 
phalseide: and then for fun see if maxpc can see it
 
phalseide: (shared on purpose with that role)
 
phalseide: ?
 
phalseide: okay, im gonna create a bunch of users with different privelanges.
 
phalseide: im not gonna be much help more than a go or no on how easy this is.
 
phalseide: we can chat on the phone about pricing
 
phalseide: after i do this test
 
GG720InTheBooks: ok
 
phalseide: ah! revenue stream for robert and us....
 
phalseide: we create the franchises's website!
 
phalseide: ("optional")
 
GG720InTheBooks: he has already asked about his
 
GG720InTheBooks: i put it off
 
phalseide: good.
 
phalseide: we should get someone in there and work in parallel.
 
GG720InTheBooks: i mentioned that he needs to work through his identity first
 
phalseide: yeah
 
GG720InTheBooks: i told him I have a marketing company out of state that i work with
 
GG720InTheBooks: i explained that we can do web development
 
GG720InTheBooks: but that is not design
 
GG720InTheBooks: and that he needs to nail the image and identity, then design
 
GG720InTheBooks: then we code
 
GG720InTheBooks: he got it
 
GG720InTheBooks: again....
 
GG720InTheBooks: if I had a worksheet that explained that in very few words
 
GG720InTheBooks: we would have another person selling us
 
GG720InTheBooks: he could pass the sheet on to someone saying , you need to talk to these guys
 
GG720InTheBooks: looks like multiple column css tables is going to suck for making it variable
 
GG720InTheBooks: i have not given up
 
GG720InTheBooks: but ie is blowing it
 
GG720InTheBooks: we mandate Firefox
 
phalseide: YEAH!
 
phalseide: W3C baby
 
GG720InTheBooks: i don't want to spend my life troubleshooting css for ie
 
phalseide: so, there is a char limit to username....boo hiss
 
GG720InTheBooks: also
 
GG720InTheBooks: you cannot repeat a role name
 
phalseide: that makes sense
 
GG720InTheBooks: you have to put Adeft Managment
 
GG720InTheBooks: and MaxPc Management
 
phalseide: so we have to do it in both places.
 
phalseide: crap.
 
phalseide: but i understand that
 
phalseide: i guess
 
phalseide: a role is interchangeable
 
phalseide: and should only be filled by one person at a time
 
phalseide: people are interchangeable
 
phalseide: roles are not
 
GG720InTheBooks: right
 
GG720InTheBooks: and person may assume multiple roles
 
phalseide: right.
 
phalseide: yeah, mandate FF
 
phalseide: franchise requirement
 
phalseide: then we won't be fighting axtivex crap and updates, and we could even write some cool greasemonkey extensions
 
GG720InTheBooks: i have spent too many hours making layouts ie compatable to even give it thought for our projects
 
phalseide: AMEN
 
phalseide: you sound like the guys at wikiexpert
 
phalseide: they are always bitcing about IE.
 
phalseide: the js is even worse
 
GG720InTheBooks: its a waste
 
phalseide: i couldn't get any xpath stuff to work
 
phalseide: and i HAD to have that for what i did
 
GG720InTheBooks: i had a $800 project go negative because i had to fight ie compliance
 
GG720InTheBooks: load of crap
 
phalseide: man.
 
phalseide: btw,
 
phalseide: back to work
 
phalseide: i mean
 
phalseide: crap, phalseid/adeft.com can see all leads...
 
phalseide: adeft.com/phalseid i should say....
 
GG720InTheBooks: you need to resrict the data
 
GG720InTheBooks: under the user account
 
GG720InTheBooks: if i sounds like i know what i am talking about, its because i thought i say that
 
GG720InTheBooks: not sure
 
GG720InTheBooks: everyone is saying tabular data belongs in tables
 
GG720InTheBooks: not css
 
GG720InTheBooks: crap
 
GG720InTheBooks: should make it easier though
 
phalseide: okay.
 
phalseide: another thing you can do for pay...
 
phalseide: where do i limit users?
 
GG720InTheBooks: go to the user
 
GG720InTheBooks: edit ti
 
GG720InTheBooks: it
 
GG720InTheBooks: then somewhere in there
 
GG720InTheBooks: nope
 
GG720InTheBooks: crap
 
GG720InTheBooks: somewhere i saw data ownership
 
GG720InTheBooks: hey
 
GG720InTheBooks: under settings>>>Sharing Access
 
GG720InTheBooks: yeah ha
 
GG720InTheBooks: hope it works
 
phalseide: crap. im outta time.
 
phalseide: dang. maybe late tonight, after i attend to my poor wife
 
phalseide: sharing access works, but i don't see how to make specific information work with one of the specific roles that i made
 

Latest revision as of 07:54, 8 August 2008

while not an ERP, vtiger actually has a good database structure that could work well with it. what exactly are you trying to do/looking for? --Phalseid 05:24, 7 August 2007 (NZST)

Since the nodal model is moving far too slowly we need an online business organisation package. It needs to handle accounts/budgetting, stock, time management, workflow etc. WebERP does it, but is a really crappy interface, TinyERP does it too, but is too hard to install so we haven't been able to check it out properly yet. --Nad 10:14, 7 August 2007 (NZST)
I'll check out vTiger when I get it installed on our server - I'm trying to integrate it in the same way as the wikia. --Nad 10:32, 7 August 2007 (NZST)
alrighty. be interested to see what you find, andrew and I are using the backend for ourselves, and have written (and are currently writing) quite a few "widgets" to facilitate work orders, product orders, time management, and project management. There is no "project management" per se in vtiger, but if you copy over the account module, and use that, it works quite well. you can use a new "account" for each project -which can be linked back to other projects (accounts), and then use the ticket system for tasks and time tracking. you can build invoices from that, but there is no link to accounting packages yet. I have a prospect who has expressed interest in that, so keep all that in mind.... --Phalseid 10:43, 7 August 2007 (NZST)
OSFinancials looks like it may be pretty good too and recently is able to integrate into vTiger --Nad 11:29, 7 August 2007 (NZST)
Thanks for the info - what are the widgets you've made for vTiger? is there a place with info about all the addons like MW has? --Nad 17:02, 7 August 2007 (NZST)
The only working widget (out in the field, geting paid for each transaction) is what we call orderdot. I am currently working on timedot. the widgets are basically discrete tasks that do not require the full interface, or, the user is too dumb or just needs a simple interface to VT, if that makes sense. Here is a list of all the current modules (for better or worse) in vtiger: http://www.vtiger.com/products/crm/module-owners.html --Phalseid 04:20, 8 August 2007 (NZST)