Flag Of United States of America +1 713 701 5957
Flag Of United Kingdom +44 191 308 5117
Flag Of Australia +61 (2) 8003 7653
sales@pragtech.co.in

Pragmatic Odoo V11 / V12 / V13 & V14@ AWS Platform

Pragmatic Odoo Amazon AWS Platform

Pragmatic Odoo is a pre-configured, secured, optimized and ready to run image for running Odoo on Amazon EC2 in a production mode. Odoo is a very popular business suite of application which covers the most important aspects of running a business including Sales, Purchase, Accounting, Finance, HR, Inventory Management, MRP, and POS. We have created a database with necessary modules such as automatic DB backups, Audit trails, encrypted passwords, warnings and alerts, Dashboards, VAT and some of the other must modules in Odoo to run it effectively in production.

Software Environment

Base Operating System
Distributor ID: UbuntuDescription: Ubuntu 18.04.3 LTSRelease: 18.04

Frequently Asked Questions: FAQ


1] How do I start using my Odoo instance?

  • To use Odoo Instance you need to go AWS Market Place and search for Pragmatic Odoo page and launch the instance

2] How will I able to access my Odoo?

  • For accessing the Odoo
    1) Go to browser
    2) Enter IP address of AWS instance to access the Odoo instance
    For ex:If the IP address is 54.201.156.40, just go to link: http://54.201.156.40/

3] Is Pragmatic Odoo production ready?

  • Pragmatic Odoo instance comes with production ready environment. All essential modules are installed and pre-configured

4] How much I will be charged for using Pragmatic Odoo?

  • Pragmatic Odoo is a free instance to be used on cloud. No charges are applicable except the AWS hosting Cost

5] Do this installation have all Odoo modules needed for my organization?

  • We have tried to install the generic core modules. If you need any specific module then you can search and install modules. For the list of all the modules installed, Please go through the Link mentioned below

6] What version of PostgreSQL is used at back end?

  • PostgreSQL 12 is used to store data at backend

7] Do you provide implementation and customization service?


8] I changed admin password of Odoo but it is not working.

  • The issue may be because the changes made by you has not yet affected concern file. You need to refresh your Odoo page

9] I can ping my public IP but in browser no page is opened and nothing is happening. [server Not Found].

  • It is probably a concern that relates to Security groups. Please set your security group permission to inbound and outbound as per instructions

10] How to check server services?



  • ubuntu@ip-172-31-43-36:~$ ps -aux | grep odoo
  • Output - odoo 1767 0.5 7.1 493444 72204 ? Sl 09:30 0:00 python3 /opt/odoo/odoo-bin --config /etc/odoo/odoo.conf --logfile /var/log/odoo/odoo-server.log

11] How to {start|stop|restart|force-reload|status} server service?

  • ubuntu@ip-172-31-43-36:~$ sudo service odoo {start|stop|restart|force-reload|status}
    OR
    ubuntu@ip-172-31-43-36:~$ sudo /etc/init.d/odoo {start|stop|restart|force-reload|status}

12] What is the default username and password?

  • Default Email/Username: admin
    Password: AWS instance ID

13] How to create a new database?

  • You can create new database using the following link
    [YOUR_IP_ADDRESS]/web/database/manager

Please note that you will need to install Sales and Purchase apps/modules if you want to install all additional modules for being production ready.


14] How can I use my domain for Odoo?

  • You should point your domain to your EC2 elastic IP from your domain panel, after that just make changes in /etc/apache2/sites-available/odoo.conf file and replace your IP with your domain, if you still have any problem, get in touch with our technical team

15] How to ssh to the instance?

  • You can ssh to the instance with the help of pem key with below command
    $ ssh i pem_file_path ubuntu@IP_ADDRESS_OF_INSTANCE
    For ex: If the IP address of instance is 54.201.156.40 and pem file name is EC2.pem then the command would be $ ssh i EC2.pem This email address is being protected from spambots. You need JavaScript enabled to view it.
    Pem key is the file which gets downloaded when you first launch the instance. If you lost this key or did not download it, you will need to stop the current instance. and relaunch a new instance from the marketplace

