Article RSS Feed

Open calling partner in 1 click with the OpenERP-Asterisk connector

Raphaël Valyi - Akretion.com — Sun, 13 May 2012 00:00:00 GMT

Open calling partner in 1 click with the OpenERP-Asterisk connector

Akretion, the author of the OpenERP-Asterisk connector, is proud to announce the immediate availability of a new feature on the connector: the ability to open the calling partner in one click in OpenERP.

Here is a typical usage scenario of this new feature:

Someone calls you and you pickup the phone. You click on the button Open calling partner in OpenERP : OpenERP sends a query to Asterisk to get a list of the current phone calls.
If OpenERP finds a phone call involving the user’s phone, it gets the phone number of the calling party.
OpenERP searches the phone number of the calling party in its database and, if a record matches, it shows the name of the related Partner and proposes to open it, or open its related sale orders or invoices:

Another incredible thing about this new feature is that it’s already fully documented on the dedicated web page on Akretion’s Web site.

This page also presents Akretion’s service offering to help you deploy the OpenERP-Asterisk connector. Who can better help you deploy this solution than the author of the module himself ?

Please note that this new feature is only available for OpenERP version 6.1 for the moment. But Akretion can backport it to your version of OpenERP on request.

Formation OpenERP - Magento/PrestaShop : 3-4-5 juillet 2012 - Lyon ou Paris

Raphaël Valyi - Akretion.com — Tue, 24 Apr 2012 00:00:00 GMT

Akretion and Camptocamp announce the release of the PrestaShop-OpenERP connector

Raphaël Valyi - Akretion.com — Thu, 23 Feb 2012 00:00:00 GMT

Akretion and Camptocamp announce the release of the PrestaShop-OpenERP connector

February 23rd 2012

Akretion and Camptocamp announce the immediate and worldwide availability of the PrestaShop-OpenERP connector version 0.1.

PrestaShop is an Open Source e-commerce software written in PHP that provides an easy-to-use and high-performance solution to set up an online shop. OpenERP is an Open Source ERP software written in Python that provides an extended functional coverage: Customer Relationship Management (CRM), sales and purchase administration, stock management, Material Requirement Planning (MRP), accounting, etc.

Many e-commerce companies running PrestaShop are looking for a global solution that includes stock management and accounting. For a successful e-commerce company, automating stock management, supplier orders and accounting are critical in order to have a profitable business. OpenERP and PrestaShop complement each other perfectly:

PrestaShop manages the front office: product catalog, customer accounts, carts, order validation and payment by credit card;
OpenERP handles the back office: stock management, supplier orders, customer claims, accounting, etc.

The only thing that was missing was a connector between these two software!

This first version of the PrestaShop-OpenERP connector has been developed during a one-week code sprint that took place on February 6th – 10th 2012 in Seythenex (Haute-Savoie, France). This large R&D effort of Akretion and Camptocamp (with the participation of one developer from Julius Network Solutions) is the kick-start of a new Open Source software project called PrestashopERPconnect. Akretion and Camptocamp form the PrestashopERPconnect core editors and are the official maintainers of the project.

Sebastien Beau, e-commerce project manager at Akretion, declares: “Our target was to be capable of importing orders from PrestaShop to OpenERP at the end of our one-week code sprint. But before importing the first order, we needed to develop the synchronization of shops, currencies, languages, countries, carriers and products. We reached our target on Thursday evening, so we deserved to go skiing on Friday afternoon at the La Sambuy ski resort!”

Joël Grand-Guillaume, Business Solution Division Manager at Camptocamp in Lausanne adds: “We did not only bring the finest swiss chocolates to this code sprint; we also brought our long experience of software development on the OpenERP framework and our knowledge of software architecture.”

The PrestaShop company contributed to the development of the connector by providing technical support on the PrestaShop webservices that are used by the connector. Nebojsa Stojanovic, Chief Technical Officer of PrestaShop, declares: “The development of the PrestaShop-OpenERP connector is the proof that our large developers community is a key differentiator compared with proprietary e-commerce solutions. We are very happy to see our award-winning Open Source e-commerce platform connected to one of the leading Open Source ERP solutions.”

FAQ about the PrestaShop-OpenERP connector

