Menu Options

New Project

Ctrl+N

Create a new SuperCHANNEL project.

You will be prompted to save the current project, if it contains unsaved changes.

Open Project

Ctrl+O

Open a saved SuperCHANNEL project file.

If the saved project requires a username and password to connect to the source or target database, you will be prompted to enter the credentials.

If you close SuperCHANNEL after having built a SuperSTAR database, and then subsequently open the project again, SuperCHANNEL will detect that the target database exists and will open it in "update mode". Existing columns in the target database will be greyed out. You will be able to add new mapped columns, and update the data in the existing target database, but you will not be able to modify the settings for previously mapped and built columns or rebuild the entire target database.

If you wish to edit the existing mappings and rebuild the database, you must remove or rename the existing SXV4 file before you open the project in SuperCHANNEL.

See Rebuild an Existing SXV4 for more information.

Save Project

Ctrl+S

Save the current SuperCHANNEL project.

This option is only available once you have connected to a source and target database.

Save Project As

Save a copy of the current SuperCHANNEL project.

Save Logs As

Save the current contents of the build logs to a file.

Connect to Source

Ctrl+D

Connect to a source database. This option is only available if you are not currently connected to a source database.

Disconnect From Source

Disconnect from the currently connected source database. This option is only available if you are not currently connected to a target database.

Connect to Target

Ctrl+T

Connect to a target database (i.e. an SXV4 file). This option is only available if you are not currently connected to a target database.

Disconnect from Target

Disconnect from the currently connected target database. This option is only available if you are currently connected to a target database.

Recent File List

Open a recent SuperCHANNEL project.

Exit

Exit SuperCHANNEL.

Status Bar

Show or hide the status bar at the bottom of the SuperCHANNEL window.

Toolbar

Show or hide the various toolbars.

Add Table

Ctrl+A

Add the currently selected table or tables from the Source View to the Target View. SuperCHANNEL will attempt to automatically determine which type of table it is, but you will be able to modify this afterwards if it is not right.

If the selected tables have foreign key links to other tables then the linked tables will also be added.

Add as Fact Table

Ctrl+F2

Add the currently selected table(s) from the Source View to the Target View as fact tables.

If the selected tables have foreign key links to other tables then the linked tables will also be added.

Add as Classification

Ctrl+F3

Add the currently selected table(s) from the Source View to the Target View as classification tables.

If the selected tables have foreign key links to other tables then the linked tables will also be added.

Add as Plain Table

Ctrl+F4

Add the currently selected table(s) from the Source View to the Target View as plain tables.

If the selected tables have foreign key links to other tables then the linked tables will also be added.

Add as Single Table

Ctrl+Shift+A

Add the currently selected table(s) from the Source View to the Target View.

This option is the same as Add Table, except that linked tables will not be added.

Add All Tables

Ctrl+B

Add all the tables in the Source View to the Target View.

Set to Fact Table

F2

Change the currently selected table(s) in the Target View into fact tables.

Set to Classification

F3

Change the currently selected table(s) in the Target View into classification tables.

Set to Plain Table

F4

Change the currently selected table(s) in the Target View into plain tables.

Create Reference

Ctrl+R

Start creating a reference, based on the currently selected field in the Target View.

Create Classification

Ctrl+L

Create a classification based on the currently selected field in the Target View.

Set Primary Key / Remove Primary Key

Ctrl+P

Make the currently selected field in the Target View a primary key (or remove the primary key status if it is currently designated as a primary key).

Exclude Column / Include Column

Ctrl+H

Include or exclude the currently selected field in the Target View from the build.

Set Default Summation

Ctrl+M

Set the currently selected item in the Target View to be the default summation for this database.

This option is only available if the currently selected item is either a fact table (in which case the default summation will be a count of the records in the fact table), or a measure.

Delete

Del

Remove the selected table or tables from the Target View.

This does not delete or modify the table in the source database in any way; it simply removes the table from the target database.

Build Table

Build the selected table in the target database.

Update Table

Update the selected table in the target database.

Revise Table

Revise the fact table in the target database, based on the values in the source for the selected column.

Resume Table

Resume insert on the selected table in the target database from the last commit point (only available if a build has been stopped).

Update All

Update all tables in the target database.

Build All

F5

Build all tables in the target database.

Resume All

Resume building all tables in the target database, starting from the last commit point (only available if a build has been stopped).

Stop Building

Ctrl+Break

Stop the current build (only available when a build is in progress).

You can review the Build Logs pane to see how much of the build has completed, as well as any error messages.

Source Tool

Alt+1

Display the Source View pane. This shows the tables and columns in your source database.

Attributes Tool

Alt+2

Display the Target Attributes pane. This allows you to view and change various attributes for your target database tables and columns, such as the labels to display in the SuperSTAR clients and the column data types and usages.

Logs Tool

Alt+3

Display the Build Logs from the most recent build of the target database.

Data Type Mapping Tool

Alt+4

Display the Data Type Mapping pane. This allows you to customise the default mapping between data types in the source and target databases.

Preferences

Alt+5

Display the Preferences pane.

Although this tool will allow you to make changes to the SuperCHANNEL configuration, you are recommended to make any required changes by editing the configuration file directly, rather than using the SuperCHANNEL GUI. See config.txt for more information.

Target Tool

Alt+6

Display the Target View pane.

Grouping Tool

Alt+7

Display the Grouping tool. You can use this tool to create groupings of fields and change the order they display in the SuperSTAR clients.

Classification Editor

Open the classification editor. This tool is only available when the target database has been previously built and saved.

Online User Guide

Open the SuperCHANNEL user guide.

Tutorial

Open the SuperCHANNEL tutorial.

E-mail Support

Start a new message in your default email client that you can use to contact support.

Space-Time Research On The Web

Open the WingArc Australia website in your default web browser.

About

See information about the product version.