Skip to main content

Ruby and C# code to upload a file to a server that uses FrontPage extensions

I ran into a challenge last week. I had to write a script or program that creates an RSS file and upload it to a IIS server. The program would be be scheduled to run every so often. The IIS server did not supported DAV, but it supported Front Page Extensions 2002. I looked everywhere in the web for sample code on how to upload files to such servers. I found out that MS Internet Publishing is the technology used by Front Page Extensions. I also found out that there was an OLE provider for it and that I could connect to it using classic ADO 2.5. I tried the example provided in Microsoft site, but the code crashed when the ADODB.Stream object opened the stream from the record. The error said something about “Interface not supported” and “InvalidCast”.

My old ASP 3.0 book has a sample of writing directly to the ADODB.Stream, so I tried that and it worked but it kept prompting a dialog asking for the username and password even though I had passed those in the Stream’s open method. To solve the dialog problem, I connected using the ADODB.record (passing the username and password to its open method) and then opening the stream straight from the url. The following are two working sample codes that will upload a file to a server that supports Front Page extensions:

[Both samples are released under the MIT license]

Ruby code:

require 'win32ole'

#Reads the contents of a local file and writes its
# contents into a remote file pointed by remote_url.
# The remote file must be hosted on a server that suppots
# FrontPage Extensions. This methos uses the MS Internet
# Publishing OLE DB provider through ADO.
# Please note that remote_url will be overwritten, DO
# NOT point remote_url to a folder.
def upload_file(local_file_path, remote_url,
 username, password)
 #the connection must be established first by using
 # ADODB.Record
 grec = WIN32OLE.new('ADODB.Record')
 grec.Open("",
 "URL=#{remote_url}" , 3, 67108864, 16384,
 username,
 password)
 
 #Get the contents from the file
 contents = File.open(local_file_path, "r").read
 
 #Write the contents into the remote file
 objStream = WIN32OLE.new('ADODB.Stream')
 objStream.Open("URL=#{remote_url}", 3,
               -1, username,
               password)
 objStream.Type = 2
 objStream.Position = 0
 objStream.SetEOS()
 #Very important to set when writing rss or xml
 # files with encoding attribute set to UTF-8
   objStream.Charset = "ascii"
 objStream.WriteText(contents, 0)
   
 #close connections
 objStream.close()
 grec.Close()
         
end
 Sample call:

upload_file("folder_in_your_computer/news.xml", 
 "http://server.com/news/news.xml" , "myusername", "paswwrd")

C# code (you must add the ADO 2.5 COM reference to your project, I also did not include the code to get the text from a file, I leave that as an exercise to the reader ;) ) :

static void UploadFile(string url, string username,
           string password)
       {
           //You must connect first to the record to supply
           // the username and password, otherwise it will
           // prompt a login dialog when calling Stream's Open
           ADODB.Record grec = new ADODB.Record();
           grec.Open("",
      url, ADODB.ConnectModeEnum.adModeReadWrite,
      ADODB.RecordCreateOptionsEnum.adCreateOverwrite,
      ADODB.RecordOpenOptionsEnum.adDelayFetchStream,
      username,
      password);

           //Use ADODB.Stream to write the contents of the remote
           // file
           ADODB.Stream objStream = new ADODB.Stream();
           objStream.Open(url, ADODB.ConnectModeEnum.adModeReadWrite,
               ADODB.StreamOpenOptionsEnum.adOpenStreamUnspecified,
               username,
               password);
           objStream.Type = ADODB.StreamTypeEnum.adTypeText;
           objStream.Position = 0;
           objStream.SetEOS();
           objStream.Charset = "ascii";
           objStream.WriteText("I just changed it from c#",
               ADODB.StreamWriteEnum.adWriteLine);


           //close connections
           objStream.Close();
           grec.Close();

       }

Comments

Popular posts from this blog

Mail labels and letter templates for jasperreports

The following are free (MIT license) mailing labels and letter templates for jasperreports that you can download and use in jasperserver and/or ireport: Update 3/15/2011 : I moved the Mail templates zip file here . Please consider making a small donation if the templates are of help to you, Thank you! If you need more information on how to use those templates please leave a comment in the blog.

How to create online multiplayer HTML5 games in Contruct2

  Construct2 can use websockets to send and receive messages between games. By using socket-io , we can use a Node.js script as the server and my modification to the socket-io plugin for Construct2 to allow the games to synchronize data between them in real-time. There are two parts to this design: the Node.js server and the Construct2 clients (the games playing). The main part of building an online multiplayer HTML5 game is to plan: how the clients will communicate how often and what to communicate how much of the logic will go into the server and how much to the client. In my sample game, I chose to have each client own a player and have the server just relay messages: Use string messages in the form TypeOfMessage, Parameter1, Paremeter2, Parater3, etc to communicate. Have the clients send their player position about 16 times a second. Whenever their player shoots, the client needs to send a message immediately. Almost all of the game logic will...

Send Email from C# using Outlook's COM late binding

The following sample code shows how to send emails from Outlook and Exchange using C#. This code works with any version of Outlook because it uses Late Binding to automate Outlook. Parts of the code where taken from other websites. using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Reflection; using System.Threading; namespace LateBindingTest { class OutlookEmailerLateBinding { private object oApp; private object oNameSpace; private object oOutboxFolder; public OutlookEmailerLateBinding() { Type outlook_app_type; object[] parameter = new object[1]; //Get the excel object outlook_app_type = Type.GetTypeFromProgID("Outlook.Application"); //Create instance of excel oApp = Activator.CreateInstance(outlook_app_type); //Set the parameter which u want to set parameter[0] = "MAPI...