Archive for February, 2011

Thursday cloudy reads

February 24, 2011 Leave a comment

OpenERP module of the day: base_crypt (or encrypting your user password in OpenERP)

February 22, 2011 2 comments
Category:WikiProject Cryptography participants

Image via Wikipedia

This is a quick post. I found this base module which is quite useful and I wanted to share it with you. The module is base_crypt and it encrypts user passwords in the OpenERP database. By  default OpenERP stores user passwords in the res_users table, they are stored in plain text in the password field. base_crypt module encrypts all passwords with the MD5 algorithm. Below is the link for downloading the module:

IMHO, this module should be part of core since it is a good security practice to store passwords in encrypted form. In some places it is mandated by law. It is also a nice module to look at, checking its code is fun.


Monday reads

February 21, 2011 Leave a comment
Categories: Reads

Python Entre Todos – A new online Python magazine (in english, of course)

February 20, 2011 Leave a comment
Python logo

Image via Wikipedia

PET, or Python Entre Todos (which means “Python among us” in spanish) is a new Python online magazine. It is written by argentinian Python developers in spanish and english. You can find the english issue here:

Python Entre Todos – English Translation – Issue #1

The goal of the magazine is to spread Python as a programming language in the community.

Why I read it? here are some of my reasons:

  • even though you don’t need Python to implement OpenERP, the more you know about this programming language the better. And reading a Python magazine is a good way to improve my OpenERP skills
  • I miss Python Magazine
  • I do not find good printed technical magazines, so I have to fall into online magazines. And I think PET will become one of my favorites soon
  • the more knowledgeable in Python the OpenERP is, the better. We will have better modules, and OpenERP will be more modular. Which will increase its adoption

So far there is one issue online, but two more issues are on the way.

Have a great Sunday!

OpenERP module of the day: sale_delivery (or managing open orders)

February 20, 2011 Leave a comment

Image via Wikipedia

Quick Sunday post. The sale_delivery module allows you manage open orders on OpenERP. An open order is when your client orders from you a product that needs to be delivered in multiple packings. After installing the module, every time you create a sales order you will notice a new tab with the delivery planning. There you will be able to enter when  you are planning on when and how many units of your product you are planning on delivering. Later, you will be able to invoice the customer from packing

Where is this module useful? In places like Argentina. Many businesses have open orders with their clients. This is a very common use case. Other common use cases are invoicing (that is the first one) and managing stock. Not surprisingly financial accounting is not on the list, since a huge size of the economy is informal.

Have a good Sunday!

Thoughts on a modular OpenERP

February 18, 2011 2 comments
Image representing Microsoft as depicted in Cr...

Image via CrunchBase

Sharing my thoughts on how we have been using OpenERP these past four months. Couple of our customer (which happen to be small businesses) appreciate it as a full integrated system, and they are starting to use most of its modules. Starting with financial management for creating invoices and receiving payments. Pretty much managing its finances. Then they use the logistics and purchasing modules, and they have started planning for the CRM modules.

Those clients happen to be very small and they don’t have a large budget for a full-fledged ERP implementation, so they use it as they learn it. They started playing with it and from time to time they call us to help them with their questions or problems. And I think this list is growing for a couple of reasons. They find a lot of functionality and they love it. Second reason is, it gives them a chance to run away from Microsoft. We set world records when it comes to software piracy in Argentina, and the law has become stricter about it. Nowadays small businesses are being audited and are being forced to either buy Microsoft (plus other) licenses, or go open source. And many are choosing open source. And they are finding OpenERP a super option for getting rid of Microsoft Windows servers and Microsoft SQL servers. In the long run, this is a great scenario for cloud computing, but more on that on a later post.

Now, we finished a project and starting a new one. With different clients. We could safely say they are not related to OpenERP but we ended up using it. Why? Because OpenERP provided us with the infraestructure we needed for our projects. The system provided with the business objects (and forms, reports and views) necessary for deploying our applications.

In one project we needed to keep track of attendances with a fingerprint reader. So we used the contract, employee and attendances business objects provided by OpenERP. We just integrated the fingerprint reader module to the HR module. And the customer is pretty much happy with this, plus it saved us a lot of hours. Now we are starting a project where we need to calculate the safety stock, reorder point and order size for a manufacturing company. We will use the MRP module in OpenERP since it will provide us the business objects we need for this project (such as Bill of Materials).

Well, using OpenERP business objects is an scenario we never anticipated, and we are very happy with it. And we are very glad OpenERP is getting more and more modular. Plus, it is a good way to expand the OpenERP presence in customers.

Have a great weekend!

The IT Crowd and the Internet

February 16, 2011 Leave a comment

I know it is a radical departure from my traditional posts but just found this on OpenClipart and I wanted to share it with you.

If you watch The IT Crowd (a hilarious TV show about a HelpDesk), you might recognize it. But if you do not, this is a good time to watch it:

and in case you want more, here is a classic:

Have fun!