CRM | e-Commerce | Accounting | Inventory | PoS | Project management | MRP | etc.
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
We already do this back on 2012 but we already forget the parameters.
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
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)
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"(!!!).
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)
About This Community
Odoo Training Center
|Asked: 3/7/13, 12:32 PM|
|Seen: 12000 times|
|Last updated: 5/4/15, 8:08 AM|