16] How can I add new modules?

  • You can add new modules in the folder /opt/odoo/addons
    for this you need to run the below command
    rsync -rave "ssh -i instance_server.pem" ubuntu@IP_ADDRESS_OF_INSTANCE:/opt/odoo/addons
    For ex: If the IP address of instance is 54.201.156.40, pem file name is EC2.pem and addon module is ec2_addon then the command would be
    rsync -rave "ssh -i instance_server.pem" ubuntu@IP_ADDRESS_OF_INSTANCE:/opt/odoo/addons
    Here you need to provide pem file path and Add_On_Moduel is the module that you want to add on the EC2 instance under addoons directory

Support:

Pragmatic has launched a telephonic and Email Helpdesk support for Odoo for both Technical and Functional/User areas. Please note that this is not an alternative to OPW Publishers warranty provided by Odoo. It is meant to solve practical issues faced by companies while configuring and using Odoo. This support involves helping potentially companies who are using Odoo and need someone whom they can call and get help with their running systems.

Pragmatic Advantage

  • Odoo Experts with in-depth understanding of technical and functional aspects of Odoo
  • Experience staff involved in large Odoo implementations spanning over 6-10 months
  • In depth understanding of Odoo server Setup, Configuration, Customization, Module migration, Data Migration ETL and advanced reporting Business Intelligence tools

Our Helpdesk support is based on Ticket basis. Each ticket is an issue which could be solved in 1 hour of time or less.
Currently we are supporting Europe, Africa, Moddle-East and Asia Pacific You can reach us at E-mail This email address is being protected from spambots. You need JavaScript enabled to view it. or skype us: pragtech

Our plans are as follows:

FeaturesPremiumStandardEnterprise
Support limit
  • 8 tickets every month
  • 5 tickets every month
  • Requirements Analysis
  • Unlimited functional assistance
Availability
  • 5X8
  • 5X8
  • 7AM - 7PM CET Time
  • 7AM - 1PM EST Time
Contact Means
  • Voice
  • Email
  • Email
  • Voice
  • Email
Turnaround time
  • Reaction time: 4 hours
  • Issue Resolution time: 3 day
  • Reaction time: 1 day
  • Issue Resolution time: 5 days
  • Immediately
PricingSkype us: pragtech
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Skype us: pragtech
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
Skype us: pragtech
Email: This email address is being protected from spambots. You need JavaScript enabled to view it.
URL:http://pragtech.co.in/services/customization-implementation-service/odoo-openerp/odoo-openerp-implementation-methodology.html

The following is an overview of our implementation process and the activities we perform or assist you in performing.

1] Business Review

  • This step begins during our sales process. We speak with you and your users about their requirements and how they currently perform their duties
  • We identify the current processes and document them
  • This provides us with an understanding of your business environment and helps us speak your language

2] Project Planning

Gap Analysis

  • Helps us to cover the functional gap

Project Planning

  • We work with your team to identify the discrete tasks, responsibilities and timelines for your project
  • Establish proper system policies for maintaining and backing-up data
  • Executing tasks as per the Implementation Plan in conjunction with the Project Team
  • Creation of required custom reports

3] Reengineering, Installation, Team training, Conference room pilot testing

Customizing, installing and/or upgrading modules and copy it to a test database for use in the pilot testing phase of the project.

Training

  • Our training approach focuses on developing user comfort with the applications they will be using
  • When you go live, we want your users to know their part of the system and feel comfortable with it
  • Our training approach focuses on developing user comfort with the applications they will be using
  • When you go live, we want your users to know their part of the system and feel comfortable with it

