One of my projects involves a complex financial database (stored in Access). I wanted to add a feature to the client EXE that allowed testers to FTP their current copy of the database to me so that I could try to reproduce problems without having to reenter all the data. I didn’t see an FTP control handy in VS2003, and I didn’t feel like messing around with Windows built-in FTP command line program, which doesn’t support passive mode & is annoying to pass parameters to.
So I found NcFTP, a free command line FTP program that fit the bill. Specifically, it offers a dedicated “uploader” program called NcFTPPut. Now, the codebehind for my “Upload Database” button looks like this
Private Sub UploadDatabase()
If MessageBox.Show(“Upload current database for testing? You must be connected to the internet.”, _
“Confirm Upload”, MessageBoxButtons.YesNo) = DialogResult.Yes Then
‘ make temporary copy of database
Dim currentDB As String = AppConfig.GetDBFileName
Dim tmpDBName As String = currentDB.Replace(“.mdb”, “-” & _
System.DateTime.Now.ToString(“M-d-yyyy-h-m”) & “.mdb”)
System.IO.File.Copy(currentDB, tmpDBName, True)
‘ upload using NcFTPPut
Dim exe As String = System.IO.Path.GetDirectoryName(Application.ExecutablePath) & _
“\ncftpput.exe”
Dim params As String = “-u MyFTPUserName -p FTPPassword ftp.developmentnow.com . “”" & tmpDBName & “”"”
Try
Dim myProcess As Process = System.Diagnostics.Process.Start(exe, params)
myProcess.WaitForExit()
Catch ex As Exception
MessageBox.Show(ex.Message, “Error”, MessageBoxButtons.OK, MessageBoxIcon.Error)
Finally
‘ delete temp copy
System.IO.File.Delete(tmpDBName)
End Try
End If
End Sub
It’s simple, but it works. Now whenever testers find problems with the program, they can just click the “Upload Database” button in my app to send me the data I need to reproduce the problem.