Member Database

The Membership Manager Member Database is likely the most extensible member database available today!

The Membership Manager Member Database stores data in a SQL database, and may be accessed in many ways: the browser based SharePoint list interface, SharePoint Designer, Web Services and API’s. The documented data schema diagram ships with the Membership Manager Member Database product.

You can easily add new fields, membership levels, types, status and virtually any other organizational specific piece of data you wish to track. Automatically fill the member database by simply populating the provided Excel file with your existing data, and clicking the “Import Member Data” button. The provided Excel file contains the necessary fields and required format.

Nearly all member database customizations may be achieve by simply using the browser interface (for example: adding new fields, marking fields as required, creating forms with full CRUDQ operators (create, read, update, delete, and query), security, roles, rollups, modifying existing lists, creating new lists, exporting data, surfacing external data, etc…

The Member Database offers several APIs that you can use to work with data. The following managed object models provide types and members that allow you to modify member database properties and create and manage list templates and list items:

For code that operates on the server, the Microsoft.SharePoint namespace provides the core classes that represent a list. The Microsoft.SharePoint.Deployment namespace provides an API for migrating content between site collections.

For managed code that operates in the context of client-side Microsoft .NET 3.5 applications or Silverlight applications, the Microsoft.SharePoint.Client namespace provides a subset of the types and members available in the server object model.

For script that operates in the browser, the ECMAScript (JavaScript, JScript) object model of the SP namespace provides a subset of the types and members available in the server object model. The Lists Web service provides methods for working remotely with lists.