Siirry sisältöön
Menu
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Tämä kysymys on merkitty
10 Vastaukset
17542 Näkymät

Everybody know that openerp have a extension for OpenOffice that allow us to design our reports such a Invoice, Sales Order Etc.

We need to know Server Parameters for OpenERP "Online" that are:

Server URL, Port and Protocol Conection

See image -> http ://goo.gl/YvU0P
image description
We already do this back on 2012 but we already forget the parameters.

Avatar
Hylkää

Tried this, still doesn't works

Paras vastaus

The first thing to know is that we introduced the "OAuth" authentication method in OpenERP. OpenERP Online use it by default. The Report Designer and the Thunderbird plugins are not yet upgraded to handle this method of authentication.

Nevertheless, a work around exists to use the report designer on your OpenERP Online. You just have to follow these steps:

  • Sign in as administrator in your OpenERP Online
  • Go to "Settings" > "Users" > "Users"
  • Select the users for which you want to use the Report Designer or the Thunderbird plugin
  • Click on the drop-down menu "More..." in the top middle of the page
  • Click on "Change Password"
  • Set the password of the users

Then, here are the parameters to use:

  • Server: "yourcompanyname".my.openerp.com
  • Port: 443
  • Protocol: XML-RPCS
  • Database: "yourcompanyname"

And, as credentials, use the login and the password you just set

Avatar
Hylkää

I create a new user in my instance, login is the email ID of that user and set a password for him through "Change Password". On using these parameters in OpenOffice 3.2.1, I still get "Connection denied. Please enter valid login/password". I wonder what I do wrong here.

The topic at http://help.openerp.com/question/21225/how-to-use-the-openoffice-report-designer-base_report_designer-on-the-saas-with-xml-rpc-secure/ says use port 443. I tried that too, but it fails. Still can't connect.

Paras vastaus

Tried as well -> Connection denied

Avatar
Hylkää
Paras vastaus

AS PER DENIS LEDOUX [https://accounts.openerp.com/forum/Help-1/question/4900?answer=8584#post-id-8584] I understand it works only for OpenErp 7 Online (Saas)

Avatar
Hylkää

It does not work on the SaaS platform. I tried on it my tests -> mpossible to establish the connection between OpenOffice and OpenERP.

I work with OpenOffice 4.0.0 on Windows 7. There is maybe an issue with this release ?

As for my case: it Works on the Saas platform on windows 7 :)

Same for me, saas instance connection denied...

Paras vastaus

Tried this solution too, but "Connected denied. Please ..."

What's wrong?

Avatar
Hylkää
Paras vastaus

Tried as well, got the Error: Connection to server fail. Please check your Serve .... (error message is cutted off)

How to solve this?

Thx

Avatar
Hylkää
Paras vastaus

Could someone that has the thunderbird plugin working, please let us know how to connect to the odoo web??

In my case I use thunderbird on my mac. 

 

Thanks

Avatar
Hylkää
Paras vastaus

Tried the solution -> Connection denied

Avatar
Hylkää
Paras vastaus

Same situation here... I've install the v.7 of the server. The installation is on the machine that is behind a firewall. Now do I need to set the forwarding through the firewall to point to the database port, or to the mail server port (443).?

Avatar
Hylkää
Paras vastaus

For all of those facing connection problems under windows: If you try to connect from Windows, the problem could be located in the settings of your (Windows) firewall. Try to connect to a local instance to rule out other problems which may cause this error. If you can connect locally, then the problem is most probably located in a missing firewall setting (could also be your router firewall). 

In the Windows firewall, you need to create an inbound and outbound rule for swriter.exe and TCP port 443 (local & remote port), and "Allow the connection if it is secure". In the advanced settings of the rule, you need to "Allow edge traversal"(!!!).

Avatar
Hylkää
Paras vastaus

I'tried on 2 instances on odoo.com and it worked.

step 1) First I modfiy the user password so as specified above.

step 2) Then I open OpenOffice Writer (it's version 4.1.0).

step 3) Choose OpenERP Report Designer (menu) then choose Server Parameters

There the answers I give :

step 3a) Server : [name-of-your-company].odoo.com (in my case "ecuries-du-castelain.odoo.com")

step 3b) Port : 443

step 3c Protocol Connection : XML-RPC secure

step 4) click next

step 5a) database : [name-of-your-database] in my case "ecuries-du-castelain")

step 5b) Login : [user] (in my case "admin")

step 5c) Password : [password] (defined @ step 1)

 

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
12
jouluk. 17
33861
0
toukok. 16
4255
1
helmik. 16
6785
1
toukok. 15
6756
1
maalisk. 15
9527