Hi Alexis Reyes! Thank you
for your help!
That works, but I need the
export without grouping headings (Example
Company (1), Globex Corporation (2) …) in the Excel file. There should be a contact in each line (as in the
default export). I also have too many contacts to manually expand the range
every time.
In the grouped export, the
names in the Excel table look like this
|
Display Name
|
Name
|
Company Name Entity
|
|
Example Company (1)
|
|
|
|
Example Company, John Doe
|
John Doe
|
Example Company
|
|
Globex Corporation (2)
|
|
|
|
Globex Corporation, Paula
Poe
|
Paula Poe
|
Globex Corporation
|
|
Globex Corporation, Tommy
Toe
|
Tommy Toe
|
Globex Corporation
|
|
Initech Inc. (1)
|
|
|
|
Initech Inc., Richard Roe
|
Richard Roe
|
Initech Inc.
|
|
Undefined (6)
|
|
|
|
Acme Corporation
|
Acme Corporation
|
Acme Corporation
|
|
Example Company
|
Example Company
|
Example Company
|
|
Globex Corporation
|
Globex Corporation
|
Globex Corporation
|
|
Initech Inc.
|
Initech Inc.
|
Initech Inc.
|
|
Soylent Corp
|
Soylent Corp
|
Soylent Corp
|
I need a list export with
an extra column with the first name and last name if it is an individual
contact. If a company contact is entered in the line, the "Individual
Contact" cell should remain empty.
|
Display Name
|
Name
|
Individual Contact Name
(First Name + Last Name )
|
Company Name Entity
|
|
Acme Corporation
|
Acme Corporation
|
|
Acme Corporation
|
|
Example Company
|
Example Company
|
|
Example Company
|
|
Example Company, John Doe
|
John Doe
|
John Doe
|
Example Company
|
|
Globex Corporation
|
Globex Corporation
|
|
Globex Corporation
|
|
Globex Corporation, Paula
Poe
|
Paula Poe
|
Paula Poe
|
Globex Corporation
|
|
Globex Corporation, Tommy
Toe
|
Tommy Toe
|
Tommy Toe
|
Globex Corporation
|
|
Initech Inc.
|
Initech Inc.
|
|
Initech Inc.
|
|
Initech Inc., Richard Roe
|
Richard Roe
|
Richard Roe
|
Initech Inc.
|
|
Soylent Corp
|
Soylent Corp
|
|
Soylent Corp
|
I am able to insert the
column "Individual Contact Name" in the list view in Odoo with
<field
name="name" string=“Individual Contact Name“
attrs="{'invisible': [('is_company', '=', True)]}"/>
But when I export the view, the Company
Names are exported again in the Individual Contact Name column.
Thanks
