External Data Example

The following information is being displayed by using a Data Object to find all Site Manager users in the Site Manager database and display some of their details. In order for this to display in this Sample Data do the following:

  1. In Site Manager go to Tools > Configuration > Handlers and click Configure next to the Data Object Handler. Click on the user (smuser) and update the username and password that is used to connect to your Site Manager database. You can find out the username by clicking Help > About Site Manager > Database, and it is shown next to Connected User.
  2. In Site Manager go to Assets > Content Templates and Edit the SM Users Data Object template. Select the Formatter tab and Edit the text/html. In the t4 tag, update the url of the database:
    <t4 type="data-obj" method="jdbc" driver="com.mysql.jdbc.Driver" db-url="jdbc:mysql://localhost/<DB-NAME>" username="smuser" sql="select username, last_name, first_name, email_address from users" formatter="text/output" />
  3. Select Content > Publish and the data will appear on the page.


FAQ

How to Incorporate Content from a Database

Visit our How to section on the extranet to get a step by step guide on how to create this feature.


Site Manager Users

Login

Name

Email


FAQ

How to create a CSV file

You can also see this users list in CSV Excel format.

Visit our How to section on the extranet to get a step by step guide on how to create this feature.



Contact Us

TERMINALFOUR

Tel Ireland: +353 1 8509 700
Tel UK: +44 1753 542 234
Tel US: +1 617 444 8493