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$ 289.14
| Availability |
Odoo Online
Odoo.sh
On Premise
|
| Odoo Apps Dependencies |
•
Inventory (stock)
• Discuss (mail) • Invoicing (account) |
| Lines of code | 1348 |
| Technical Name |
dynamic_import_records |
| License | OPL-1 |
| Website | https://www.vrajatechnologies.com |
| Versions | 15.0 16.0 17.0 18.0 19.0 |
.png?53fd6dd)
Enterprise Community Odoo.sh
ALL IN ONE Import Record From SFTP Import CSV & XLSX File Manually
A comprehensive solution called Dynamic Import Records makes it easy to import any kind of data into your Odoo database. This is our ONE-STOP IMPORT SOLUTION. With its versatility and effectiveness, this robust module is a vital tool for companies trying to streamline their data management procedures.
Watch on YouTube
Recommended Solutions
.png?53fd6dd)
Features
Process
FAQs
Versatile Data Import
Different Import Techniques
Interface That's Easy to Use
Validation of Data and Error Management
All types Data Mapping
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
Import Product CSV & XLSX file sample.
Import Sale order CSV & XLSX file sample.
Installation and Configuration of import records.
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.)
This is sub table configuration.
Import CSV & XLSX file via SFTP.
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).
This is the Schedule Action that will import the file from the SFTP path provided in configuration.
Import CSV & XLSX file via FTP.
Configuration of FTP Connection.
Configuration is same as SFTP connection.
This is the Schedule Action that will import the file from the FTP path provided in configuration.
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.
Log management.
Log Details.
You can see detailed logs of operations here. You can see logs for create/update records or any error (Marked RED) that you encounter while performing an operation.
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, configuraion support or bug-related queries?
- You can reach us via support@vrajatechnologies.com
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
%201.png?53fd6dd)
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
GET INSTANT PERSONALIZED DEMO
Submit Request
Teams
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