Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

0

Openerp Reports on Google spreadsheet [v7]

By
Yassine TEIMI
on 1/27/15, 8:16 AM 931 views

The main idea, is to be able to fetch data from openerp into google spreadsheets, for that you should establish a connection between the two, using javascript, and others languages, for that I installed the module google_spreadsheet. This module depends on google_base_account, it adds the Synchronization tab on user form, I filled in this tab, the google account ( user and password ) for a user.

Then on Reporting Module, a new menu is available, "Google spreadsheets", I created a new spreadsheet, it gives you a link with a google drive ID, I tick the link, knowing that I'm already connected to my google account, a new tab on my google spreadsheet menu appears, offering Settings to connect to the server. I don't know what the google drive ID is for ?

After That I fill the url of my server, the Database, and the login and the password, My problem is, when I try to fetch records with the method : oe_browse for example : =oe_browse("res.partner"; "name city country_id"; "[['customer','=',true]]"; "name asc"; 5)

it gives :  Authentication Error (line 320, file "Code")

Is there any step by step for implementing google spreadsheet integration with openerp v7 ? I think somethiing is wrong with the connection between the two parts. can anybody gives a hand please ? Thanks.

Hi Yassine. I am trying to do exactly the same , having the same results. Can anybody help?

Luis Miguel Sarabia Quiroz
on 12/9/15, 9:02 AM

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

1 follower(s)

Stats

Asked: 1/27/15, 8:16 AM
Seen: 931 times
Last updated: 3/16/15, 8:10 AM