(I) Project Team Training:

  • The assigned project lead(s) and project team members will be provided top-level training on the entire system to provide an overview of the modules and how they are set up
  • The following are some examples of key areas that will be addressed during training: A) Coverage on the use of all modules included in your system configuration. B) How to customize the setup of modules to fit your business

(II) End-User Training:

  • The following are some examples of key areas that will be addressed during training

Go-Live!

During the go-live period we ensure that all requirements have been covered to ensure a smooth transition onto the new business system. It is at this time that all tasks on the project plan have been complete, all users trained, all processes re-engineered, and the final data migration/conversion is performed.


Post Implementation Review and Continuous Improvement

A plan for on-going improvement will be discussed and project planning for additional phases of your implementation may be scheduled.


Functional Training:

Odoo User and Functional Training
We can provide an in-depth training on how to effectively use Odoo.

Objectives

  • Understand the functional concepts
  • Work with the software on a daily basis

Training Agenda

Introduction and Installation of Odoo - 1 hour

  • Install and Create New Database
  • System Administration

Products and Partners – 1 hour

  • What is a product?
  • How to configure differnt types of Products and services in Odoo
  • What are Partners?
  • How to add Customers and Suppliers

Purchases and Sales – 1 hour

  • Purchases Management flow
  • Sales Management flow
  • Price lists

Odoo CRM and Pragmatic CRM – 1 hour

  • Leads
  • Opportunities
  • Meetings
  • Accounts
  • Trouble tickets

Human Resources (HR) – 1 hour

  • Employees
  • Expenses
  • Holidays
  • TimeSheets

Financial Management – 1 hour

  • Chart of accounts
  • Journals
  • Fiscal year
  • Closing
  • Reconcilation
  • From Invoice to Payment
  • Analytical Accounts and budgeting
  • Legal Reports Blanace Sheet, Income Statement

Project Management- 1 hour

  • Project with tasks and phases
  • Contracts
  • Invoicing from projects
  • Task analysis

Stock and Inventory Management – 1 hour

  • Warehouse and locations
  • Stock moves
  • Real and Virtual Stock
  • Goods Receipt Note

Pragmatic Odoo 3-2-1 Launch:



Odoo Modules Installed:

Core Modules

A list of modules pre-configured and preinstalled in the Pragmatic Odoo has been mentioned. For details, please click on the link provided.


Technical NameModule Name
CrmCRM
mailSocial Network
account_vouchereInvoicing & Payments
account_accountantAccounting and Finance
sale Sales Management
stockWarehouse Management
purchasePurchase Management
accounteInvoicing
account_chart Template of Charts of Accounts
account_report_companyInvoice Analysis per Company
analyticAnalytic Accounting
audittrailAudit Trail
auth_cryptPassword Encryption
auth_signup Signup
baseBase
base_action_ruleAutomated Action Rules
base_calendarCalendar
base_importBase import
base_setupInitial Setup Tools
base_statusState/stage Management
base_vatVAT Number Validation
boardDashboards
contactsAddress Book
decimal_precisionDecimal Precision Configuration
ediElectronic Data Interchange (EDI)
email_templateEmail Templates
fetchmailEmail Gateway
l10n_inIndian - Accounting
portal Portal
portal_crmPortal CRM
portal_salePortal Sale
portal_stockPortal Stock
processEnterprise Process
procurementProcurements
productProducts & Pricelists
resourceResource
sale_crmOpportunity to Quotation
sale_stockSales and Warehouse Management
shareShare any Document
warningWarning Messages and Alerts
webWeb
web_calendarWeb Calendar
web_diagramOdoo Web Diagram
web_ganttWeb Gantt
web_graphGraph Views
web_kanbanBase Kanban
web_shortcutsWeb Shortcuts
web_testsTests
web_view_editorView Editor

Additional Modules Installed

1] Audit Trail :


Technical NameCategory
CategoryExtra Tools
MenuReporting -> Audit

