Community mailing list archives

community@mail.odoo.com

Re: How to import data from postgresql to excel

by
OpenERP Master
- 06/30/2015 16:37:12
Why dont you learn standard sql syntax.

SELECT sale.name, billing_address.name, shipping_address.name
FROM sale_order sale
JOIN res_partner billing_address ON (sale.partner_invoice_id = billing_address.id)
JOIN res_partner shipping_address ON (sale.partner_shipping_id = shipping_address.id)

On Tue, Jun 30, 2015 at 1:27 PM, Basavraj Parit <paritbasavraj2@gmail.com> wrote:

You may export data to a CSV file by selecting proper format ie for separation you may use excel cell utf -8 format so it give proper data then you may do same for sales

Basavraj

On 30-Jun-2015 6:07 pm, "Mignon, Laurent" <laurent.mignon@acsone.eu> wrote:
Sayali,

May be this one can help you: sql_export module
sql_export_module is for advanced users/integrator since it requires you know the database structure and should be use with caution since the security is not enforced. 

Regards,

lmi

On Tue, Jun 30, 2015 at 2:22 PM, John Walsh <michaeljohn32@yahoo.com> wrote:
Sayali,

If you want data directly from postgresql, you will want to log in to psql and do a query like the following:

COPY (SELECT p.name, s.name from sale_order s LEFT JOIN res_partner p on s.partner_id=p.id) TO '/tmp/cust-sale.csv' CSV HEADER;

That query will give you the customer name and the sales order number/name and the resulting file can be exported to excel.  See also this stack overflow question and answer: http://stackoverflow.com/questions/5509460/postgresql-query-to-excel-sheet


If, however, you want to just export a certain list view, check out:
or

Best of luck!
 
~John Walsh




On Tuesday, June 30, 2015 7:15 AM, Sayali Kothawade <sayali.kothawade@ayanworks.com> wrote:


Hello,
        I am trying to import data from Postgresql from sales modules to excel.
I want data from customers and sales order on a single excel sheet. 
Can you please suggest me any solution?
 



Thanks & Regards,
Sayali Kothawade.
Ayanworks Technolgy Solutions Pvt. Ltd.
_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe


_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe




--
Laurent Mignon
Senior software engineer

Tel: +352 20 21 10 20 32
Fax: +352 20 21 10 21
Email: laurent.mignon@acsone.eu


Acsone SA, Succursale de Luxembourg 
22, Zone Industrielle
​ ​
​| L-8287 Kehlen, Luxembourg
TVA LU24733605
​ | ​RCS B160400​

Acsone sa/nv
Boulevard de la Woluwe 56, b4  Woluwedal
​ | B-1200 Bruxelles - Brussel 
RPM Bruxelles 0835.207.216 RPR Brussel  



_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe

_______________________________________________
Mailing-List: https://www.odoo.com/groups/community-59
Post to: mailto:community@mail.odoo.com
Unsubscribe: https://www.odoo.com/groups?unsubscribe