Hi Igor,
Your response helps a lot.
Another question or two.
If I develop a Windows Batch script to look in a specific Shared Folder for the existence of a file (file name changes).
How do I pass that file name to my TOAD Automation script?
Once I get that file name in to the Automation script I will then Import the file using the Import Wizard Activity.
Once I complete all my Automation Activities I will then execute a Run Program Activity to execute a Windows Batch script to move the file to a “Processed Shared
Folder”.
Thanks,
Rick
Rick Girardi
Business Intelligence Analyst
Enterprise Risk Management
Wilbur-Ellis Company
345 California Street, 27th Floor
San Francisco, CA 94104
Office: 415-772-4029
Fax: 415-772-4011
rgirardi@wilburellis.com
From: Igor Manokhin [mailto:bounce-IgorM@toadworld.com]
Sent: Tuesday, November 04, 2014 12:00 PM
To: toaddatapoint@toadworld.com
Subject: RE: [Toad Data Point - Discussion Forum] Weekly Automation Script
RE: Weekly Automation Script
Reply by Igor Manokhin
I presume we’re talking about Automation. if this is the case then the answer is: Yes, you can. You might want to create a batch file with ‘if exist’ command. This batch file should produce non-zero
exit code if file isn’t found. Run this batch file with Run activity. If file exists, then its Run_1_RCODE variable will contain 0. You can check its value in If…Else activity and decide if you need to continue processing your data.
In Run activity returns non-zero exit code it will produce an error you can ignore by pressing Continue On Error in the Settings activity.
I attached an example script as well as a batch file you can use as a starting point for your script. .bat extension is not allowed to upload so I changed it to txt. Please rename it back to .bat
when you download them.
Thanks,
Igor.
http://www.toadworld.com/cfs-file.ashx/__key/communityserver-discussions-components-files/36/0753.IfXlsExists.bat.txt
http://www.toadworld.com/cfs-file.ashx/__key/communityserver-discussions-components-files/36/3480.Script_5F00_1.tas
To reply, please reply-all to this email.
Stop receiving emails on this subject.
Or
Unsubscribe from Toad Data Point - General notifications altogether.
Toad Data Point - Discussion Forum
Flag
this post as spam/abuse.