This module allows administrator track every user operation on all the objects of the system.
In business there are number of users. It is tedious task for an administrator to track all users’ activity. Odoo introduces a unique feature to track user activity on any model. It means a user perform any action [like create, modify, delete] on any model and all those performed action can be seen by administrator by logs. This feature is introduced in Audit Trail module.
To track user activity you need to create audit rule. Audit rules are specified on a particular model that one needs. One Can assign user to track his activity. The rules tell the system which activities performed by the user need to be logged.
1] Create Rule.
2] To activate the audit rule you need to first 'Subscribe' to the audit rule.


2] Auth_ crypt(Password Encryption) :

Technical NameAuth_crypt
CategoryExtra Tools

By default Odoo saves password in plain text. You can find it in res_users that contains list of users and their passwords. Once you switch to encrypted passwords you can't recover user passwords anymore . Currently, thetre is no provision to make passwords encrypted by default. After installing this module, it removes text password field and adds new field named,:password_crypt which saves password in encrypted format. It uses md5crypt FreeBSD crypt(3) based on but different from md5.
Important: uninstalling it may cause issue with your logging. Old password is recovered after unistalling it.


3] Auth_ldap(Authentication via LDAP):

LDAP: A common usage of LDAP is to provide a "single sign-on" where one password for a user is shared between many services, such as applying a company login code to web pages. To use this model you need to have user ldap server up and running.


Technical NameAuth_crypt
CategoryAuthentication
MenuSettings -> Companies -> Companies->Configuration

This module allows users to login with their LDAP username and password, and will automatically create Odoo users for them on the fly. Install python package, ELSE users_ldap module in will not function. Using sudo apt-get install python-ldap.
After installing this module, you need to configure the LDAP parameters in the Configuration tab of the Company details. Different companies may have different LDAP servers, as long as they have unique usernames (usernames need to be unique in Odoo, even across multiple companies).Users' LDAP passwords are never stored in the Odoo database, the LDAP server is queried whenever a user needs to be authenticated. No duplication of the password occurs, and passwords are managed in one place only.


4] Base_action_rule(Automated Action Rules):


Technical Namebase_action_rule
CategorySales
MenuSettings -> Technical -> Automated Action

This module allows to implement action rules for any object. Use automated actions to automatically trigger actions for various screens.
Example: A lead created by a specific user may be automatically set to a specific sales team, or an opportunity which still has status pending after 14 days might trigger an automatic reminder email.
**You need to activate Technical features of user to see this option.
Few actions you can trigger are send Email, send SMS, etc. Provided that you have configured your mail gateway (for email), or any other settings required at your side.


5] Base_import(Base import):


Technical Namebase_import
CategoryUncategorized
MenuImport link beside Create on many forms

For Administrator to activte this option, there are two ways.
1) Install base_import module or
2) Check Import/Export in Settings -> General Settings.

This module is used for importing data from users CSV(Comma-separated values) file. When you have too many entries to make in your database, and data is available in csv file or a csv can be generated from another file then this module will come to your rescue. 1) To import click import and your values will be visible(NOT yet inserted), then you need to select corresponding columns for each value in csv. 2) After this, click validate to validate your value to column insert ralation.(All required fields must be inserted). 3) Finally click on import to insert data.


6] Base_setup(Initial Setup Tools):


Technical Namebase_setup
CategoryTechnical Settings
MenuSettings->Configuration->General Settings

This module helps to configure the system at the installation of a new database.
It allows you to select between list of profiles to install:
1) Minimal profile
2) Accounting only
3) Services companies
4) Manufacturing companies
It also asks screens to help easily configure your company, the header and footer, the account chart to install and the language, email gateway setting, etc.


7] Base_status(State/Stage Management):


Technical Namebase_setup
CategoryTechnical Settings
MenuSales->Phone Calls

Time line tracking of actions for leads can be done with this module.
Example:
Schedule a call with client on particular day and time. Priority of calls can be set as well. You can fix meeting and convert calls to opportunity. You can change status of call accordingly (held, done).
Potential Lead and opportunity can be followed with this module.


