Finance | Project Operations, Human Resources, ...

how to download only specific file from ftp server

(0) Share

Report

Posted on by Community Member

i am downloading file from ftp server to local folder and after that i am reading those file from the folder to ax table

the problem is i want to filter some file on the basis of file extension while downloading

i am using the code to download file from ftp server.

private void ftpDownloadAllFiles()
{
str fileNameType;

FilePath filePathDest;
;
saveToFilePath= local file path;
fileNameType=".R102";
ftpHostName= "ftp path";
// info("weqd");
this.getFTPDirFilesList();
//info("weq1");
ftpFilesListEnum = ftpFilesList.getEnumerator();
ftpFilesListEnum.reset();

while (ftpFilesListEnum.moveNext())
{
fileNameType = ftpFilesListEnum.current();
//info("weq");
// Marshaling .NET to X++
ftpObject = System.Net.WebRequest::Create(ftpHostName + @"/" + fileNameType);
ftpWebRequest = ftpObject;

if (ftpWebRequest)
{
ftpWebRequest.set_KeepAlive(false);
ftpWebRequest.set_UsePassive(true);
ftpWebRequest.set_UseBinary(true);
//ftpWebRequest.set_Timeout(ftpTimeOut);
ftpWebRequest.set_Method(#DownloadFile);
//ftpWebRequest.set_ReadWriteTimeout(ftpTimeOut);
this.setFTPCredentials();

ftpWebResponse = ftpWebRequest.GetResponse();
//info("weqq4");
// BP Deviation Documented
ioStreamReader = new System.IO.StreamReader(ftpWebResponse.GetResponseStream());

if (ioStreamReader)
{
strReadLine = ioStreamReader.ReadToEnd();

if (strReadLine)
{
filePathDest = saveToFilePath + @"\" + fileNameType;
this.writeFile(filePathDest);

info(strfmt("Downloaded file %1 to %2", fileNameType, saveToFilePath));
}

ioStreamReader.Close();
}
}
}
}

I have the same question (0)

All responses (7)

Answers (0)

ergun sahin 8,826 Moderator on at

Like (0)

Report

I don't fully understand, is the code above working? what's inside the fileNameType object (in loop).

Was this reply helpful? Yes No
Martin Dráb 237,807 Most Valuable Professional on at

Like (0)

Report
Please always use Insert > Insert Code (in the rich-formatting view) to paste source code. It preserves line indentation, which makes code much easier to read:

private void ftpDownloadAllFiles() { str fileNameType; FilePath filePathDest; ; saveToFilePath= local file path; fileNameType=".R102"; ftpHostName= "ftp path"; this.getFTPDirFilesList(); ftpFilesListEnum = ftpFilesList.getEnumerator(); ftpFilesListEnum.reset(); while (ftpFilesListEnum.moveNext()) { fileNameType = ftpFilesListEnum.current(); //info("weq"); // Marshaling .NET to X ftpObject = System.Net.WebRequest::Create(ftpHostName @"/" fileNameType); ftpWebRequest = ftpObject; if (ftpWebRequest) { ftpWebRequest.set_KeepAlive(false); ftpWebRequest.set_UsePassive(true); ftpWebRequest.set_UseBinary(true); ftpWebRequest.set_Method(#DownloadFile); this.setFTPCredentials(); ftpWebResponse = ftpWebRequest.GetResponse(); // BP Deviation Documented ioStreamReader = new System.IO.StreamReader(ftpWebResponse.GetResponseStream()); if (ioStreamReader) { strReadLine = ioStreamReader.ReadToEnd(); if (strReadLine) { filePathDest = saveToFilePath @"\" fileNameType; this.writeFile(filePathDest); info(strfmt("Downloaded file %1 to %2", fileNameType, saveToFilePath)); } ioStreamReader.Close(); } } } }

Nevertheless your description suggests that you want to change the logic of getFTPDirFilesList(), not the method you've shown above.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
private void getFTPDirFilesList() { container conFTPFilesDownload; ListIterator ftpFilesListIterator; ftpHostName="ftppath"; ftpObject = System.Net.WebRequest::Create(new System.Uri(ftpHostName)); ftpWebRequest = ftpObject; if (ftpWebRequest) { ftpWebRequest.set_KeepAlive(true); ftpWebRequest.set_UsePassive(true); ftpWebRequest.set_UseBinary(true); ftpWebRequest.set_Method(#ListDirectory); this.setFTPCredentials(); try { ftpWebResponse = ftpWebRequest.GetResponse(); } catch (Exception::CLRError) { throw error(AifUtil::getClrErrorMessage()); } if (ftpWebResponse) { ftpFilesList = new list(Types::String); // BP Deviation Documented ioStreamReader = new System.IO.StreamReader(ftpWebResponse.GetResponseStream()); if (ioStreamReader) { strReadLine = ioStreamReader.ReadLine(); while (!System.String::IsNullOrEmpty(strReadLine)) { ftpFilesListIterator = new Listiterator(strsplit(strReadLine, '/')); while (ftpFilesListIterator.more()) { conFTPFilesDownload = ftpFilesListIterator.value(); ftpFilesListIterator.next(); } ftpFilesList.addEnd(conPeek(conFTPFilesDownload, conlen(conFTPFilesDownload))); strReadLine = ioStreamReader.ReadLine(); } ioStreamReader.Close(); } if (ftpFilesList.empty()) { warning (strfmt("No files available in %1", ftpHostName)); } } } }

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,807 Most Valuable Professional on at

Like (0)

Report

Unfortunately your code indentation is still weird in getFTPDirFilesList(). Could you fix it by yourself this time, please? Please pay more attention to it - if you make it difficult for us to help you, you decrease your chances to get an answer.

Regarding your code, it seems to me that all you need to do is adding a condition for adding file names to getFTPDirFilesList. You will skip the file if its extension isn't .R001.

You can utilize fileNameSplit() method, for example, to get the file extension.

Was this reply helpful? Yes No
Suggested answer

Martin Dráb 237,807 Most Valuable Professional on at

Like (0)

Report

[deleted]

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I am using code available at this url

ax.com/.../

can you suggest me code or changes by which i can get the correct result.

i had tried to filter the file with several changes, didn't got any result

Was this reply helpful? Yes No
Martin Dráb 237,807 Most Valuable Professional on at

Like (0)

Report
I mean using the "if' statement to add the file name to the list only if it meets certain conditions.

Instead of this:

ftpFilesList.addEnd(...); // Add every single file

you would do this:

if (fileExtension == requiredFileExtension) { ftpFilesList.addEnd(...); // Add only selected file names }

And as I mentioned, you can use fileNameSplit() to get the file extension from a file name.

Was this reply helpful? Yes No