Using Actuate 8 sp1...
I have an actuate report that after it generates the report it also generates an XML file.
I then have a program (XYZ) that runs that looks at those files and processes the XML Files.
We have the actuate report set to run at 12:01am every night and then the XYZ program to run at 4:00am. After the XYZ program runs it automatically backs up the processed XML files and moves them into a archive folder for historical data collection.
A problem that we have had is that Actuate has hung on us a few times and didn't run the Actuate report until after 4am. So XYZ ran with no XML files to process and reported that there was nothing to process. Then Actuate report ran and the XML Files were created, but nothing happened to them because the XYZ program only runs once at 4am.
Three things that we would like to be able to do, is:
1. Generate a second copy of the file with a date stamp ( i think this should be easy enough )
2. If the XML file is still present after XYZ runs (meaning it was not there initially to process) append the next generated XML file onto the end of the first one.
3. Generate an XML file even if there is no data to report. (Apparently Actuate does not generate an XML file if there is nothing there.)
Does anyone know if this is possible?
Thanks
Tom Cusick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
the code being used at the end of the report is:
I have an actuate report that after it generates the report it also generates an XML file.
I then have a program (XYZ) that runs that looks at those files and processes the XML Files.
We have the actuate report set to run at 12:01am every night and then the XYZ program to run at 4:00am. After the XYZ program runs it automatically backs up the processed XML files and moves them into a archive folder for historical data collection.
A problem that we have had is that Actuate has hung on us a few times and didn't run the Actuate report until after 4am. So XYZ ran with no XML files to process and reported that there was nothing to process. Then Actuate report ran and the XML Files were created, but nothing happened to them because the XYZ program only runs once at 4am.
Three things that we would like to be able to do, is:
1. Generate a second copy of the file with a date stamp ( i think this should be easy enough )
2. If the XML file is still present after XYZ runs (meaning it was not there initially to process) append the next generated XML file onto the end of the first one.
3. Generate an XML file even if there is no data to report. (Apparently Actuate does not generate an XML file if there is nothing there.)
Does anyone know if this is possible?
Thanks
Tom Cusick
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
the code being used at the end of the report is:
Code:
Sub Finish( )
Super::Finish( )
' Insert your code here
dim v as AcXMLDataVisitor
set v = newXMLDataVisitor("xml/text")
v.generateXML(fileName, me, "")
(fileName is set as a parameter)