Siirry sisältöön
Sinun on rekisteröidyttävä, jotta voit olla vuorovaikutuksessa yhteisön kanssa.
Kaikki kirjoitukset Ihmiset Merkit
Tunnisteet (Näytä kaikki)
odoo accounting v14 pos v15
Tietoa tästä foorumista
Tämä kysymys on merkitty
xlsxExportingv13
2 Vastaukset
4025 Näkymät
Avatar
Open Blue Sea Farms

Hello community,

Is there a way to configure the exporting tool so that the blank lines have the same content of the previous line, avoiding leave blank cells? This issue occurs when there are one or more fields from another model (like sales and invoices, for example)

I need to use the exported information in a dynamic table, but the standard way how Odoo is doing it doesn't work for this purpose.

I'd appreciate your help.

The attached image from the model "sale.order" shows the commented issue (blank cells were painted in yellow to highlight)  


Avatar
Hylkää
Avatar
Amr Abd-Alkrim (FireBits)
Paras vastaus

Odoo made the blank lines for a purpose which is reimporting the exported data again to odoo.
The blank lines tells odoo that these orderlines belongs to this sale order so with out the blanks Odoo can't tell if the order has more than one orderline.

I hope you understand that you have to fill the blanks manually and there is no option to let Odoo do it for you right now.
You can request it as a new feature in the next Odoo though. 

Go to Odoo in github and request a new feature.


Happy to help :) an upvote will be awesome


Avatar
Hylkää
Open Blue Sea Farms
Tekijä

Thanks Amr for your response.

Amir

hmm, not true.

The blank cells can be filled in with the same data as the first row and that won't cause any issue as long as they are all exactly the same. Blank cells are not a must have.

This can be inconvenient when importing data into another database.

Avatar
Masoud
Paras vastaus

Hasn't anything related to this problem come up yet? this is a huge problem when you're exporting data to make a report out of it in Excel especially when it's a multi-dimensional thing in your company like exporting sales orders and stuff like that!

Avatar
Hylkää
Aiheeseen liittyviä artikkeleita Vastaukset Näkymät Toimenpide
Export data to custom XLSX template in python
python xlsx Exporting odoo16features
Avatar
Avatar
1
lokak. 24
2850
HRMS Appraisal question
xlsx Exporting CSV Appraisal odoo17
Avatar
0
elok. 24
1245
E-Mail "Branding" in Odoo 13? How to remove Powered by / Sent by Odoo?
v13
Avatar
Avatar
Avatar
2
kesäk. 24
6330
Error login LinkedIn v13 enterprise
v13
Avatar
Avatar
2
maalisk. 24
1815
What are mandatory export fields
Exporting
Avatar
Avatar
1
helmik. 24
2597