Friday, March 30, 2012

Delete empty cells in Excel

Good trick on this blog: press F5 and click special, then blanks then ok. It'll select all empty cells, you can delete them with a right click.

Sunday, March 11, 2012

OpenERP databases + export and import to forms

OpenERP uses PostgreeSQL to host databases.
  • Databases can be created from the client interface. 
  • They can also be deleted "drop" database
  • Backed-up and imported. It appears some data was lost after a database backup and retrieval (I have to test that again).
Import into forms
"You just first try export the data from export wizard and import compatible field needs to be true in export wizard.
The generated wizard output csv will give you better idea regarding fields and format."

OpenERP install and config

For a very long time I have been wanting to test OpenERP for basic invoicing and inventory management for a small business.

OpenERP installation on Ubuntu Linux
Gave me the basic instruction to:
  • Configure postgreeSQL (in the file
    /etc/postgresql/8.4/main/pg_hba.conf) 
  •  Create a database user called "openerp"
  •  Configure OpenERP server (in the file
    /etc/openerp-server.conf )
I now started the OpenERP client and can see  "no database found, you must create one!"
I then started the client and clicked on FIle/Databases/New Database

 There is a detailed tutorial of the installation on this blog written in May 2010.

....
I'm now trying to import a list of products