8] Base_vat:(VAT Number Validation):


Technical Namebase_vat
CategoryDependency
MenuSettings->Companies->(Your company Name)-> VIES VAT Check (Each Partner) ->Accounting->TIN/VAT

** Check the VAT number depending of the country.
After installing this module, values entered in the VAT field of Partners will be validated for all supported countries. The country is inferred from the 2-letter country code that prefixes the VAT number.
e.g. BE0477472701 will be validated using the Belgian rules.
If customer is subjected to VAT then to check TIN (Tax identification Number) validity, mark the check box in partners Accounting option.
There are two different levels of VAT number validation:
1) By default, a simple off-line check is performed using the known validation rules for the country, usually a simple check digit. This is quick and always available, but allows numbers that are perhaps not truly allocated or not valid anymore.
2) When the "VAT VIES Check" option is enabled (in the configuration of the user's Company), VAT numbers will be instead submitted to the online EU VIES database, which will truly verify that the number is valid and currently allocated to a EU company. Slow since required Internet connection.


9] Board(Dashboards):


Technical Nameboard
CategoryTechnical Settings
MenuReporting->Configuration->Create Board Reporting->Dashboards->My Dashboard

After installing this module, User can create custom dashboard and add data to it according to his needs.
To add the first report into this dashboard, go to any menu, switch to list or graph view, and click 'Add to Dashboard' in the extended search options on upper right corner. You can filter and group data before inserting into the dashboard using the search options.


10] Contacts(Address Book):


Technical Namecontacts
CategoryExtra Tools
MenuMessaging->Organizer->Contacts

All the contacts information is shown in mentioned menu. A contact can be a company that itself contains one or more contact persons' information. You can create, delete or modify contact information.


11] Web_shortcuts(Web Shortcuts):


Technical Nameweb_shortcuts
CategoryExtra Tools
MenuAdd a Shortcut icon besides the views title in order to add/remove a shortcut.

It is always convenient have shortcuts to the menu you use more often. Web shortcuts module is way to create user shortcuts for is web interface according to his choice. Adds a Shortcut icon besides the views title in order to add/remove a shortcut. A star beside your login name contains all the shortcut options you have selected.To add a shortcut go to any tree or form view and click on star on that view that appears before form name still it turns yellow. After this you can check your selection is added in to shortcuts by clicking on star on view title beside your login name.


12] Warning (Warning Messages and Alerts):


Technical Nameweb_shortcuts
CategoryExtra Tools
Menu(Each Partner) ->Warning

**The warning module just give the warning and keep flow continue to the user.
Warning messages can be displayed for objects like sale order, purchase order, picking and invoice. The message is triggered by the form's on change event.
To add warning, go to particular partner, you will find warning tab. Add your warning messages on actions listed there. It is per user based warning message.


User Guide

OVERVIEW

Pragmatic Techsoft is a dynamic and fast growing company committed towards creating value for our customers. Located in Pune, India the educational and IT hub of western India, we take pride in delivering rapid, customized open source enterprise applications following agile and lean software methods. Whether you are developing an application from scratch, working on an existing application or porting your application to a new platform or framework, we can meet your business needs.

You can learn more about Pragmatic at http://pragtech.co.in/

Odoo is a comprehensive suite of business applications including Sales, CRM, Project management, Warehouse management, Manufacturing, Financial management, Human Resources and more.

You can learn more about Odoo at http://www.openerp.com

Pragmatic Odoo is a pre-configured, secured, optimized and ready to run image for running Odoo on Amazon EC2 in a production mode. Odoo is a very popular business suite of application which covers the most important aspects of running a business including Sales, Purchase, Accounting, Finance, HR, Inventory Management, MRP, and POS. We have created a database with necessary modules such as automatic DB backups, Audit trails, encrypted passwords, warnings and alerts, Dashboards, VAT and some of the other must modules in Odoo to run it effectively in production. You need to have your AWS instance. Lanuch your instance with Pragmatic AMI.To get Pragmtic AMI on your instance a link is provided on the landing page.


