Simplified and Extended View in OpenERP


You may like to visit How to install OpenERP 6.1 and OpenERP 6.0 on Windows Vista and Windows 7 in 10 Minutes.

Now, It is time to find out the difference between Simplified View and Extended View in OpenERP. We believe that you have installed OpenERP, created database using web client and installed the modules and if you are searching for the answers then visit our related articles…

Once you finish the installation process, Open WebClient by using the URL: http://localhost:8069/web/webclient/home

Next step is to create the database,

Please visit our post on How to create database in OpenERP?

Open WebClient by using the URL: http://localhost:8069/web/webclient/home

Lets see how to install Sale Module, How to Install Sale / Any Module in OpenERP

Click on Sales -> Product -> Click on Any Product Name

Product - OpenERP Web Client
Product – OpenERP Web Client

Click on Product Ice-Cream to Open it in a Form View;  Click on Edit

Product in a Form View - OpenERP Web Client
Product in a Form View – OpenERP Web Client

Now lets configure web client to display extended view.

Click on Settings -> Users

Users - OpenERP Web Client
Users – OpenERP Web Client

Click on Administrator -> Edit

There are two tabs available; Click on Access Right

In Usability Section, Click on the checkbox, Extended View

Save

Administrator - Extended View - OpenERP Web Client
Administrator – Extended View – OpenERP Web Client

Verify the Product in Form View again and we can see more fields than Simplified View

Product in Extended View - OpenERP Web Client
Product in Extended View – OpenERP Web Client

Done!!! 🙂

How to Install Sale / Any Module in OpenERP


If you have already installed OpenERP and created database with the use of Web Client then after some initial configuration, immediate next step will be to install required modules. Now the question is how to install modules? Here we are with the Answer…

You may like to visit How to install OpenERP 6.1 and OpenERP 6.0 on Windows Vista and Windows 7 in 10 Minutes.

Once you finish the installation process, Open WebClient by using the URL: http://localhost:8069/web/webclient/home

Next step is to create the database,

Please visit our post on How to create database in OpenERP?

Open WebClient by using the URL: http://localhost:8069/web/webclient/home

Homepage - OpenERP Web Client
Homepage – OpenERP Web Client

Click on the Settiings -> Modules -> Modules

Modules - OpenERP Web Client
Modules – OpenERP Web Client

There are four filters available.

Filters - OpenERP Web Client
Filters – OpenERP Web Client

Apps ->  List of Main Modules

Extra ->  List of Extra Addons

Installed->  List of Installed Modules

Not Installed-> List of Not Installed Modules

As of now No Module has been Installed; Click on Apps Filter and search for the Sale Module

Sale Module - OpenERP Web Client
Sale Module – OpenERP Web Client

Now Click on Install button to install Sale Module.

Sale Module Installation in Progress - OpenERP Web Client
Sale Module Installation in Progress – OpenERP Web Client

Once Sale Module will be installed, it will ask for “Install your Chart of Accounts”; Click Cancel.

Sale Module Installed - OpenERP Web Client
Sale Module Installed – OpenERP Web Client

Refresh the Window. Apply the Filter “Installed” and verify the installed Modules.

Sale Module Installed - OpenERP Web Client
Sale Module Installed – OpenERP Web Client

Done!!! 🙂

How to drop the database in OpenERP?


Do you want to drop database in OpenERp using Web Client? Here we provide step by step menthod to drop the PostgreSQL.

Click on the Manage Databases Link to drop Database (PostgreSQL).

Before you create any database, you need to install OpenERP.To install OpenERP 6.1 and OpenERP 6.0 on Windows Vista and Windows 7 in 10 Minutes, You may like to visit How to install OpenERP 6.1 and OpenERP 6.0 on Windows Vista and Windows 7 in 10 Minutes.

Once you finish the installation process, Open WebClient by using the URL: http://localhost:8069/web/webclient/home

Next step is to create the database,

Please visit our post on How to create database in OpenERP?

Once you have the database and in case you want to drop it then follow the steps given below:

Open WebClient by using the URL: http://localhost:8069/web/webclient/home

Click on the Manage Databases Link to drop Database (PostgreSQL).

Manage Databases in OpenERP Web Client
Manage Databases in OpenERP Web Client

Click on the Drop Link

Drop Database in OpenERP Web Client
Drop Database in OpenERP Web Client

Select the database to drop and provide the master password, in our case “admin” 🙂

Drop Database in OpenERP Web Client
Drop Database in OpenERP Web Client

It will ask for the confirmation to drop the postgreSQL database.

Drop Database confirmation in OpenERP Web Client
Drop Database confirmation in OpenERP Web Client

Click on Ok.

