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.
