dinsdag 24 april 2018  |  Inloggen  
DataDisplay Minimaliseren
Name: Mirjam Riessen
User ID:  3290
Email: harryenmirjam@chello.nl
Name: Carina Vries
User ID:  3289
Email: devries.carina@gmail.com
Name: Mirjam Plante
User ID:  3288
Email: mirjampl@hotmail.com
Name: Jaap Hovenkamp
User ID:  3287
Email: dekijkuit@hotmail.com
Name: Lia Cocq
User ID:  3286
Email: Lia_decocq@hotmail.com
1 2 3 4 5 



About DataDisplay Minimaliseren

Description



This module can display all the records from a predefined database table or custom query on your website. The column names from the table become the tokens that can be replaced in the fully customizable module templates, so you can show the table data exactly the way you want. Results can be split into multiple pages using paging.
The module can also connect to an external database to get data there (MS SQL and MySQL).


Module settings



External database is MySQL:
Check if the external database is MySQL.

Connection string:
Input the connection string to connect to the external database.
A connection string should look something like this: Data Source=192.168.0.55; Initial Catalog=DotNetNuke; User ID=DnnUser; Password=1A2b3C4d

Source table:
Select the source table to export the records from. If a connection string is entered, the module will retrieve a list of tables from the external database.

Custom query:
Input your custom query here. This will be used to export the data instead of a predefined source table.

Columns:
The columns from the source table or custom query. These can be used in the templates as tokens.







Template Settings



Use paging:
Enable this option to use paging of the rows with the selected number of items per page.

Items per page:
You can define the number of items shown per page.

Header template:
Text that will appear above the items.

Item template:
The template uses to display the items.

Alternating item template:
The alternating template uses to display the items.

Separator item template:
The template used between the items.

Footer template:
Text that will appear below the items.

StyleSheet:
Add your custom styles that apply to the templates directly in the module.






Which version to install



DataDisplay comes in 2 versions. Normal installation and a HostOnly installation because the module does NOT take Portal ID’s into account. This could potentially be a security risk on shared hosting solutions so when the HostOnly version is installed, only Host account users can change the settings of the module.



Tokens



These are the available tokens that can be used in the Custom Query. These are default DNN values and cannot be used in the templates.

[USER_ID]
[USER_USERNAME]
[USER_FIRSTNAME]
[USER_LASTNAME]
[USER_DISPLAYNAME]
[USER_EMAIL]
[PORTAL_ID]
[PORTAL_NAME]
[PORTAL_EMAIL]
[PORTAL_ALIAS]
[TAB_ID]
[TAB_TITLE]
[TAB_NAME]
[MODULE_ID]