Product-Documentation

Functionality

Managing Databases

The Content Central configuration page has four sections: Import Database From FFDB, Download Database, Upload Database, New Database and Edit Records. Some of these sections may be hidden depending on individual configuration and circumstances.

Import Database From FFDB

In situations when Content Central discovers databases from the Form Filling Database extension on the system, it enables the import function. The ‘FFDB Database Name’ drop down contains the list of importable databases. A new unique name has to be assigned to the imported database so that it does not conflict with an existing Content Central database.

Download Database

Previously uploaded databases can be downloaded in this section by selecting the database name from the dropdown list and clicking the download button.

Upload Database

A database in CSV format can be uploaded in this section to update an existing database or to create a new one. Select the name of the database to update then click ‘choose file’ to select the data to upload. It is advisable to back up a database before uploading it. To add a new database, select New database > provide name from the dropdown and enter a name in the field on the right, then click choose file.

The database must be a in a valid CSV file format and the column headings must match the respective form filling fields exactly including spacing and capitalisation, in order for the columns to map to the fields in the form filling. All leading and trailing spaces are removed from column headings at upload time. The section column must also be present in the database (can be empty).

New Database

‘Database Name’ - enter the name of the newly created database.

‘Column Names’ - enter the list of column names (headings) for the new database separated by commas. The column headings must match the respective form filling fields exactly including spacing and capitalisation, in order for the columns to map to the fields in the form filling. Do not add the ‘Section’ column, it will be added to the database automatically.

Edit Records

Once a database has been uploaded it will need a dropdown key and dropdown description which are then used on form filling page in the main dropdown. These two values are found in the ‘Edit Records’ section. Select the database from the dropdown list, both fields will be available to edit.

The ‘Dropdown Key’ is the unique identifying column of the database. The ‘Dropdown Description’ is the name the user sees in the dropdown list on the form filling page. For both of these fields enter the column header in between two # tags, for example: #Firstname# #Lastname# where Firstname and Lastname are the column headers. Once the dropdown key and dropdown description have been entered, click the ‘Save Key\&Description Values’ button.

The name of a database can be changed by clicking the ‘Rename this database’ button. When this is clicked the database name will become editable. When you are happy click Save the new name. A database can be deleted by selecting the database from the list and clicking ‘Delete this database’. Click the confirmation to delete the database. Once deleted, the data cannot be restored.

Individual records can be edited or deleted by selecting either of the two buttons on the left of the table. ‘Delete’ will remove this row and ‘Edit’ will make the contents of the row editable. Once edited click update for the changes to take effect. Add records by clicking the ‘Add Record’ button.

Form Filling Fields Configuration

Each product enabled for Content Central can contain multiple record selection drop down controls. Each such control has to be created as ‘Drop down list box’ control type and it has to be configured to retrieve values from SXI Module. The ModuleName is ‘Content Central’ and the Keyword is the required Content Central database name (CC database configuration is explained here). The drop down control can be placed at any location among other form filling fields. Default values can also be configured - in that case the relevant form filling fields are populated on initial load of the document customisation user page.

Multiple drop downs can be achieved by creating another drop down control with a different CC database selected in the Keyword setting.

Sections

The database can be split into different sections, where only users with sections in their profile matching the record’s will be able to see and select it (e.g. showing only some records to certain office locations). Each database must have a section column. See the image below for an example of how sections might work.

The user profile field ‘FormFillingDatabaseSection’ determines which section a user is in. In the example below, the user will only see records relating to a Watford branch, whereas a user whose section was ‘BirminghamOffice” might instead see records for branches in Smethwick or Solihull. If left blank the user will see all records. The field is named ‘FormFillingDatabaseSection’ on systems with previous installations of the ‘Form Filling Database’ extension.

On systems without previous ‘Form Filling Database’ extension installations the field is named ‘Content Central Section’.