Archive

Posts Tagged ‘GTK’

Deleted records in OpenERP

December 21, 2011 Leave a comment
The blue/white elephant logo of the PostgreSQL...

Image via Wikipedia

Sooner or later you will find yourself with pgAdmin (or any other query tool) querying the OpenERP database in order to pull statistical information. It happens, and it is a healthy sign of your OpenERP implementation.

Something you need to keep in mind is how OpenERP “deletes” its records. It does not physically remove them. It just marks them as deleted. And it does so with the active field in the table. This field, which happens to be a boolean field, if true indicates that the record is not deleted. Otherwise you should not take the record into account in your queries.

Cheers!

Time-outs and the openerp-web client

December 20, 2011 Leave a comment

Sometimes you need to change the time-out setting of your openerp-web client application. There might be many reasons for this, among them the need to submit long  processes or views that take minutes to retrieve the desired data. Doing this is no big deal with the GTK client, but gets tricky  when it comes to the web client since you get a time-out error message after two minutes of inactivity.

How do you solve this? It’s easy. In OpenERP v5 you need to locate the file tiny_sock.py. In that file, search for the file that reads:

self.sock.settimeout(120)

In my web client, that happens to be the line 49. Then you change the parameter of the settimeout function to the number of seconds you desire. Then restart your web client.

With OpenERP v6 is pretty much the same story, now you do not need to modify the source code. You only need to change the openerp-web.cfg configuration file. In that file, you will find the following entry in the OpenERP Server section:

openerp.server.timeout = 450

Then you have to restart your web client application.
That’s all you need to do in order to change your timeout settings in your OpenERP Web Application.

Cheers!

A quick look at OpenERP user interface

December 20, 2010 Leave a comment

Just a quick note before starting, this post covers OpenERP 5.0 user interface. I will cover 6.0 UI when it is released.

Most of the times, the information you see at OpenERP is either a List or a Form. The first ones are a list of business objects you can view or edit, whereas the latter allow you edit those business objects. So far so good. What might be difficult to grasp at first is how to fill out those forms or how to navigate those lists. Hence this post.

We will begin with the buttons we find in a form. The image below shows an standard form of a partner in the GTK client:

 

OpenERP GTK Client Screenshot

OpenERP GTK Client Screenshot

 

On the top right side of the main tab we can find three buttons. New, Save and Edit, and Cancel. These buttons save what we have done or let us cancel our cnahges. They are designed to allow you change the entry form state. To the right of the buttons we can find the navigation buttons, which allow us go to the previous record on the list and the next one.

After choosing one of the items on the list, we can edit it. Entry forms in OpenERP have a hierarchical structure, with main entries and secundary entries. They can be mandatory or not, and can be identified with the light blue color. They turn red when the user did not enter any information in them.

The secondary entries can be found in the different tabs in the form. For instance, the partner has the following tabs: Main, Sales and Purchases, History, Notes, Accounting and Categories. I advise you to check the different entries before continuing with the form. Below you will see an icon with a hard disk and an arrow pointing at some of the entries.

 

OpenERP buttons

OpenERP buttons

 

This icon indicates that it is necessary to save the form before continuing with the entry (just pressing the icon is enough). The entries with these arrows are lists. For instance, the partner can have different contacts and filling this form allows you to create more contacts for this partner.

 

Lookup button on OpenERP

Lookup button on OpenERP

Another important icon is the folder button, with a magnifying glass on it. This button is related to reference entries. This means that the information to be intered has to exist in the system database. A different way of entering information in a reference field is to write the first letters of the value we wish to enter and press Tab, the system will complete the field with the first value that matches the letters entered on the field. Keep in mind that as long as you enable and disable modules some entries might disappear.

Well, enough for today on OpenERP UI. My next post will cover some of the online resources for learning how to use this ERP system.

Cheers!