[Erp5-dev] New Business Template

[Jean-Paul Smets]

Le Vendredi 16 Décembre 2005 05:09, Rafael Monnerat a écrit :
> I create a new business template , the ERP5 Groupware

Sorry Rafael for my late reply. 

> The ERP5 Groupware has a new portal type. The FSFile has the same
> function of portal type File, but I create this portal type with some new
> features:
>
>    - File System Storage – In initial version Storage all files in
>    '/var/lib/zope/Local'

ERP5 File used to be based on ExtFile (until a few weeks ago). The code and 
dependency is still there (since most of our customers still use FS based 
approach). I think it would be better to include some switch in ERP5 so 
that people can chose if they prefer file based or ZODB based. For example, 
in the same way as in Photo product to chose PIL or image magick.

Now, about FS vs. ZODB. We used to think that FS based provided higher 
performance than ZODB based. We actually changed our mind recently after 
finding a way to get the same performance with ZODB as with FS based 
approach. Together with the fact that ERP5 supports WebDAV and that ZODB is 
simpler to setup, I think FS based approach is no longer needed. In 
particular, FS based is quite inconevenient with clusters. I am stating 
that after using FS based files for more than 3 years. So, I can understand 
your interest in FS based approach.

>    - Catalog Full Text - These extract the file content as text ( using a
>    conversor ) and catalog the file on mysql ( Use SearchableText )

Very nice. This will be very useful and I would like to integrate it is 
possible. I would suggest you to have a look to ZMySQLDDA
	http://cvs.erp5.org/ZMySQLDDA/

It is a derivative of MySQL DA which waits for the end of transactions to 
send SQL requests to MySQL. This is useful with MyISAM tables which do not 
support transactions. It prevents from getting exceptions in Zope related 
to lack of transactions in MyISAM (this is of course not need by InnoDB 
which supports transactions).

You could also try to mix (if you want to have fun) MySQL for high 
performance tables and pgsql for full text (I hear that pgsql has great 
full text algorithms).

> I include in the ERP5 Groupware some files and customize the
> navigation_box to execute the full text search. ( More Explain in Howto
> This business template will have the minimal Groupware tool and maybe I
> will extend to Personal tools. I'm working to create:

OK

> Forum

I am interested to see how you will implement that.

> Task List for Groups ( Used to Personal Task List too. )

I would suggest you not to concentrate too much on Tasks since we have 
already something in that area for project management. Tasks are the same 
thing as "service orders". So, they must be implemented with ERP5 Order 
class and integrated in ERP5 simulation. This requires in depth 
understanding of ERP5 simulation.

> Events
> Calendar
> News

I am interested to see what you get in that area. Regarding Calendar, there 
are some Calendars in ERP5 for planification of tasks and orders. This kind 
of calendar is very different with what people expect for personal 
calendaring. It looks more like production calendars in factories. There 
will also be calendar data structures for human resource management (ie. 
definition of working periods, not of personal calendars). This is still 
partly an open issue for us.

>
>
>  I Don't want recreate a CPS or Plone ( or other cms ) in ERP5. I think
> in some cases I solution needs a big CMS like these, but in other cases a
> simple solution for content managementis better than big, confuses and
> dificults solution.
>

I think that it takes a huge time and effort to create a CMS such as CPS or 
Plone and that it would be vain to create in ERP5 yet another CMS. Still, 
your project is interesting as a way to test or extend the technical 
capabilities of ERP5. And it is true that in some cases, when ERP5 users 
just want to add images, documents and files to products or orders, there 
is no need for a CMS.

>  Suggestion, questions are wellcome.

My suggestion is to proceed step by steps. Implement one part perfectly and 
publish/submit it quickly. This way, we can help you.

>
>
> --
> Rafael M. Monnerat
> http://monnerat.objectis.net

-- 
Jean-Paul Smets-Solanes, Nexedi CEO - Tel. +33(0)6 62 05 76 14
Nexedi: Consulting and Development of Libre / Open Source Software
http://www.nexedi.com
ERP5: Libre/ Open Source ERP Software for small and medium companies
http://www.erp5.org
Rentalinux: Desktop Linux Server
http://www.rentalinux.com