Description
.png)
Enterprise Community Odoo.sh
Dynamic Import XML Records(FTP/SFTP Import/Manually Upload)
The Dynamic XML Import for Odoo module allows businesses to import XML files of any structure into Odoo without hardcoding.
Whether your XML comes from suppliers, marketplaces, logistics partners, payment gateways, legacy ERPs, or government systems, this module maps XML nodes dynamically to Odoo models like Products, Sales Orders, Customers, Invoices, Stock, and custom records.
Ideal for companies working with EDI, B2B integrations, and XML-based data exchange.
With the newly Dynamic Translation feature, users can automatically translate imported data into selected languages. The module allows you to enable translation during import and choose the target language, ensuring that your data is localized and ready for multilingual environments without additional manual effort.
- Why Businesses Choose This Module
- Works with any XML structure
- No fixed schema or hardcoding
- Supports custom Odoo models
- Reusable mapping configurations
- Scalable for enterprise data volume
- Ideal for B2B & EDI-style workflows
Watch on YouTube
Key Features
.png)
Connect With Multiple FTP/SFTP Servers
.png)
Supported Any XML File Format
With Dynamic Data Translation
.png)
Auto Import/Upload Files Manually
.png)
Auto Import Inventory From FTP/SFTP
.png)
Manage Detailed Log For Each Process
Interactive User
Interface
We specialize in delivering advanced Odoo solutions across multiple domains. Our expertise includes:
EDI & SWIFT/ACH Payment Integrations
End-to-end EDI automation, including X12, EDIFACT, XML standards, & financial integrations such as SWIFT, ACH, & Fedwire.
eCommerce Integrations
Seamless integration with leading eCommerce platforms to sync products, orders, inventory, and customer data in real time.
Shipping Integrations
Robust shipping connectors for global couriers, offering automated label generation, tracking, and rate computation.
Most Useful Apps for your ERP
A wide range of highly-rated Odoo modules designed to enhance automation, improve productivity, & simplify business operations.
Import Recored
Import Manually
FAQs
1. Installation
After downloading the Dynamic Import XML Records App from the Odoo store, place it in the Odoo Addons path or any desired location. Restart your Odoo instance and go to the Apps section in the dashboard. Click on “Update Apps List” from the menu. Once the list is updated successfully, the Dynamic Import XML Records app will appear in the Apps section.
Click the “Install” button, and you’re all set! You can now use the Dynamic Import XML Records app in your Odoo instance.
2.FTP/SFTP Configuration (From menu Sync FTP/SFTP Syncing)
You need to set up FTP syncing connection by entering the URL, port, username, and password.
After entering the proper details, the right-side ribbon indicates whether your FTP connection is properly configured or not.
You need to set up SFTP syncing connection by entering the Host, username, password, host. Additionally you need to enter root directory path, so we will import inner all directories.
After entering the proper details, the right-side ribbon indicates whether your SFTP connection is properly configured or not.
3.Fetch Directories from FTP/SFTP
After successfully syncing with FTP/SFTP, you will see the ‘Sync FTP/SFTP Directories’ button. Clicking this button will fetch the directories from FTP/SFTP and create corresponding records in Odoo.
4. Mapping Table integration (From Mapping menu)
You need to mention the required details for the table.
Odoo Model: Which Odoo model would you like to perform the operation on?
Main Table:You need to enable this option if your configuration is main. For example, to add a sale order record, create a configuration record with the main table option enabled for the sale order model. Additionally, create a separate configuration for the sale order line without enabling the main table option.
File Type If your XML file having single record then select single. – If your XML file having multiple records then select multiple.
XML Header: You need to specify the main header name in the XML.
-
Search record from this value: To check an existing record, Set the XML element name(s) here. Use the provided value(s) to check if existing records are available. You can specify multiple XML elements, separated by commas.
Default value: During the import process, if you want to include specific values along with the processed data, you should enter these values in dictionary format.
In Mapping XML Elements with Fields table
-
XML Element: You need to enter the exact XML element you want to map with the Odoo field.
Selected Model fields: You need to select the field with which you want to map the XML data.
Field to search for M2O: This field is optional. If you choose a Many2one field for mapping, you have the option to set the inner field of that Many2one model. This helps you search records based on that field; otherwise, the search will use the name field of the Many2one model.
Sub Table:For a One2Many field, you need to select a subtable where a separate configuration is available for the One2Many fields. (In the subtable, follow the same concept, but you do not need to enable the Main table option. If the “Search record from this value” field is left empty, it will create duplicate One2Many records from the CSV. If you select this option, it will update existing records.)
Main Table
Sub Table
5. Import Records with Dynamic Translation
Enhance your data import process with built-in Dynamic Translation capabilities. This feature allows you to automatically translate imported XML data into your preferred language during processing.
To use this feature, create a mapping table for the main table where you want to import multiple records and apply translation. Define the XML element tags for which translation should be enabled, and select the target language to translate the corresponding field data.
Translation should be configured within the translation field, and after importing the data, the translated values will be reflected in the translation fields selected in the mapping table.
6. Sample XML files
Sample Products file which gets imported from FTP.
7.Import Records Process (From FTP/SFTP to Odoo)
Fetch Inner files/attachments from directories through button “Sync Inner Files”
We have also provided a scheduled action option for automation. A scheduled action will be created for each FTP/SFTP configuration, and you can review it using the smart button within the form view. You can configure the execution time according to your requirements.
Before pressing the button or executing the scheduled action, certain configurations must be completed. The details are provided below.First, in the directory list view, specify which directory will be used for the Download operation, so from those directory we will fetch inner files.
In the directory configuration, there’s an option stating, “Daily new file coming in this directory”. If a directory receives new files with the same name every day, and you need to fetch and process them in Odoo daily, you should enable this checkbox.
Second, in the directory itself you need to select Mapping Model/Table if you don’t want to search using XML header.
We’ve added a feature that allows automatic mapping table search using an XML file’s header. Enable the “Search mapping table using XML header” option in the directory form view to support multiple file formats in one directory. Ensure the mapping table is configured for different XML headers.
After making these selections of download option & mapping Model/table you need to press ‘Sync Inner Files’ button, that process fetch inner files/attachments from the directories chosen for downloading will be fetched into Odoo, creating Odoo attachments.
Along with FTP/SFTP attachments, Transaction will also be created. (Those records will be processed when the scheduled action executes.)
Additionally, we have implemented a directory-wise auto-sync feature. If you have numerous files across different directories that are marked for download, there is a possibility where the common scheduled action of sync inner files encounters timeouts due to Odoo’s processing limits, resulting in incomplete synchronization.
To address this issue, we have provided an option to enable auto-sync on a per-directory basis. Simply click the “Generate Auto Sync” button in the desired directory, and the sync process will run individually for the files within that directory, ensuring complete synchronization. You can review it using the smart button within the form view.
8.Process Transactions via Scheduled Action (Cron)
From the scheduled action, all Transactions in the draft state are processed based on the type.
Incoming type: Records will be created in Odoo.
On successful Transaction processed that record will move to the done state, if any issue arises then it will move into the failed state & log will generated to check issue.
Scheduled Action
Incoming record created of Sale Order
9. Log management
A log is created for reference in case of any faults during the import process.
We also set a scheduled action to delete log records older than 13 days.
10. Sample XML files
Sample Sale order file which gets imported from FTP.
1. We are managing a distinct configuration setup for the import multiple records in a single file.
Odoo Model:Which Odoo model would you like to perform the operation on?
Main table: For importing multiple records in a file, we use a main table and sub-table concept. In the main table, you need to enable this option. (You need to create sub-table first for those model mapping configuration.)
File Type: If your XML file having single record then select single. – If your XML file having multiple records then select multiple. (In this case it’s regarding multiple records in single file.)
XML Header:You need to specify the main header name in the XML.
Search record from this value: To check an existing record, Set the XML element name(s) here. Use the provided value(s) to check if existing records are available. You can specify multiple XML elements, separated by commas.
Default value:During the import process, if you want to include specific values along with the processed data, you should enter these values in dictionary format. Type: Incoming.
In Mapping XML Elements with Fields table
XML Element:Enter the exact XML element to map with the Odoo field. Use ‘/’ to separate elements for nested levels.
Sub EDI Import Table: For importing multiple records in a file, create a table without enabling the main table option, inside that table map Odoo fields to XML elements, and select that table here.
Main Table of Import multiple records in a file
Sub Table
Sub Table of Import Quants
2. Import Records with Dynamic Translation
Enhance your data import process with built-in Dynamic Translation capabilities. This feature allows you to automatically translate imported XML data into your preferred language during processing.
Create a mapping table for the main table where you want to import multiple records and apply translation. Configure the XML elements to correctly identify the sub-table.
Link the sub-table to the appropriate model where the records need to be imported.
Within the sub-table, define the XML element tags for which translation should be enabled, and select the target language to translate the corresponding field data.
Translation should be configured within the translation field, and after importing the data, the translated values will be reflected in the translation fields selected in the mapping table.
Sample XML files
Sample Products file which gets imported from FTP.
3.Import Records Process (From FTP/SFTP to Odoo)
Fetch Inner files/attachments from directories through button “Sync Inner Files”
We have also provided a scheduled action option for automation. A scheduled action will be created for each FTP/SFTP configuration, and you can review it using the smart button within the form view. You can configure the execution time according to your requirements.
Before pressing the button or executing the scheduled action, certain configurations must be completed. The details are provided below.
First, in the directory list view, specify which directory will be used for the Download operation, so from those directory we will fetch inner files.
In the directory configuration, there’s an option stating, “Daily new file coming in this directory”. If a directory receives new files with the same name every day, and you need to fetch and process them in Odoo daily, you should enable this checkbox.
Second, in the directory itself you need to select Mapping Model/Table if you don’t want to search using XML header.
We’ve added a feature that allows automatic mapping table search using an XML file’s header. Enable the “Search mapping table using XML header” option in the directory form view to support multiple file formats in one directory. Ensure the mapping table is configured for different XML headers.
We have also introduced a feature that enables record splitting. If a file is too large or contains an excessive number of records, it will be automatically split to ensure seamless processing. This functionality applies to all files within this directory, allowing efficient handling and processing.
You need to enable the “Split the records of a file” option. Once enabled, a new field will appear below it, where you must specify the XML tag used to split the file. This tag should correspond to multiple records.
After making these selections you need to press ‘Sync Inner Files’ button, that process fetch inner files/attachments from the directories chosen for downloading will be fetched into Odoo, creating Odoo attachments.
Along with attachments, Transaction will also be created. (Those records will be processed when the scheduled action executes.)
Additionally, we have implemented a directory-wise auto-sync feature. If you have numerous files across different directories that are marked for download, there is a possibility where the common scheduled action of sync inner files encounters timeouts due to Odoo’s processing limits, resulting in incomplete synchronization.
To address this issue, we have provided an option to enable auto-sync on a per-directory basis. Simply click the “Generate Auto Sync” button in the desired directory, and the sync process will run individually for the files within that directory, ensuring complete synchronization. You can review it using the smart button within the form view.
4. Process Transactions via Scheduled Action (Cron)
From the scheduled action, all Transactions in the draft state are processed based on the type.
Incoming type:Records will be created in Odoo.
On successful Transaction processed that record will move to the done state, if any issue arises then it will move into the failed state & log will generated to check issue.
Scheduled Action
Incoming record created of Sale Order
Sample XML files
Sample Sale order file which gets imported from FTP.
1. Mapping Table integration
Odoo Model:Which Odoo model would you like to perform the operation on?
Main table:You need to enable this option if your configuration is main. For example, to add a sale order record, create a configuration record with the main table option enabled for the sale order model. Additionally, create a separate configuration for the sale order line without enabling the main table option.
File Type: If your XML file having single record then select single. – If your XML file having multiple records then select multiple.
XML Header: You need to specify the main header name in the XML.
Search record from this value:To check an existing record, Set the XML element name(s) here. Use the provided value(s) to check if existing records are available. You can specify multiple XML elements, separated by commas.
Default value:During the import process, if you want to include specific values along with the processed data, you should enter these values in dictionary format.
In Mapping XML Elements with Fields table
XML Element: You need to enter the exact XML element you want to map with the Odoo field.
Selected Model fields: You need to select the field with which you want to map the XML data.
Field to search for M2O:This field is optional. If you choose a Many2one field for mapping, you have the option to set the inner field of that Many2one model. This helps you search records based on that field; otherwise, the search will use the name field of the Many2one model.
Sub Table:For a One2Many field, you need to select a subtable where a separate configuration is available for the One2Many fields. (In the subtable, follow the same concept, but you do not need to enable the Main table option. If the “Search record from this value” field is left empty, it will create duplicate One2Many records from the CSV. If you select this option, it will update existing records.)
Main Table
Sub Table
2. Import XML file manually through a wizard
Mapping Tabel/Model: select Mapping Model/Table
Import File: Import XML file
Split the recoreds of the file : We have also introduced a feature that enables record splitting. If a file is too large or contains an excessive number of records, it will be automatically split to ensure seamless processing. This functionality applies to all files within this directory, allowing efficient handling and processing.
You need to enable the “Split the records of a file” option. Once enabled, a new field will appear below it, where you must specify the XML tag used to split the file. This tag should correspond to multiple records.
After submitting the process, a Transaction will also be created. (Those records will be processed when the scheduled action executes.)
Incoming record created of Products
Sample XML files
Sample Product file which gets imported from FTP.
I need an extra customization in this application, how can I get it?
- Yes, you can contact us on support@vrajatechnologies.com or can schedule a DEMO with our team to customize additional features.
Is the application compatible with Odoo Enterprise and Community?
- Yes, this application module is supported by both. It is also compatible with test and production environments.
Do I get free upgrades and support if I purchase this application?
- If there is a bug or any issues, our team will be there to help you out. If you need to add any new features, you will need to upgrade the application.
Is technical knowledge required to set up the integration?
- While some technical understanding may be helpful, the integration is designed to be user-friendly. Detailed documentation and support may be provided to aid in the setup process.
Is this free customization and implementation?
- Our team has produced a support video that guides you through the implementation process step by step. If you encounter any issues, please feel free to contact us for assistance.
Which protocol you have used to transfer file?
- We have used FTP protocol to transfer files.
Does this support all type of import records?
- Yes, mostly all types of records will supported, for import inventory we have given separate configuration that mentioned in documentation.
Which file format supported?
- XML file format supported.
From one directory currently 5 files are there & those imported in Odoo, next time when there are total 10 files(5 old and 5 new) that time if I fetch inner files from same directory is it create old records again in Odoo?
- No, we have managed that thing. Only new files will import in Odoo & from those files records will create.
What is the Dynamic Translation feature?
- It allows automatic translation of imported XML data into a selected language during the import process.
How do I enable translation during import?
- You can enable translation in the mapping table configuration and select the target language for the fields you want to translate.
Will the translated data be stored in Odoo?
- Yes, after import, the translated values will be stored in the corresponding translation fields configured in the mapping table.
Can I use multiple languages for translation?
- Yes, you can select different target languages based on your requirements during configuration.
Submit a Support Ticket
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.
To create a support ticket, please register via the Vraja Technologies Support Email and provide the necessary details so we can assist you in resolving the issue.
Email Us
support@vrajatechnologies.com
 1.png)
Contact Us
vrajatechnologies.com/contactus
Support
vrajatechnologies.com/support-policy
Vraja Technologies Services
Odoo Implementation
Odoo App Integration Services
Odoo Customization
Odoo Consultation
Odoo Support & Maintenance
Odoo Developer Outsourcing
Suggested Application
Reviews
There are no reviews yet.