Contents

CMS Data!

Video Tutorial: CMS Data!

 

Overview

The CMS Data! feature allows you to search/sort/view/edit/create/delete records in most CMS/SocietyNet database tables.  This is a valuable tool for advanced users who want to drill down directly into data and make changes; as well as average users who just want to view a specific record.

How it Works

The CMS Data! feature is under the System > Data tab.  On that screen, there are two main drop down menus:

  • Database:
    • CMS
    • SocietyNet
  • Table

The data editor is generic and does not specifically know how to handle certain fields - it simply does the best it can.  An example is that if a text field contains <html>, a WYSIWYG editor will automatically be used for editing the field.  The editor recognizes all basic field types, and allows editing of about almost all tables in each database.  Tables must have a primary key; though that PK can be of multiple types: incrementing integer, unique value, and composite.  Tables without a PK are not understood in handling, and therefor not listed as selectable in the drop down menus.

Note: when making changes to tables, you are directly modifying the tables as though you're in SQL Management Studio. This means there is no undo if you delete a record or make a mistake.

Data Editor Features

The Data Editor is an advanced data control, built on our in house technology known as ProjectL and AutoForms.  It is a generic editor which can specifically or automatically handle data tables and fields.  It has several important usability features:

  • Adjustable / best fit width for listing and editing
  • Number of items per page (automatically reduced as low as 3, depending on number of fields in a table)
  • Edit Tall: On / Off - this allows you to edit things wide (floating fields), or tall (line break between fields)
  • Automatic sortable column list
  • Automatic advanced search handling; automatic handling of field data types and search semantics; searches as you type with AJAX
  • Automatic record duplication capability
  • Automatic new record creation, using table field defaults in SQL as value templates
  • Batch editing
  • Batch record duplication
  • Batch deletion
  • JQuery based UI controls for understood fields (WYSIWYG, Date/Time, etc.)
  • Inline AJAX based editing; dynamically selected HTTP GET or POST for faster communication with the server over the internet
  • Special client state field, with reduced size compared to ASP.NET view state, for faster manipulation over the internet