Asier Zabaleta
Author Archive

Asier Zabaleta

Image_Placeholder_Openbravo_Tech_750x375_v02



Today im going to show you a simple module that will integrate Openbravo ERP with Zoho reports. The aim is to set up a background process sending data from the ERP to Zoho. Then, after creating custom reports on Zoho, publish them in your Openbravo ERP workspace so that relevant data for your company is always on hand.


Pre-requisites:

  • Zoho user account (free)
  • Zoho integration module for Openbravo ERP 3.0

Setting up the data transfer



First of all you need to have a new database in Zoho reports.

Then find the Zoho API key for your account. (Mandatory for sending data to your zoho account).


Now lets configure the process in Openbravo ERP. Create a Zoho integration header with the folowing information:
  • Zoho database (the one you created in the previous step)
  • Zoho API key
  • Zoho username
  • Zoho password
Then, configure an HQL for sending data to our Zoho database.
  • Import type: Choose between “Delete all and import data”, “Append” or “Update”.
  • Zoho Table (this process will create this table in Zoho Reports)
  • HQL query. (In this example I created a simple query for “Sales by Organization”
And last, schedule the process for sending this data to Zoho. In this case, I have configured this process to be run every 1 minute. Then hit “Schedule Process”.
From now on, this process will create a new table in your Zoho Reports account, with the data of your ERP.


Report Creation
Time to create a report in Zoho reports with this data.


When done, save the chart and click on Publish and “Embed in Website/Blog”.


Copy the HTML snippet and return back to Openbravo ERP to add a widget with this HTML code. Create an “User defined HTML widget”.


Then just paste the HTML code from Zoho Reports:


And… Voilá !


Meaningful information for you company updated in real time in your Openbravo ERP workspace. And the best: No need for development skills to do it !


This article shows the power of how different separate parts of Openbravo technology can be combined to create a great solution.
  • Openbravo widgets
  • Openbravo Process Scheduler
  • Openbravo – Hibernate integration
And this is just an example of why web solutions are so powerfull these days. Their ease of integration with other tools make them a must !!



Any doubts or inquiries, I would be glad to answer them :)


Read More
Image_Placeholder_Openbravo_Tech_750x375_v02
Modularity



Today im going to show you a simple module that will integrate Openbravo ERP with Zoho reports. The aim is to set up a background process sending data from the ERP to Zoho. Then, after creating custom reports on Zoho, publish them in your Openbravo ERP workspace so that relevant data for your company is always on hand.


Pre-requisites:

  • Zoho user account (free)
  • Zoho integration module for Openbravo ERP 3.0

Setting up the data transfer



First of all you need to have a new database in Zoho reports.

Then find the Zoho API key for your account. (Mandatory for sending data to your zoho account).


Now lets configure the process in Openbravo ERP. Create a Zoho integration header with the folowing information:
  • Zoho database (the one you created in the previous step)
  • Zoho API key
  • Zoho username
  • Zoho password
Then, configure an HQL for sending data to our Zoho database.
  • Import type: Choose between “Delete all and import data”, “Append” or “Update”.
  • Zoho Table (this process will create this table in Zoho Reports)
  • HQL query. (In this example I created a simple query for “Sales by Organization”
And last, schedule the process for sending this data to Zoho. In this case, I have configured this process to be run every 1 minute. Then hit “Schedule Process”.
From now on, this process will create a new table in your Zoho Reports account, with the data of your ERP.


Report Creation
Time to create a report in Zoho reports with this data.


When done, save the chart and click on Publish and “Embed in Website/Blog”.


Copy the HTML snippet and return back to Openbravo ERP to add a widget with this HTML code. Create an “User defined HTML widget”.


Then just paste the HTML code from Zoho Reports:


And… Voilá !


Meaningful information for you company updated in real time in your Openbravo ERP workspace. And the best: No need for development skills to do it !


This article shows the power of how different separate parts of Openbravo technology can be combined to create a great solution.
  • Openbravo widgets
  • Openbravo Process Scheduler
  • Openbravo – Hibernate integration
And this is just an example of why web solutions are so powerfull these days. Their ease of integration with other tools make them a must !!



Any doubts or inquiries, I would be glad to answer them :)


Read More
Image_Placeholder_Openbravo_Tech_750x375_v02
User Interface

Hi,
As a Openbravo ERP consultant and member of the Openbravo Community, I am always curious about what is coming next in the product; in particular, I am now interested in the progress of the new user interface for 3.0.
To satisfy my curiosity, I o…

Read More
Image_Placeholder_Openbravo_Tech_750x375_v02

