This module integrates with FTP servers to retrieve folder structures and create file attachments, allowing seamless file management within Odoo. It supports importing and exporting various data, facilitating efficient data transfer to and from Odoo.
You need to set up FTP syncing connection by entering the FTP URL, port, username, and password.
After entering the proper details, the right-side ribbon indicates whether your FTP connection is properly configured or not.
After successfully syncing with FTP, you will see the 'Sync FTP Directories' button. Clicking this button will fetch the directories from FTP and create corresponding records in Odoo.
(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.)
First, in the directory list view, specify which directory will be used for the Download operation and which for the Upload operation.
After making these selections, the inner files/attachments from the directories chosen for downloading will be fetched into Odoo, creating Odoo attachments.
Along with FTP attachments, EDI transaction records will also be created. (Those records will be processed when the scheduled action executes.)
A scheduled action has been created to fetch export records based on the EDI Table configuration of the Trading Partner and Odoo Model, which will then create EDI transaction records. (Those records will be processed when the scheduled action executes.)
If something goes wrong or required field values are missing, those EDI transaction records will be set to a failed state, and a log will be generated for them. After rectifying the issue, you can recompute the XML content by clicking the 'Re-compute' button. Upon successful recomputation, the XML content will be available, and the state will change to draft.
From the scheduled action, all EDI transactions in the draft state are processed based on the type.
Incoming type: Records will be created in Odoo.
Outgoing type: Records will be exported/uploaded to FTP from Odoo. Based on the configuration table, the XML file will be uploaded to the directory specified in the configuration.
On successful EDI 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
Incoming record created of Purchase Order
Outgoing record: XML file is generated and exported to the configured FTP directory.
A log is created for reference in case of any faults during the import/export process.
We also set a scheduled action to delete log records older than 13 days.
Sample Sale order file which gets imported from FTP.
Sample Purchase Order file which gets imported from FTP.