Skip to Content
Odoo Menu
  • Sign in
  • Try it free
  • Apps
    Finance
    • Accounting
    • Invoicing
    • Expenses
    • Spreadsheet (BI)
    • Documents
    • Sign
    Sales
    • CRM
    • Sales
    • POS Shop
    • POS Restaurant
    • Subscriptions
    • Rental
    Websites
    • Website Builder
    • eCommerce
    • Blog
    • Forum
    • Live Chat
    • eLearning
    Supply Chain
    • Inventory
    • Manufacturing
    • PLM
    • Purchase
    • Maintenance
    • Quality
    Human Resources
    • Employees
    • Recruitment
    • Time Off
    • Appraisals
    • Referrals
    • Fleet
    Marketing
    • Social Marketing
    • Email Marketing
    • SMS Marketing
    • Events
    • Marketing Automation
    • Surveys
    Services
    • Project
    • Timesheets
    • Field Service
    • Helpdesk
    • Planning
    • Appointments
    Productivity
    • Discuss
    • Approvals
    • IoT
    • VoIP
    • Knowledge
    • WhatsApp
    Third party apps Odoo Studio Odoo Cloud Platform
  • Industries
    Retail
    • Book Store
    • Clothing Store
    • Furniture Store
    • Grocery Store
    • Hardware Store
    • Toy Store
    Food & Hospitality
    • Bar and Pub
    • Restaurant
    • Fast Food
    • Guest House
    • Beverage Distributor
    • Hotel
    Real Estate
    • Real Estate Agency
    • Architecture Firm
    • Construction
    • Estate Management
    • Gardening
    • Property Owner Association
    Consulting
    • Accounting Firm
    • Odoo Partner
    • Marketing Agency
    • Law firm
    • Talent Acquisition
    • Audit & Certification
    Manufacturing
    • Textile
    • Metal
    • Furnitures
    • Food
    • Brewery
    • Corporate Gifts
    Health & Fitness
    • Sports Club
    • Eyewear Store
    • Fitness Center
    • Wellness Practitioners
    • Pharmacy
    • Hair Salon
    Trades
    • Handyman
    • IT Hardware & Support
    • Solar Energy Systems
    • Shoe Maker
    • Cleaning Services
    • HVAC Services
    Others
    • Nonprofit Organization
    • Environmental Agency
    • Billboard Rental
    • Photography
    • Bike Leasing
    • Software Reseller
    Browse all Industries
  • Community
    Learn
    • Tutorials
    • Documentation
    • Certifications
    • Training
    • Blog
    • Podcast
    Empower Education
    • Education Program
    • Scale Up! Business Game
    • Visit Odoo
    Get the Software
    • Download
    • Compare Editions
    • Releases
    Collaborate
    • Github
    • Forum
    • Events
    • Translations
    • Become a Partner
    • Services for Partners
    • Register your Accounting Firm
    Get Services
    • Find a Partner
    • Find an Accountant
    • Meet an advisor
    • Implementation Services
    • Customer References
    • Support
    • Upgrades
    Github Youtube Twitter Linkedin Instagram Facebook Spotify
    +1 (650) 691-3277
    Get a demo
  • Pricing
  • Help

Odoo is the world's easiest all-in-one management software.
It includes hundreds of business apps:

  • CRM
  • e-Commerce
  • Accounting
  • Inventory
  • PoS
  • Project
  • MRP
All apps
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
You need to be registered to interact with the community.
All Posts People Badges
Tags (View all)
odoo accounting v14 pos v15
About this forum
Help

Export the name of the contact person in a separate column

Subscribe

Get notified when there's activity on this post

This question has been flagged
exportcontactsnamev14
2 Replies
3804 Views
Avatar
Martins

I'm looking for a way to export the names (first name and last name) of the contact persons from the Contacts app in a separate column without an active filter. I am using odoo 14 enterprise online

What I am able to export

Name

Example Company

John Doe

Acme Corporation

Globex Corporation

Paula Poe

Tommy Toe

Soylent Corp

Initech Inc.

Richard Roe

 

Display Name

Example Company

Example Company, John Doe

Acme Corporation

Globex Corporation

Globex Corporation,  Paula Poe

Globex Corporation, Tommy Toe

Soylent Corp

Initech Inc.

Initech Inc., Richard Roe

 

Commercial Company Name

Example Company

 

Acme Corporation

Globex Corporation

 

 

Soylent Corp

Initech Inc.

 

 

What do I need to export

Contact Name

 

John Doe

 

 

Paula Poe

Tommy Toe

 

 

Richard Roe


Thanks

0
Avatar
Discard
Avatar
Martins
Author Best Answer

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

0
Avatar
Discard
Avatar
Alexis Reyes
Best Answer

Hi Martins, try to group the contacts first by type of company. Then select all those who are person and export. Remember to always expand the range of the displayed list, so that you can select all of them. Hope this helps you.

0
Avatar
Discard
Enjoying the discussion? Don't just read, join in!

Create an account today to enjoy exclusive features and engage with our awesome community!

Sign up
Related Posts Replies Views Activity
Export functionality whole number odoo by default Export in Tree view??
export v14
Avatar
0
Aug 23
1868
Selective Read/only for Contacts
contacts v14
Avatar
Avatar
1
Jul 23
2363
first name and last name fields in odoo online
partner contacts name
Avatar
Avatar
Avatar
3
Jan 25
5497
Contact export customization
export contacts customization
Avatar
0
Nov 24
1624
Contacts internal notes field - export
notes export contacts
Avatar
Avatar
1
Jul 24
3756
Community
  • Tutorials
  • Documentation
  • Forum
Open Source
  • Download
  • Github
  • Runbot
  • Translations
Services
  • Odoo.sh Hosting
  • Support
  • Upgrade
  • Custom Developments
  • Education
  • Find an Accountant
  • Find a Partner
  • Become a Partner
About us
  • Our company
  • Brand Assets
  • Contact us
  • Jobs
  • Events
  • Podcast
  • Blog
  • Customers
  • Legal • Privacy
  • Security
الْعَرَبيّة Català 简体中文 繁體中文 (台灣) Čeština Dansk Nederlands English Suomi Français Deutsch हिंदी Bahasa Indonesia Italiano 日本語 한국어 (KR) Lietuvių kalba Język polski Português (BR) română русский язык Slovenský jazyk slovenščina Español (América Latina) Español ภาษาไทย Türkçe українська Tiếng Việt

Odoo is a suite of open source business apps that cover all your company needs: CRM, eCommerce, accounting, inventory, point of sale, project management, etc.

Odoo's unique value proposition is to be at the same time very easy to use and fully integrated.

Website made with

Odoo Experience on YouTube

1. Use the live chat to ask your questions.
2. The operator answers within a few minutes.

Live support on Youtube
Watch now