FEATURES

Easy To Get started

  • Launch your instance with pragmatic Odoo AMI and start using it as soon as your instance is ready

Free

  • Pragmatic Odoo is a free instance to be used in cloud. No charges are applied for it's use. Only cost use have to bare is AWS hosting cost.

Ready To Use


Data Back-up

  • Backup of database for your Odoo is taken on regular interval to ensure your data is safe and secure. Additionally You can take backup manually.

REQUIREMENTS

Only requirement for you to start with is Amazon EC2 instance. One you have your Amazon account you can start your EC2 instance with this AMI.

How to access the instance

For accessing the Odoo instance:

    1) Go to browser
    2) Enter IP address of AWS instance to acess the Odoo instance
    For ex:
    If the IP address is 54.201.156.40, just go to link: http://54.201.156.40/

Odoo Configuration File :- sudo nano /etc/odoo/odoo.conf
Odoo Log File:- tail -f /var/log/odoo/odoo-server.log
Odoo Setup :- Odoo GitHub Build
Odoo Database MasterPassword:- AWS Server Instance Id

TROUBLESHOOTING

  • For any technical support contact
This email address is being protected from spambots. You need JavaScript enabled to view it.

  • You can also see our Support Services
http://pragtech.co.in/labs/product-lab/pragmatic-openerp-amazon-aws-platform.html#Support

  • You can find more information about this product at:
http://pragtech.co.in/

  • For any problem related to Odoo, please visit
http://help.openerp.com/questions/

LICENSES

  • Python is distributed under the Python 2.5 License, which is located at
http://www.python.org/download/releases/2.5.1/license/

  • Odoo is distributed under the AGPL-3 License, which is located at
http://www.gnu.org/licenses/agpl-3.0.txt

  • libxml2 is distributed under the MIT license, located at
http://www.opensource.org/licenses/mit-license.php

  • PostgresSQL is distributed under PostgreSQL License
http://www.postgresql.org/about/licence/

  • PhpPgAdmin is distributed under The GNU Public License
https://raw.github.com/phppgadmin/phppgadmin/master/LICENSE

Features:

This release include essential modules (base,sale,account etc.) for an organization. We have included few more modules to add extra features to your Odoo. Following are the installed modules for additional features.

  • Audit Trail
  • Auto Backup
  • Password Encryption
  • Automated Action Rules
  • State/Stage Management
  • VAT Number Validation
  • Dashboards
  • Address Book
  • Web Shortcuts
  • Warning Messages and Alerts

For more details on extra features click:
http://pragtech.co.in/labs/product-lab/pragmatic-openerp-amazon-aws-platform.html#Odoo OpenERP_modules


Installation Instructions:

To get started with Pragmatic Odoo you need to have AWS account. Start your instance with Pragmatic Odoo AMI. For detailed installation guide click:
http://pragtech.co.in/labs/product-lab/pragmatic-openerp-amazon-aws-platform.html#User_Guide


Recommendations:

1] We recommend instance type small from instance family General purpose for system users upto 30.
2] We recommend instance type medium from instance family General purpose for system users upto 100.
3] We recommend instance type large from instance family General purpose for system users upto 200.
4] We recommend instance type small from instance family General purpose for system users upto 200+.

Any instance from other family will perform well but may not be needed though.


Known Issues:

We strongly adviced you to change instance type if you found your operations taking much time than required. Please follow recommendations mentioned on system user basis.
**Check frequently for additions and updates to these release notes.


Contact details:

For any Queries please mail at This email address is being protected from spambots. You need JavaScript enabled to view it. To report Bug/issue or any support service please visit:
http://pragtech·co·in/labs/product-lab/pragmatic-openerp-amazon-aws-platform.html#Support