Solved

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

Posted on 2013-11-27
6
595 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
Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

 

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

Maximize Your Threat Intelligence Reporting

Reporting is one of the most important and least talked about aspects of a world-class threat intelligence program. Here’s how to do it right.

Join & Write a Comment

Suggested Solutions

For a while now I'v been searching for a circular progress control, much like the one you get when first starting your Silverlight application. I found a couple that were written in WPF and there were a few written in Silverlight, but all appeared o…
User art_snob (http://www.experts-exchange.com/M_6114203.html) encountered strange behavior of Android Web browser on his Mobile Web site. It took a while to find the true cause. It happens so, that the Android Web browser (at least up to OS ver. 2.…
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…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

708 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now