Import, Export and Mass Update: Tips and tricks
9. Questions ?
3. Data Import
4. My company is moving to Odoo to better structure and automates my processes. Therefore I need to put data in Odoo to use them !
10. Thank you. #odooexperience EXPERIENCE 2016
1. Export and Mass Update: Tips and tricks Michael Vercruyssen • Functional consultant EXPERIENCE 2016
6. Create Template Select records in list view Select the field by label name (easily reorder them) Select the export type (to reach up to 3 relational levels) Select the format: CSV or Excel Save fields list for future use Data Export
8. Export/import Select the records to update in list view Select the option “import-Compatible Export” Keep the first column with “ID”, if left blank it create a new record You can modify any fields Use Vlookup to link relation field and set the external ids (better) Mass Update
2. Introduction 1 Import Export Mass Update Conclusion 2 3 4 5
5. Create Template Export to get file structure Use external IDs or name to create links between objects Use fields label or field name for the first row Check your file structure Import Preview of your file with mapping with Odoo fields Tick “Show all fields for completion (advanced)” to see all type of fields Validation of the import Import Data import
7. Import ● Use preferably External IDs ● Export a test record to get file structure for this model ● For relation field, do a vlookup after exporting the other model ids ● To be able to link model => generate the external id of records by exporting them. ● Tick “Show all fields for completion (advanced)” to see all type of fields Export ● Save your export list for future use ● Use the export type to get more fields and go deeper in the relationships ● Export directly in Excel for analysis purpose ● You can export also pivot table into excel sheets Tips and tricks
- 242 Total Views
- 0 Website Views
- 242 Embeded Views
- Social Shares
- 0 Likes
- 0 Dislikes
- 0 Comments
- 0 Facebook
- 0 Twitter
- 0 Google+
- 6 onlinesync.odoo.com
- 2 accounts.odoo.com
Keynote: Odoo 9 New Features41067 Views .
Odoo Mobile Development Framework & App build with it11648 Views .
Odoo 9 New Design- The rationales behind it11403 Views .
Open Source Licenses9474 Views .
How A/B testing can help you optimize your website8678 Views .
Shipper integration - UPS, DHL, FedEx7545 Views .
Import and export data - Tips & Tricks6316 Views .
UX best practices to create your module6112 Views .
Keynote: Odoo Strategy 20155968 Views .
How to use Odoo in a Restaurant5554 Views .
Odoo 9: New Business Model5415 Views .
Contributing to the Odoo Community Association (OCA)4896 Views .
Odoo cms Performance Comparison and Optimisation4767 Views .
VOIP: One-click Button to Automate Calls4331 Views .
First steps in Odoo dev3984 Views .
Odoo 9 New Design- Usability Methodology3813 Views .
How to use Odoo in a service company3794 Views .
Advanced Features of the API3766 Views .
State of the Odoo JS framework3737 Views .