Configure the Data Source and "You can customise..." Footnotes - SuperWEB2

SuperWEB2 can be configured to display 'footnote' text at the bottom of each table:

You can configure the text that is shown here, or remove it entirely.

Configure the Data Source Text

The first footnote line is intended to provide information about the data source used for the table. It is set on a per-database basis. The data source text that is configured for a given database will be displayed whenever a table based on that database is created.

To define the data source text, you need to edit the file database_labels.properties, which is located in <tomcat_home>\webapps\webapi\WEB-INF\classes\

There may be multiple copies of this file for different languages and locales, with names like database_labels_en.properties, and database_labels_en_AU.properties. You need to make these changes in all versions of the file. The properties file that is used will depend on the language settings in the end user's web browser and the set of supported locales defined in the faces-config.xml configuration file (see Multilingual and Localisation Support - SuperWEB2 for more information about localisation and how SuperWEB2 uses the properties files).

The data source text is defined in this file using two lines: one line defines the text string itself, and the other assigns that text string to a particular database.

For example:

bank.datasource=datasource.synthetic
people.datasource=datasource.synthetic
census.datasource=datasource.2001

datasource.synthetic=Space-Time Research synthetic data
datasource.2001=2001 National Census

In this example:

• For tables created using the databases with IDs bank and people, SuperWEB2 will display the text "Data Source: Space-Time Research synthetic data".
• For tables created using the database with the ID census, SuperWEB2 will display the text "Data Source: 2001 National Census".

If the text you want to show for your database is not already listed in this file:

1. Add the datasource text as follows (replace <datasource_id> with an ID of your choosing to identify this text, and replace <text> with the text string itself):

   CODE

   datasource.<datasource_id>=<text>

2. Then map your database to this text by adding a line similar to the following (replace <database_id> with the ID of the database, and <datasource_id> with the ID of the data source text string you want to map this database to):

   CODE

   <database_id>.datasource=datasource.<datasource_id>

3. Restart Tomcat (or the SuperWEB2 Service if you use SuperSTAR Suite).

If you do not want to display a data source for a given database, simply remove the mapping for that database from this file.

Remove the Footnote Text Entirely

If you want to remove all the footnote text, then you can do this by editing the file <tomcat_home>\webapps\webapi\tableView\tableView.xhtml

This change will apply to all databases.

1. Open tableView.xhtml in a text editor.
2. Delete the lines highlighted below (searching for footnote may help you locate them):
   

   

3. Save tableView.xhtml.
4. Restart Tomcat (or the SuperWEB2 Service if you use SuperSTAR Suite).
5. Review the changes in your browser. If you do not see the change you may need to refresh your browser's cache or restart your browser.