Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Actuate and XML

Status
Not open for further replies.

tjcusick

Programmer
Dec 26, 2006
134
US
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:
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)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top