Skip to Content
This question has been flagged
odoo10
2 Replies
5443 Views
Avatar
Sarina

I have  this  code  which exports data in xml format  but I need to  implement  the  code in odoo with  download option. How can i do that?

import psycopg2

CONNECT_ARGS = 'host=localhost user=postgres password=postgres dbname=agni2'


def exportPlants(outfileName):
    outfile = file(outfileName, 'w')  #opens file for writing
    connection = psycopg2.connect(CONNECT_ARGS)
    cursor = connection.cursor()
    cursor.execute("select * from tbl")
    rows = cursor.fetchall()
    outfile.write('<?xml version="1.0" ?>\n')
    outfile.write('<mydata>\n')
    for row in rows:
        outfile.write('  <row>\n')
        outfile.write('    <name>%s</name>\n' % row[0])
        outfile.write('    <desc>%s</desc>\n' % row[1])
        outfile.write('    <rating>%s</rating>\n' % row[2])
        outfile.write('  </row>\n')
    outfile.write('</mydata>\n')
    outfile.close()




exportPlants('out6')
Avatar
Discard
Avatar
Fatih Piristine
Best Answer

if you really need a sample code, in hurry without reading the docs, such as exporting xml format. look into part where sitemap.xml is handled. I guess from that point on, you will figure out everything.

like Zachary mentioned: don't go around the ORM.

Avatar
Discard
Avatar
Zach Waite
Best Answer

It looks like maybe agni2 is your odoo database and you've bypassed odoo to prototype this export script using the postgres user? (odoo won't use postgres user per the install docs https://www.odoo.com/documentation/10.0/setup/install.html#id5)

Depending on your use case, you can develop a custom module and access the data using the ORM or call the web service api.  Odoo seems to frown on bypassing the ORM (https://www.odoo.com/documentation/10.0/reference/guidelines.html#do-not-bypass-the-orm) to execute SQL directly.

I'm guessing that since you're extracting all the data from the table in your query you're intending to ETL into some other system or perform interactive analysis; if that is the case then maybe just call the api (https://www.odoo.com/documentation/10.0/api_integration.html), or have a look at ERPpeek (http://erppeek.readthedocs.io/en/latest/)

Avatar
Discard
Related Posts Replies Views Activity
Create schedule action For sending emails
odoo10
Avatar
Avatar
Avatar
2
Jul 25
7839
How to send messages that are not shown in chatter? Solved
odoo10
Avatar
Avatar
Avatar
2
Oct 25
9935
How to ORDER BY? [Odoo 10] Solved
odoo10
Avatar
Avatar
2
Nov 24
30842
Dynamic domain functionality - possible to change domain of a field in another model with onchange? (Odoo 10) Solved
odoo10
Avatar
Avatar
Avatar
2
May 24
9252
Change state of other module
odoo10
Avatar
Avatar
Avatar
Avatar
3
Mar 24
8909