FTP/SFTP IMPORT CSV/XLS FILE | All In One Import Record From FTP| All In One Import - Sales, Purchase, Accounts,Partner, Product, Inventory, BOM, CRM, Project | Import Product Template | Import Product Image | Import Product Variant | Import Sale Order Lines | Import Reordering Rules | Import Purchase Order Lines | All In One Import Record From SFTP | All In One Import Record From FTP | Import CSV File Manually
by Vraja Technologies https://www.vrajatechnologies.com$ 284.01
ALL IN ONE Import Record From SFTP Import CSV & XLSX File Manually |
Community Enterprise Odoo.sh |
A comprehensive solution called ALL IN ONE Import Records makes it easy to import any type of data into your Odoo database. This is a ONE-STOP IMPORT SOLUTION designed to simplify and streamline data management processes. With its flexibility and efficiency, this robust module enables users to import data through configurable mappings, multiple file formats, and automated workflows. Additionally, it supports dynamic translation during import, allowing users to configure translation fields at the table level and seamlessly import multilingual data within a single operation.This powerful capability makes it an essential tool for businesses operating in multi-language environments, ensuring accuracy, consistency, and efficiency across all data import processes.
End-to-end Odoo solutions for growing companies.
Explore the key features, workflow, and value of this Odoo module.
|
|
Versatile Data Import |
|
|
Different Import Techniques |
|
|
Interface That's Easy to Use |
|
|
Validation of Data and Error Management |
|
|
All types Data Mapping |
|
|
Dynamic Multilanguage Translation Support |
|
|
Supports CSV and Excel files |
|
|
Supports comma(',') and semicolon(';') as seprator for CSV files |
|
|
Supports 'UTF-8' and 'ISO-8859-1' format for CSV files |
01 Import Product CSV & XLSX file sample.
02 Import Invoices CSV & XLSX file sample.
03 Import Sale order CSV & XLSX file sample.
04 Dynamic Translation Product Import CSV & XLSX file sample.
05 You need to map fields of Odoo with CSV & XLSX columns.
Select Model in which you want to import records : You need to select Odoo model in which you want to create records.
Search record from this value : Set Column Alphabet (From A-Z), from this value check existing record available or not. To avoid duplication of records in Odoo this must be needed.
Default value : During the import/export process, if you want to include specific values along with the processed data, you should enter these values in dictionary format.
Main Table : You need to enable this option if your configuration is main, for example if you want to add a sale order record then for the sale order model you need to create configuration record with main table enable & you need to create sale order line configuration separately without main table enable.
CSV file column name : You need to enter the Alphabet (From A-Z), for which CSV column you need to map the Odoo field.
Selected Model Fields : Select field of selected model in which you want to add value.
Field to search for M2O : This field is not required, if you choose Many2one field for mapping then you have an option to set the inner field of that Many2one model. It helps you to search records based on that field or else search with the name field of the Many2one model.
Sub Table : For One2Many field you have to select a sub table in which there is a separate configuration available for One2Many field/model. (In sub table there is the same concept to follow, the only difference is in that table you don’t need to enable Main table & also not required to enter Search record from this value, so it will create duplicate One2Many records from CSV & if you select then it will update existing record.)
06 This is sub table configuration.
07 This is the configuration table for dynamic translation. By enabling the field translation option, you can select the languages in which you want to translate the data during the import process.
08 After the import process is completed, the translated values will be available in the corresponding translation fields.
09 Import CSV & XLSX file via SFTP.
10 Configuration of SFTP Connection.
Left Side : You need to enter SFTP details which are needed to connect to SFTP.
Store : You need to select the store and based on store some fields are visible below.
Dynamic Import Record : You need to select which Dynamic Import Record you want to connect with this SFTP record.
File Import Path : You need to enter file import path from SFTP.
Which type of data import? : You have to select which type of data you want to import: Inventory data or other data. If you select Inventory then you will see the location field. You have to enter the location where you want to change the inventory data.
Use first row as a header? : You need to select Use first row as a header? If you use Heading/Header in a CSV file.
Split the records of a file : If you have big files that need splliting for processing then you have to select the Split the Records of a File field as well.
CSV File Delimiter : At last, you have to enter the delimiter for the csv file (comma or semicolon).
11 This is the Schedule Action that will import the file from the SFTP path provided in configuration.
12 Import CSV & XLSX file via FTP.
13 Configuration of FTP Connection.
Configuration is same as SFTP connection.
14 This is the Schedule Action that will import the file from the FTP path provided in configuration.
15 Import CSV & XLSX file manually through a wizard.
Configuration is same as SFTP right side configuration except you have to select the file in this wizard.
16 Log management.
17 Log Details.
|
|
What is the purpose of the ALL IN ONE Import Records module?This module allows you to import data into Odoo using CSV or XLSX files with flexible field mapping, automation, and multilingual support. |
|
|
What types of records can I import using this module?You can import Products, Invoices, Sale Orders, Inventory data, and any custom Odoo model. |
|
|
How does field mapping work in this module?You need to map CSV/XLSX columns (A–Z) with Odoo model fields to ensure correct data import. |
|
|
How can I avoid duplicate records during import?Use the “Search record from this value” option to match existing records and update them instead of creating duplicates. |
|
|
What is the difference between Main Table and Sub Table?Main Table is used for primary records (e.g., Sale Orders), while Sub Table is used for related One2many records (e.g., Sale Order Lines). |
|
|
What is dynamic translation and how does it work?Dynamic translation allows you to import multilingual data by enabling translation on fields and selecting languages during configuration. |
|
|
Where are translated values stored after import?Translated values are automatically stored in Odoo’s translation fields and displayed based on the selected language. |
|
|
What import methods are available in this module?You can import data via SFTP, FTP, or manually through a wizard interface. |
|
|
How can I track import logs and errors?You can view detailed logs in the Log Management section, including created records, updated records, and errors highlighted in red. |
|
|
I would like to request a custom feature for this application. What’s the process to get it implemented?We’re happy to help tailor the application to meet your business needs! You can reach us via sales@vrajatechnologies.com |
|
|
Who is the point of contact for technical support, configuration support or bug-related queries?You can reach us via support@vrajatechnologies.com |
|
|
Included App SupportNo Time-Limit Support for Supported Versions |
If you encounter any issues while using our app that are caused by the app itself, we offer complimentary support for 90 days from the date of purchase.
Contact Us
vrajatechnologies.com/contactusSupport Policy
vrajatechnologies.com/support-policyDynamic Dashboard Builder
This module lets users create fully configurable, model-driven Odoo dashboards without coding, with dynamic fields, filters, relational data, calculated columns, and website-based visualization. It supports date filters, summary cards, dynamic tables, quick Today records, live selection updates, and custom colors for a modern and user-friendly dashboard experience.
Dynamic Export Records
This Odoo export module allows users to flexibly export records in CSV, TSV, or Excel formats with configurable fields, required field validation, filters, flat data, and one2many relational structure support. It supports FTP/SFTP export, API-based report downloads with additional filters, export logging, and repeatable structured data export configurations for any Odoo model.
Dynamic Field Mapping
Dynamic field mapping between two models in Odoo involves setting up mechanisms to automatically transfer or update data from one model to another. This can be useful in various scenarios, such as synchronising data between CRM leads and sales orders, sales orders and Invoice or any other custom models.
CRM to Rental Dynamic Field Mapping
Dynamic field mapping from CRM to Rental in Odoo involves automatically transferring data from the CRM model (crm.lead) to the Rental model (sale.order).This setup will dynamically map custom fields from CRM to Rental in Odoo, ensuring seamless data synchronization and enhanced workflow automation.
CRM To Sales Dynamic Field Mapping
Dynamic field mapping between Odoo CRM and Sales helps automatically transfer selected CRM fields to matching Sales Order fields, ensuring consistent and accurate data across both modules.It streamlines the workflow by allowing users to define source CRM fields and corresponding Sales fields, reducing manual entry and improving sales process efficiency.
Delivery Order To Invoice Dynamic Field Mapping
Dynamic field mapping from Delivery Order/picking to Invoice in Odoo involves automatically transferring data from the picking model (stock.picking) to the Invoice model (account.move).This can be particularly useful for maintaining data consistency and streamlining workflows. Identify the fields in the Picking model that you want to map to the Invoice model. Determine the corresponding fields in the invoice model.
Helpdesk Ticket To Repair Dynamic Field Mapping
Dynamic field mapping from Helpdesk Ticket to Repair in Odoo involves automatically transferring data from the Helpdesk Ticket model (helpdesk.ticket) to the Repair model (stock.picking). This setup will dynamically map custom fields from Helpdesk Ticket to Repair in Odoo, ensuring seamless data synchronization and enhanced workflow automation.
Helpdesk Ticket To Return Dynamic Field Mapping
Dynamic field mapping from Helpdesk Ticket to Return in Odoo involves automatically transferring data from the Helpdesk Ticket model (helpdesk.ticket) to the Return model (stock.picking). This setup will dynamically map custom fields from Helpdesk Ticket to Return in Odoo, ensuring seamless data synchronization and enhanced workflow automation.
Purchase To Vendor Bill Dynamic Field Mapping
Dynamic field mapping from Purchase Order to Vendor Bill in Odoo involves automatically transferring data from the Purchase Order model (purchase.order) to the Vendor Bill model (account.move). This setup will dynamically map custom fields from Purchase Orders to Vendor Bills in Odoo, ensuring seamless data synchronization and enhanced workflow automation.
Purchase To Receipt Order Dynamic Field Mapping
Dynamic field mapping from Purchase Order to Incoming Order in Odoo involves automatically transferring data from the Purchase Order model (purchase.order) to the Incoming Order model (stock.picking). This setup will dynamically map custom fields from Purchase Orders to Incoming Orders in Odoo, ensuring seamless data synchronization and enhanced workflow automation.
Repair To Sale Order Dynamic Field Mapping
Dynamic field mapping from Repair Order to Sale Order in Odoo involves automatically transferring data from the Repair Order model (repair.order) to the Sale Order model (sale.order). This setup will dynamically map custom fields from Repair Orders to Sale Orders in Odoo, ensuring seamless data synchronization and enhanced workflow automation.
SaleOrder To PurchaseOrder(Dropshipping) Dynamic Field Mapping
Dynamic Field Mapping from Sales Order to Purchase Order in Odoo automatically transfers selected standard or custom fields from `sale.order` to `purchase.order`, ensuring accurate data synchronization and workflow automation. It supports flexible model and field mapping for sales-to-purchase, dropshipping, custom modules, and changing business requirements without repeated code changes.
SaleOrder To Project Task Dynamic field mapping
Dynamic Field Mapping from Sales Order to Project Task in Odoo automatically transfers selected standard or custom fields from `sale.order` to `project.task`, ensuring seamless data synchronization and workflow automation. It supports flexible and customizable model-field mapping for sales-to-task workflows, custom modules, integrations, and changing business requirements without repeated code changes.
Sale To Delivery Dynamic Field Mapping
Dynamic Field Mapping from Sales Order to Delivery Order in Odoo automatically transfers selected standard or custom fields from "sale.order" to "stock.picking". It ensures seamless data synchronization, reduces manual entry, and improves workflow automation between sales and delivery operations.
Sale To Invoice Dynamic Field Mapping
Dynamic field mapping from Sales to Invoice in Odoo involves automatically transferring data from the Sales Order model (sale.order) to the Invoice model (account.move).This can be particularly useful for maintaining data consistency and streamlining workflows. Identify the fields in the Sales moodel that you want to map to the Invoice model. Determine the corresponding fields in the invoice model.
Sale To Manufacturing Dynamic Field Mapping
Dynamic Field Mapping from Sales Order to Manufacturing Order in Odoo automatically transfers selected standard or custom fields from "sale.order" to "mrp.production". It ensures seamless data synchronization, reduces manual work, and improves workflow automation between sales and manufacturing operations.
Helpdesk Ticket To Refund Invoice Dynamic field mapping
Dynamic Field Mapping from Helpdesk Ticket to Refund Invoice in Odoo automatically transfers selected standard or custom fields from "helpdesk.ticket" to "account.move". It ensures seamless data synchronization, reduces manual entry, and supports flexible field mapping for refund workflows, custom modules, and changing business needs.
Helpdesk Ticket To Project Task Dynamic field mapping
Dynamic Field Mapping from Helpdesk Ticket to Project Task in Odoo automatically transfers selected standard or custom fields from helpdesk.ticket to project.task. It ensures seamless data synchronization, reduces manual entry, and supports flexible field mapping for ticket-to-task workflows, custom modules, and changing business needs.
Dynamic Import Records From Email
Automates record creation in Odoo from email attachments (Excel/CSV) with dynamic model mapping. This module automates the processing of incoming emails with Excel or CSV attachments. It searches for unread emails from specific partner email addresses, parses and extracts attachments from emails (it supports .xlsx and .csv files), and dynamically creates records in the configured Odoo model.
Dynamic Import XML Records(FTP/SFTP Import/Manually Upload)
Dynamic XML Import for Odoo allows businesses to import XML files of any structure into Odoo using flexible node mapping without hardcoding. It supports XML-based integrations for products, orders, customers, invoices, stock, and custom records, with Dynamic Translation support for multilingual data import.
Explore Before Purchase |
Start with a free trial
Test the connector with your real workflows using our 15-day free trial. If you need help, our product experts will guide you throughout the trial.
|
|
Test the connector with your real workflows.Our product experts will guide you during the trial to help you evaluate, configure, and use the connector with confidence.
15-Day
Trial
Expert
Guidance
Real
Workflow Testing
|
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) • Invoicing (account) |
| Lines of code | 1368 |
| Technical Name |
dynamic_import_records |
| License | OPL-1 |
| Website | https://www.vrajatechnologies.com |
Odoo Proprietary License v1.0 This software and associated files (the "Software") may only be used (executed, modified, executed after modifications) if you have purchased a valid license from the authors, typically via Odoo Apps, or if you have received a written agreement from the authors of the Software (see the COPYRIGHT file). You may develop Odoo modules that use the Software as a library (typically by depending on it, importing it and using its resources), but without copying any source code or material from the Software. You may distribute those modules under the license of your choice, provided that this license is compatible with the terms of the Odoo Proprietary License (For example: LGPL, MIT, or proprietary licenses similar to this one). It is forbidden to publish, distribute, sublicense, or sell copies of the Software or modified copies of the Software. The above copyright notice and this permission notice must be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.
Please log in to comment on this module