Universal List is a powerful add-in module to DotNetNuke which allows non-technical administrators to build data-driven applications. Universal List lets users view, create, update and delete data stored in databases. Using an intuitive interface, Administrators can build their application using a mouse and basic HTML. Below are screenshots of a sample "class reunion" database application. (For a larger image, click a screenshot below.)
View Record List / Grid
Here is the main "public-facing" page which lets users see all of the records in a list layout. The page has sorting, filters, searching, pagination and a 2-grid data layout. Using a few HTML Table tags, this list can be converted into a spreadsheet-like grid layout.
View Record Details
If enabled by the administrator, Users can click a record to see additional details (more data points or the same data in a different layout). The administrator can hide this view altogether or hide it from certain users (using DNN's Roles).
Add New / Edit Existing Record (Data Entry Form)
Users can also create new records or modify existing ones using an Edit form. Administrators can show/hide the page based on a user's Role and can allow some roles to edit all records or only the records they created.
Import Data From Excel, CSV or XML
To save time, administrators or users can quickly upload data in Excel, CSV or XML files into the database. Simply match fields in the database to columns in the spreadsheet. When no data is present in the upload file, UL lets you enter a default value.
Export Data to Reports
Users also have the option to export data into Excel, CSV or XML files. Check the fields, choose a file format and presto - a report. This feature can also be turned off by administrators.
Configuration: Table & Fields View
The administrator-facing side of Universal List allows you to build and alter applications to fit your needs. To start, just create a new table or select an existing one within your DNN database. Then add or edit data fields.
With UL, you can make unlimited applications on your website - you can also create different views of the same data table - for example, one for the public and one for administrators.
Configuration: Add New Field
Adding a new field is a snap. Just choose the field name (no spaces or special characters except underscore), whether it is required, if it should be included in the sorting and filter sections, and what type of data it will be. UL currently lets you to create text, multi-line text, dropdown (pulled from another table), numeric, checkbox, or date fields.
All Data is Stored in SQL Tables
This screenshot of a MS SQL database illustrates that all data built and stored with UL resides in your DNN SQL database - not in XML. This makes integration into other applications simple.
Universal List Templates
UL's Template pages are where the power and simplicity of the software are most evident. You can control the look and feel of each page and location of each feature using basic HTML and our simple tokens.
Configuration: List View Header (aka Main Template)
The section surrounding the actual data on the List/Grid page is controlled by the "Main Template." This is where sorting, pagination, filters and search are controlled.
Enter custom Header and Footer text, put paginaton links above an below the data, etc here. You can also decide if the page is to be a grid or list and how many columns in which to display the data.
Configuration: List View Data (aka Short View Template)
The layout of each data record on the List page is controlled here. Using simple Tokens, data can be added or excluded. Basic HTML or CSS tags control the layout and look of the data as well.
Configuration: Record Details (aka Full View Template)
UL also includes a Record Details template (no screenshot displayed) where you can design a 'more details' page.
Configuration: Add/Edit Template
UL's fourth and final Template lets you control the look and layout of the data entry form which controls how records are added or edited. Based on the data type selected when the field was created, UL will automatically display a date picker control, checkbox, dropdown, etc. You just add the token and set the height and width of the elements using basic HTML.
UL lets the administrator pre-determine the sort order of the data on the list page. Just pick a field, choose ascending or descending order and press save.
Filters allow administrators to exclude data which matches specific criteria from public view.
Almost every aspect of UL can be controlled on the Security page. Using DNN's built-in Security Roles functionality, UL lets an administrator control which users (based on the Role to which they belong) can perform what actions (add new, edit existing, delete, view, etc).
Each page where you place a UL module can have different security settings. In addition, you can control what actions a user can perform on all records in the database or just their own records.
Configuration: Advanced (aka Notifications)
When a record is added, deleted, or modified, you can choose to have a notification email sent to one or more email addresses.
Sample Notification Email
Below is a sample of the email sent - notice the website, timestamp, table, record ID and username are captured - in addition to the old and new data values.
Many of the links and words used within UL can be changed to make the application itself conform o the needs of your users.