Toad World® Forums

Problem with automation scripts in TDA 2.6 ...


#1

4/2/2010 3:15:01 PM: Build started

4/2/2010 3:15:08 PM: Build Completed

4/2/2010 3:15:10 PM: Connecting to BDSS2_PROD (E65269), E65269

4/2/2010 3:15:10 PM: Connection successful.

4/2/2010 3:15:10 PM: Running export template W:\Marcy - Ins Payor Files\200812 Output Test\BAS Export Template File.txp

4/2/2010 3:15:22 PM: Attempted export 79 rows.

4/2/2010 3:15:22 PM: Successfully exported 79 rows.

4/2/2010 3:15:22 PM: Export Finished, click Aetna.xls to view file.

4/2/2010 3:15:22 PM: Running export template W:\Marcy - Ins Payor Files\200812 Output Test\BIR Export Template File.txp

4/2/2010 3:15:24 PM: Running export template W:\Marcy - Ins Payor Files\200812 Output Test\BMD Export Template File.txp

4/2/2010 3:15:45 PM: Attempted export 102 rows.

4/2/2010 3:15:45 PM: Successfully exported 102 rows.

4/2/2010 3:15:45 PM: Export Finished, click Aetna.xls to view file.

4/2/2010 3:15:45 PM: Running export template W:\Marcy - Ins Payor Files\200812 Output Test\BSH Export Template File.txp

4/2/2010 3:15:53 PM: Attempted export 2 rows.

4/2/2010 3:15:53 PM: Successfully exported 2 rows.

4/2/2010 3:15:53 PM: Export Finished, click Aetna.xls to view file.

4/2/2010 3:15:53 PM: Running export template W:\Marcy - Ins Payor Files\200812 Output Test\GAR Export Template File.txp

4/2/2010 3:16:04 PM: Attempted export 27 rows.

4/2/2010 3:16:04 PM: Successfully exported 27 rows.

4/2/2010 3:16:04 PM: Export Finished, click Aetna.xls to view file.

4/2/2010 3:16:04 PM: Running export template W:\Marcy - Ins Payor Files\200812 Output Test\GRP Export Template File.txp

4/2/2010 3:16:11 PM: Attempted export 50 rows.

4/2/2010 3:16:11 PM: Successfully exported 50 rows.

4/2/2010 3:16:11 PM: Export Finished, click Aetna.xls to view file.

4/2/2010 3:16:11 PM: Running export template W:\Marcy - Ins Payor Files\200812 Output Test\IRV Export Template File.txp

4/2/2010 3:16:59 PM: Attempted export 32 rows.

4/2/2010 3:16:59 PM: Successfully exported 32 rows.

4/2/2010 3:16:59 PM: Export Finished, click Aetna.xls to view file.

4/2/2010 3:16:59 PM: Running export template W:\Marcy - Ins Payor Files\200812 Output Test\OCH Export Template File.txp

4/2/2010 3:17:43 PM: Attempted export 8 rows.

4/2/2010 3:17:43 PM: Successfully exported 8 rows.

4/2/2010 3:17:43 PM: Export Finished, click Aetna.xls to view file.

4/2/2010 3:17:43 PM: Running export template W:\Marcy - Ins Payor Files\200812 Output Test\PLA Export Template File.txp

4/2/2010 3:17:46 PM: Attempted export 28 rows.

4/2/2010 3:17:46 PM: Successfully exported 28 rows.

4/2/2010 3:17:46 PM: Export Finished, click Aetna.xls to view file.

4/2/2010 3:17:46 PM: Running export template W:\Marcy - Ins Payor Files\200812 Output Test\PLH Export Template File.txp

4/2/2010 3:17:50 PM: Attempted export 4 rows.

4/2/2010 3:17:50 PM: Successfully exported 4 rows.

4/2/2010 3:17:50 PM: Export Finished, click Aetna.xls to view file.

4/2/2010 3:17:50 PM: Running export template W:\Marcy - Ins Payor Files\200812 Output Test\WAX Export Template File.txp

4/2/2010 3:18:24 PM: Attempted export 11 rows.

4/2/2010 3:18:24 PM: Successfully exported 11 rows.

4/2/2010 3:18:24 PM: Export Finished, click Aetna.xls to view file.

4/2/2010 3:18:24 PM: Done

Just tried to run one of my monthly automation scripts from the 2.6 version of TDA. Appeared to work correctly but when I checked the Excel books only the last export in each set of exports is present. Each script ran 11 exports (to 11 different tabs in an excel workbook). Tried backing up to older version, and that bombed also. The output log looks as if it wrote to each tab. See below:


#2

I can see you are exporting to the same file but I can not see the details in the export templates. In TDA 2.6 we did make some changes in Export. I go over these changes in this Blog posting.

http://www.toadworld.com/BLOGS/tabid/67/EntryID/514/Default.aspx

I would suggest exporting to a different named sheet for each export. If this does not answer your questions, zip up all of your txp files and Automation script and send to me directly.

Debbie
dpeabody@quest.com



#3

The subject line of your email did not include a token used by the system to identify you and the message to which you are replying. Please try again, and make sure not to delete the token (enclosed in square brackets) at the end of the subject line.

Desperately trying to send the scripts and export templates direct to Debbie. Replied but getting this error…
INS Payor Automation and Export Templates.zip (128 KB)