Automate Utility Kit - Automate_Studio - 20.3

Automate Studio with Connect User Guide

Product type
Product family
Automate > Automate Studio
Product name
Automate Studio
Automate Studio with Connect User Guide
Topic type
How Do I
First publish date

The Automate Utility Kit provides tools that make it easier to work with and upgrade Studio.

The information below supports the use of the utility kit, and you can request a link to the Automate Utility Kit from Customer Support.

Below are the Automate Utility Kit Tools:

  • Chained scripts conversion to latest

  • Manage Add-Ins

  • Generate Command Line

Chained scripts conversion to latest

Currently v10.x scripts cannot be linked with v11 and later scripts, and v10.x linked scripts cannot be submitted to Foundation v11 and later. Instead of converting the scripts individually, you can use the utility to do the following:

Convert script chains that were created in v10.x to the v11 and later format. The chained scripts will be created in the same folder and have the extension _v11 (or _v12 or later version), unless you check the Overwrite original box.

If any or all carry settings (data file, start row, end row, number of records, sheet) are carried forward from the first v10.x script, the converted v11 (or later version) script chain will show the carry setting as Custom, with all of these settings carried from the first file. All other settings, such as ALC and backup SAP, will be picked from the individual files.

If the v10.x script chain has no carry settings defined for the first script, Studio v11 and later will apply the Run settings - All from Individual Script setting.

dialog box for converting linked scripts

  1. Click Convert 10.x and lower version Linked Scripts.
  2. Click the Browse script button, navigate to the first linked script in the chain, click Open, and then click Open again.
  3. Only linked scripts can be opened. If you select an unlinked script, an error message will appear.
  4. To replace the original script, check the Overwrite Original box.
  5. Click Convert.
  6. Click Close.

Manage Add-Ins

To manage add-ins, you must run the utility kit as an administrator. Start the kit by right-clicking it and clicking Run as Administrator.

manage add ins dialog box

  1. Click Manage Add-Ins.
  2. Click the add-in that you want to change.
  3. Do one of the following:
    • Register or un-register the add-in.
    • Register or un-register the macro. If the macro is unregistered, Run will no longer be available.
    • Load the add-in or macro if it is installed but has not been loaded.
    • Repair the add-in or macro. Repair basically un-registers and then registers the add-in or macro.

Generate Command Line

Command line code and macro code is complex and hard to prepare. This tool uses the run settings that you enter to automatically generate command line and macro code that you can copy and run on the command line or paste into an Excel macro.

Generate a command line

In Connect mode, provide the script file and data file paths. The rest of the fields are optional.

In Foundation mode, click URL and enter the path to the script on the Foundation site, or click Local Script, click the Browse button, navigate to the script, and click Open.

If you click ALC, type the SAP server description. If you click Server-Client, type the values for Server and Client ID.