# HG changeset patch # User dwinter # Date 1377760201 -7200 # Node ID c0dcb747cc41270221ae9f1c86e5fb85f0e89da3 # Parent f7d8d12b203bde058b7906dd9105b0472fb1b6b8 handle problem of MPIWG: keys, MPIWG: in the keys is now removed. diff -r f7d8d12b203b -r c0dcb747cc41 MPIWGRoot.py --- a/MPIWGRoot.py Wed Aug 07 12:03:58 2013 +0200 +++ b/MPIWGRoot.py Thu Aug 29 09:10:01 2013 +0200 @@ -296,7 +296,7 @@ #create the new entry in the database - result,msg=self.members.createNewDBEntry(data['publish_the_data'],data['key'],data['last_name'], + result,msg=self.members.createNewDBEntry(data['publish_the_data'],data['key'].replace("MPIWG:",""),data['last_name'], data['first_name'],data['titles_new'],data['status'],"", "",data['date_from'],data['date_to'], data['department'],'',data['funded_by'], @@ -335,9 +335,13 @@ member.changeData(data) + + def updatePersonalwww_doIt(self): """do the update""" args=self.REQUEST.form + + resultSet=self.REQUEST.SESSION['personal_www']['resultSet'] news=self.REQUEST.SESSION['personal_www']['news'] conflicts=self.REQUEST.SESSION['personal_www']['conflicts'] @@ -419,9 +423,15 @@ """ dsn=self.getConnectionObj().connection_string #dsn="dbname=personalwww" - resultSet=updatePersonalWWW.importFMPXML(uploadfile) + resultSetTmp=updatePersonalWWW.importFMPXML(uploadfile) + + + resultSet={} + for key in resultSetTmp.keys(): + resultSet[key.replace("MPIWG:","")]=resultSetTmp[key]; + news,conflicts=updatePersonalWWW.checkImport(dsn, resultSet) - + self.REQUEST.SESSION['personal_www'] = {'resultSet': resultSet, 'news': news, 'conflicts': conflicts} pt=PageTemplateFile(os.path.join(package_home(globals()),'zpt','updatePersonalwww_check.zpt')).__of__(self) diff -r f7d8d12b203b -r c0dcb747cc41 updatePersonalWWW.py --- a/updatePersonalWWW.py Wed Aug 07 12:03:58 2013 +0200 +++ b/updatePersonalWWW.py Thu Aug 29 09:10:01 2013 +0200 @@ -12,7 +12,8 @@ # list of fields that are taken from XML and checked against DB as conflicts #checkFields=['key','first_name','last_name','title','home_inst','current_work','e_mail2'] -checkFields=['key','first_name','last_name','title','titles_new','home_inst','current_work'] +#checkFields=['key','first_name','last_name','title','titles_new','home_inst','current_work'] +checkFields=['first_name','last_name','title','titles_new','home_inst','current_work'] def sql_quote(v): @@ -250,6 +251,7 @@ def checkImport(dsn,resultSet): #now connect to the database + #remove the MPIWG: in all keys logging.info("dsn: %s"%dsn) dbCon = psycopg.connect(dsn) db = dbCon.cursor()