How to install Pentaho Bi Server with ubuntu 12.04 LTS server

PART-I Pr-requisites 1)Ubuntu Server Find OS: lsb_release -a Outupt : No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 12.04.3 LTS Release: 12.04 Codename: precise 2) Mozilla firefox(Preferrable for pentaho) Version 35

Read More Leave comment

Concatenating Two Fields Using Pentaho Data Integration

In formal language theory and computer programming, string concatenation is the operation of joining character strings end-to-end. For example, the concatenation of “foot” and “ball” is “football”. In programming, string concatenation generally occurs at run time, as string values are not in general known until run time. However, in the case of string literals, the values are known at compile time, and thus string concatenation […]

Read More Leave comment

Time consuming search issue (Deletion of temporary search)

In our Central server ( Customer Relationship Management) large amout of data is processed, there is also a search function that requires continuous insertion of vast amount of data in temporary tables of search. To search a record a record first the records will be fetched using all the filters provided by hitting a dynamically prepared sql query. The results are then inserted in temporary […]

Read More Leave comment

Translate QWeb Report in Odoo 8

When we make any module which will be used in multiple geographical region and will be accessed in multiple languages at that point of time we have to add language support to the module. In this blog we will see how to add Multi-Language support in QWeb reports of Odoo 8. Translation is supported by Odoo, but you will be wondering the way odoo used […]

Read More Leave comment

Use Of Parameters In Pentaho Data Integration

In computer programming, a parameter is a variable, used in a subroutine to refer to one of the pieces of data provided as input to the subroutine. These kind of data are called arguments. You will always come up with situations when you need to address these kind of variables inorder to overcome the burden of reusing certain values for every job and transformation and […]

Read More Leave comment

MySQL to Maria DB Migration

MySQL to Maria DB Migration This Blog is related to MySQL to Maria DB Migration With Oracle’s fairly recent acquisition of MySQL, a lot of people are looking to move away from MySQL in fear of Oracle changing the licensing, which could force you to change database backends. # service stop apache2 # service stop nginx # service stop mysql Next, make a simple mysqldump […]

Read More Leave comment

Syntax Migration from OpenERP 7 to Odoo v8

In Odoo v8 Syntax is the main thing which is new to the Developers. It’s Simple, Easy to Use and more flexible than OpenERP7 Syntax. Here are some Syntax changes in Odoo v8 API 1. Statement: OpenERP 7 Search Syntax: self.pool.get(‘model.name’).search(cr, uid, [(‘operand1′,’operator’,’operand2′)])

Read More Leave comment

Creating New Ids Using Combination Lookup Step In PDI

In database relationalship modeling , a unique key is a set of zero, one, or more attributes. The value(s) of these attributes are required to be unique for each tuple (row) in a relation. The value, or combination of values, of unique key attributes for any tuple should not be repeated for any other tuple in that relation. When more than one column is combined […]

Read More Leave comment

Insert fields into PDF name

All reports are composed with the help of HTML/Qweb by using Report Template in Odoo, . The PDF conversion itself is taken care by wkhtmltopdf.If user need to create a report for a particular model, user will have to define this report and the report template it is going to use. If user wish, he/she can also declare a specific paper format for this report. […]

Read More Leave comment

Installing & Configuring OpenLDAP Server CentOS 6.5

How to Installing & Configuring OpenLDAP Server CentOS 6.5 This blog is all about Installing & Configuring OpenLDAP Server CentOS 6.5.The Lightweight Directory Access Protocol is an open, vendor-neutral, industry standard application protocol for accessing and maintaining distributed directory information services over an Internet Protocol (IP) network.Directory services play an important role in developing intranet and Internet applications by allowing the sharing of information about users, […]

Read More Leave comment