蟾蜍：10.6：求于自动化reoccuring Excel报表明确指示 [英] Toad: 10.6: Seek clear instructions on automating reoccuring excel reports

问题描述

我是新来的蛤蟆10.6.1和有一个关于运行SQL脚本和电子邮件数据为Excel计划的基础上的文件的问题。

我如何运行脚本，并为Excel格式和电子邮件另存为Excel文件自动为？感谢您的时间。

下面是我到目前为止已经完成，但不认为它正确的，因为我得到ORA-00911：无效字符的第5步。

1. 选择工具|自动化设计软件菜单选项


2. 从右边的窗格中选择DB杂项标签


3. 最后图标这个选项卡中执行脚本，双击它根据动作列表中添加


4. 双击执行脚本1操作打开它


5. 选择文字单选按钮，然后输入查询语句或文件单选按钮，指向SQL文件（我不断收到ORA-00911：无效字符，以及）


6. 在输出窗格中，指定输出目的地，也许一个文件，如果是这样，提供路径和文件输出文件


7. 点击应用和取消


8. 右键单击执行脚本1的动作和命中运行。检查上面的输出路径和文件，以确保其创建


9. 在utlities我增加了电子邮件的功能，但无法整合步骤6安培; 9自动报告

解决方案

当你说剧本你真的想要一个查询的结果导出到Excel中，然后通过电子邮件吗？如果是这样，沟内执行脚本操作。使用导出数据集动作，而不是其目的是运行一个查询，结果导出到各种格式。执行脚本的目的是模拟SQL * Plus功能，你的输出被限制在文本文件中。

1. 删除一个数据集执行行动纳入您的应用程序。它可在自动化设计软件的导​​入/导出选项卡。




2. 双击它来编辑它的属性。




3. 选择文件作为输出目的地，然后点击...按钮，将文件名的权利。设置你的文件名并选择.xls文件格式。你认为合适设置任何其他选项。




4. 选择数据集选项卡，选择导出查询。输入您的SQL那里。




5. 应用和取消。




6. 弃用电子邮件行动统一到您的应用程序下面的导出数据集动作。它可从实用程序选项卡。




7. 双击它来编辑它的属性。




8. 按要求配置邮件服务器的所有属性。 ***请注意，只有10.6支持简单的邮件服务器没有SSL / TLS，所以你不能使用你的Gmail帐户或类似的东西。它的限制。新版本支持蟾蜍Gmail和等。




9. 在附件区域中单击添加文件，并指定导出的.xls文件名。




10. 应用和取消。

现在，当你运行你的应用程序会导出为XLS并通过电子邮件发送的文件。

I am new to Toad 10.6.1 and have a question about running a SQL script and email data as an excel file on a scheduled basis.

How do I run script and save as excel format and email as excel file to automatically? Thank you for your time.

Below is what I've done so far but dont think its correct as I get "ORA-00911: invalid character" on step #5 .

1. Select Utilities | Automation Designer menu option
2. Select DB Misc tab from right side pane
3. Last icon in this tab is Execute Script, double click on it to add under Action list
4. Double click on Execute Script 1 action to open it
5. Select Text radio button and enter query statement or File radio button and point to SQL file (I keep getting "ORA-00911: invalid character" as well)
6. Under Output pane, designate the Output destination, perhaps a file and if so, provide path and file for output file
7. Hit Apply and Cancel
8. Right click on Execute Script 1 action and hit Run. Check the above output path and file to ensure its created
9. Under utlities I added the email function, but unable to integrate steps 6 & 9 to automate report

解决方案

When you say "script" are you really trying to export the results of a single query to Excel and then email that? If so, ditch the execute script action. Use the "Export Dataset" action instead which is intended to run a query and export the results to various formats. Execute Script is intended to emulate SQL*Plus functionality and your output is limited to text file.

1. Drop an "Execute Dataset" action into your app. It's available from the Import/Export tab in Automation Designer.

2. Double click it to edit its properties.

3. Select "File" as the output destination and click the "..." button to the right of the filename. Set your filename and choose the .xls file format. Set any other options as you see fit.

4. Select the Dataset tab and select "Export query." Enter your SQL there.

5. Apply and Cancel.

6. Drop an "Email" action into your app following your "Export Dataset" action. It's available from the Utilities tab.

7. Double click it to edit its properties.

8. Configure all properties as required for your mail server. *** Note that 10.6 only supports simple mail servers and no SSL/TLS so you can't use your Gmail account or anything like that. It's limiting. Newer versions of Toad support Gmail and the like.

9. In the Attachments area click "Add File" and specify your exported .xls filename.

10. Apply and Cancel.

Now when you run your app it will export to XLS and email the file.

这篇关于蟾蜍：10.6：求于自动化reoccuring Excel报表明确指示的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！