Hi,
As a Openbravo ERP consultant and member of the Openbravo Community, I am always curious about what is coming next in the product; in particular, I am now interested in the progress of the new user interface for 3.0.
To satisfy my curiosity, I o…

Read More
Image_Placeholder_Openbravo_Tech_750x375_v02
Development Environment

The other day a customer running a Cloud appliance needed to replicate its production environment into 3 new servers. These were the options

  1. Deploy Openbravo ERP by doing a custom installation in the 3 servers and then move the actual installation to these 3 new servers.
  2. Deploy Openbravo ERP using a community appliance and then move the actual installation to the 3 new servers.

Using an appliance for deployment makes things not just quicker but a lot easier for the system integrator. You won’t just save some hours deploying each new server, but you will also be sure that everything is well configured and optimized.

Similar reasons apply to the task of moving the actual instance (database + modules) to the servers. It’s a time consuming task, moreover when you need to repeat it three times. There are a lot of manual commands to be executed and mistakes can happen. Even doing the steps correctly, this task for the 3 servers should take around 2 working days.

But, as the customer was using the Openbravo Professional Edition, they had the Cloud appliance up and running.


This made much easier the replication of the environment. The Cloud Appliance does not introduce improvements in the deployment of Openbravo ERP compared to the community appliance, but provides significant advantages to Professional Edition Subscribers managing the instance, as the steps went down to these:

  1. Download the last backup from the production environment
  2. Upload it to each 3 servers
  3. In each server click on Restore that backup.

As you can see, the Openbravo Cloud Appliance (manual) does not only allow you to spend more effectively your time maintaining your instance, but also avoids unexpected errors and problems in these critical manual tasks.

In the end, the replication of the original environment in 3 (counting that they all use the Professional Edition) was done in less than 4 hours.

Read More
Image_Placeholder_Openbravo_Tech_750x375_v02

The other day a customer running a Cloud appliance needed to replicate its production environment into 3 new servers. These were the options

  1. Deploy Openbravo ERP by doing a custom installation in the 3 servers and then move the actual installation to these 3 new servers.
  2. Deploy Openbravo ERP using a community appliance and then move the actual installation to the 3 new servers.

Using an appliance for deployment makes things not just quicker but a lot easier for the system integrator. You won’t just save some hours deploying each new server, but you will also be sure that everything is well configured and optimized.

Similar reasons apply to the task of moving the actual instance (database + modules) to the servers. It’s a time consuming task, moreover when you need to repeat it three times. There are a lot of manual commands to be executed and mistakes can happen. Even doing the steps correctly, this task for the 3 servers should take around 2 working days.

But, as the customer was using the Openbravo Professional Edition, they had the Cloud appliance up and running.


This made much easier the replication of the environment. The Cloud Appliance does not introduce improvements in the deployment of Openbravo ERP compared to the community appliance, but provides significant advantages to Professional Edition Subscribers managing the instance, as the steps went down to these:

  1. Download the last backup from the production environment
  2. Upload it to each 3 servers
  3. In each server click on Restore that backup.

As you can see, the Openbravo Cloud Appliance (manual) does not only allow you to spend more effectively your time maintaining your instance, but also avoids unexpected errors and problems in these critical manual tasks.

In the end, the replication of the original environment in 3 (counting that they all use the Professional Edition) was done in less than 4 hours.

Read More
Image_Placeholder_Openbravo_Tech_750x375_v02
User Interface

Hi,
Skinning Openbravo ERP to fit a company’s corporate colors is usually a required task in an implementation project. Let me show you a few easy steps to start creating your new skin and seeing the effects from the beginning.
What Im going to do is …

Read More
Image_Placeholder_Openbravo_Tech_750x375_v02

Hi,
Skinning Openbravo ERP to fit a company’s corporate colors is usually a required task in an implementation project. Let me show you a few easy steps to start creating your new skin and seeing the effects from the beginning.
What Im going to do is …

Read More
Image_Placeholder_Openbravo_Tech_750x375_v02

With the release of the iPad ( http://www.apple.com/ipad/ ) a new range of possibilities can be discovered regarding the ERP mobility world.See this example about launching a Stock report in Openbravo ERP on an iPad.See also a Sales invoices dimensiona…

Read More
Image_Placeholder_Openbravo_Tech_750x375_v02
Mobility

With the release of the iPad ( http://www.apple.com/ipad/ ) a new range of possibilities can be discovered regarding the ERP mobility world.See this example about launching a Stock report in Openbravo ERP on an iPad.See also a Sales invoices dimensiona…

Read More