Transform structured data tables into complex grandMA macros automatically, streamlining repetitive tasks and boosting workflow efficiency.

“Turn your Excel into Macros.”

Core Capabilities

• Generate Macros from Templates: Import tables and apply predefined templates for macro creation. Choose to generate either a single comprehensive macro or individual macros for each line.
• Persistent Templates: Store and recall macro templates to standardize workflows, ensuring consistent and efficient macro generation across projects.
• From Presets to Show Setup Tools: Design rehearsal macros that streamline operations, like activating specific pages and executors for each song. Or create XYZ Preset macros from position data, patch fixtures to DMX addresses, and build cuelists with embedded commands for complex show control.

Step-by-Step Guide

1. Prepare Data:

   • Create your data table in Excel (or your preferred software) with all the fields you need to process.

2. Import Data:

   • Configure your preferred import settings and optionally configure the CSV format in the GMA Toolbox Settings page.
   • Before importing CSV files, you can configure the CSV format in the GMA Toolbox Settings page. If you're unsure about the format, open the CSV file in a text editor to check its first line.
   • Use Import File to import data from the Comma-Separated Values file (.csv). Alternatively, use Import Clipboard to paste data from applications such as Excel.

3. Edit the Macro Template:

   • Create, load (and save) your required macro template.
   • Use placeholders to insert CSV data. Placeholder {0} represents the current row number. Placeholders {1}, {2}, {3}, etc. represent data columns.
   • Lines starting with “#” will be ignored during generation.

4. Set Export Preferences:

   • Set a name for the generated macros. The name can include a placeholder to insert table data when creating individual macros.
   • Choose an export mode: either generate one comprehensive macro containing all data rows or create individual macros for each data row.

5. Export Macros:

   • For manual import: Export the generated macros to a grandMA2 or grandMA3 folder.
   • Start automatic import: Send the macros directly to the console. Select the first macro ID on the console (a popup window will appear).

User Interface Guide

Import Options

• First Row is Header: Check this option to use the first row as a table header (and exclude it from macro creation).

Export Configuration

• Name: Set the macro name for export. You can include a placeholder to automatically insert table data when generating individual macros.
• Export Mode: Choose whether to create a single macro containing all data rows or separate macros for each row.

Table Fields

• Columns: Each field begins with a number, which can be used as a placeholder {x} in the macro editor.
• Eye Icon: Click to preview the generated macro using the selected line.