Thank you Neil, We are on version 9 and it has also has got that option. But I don't want to delete all the reports in one go. I just want to delete specific days. Can we achieve that using a script or scheduled job?
Thanks, Jo On Aug 18, 1:57 pm, Neil <[email protected]> wrote: > 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- Hide quoted text - > > - Show quoted text - -- 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.
