--- a/MPIWGRoot.py	Thu Feb 14 20:38:30 2013 +0100
+++ b/MPIWGRoot.py	Fri Feb 15 20:51:34 2013 +0100
@@ -278,6 +278,16 @@
         # return pure list of objects
         return [f[1] for f in features]
 
+    def getDepartments(self):
+        """returns a list of the Departments"""
+        dir = getattr(self, 'departments', None)
+        if dir is None:
+            return []
+        
+        depts = dir.objectItems(['MPIWGDepartment'])
+        depts.sort(sortWeight)
+        # return pure list of objects
+        return [f[1] for f in depts]
 
     def getMPIWGRoot(self):
         """returns the MPIWG root"""
@@ -287,15 +297,6 @@
         """returns the URL to the root"""
         return self.absolute_url()
         
-    def upDateSQL(self,fileName):
-        """updates SQL databases using fm.jar"""
-        fmJarPath=os.path.join(package_home(globals()), 'updateSQL/fm.jar')
-        xmlPath=os.path.join(package_home(globals()), "updateSQL/%s"%fileName)
-        logger("MPIWG Web",logging.INFO,"java -classpath %s -Djava.awt.headless=true Convert %s"%(fmJarPath,xmlPath))
-        ret=os.popen("java -classpath %s -Djava.awt.headless=true Convert %s"%(fmJarPath,xmlPath),"r").read()
-        logger("MPIWG Web",logging.INFO,"result convert: %s"%ret)
-        return 1
-    
     def patchProjects(self,RESPONSE):
         """patch"""
         projects=self.ZopeFind(self.projects,obj_metatypes=['MPIWGProject'])