Hi What version are you using? We are on v10 and there is an option to 'Delete Job Reports' in the action menu when selecting Administer Publication > Job Reports, which deletes all reports in one go.
Neil On Aug 18, 8:51 am, Jo <[email protected]> wrote: > Hi, > > We have a long list of publishing report for our live project in > reddot cms. > Other than dleting it manually one by one, is there any way that we > could delete it , like for a motnhs report? > > I tried to write a script, which didn't work as expected.I tried to > run the script as scheduled job. This is based on another post here. > > -------------------------------------------start > code----------------------------------------------------------------------- > ----------------------------- > <% > > '***************************************************** Settings > ***************************************************** > > ProjectGUID = "8517ABAA4EB248C795B3344E7B31EE4C" 'Project GUID > pageGUID = "F5D623EFABBF407CAE52BF267D775986" 'GUID of page that > contains text field > linkGUID = "9336EB5B39154C1DACEC9285719E2D7P" 'GUID of anchor or list > that the above page is connected to > folderGUID = "00F18BD2FD6D4E5DB005E8F644737AC0" 'GUID of resource > manager folder where images are stored > textField = "txt_images" 'Name of > text field to update > Username = "xxx" 'Username > of user with sufficient rights to > publish page > Password = "xxx" > 'Password of above user > reportGUID = "44787BD40B04479C861632D089826358" 'GUID of the job > report > daysno = "100" 'delete > reports before x days > > '*************************************************** End Settings > *************************************************** > %> > > <html> > <head> > <style> > body { > font-family: Verdana; > font-size: 0.8em; > } > .error { > color: #f00; > } > </style> > > </head> > <body> > > <% > 'on error resume next > > ' ### Define server objects > set objIO = Server.CreateObject("RDCMSAsp.RDPageData") > objIO.XmlServerClassName = "RDCMSServer.XmlServer" > set objXML=Server.CreateObject("Microsoft.XMLDOM") > > ' ### Login to CMS > xmlData = "<IODATA>" &_ > "<ADMINISTRATION action=""login"" name=""" & > Username & """ > password=""" & Password & """/>" &_ > "</IODATA>" > loginData = objIO.ServerExecuteXml(xmlData, strError) > Call objXML.LoadXML(loginData) > set loginData = objXML.selectSingleNode("//IODATA/LOGIN") > LoginGUID = loginData.getAttribute("guid") > > ' ### Retrieve session guid > xmlData = "<IODATA loginguid=""" & LoginGUID & """>" &_ > "<ADMINISTRATION action=""validate"" guid=""" & > LoginGUID & """ useragent=""script"">" &_ > "<PROJECT guid=""" & ProjectGuid & """/>" &_ > "</ADMINISTRATION>" &_ > "</IODATA>" > sessionData = objIO.ServerExecuteXml(xmlData, strError) > Call objXML.LoadXML(sessionData) > set sessionData = objXML.selectSingleNode("//IODATA/SERVER") > SessionKey = sessionData.getAttribute("key") > > Response.Write ("SessionKey : "+SessionKey+" ") > > xmlData = "<IODATA sessionkey="""" & SessionKey & """">"&_ > "<PROJECT guid=""" & ProjectGuid & """ > sessionkey="""" & SessionKey & """">" &_ > "<EXPORTREPORT guid=""" & reportGUID & """ > action=""deleteall""/>" &_ > "</PROJECT>" &_ > "</IODATA>" > > sessionData = objIO.ServerExecuteXml(xmlData, strError) > Call objXML.LoadXML(sessionData) > > 'days=""" & daysno & """ > > Response.Write ("deleted ??") > > ' ### Log out > xmlData = "<IODATA loginguid=""" & LoginGUID & """>" &_ > "<ADMINISTRATION><LOGOUT guid=""" & LoginGUID & """ > /></ADMINISTRATION>" &_ > > "</IODATA>" > objIO.ServerExecuteXml xmlData, strError > > Response.Write ("Job reports deleted.") > > ' ### Dispose of objects > set objXML = nothing > set objIO = nothing > %> > > </body> > </html> > > --------------------------------------------------------end > code----------------------------------------------------------------------- > ------- > > Please anybody help me on this ? > > Thanks, > Jo -- You received this message because you are subscribed to the Google Groups "RedDot CMS Users" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/reddot-cms-users?hl=en.