What is the license of the connector? Where can I get the source code? This connector is published under the GNU Affero General Public License version 3 (the same license as OpenERP). The source code is available on Launchpad: https://launchpad.net/prestashoperpconnect (Launchpad is a development platform that hosts many Open Source software projects, including OpenERP and Ubuntu).
Which versions of OpenERP and PrestaShop are supported? Regarding OpenERP, the connector has been developed on OpenERP 6.1, which was released yesterday. And concerning PrestaShop, it supports all versions of PrestaShop starting from version 1.4, which is the first version of PrestaShop to propose a webservice interface. It doesn’t require any module in PrestaShop. The current version of the connector comes with the mapping of objects between OpenERP 6.1 and PrestaShop 1.5 only. PrestaShop 1.5 is currently under development and will introduce multi-shop support and many other features. Adding support for PrestaShop 1.4 should be easy.
You publish this connector for free on the Internet… how do you earn a living? Akretion and Camptocamp – the PrestashopERPconnect core editors – have developed this connector as part of their R&D effort. Both companies are strong supporters of Open Source software and have a long history of code contributions to OpenERP and other Open Source projects. Instead of spending millions in Sales and Marketing, they estimate that this code contribution is a better means to generate customer demand for software development on the connector and/or OpenERP and also for their trainings, professional services and SaaS (Software as a Service) offers.
Is the connector ready for production use? This version 0.1 has all the essential building blocks to connect OpenERP and PrestaShop and already supports the import of orders from PrestaShop to OpenERP in simple scenarios. Depending on how PrestaShop is used, generic or specific developments on the connector may be required.
What should I be aware of before deploying the connector? This connector can be downloaded by anyone on the Internet but it requires deep knowledge of OpenERP, PrestaShop and the connector’s internals to be deployed successfully in production. The PrestashopERPconnect core editors are available to help you deploy this solution for your PrestaShop-based e-commerce business.

About Akretion

Akretion is an OpenERP-expert company based in Brazil (Rio de Janeiro) and France (Lyons) with a strong experience in e-commerce projects. Akretion key contributions to Open Source software include the Magento-OpenERP connector, the Asterisk-OpenERP connector, the Brazilian localization for OpenERP, support for French customs formalities (DEB and DES) in OpenERP and the OOOR connector to use OpenERP from the Ruby programming language. Akretion sells training, consulting, software development and SaaS (Software as a Service) on OpenERP.

About Camptocamp

Incorporated in 2001, Camptocamp is an Open Source software editor and integrator in three complimentary areas: Business Solutions (OpenERP, Business Intelligence, e-commerce), Geospatial Solutions and Infrastructure Solutions. Camptocamp strives to deliver high value-added services (consulting, R&D, training, support) to its customers in order to assist them in deploying efficient and sustainable Open Source applications. Based in Lausanne (Switzerland), Chambéry (France) and Vienna (Austria), Camptocamp counts 43 employees with functional as well as technical skills.

Press contacts

Akretion: Alexis de Lattre – Mail: alexis.delattre (at) akretion.com
Camptocamp: Maxime Wiot – Mail: maxime.wiot (at) camptocamp.com – Phone: +33 4 79 44 44 94 or +41 21 619 10 10

Formation OpenERP - Magento : 3-4-5 avril 2012 - Lyon

Raphaël Valyi - Akretion.com — Thu, 16 Feb 2012 00:00:00 GMT

Formation OpenERP - Magento : 24-25-26 janvier 2012 - Paris

Raphaël Valyi - Akretion.com — Tue, 10 Jan 2012 00:00:00 GMT

master your OpenERP data integration with Akretion TerminatOOOR!

Raphaël Valyi - Akretion.com — Fri, 09 Dec 2011 00:00:00 GMT

OpenERP is all the rage among open source ERP’s but its native import/export have limitations when it comes to data integration. Server side OpenERP import/export is powerful but not so easy to get started and get interfaced. On the contrary, the famous Kettle open source ETL from Pentaho connects to almost anything, any SGBD thanks to the JDBC connectors, any CSV, Excell files…

With TerminatOOOR you have all the power of the full OpenERP API right inside your ETL data in/out flow. You can do any Create Read Update Delete operation enforcing the access rights of OpenERP. But you are absolutely not imited to that, in fact you can just do anything you would do with your OpenERP client: click buttons, perform workflow actions, trigger on_change events… This is because OOOR gives you the full access to OpenERP API.

We created TerminatOOOR back in late 2009 for a customer doing ecommerce sales on several different channels: Magento, OSCommerce, Amazon, Ebay, using several payments gateways and bank interfaces. Later we continued to use it in similar projects where integration with other systems would make the difference. It’s also used a lot for loading your data into OpenERP when you migrate to it. But those are just a few possibilities… We finally got the time to package TerminatOOOR for an easier installation and we also documented it extensively.

All right, so don’t wait any longer and read the detailed documentation You might also be interested in downloading it or looking at its source code

We would also here thank all the great people who made this possible: the Kettle guys, Slawomir Chodnicki who revolutionized the Ruby Kettle plugin, all the JRuby team and specially people like Charles Headius Nutter, Yannick Buron for helping in the first doc version a year ago, CampToCamp and Ting.es for their testing and patches on OOOR and all the people who tested and helped in a way or another.

