you can always write your own batch job outside of CMS and run it as scheduled task on your Windows Server.. Would that work?
On 19 Aug., 03:52, Jo <[email protected]> wrote: > 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.
