Difference between revisions of "Developer References"
(→Core Content Definitions) |
(→Core Content Definitions) |
||
Line 108: | Line 108: | ||
; Data Sources : | ; Data Sources : | ||
* ConnString | * ConnString | ||
− | + | ; Tables : | |
* DataSourceID | * DataSourceID | ||
− | + | ; Content : | |
* ContentTableID | * ContentTableID | ||
* AuthoringTableID | * AuthoringTableID | ||
Line 133: | Line 133: | ||
* IsBaseContent | * IsBaseContent | ||
* InstalledByCollectionID | * InstalledByCollectionID | ||
− | + | ; Content Fields : | |
* ContentID | * ContentID | ||
* Type | * Type | ||
Line 172: | Line 172: | ||
* createResourceFilesOnRoot | * createResourceFilesOnRoot | ||
* prefixForRootResourceFiles | * prefixForRootResourceFiles | ||
− | + | ; Content Field Help : | |
* FieldID | * FieldID | ||
* HelpDefault | * HelpDefault | ||
* HelpCustom | * HelpCustom | ||
− | + | ; Content Field Types : | |
* EditorAddonId | * EditorAddonId | ||
− | + | ; Add-on Content Field Type Rules : | |
* addonID | * addonID | ||
* contentFieldTypeID | * contentFieldTypeID | ||
− | + | ; Sort Methods : | |
* OrderByClause | * OrderByClause | ||
− | + | ; Content Categories===== | |
− | + | ; Visit Summary : | |
* DateNumber | * DateNumber | ||
* TimeNumber | * TimeNumber | ||
Line 197: | Line 197: | ||
* BotVisits | * BotVisits | ||
* NoCookieVisits | * NoCookieVisits | ||
− | + | ; Page View Summary : | |
* DateNumber | * DateNumber | ||
* TimeNumber | * TimeNumber | ||
Line 208: | Line 208: | ||
* BotPageViews | * BotPageViews | ||
* NoCookiePageViews | * NoCookiePageViews | ||
− | + | ; Visitors : | |
* MemberID | * MemberID | ||
* OrderID | * OrderID | ||
* ForceBrowserMobile | * ForceBrowserMobile | ||
− | + | ; Visits : | |
* StartTime | * StartTime | ||
* StartDateValue | * StartDateValue | ||
Line 237: | Line 237: | ||
* Mobile | * Mobile | ||
* Bot | * Bot | ||
− | + | ; Viewings : | |
* VisitID | * VisitID | ||
* VisitorID | * VisitorID | ||
Line 252: | Line 252: | ||
* ExcludeFromAnalytics | * ExcludeFromAnalytics | ||
* PageTitle | * PageTitle | ||
− | + | ; Admin Menuing : | |
* AdminOnly | * AdminOnly | ||
* DeveloperOnly | * DeveloperOnly | ||
Line 265: | Line 265: | ||
* NavIconTitle | * NavIconTitle | ||
* InstalledByCollectionID | * InstalledByCollectionID | ||
− | + | ; Menu Entries : | |
* ParentID | * ParentID | ||
* NavIconType | * NavIconType | ||
* NavIconTitle | * NavIconTitle | ||
− | + | ; Navigator Entries : | |
* ParentID | * ParentID | ||
− | + | ; Report Rules : | |
* Browser | * Browser | ||
* Address | * Address | ||
− | + | ; Trap Log : | |
* Host | * Host | ||
* Path | * Path | ||
Line 281: | Line 281: | ||
* Resolved | * Resolved | ||
* Resolution | * Resolution | ||
− | + | ; Site Properties : | |
* FieldValue | * FieldValue | ||
− | + | ; Admin Site Properties===== | |
− | + | ; Topics : | |
* PublicJoin | * PublicJoin | ||
* AllowBulkEmail | * AllowBulkEmail | ||
* Pages | * Pages | ||
− | + | ; Topic Rules : | |
* TopicID | * TopicID | ||
* ContentID | * ContentID | ||
* RecordID | * RecordID | ||
* ContentRecordKey | * ContentRecordKey | ||
− | + | ; Page Content Topic Rules : | |
* TopicID | * TopicID | ||
* PageID | * PageID | ||
− | + | ; Member Topic Rules : | |
* TopicID | * TopicID | ||
* MemberID | * MemberID | ||
− | + | ; Topic Habits : | |
* MemberID | * MemberID | ||
* TopicID | * TopicID | ||
Line 305: | Line 305: | ||
* Score | * Score | ||
* ContentRecordKey | * ContentRecordKey | ||
− | + | ; Languages : | |
* HTTP_Accept_Language | * HTTP_Accept_Language | ||
− | + | ; People : | |
<blockquote> | <blockquote> | ||
The people table holds records that represent users. It has by default one child content definition, Members. : | The people table holds records that represent users. It has by default one child content definition, Members. : | ||
Line 369: | Line 369: | ||
</blockquote> | </blockquote> | ||
− | + | ; Members : | |
Members is a child content of People. | Members is a child content of People. | ||
− | + | ; Groups : | |
<blockquote> | <blockquote> | ||
Groups a collections of people, like a mailing list, or a committee. | Groups a collections of people, like a mailing list, or a committee. | ||
Line 382: | Line 382: | ||
</blockquote> | </blockquote> | ||
− | + | ; Group Rules : | |
Group rules are records that create editing rights for a groups. When a rule is created, users in the selected group can edit records in the selected content. | Group rules are records that create editing rights for a groups. When a rule is created, users in the selected group can edit records in the selected content. | ||
<blockquote> | <blockquote> | ||
Line 391: | Line 391: | ||
</blockquote> | </blockquote> | ||
− | + | ; Member Rules : | |
Records that indicate if a user is in a group. | Records that indicate if a user is in a group. | ||
<blockquote> | <blockquote> | ||
Line 399: | Line 399: | ||
</blockquote> | </blockquote> | ||
− | + | ; Organizations : | |
The organizations table represents a list of companies with which users may be associated. | The organizations table represents a list of companies with which users may be associated. | ||
<blockquote> | <blockquote> | ||
Line 422: | Line 422: | ||
</blockquote> | </blockquote> | ||
− | + | ; Page Content : | |
* Headline | * Headline | ||
* Copyfilename | * Copyfilename | ||
Line 479: | Line 479: | ||
* LinkAlias | * LinkAlias | ||
* Topics | * Topics | ||
− | + | ; Page Content Block Rules : | |
* GroupID | * GroupID | ||
* RecordID | * RecordID | ||
− | + | ; Email : | |
* Subject | * Subject | ||
* FromAddress | * FromAddress | ||
Line 504: | Line 504: | ||
* StylesFilename | * StylesFilename | ||
* BlockSiteStyles | * BlockSiteStyles | ||
− | + | ; Email Style Rules : | |
* emailId | * emailId | ||
* sharedStylesId | * sharedStylesId | ||
− | + | ; Group Email : | |
* Submitted | * Submitted | ||
* Sent | * Sent | ||
Line 513: | Line 513: | ||
* ConditionPeriod | * ConditionPeriod | ||
* ConditionExpireDate | * ConditionExpireDate | ||
− | + | ; System Email : | |
* ConditionID | * ConditionID | ||
* ConditionPeriod | * ConditionPeriod | ||
Line 521: | Line 521: | ||
* Submitted | * Submitted | ||
* Sent | * Sent | ||
− | + | ; Conditional Email : | |
* ToAll | * ToAll | ||
* Submitted | * Submitted | ||
* Sent | * Sent | ||
− | + | ; Email Groups : | |
* EmailID | * EmailID | ||
* GroupID | * GroupID | ||
− | + | ; Email Topics : | |
* EmailID | * EmailID | ||
* TopicID | * TopicID | ||
− | + | ; Email Drops : | |
* DateAdded | * DateAdded | ||
* EmailID | * EmailID | ||
− | + | ; Email Log : | |
* LogType | * LogType | ||
* SendStatus | * SendStatus | ||
Line 546: | Line 546: | ||
* VisitID | * VisitID | ||
* DateBlockExpires | * DateBlockExpires | ||
− | + | ; Email Templates : | |
* Link | * Link | ||
* Source | * Source | ||
* BodyHTML | * BodyHTML | ||
− | + | ; Email Wizards : | |
* EmailTypeID | * EmailTypeID | ||
* IncludeTemplateForm | * IncludeTemplateForm | ||
Line 567: | Line 567: | ||
* IncludeConditionPeriod | * IncludeConditionPeriod | ||
* DefaultConditionPeriod | * DefaultConditionPeriod | ||
− | + | ; Content Watch : | |
* Contentid | * Contentid | ||
* Recordid | * Recordid | ||
Line 576: | Line 576: | ||
* WhatsNewDateExpires | * WhatsNewDateExpires | ||
* ContentRecordKey | * ContentRecordKey | ||
− | + | ; Content Watch Lists : | |
* AllowRSS | * AllowRSS | ||
* RSSFilename | * RSSFilename | ||
Line 583: | Line 583: | ||
* RSSLink | * RSSLink | ||
* RSSDateUpdated | * RSSDateUpdated | ||
− | + | ; Content Watch List Rules : | |
* ContentWatchID | * ContentWatchID | ||
* ContentWatchListID | * ContentWatchListID | ||
− | + | ; See Also : | |
* ContentID | * ContentID | ||
* RecordID | * RecordID | ||
* Link | * Link | ||
* Brief | * Brief | ||
− | + | ; Paths===== | |
− | + | ; Path Rules : | |
* GroupID | * GroupID | ||
* PathID | * PathID | ||
− | + | ; Notes : | |
* MemberID | * MemberID | ||
* FromEmail | * FromEmail | ||
Line 606: | Line 606: | ||
* ReadVisitID | * ReadVisitID | ||
* DateExpires | * DateExpires | ||
− | + | ; States : | |
* Abbreviation | * Abbreviation | ||
* SalesTax | * SalesTax | ||
Line 612: | Line 612: | ||
* FIPSState | * FIPSState | ||
* StateRegionID | * StateRegionID | ||
− | + | ; Countries : | |
* Abbreviation | * Abbreviation | ||
* DomesticShipping | * DomesticShipping | ||
− | + | ; Images : | |
* ImageFilename | * ImageFilename | ||
* Width | * Width | ||
Line 632: | Line 632: | ||
* ViewingsMax | * ViewingsMax | ||
* NewWindow | * NewWindow | ||
− | + | ; Properties : | |
* TypeID | * TypeID | ||
* KeyID | * KeyID | ||
* FieldValue | * FieldValue | ||
− | + | ; Alerts : | |
* MemberID | * MemberID | ||
* ToMemberID | * ToMemberID | ||
Line 642: | Line 642: | ||
* RemoteMonitor | * RemoteMonitor | ||
− | + | ; Authoring Controls : | |
* ContentID | * ContentID | ||
* RecordID | * RecordID | ||
Line 648: | Line 648: | ||
* DateExpires | * DateExpires | ||
* ContentRecordKey | * ContentRecordKey | ||
− | + | ; Search Keywords : | |
* Count | * Count | ||
* VisitID | * VisitID | ||
− | + | ; Shared Styles Include Rules : | |
* StyleID | * StyleID | ||
* IncludedStyleID | * IncludedStyleID | ||
− | + | ; Shared Styles : | |
* StyleFilename | * StyleFilename | ||
* AlwaysInclude | * AlwaysInclude | ||
Line 663: | Line 663: | ||
* Templates | * Templates | ||
* SharedStyles | * SharedStyles | ||
− | + | ; Shared Styles Add-on Rules : | |
* AddonID | * AddonID | ||
* StyleID | * StyleID | ||
− | + | ; Scripting Modules : | |
* Code | * Code | ||
− | + | ; Scripting Languages===== | |
− | + | ; Add-on Scripting Module Rules : | |
* AddonID | * AddonID | ||
* ScriptingModuleID | * ScriptingModuleID | ||
− | + | ; Add-on Include Rules : | |
* AddonID | * AddonID | ||
* IncludedAddonID | * IncludedAddonID | ||
− | + | ; Add-on Content Trigger Rules : | |
* AddonID | * AddonID | ||
* ContentID | * ContentID | ||
− | + | ; Add-on Events===== | |
− | + | ; Add-on Event Throwers : | |
* eventId | * eventId | ||
* collectionId | * collectionId | ||
− | + | ; Add-on Event Catchers : | |
* addonId | * addonId | ||
* eventId | * eventId | ||
− | + | ; Add-ons : | |
* OnPageStartEvent | * OnPageStartEvent | ||
* BlockDefaultStyles | * BlockDefaultStyles | ||
Line 750: | Line 750: | ||
* ScriptingModules | * ScriptingModules | ||
* Events | * Events | ||
− | + | ; Aggregate Functions===== | |
− | + | ; Aggregate Function Scripts : | |
* ObjectProgramID | * ObjectProgramID | ||
* Copy | * Copy | ||
− | + | ; Aggregate Function Objects : | |
* Link | * Link | ||
* Copy | * Copy | ||
− | + | ; Aggregate Function Replacements : | |
* ObjectProgramID | * ObjectProgramID | ||
* Link | * Link | ||
− | + | ; Add-on Collection Parent Rules : | |
* ParentID | * ParentID | ||
* ChildID | * ChildID | ||
− | + | ; Add-on Collection CDef Rules : | |
* ContentID | * ContentID | ||
* CollectionID | * CollectionID | ||
− | + | ; Add-on Collection Module Rules : | |
* ScriptingModuleID | * ScriptingModuleID | ||
* CollectionID | * CollectionID | ||
− | + | ; Add-on Collections : | |
* System | * System | ||
* Updatable | * Updatable | ||
Line 786: | Line 786: | ||
* DataRecordList | * DataRecordList | ||
* Events | * Events | ||
− | + | ; Portals===== | |
− | + | ; Portal Add-on Rules : | |
* PortalID | * PortalID | ||
* AddonID | * AddonID | ||
− | + | ; Library Folders : | |
* Description | * Description | ||
* ParentID | * ParentID | ||
− | + | ; Library Folder Rules : | |
* FolderID | * FolderID | ||
* GroupID | * GroupID | ||
− | + | ; Library Files : | |
* FileTypeID | * FileTypeID | ||
* Description | * Description | ||
Line 808: | Line 808: | ||
* DateExpires | * DateExpires | ||
* AltText | * AltText | ||
− | + | ; Library File Types : | |
* ExtensionList | * ExtensionList | ||
* IconFilename | * IconFilename | ||
Line 817: | Line 817: | ||
* IsDownload | * IsDownload | ||
* DownloadIconFilename | * DownloadIconFilename | ||
− | + | ; Library File Log : | |
* FileID | * FileID | ||
* VisitID | * VisitID | ||
* MemberID | * MemberID | ||
− | + | ; Link Forwards : | |
* SourceLink | * SourceLink | ||
* DestinationLink | * DestinationLink | ||
* Viewings | * Viewings | ||
* GroupID | * GroupID | ||
− | + | ; Link Aliases : | |
* Link | * Link | ||
* PageID | * PageID | ||
* QueryStringSuffix | * QueryStringSuffix | ||
− | + | ; Domains : | |
* TypeID | * TypeID | ||
* RootPageID | * RootPageID | ||
Line 840: | Line 840: | ||
* Visited | * Visited | ||
* allowCrossLogin | * allowCrossLogin | ||
− | + | ; Page Templates : | |
* BodyHTML | * BodyHTML | ||
* BodyTag | * BodyTag | ||
Line 855: | Line 855: | ||
* Source | * Source | ||
* Domains | * Domains | ||
− | + | ; Template Domain Rules : | |
* templateId | * templateId | ||
* domainId | * domainId | ||
− | + | ; Shared Styles Template Rules : | |
* TemplateID | * TemplateID | ||
* StyleID | * StyleID | ||
− | + | ; Site Sections : | |
* Caption | * Caption | ||
* TemplateID | * TemplateID | ||
Line 874: | Line 874: | ||
* JSFilename | * JSFilename | ||
* JSEndBody | * JSEndBody | ||
− | + | ; Section Block Rules : | |
* GroupID | * GroupID | ||
* SectionID | * SectionID | ||
− | + | ; Meta Content : | |
* MetaDescription | * MetaDescription | ||
* MetaKeywordList | * MetaKeywordList | ||
Line 883: | Line 883: | ||
* ContentID | * ContentID | ||
* RecordID | * RecordID | ||
− | + | ; Meta Keywords===== | |
− | + | ; Meta Keyword Rules : | |
* MetaContentID | * MetaContentID | ||
* MetaKeywordID | * MetaKeywordID | ||
− | + | ; Aggregate Access : | |
* Link | * Link | ||
− | + | ; Copy Content : | |
* Copy | * Copy | ||
− | + | ; User Form Response : | |
* Copy | * Copy | ||
* DateAdded | * DateAdded | ||
* VisitID | * VisitID | ||
− | + | ; Tasks : | |
* Command | * Command | ||
* DataSource | * DataSource | ||
Line 905: | Line 905: | ||
* DateCompleted | * DateCompleted | ||
* ResultMessage | * ResultMessage | ||
− | + | ; Dynamic Menus : | |
* Depth | * Depth | ||
* Layout | * Layout | ||
Line 913: | Line 913: | ||
* StylePrefix | * StylePrefix | ||
* StylesFilename | * StylesFilename | ||
− | + | ; Dynamic Menu Section Rules : | |
* DynamicMenuID | * DynamicMenuID | ||
* SectionID | * SectionID | ||
− | + | ; Custom Reports : | |
* SQLQuery | * SQLQuery | ||
− | + | ; Form Pages : | |
* Instructions | * Instructions | ||
* Body | * Body | ||
− | + | ; Remote Queries : | |
* RemoteKey | * RemoteKey | ||
* QueryTypeID | * QueryTypeID | ||
Line 934: | Line 934: | ||
* DateExpires | * DateExpires | ||
* VisitID | * VisitID | ||
− | + | ; Wrappers : | |
* copytext | * copytext | ||
* targetstring | * targetstring | ||
Line 943: | Line 943: | ||
* stylesfilename | * stylesfilename | ||
* OtherHeadTags | * OtherHeadTags | ||
− | + | ; Activity Log : | |
* MemberID | * MemberID | ||
* OrganizationID | * OrganizationID | ||
Line 950: | Line 950: | ||
* VisitorID | * VisitorID | ||
* VisitID | * VisitID | ||
− | + | ; Layouts : | |
* Layout | * Layout | ||
* StylesFilename | * StylesFilename | ||
* SharedStyles | * SharedStyles | ||
− | + | ; Shared Styles Layout Rules : | |
* LayoutID | * LayoutID | ||
* StyleID | * StyleID | ||
− | + | ; Site Warnings : | |
* shortDescription | * shortDescription | ||
* location | * location |
Revision as of 22:13, 12 April 2016
This section contains technical information that describes how to use the Contensive framework to develop applications.
Contents
[hide]Technical References
This section includes guides to typical technical tasks needed to host Contensive applications.
Extending Contensive
Contensive can be extended through two mechanisms, script programming on the hosting page and through Add-ons. Each has its advantages and drawbacks. Generally, using add-ons is the easiest and most versatile but in those cases where the add-on framework does not provide enough flexibility, writing scripts is always a fall-back.
Scripting the Host Page
Contensive does not run directly from the web server, but is instantiated from a framework running on the server, such as php. This way it can easily interface to any windows server platform, and be developed on top of any scripting system going forward. We currently use PHP, but ASP and ASPX are also supported.
Contensive creates the website document requested within the Contensive API, so the script page that initiates Contensive is used for the entire site, no matter what URL or content is requested. We call this the host page.
The easiest way to add functionality to the site through a host page script is to use replacement strings. Create an add-on that just leaves a unique string in the content, then in the host page, detect the unique string, run your functionality and replace it in.
Extending Contensive with Add-ons
An Add-on is a group of html, css, JavaScript, programming code, etc that when worked together, provide content or functionality for the site.
More Information
- Tutorials to provide a easy path for developers at Contensive and our clients to begin using our server framework.
Contensive Installation and Setup
Contensive SMS Architectural Overview
- An overview of the system that include more a in-depth discussion of the available features.
Metadata (Content Definitions)
Creating Forms with Multiple Select Fields
Data Sources
Data is stored with a meta data construct called Content Definitions, which is a thin layer backed by the site's database.
Content Definitions
A content definition (cdef) describes a database table. It includes fields which map to each database table field.
To create a new content definition, use the Create Content Definition tool on the Tools navigator menu. To edit a definition, use the Manager Admin Edit tool in the Tools menu. When a content definition is created, the appropriate database fields are created to hold data for it. You can you then use admin site to add, delete and modify records for the content definition.
All content definitions automatically include a core set of fields. The primary key is always and integer named Id.
Child Content Definitions are definitions that are be subordinate to other Definitions. A child inherits the fields of parent. Child definitions are useful to help segmenting records. For instance, you could create a child of Page Content called Meetings Page Content, and assigned editing for this definition to a group. People in that group could edit those pages, but no others.
Content Definition Field Types
Content definition fields must be one of the following types
- Auto Increment
- Boolean
- css file
- Currency
- Date
- File
- Float
- Html
- Html File
- Image
- Integer
- javascript File
- Link
- Long Text
- Lookup
- Many To Many Select
- Member Select
- Redirect
- Resource Link
- Text
- Text File
- Xml File
Basic Content Definition Fields
These fields are included in all Content Definitions
- Active
- ccGuid
- ContentCategoryId
- ContentControlId
- CreatedBy
- CreateKey
- DateAdded
- EditArchive
- EditBlank
- EditSourceid
- Id
- ModifiedBy
- ModifiedDate
- name
- SortOrder
Core Content Definitions
The following is a list of the Content Definitions considered core data and installed when the application is created.
- Data Sources
- ConnString
- Tables
- DataSourceID
- Content
- ContentTableID
- AuthoringTableID
- AllowAdd
- AllowDelete
- AllowWorkflowAuthoring
- AllowContentTracking
- AllowTopicRules
- AllowContentChildTool
- AllowMetaContent
- DeveloperOnly
- AdminOnly
- ParentID
- DefaultSortMethodID
- DropDownFieldList
- EditorGroupID
- Field Definitions
- IconLink
- IconWidth
- IconHeight
- IconSprites
- IsBaseContent
- InstalledByCollectionID
- Content Fields
- ContentID
- Type
- Caption
- ReadOnly
- NotEditable
- LookupContentID
- RedirectContentID
- RedirectPath
- RedirectID
- UniqueName
- TextBuffered
- DefaultValue
- Required
- Password
- Scramble
- HTMLContent
- IndexColumn
- IndexWidth
- Authorable
- IndexSortPriority
- IndexSortDirection
- EditSortPriority
- EditTab
- AdminOnly
- DeveloperOnly
- ManyToManyContentID
- ManyToManyRuleContentID
- ManyToManyRulePrimaryField
- ManyToManyRuleSecondaryField
- MemberSelectGroupID
- RSSTitleField
- RSSDescriptionField
- LookupList
- IsBaseField
- editorAddonID
- InstalledByCollectionID
- createResourceFilesOnRoot
- prefixForRootResourceFiles
- Content Field Help
- FieldID
- HelpDefault
- HelpCustom
- Content Field Types
- EditorAddonId
- Add-on Content Field Type Rules
- addonID
- contentFieldTypeID
- Sort Methods
- OrderByClause
- Content Categories=====
- Visit Summary
- DateNumber
- TimeNumber
- TimeDuration
- AveTimeOnSite
- Visits
- PagesViewed
- NewVisitorVisits
- SinglePageVisits
- AuthenticatedVisits
- MobileVisits
- BotVisits
- NoCookieVisits
- Page View Summary
- DateNumber
- TimeNumber
- TimeDuration
- PageTitle
- PageID
- PageViews
- AuthenticatedPageViews
- MobilePageViews
- BotPageViews
- NoCookiePageViews
- Visitors
- MemberID
- OrderID
- ForceBrowserMobile
- Visits
- StartTime
- StartDateValue
- LastVisitTime
- StopTime
- TimeToLastHit
- VisitorID
- VisitorNew
- MemberID
- MemberNew
- REMOTE_ADDR
- RemoteName
- Browser
- HTTP_VIA
- HTTP_FROM
- HTTP_REFERER
- RefererPathPage
- PageVisits
- CookieSupport
- LoginAttempts
- VerboseReporting
- VisitAuthenticated
- ExcludeFromAnalytics
- Mobile
- Bot
- Viewings
- VisitID
- VisitorID
- MemberID
- Host
- Path
- Page
- QueryString
- Form
- StateOK
- Referer
- PageTime
- RecordID
- ExcludeFromAnalytics
- PageTitle
- Admin Menuing
- AdminOnly
- DeveloperOnly
- ParentID
- NewWindow
- ContentID
- AddonID
- HelpAddonID
- HelpCollectionID
- LinkPage
- NavIconType
- NavIconTitle
- InstalledByCollectionID
- Menu Entries
- ParentID
- NavIconType
- NavIconTitle
- Navigator Entries
- ParentID
- Report Rules
- Browser
- Address
- Trap Log
- Host
- Path
- Page
- CopyFilename
- Resolved
- Resolution
- Site Properties
- FieldValue
- Admin Site Properties=====
- Topics
- PublicJoin
- AllowBulkEmail
- Pages
- Topic Rules
- TopicID
- ContentID
- RecordID
- ContentRecordKey
- Page Content Topic Rules
- TopicID
- PageID
- Member Topic Rules
- TopicID
- MemberID
- Topic Habits
- MemberID
- TopicID
- VisitID
- Score
- ContentRecordKey
- Languages
- HTTP_Accept_Language
- People
The people table holds records that represent users. It has by default one child content definition, Members. :
- FirstName
- Text: The first name of the user. Typically the record's name is saved as firstName + lastName.
- LastName
- Text: The last name of the user. Typically the record's name is saved as firstName + lastName.
- Company
- Text: A text field that can be used for the user's company. Note there is also an OrganizationId which typically is a foreign key to the organizations table.
- Title
- Text: The user's title
- Address
- Text: The first line of the user's address
- Address2
- Text: The second line of the user's address
- City
- Text: The city of the user's address
- State
- Text: The state of the user's address. There is a States content definition that can be used, but to provide the most flexibility, the field is denormalized so states and provinces from other countries can be entered.
- Zip
- Text: The zip code / postal code of the user's address
- Country
- Text: The country of the user's address. There is a Countries content definition that can be used, but to provide the most flexibility, the field is denormalized so other countries can be entered.
- Text: The primary email contact information for the user
- Phone
- Text: The primary phone contact information for the user
- Fax
- Text: The primary fax contact information for the user
- ImageFilename
- File: An image for the user
- ThumbnailFilename
- File: An smaller thumbnail, avatar for user. Typically 100px square
- NotesFilename
- Text File: A text file that can be used for notes about the user.
- ResumeFilename
- Text File: A text file that can be used as a background or resume for the user.
- OrganizationID
- Lookup to Countries: A lookup to the Organizations definition. Typically this is the organization for which the user is associated.
- BillName
- Text: If this user is used as a billing contact, this is the notification name.
- BillEmail
- Text: If this user is used as a billing contact, this is the notification email.
- BillPhone
- Text: If this user is used as a billing contact, this is the notification phone.
- BillFax
- Text: If this user is used as a billing contact, this is the notification fax.
- BillCompany
- Text: If this user is used as a billing contact, this is the notification company.
- BillAddress
- Text: If this user is used as a billing contact, this is the notification address line 1.
- BillAddress2
- Text: If this user is used as a billing contact, this is the notification address line 2.
- BillCity
- Text: If this user is used as a billing contact, this is the notification city.
- BillState
- Text: If this user is used as a billing contact, this is the notification state. There is a States content definition that can be used, but to provide the most flexibility, the field is denormalized so other countries can be entered.
- BillZip
- Text: If this user is used as a billing contact, this is the notification zip.
- BillCountry
- Text: If this user is used as a billing contact, this is the notification country. There is a Countries content definition that can be used, but to provide the most flexibility, the field is denormalized so other countries can be entered.
- ShipName
- Text: If this user has a separate shipping contact, this is the address name.
- ShipCompany
- Text: If this user has a separate shipping contact, this is the address company.
- ShipAddress
- Text: If this user has a separate shipping contact, this is the address line 1.
- ShipAddress2
- Text: If this user has a separate shipping contact, this is the address line 2.
- ShipCity
- Text: If this user has a separate shipping contact, this is the address city.
- ShipState
- Text: If this user has a separate shipping contact, this is the address state. There is a States content definition that can be used, but to provide the most flexibility, the field is denormalized so other countries can be entered.
- ShipZip
- Text: If this user has a separate shipping contact, this is the address zip code / postal code.
- ShipCountry
- Text: If this user has a separate shipping contact, this is the address country. There is a Countries content definition that can be used, but to provide the most flexibility, the field is denormalized so other countries can be entered.
- ShipPhone
- Text: If this user has a separate shipping contact, this is the phone.
- Username
- Text: The user's login username, when authentication is configured to use a username,
- Password
- Text: The user's login password.
- AllowBulkEmail
- Boolean: When true, email can be sent to this user. Set false to block email.
- Admin
- Boolean: When true, this user assumes the Administrator role. Administrators can edit any content and are not effected by page blocking.
- Developer
- Boolean: When true, this user assumes the Developer role. Developers assume all Administrator rights, and can access content definitions, admin features and addons marked developer only.
- DateExpires
- Date: When not empty, this user's authentication method is only valid before this date.
- AutoLogin
- Boolean: When true, and enabled in site properties, this user can be automatically authenticated based only on a persistent cookie.
- AllowToolsPanel
- Boolean: When true, and this user is a content editor, they see the edit tool panel.
- ExcludeFromAnalytics
- Boolean: When true, visits from this user are excluded from visit analytics.
- Visits
- read-only, Integer: The number of times a user has authenticated with this record.
- LastVisit
- Read-only Date: The time and date of the last time a user authenticated with this record.
- CreatedByVisit
- Read-only Boolean: true if this user record was created by a visit.
- LanguageID
- Lookup to languages: The language set by the user's browser during the user's last visit.
- BirthdayDay
- Integer: The day of the month of the user's birthday, 1...31.
- BirthdayMonth
- Integer: The month of the user's birthday, 1...12.
- BirthdayYear
- Integer: The year of the user's birthday.
- StyleFilename
- Css file: Styles that will be added to everypage of the site when this user is authenticated.
- Topics
- Many to Many: A list of the topics from pages visited by this user.
- nickName
- a short name used by some addons.
- Members
Members is a child content of People.
- Groups
Groups a collections of people, like a mailing list, or a committee.
- Caption
- Text: The name of the group used on the public website.
- CopyFilename
- Text File: A description for the group that may be displayed on the public site.
- AllowBulkEmail
- Boolean: When true, this group can be sent group email.
- PublicJoin
- Boolean: When true, this group can be joined by anyone on the public site.
- MembershipReference
- Read-only Redirect: A link to Group Rules, a list of poeple in this group.
- Group Rules
Group rules are records that create editing rights for a groups. When a rule is created, users in the selected group can edit records in the selected content.
- GroupID
- Lookup to Groups: The group associated to this rule.
- ContentID
- Lookup to Content: The content definition that this group can edit.
- AllowAdd
- Boolean: When true, users in this group can add new records to the content.
- AllowDelete
- Boolean: When true, users in this group can delete records from the content.
- Member Rules
Records that indicate if a user is in a group.
- MemberID
- Readonly Lookup into people: The user that is in the group.
- GroupID
- Readonly Lookup into groups: The group in which the user belongs.
- DateExpires
- Date: if not empty, membership in the group is invalid after this date.
- Organizations
The organizations table represents a list of companies with which users may be associated.
- CopyFilename
- Text File: A description for the organiation that may be displayed publically.
- BriefFilename
- Text File: A shorter description that may be used in a list of organizations.
- ContactMemberID
- Lookup into Members: The primary contact in the people definition.
- Address1
- Text: Line 1 of the primary organization address.
- Address2
- Text: Line 2 of the primary organization address.
- City
- Text: The City of the primary organization address.
- State
- Text: The State of the primary organization address.
- Country
- Text: The Country of the primary organization address.
- Zip
- Text: The zip code or postal code of the primary organization address.
- Phone
- Text: The primary phone for the organization, not otherwise associated to a user, like the front desk.
- Fax
- Text: The primary fax for the organization, not otherwise associated to a user.
- Web
- Text: The organization's website.
- Text: The primary email for the organization, not otherwise associated to a user.
- Link
- Text: If provided, the url that should be used for links to the website.
- Viewings
- Read-only Integer: If this organization is displayed in a directory-style list, this integer can be used to count how often the organization details were viewed.
- Clicks
- Read-only Integer: If this organization is displayed in a directory-style list, this integer can be used to count how often the organization's website or link was clicked.
- ImageFilename
- image: The primary image for the record.
- ThumbNailFilename
- Image: A secondary smaller image for the record.
- Page Content
- Headline
- Copyfilename
- ContentPadding
- ContactMemberID
- IsSecure
- TemplateID
- AllowHitNotification
- AllowReturnLinkDisplay
- AllowMetaContentNoFollow
- AllowSeeAlso
- AllowFeedback
- AllowMoreInfo
- AllowPrinterVersion
- AllowEmailPage
- AllowLastModifiedFooter
- AllowMessageFooter
- AllowReviewedFooter
- DateReviewed
- ReviewedBy
- Viewings
- PubDate
- DateExpires
- DateArchive
- ArchiveParentID
- TriggerConditionID
- TriggerConditionGroupID
- TriggerSendSystemEmailID
- TriggerAddGroupID
- TriggerRemoveGroupID
- LinkLabel
- AllowInMenus
- AllowInChildLists
- AllowChildListDisplay
- ChildListSortMethodID
- MenuHeadline
- AllowBrief
- BriefFilename
- Link
- Clicks
- ParentID
- ParentListName
- ChildPagesFound
- ChildListInstanceOptions
- PageLink
- BlockContent
- BlockPage
- BlockGroups
- BlockSourceID
- CustomBlockMessage
- RegistrationGroupID
- JSOnLoad
- JSHead
- JSFilename
- JSEndBody
- LinkAlias
- Topics
- Page Content Block Rules
- GroupID
- RecordID
- Subject
- FromAddress
- TestMemberID
- EmailTemplateID
- CopyFilename
- ConditionID
- ConditionPeriod
- ScheduleDate
- ConditionExpireDate
- ToAll
- AddLinkEID
- AllowSpamFooter
- Submitted
- Sent
- DateAdded
- InlineStyles
- EmailWizardID
- LastSendTestDate
- sharedStylesId
- StylesFilename
- BlockSiteStyles
- Email Style Rules
- emailId
- sharedStylesId
- Group Email
- Submitted
- Sent
- ConditionID
- ConditionPeriod
- ConditionExpireDate
- System Email
- ConditionID
- ConditionPeriod
- ScheduleDate
- ConditionExpireDate
- ToAll
- Submitted
- Sent
- Conditional Email
- ToAll
- Submitted
- Sent
- Email Groups
- EmailID
- GroupID
- Email Topics
- EmailID
- TopicID
- Email Drops
- DateAdded
- EmailID
- Email Log
- LogType
- SendStatus
- ToAddress
- FromAddress
- Subject
- DateAdded
- EmailID
- EmailDropID
- MemberID
- VisitID
- DateBlockExpires
- Email Templates
- Link
- Source
- BodyHTML
- Email Wizards
- EmailTypeID
- IncludeTemplateForm
- DefaultTemplateID
- TemplateFormInstructions
- IncludeContentForm
- DefaultContent
- ContentFormInstructions
- IncludeGroupForm
- GroupFormInstructions
- IncludeSchedule
- AllowSpamFooterDefault
- IncludeAllowSpamFooter
- LinkAuthenticationDefault
- IncludeLinkAuthentication
- IncludeConditionPeriod
- DefaultConditionPeriod
- Content Watch
- Contentid
- Recordid
- Link
- LinkLabel
- Clicks
- AllowWhatsNew
- WhatsNewDateExpires
- ContentRecordKey
- Content Watch Lists
- AllowRSS
- RSSFilename
- RSSTitle
- RSSDescription
- RSSLink
- RSSDateUpdated
- Content Watch List Rules
- ContentWatchID
- ContentWatchListID
- See Also
- ContentID
- RecordID
- Link
- Brief
- Paths=====
- Path Rules
- GroupID
- PathID
- Notes
- MemberID
- FromEmail
- FromName
- FromMemberID
- FromVisitID
- CopyFilename
- NoteRead
- ReadDate
- ReadVisitID
- DateExpires
- States
- Abbreviation
- SalesTax
- CountryID
- FIPSState
- StateRegionID
- Countries
- Abbreviation
- DomesticShipping
- Images
- ImageFilename
- Width
- Height
- Caption
- Align
- ThumbnailFilename
- ThumbnailWidth
- ThumbnailHeight
- Link
- DateExpires
- LastViewDate
- Clicks
- ClicksMax
- Viewings
- ViewingsMax
- NewWindow
- Properties
- TypeID
- KeyID
- FieldValue
- Alerts
- MemberID
- ToMemberID
- EmailOnVisit
- RemoteMonitor
- Authoring Controls
- ContentID
- RecordID
- ControlType
- DateExpires
- ContentRecordKey
- Search Keywords
- Count
- VisitID
- Shared Styles Include Rules
- StyleID
- IncludedStyleID
- Shared Styles
- StyleFilename
- AlwaysInclude
- Prefix
- Suffix
- Add-ons
- Layouts
- Templates
- SharedStyles
- Shared Styles Add-on Rules
- AddonID
- StyleID
- Scripting Modules
- Code
- Scripting Languages=====
- Add-on Scripting Module Rules
- AddonID
- ScriptingModuleID
- Add-on Include Rules
- AddonID
- IncludedAddonID
- Add-on Content Trigger Rules
- AddonID
- ContentID
- Add-on Events=====
- Add-on Event Throwers
- eventId
- collectionId
- Add-on Event Catchers
- addonId
- eventId
- Add-ons
- OnPageStartEvent
- BlockDefaultStyles
- DateAdded
- IconHeight
- IconWidth
- CustomStylesFilename
- IconSprites
- JavaScriptBodyEnd
- OnNewVisitEvent
- RemoteMethod
- CopyText
- SharedStyles
- StylesFilename
- OtherHeadTags
- MetaKeywordList
- OnPageEndEvent
- PageTitle
- IconFilename
- JavaScriptInHead
- JavaScriptOnLoad
- Admin
- Content
- Template
- HelpLink
- NavTypeID
- Help
- Description
- MetaDescription
- EditBlank
- ScriptingCode
- ScriptingTimeout
- inlineScript
- CollectionID
- OnBodyStart
- fieldTypeEditor
- IsInline
- DotNetClass
- Copy
- ArgumentList
- Link
- NavIconType
- OnBodyEnd
- ObjectProgramID
- JSFilename
- RobotsTxt
- IncludedAddons
- FormXML
- InFrame
- Filter
- ScriptingLanguageID
- RemoteAssetLink
- BlockEditTools
- AsAjax
- ProcessServerKey
- Process
- ProcessInterval
- ProcessRunOnce
- ProcessNextRun
- ProcessContentTriggers
- DotNetClassLibrary
- ScriptingEntryPoint
- ScriptingModules
- Events
- Aggregate Functions=====
- Aggregate Function Scripts
- ObjectProgramID
- Copy
- Aggregate Function Objects
- Link
- Copy
- Aggregate Function Replacements
- ObjectProgramID
- Link
- Add-on Collection Parent Rules
- ParentID
- ChildID
- Add-on Collection CDef Rules
- ContentID
- CollectionID
- Add-on Collection Module Rules
- ScriptingModuleID
- CollectionID
- Add-on Collections
- System
- Updatable
- blockNavigatorNode
- helpLink
- Help
- InstallFile
- LastChangeDate
- ChildCollections
- ContentDefinitions
- ScriptingModules
- OtherXML
- wwwFileList
- ContentFileList
- ExecFileList
- DataRecordList
- Events
- Portals=====
- Portal Add-on Rules
- PortalID
- AddonID
- Library Folders
- Description
- ParentID
- Library Folder Rules
- FolderID
- GroupID
- Library Files
- FileTypeID
- Description
- Filename
- FileSize
- FolderID
- Clicks
- Width
- Height
- AltSizeList
- DateExpires
- AltText
- Library File Types
- ExtensionList
- IconFilename
- IsImage
- IsVideo
- IsFlash
- MediaIconFilename
- IsDownload
- DownloadIconFilename
- Library File Log
- FileID
- VisitID
- MemberID
- Link Forwards
- SourceLink
- DestinationLink
- Viewings
- GroupID
- Link Aliases
- Link
- PageID
- QueryStringSuffix
- Domains
- TypeID
- RootPageID
- DefaultTemplateId
- PageNotFoundPageID
- forwardDomainId
- ForwardURL
- NoFollow
- Visited
- allowCrossLogin
- Page Templates
- BodyHTML
- BodyTag
- IsSecure
- Link
- StylesFilename
- SharedStyles
- OtherHeadTags
- MobileBodyHTML
- JSOnLoad
- JSHead
- JSFilename
- JSEndBody
- Source
- Domains
- Template Domain Rules
- templateId
- domainId
- Shared Styles Template Rules
- TemplateID
- StyleID
- Site Sections
- Caption
- TemplateID
- RootPageID
- ContentID
- MenuImageFilename
- MenuImageOverFilename
- HideMenu
- BlockSection
- JSOnLoad
- JSHead
- JSFilename
- JSEndBody
- Section Block Rules
- GroupID
- SectionID
- Meta Content
- MetaDescription
- MetaKeywordList
- OtherHeadTags
- ContentID
- RecordID
- Meta Keywords=====
- Meta Keyword Rules
- MetaContentID
- MetaKeywordID
- Aggregate Access
- Link
- Copy Content
- Copy
- User Form Response
- Copy
- DateAdded
- VisitID
- Tasks
- Command
- DataSource
- SQLQuery
- Filename
- NotifyEmail
- ImportMapFilename
- DateStarted
- DateCompleted
- ResultMessage
- Dynamic Menus
- Depth
- Layout
- FlyoutOnHover
- Delimiter
- FlyoutDirection
- StylePrefix
- StylesFilename
- Dynamic Menu Section Rules
- DynamicMenuID
- SectionID
- Custom Reports
- SQLQuery
- Form Pages
- Instructions
- Body
- Remote Queries
- RemoteKey
- QueryTypeID
- DataSourceID
- SQLQuery
- ContentID
- Criteria
- SortFieldList
- AllowInactiveRecords
- SelectFieldList
- MaxRows
- DateExpires
- VisitID
- Wrappers
- copytext
- targetstring
- javascriptonload
- javascriptinhead
- JSFilename
- javascriptbodyend
- stylesfilename
- OtherHeadTags
- Activity Log
- MemberID
- OrganizationID
- Message
- Link
- VisitorID
- VisitID
- Layouts
- Layout
- StylesFilename
- SharedStyles
- Shared Styles Layout Rules
- LayoutID
- StyleID
- Site Warnings
- shortDescription
- location
- PageID
- description
- count
- DateLastReported
- generalKey
- specificKey