About

This planet is the place where developers and contributors express themselves about the Open ERP project.

Bloggers

Last updated:
July 03, 2009 06:59 PM
All times are UTC.

Powered by:
Planet

OpenERP Book
Open ERP Planet

July 02, 2009

Cecile Debois    

OpenERP : plan de formation 2ème semestre 2009

Camptocamp est heureux de vous donner ci-dessous la liste des formations OpenERP pour le 2ème semestre 2009.

Ces formations sont données dans nos locaux de Lausanne en cours inter-entreprise. Nous sommes également à disposition si vous souhaitez organiser une formation OpenERP au sein même de votre entreprise (intra-entreprise) ou dans nos bureaux de Chambéry.

Pour plus d'informations, n'hésitez pas à nous contacter par email Cette adresse email est protégée contre les robots des spammeurs, vous devez activer Javascript pour la voir. .

by Cécile (Open ERP) (noreply@blogger.com) at July 02, 2009 01:59 PM

June 18, 2009

Olivier    

Hiding documentation comments.


Comments in the documentation are becoming very numerous. They begin to hinder the reading.

If you want to read the Open ERp documentation without those comments, we have added a small utility to control the appearance of these comments. There is now a small selection list on the right of the next, previous links:

Hide js-kit comments selection list

You can now choose to read the documentation without these comments if you want.

Your choice will be remembered from page to page and even if you start a new web session (a cookie is used to store your choice)

by Olivier at June 18, 2009 07:02 AM

June 09, 2009

OpenERP 5.0    

Feeback for May '09 Developments

Hello,

Here is the feedback of the last month's work.

1.Report Engine :
Open ERP Report Engine has added new type of report called mako2html to parse HTML reports using MAKO template for faster and formatted output. See more detail : http://openerp-team.blogspot.com/2009/05/faster-formating-of-html-reports-using.html


2.Multi-Company :
Now User can directly change the company without having to log out, directly by going through the user preferences. and also Current company is displayed on status bar.


3.Google MAP in Open ERP :
We can see our partner information on google map(name, code, address,...) with icon on map.
Display country wise Partner Turnover, country appears in different colors like
light red color => high turnover
dark red color => low turnover
Display Delivery routes from Warehouse location to Customer location by cities with 10 different colors (by number of delivery to that city from warehouse)

Note : It generates KML file so you can save it on your computer and upload it on google map or google earth.
Required python packages : Google direction package


4.Google Translation in Open ERP :
Now we can translate Open ERP terms / fields / objects etc. in any language using integration of Google Translate. And also we can see unreviewed terms and review easily
see more information : http://www.openerp.com/planet/


5.CRM :
*On Case Section, we can configure the mailgateway through fetchmail to specify the parameters pop address, port, user, password, mailgate script path. When save mailgateway configuration, parameter file will be created per section in "server > bin > .fetchmail > dbname" . and scheduler will be read this file and call system command to fetch mail
*After click on Reminder button in case form, Window will be display message "Email Successfully sent !" if mail successfully sent
*Improve openerp-mailgate.py to accept html body


6.Base Quality module :
This module has been reviewed and should now be more accurate and more usable. As reminder, the base quality module allow you to check the quality of a module using different criteria (pylint, speed efficiency, coding standard followed by openepr, etl...).

It evaluates score in percentage (%) for whole module as well as it can provide score for individual tests, also it can skip some tests if module is not installed in server (workflow test...) so that your score is not bad for no reason.
Use Ponderation value to calculate score. It allows you to save the result of test (Save Report button)
Module also provide generic framework to define your own quality test.
Note : For more information (README.txt)

7.Document modules :

document_rules :
Document Rule module is mainly developed for creating rules on documents.
There are four types of rules which are defined in server actions: To copy document, To move document, To Assign partner to a document and To assign user to a document.
These rules are fired when rules criteria match on the basis of time defined in the scheduler.

document_extention :
Document extension module keeps track of versioning of documents.
Any change is made to the document and saved then it creates version of that document and the versioned document gets locked. The user cannot modify the document if it is versioned. 


8.Usability Improvement :

