Finance | Project Operations, Human Resources, ...

I want to read multiple comma delimiter file from ftp server and insert data into ax regular table

(0) Share

Report

Posted on by Dynamics AX

I want to read multiple comma delimiter file from ftp server and insert data into ax regular table

i am trying this but i did not got any result.

please provide the X++ code for the same

I have the same question (0)

All responses (9)

Answers (0)

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

Like (1)

Report
Decompose the problem to individual pieces:

Getting a file from FTP

Reading a CSV file

Inserting data to a table

Then think about what you know how to do and what you don't. For example, maybe you know how to insert data, but you don't know how to work with FTP.

When you understand what actually need, you can use a search engine to find documentation, blog posts and forums threads on the right topic. If you don't find what you need, create a new thread (with an approriate name and tags) and explain your particular problem.

Was this reply helpful? Yes No
Dynamics AX 20 on at

Like (0)

Report

Yes

1. i am not able get file from ftp folder.

please provide the X++ code for the same

Was this reply helpful? Yes No
Blue Wang on at

Like (1)

Report

Hi M.G.Harran，

Maybe these are helpful to you:

daxbalakumaran.wordpress.com/.../

www.atomicax.com/.../downloading-files-ftp-and-doing-something-them-d365fo

Was this reply helpful? Yes No
Dynamics AX 20 on at

Like (0)

Report

i tried using this daxbalakumaran.wordpress.com/.../

still having issue.

i am not getting any response from ftp server

Was this reply helpful? Yes No
Dynamics AX 20 on at

Like (0)

Report

how i will run this code in ax 2012

www.atomicax.com/.../downloading-files-ftp-and-doing-something-them-d365fo

Was this reply helpful? Yes No
Dynamics AX 20 on at

Like (0)

Report

i tried

still didn't got response from ftp server.

Was this reply helpful? Yes No
Suggested answer

nmaenpaa 101,160 Moderator on at

Like (0)

Report

Can you access the FTP server from the location where AX runs? You can try to access it via a web browser. Perhaps some firewall is blocking the access.

In general, may I suggest that you share as much details about your situation as possible? This would help us to help you figure out what the problem could be, and hopefully solve the problem. The quality of the help that you will get is strongly linked to the quality of information that you share.

Was this reply helpful? Yes No
Dynamics AX 20 on at

Like (0)

Report

Yes i am able to access the ftp server from the location where Ax is running

code

//in the code i am not getting response, refer the comment.

private void getFTPDirFilesList()

{

container conFTPFilesDownload;

ListIterator ftpFilesListIterator;

// Marshaling .NET to X++

ftpObject = System.Net.WebRequest::Create(ftpHostName);

ftpWebRequest = ftpObject;

if (ftpWebRequest)

{

ftpWebRequest.set_KeepAlive(false);

ftpWebRequest.set_UsePassive(true);

ftpWebRequest.set_UseBinary(true);

ftpWebRequest.set_Timeout(ftpTimeOut);

ftpWebRequest.set_Method(#ListDirectory);

this.setFTPCredentials();

ftpWebResponse = ftpWebRequest.GetResponse();

//-------------code is not running after this line.----------------------------------//

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(&amp;quot;No files available in %1&amp;quot;, ftpHostName));

}

}

}

}

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

Like (0)

Report
It sounds like GetResponse throws an exception, but you're not aware of it, because you forget to catch it. And you can't fix the problem without finding out what it is.

Do the following; it should show the message from the exception (unless yoi call the code inside a transaction).

try { ftpWebResponse = ftpWebRequest.GetResponse(); } catch (Exception::CLRError) { throw error(AifUtil::getClrErrorMessage()); }

By the way, please always use Insert > Insert Code (in the rich-formatting view). Unlike your code above, it preserves indentation, making code much easier to read.

Was this reply helpful? Yes No

Join the conversation

Community site session details

I want to read multiple comma delimiter file from ftp server and insert data into ax regular table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates

Community site session details

I want to read multiple comma delimiter file from ftp server and insert data into ax regular table

Helpful resources

Quick Links

Responsible AI policies

Neeraj Kumar – Community Spotlight

Congratulations to the November Top 10 Community Leaders!

Subscribe to this forum!

Select categories

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

Featured topics

Product updates