Create custom modules on the fly! Complex and simple structures! Manage your data with ease!
Universal List v.3.3
Universal List (U.L.) is a tool for creating and managing database tables in DNN with a mouse. Tables can be standalone and simple, like Contacts (Name, Address & Phone), or relational (creating complex relationships using multiple tables) like Contacts (Name, Address & Phone), Departments (Name, Manager, Contact), & Roles (RoleName, Description, PayGrade).
Universal List 3.3 has the following properties:
§ NEW! Extended filters - admin can predefine any count of filters. Predefined filters can not be changed by user. Admin can predefine list of fields, which user can use for filtering.
§ NEW! Default sorting - admin can predefine any count of fields for Sort by Default. Predefined sorting can not be changed by user. Admin can predefine list of fields, which user can use for sorting.
§ NEW! Extended security - if user has rights to edit records, then he can edit only own records. Admin define this feature in “Security“ settings.
§ NEW! Cascade reference – show your data faster then AJAX.
§ NEW! Extended Search data (like Google).
§ NEW! Export/Import structures of tables from Excel, CSV, XML.
§ NEW! Extended security – allow to set security for each TabModuleID and each Role.
§ NEW! Packages Export/Import – easy way to exchange data between projects. All packages for Universal List free-of-charge! You can download free packages at Universal List Packages or public your own packages.
§ Dynamic structure of the tables for data storage. You can Import data structures from different formats like Excel, CSV, XML.
§ Data is displayed in custom formats using templates. The admin can define default template views, but each user can create their own custom template (only will be seen by that user).
§ Import/Export of data support the following formats: Excel, CSV, XML.
§ Security! Define which users have permission for different operations: add, edit, delete, review, change table structure.
§ Sort of data.
§ Fast filtering of the data, taking into account a complex filter for DateTime, Numeric, Reference.
§ Relational-like binding of two or more tables. Creation of complex structures, for example Clients, Managers, Products, using key fields to link table data.
U.L. provides on-screen, admin-only access to add new, edit and delete records using a mouse. You can delete records one at a time or in bulk. You can also use DNN security roles to allow certain users perform specific actions.
U.L. allows bulk-uploading of records into your tables from Excel, CSV & XML files. Field names, order, etc are user-determined.
U.L. features customizable admin-only templates for "list" and "details" pages. Templates use standard html and tokens (field names surrounded by hashes (#)).
U.L. has built-in list page sorting, filtering & pagination. All of the features you expect from an item list page - sorting by row header, list filtering by keyword or dropdown, user-set pagination (show X records per page; click next, previous, or the page number). Filtering takes into account DateTime, Numeric, or Reference data.
U.L. has keyword searching. It uses a fast indexing algorithm to search by keyword in all of the data fields.
U.L. can export data to Excel, CSV or XML. Users can click to export a subset of the data to the file format of their choice. Admins can define the export template field names, order, etc
Finally, U.L. is customizable. Contact us today to see how easy it is to build a custom module with no software coding.
Universal List is Perfect For:
§ Product Catalogs - Item number, description, price, etc. Add tables for categories, manufacturers, sizes/colors, etc. Users can search, sort, view details, and link to an external payment provider or shopping cart.
§ CRM or Other Contact-Related Applications - Manage relationships between people, organizational structures, contact information, etc.
§ Simple lists like Articles, Blogs,
§ Real Estate catalogs