*Make Partner Category structure view, Products Categories structure view, Analytical Account Structure View same like Stock Locations Structure view
*Rename “Administration > Security > Grant Access to Menus” into "... / Manage Menus"
*Change Order of menus in Product menu. Before, It was like this: Configuration,
Product's by Categories, Pricelists, Products. But Now It is like this: Configuration, Pricelists, Products by Categories, Products
*Rename field "Rentable Product" by "Can be Rent" in Product Form.
Reorder invoicing menus, the New ... Invoice is always the first menu of his level. It should be the latest one. For example, "New Customer Invoice" must be after "Unpaid Customer Invoices".
*On a task form View, second tab, put the text fields.function bellow the one2many and many2one for parent task.
*On a Task View : the fields Importance, Starting Date, Sequence, Partner, can be changed when the task is draft. (can always be changed). Currently, they are readonly.
*In the project management menu, rename "Template of Projects" by "Templates of Projects".
*On a tracking lot, put a link on the right of the lot to get the stock by location.
*On Periodical Inventory, Add the state cancel and the buttons for the following transitions: draft -> cancel, cancel -> draft
*On Outgoing products form, the stock.move lines must have a colour according to their state: grey for confirmed, black for others, blue for done
*The menu: Reporting / Traceability / Stock by Lots should open in list view instead of form view.
*On stock.picking, rename the state: Cancel -> Cancelled
*Now The report dates of inventories displays product field instead of ID of products
*On a purchase order, rename the state "Confirmed" by "Waiting Supplier Ack.".
*On a purchase order form, the “Address” should be renamed to “Supplier Address”. “Partner Ref” has been renamed to “Supplier Ref”.
*In manufacturing, put good icon of the menu Production Orders Planning .
*Change the cases segmentation form, user department form, Scheduler action form to be compliant with v5 guidelines of the form view. (a few fields on the top of the notebook)
*Add Gantt view on CRM Meeting
*Override the name_get method on a stock.location object. If you have 'full':1 in the context, return the full path instead of simply the name: "Tiny Sprl / Stock / Stock Wavre". Change the report Stock by Lots so that it displays the location like this


9.New System in Planning Management :
The module report_analytic_planning has been completely reviewed.
*New integer field for 'Business Days' in planning
*Improve view and do a fixed area in top (as for new design since 5.0)
*Change the default name to be the current month instead of the current day
*Put link between planning and project.task
*New a boolean field on planning line: "Assigned to task(s)" to check task assigned or not for planning line.
*Display Planning By User with him department' user, total of remaining hours of tasks, total plan hours, total open hours, total of Valid holidays Requests between the 2 dates of the planning, calculate free hours, total of timesheet lines between the dates of the planning
*Display Planning By Account with above information


10.ETL :
Improvement
- Pause and restart the job (Under developement)
- Thread server implement on demo
- pickle object to store the current job status

- Python Cprofile
- added concept of cprofile on job in run

New components:

google calendar
- connector => Provide connection to google calendar
- in => fetch events from google calendar
- out => send events to google calendar

google documents
- connector => Provide connection service to google documents
- in => Fetch files from google doc
- out => send files to google doc

gmail contacts
- out => send contacts to gmail contact for given user

Blogger
connector => Provice connection to blogger service
out => send blogs to blogger

XML RPC :

New Test Files
test file for xml_in and xml_out (demo data in xml with different companies):
- added test files which convert xml to dictionary format and vice versa
- try to use XSLT for import and export of xml files (Under development)

etl_interface:
Views:
New components views added(google calendar, google documents)
Dynamic views creation of all components
views improve for job
Wizard:
Add components and transitions from job object
Workflow:
Modified workflow for pause and restart the job


11.Ported etree object instead of minidom object


12.Thurnderbird pluging :
Here are few enhancements, improvements and bugfixing have been done on thunderbird plugin.

