Send local files to SFTP Server

Has anyone been able to send file(s) to SFTP Server from Mongoose using scripting?

I have been trying several way, but I got stuck on always getting a FALSE response and nothing gets transferred regardless what I do.

Source Code (cleaned up to not show any company relevant information) - I have highlighted to problem code:

public void sendFTP() {

string filterIDO = "";
string errorMsg = "Something went wrong!";
string fileName = "";
string currDateTime = DateTime.Now.AddDays(-10).ToString("yyyy/MM/dd hh:mm tt");

filterIDO = "CreatedDate >= '" + currDateTime + "'"; //Request created within the last 10 days

fileName = "D:\Myfiles\export_file.csv";

ThisForm.CurrentIDOCollection = ThisForm.PrimaryIDOCollection;
ThisForm.CurrentIDOCollection.Filter = filterIDO;
ThisForm.CurrentIDOCollection.Refresh();
ThisForm.Components["grid_Data"].IDOCollection.ExportCollection(false, fileName, false); //Exports the IDO Data to a local File - This works fine!!

//Send File to FTP instance
if(Application.FileServer.ImportToFileSeverFromLocal(fileName, "export_file.csv", "SFTP_FileServer", "LogicalFolder", out errorMsg, null)) {

Application.ShowMessage("Success");
} else {

Application.ShowMessage("Failed"); //I am ALWAYS ending up here for some reason!?
}

}

Appreciate any insight and/or suggestions anyone might have, since I want to make this process MT Cloud compliant for our upcoming Cloud Migration.

/RB

Find more posts tagged with

Accepted answers

All comments

Kevin Heiman

Offering an alternate for consideration. Have ION deliver the data to consumers such as sFTP.

Mongoose calls the ION IMS API and post the file to the IMS API.

ION then routes it to the endpoint desired. As well as other ION capability can be leveraged.

Rene Bottern

Sounds interesting, I'll see what information I can find about this approach, thanks.

Kevin Heiman

Feel free to ask for guidance, I am unsure to your Infor OS / ION skills. We have used this in customers and 3P scenarios. Mongoose supports the API and authentication internally (in MT).

Link into the IMS overview:

https://docs.infor.com/ion/2021-x/en-us/ioncedg/default.html?helpcontent=mhn1519993806956.html

A deeper link on one way IMS from APP to ION.

https://docs.infor.com/ion/2021-x/en-us/ioncedg/default.html?helpcontent=ooo1519994008158.html

deep link to the sFTP section

https://docs.infor.com/ion/2021-x/en-us/iondeskceug/default.html?helpcontent=ako1450695969970.html

kazuyuki-mochizuki

Maybe you can try using the File Maintenance form in syteline and upload a file manually just to see if the file servers and logical folder is setup correctly?

Rene Bottern

Unfortunately I need this automated, and also we are actually running M3, but we are using Mongoose as well for both Development of additional applications as well as Factory Track.

Not sure what's wrong with my parameters, but I would assume the standard Mongoose functions should work, why else have them? (i.e. Application.FileServer.ImportToFileSeverFromLocal...)

kazuyuki-mochizuki

I just thought that maybe it could be the setup for file server/logical folder or user permissions is the issue and not the code. we can use the file maintenance form if available just to see if you can upload files manually.

Rene Bottern

Thanks, but my connection is verifying just fine, and I can manually load the files to the SFTP folder.
Just not sure what's wrong with the Mongoose code.
I might try some standard .Net options instead to solve this.

Copyright © 2025 Infor. All rights reserved.