Overview
Advanced Users
Item Scripter allows you to generate SQL scripts for custom items in InFocus.
Generated scripts can be used to INSERT or UPDATE the item in another InFocus database and are listed across tabs in the order of deployment (e.g. Script 1, Script 2, etc.).
Supported Item types include:
| • | Action/Reports - Custom reports built in Custom Reports applet and with ReportBuilder |
| • | Analytic Dashboard - Analytic Dashboard views designed in Analytic Dashboard Designer |
| • | Analytic Model - Queries entered as Analytic Models in Dashboard Queries Manager |
| • | Chart - Chart widgets built in Dashboard Queries Manager |
| • | Gridget - Gridgets built in Dashboard Queries Manager |
| • | Invoice - Invoice designs |
| • | Tile - Tile widgets built in Dashboard Queries Manager |
When would I use this?
Item Scripter is generally only used to generate scripts for installing (or updating) supported items in another InFocus database.
Tutorial
To generate scripts for an item:
| 1. | Browse to UT>Item Scripter |
| 2. | Select an item type from the drop-down |
| 3. | Double-click an Item from the list |
| 4. | Select INSERT or UPDATE as appropriate |
Generated scripts are listed across tabs in the order of deployment. Scripts can be copied or exported as needed for deployment. Generally, scripts would be deployed in the destination InFocus database using SQL Query applet. Please note: SQL Queries can directly affect the InFocus database. Use caution.
Field Descriptions
| • | Item Type - Drop-down displaying supported item types |
| • | Item list - List of available items |
| • | INSERT - Check to generate insert scripts |
| • | UPDATE - Check to generate update scripts |
| • | Generate Scripts - Click to generate scripts for the selected item |
| • | Copy Tab to Clipboard - Copies the text of the selected tab to the Clipboard |
| • | Copy all Tabs to Clipboard - Copies the text of all tabs to the Clipboard |
| • | Export to a Single File - Exports a single .sql file through a Save As dialogue |
| • | Export to File per Tab - Exports a .sql file for each tab using the Export Directory and File Name Mask (see below) |
| • | Export Directory - Sets the location for saving files when using Export to File per Tab |
| • | File Name Mask - Sets the variables for naming the files exported with Export to File per Tab. |
| o | {type} - Chart, Tile, Report, etc. |
| o | {state} - INSERT or UPDATE |
| o | {index} - 1, 2,… order of script |
|