Docs / NVXCFT Cloud File Transfer / Tasks Working with the Cloud File Transfer
With the help of the codeunit CFTFileInterfaceMgtNVX files can be exported or imported according to the CFT setup.
The app can either be used in a cloud database with flows or with the extension OnPremise File Transfer for OnPremise databases allow direct file access and thus bypass the flows.
Which variant is used controls which apps are installed and what is set up in the CFT setup.
Setup of Flows
The export or import flow can be started via an HTTP request to one of the Uri defined in the CFT setup.
The flows send an HTTP POST or GET request to the pages released as web service in order to import a file to BC or via e.g. export a file system connector to an existing folder.
Caution
Für den Flow wird eine PowerAutomate Premium Lizenz benötigt.
You can find in the repository 2 example files for an import or export flow.
ExportFile_CloudFileTransfer_Demo_20220113070553.zip
ImportFile_CloudFileTransfer_Demo_20211020045958.zip
In these Flows are authentifications saved. These authentifications must be changed after the import of the template.
At the import flow the username and password is set in the HTTP2 step.
At the export flow the username and password are set in the HTTP as well the HTTP2 steps.
An Azure Active Directory application with a secret is required for the login data.
Enter the data like this:
Caution
An Azure Active Directory registration must first be set up by the cloud administrators on the tenant.
The flow is running asynchronously in the default setup.
If the flow has to be executed synchronously, this could be the case if the files has to be processed directly in the code calling the flow. Then the default flow has to be extended with an response-element.
In the response-element (if existing) you can set up if the flow should be executed synchronously or asynchronously. Without a response-element the flow will be executed asynchronously.
tTsting the Flows
Once set up, the flows can be tested manually.
In the CFT Files files can be imported or exported manually and the flows can be started manually.
For this, the respective flow must already be set up in the CFT setup.
With the on-premise variant, the flows do not have to be tested, of course, because they do not exist here.
Implementation in Applications
Example code for implementation in processes. The implementation is the same for using flows or OnPremise for using direct file access.
Export
The CFT file must be created before the export and the file to be exported must be stored in it as a blob. Then the export can be started.
Before importing, the files must be imported and then they can be processed.
The files are imported asynchronously, which means they may not have been imported yet when they are run through as shown in the code example.
procedure ImportAllFilesFromImportPath(ImportPath: Text)
var
CFTSetup: Record "CFT Setup NVX";
FileInterfaceMgt: Codeunit CFTFileInterfaceMgtNVX;
begin
CFTSetup.Get();
FileInterfaceMgt.RunFileImport(CFTSetup, ImportPath);
CFTFile.Reset();
CFTFile.SetRange(Usage, Usage::MyUsage);
CFTFile.SetRange(HasValue, true);
if CFTFile.FindSet() then
repeat
ProcessImportedFile(CFTFile);
until CFTFile.Next() = 0;
end;
Docs / NVXCFT Cloud File Transfer / Tasks Export Process
Export Prozess
A graphical illustration how the export process works.
Docs / NVXCFT Cloud File Transfer / Tasks Import Process
Import Process
A graphical illustration how the import process works.
Docs / NVXCFT Cloud File Transfer / Appendix Release Notes
Would you like to know what has changed in the app?
Below you'll find an overview about new features and changes that has been done in the updates.
Build-Overview in DevOps
NVXCFT 1.1.7.0
as of Business Central 22 2023/10/19
Modifications
Adaptations for BC 23 compatibility.
NVXCFT 1.1.6.0
as of Business Central 18 2023/10/16
Improvements
Support for synchronous import and export flows. If the flow delivers a response and is set up not to be asynchronous, then the app can now work with that.
NVXCFT 1.1.5.0
as of Business Central 18 2023/06/21
Improvements
When automatically importing files, it is now possible to specify the usage.
NVXCFT 1.1.4.0
as of Business Central 18 2023/04/17
Corrections
When importing files with page CFT Import File (CFTImportFileNVX) the field Transfer Direction was not filled.
NVXCFT 1.1.3.0
as of Business Central 18 2023/05/01
Improvements
The table web service aggregate was used as normal table and not temporary.
NVXCFT 1.1.2.0
as of Business Central 18 2022/03/10
Improvements
When creating a new sandbox environment in the cloud all URLs will be deleted in the CFT Setup.
NVXCFT 1.1.1.0
as of Business Central 16
Corrections
The CFT Usage will now be used with names and no longer with captions. With this change the caption no longer has to be exactly the name.
NVXCFT Cloud File Transfer
At the export flow the username and password are set in the HTTP as well the HTTP2 steps.
An Azure Active Directory application with a secret is required for the login data.
Enter the data like this:
