Solved

how to copy a file from a local machine folder to an FTP folder

Posted on 2013-11-27
6
604 Views
Last Modified: 2013-11-27
I need to copy a text file from a local folder to an ftp folder.

I believe that the steps are:

Read the local file contents into a filestream.

Initiate an FTPWebRequest.

Use a  FTPWebRequest method to copy the filestream to the ftp folder.

Here are my source statements:

   strSourcePath = "C:\\Develop\\Apps\\StockPro\\Data\\Changes\\";
   string strSourceFileName = "Changes.txt";
   string strSourceFile = strSourcePath + strSourceFileName;

// Create a filestream object

     FileStream fs = new FileStream(strSourceFile, FileMode.Open, FileAccess.Read);
     StreamReader sr = new StreamReader(fs);

// Copy the contents of the file to the request stream.
            StreamReader sourceStream = new StreamReader("Changes.txt");
            byte [] fileContents = Encoding.UTF8.GetBytes(sourceStream.ReadToEnd());

// only one column is copied to the request stream.

//Use a  FTPWebRequest method to copy the filestream to the ftp folder.
0
Comment
Question by:Dovberman
  • 3
  • 3
6 Comments
 
LVL 18

Expert Comment

by:Jerry Miller
ID: 39681380
Here is a function that I use to upload files to a FTP server:

Public Shared Function UploadToFTP(ByVal fstream As Stream, ByVal fileName As String, ByVal folder As String) As Boolean
        Dim reqStream As Stream
        Dim ftpWebResponse As FtpWebResponse
        Dim nc As New System.Net.NetworkCredential(ID, Password)
        Dim cc As New System.Net.CredentialCache()
        Dim strFTPFilePath As String
        Dim n_month_name As String = DateTime.Now.ToString("MMMM")
        Dim n_month_num As String = DatePart("m", DateTime.Now).ToString()
        Dim n_year As String = DatePart("yyyy", DateTime.Now).ToString()
        Dim monthFolder As String
        Dim builder As New StringBuilder

        If Len(n_month_num) = 1 Then
            builder.Append("0")
        End If
        builder.Append(n_month_num)
        builder.Append("_")
        builder.Append(n_month_name)
        monthFolder = builder.ToString()

        Try
            folder = folder & "/" & n_year & "/" & monthFolder

            'Create a FTP Request Object and Specfiy a Complete Path
            strFTPFilePath = "ftp://" & ServerName & "/" & folder & "/" & fileName

            Dim reqObj As FtpWebRequest = DirectCast(FtpWebRequest.Create(New Uri(strFTPFilePath)), FtpWebRequest)

            reqObj.Method = WebRequestMethods.Ftp.UploadFile
            'reqObj.EnableSsl = True

            'To access Resourse Protected,give UserName and PWD
            reqObj.Credentials = nc
            reqObj.UseBinary = True

            Dim buffer As Byte() = New Byte(fstream.Length - 1) {}
            fstream.Read(buffer, 0, buffer.Length)
            'Removed Close because the with the stream closed, it would not add data to the db
            'fstream.Close()

            'Upload file
            reqStream = reqObj.GetRequestStream()
            reqStream.Write(buffer, 0, buffer.Length)
            reqStream.Close()

            ftpWebResponse = reqObj.GetResponse()
            ftpWebResponse.Close()
            Return True

        Catch Ex As Exception
            commonFunctions.insertLogEvents(LOG_EVENT_ERROR, Ex.Message)
            Return False
        End Try

    End Function

Open in new window

0
 
LVL 18

Accepted Solution

by:
Jerry Miller earned 500 total points
ID: 39681391
I converted it to C3 using this site. http://www.developerfusion.com/tools/convert/vb-to-csharp/

public static bool UploadToFTP(Stream fstream, string fileName, string folder)
{
	Stream reqStream = default(Stream);
	FtpWebResponse ftpWebResponse = default(FtpWebResponse);
	System.Net.NetworkCredential nc = new System.Net.NetworkCredential(ID, Password);
	System.Net.CredentialCache cc = new System.Net.CredentialCache();
	string strFTPFilePath = null;
	string n_month_name = DateTime.Now.ToString("MMMM");
	string n_month_num = DateAndTime.DatePart("m", DateTime.Now).ToString();
	string n_year = DateAndTime.DatePart("yyyy", DateTime.Now).ToString();
	string monthFolder = null;
	StringBuilder builder = new StringBuilder();

	if (Strings.Len(n_month_num) == 1) {
		builder.Append("0");
	}
	builder.Append(n_month_num);
	builder.Append("_");
	builder.Append(n_month_name);
	monthFolder = builder.ToString();

	try {
		folder = folder + "/" + n_year + "/" + monthFolder;

		//Create a FTP Request Object and Specfiy a Complete Path
		strFTPFilePath = "ftp://" + ServerName + "/" + folder + "/" + fileName;

		FtpWebRequest reqObj = (FtpWebRequest)FtpWebRequest.Create(new Uri(strFTPFilePath));

		reqObj.Method = WebRequestMethods.Ftp.UploadFile;
		//reqObj.EnableSsl = True

		//To access Resourse Protected,give UserName and PWD
		reqObj.Credentials = nc;
		reqObj.UseBinary = true;

		byte[] buffer = new byte[fstream.Length];
		fstream.Read(buffer, 0, buffer.Length);
		//Removed Close because the with the stream closed, it would not add data to the db
		//fstream.Close()

		//Upload file
		reqStream = reqObj.GetRequestStream();
		reqStream.Write(buffer, 0, buffer.Length);
		reqStream.Close();

		ftpWebResponse = reqObj.GetResponse();
		ftpWebResponse.Close();
		return true;

	} catch (Exception Ex) {
		commonFunctions.insertLogEvents(LOG_EVENT_ERROR, Ex.Message);
		return false;
	}

}

Open in new window

0
 

Author Comment

by:Dovberman
ID: 39681602
I understand the principle, but have a few clarification questions:

// initialize parameters

string strSourcePath = "C:\\Develop\\Apps\\StockPro\\Data\\Changes\\";
string strSourceFile = strSourcePath + "Changes.txt";

string strSourceFileName = "Changes.txt";

        //Structure of the Changes//Changes.txt file
    //Date                  OldExchange        OldSymbol      NewExchange      NewSymbol
    //20131126      OTCBB          BRVM                       OTCBB                        ZENO
    //20131126      OTCBB          CCRY                      OTCBB                        ARTR

//Create filestream
 
FileStream fs = new FileStream(strSourceFile, FileMode.Open, FileAccess.Read);
StreamReader sr = new StreamReader(fs);

// ?? How do I create the filestream from the Changes.txt file?

// Copy the file to the ftp folder

Boolean blnResponse = CopyFTPFile(fs,strSourceFileName,strSourcePath);
0
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 

Author Comment

by:Dovberman
ID: 39681692
I got it to work by making sure that the parameters were correctly structured.

Thanks,
0
 

Author Closing Comment

by:Dovberman
ID: 39681697
I got it to work by making sure that the parameters were correctly structured.

Thanks,
0
 
LVL 18

Expert Comment

by:Jerry Miller
ID: 39681722
Happy that it worked for you!
0

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

One of a set of tools we're offering as a way to say thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Just a quick little trick I learned recently.  Now that I'm using jQuery with abandon in my asp.net applications, I have grown tired of the following syntax:      (CODE) I suppose it just offends my sense of decency to put inline VBScript on a…
A long time ago (May 2011), I have written an article showing you how to create a DLL using Visual Studio 2005 to be hosted in SQL Server 2005. That was valid at that time and it is still valid if you are still using these versions. You can still re…
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

837 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question