Odoo Advanced Import Pro – All Modules Bulk Data Tool
by WebbyCrown Solutions https://www.webbycrown.com$ 58.56
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 65119 |
| Technical Name |
odoo_advanced_import_all_modules |
| License | LGPL-3 |
| Website | https://www.webbycrown.com |
| Versions | 17.0 18.0 |
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Lines of code | 65119 |
| Technical Name |
odoo_advanced_import_all_modules |
| License | LGPL-3 |
| Website | https://www.webbycrown.com |
| Versions | 17.0 18.0 |
Odoo Advanced Import Pro – All Modules Bulk Data Tool
Universal Multi-Format Import Solution (CSV/XML/Excel/JSON) with API Integration, Smart Field Mapping, Scheduled Imports, Data Filtering, Batch Processing, and Comprehensive Logging for Any Odoo Model
Complete Import Walkthrough
Discover how the Advanced Import And Data Migration Tool simplifies data migration and bulk imports in Odoo. Import data from CSV, XML, Excel, JSON files, URLs, or REST APIs into any Odoo model with intelligent field mapping, data filtering, scheduled imports, batch processing, real-time progress tracking, import control (pause/resume/stop), auto-create related records, and comprehensive error logging. Perfect for data migration, bulk updates, regular data synchronization, and automated imports.
Feature Highlights:
Key Benefits
- Multi-Format Support: Import from CSV, XML, Excel (.xlsx, .xls), and JSON files with automatic format detection and parsing.
- Multiple Import Sources: Upload files, import from URLs, or fetch data directly from REST APIs with full authentication support (Basic, Bearer Token, API Key).
- Scheduled Imports: Automate your imports with scheduled recurring tasks (daily, weekly, monthly, yearly, or custom cron expressions).
- Data Filtering: Filter rows before import using custom rules with multiple operators (equals, contains, greater than, etc.) and logical operators (AND/OR).
- Auto-Create Related Records: Automatically create missing Many2one related records during import, eliminating manual data preparation.
- Import Control: Pause, Resume, or Stop imports during processing for better control over long-running imports.
- Universal Model Support: Import data into any Odoo model - standard or custom - with a single, intuitive interface.
- Smart Field Mapping: Automatic field detection and mapping with manual override options for precise control.
- Batch Processing: Process large datasets efficiently with configurable batch sizes and background processing.
- Real-Time Progress: Track import progress in real-time with detailed statistics and progress indicators.
- Comprehensive Logging: Detailed logs for every record - success, error, and update - with full row data for troubleshooting and advanced search capabilities.
- Multiple Import Modes: Create new records, update existing ones, or do both with intelligent duplicate detection.
- Data Preview: Preview your data before importing to ensure accuracy and catch issues early.
- Complex Field Support: Handle Many2one, Date, Boolean, Selection, and all other Odoo field types seamlessly.
- Kanban Views: Visual dashboards for import configurations and scheduled imports with status indicators and quick access.
- Help Guide: Comprehensive built-in help guide with complete workflow documentation and troubleshooting tips.
2. Modules & Features
1. Multi-Format File Upload & Configuration
- Support for CSV, XML, Excel (.xlsx, .xls), and JSON file formats.
- Upload files, import from URLs, or fetch from REST APIs with authentication.
- CSV: Custom delimiters (comma, semicolon, pipe, tab) and header row detection.
- XML: Auto-detection of root elements or manual specification.
- Excel: Sheet selection support with header row detection.
- JSON: Support for root arrays and nested objects with path specification.
- Select any Odoo model (standard or custom) as the import target.
2. API Integration
- Fetch data directly from REST APIs with full HTTP method support (GET, POST, PUT, PATCH).
- Multiple authentication types: Basic Auth, Bearer Token, API Key, or no authentication.
- Custom request headers in JSON format for API-specific requirements.
- Request body support for POST/PUT/PATCH requests with JSON payloads.
- Automatic JSON response parsing with root path support for nested data structures.
3. Smart Field Mapping
- Automatic field mapping with intelligent name matching (case-insensitive).
- Manual field mapping with dropdown selection for each source field.
- Support for all field types including relational fields (Many2one, One2many, Many2many).
- Field validation and required field checking before import.
- Auto-create related records for Many2one fields when enabled.
4. Data Filtering
- Filter rows before import using custom rules with multiple operators.
- Operators: Equals, Not Equals, Greater Than, Less Than, Contains, Starts With, Ends With, Is Empty, In, Not In.
- Logical operators: AND (all conditions) or OR (any condition).
- Import only rows that match specific criteria (e.g., active records, date ranges, categories).
- Exclude invalid or test data before processing.
5. Data Preview
- Preview first 5 rows of mapped data before importing.
- See exactly how source fields map to Odoo fields.
- Validate data format and catch errors before processing.
6. Import Modes
- Create Only: Import new records only, skip existing ones.
- Update Only: Update existing records based on unique field matching.
- Create or Update: Create new records or update existing ones automatically.
- Select unique field for update operations (email, code, name, etc.).
7. Scheduled Imports
- Schedule imports to run automatically at specified intervals.
- Schedule types: Daily, Weekly, Monthly, Yearly, Run Once, or Custom Cron.
- Automatic cron job creation and management for reliable execution.
- Track execution history with run count, last run date, and next run date.
- Kanban view for visual dashboard of scheduled imports.
8. Batch Processing & Import Control
- Process large datasets in configurable batches (default: 10 records per batch).
- Background processing continues even after page refresh.
- Real-time progress tracking with "X / Y" format display.
- Import Control: Pause, Resume, or Stop imports during processing.
- Import continues in background using cron jobs for reliability.
9. Comprehensive Logging & Advanced Search
- Three log types: Success, Error, and Update for complete visibility.
- Color-coded logs (green for success, blue for update, red for errors).
- Full row data stored with each log entry for troubleshooting.
- Advanced Search: Filter by log type, row number, date range, error type, session ID, and more.
- Group by log type, date, session, or created by for better analysis.
- Formatted data display with searchable, filterable log views.
10. Kanban Views & Help Guide
- Kanban Views: Visual dashboards for import configurations and scheduled imports.
- Group by state, schedule type, or other criteria for better organization.
- Quick access to import status, progress, and statistics.
- Help Guide: Comprehensive built-in documentation with complete workflow.
- Step-by-step instructions, troubleshooting tips, and best practices.
FAQs
1. What is the Odoo Advanced Import Pro – All Modules Bulk Data Tool?
It is a comprehensive multi-format import solution for Odoo that allows you to import data from CSV, XML, Excel, and JSON files, URLs, or REST APIs into any Odoo model with intelligent field mapping, data filtering, scheduled imports, batch processing, background import, real-time progress tracking, import control (pause/resume/stop), auto-create related records, and comprehensive error logging. Perfect for data migration, bulk updates, regular data synchronization, and automated imports.
2. What file formats are supported?
The module supports CSV (with custom delimiters), XML (with auto-detection or manual root element), Excel (.xlsx, .xls with sheet selection), and JSON (root arrays or nested objects with path specification). You can also import from URLs or fetch data directly from REST APIs.
3. Can I schedule imports to run automatically?
Yes! You can schedule imports to run automatically at specified intervals: Daily, Weekly, Monthly, Yearly, Run Once at a specific date/time, or use Custom Cron expressions for advanced scheduling. The system automatically creates and manages cron jobs for reliable execution.
4. How does API integration work?
You can fetch data directly from REST APIs by configuring the API endpoint URL, HTTP method (GET, POST, PUT, PATCH), authentication type (Basic Auth, Bearer Token, API Key, or None), custom headers, and request body. The system automatically parses JSON responses and supports root arrays or nested objects with path specification.
5. Can I filter data before importing?
Yes! You can use data filtering to import only rows that match specific criteria. Set up filter rules with operators like Equals, Contains, Greater Than, Is Empty, In, etc., and combine them with AND/OR logic. This is useful for importing only active records, filtering by date ranges, or excluding test data.
6. What import modes are available?
Three modes: Create Only - imports new records only; Update Only - updates existing records based on a unique field; Create or Update - automatically creates new records or updates existing ones based on unique field matching.
7. Can I control imports during processing?
Yes! You can Pause an import to temporarily stop processing, Resume to continue from where it was paused, or Stop to completely halt the import. This gives you full control over long-running imports.
8. Can the system auto-create related records?
Yes! When enabled, the system automatically creates missing related records (Many2one fields) during import. For example, if you're importing a contact with a company that doesn't exist, the system will automatically create the company record. This eliminates the need for manual data preparation.
9. Can I see what went wrong if import fails?
Yes! The module provides comprehensive logging with three types: Success (green), Update (blue), and Error (red). Each log entry includes the row number, error message, and the complete row data in a formatted table. Advanced search capabilities allow you to filter by log type, row number, date range, error type, and more for easy troubleshooting.
Contact & Support
Have Any Question ?
Sales : +91 (942) 867-7503
Please log in to comment on this module