* If the thunderbird plugin is not installed or if it's not correctly configured, the proper error message will appear.
* Restructure module addons-extra/thunderbird
* When you want to archive a mail containing an attachment, it opens a window saying "Mail contains attachment!". This window is not useful so removed.
* Rename "Create" button on the bottom left corner to "Create Contact".
* When you archive an email with attachments, it asks Would you like to also save attachments of the email:
- Cancel (don't save anything)
- No (create case only)
- Yes (create case + attachments)
* If it's linked to a partner or address, it will fill in the partner and/or address when it creates a case.
* We have two buttons to archive from the archive window:
* Create Case (the current action)
* Attach (don't create a case but save the email as a normal .eml
file + his attachments, on the selected object). -> this one does not need a section.
* Select all model and search.
* Reviewed all dialogue window. It will ask for Cancel and Ok at the right in each window.
* We have found few bugs and enhancements at the time of testing. We will fix it soon.
Testing on windows platform is going on.
Some modules are in trunk community addons :

1.l10n_nl
Contributor : Veritos - Jan Verlaan (http://www.veritos.nl)

2.printjob
Contributor : Pegueroles SCP (http://www.pegueroles.com)
Featutes :
* Enables batch printing
* Correct memory leak when printing crashes
* Permits reprinting lost PDFs
* Possibility to send jobs to a printer attached to the server

3.price_adjust
Contributor : Niels Huylebroeck (http://www.bubbles-it.be)
Features:
* Price Adjust Wizard :
This wizard will allow you to adjust Cost Price and Sale Price for entire categories.
We can either set a fixed price or use a multiplier to increase or decrease the price.

4.account_customer_ref
Contributor : Alberto Garcia & Tiny
Features :
* Add Sale Customer Ref to Invoice
* In each invoice line show the customer ref of Sale Order origin

5.sale_report_html
Contributor : Tiny (http://www.openerp.com)
Features:
* New HTML report of sale order using MAKO template
* Note: Your system should have mako 0.2.4 installed.

6.account_receipt
Contributor : Paulino
Features:

1.report_truetype
Contributor : EduSense BV (http://www.edusense.nl)

Features :
Module to add any TrueType font to reports. This module transparently extends the report machinery to use TrueType fonts. The normal mechanisms used in Open ERP use the standard Type1 fonts in a latin1 encoding. This prevents usage of wide char character sets, known as UTF-8 and UTF-16 fonts.
This module enables the usage of any TrueType font, which are by definition UTF-8 encoded. The implementation chosen is a one-time registration of all found TrueType fonts in locations as advertised by rl_config.TTFontSearchPath during startup of the server. The path can be adapted to your needs. See reportlab's documentation for the details.
The consequence of this implementation is that new fonts will only be loaded after restarting the Open ERP server. Advantage is that the penalty for scanning and registering is paid only once every server run.
After loading, all reports generated by Open ERP can use these fonts by stating their formal mapped Type1 name, which can be found by running 'ttmkfdir' in the directory containing the fonts (unix like platforms). The typefaces will be listed in the file 'fonts.scale'.

TODO:
* One should be able to replace existing fonts using a map.
* One should know the registered fonts without peeking into the file system, let alone using rare utils.

by dso (tiny erp) (noreply@blogger.com) at June 09, 2009 06:40 AM

June 04, 2009

Fabien Pinckaers    

Meet us at Euro Python - Birmingham, UK

This year, the world's biggest Python event, Euro Python, will be organised in Birmingham (UK), the 28th of June, up to the 4th of July. Fabien Pinckaers, Open ERP's founder and CEO will do two conferences: one on Open Object, one on Open ERP. these conferences are scheduled for the 30th of June and the 1st of July.

The complete time table is available on the Euro Python website:
We will attend Euro Python for these two days. We hope to meet you in UK to discuss Open ERP issues. If you want to organize a meeting with Fabien Pinckaers during this period, contact cde AT openerp.com

by Fabien Pinckaers (noreply@blogger.com) at June 04, 2009 04:21 PM

OpenERP 5.0    

Open ERP Integration With Google Map

Hello,

We have come up with new features, which gives you flexibility to get your data like, partner information : individual partner information, country wide partner information on Google MAP with just one click. It is very simple to have your data from any Open ERP database on Google MAP.

Now, we have made it easier to trace partners information with name, address, code, receivable and payable, etc on a single click from Google map. More over you can get contry wise data for total number of partners, complied with number of invoices made and total turnover for respective country. Also you can find delivery routes with customer and warehouse locations, with number of deliveries and number of products sent.

This will provide great ergonomic and rich ERP interface to end user. With this, in few clicks you can analyse and keep track of your business in real time.









How to use:
- Install Google_earth on your Open ERP database.
- You will find this module at Menu -> Partners -> Google Map / Earth
- You will get
- Customer on map with turnover
- Partners country on map
- Delivery routes find

- By running these wizard, you will get KML file, upload it in your google map account
- Now, enjoy looking at analyze data on Google MAP.

Thank you,
Open ERP Team.

by dso (tiny erp) (noreply@blogger.com) at June 04, 2009 02:35 AM

May 31, 2009

Fabien Pinckaers    

Manufacturing Capacity Planning

Here is a one minute screencast that shows the Gantt chart features of Open ERP and how we use it to manage the manufacturing planning. Enjoy the power of the Open ERP user interface. That's a good proof we can do smart applications with web interfaces today.

You must install the mrp_operations module to do this.



The screencast has two parts.

Part 1: Work Orders Planning

We compute a manufacturing order (a PC2) that has 4 work orders related. Two of these 4 work orders can be launched in parallel and the others must be serialized. We use the gantt chart to planify the operations. Open ERP is smart enough to:
  • Serialize some operations, recomputing dependencies
  • Adapt length of work orders according to day/time (because workcenters are configured to work from monday to friday, 8 hours a day)
  • Synchronize work orders and manufacturing orders.
Part 2: Manufacturing Orders Planning

The phase 2 show the production of a PC0, that has two others manufacturing operations in make to order (PC2 and CPU_GEN). It shows the different dependencies between the orders and how Open ERP computes automatically length, durations and partsdependencies. Of course, work orders on the different work centers synchronize automatically with manufacturing orders.

If you are interrested by logistic or manufacturing processes, I suggest you to have a look at the new Open ERP book.

by Fabien Pinckaers (noreply@blogger.com) at May 31, 2009 04:04 PM

May 29, 2009

OpenERP 5.0    

Open ERP made language translation easy with Google Translate

Hello

Now translate Open ERP terms / fields / objects etc. in any language, as we have made it easier for you with the integration of Google Translate.

We have developed new module which can translate your terms using google translate, You can find menu here: Administration / Translation / Application terms / need review terms…


Google Translate




After Translation



Enjoy using your favorite OpenERP application with Google Translation.

You can get these modules on launchpad in trunk-extra-addon

Name of the module

1. Google_translate

Thanks,

OpenERP Team.

by dso (tiny erp) (noreply@blogger.com) at May 29, 2009 01:03 AM

May 25, 2009

Cecile Debois    

New Open ERP Book : Retail and Industrial Management

Open ERP for Retail and Industrial Management

We are proud to announce the new Open ERP book - Retail and Industrial Management, steps towards Sales, Logistics and Manufacturing Integration
in the Open Source & Management Collection.

This book is about the use of Open ERP in a leading ERP system for manufacturing and stock management.

It's one of a series of books from Open Object Press on the use of Open ERP in a range of enterprise settings.

Availabilities

This book is available in english on our website at the price of 29,9 € at the following link : http://www.openerp.com/fr/buy/books.html

Introduction

Do you dream of the perfect company ?

That's the company where information moves freely between all functional areas, where you never have to enter data a second time, and everything is centralized in a single enterprise management system. This is the place where you rarely work on anything in a panic because everything is planned and well-structured, where everybody has permanent access to all useful information, and where all routine tasks are automated and easily controlled. This book represents a modern approach to retail and industrial management, giving you the tools for implementing this type of integrated management based on Open ERP.

The Authors

Fabien Pinckaers is the founder and director of Tiny sprl. In four years he created a group of over 80 employees with no borrowings or need for capital. In this Collection he presents his management methods and the software that enabled such organic growth.

Author of articles and books on the precesses and technologies of innovation, Geoff Gardiner is the managing director of Seath Solutions Ltd in the UK. Seath Solutions is a leader in improving working processes and integrating management information.

About Open ERP

With more than 1000 downloads per day, this is the most admired and used free and open source management software solution in the world. It covers all the modular and flexible enterprise functions, including customer relations, sales management, accounting, finance, stock management, project management, internal organization, human resources, purchase management, and manufacturing management.

Next books to come

- Customer Relationship Management
- Service Company Management
- Accounting



by Cécile (Open ERP) (noreply@blogger.com) at May 25, 2009 04:59 PM

© 2001-TODAY Tiny sprl. All rights reserved.
OpenERP and OpenObject are trademarks of the Tiny company.
They both are released under GPL V2.0.