Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:
I'm facing an issue when exporting data from Odoo to Excel or CSV. Some columns, like Order Number, only show values in the first row of each group, leaving blank cells in the rows below.
Is there a way to configure the export settings to ensure all rows have complete data?
Would a custom Odoo report or SQL query be needed to get a proper format?
Has anyone found a workaround for this issue?
Thank you!
Blank values are exported when you have a "One2Many" relationship.
If you export fields from both Sales Orders (One) and Sales Order Lines (Many) you will see blank values for Sales Order fields between Orders:
If instead you just export all the Sales Order Line fields (and access Sales Order fields indirectly) you will get no blanks:
1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.
