posvur.blogg.se - Call stored procedure wysiwyg webuilder

This service handles the schema of events and the criteria for syncing events (a combination of the periodic and member refresh).

Events Refresh - another automatic job that runs at the beginning of the Member Refresh.

Member Refresh - a full data pull from Netforum that updates the users' Higher Logic objects (communities, security groups, custom demographics, profile information).

Periodic Refresh - an automatic job that runs every 30 minutes to identify users that have changed some field that Higher Logic is reading from Netforum.

There are three Higher Logic services that are included within the Netforum-Enterprise-XML integration: Modifying any of the stored procedures or views will have immediate results on the integration so be careful and test before altering them. This document will explain the various stored procedures and the corresponding views including the specific schema that must be followed for the data to come through correctly. Some stored procedures might simply be used for calling the view and reflecting the same schema. The data that is returned will form the foundation of your Higher Logic site and create all the relevant Higher Logic objects such as communities, demographics, security groups, calendar events, and user profiles.Ī note about the stored procedures and views: The stored procedure's main goal is to be executed from the webservice. The view is responsible for capturing the information and creating the schema. Higher Logic calls Netforum's Webservice to directly execute the stored procedures and views. The Netforum-Enterprise-XML integration with Higher Logic is built off a system of stored procedures and views that are installed on your Netforum SQL database.