Blogs

Backup and Restore of complete OpenERP in Linux(Ubuntu)

This is just some simple tips for moving an OpenERP server instance and Database from a Linux server to another Linux physical server. Normally Debain based Ubuntu is recommend to install OpenERP. Hope this will help at least some beginners. Good luck :) This process is normally done using linux commands as mentioned below.

1) On Source Server
.ssh to existing OpenERP server as the user running OpenERP

Quickbooks - OpenERP Integration

This integration module aims at transfer of data saved in quickbooks to OpenERP. The following applications is used for this purpose

          a) Quickbook Web Connecter

          b) PHP DevKit from Consolibyte

What's new in OpenERP 6.1

In this blog i am trying to make an analysis of the new features in OpenERP 6.1 along with a comparison of it with version 6.0. OpenERP 6.1 is more fast, modular, powerful and user friendly. And also comes with advanced business features.

Rental Solution using OpenERP

    'Rental Solution in OpenERP', provided by Zesty Beanz is an integration of popular OpenERP modules 'crm' and 'rent'. The solution converts leads and opportunities into rent order and manges the return of the rented products without affecting stock equations and accounting parameters. Let's have a look into the flow of events

1. Create Lead

Menu : Sale > Leads

Email using email_template in OpenERP 6.1

email_template is a default module of OpenERP which is used to send emails from OpenERP. It is much easier than smtp_client and the template of the mail can be easily customized. We can configure outgoing email server and template of email_template from Setting > Configuration > Email. The outgoing mail server of email_template can be configured from "Outgoing Mail Servers" in  Setting > Configuration > Email. The following is a screenshot of configuring outgoing mail server in email_template.

Importing different csv file templates to a single Model(Object) in OpenERP

This in an interesting module in OpenERP which I found useful recently for importing different csv file templates to a single object(model) in OpenERP. For example when we create a crone job (scheduler) to import csv files from different suppliers with their invoices which has different structure to the Customer Invoices in OpenERP. Below is a generic explanation of the existing module.

Crosstab in iReport

iReport is an reporting tool used for designing jasper report in OpenERP. In OpenERP it is difficult to create a report that has a dynamic column. For instance consider an example of a project report that has details regarding the project task completion date. The task name will be the name of the column. In such cases, the cross tab in report comes handy.

XLS Formula in Jasper Report using iReport

Jasper report is an reporting tool used in OpenERP for printing the reports in formats like pdf, Excel, HTML etc. Lets consider an example about the accounting reports. The report contain details regarding the credit amount, debit amount balance etc. It would be very useful if the report is printed in excel format. In excel sheet we will be able to specify the formula based on which each cell value is calculated. So if we are generating the excel sheet from jasper report we should be able to specify the formule in jasper report which should be used in the excel sheet.

Basics of Umbrello UML Modeller

Introduction

Filtering in one2many fields -OpenERP

Last week I got into a situation that I really need to use filtering in tree view of one2many field. I have seen the use of filtering in search view, but not in tree view of a one2many field.
Example:
Note:this is just an example.
I have created a sale order. Here same product comes 2 or 3 times.