Done!!! 🙂

How to create database in OpenERP?


Are you beginner and taking babysteps in OpenERP? We can help you in the very 1st step. It’s all about database and it is the central component in ERp systems so lets learn on how to create database in OpenERP…

Before you create any database, you need to install OpenERP.To install OpenERP 6.1 and OpenERP 6.0 on Windows Vista and Windows 7 in 10 Minutes, You may like to visit How to install OpenERP 6.1 and OpenERP 6.0 on Windows Vista and Windows 7 in 10 Minutes.

Once you finish the installation process, Open WebClient by using the URL: http://localhost:8069/web/webclient/home

Click on the Manage Databases Link to create Database (PostgreSQL).

Manage Databases in OpenERP Web Client
Manage Databases in OpenERP Web Client

In Create New Database screen of OpenERP Web Client, Give New database name and Password and Click on Create.

Create Database in OpenERP Web Client
Create Database in OpenERP Web Client

It will take some time to create a new database; once the database is created you will be redirected to the web console of OpenERP.

OpenERP Web Console
OpenERP Web Console

Done!!! 🙂

How to install OpenERP 6.1 and OpenERP 6.0 on Windows Vista and Windows 7 in 10 Minutes


How to install OpenERP 6.1 and OpenERP 6.0 on Windows Vista and Windows 7 in 10 Minutes

Download Windows Auto-Installer from http://www.openerp.com/downloads/

Download Windows Auto-Installer of OpenERP
Download Windows Auto-Installer of OpenERP

Click on the installer.

Select a language in which you want to install Open ERP.

Installer Language of OpenERP
Installer Language of OpenERP

Click next in the following wizard.

OpenERP Installation Wizard
OpenERP Installation Wizard

Accept the Terms of Agreement to install OpenERP 6.1 / 6.0

Accept GNU General Public License to install OpenERP
Accept GNU General Public License to install OpenERP

There are three types of installation are available to install OpenERP 6.1

Select Type of Install to install OpenERP
Select Type of Install to install OpenERP

We select All in One installation.

All in One installation to install OpenERP
All in One installation to install OpenERP

Keep the default values for Hostname, Port, Username and Password.

PostgreSQL connection configuration to install OpenERP
PostgreSQL connection configuration to install OpenERP

Select the destination folder where you want to keep all modules related to OpenERP 6.1 and click Install.

Select destination folder on your system to install OpenERP
Select destination folder on your system to install OpenERP
OpenERP installtion in progress
OpenERP installtion in progress

It will take 5-10 minutes to complete the installation.

OpenERP installtion in Completed
OpenERP installtion in Completed

Finish the installation.

OpenERP installtion Completed
OpenERP installtion Completed

We are ready to go…

http://localhost:8069/web/webclient/home

OpenERP Web Client
OpenERP Web Client

Done!!!

🙂

How to backup and restore OpenERP database ?


There are two methods to perform backup and restore operation for OpenERP database.

Lets go through step by step:

Method 1: Using GUI

Follow the steps to create backup and restoring database.

1) Goto Login page,
2) Click on Manage Databases,
3) There are various options available on left side bar.
4) Follow the screens displayed below.

OpenERP database backup
OpenERP database backup
OpenERP database restore
OpenERP database restore

Method 2: Using command prompt (Using PostgreSQL)

It is advisable that if backup has been taken from command prompt then restoring should be from command prompt only.

Follow the screen steps for creating backup and restore.

1) Executing following command will create a blank database.
Command: createdb –encoding=UTF-8 testdb

Create blank database
Create blank database

2) Executing following command will create a backup of database : openerp_61
Command: pg_dump -f backup_openerp_61 openerp_61

OpenERP database backup from command prompt
OpenERP database backup from command prompt

3) Execute following command will restore your db into blank database created in step 1.
Command: psql testdb < backup_openerp_61

OpenERP restore database from command prompt
OpenERP restore database from command prompt

Problem during restoring from command prompt :

Upto here, assume that everything is working in the same PC. Now let say, someone is trying to restore database using command prompt for which, the database has been backed up from another PC.

Please check following screenshots.

OpenERP database backup process
OpenERP backup database process

In above case, You can see the error message `role “john” does not exist`. It means that database has been backed up from another PC having name is ‘john’.

So now, in this case there are two solutions to restore this database as follows.

1) Either you can open dump file, and change the role name wherever you find name ‘john’ as your role displayed in following screen. Here I have changed name as ‘navrang’ in place of ‘john’.

OpenERP restore database process
OpenERP restore database process

2) Another option is, if dump file is too long to change role/owner name, then you can create a user in your PC named ‘john’ so it will work as it is.

And this way we can restore our database.