Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

How to use the OpenOffice Report Designer ( base_report_designer ) on the SaaS with XML-RPC Secure

Subscribe

Get notified when there's activity on this post

This question has been flagged
onlinesaasreportdesigner
12 Replies
35455 Views
Avatar
Sébastien Versailles (sve)

Since beginning of June 2013 , I cannot connect anymore my OpenOffice Report Designer to my SaaS instance. Can you help me?

5
Avatar
Discard
Tony Hawkins

I have also experienced this, but the instructions below do not seem to work. Any more ideas? It was working perfectly up to 3rd July 2013 - has something been changed?

Avatar
Sébastien Versailles (sve)
Author Best Answer

Hello,

Since beginning of June 2013, we are using the protocol XML-RPC Secure to connect the OpenOffice Report Designer to the OpenERP Online instances.

Here are the steps you need to follow to use the new plugin:

  • 0a) Don't forget to add a password to your user ( cf question 4900 )
  • 0b) Don't forget that this plugin works with OpenOffice and with Libreoffice until V3.6 , but not with Libreoffice V4.0+
  • 1) In your instance , go to Settings/Modules/base_report_designer, click on "upgrade"
  • 2) In your instance, go to Settings/Configuration Wizards/OpenERP Report Designer Installation/Set as To Do/Launch/Download the file.
  • 3) Rename your file by adding ".zip" at the end of the file name
  • 4) In OpenOffice, (Tools/Extension manager) disable the existing extension
  • 4b) If necessary, delete manually the plugins from the application data (google..)
  • 5) Restart OpenOffice
  • 6) In OpenOffice, (Tools/Extension manager) Add the new extension file
  • 7) Restart Openoffice
  • 8) In Openoffice Report Designer/Server parameters ; fill in with the following settings: Server: YOUR_INSTANCE.my.openerp.com Port: 443 Protocol: XML-RPC secure
  • 9) Continue with the same steps as before ( type in the name of your instance )

I hope it will help you.

3
Avatar
Discard
michel Guénard

the openoffice extension as downloaded thru the link (step 2 above) provided during the setup of the base_report_designer module creates an error when installing it as an OO extension. Any fix to this?

Sampath Kumar S

hello sir, even i did the same thing but i'm not able enable the extension base_report_designer file in openoffice can u plz help it out

bakhtawar

when i follow step 7 and restrat office it not show me openoffice report designer where i find this?

Dale E. Moore

Maybe an answer will appear... https://answers.launchpad.net/openobject-addons/+question/241854

Avatar
FPT MEDIA
Best Answer

I had the same issue and was attempting to test out any combination of the recommendations above to attempt to solve and finally found one that worked for me.

On SaaS version of Odoo Online (v8); follow the steps above to download the configuration wizard and .zip file locally from your Odoo instance. This was done using the most recent version of OpenOffice 4 - all the advice seemed to point people to different ports or RPC protocols, but using standard RPC and port 80 worked for me using Windows 8 and OpenOffice 4.

  1.  In your instance , go to Settings/Modules/base_report_designer, click on "upgrade"
  2.  In your instance, go to Settings/Configuration Wizards/OpenERP Report Designer Installation/Set as To Do/Launch/Download the file.
  3.  Rename your file by adding ".zip" at the end of the file name
  4.  In OpenOffice, (Tools/Extension manager) disable the existing extension
  5.  If necessary, delete manually the plugins from the application data (google..)
  6.  Restart OpenOffice
  7.  In OpenOffice, (Tools/Extension manager) Add the new extension file
  8. Restart Openoffice
  9.  In Openoffice Report Designer/Server parameters ; fill in with the following settings: Server: YOUR_INSTANCE.odoo.com Port: 80 Protocol: XML-RPC (I did NOT select 'secure)
  10.  Select Next
  11. DB name: "your instance name"; username: your profile username, not Odoo OAuth name (in my case: "admin"); Password: your system password
  12. Click 'Connect' - you should see a message that responds with: "You can start creating your report in the current document; After creating, sending to the server"

Hope this help!

1
Avatar
Discard
Avatar
Youri Lebarch
Best Answer

Please, where can i find openoffice or libreoffice until V3.6 ?

0
Avatar
Discard
Avatar
wjn
Best Answer

I followed your instructions, but keep getting wrong username / password if I try to connect with the Report Designer. For 100% sure the username & password are o.k., I use admin / <password> with which I can logon to OpenERP without any problem.

In the default openerp-server.conf is the next line:

specify the TCP port for the XML-RPC Secure protocol

xmlrpcs_port = 8071

Sure the port 443 mentioned in your answer should be used, not 8071?

0
Avatar
Discard
Avatar
M. Höppner
Best Answer

not for SaaS but for an installation in a local network you have to use the port of the apache server and NOT any other port like 8069, 8070, 8071 related to RPC, in my case 80 work fine (even from a PC which is not the server), however I do not know what works for SaaS

0
Avatar
Discard
Avatar
SureshRao
Best Answer

Dear Friend,

i install Ubuntu 14.04 and install LibraOffice V4 . when i clink on OpenErp Report designer menu . its no working .no error showing also.

kindlly advice me.

thanks,

suresh rao

 

0
Avatar
Discard
Ivan

Suresh, the plugin only works for OpenOffice/LibreOffice 3.2.

Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
OpenERP Online: What are the parameters for the report designer or the Thunderbird plugin? Solved
online report designer parameters
Avatar
Avatar
Avatar
Avatar
Avatar
10
May 15
18421
OpenOffice Report Designer (Saas) - Connection denied - Invalid login/password
report designer
Avatar
0
May 16
4941
Why is there no longer a free website?
online saas
Avatar
0
Mar 15
5926
Odoo online help!
online saas customization
Avatar
Avatar
1
Jun 21
4401
Odoo Saas edition: Report customization Solved
saas report customization
Avatar
1
Jan 17
4845
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now