Hi, we're considering offering OpenERP based solutions to our clients. First we'd like to implement OpenERP in our company. We have a homegrown PHP/PostgreSQL system now. I have a quick look over OpenERP and tried to figure out how to implement our current functionality in it. And I have few questions :-) I don't need precise answers how to exatly do it but pointer to existing modules, code examples or if it's easy or hard to implement it - or estimation in man days ;-)
1) DMS - We'd like to use DMS feature for storing all documents in our company (hundreds of GBs, around 20 users reading/writing documents simultaneously). What's the recommended access method to documents? Through GTK client or using FTP? It must be easy to add or edit documents and it must be fast. I'm asking because I've found some performance data about ftp access which were not very impressive. And I'm not sure how easy is to use documents through GTK client (add or edit). Anyone has experience with deployment of DMS in somewhat "larger" scale? How is DMS implemented? Are the documents stored in database or on filesystem? 2) Reports - In our current solution we have some complex reports which looks like this: filters (no problem in OpenERP) grouping (e.g. group by - period: yes/no, user group: yes/no, ...) then follows data table with subtotals, breakdown by grouping categories etc. Some of our reports are on big datasets (many tables, millons rows). We're programming these reports using dynamicly constructed SQL - PostgreSQL takes care of optimalization... Is it possible to create such reports in OpenERP? Is it possible to directly use SQL? Or the recommended way is using ORM/BI/python modules? Is there any example of BI usage? We'd prefer doing these reports the "dynamic SQL way" because we think it's most efficient... 3) Forms - In our current solution we have few complex forms for entering data, e.g. table 30x40 storing it's values to say 4-5 database tables and editing many rows at once. There are javascript calculated fields also. Is it possible to have such complex forms in OpenERP? Any pointers how to do it? Is it possible without changing clients code? 4) Invoices - Is it possible to break one "real" invoice item to several "analytic" invoice items (different accounts, cost centers, projects etc)? 5) E-mail integration - Is there some description of how email integration works? We'd like to store all emails regarding clients, projects in OpenERP but we'd like not to manually add all these emails using outlook/thunderbird plugin. Is it possible? 6) Calendar - I'd like to test Calendar in my own installation. Which module I have to install, please? 7) Is it possible to do administrative tasks like editing forms, changing workflow from GTK client? I can't find it anywhere :-( 9) English book - When will be the English version of OpenERP book available, please? Looking forward to your answers, OpenERP seems to us as a great product! Thanks, Kuba -------------------- m2f -------------------- -- http://www.openerp.com/forum/viewtopic.php?p=23480#23480 -------------------- m2f -------------------- _______________________________________________ Tinyerp-users mailing list http://tiny.be/mailman/listinfo/tinyerp-users
