2024:Grooper Command Console (Application)

Grooper Command Console (or GCC) is an administrative application used to add and remove connections to Grooper Repositories, upgrade existing Grooper Repositories to a newer version, and install and uninstall Grooper Services.

About

FYI	Grooper Command Console (GCC) replaced Grooper Config in version 2024. All setup and configuration previously done in Grooper Config is now done in Grooper Command Console.

Grooper Command Console (GCC) is a command line interface for performing system configuration and administrative tasks. GCC is used to:

• Set up new and connecting to existing Grooper Repositories.
• Install and uninstall Grooper Services, such as Activity Processing services.
  • Be aware: GCC's primary function is to install services. Managing and configuring them should be done from the Machines node in the Design page.
• Installing product licensing

GCC performs system admin operations using command prompts. The syntax for executing a GCC command is as follows:

gcc> group command parameters

• FYI: The GCC documentation lists required parameters in angle brackets <> and optional parameters in square brackets []

There are seven (7) GCC command groups:

• connections - Used to manage Grooper Repository connections
• databases - Used to manage Grooper databases
• services - Used to manage Grooper services
• license - Used to manage licensing for a local Grooper license server
• scripts - Used to manage Grooper scripts
• utils - Various utility commands
• help - Use help commands for more information about commands in a group.
  • help commands should always follow the syntax help groupName.
  • For example, help connections will give you information about the various commands in the connections group.

How To: Grooper Repository Connections

⚠	GCC must be run as an administrator to perform most of its functionality. It performs functions that require elevated access in Windows.

This portion of the article will instruct you how to use Grooper Command Console to do the following things:

• Connect to an existing Grooper Repository
• Create and connect to a new Grooper Repository
• Upgrade a Grooper Repository to a new version

Connect to an existing Grooper Repository

When using GCC to connect to an existing Grooper Repository, you just need to enter a single GCC command.

1. Open GCC.
   • GCC can be accessed from the Windows Start menu.
   • The executable gcc.exe can be found in the Grooper install directly.
2. Use the following GCC command to connect to the Grooper Repository:
   • connections add <server> <database> [user] [password]
     • <server> is a required parameter. Enter the server name (or IP address) hosting the Grooper database.
     • <database> is a required parameter. Enter the name of the Grooper database. If the database name contains spaces, you must enclose the whole name in quotes (i.e. "database name")
     • [user] and [password] are optional parameters. Windows will pass through the currently logged on user's credentials if not entered.

For example, if I wanted to connect to a Grooper Repository whose database named "2024 Grooper DB" was hosted on a server named "GROOPERSQL01", I would enter the following GCC command.

• connections add GROOPERSQL01 "2024 Grooper DB"

FYI	If you want to verify which Grooper Repositories you are connected to, use the following command: connections list This command will list all current Grooper Repository connections.

Create and connect to a new Grooper Repository

Creating a new Grooper Repository is done with three GCC commands. (1) You will use a command to create a new Grooper database. (2) You will use a command to add the connection to the newly created Grooper Database. (3) You will initialize the new Grooper Repository.

1. Open GCC.
   • GCC can be accessed from the Windows Start menu.
   • The executable gcc.exe can be found in the Grooper install directly.
2. Use the following GCC command to create a new Grooper Database:
   • databases create <serverName> <databseName> [user] [password]
     • <serverName> is a required parameter. Enter the server name (or IP address) hosting MSSQL where the database will be created.
     • <databaseName> is a required parameter. Enter the name of the Grooper database.
       • If the database name contains spaces, you must enclose the whole name in quotes
       • Ex: "2024 Grooper Database"
     • [user] and [password] are optional parameters. Windows will pass through the currently logged on user's credentials if not entered.
