table

Use this command to manage shared tables saved to the User Data Repository (UDR).

You can use the table command to add saved tables to the UDR, as well as managing existing saved tables that have been created in SuperWEB2.

You can also use this command to move all private tables owned by a given user to a different user (for example in cases where an end-user has retired or left their organisation and they want to give their saved tables to their replacement).

The commands for listing, adding and managing saved tables only operate on tables that have been saved in the main catalogue area (you cannot list, add and manage tables that are saved to a user’s private storage area). The transfertables command is the exception to this, as it operates only on a user’s private tables.

The tables that you manage using this command will only be available to users of SuperWEB2. They do not appear in SuperCROSS.

If you are running the SuperADMIN console on a different machine to the one running SuperWEB2, then make sure you use the connection command to check and configure the connection to SuperWEB2.

table [ <folder_id> ] addtable <table_id> [ <display_name> ] <path_location>

Add a table to the catalogue.

`<folder_id>`	(Optional): the folder to add the table to. If you omit this the table will be added at the top level of the catalogue.
`<table_id>`	A unique identifier for the new table. This is the ID that you will use to manage the table in SuperADMIN.
`<display_name>`	(Optional): a display name for the table. This is what users will see in SuperWEB2. If you choose not to set the display name then it will be set to the same value as the table ID.
`<path_location>`	The location on your local disk of the TXD file that contains the table. Once you add the table it will be uploaded to the server and the file on disk will no longer be required.

table [ <folder_id> ] tables

List all the tables in the specified folder (or at the root level if you omit the folder ID).

The command table on its own is an alias for table tables (i.e., this command will list all tables at the root level).

table <table_id>

List details of the specified table.

table <table_id> remove

Remove a table from the catalogue.

table <table_id> move <folder_id>

Move a table to the specified folder.

table <table_id> displayname

View the current display name of the specified table.

table <table_id> displayname <new_display_name>

Change the display name of the specified table.

table <table_id> content

Display the details of the table. For example:

TEXT

> table savedtable1 content
HEADER
        ESCAPE_CHAR & ITEM_BY_CODE
        DBID "bank"
        HEADING "&&o&n&&d&nTable 1&n&&v&n&&s"
        FOOTER "&&r&n&&f&n&&c&n&&p&n&&a"
        ALIGN HEADING CENTRE
.....

table <table_id> export <path_location>

Export the table to a file.

The path location must be a full path to the location to save the file on disk, including the filename. For example:

CODE

table savedtable1 export "E:\tables\savedtable1.txd"

table transfertables <current_user> <new_user>

Transfer all tables owned by a given user to a different user. You must be an administrator user to run this command.

For example:

CODE

table transfertables user1 user2

Whenever tables are transferred between users via this command, a record will be logged in the SuperWEB2 audit logs. SuperADMIN does not verify that the user the tables are being transferred to exists, so make sure that you check the command carefully before running it. If you make a mistake you can check the records in the audit logs and then use the command again to move the tables to the correct user.

For users connecting via SAML authentication, you need to use the SAML user ID (which may be an automatically generated ID depending on how you have configured the SAML connection).