Enjoy!

Some news about product_variant_multi

Raphaël Valyi - Akretion.com — Fri, 28 Oct 2011 00:00:00 GMT

Some news about product_variant_multi

October 28th, 2011

Recently Akretion made some changes on product_variant_multi. Indeed, we redesigned the automatic generation of the variant names. Before, it was only possible to access the name of the dimension and the name of the option selected.
For example, the default model for the variant name was [NAME] – [VALUE], and if your company had some custom fields on product.variant.dimension.option, it was not posible to generate a custom variant name with them.

We now use a generic syntax which is the same as the code generator syntax (better homogeneity). If you want to have the same result as before, you should use the following syntax : [_o.dimension_id.name_] – [_o.option_id.name_] where o is the object product.variant.dimension.option. And if your company added a field on the object product.variant.dimension.option, you can use the syntax [_o.dimension_id.name_] – [_o.option_id.my_custom_field_].

Also we introduced the field code on product.variant.dimension.option and we replaced the default syntax by [_o.dimension_id.name_] – [_o.option_id.code_]. This little change adds a lot of possibility for variant name customization.

We hope that you will like these enhancements and that you will have a smooth upgrade of the module product variant multi with the above instructions.

Benchmarks with OpenERP server hosted on the Internet

Raphaël Valyi - Akretion.com — Thu, 27 Oct 2011 00:00:00 GMT

Benchmarks with OpenERP server hosted on the Internet

October 27th, 2011

As Akretion starts to host some OpenERP servers for its SMB customers, we want to propose them a solution that is both fast and secure. So far, the majority of our customers host the OpenERP server on their LAN and access it via the Gtk Client through the Net-RPC protocol. The Net-RPC protocol is fast but not secure : the passwords and all the data are sent in clear, but our customers consider that, as the connection is made over their LAN, it’s not a problem. By the way, it is probably a bad assumption, because a lot of IT attacks against companies come from the inside ! And when our customers need to access OpenERP from outside the office, they connect by VPN to their LAN and then they use OpenERP as usual with Gtk Client and Net-RPC protocol.

In order to select the best option for our customers that access an OpenERP server over the Internet, we made a real-life benchmark with an OpenERP server running on a machine in a datacenter, and elaborated a precise usage scenario. Basically, the scenario consist in a full purchase workflow (PO, reception of goods, supplier invoice) and a full sale workflow (SO, delivery order, customer invoice). For each protocol, we executed this scenario manually multiple times. We kept the fastest timing that was measured. As we ran the scenario manually, we estimate that the results are valid with a 10 seconds accuracy.

Bench with OpenERP server hosted on the Internet

	Net-RPC	Net-RPC inside SSH tunnel	XML-RPC	XML-RPC SSL	HTTP access with Firefox 7	HTTP access with Chrome 14	HTTPS access through an Nginx proxy with Chrome 14
Secure ?	no	yes	no	yes	no	no	yes
OpenERP 6.0.3	1 min 49	1 min 47	2 min 11	3 min 08	2 min 04	2 min 11	2 min 05
OpenERP 6.1 (trunk)	1 min 42	1 min 40	1 min 52	not available ?	buggy	1 min 43	1 min 40

Bench with an OpenERP server hosted on the LAN

	Net-RPC
OpenERP 6.0.3	1 min 15
OpenERP 6.1 (trunk)	1 min 08

Here is our analysis of the results of this benchmark :

OpenERP 6.1 is faster than OpenERP 6.0, thanks to the optimisations in the code of the server and addons (and also thanks to an ergonomy improvement on invoice generation from delivery orders).
XML-RPC SSL is not an option because it’s too slow. If you activate the debug logs on the OpenERP server, you will see that the SSL session is re-established for every request, which explains the bad performances.
on OpenERP 6.0, Net-RPC is the fastest, but the Web interface is not too far behind : only 15% slower.
on OpenERP 6.1, the Web interface is as fast as Net-RPC !

The developers of the new Web interface of OpenERP 6.1 made a great job ! Thumbs up !

As a conclusion, for those who plan to use an OpenERP server over the Internet, the best option is probably to upgrade to version 6.1 when it will be released and use the new OpenERP Web interface via HTTPS through a reverse proxy (more explainations about reverse proxy on Wikipedia).

New OpenERP - RMA module by Akretion

Raphaël Valyi - Akretion.com — Thu, 13 Oct 2011 00:00:00 GMT

New OpenERP - product (supplier) warranty module by Akretion

Raphaël Valyi - Akretion.com — Wed, 12 Oct 2011 00:00:00 GMT