3. Use the following GCC command to add a connection to the new Grooper Database:
   • connections add <serverName> <databaseName> [user] [password]
     • <serverName> is a required parameter. Enter the server name (or IP address) from step 2.
     • <databaseName> is a required parameter. Enter the name of the Grooper database from step 2.
       • If the database name contains spaces, you must enclose the whole name in quotes.
       • Ex: "2024 Grooper Database"
     • [user] and [password] are optional parameters. Windows will pass through the currently logged on user's credentials if not entered.
4. Use the following GCC command to initialize the new Grooper Repository:
   • connections init <connectionNo> <repositoryName> <storagePath>
     • Grooper Repositories must be initialized before they can be used.
       • Initialization builds the tables in the Grooper Database and associates the Grooper File Store's path with the Grooper Repository.
       • If you do not have a folder location created for the File Store, do so now. You will need to enter a UNC path for the Grooper File Store for the storagePath parameter
     • connectionNo is a required parameter. Enter the connection number for the Grooper Repository you want to initialize.
     • <repositoryName> is a required parameter. By default, uninitialized Grooper Repositories are named "New Grooper Repository" use the <repositoryName> parameter to rename your Grooper Repository.
       • Please enclose this parameter in quotes to avoid conflicts. Spaces in Grooper Repository names will break the GCC command.
       • Ex: "2024 Grooper Repo"
     • storagePath is a required parameter. Enter the storage path for your Grooper File Store's folder location.
       • Only use fully qualified UNC paths. Mapped and local drive references may not be accessible to other users or machines.
       • Please enclose this parameter in quotes to avoid conflicts. Spaces and special characters in the storage path will break the GCC command.
       • Ex: "\\servername\Grooper File Stores\2024 Grooper Repo File Store"

For example, the following three commands would create a new Grooper Repository named "2024 Grooper Repo" (presuming this is the first Grooper Repository connection added to GCC).

databases create SQLSERVER01 "2024 Grooper Database"
connections add SQLSERVER01 "2024 Grooper Database"
connections init 1 "2024 Grooper Repository" "\\servername\Grooper File Stores\2024 Grooper Repo File Store"

FYI

Knowing which Grooper Repository connection number you need to enter is critical to using the connections init command. If you do not know the connection number to enter, use the following command: connections list This will list all Grooper Repository connections and display some basic information about them. In this image see connection number "3" is not initialized.

Upgrade a Grooper Repository to a new version

When using GCC to connect to an existing Grooper Repository, you just need to enter a single GCC command. This GCC command will run upgrade code on an older Grooper Repository, allowing it to be used in a newer Grooper version.

• IMPORTANT!!! DON'T FORGET TO BACKUP YOUR REPOS
• You should always perform a complete backup of your Grooper Repository's file store and database before upgrading to any newer Grooper version.
  • If, for whatever reason, something goes wrong during the upgrade process and your file store and/or database is corrupted, you could loose critical components, such as your Batch Processes, Content Models, or document files for any Test or Production Batches.
  • Performing a backup will ensure you have something to revert to in the rare cases where the upgrade does improperly overwrite existing database values or files in your file store.
• For information how to backup and restore your Grooper database and file store, please visit the article below:
  • Backup and Restore Grooper Repository

1. Open GCC.
   • GCC can be accessed from the Windows Start menu.
   • The executable gcc.exe can be found in the Grooper install directly.
2. Use the following GCC command to upgrade the Grooper Repository:
   • connections upgrade <connectionNo>
     • connectionNo is a required parameter. Enter the connection number for the Grooper Repository you want to upgrade.

⚠	IMPORTANT - If present, make sure you compile all Object Libraries after the upgrade. IMPORTANT - The devs also strongly recommend that you perform validation on your repository after upgrading. Object Libraries should be compiled before validating your repository to ensure best results.

FYI

Knowing which Grooper Repository connection number you need to enter is critical to using the connections upgrade command. If you do not know the connection number to enter, use the following command: connections list This will list all Grooper Repository connections and display some basic information about them. In this image see connection number "3" is an older version and needs to be upgraded.