Re: Automated Data Export/File Creation

Sandi,

I don't think you can get the filename to that specific format you are mentioning but you can get it close.  In the export dialog where you put the path to the file name right click in that text box and you should see "Variables…"  From there you can insert these variables into the file name.

The closest I think you will get is THC_MEMBERS_%DATEFILE%-%TIMEFILE%.txt  which will equate to THC_MEMBERS_2013_1_3-50510.txt which is THC_MEMBERS_YYYY-MM_DD-HHMMSS.txt.  It looks like it does not pad 0's into the DD,MM or HH part which is a bummer.

On the export screen you can then click the little camera looking icon on the bottom right this is where you will create an automation action.  After that go to the menu Utilities - Automation Designer where you can set up a scheduled event for this action.

Here is a link that talks about the automation designer.  

http://www.toadworld.com/Blogs/tabid/67/EntryId/601/Task-Automation-in-Toad%C2%AE-Saving-You-Hours.aspx
https://support.quest.com/SolutionDetail.aspx?id=SOL57716

Also try googling Toad Automation Designer for some more tips.

Ed
[TeamT]



On Jan 3, 2013, at 3:04 PM, [email protected] wrote:

> 
> 
> Hi;
>  
> On a scale of 1 to 5, with 5 being the most knowledgeable, I am a 1.5 as a TOAD user. I work for a small shop as a Report Writer and create queries and views for use in Crystal Reports, mostly.  Oh…and we do not have a DB Programmer on staff; the db we work with is owned by our Software vendor, who tend to be unhelpful with this type of thing.  We have two versions of TOAD, 10.6.13 and 11.0.0.116.
>  
> Recently, the contracted with a third-party vendor to do some work for us and we need to provide them with a recurring file of customers.  The text file must be formatted in as pipe delimeted and the file name must use this convention:  THC_MEMBERS_YYYY-MM-DD-HH-MM-SS.txt, where datetimestamp changes on every run and is in the specified format in the file name (THC_MEMBERS_2013-01-03-14-51-47.txt).
>  
> The query has already been created and the data exported manually and all is fine, however, I want to automate and schedule this function.  In order to do so, I need step-by-step instructions, including how to save the file with the above specified naming convention. It probably needs a variable, but I don’t know how to do that. I started looking at the Automation Designer, but quickly lost my way.
>  
> Is there anybody who can point me to an easy to use/understand set of documents that will help me figure this out, please???
>  
> Thank you in advance,
> Sandi
> 
> 
>