diff --git a/html/process_update_sites.php b/html/process_update_sites.php
new file mode 100644
index 0000000..eace29c
--- /dev/null
+++ b/html/process_update_sites.php
@@ -0,0 +1,136 @@
+<?php
+/*******************************************************************************
+ * Copyright (c) 2010 Eclipse Foundation and others.
+ * All rights reserved. This program and the accompanying materials
+ * are made available under the terms of the Eclipse Public License v1.0
+ * which accompanies this distribution, and is available at
+ * http://www.eclipse.org/legal/epl-v10.html
+ *
+ * Contributors:
+ *    Kit Lo (IBM) - Initial API and implementation
+ *    Kit Lo (IBM) - Bug 299402, Extract properties files from Eclipse project update sites for translation
+*******************************************************************************/
+/*
+ * Extract properties files from update sites 
+ */
+# To-do: hard-coding the Eclipse, BIRT, & Webtools update sites for now; need to create an UI for project committers to enter their update sites
+$eclipse = array("/home/data/httpd/download.eclipse.org/eclipse/updates/3.6milestones/S-3.6M4-200912101301", "eclipse", "3.6");
+$birt = array("/home/data/httpd/download.eclipse.org/birt/update-site/2.6-interim", "birt", "2.6.0");
+$webtools = array("/home/data/httpd/download.eclipse.org/webtools/updates", "webtools", "3.2");
+
+# BIRT 2.6.0 & Webtools 3.2 are not defined yet, cannot test on staging server
+#$update_sites = array($eclipse, $birt, $webtools);
+$update_sites = array($eclipse);
+
+$temp_dir = "/tmp/tmp-babel/";
+$debug = TRUE;
+
+header("Content-type: text/plain");
+include("global.php");
+InitPage("");
+
+$headless = 0;
+if (!isset($User)) {
+  echo "User not defined - running headless\n";
+  $User = getGenieUser();
+  $headless = 1;
+}
+
+require(dirname(__FILE__) . "/../classes/file/file.class.php");
+global $dbh;
+
+if (is_dir($temp_dir)) {
+  exec("rm -rf $temp_dir");
+}
+mkdir($temp_dir) || die("***ERROR: Cannot create working directory $temp_dir\n");
+
+$files = array();
+$sql = "SELECT * FROM files WHERE is_active = 1";
+$rs_files = mysql_query($sql, $dbh);
+while ($myrow_files = mysql_fetch_assoc($rs_files)) {
+  $file = new File();
+  $file->project_id = $myrow_files['project_id'];
+  $file->version = $myrow_files['version'];
+  $file->name = $myrow_files['name'];
+  $file->plugin_id = $myrow_files['plugin_id'];
+  $file->file_id = $myrow_files['file_id'];
+  $files[$file->file_id] = $file;
+}
+
+foreach ($update_sites as $update_site) {
+  $plugins_dir = $update_site[0] . "/plugins/";
+  $project_id = $update_site[1];
+  $version = $update_site[2];
+
+  chdir($plugins_dir);
+  foreach (glob("*.jar") as $jar_name) {
+    # Sample jar name: org.eclipse.ui.workbench_3.6.0.I20100105-1530.jar
+    #
+    # Remove plugin version from jar name:
+    # org.eclipse.ui.workbench_3.6.0.I20100105-1530.jar => org.eclipse.ui.workbench
+    $temp_str = $jar_name;
+    $temp_str = substr($temp_str, 0, strrpos($temp_str, "."));
+    $temp_str = substr($temp_str, 0, strrpos($temp_str, "."));
+    $temp_str = substr($temp_str, 0, strrpos($temp_str, "_"));
+    $plugin_id = $temp_str;
+
+    mkdir($temp_dir . $project_id);
+    mkdir($temp_dir . $project_id . "/" . $version);
+    mkdir($temp_dir . $project_id . "/" . $version . "/" . $plugin_id);
+    chdir($temp_dir . $project_id . "/" . $version . "/" . $plugin_id);
+    exec("unzip -o -q " . $plugins_dir . $jar_name . " *.properties");
+  }
+
+  $properties_file_names = array();
+  chdir($temp_dir . $project_id . "/" . $version);
+  exec("find . -name *.properties", $properties_file_names);
+  sort($properties_file_names);
+
+  echo "Start processing properties files in project $project_id version $version...\n";
+  foreach ($properties_file_names as $properties_file_name) {
+    $properties_file_name = substr($properties_file_name, 2);
+    $plugin_id = substr($properties_file_name, 0, strpos($properties_file_name, "/"));
+	$file_id = File::getFileID($properties_file_name, $project_id, $version);
+						
+    if ($files[$file_id] != null) {
+      $file = $files[$file_id];
+      $file->is_active = 1;
+      unset($files[$file_id]);
+    } else {
+      $file = new File();
+      $file->project_id = $project_id;
+      $file->version = $version;
+      $file->name = $properties_file_name;
+      $file->plugin_id = $plugin_id;
+      $file->is_active = 1;
+    }
+    if (!$file->save()) {
+      echo "***ERROR: Cannot save file $file->name\n";
+    } else {
+      $file_name = $temp_dir . $project_id . "/" . $version . "/" . $properties_file_name;
+      $file->parseProperties(file_get_contents($file_name));
+      if ($debug) {
+        echo "  " . $file->name . "\n";
+      }
+    }
+ }
+  echo "Done processing " . sizeof($properties_file_names) . " properties files in project $project_id version $version\n\n";
+}
+
+# Deactivate the rest of the files
+foreach ($files as $file) {
+  $file->is_active = 0;
+  if (!$file->save()) {
+    echo "***ERROR: Cannot deactivate file $file->name\n";
+  }
+  if ($debug) {
+    echo "  " . $file->name . "\n";
+  }
+}
+
+if ($headless) {
+  $User = null;
+}
+
+echo "Done\n";
+?>