from psdi.util.logging import MXLogger from psdi.util.logging import MXLoggerFactory from psdi.mbo import MboConstants from psdi.mbo import SqlFormat from psdi.server import MXServer print "CLEANUPWORKORDER - START" #Log for debugging logger = MXLoggerFactory.getLogger("maximo.script") logger.debug("ScriptName" + launchPoint) #PMCHGIAASSESMENT pmchgiaassesmentSet = mbo.getMboSet("PMCHGIAASSESMENT") if (not pmchgiaassesmentSet.isEmpty()): wonum = mbo.getString("WONUM") mxServer = MXServer.getMXServer() conKey = mxServer.getSystemUserInfo().getConnectionKey() con = mxServer.getDBManager().getConnection(conKey) try: preparedstmt = con.prepareStatement( "delete pmchgiaassesment where wonum=?") preparedstmt.setString(1, wonum) iresult = preparedstmt.executeUpdate() if (iresult > 0): print "Deleted PMCHGIAASSESMENT wonum = " + wonum con.commit() con.close() except Exception, e: print e #WOACTIVITY
from psdi.mbo import MboSetRemote from psdi.mbo import MboRemote from ute.utils import Security from psdi.mbo import MboConstants from java.lang import String from psdi.workflow import WorkFlowServiceRemote from psdi.util import MXException from psdi.util import MXApplicationException from psdi.util.logging import MXLogger from psdi.util.logging import MXLoggerFactory from java.rmi import RemoteException """Script de validacion de datos en la Etapa 2 (Preparacion de Campo) del WF Preparacion de Tareas @Autor F286635 @Version 1.0""" logger = MXLoggerFactory.getLogger("maximo.gemalog") def titulo_atributo(atributo, objeto): """ Retorna el titulo del atributo pasado por parametro Parametros objeto: objeto en el que se encuentra el atributo atributo: atributo al cual le queremos identificar el titulo Retorna El titulo del atributo """ try: userInfo = mbo.getUserInfo() maxAtribute = MXServer.getMXServer().getMboSet("maxattribute", userInfo)
from psdi.util.logging import MXLoggerFactory try: commTemplateSet = mbo.getMboSet("$commtemp", "COMMTEMPLATE", "TEMPLATEID ='NTAFGEVOERD'") commTemplate = commTemplateSet.getMbo(0) if commTemplate == None: print( "Automationscript NTAFGEVOERD kon communicatietemplate NTAFGEVOERD niet vinden" ) else: commTemplate.sendMessage(mbo) except: myLogger = MXLoggerFactory.getLogger("maximo.script.autoscript") myLogger.error( "Fout opgetreden bij uitvoeren automationscript NTAFGEVOERD")