Pragmatic Odoo Amazon AWS PlatformPragmatic 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.Frequently Asked QuestionsSupportImplementation and Customization ServiceFunctional TrainingPragmatic Odoo 3-2-1 Launch:Odoo Modules InstalledSoftware EnvironmentBase Operating SystemDistributor ID: UbuntuDescription: Ubuntu 18.04.3 LTSRelease: 18.04Frequently Asked Questions: FAQ1] 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 instance2] 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?Yes, we do provide Implementation and Customization Services.http://pragtech.co.in/services/customization-implementation-service/odoo-openerp.html8] 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 page9] 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 instructions10] How to check server services?ubuntu@ip-172-31-43-36:~$ ps -aux | grep odooOutput - 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.log11] 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: adminPassword: AWS instance ID 13] How to create a new database?You can create new database using the following link [YOUR_IP_ADDRESS]/web/database/managerPlease 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 AdvantageOdoo Experts with in-depth understanding of technical and functional aspects of OdooExperience staff involved in large Odoo implementations spanning over 6-10 monthsIn depth understanding of Odoo server Setup, Configuration, Customization, Module migration, Data Migration ETL and advanced reporting Business Intelligence toolsOur 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: pragtechOur plans are as follows:FeaturesPremiumStandardEnterpriseSupport limit8 tickets every month5 tickets every monthRequirements AnalysisUnlimited functional assistanceAvailability5X85X87AM - 7PM CET Time7AM - 1PM EST TimeContact MeansVoiceEmailEmailVoiceEmailTurnaround timeReaction time: 4 hoursIssue Resolution time: 3 dayReaction time: 1 dayIssue Resolution time: 5 daysImmediatelyPricingSkype 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. Implementation and Customization Service:URL:http://pragtech.co.in/services/customization-implementation-service/odoo-openerp/odoo-openerp-implementation-methodology.htmlThe following is an overview of our implementation process and the activities we perform or assist you in performing.1] Business ReviewThis step begins during our sales process. We speak with you and your users about their requirements and how they currently perform their dutiesWe identify the current processes and document themThis provides us with an understanding of your business environment and helps us speak your language2] Project PlanningGap AnalysisHelps us to cover the functional gapProject PlanningWe work with your team to identify the discrete tasks, responsibilities and timelines for your projectEstablish proper system policies for maintaining and backing-up dataExecuting tasks as per the Implementation Plan in conjunction with the Project TeamCreation of required custom reports3] Reengineering, Installation, Team training, Conference room pilot testingCustomizing, installing and/or upgrading modules and copy it to a test database for use in the pilot testing phase of the project.TrainingOur training approach focuses on developing user comfort with the applications they will be usingWhen you go live, we want your users to know their part of the system and feel comfortable with itOur training approach focuses on developing user comfort with the applications they will be usingWhen 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 upThe 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 trainingGo-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 ImprovementA 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.ObjectivesUnderstand the functional conceptsWork with the software on a daily basisTraining AgendaIntroduction and Installation of Odoo - 1 hourInstall and Create New DatabaseSystem AdministrationProducts and Partners – 1 hourWhat is a product?How to configure differnt types of Products and services in OdooWhat are Partners?How to add Customers and SuppliersPurchases and Sales – 1 hourPurchases Management flowSales Management flowPrice listsOdoo CRM and Pragmatic CRM – 1 hourLeadsOpportunitiesMeetingsAccountsTrouble ticketsHuman Resources (HR) – 1 hourEmployeesExpensesHolidaysTimeSheetsFinancial Management – 1 hourChart of accountsJournalsFiscal yearClosingReconcilationFrom Invoice to PaymentAnalytical Accounts and budgetingLegal Reports Blanace Sheet, Income StatementProject Management- 1 hourProject with tasks and phasesContractsInvoicing from projectsTask analysisStock and Inventory Management – 1 hourWarehouse and locationsStock movesReal and Virtual StockGoods Receipt NotePragmatic Odoo 3-2-1 Launch:Odoo Modules Installed:Core ModulesA list of modules pre-configured and preinstalled in the Pragmatic Odoo has been mentioned. For details, please click on the link provided.Technical NameModule NameCrmCRMmailSocial Networkaccount_vouchereInvoicing & Paymentsaccount_accountantAccounting and Financesale Sales ManagementstockWarehouse ManagementpurchasePurchase ManagementaccounteInvoicingaccount_chart Template of Charts of Accountsaccount_report_companyInvoice Analysis per CompanyanalyticAnalytic AccountingaudittrailAudit Trailauth_cryptPassword Encryptionauth_signup SignupbaseBasebase_action_ruleAutomated Action Rulesbase_calendarCalendarbase_importBase importbase_setupInitial Setup Toolsbase_statusState/stage Managementbase_vatVAT Number ValidationboardDashboardscontactsAddress Bookdecimal_precisionDecimal Precision ConfigurationediElectronic Data Interchange (EDI)email_templateEmail TemplatesfetchmailEmail Gatewayl10n_inIndian - Accountingportal Portalportal_crmPortal CRMportal_salePortal Saleportal_stockPortal StockprocessEnterprise ProcessprocurementProcurementsproductProducts & PricelistsresourceResourcesale_crmOpportunity to Quotationsale_stockSales and Warehouse ManagementshareShare any DocumentwarningWarning Messages and AlertswebWebweb_calendarWeb Calendarweb_diagramOdoo Web Diagramweb_ganttWeb Ganttweb_graphGraph Viewsweb_kanbanBase Kanbanweb_shortcutsWeb Shortcutsweb_testsTestsweb_view_editorView EditorAdditional Modules Installed1] Audit Trail :Technical NameCategoryCategoryExtra ToolsMenuReporting -> AuditThis 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_cryptCategoryExtra ToolsBy 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_cryptCategoryAuthenticationMenuSettings -> Companies -> Companies->ConfigurationThis 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_ruleCategorySalesMenuSettings -> 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_importCategoryUncategorizedMenuImport 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_setupCategoryTechnical SettingsMenuSettings->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_setupCategoryTechnical SettingsMenuSales->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_vatCategoryDependencyMenuSettings->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 NameboardCategoryTechnical SettingsMenuReporting->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 NamecontactsCategoryExtra ToolsMenuMessaging->Organizer->ContactsAll 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_shortcutsCategoryExtra ToolsMenuAdd 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_shortcutsCategoryExtra ToolsMenu(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 GuideOVERVIEWPragmatic 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. FEATURESEasy To Get startedLaunch your instance with pragmatic Odoo AMI and start using it as soon as your instance is readyFreePragmatic 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 UsePragmatic Odoo comes with preconfigured and production ready Odoo on it. http://pragtech.co.in/labs/product-lab/pragmatic-openerp-amazon-aws-platform.html#Odoo Odoo OpenERP_modules is the list of modules installed. You can start using it for your organization as soon as your instance is ready and running.Data Back-upBackup 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 instanceFor accessing the Odoo instance: 1) Go to browser 2) Enter IP address of AWS instance to acess the Odoo instanceFor 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 TROUBLESHOOTINGFor any technical support contactThis email address is being protected from spambots. You need JavaScript enabled to view it.You can also see our Support Serviceshttp://pragtech.co.in/labs/product-lab/pragmatic-openerp-amazon-aws-platform.html#SupportYou can find more information about this product at:http://pragtech.co.in/For any problem related to Odoo, please visithttp://help.openerp.com/questions/LICENSESPython 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.txtlibxml2 is distributed under the MIT license, located athttp://www.opensource.org/licenses/mit-license.phpPostgresSQL is distributed under PostgreSQL License http://www.postgresql.org/about/licence/PhpPgAdmin is distributed under The GNU Public Licensehttps://raw.github.com/phppgadmin/phppgadmin/master/LICENSEFeatures: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 TrailAuto BackupPassword EncryptionAutomated Action RulesState/Stage ManagementVAT Number ValidationDashboardsAddress BookWeb ShortcutsWarning 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_modulesInstallation 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_GuideRecommendations: 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#SupportRelated ProductsPragmatic Odoo iPaaS on AWS PlatformPragmatic Pentaho Community Edition @AWS PlatformPragmatic Machine Learning Toolkit @ AWS PlatformPragmatic AWS IoT