Guillaume Rivière 2013 – 2017

Le logo de l'EFREI GROUP

Enterprise Resource Planning

TP1: Starting OpenERP 7.0 server and first administration steps

Rule 1: At the end of the class session, you will send your answer in a PDF file.

Rule 2: Don't read too fast, take your time to read all the instructions carefully.

Rule 3: Before leaving your computer, you will save your database as explained in exercise 2.6. Then, you will drop your database from OpenERP in order to leave everything clean for the next person who will use this computer.

Exercice 1 • Server side: Install and configure environment for OpenERP 7.0

The aim is to prepare the environment to run OpenERP.

FIRST, before doing anything, you have to make a copy of the virtual machine (OpenERP_32bits), from V:\VM\masters\vmware\ to a directory of your name on V:\VM\work\

If needed, more information about Virtuals Machines is available at http://it-portal.groupe-efrei.fr/ress/vm/start

Then, launch VMWare Player and run the .vmx file from V:\VM\work\OpenERP_32bits\.

Go on the openerp menu on the top right corner, then open Paramètres Systèmes, then click on Affichage and then set the resolution to 1280x1024.

Everything has already been done to install OpenERP on you computer, so you can directly jump to 1.4.

Show installation steps 1.1 - 1.2 - 1.3 (attention, don't do these steps, it has already been done on the EFREI Debian virtual machines)

1.4 Launch OpenERP server

If not already done, launch VMWare Player and run Debian.

Numerous options can be given when launching OpenERP server. We gonna give only necessary ones. When using the server in production, we would store the server logs in a specific file (using the --logfile option), but we won't do this for the moment, in order to see in live what the server does.

Exercice 2 • Client side: First connection to OpenERP 7.0

The aim is to explore and discover the OpenERP client.

2.1 Install specific fonts (This step is for Chinese, Japanese and Korean students only)

OpenERP is available with more than 50 translations. In the following you will be about to use OpenERP with your mother thongue. In order to able your web browser to display the fonts for the following languages, some extra packages have to be installed:

Show steps to install fonts (Attention, for Chinese, Japanese and Korean students only)

2.2 Connect and create a new database

Launch Iceweasel web browser (not Epiphany):

When connecting for the first time, you need to create a new database. In order to fill out the creation form, go on Manage Databases or, in french, Gestion des bases de données (Not need if you were already automatically redirected to the form) and then give:

After creation, you may automatically be logged in. But for the moment, logout and go to the login page and let's do first some observations:

  1. You are going to observe and compare the source code of some pages:
    • You are on the login page. View the source code of the page (Click on the page with the right button of the mouse and chose the intended menu entry).
    • Now, go again on Manage Databases or (in french) Gestion des bases de données, and view the source code of the page.
    • Now, access the pages Duplicate database or Backup database (by clicking on the left menu), and view the source code of these pages.
    • Q1: What do you observe about the source codes of all these pages?
      Q2: Is this normal? What technology allows the OpenERP client to generate web pages content?
  2. Now let's have a look to what happened. In a terminal, enter the following commands:
    1. psql -l
      Q3: Who is the owner of db_demo?
      Type Q to exit
    2. psql db_demo openerp (this time the password for openerp role is postgres)
      Enter \dt
      Use space bar and Up Arrow and Down Arrow to browse result
      Q4: What is showing the \dt command?
      Q5: How many tables are present in db_demo?
      Type Q to exit
    3. SELECT pg_size_pretty(pg_database_size('db_demo'));
      Q6: What is the size of db_demo?
    4. SELECT pg_database_size('db_demo');
      Q7: What is the unit used to express the size with this command?

2.3 First steps as administrator

  1. Type username (admin) and password (admin) and click Login.
    You arrive on the Settings panel.
    Q8: What are the 3 main levels of the menu on the left?
  2. Move the mouse cursor over the logo of OpenERP at the top left corner of the page. Then click on Edit Company data.
    Change the name of the company for Demo Company.
    Change the logo of the company for one of the following (click right button to save the image on your disk):
    Logo1 Logo2 Logo3 Logo4 Logo5 Logo6
    Save changes Save and close the pop-up panel.
    Then reload page pressing Ctrl+R or pressing F5.
    Q9: What modification can you observe on the page?
  3. There are two different (and not equivalent) ways to install applications in OpenERP 7.0: Apps and Modules
  4. Click in the menu to view Apps. If your computer has internet access, the apps will be listed from the OpenERP Apps Store.
  5. Now open Settings > Modules > Installed Modules from the menu.
    Q11: How many modules are already installed?
  6. Click on Base module name.
    Q12: What informations can you get here?
    Q13: What are the available actions?
    Q14: In the features tab of this module, can you retreive the 3 menu levels you have listed at question Q8? Under what section can you locate it?
  7. Now, go on Settings > Translations > Load a Translation
    and then install the translation for your mother thongue.
  8. Go to Settings > Users > Users
    • Click on Demo User to open form. Then click on Edit button of the form.
      Change the language of this user for your mother thongue.
      In the Access Rights tab, set Demo User as a user of Sales application.
      Click on Save button
    • Click on arrows at top right of the page to reach the Administrator form. Then click again on Edit button of the form.
      In the Access Rights tab, set Administrator as a user of Sales application.
      Click on Save button.
      Now Administrator (the account you are using right now) is a user of sales.
      Reload the page pressing Ctrl+R or pressing F5.
      Q15: What sections have appeared at the left of the upper black bar?
  9. Go to Sales > Sales > Customers
    • Use the arrow of the search bar in order to show Advanced Search panel.
      Then, use Group By functionnality in order to display customer by country.
      Under the search bar, locate the view options button
      Q16: What is the name of the current view?
      Now, click to activate the list view.
      Click on one of the two persons present in Undefined in order to display its form.
      Q17: Why these two persons appear as Undefined when grouping by country?
    • In the search bar, close the two filters Customers and Country.
      Choose kanban view mode.
      Using Advanced Search panel, observe, time after time, the entries shown for each of the five filters.
    • Again in the search bar, close all active filters, and open Advanced Search tool. Then unhide Advanced Search.
      Make this search: Country contains France and Is a Company is true.
      Click the button.
      Now, make the current search becoming a new custom filter. Call it French companies.
  10. Log out.

2.4 Log in as user

  1. Type username (demo) and password (demo) and click Login.
    You arrive on the Sales panel, which is the only one accessible for Demo User for the moment.
  2. Observe the page. Locate some translated terms.
  3. You may have a warning on the right corner of the page, nearby your login name.
    Access the preferences of Demo User.
    Then change timezone for Europe/Paris and click Save.
  4. In order to access the form of Morgan Rose, from Global Solutions, begin to type his name in the search bar, and click on the proposed name.
    Then, open his form.
    Q18: Are you allowed to edit the form?
    Explore the form and observe all the fields offered to parameter the form of this customer.
  5. Go back to the kanban view. Close all filters in the search bar. Perform a new advanced search: Users is set.
    Q19: How many results are listed? Why the other persons do not appear?
  6. Log out.

2.5 Install modules

  1. Log as Administrator.
  2. Go to Settings > Modules > Installed Modules
    • Close the filter Installed in the search bar.
    • Now you should see all available modules. For the moment, don't click on Install button
    • Clicking on the name of a module, information will be displayed. Then you will be able to go back to the list pressing the kanban view button. Doing so, take some time to explore the forms of the modules listed here.
    • Go down the page and find the Show More button. Do this again and again, in order to browse all the modules list.
    • Now, choose list mode
      Q20: What is total number of modules?
    • Go back to kanban view. The modules you are going to install are the following:
      • Accounting and Finance (When asked during the installation, you will choose French accounting)
      • MRP
      • Purchase Management
      • Sales Management
      • Warehouse Management
      Be patient, the installation of some modules can take some time. Wait!
      Q21: You have installed 5 new modules with some preloaded demonstration data. What is the actual size of the database? How many tables are defined?
      Q22: What sections are now present in the upper black bar?
      Explore each of the new sections (the menus, the forms, the preloaded data, …) by yourself.
  3. Go to Settings > Users > Users
    Open the form of Demo User and click the Edit button.
    Open the Access Rights tab.
    Observe new applications are available here.
    Observe also the different possible access grants existing for each application.
  4. Log out and log in as Demo User.
    Take few minutes to explore all the sections, menus, forms, … translated in your mother thongue.
  5. Log out.

2.6 Exporting database

2.7 Technical administration

  1. Log as Administrator.
  2. Go to Settings > Users > Users
    • Open Administrator user form.
    • Click the Edit button, and then activate Technical Features (in the Access Right panel)
    • Click the Save button, and then reload page pressing Ctrl+R or pressing F5
    • Observe that some menus are now unhidden for Administrator:
      • Users > Groups
      • Technical
      • Configuration
  3. Something usefull when programmaing, is to know the name and the type of the fields of the object models. To find these informations, all the database structure of loaded modules can be browsed from Settings > Technical > Database Structure > Models
    • Click on this menu entry to open the view on the models present in the database.
    • Look for the model res.users
      • Click on the res.users line to open its form.
      • This model allows to represent the data needed to desribe users in OpenERP.
      • Observe the fields names and types, and if the fields are required or readonly.
      • Open the Access Rights tab and observe it.
      • Open the Views tab and observe it.
    • For example, perform the same steps for the following other models:
      • res.country : used to describe data for a country in OpenERP.
      • res.partner : used to describe data for a partner in OpenERP.
      • mrp.bom : used to describe data for a Bill of Material in the MRP module of OpenERP.
      • product.product : used to describe data for a product in OpenERP.

Exercice 3 • A complete Sales / Purchase / Manufacturing / Warehouse flow

The aim is perform several steps of a complete business flow.

You are going to follow the instructions described in the chapter 2 of this book:

Els Van Vossel and Fabien Pinckaers, Streamline your Manufacturing Processes with OpenERP, A Simple Approach to Manage the Manufacturing and Supply Chain Complexity, Open Object Press, 2011, 230 pages.

Download chapter 2 in pdf (500 ko).

Remark: This book was written for the version 6 of OpenERP. Event if is is globally the same, there are some small differences with the version 7. So, don't always follow all the insctructions word after word! By example:

While performing the steps of the flow, you will have to answer the following questions:

Tableau 3.1
Name of the user Thomas Mitchell Jason Randy Robin
Job in the company
Access
rights
for the
module
Sales
Knowledge
Warehouse
Manufacturing
Accounting & Finance
Purchases
Human Resources
Marketing
Fleet
Sharing
Administration