View Single Post
  #1 (permalink)  
Old 08-08-2007, 12:59 PM
gardnli gardnli is offline
Junior Member
 
Join Date: Jul 2007
Posts: 9
Red face Web Recorder Issue

This post will be a little long, but I figure the more detailed my description, the better chance someone will be able to assist.
I have created two tasks which work in concert together. The first task goes into our company report generating system and orders 7 reports. Then the 2nd task is to go back into the reporting system and download the reports which have generated using a javascript command. This has been working very well after working all of the idiosyncrasies involved with our particular web reporting system, however, this a.m. I ran into a problem that I am at a complete loss on how to correct.
At the completion of the report request a report token ID is generated and once the report has completed, it is available for download by the report token ID. In the first process I gather the report token ID's generated and hold those values in an Access database for use when the reports are available for download. I then use the database connection to provide the parameter for the link. I was having issues with the interface between AA and our reporting system when I attempted to have it loop through a single query to provide the parameters, so I changed the code to include a query with a single record for each occurrence of the report that I wanted to have downloaded. These are named D1 - D7.

This a.m., the AA task downloaded the first report instance it came to, token ID TER412_GARDNLI_2910427, which is the token ID found in D4, not D1 and then jumped down to the bottom of the page and downloaded 6 copies of token ID TER412_GARDNLI_2901411 (which was ordered and downloaded successfully 2 days ago) which is not contained as a value in queries D1 - D7.

I have attached the entire contents of the 2nd task as TER412Download.txt and the lines which are proving the problem are 9-24. I am at a loss as to why it is downloading a report that is not one of the parameters passed through. I double checked by using the Message box function to ensure that the correct parameters were being passed. A sample (from query D1) of the value being passed to the reporting system is: javascript:download('TER412_GARDNLI_2910433.zip',' EQP1A','file:///c:/fts/TER412_GARDNLI_2910433')

Any assistance/suggestions would be greatly appreciated.
Attached Images
File Type: jpg TER412Download.jpg (13.1 KB, 9 views)
Attached Files
File Type: txt TER412Download.txt (3.4 KB, 8 views)

Last edited by gardnli; 08-08-2007 at 01:02 PM. Reason: The attachments were not visible
Reply With Quote