Introduction ChilliDB provides a collection of web controls which may be integrated into your website by your developers with minimal programming skills and a basic understanding of HTML. All of the complexities are taken care of by the ChilliDB web controls which your web developers use to interact with your ChilliDB system. The following figure shows how visitors to your website would seamlessly interact with the ChilliDB web controls which in turn would capture information which in turn would be recorded directly into your ChilliDB system. This document is intended to provide ChilliDB administrators the information relating to the actual business functions performed by the ChilliDB web controls and the steps necessary to configure ChilliDB to hold the information captured from your website. A second document called “ChilliDB Web Controls Developers Guide” provides the information necessary to integrate your website with the ChilliDB web controls which you should provide to your website developers. 1.1 Skills Required This document Assumes that the person following it is experienced with the followingL ChilliDB o Creation and Maintenance of ChilliDB records and reference data 2 Subscription Management 2.1 Overview This collection of web controls provides the functionality to allow visitors to your website the ability to register onto one or more ChilliDB Distribution Lists which are identified for being connected to your website during the setup stage covered in the Configuring ChilliDB section of this document. In order to capture subscriptions on your website, the visitors to your website will need to provide some basic information which can be used to create the subscription against the nominated Distribution Lists. If necessary, a Contact record will also be created within ChilliDB at the same time. The following basic information will be requested of the visitor to your site through the web control form fields: Email address – the address which will be registered onto the selected Distribution Lists. Given Name – used to create the Contact in ChilliDB if required. Surname – used to create the Contact in ChilliDB if required. Your Subscriptions – a selection of one or more nominated Distribution Lists from within your ChilliDB system to which visitors can choose to subscribe A sample subscription page can be seen in the following figure. This is a default look for this web control, but yours can be styled to look more like your website by your developers. 2.2 Configuring ChilliDB You will need to configure some data within your ChilliDB to service the online subscriptions which will be processed through the ChilliDB web controls on your website. You will need to: Create a new organisation or identify an existing Organisation o Any Contacts created during the subscription process will be assigned to this
Organisation. o For example you could create an Organisation called “Website Subscribers”
which is easy to remember and would easily allow you to search for any
Contacts linked to that Organisation within ChilliDB and move them around. Create new Distribution List(s) or identify existing Distribution List(s). o These will be exposed onto your website as potential Distribution Lists to which
your website visitors can subscribe Create a new Contact Type or identify an existing Contact Type o Any contacts created during the subscription process will be categorised with
this Contact Type o For example, you could create one called “Website Subscribers”, which is easy
to remember and would easily allow you to search for any Contacts created
within ChilliDB and move them around. Identify a ChilliDB User o This user will receive any ChilliDB Alerts to notify them when new subscriptions
have been created within ChilliDB. Once the above data has been created or obtained, the next stage is to configure the contents of the ChilliDB web controls which are going to appear on your website. 2.3 Configuring ChilliDB Web Controls The ChilliDB Web Integration Configuration application allows you to modify the content elements of the ChilliDB web controls such as the text of the web control page heading, section heading, page text, alert message, and the list items via a configuration screen. The configuration screen also allows you to customise the notification message of the emails or alerts which you would like to set against the new subscription event. The screen to configure the ChilliDB web controls contents can be accessed from your ChilliDB system through the "Manage ChilliDB Webcontrols" link when you go to the System Management screen. In order to access the ChilliDB Web Integration Configuration application, you will need to perform the following steps: 1. If you have not logged in, please login into your ChilliDB system using your username
and password 2. Navigate to the System Management screen by selecting the following menu item from
the ChillIDB top menu: System > System Management > Manage Note: If you do not have the menu item specified above, please contact your ChilliDB
administrator to enable the permission for you to access the screen. 3. Click the "Manage ChilliDB Webcontrols" link on the screen. Note: If you cannot find the “Manage ChilliDB Web Controls" link on the screen, please
contact the ChilliDB Support Team to enable this link for you. The ChilliDB Support
Team can be contacted via email at helpdesk@chillidb.com. 4. Clicking the “Manage ChilliDB Web Controls” link will bring you to the web controls
welcome screen as shown below. Click on subscriptions to manage subscription web
controls 5. The subscription management configuration screen is accessed by editing or creating
a new subscription web control. It allows you to configure the information shown on
the subscription page on your website, which Distribution List visitors may subscribe
to, where new Contacts and Organisations are created, and who is notified when
subscriptions are processed. Each of the configurable areas will be explained in more detail below: a. Distribution List available on your website: The section controls the Distribution List items that are going to be exposed as
potential lists for the website visitor to subscribe into on your website. The
Distribution List items list selection will be obtained from your ChilliDB system. b. ChilliDB Contact Defaults for Registration: This section controls the handling of the new Contact registration in the ChilliDB
system when the website visitor has opted to subscribe into ChilliDB Distribution
List items. The ChilliDB system will automatically create a Contact to be
associated with the subscribed visitor and then assign the Contact record to the
visitor’s selected Distribution List. The section allows you to assign the default Organisation and Contact Type for the
new visitor’s registered Contact. c. Notifications and Alerts for new Registration: This section controls the notification and alerts when the new visitor has
subscribed to the Distribution List via the web controls. You will be able to enable
email notifications to be sent to the visitors when they have subscribed into the
lists from your website. The section offers the capability to customise the email
subject and body texts for the email notifications. The section also allows you to
enable ChilliDB Alerts to be sent to your staff when there is a new visitor who has
subscribed to the Distribution List via your website. You will be able to configure
who will receive the alerts as well as set the alert text, importance, and comments. d. Customise the ChilliDB Web Controls Website Content: This section offers the capability to customise the text elements which appear in
the ChilliDB Web Controls. You will be able to change the Page Heading, Section
Heading, Page Text, and Page Alert text elements to suit your needs. The styling
appearance of these text elements will be explained in detail within the ChilliDB
Web Controls Developers Guide document. 6. Once you are satisfied with the changes made to your subscription management,
you should select the "save" option to save your changes. You should then refresh
the Subscription page on your website to see those changes and test that the
process is working how you would like it to. You may then close the Subscription
Management screen and return to ChilliDB 2.4 Processing Rules Subscriptions to the Distribution Lists are registered into your ChilliDB system using the information entered into the ChilliDB web control. When the user fills out the data collection fields, the subscription web control will: 1. Check if that contact exists within ChilliDB using the provided Email and Surname
Values If no Contact with that Surname and Email exists, then the new Contact will be
created and they will be registered onto the selected Distribution Lists. Note: All Contacts created are allocated to a pre-nominated Organisation. The
email address will be registered in ChilliDB as a “Business Email” address. If the Contact is found within ChilliDB, then the subscription web control will check if
that Contact has previously been subscribed to each selected Distribution List with
that email address and: If the Contact is already subscribed to the selected Distribution List, then the visitor to your site will be notified that they have already subscribed to this list. If the Contact is not already subscribed, then they will be subscribed to the selected Distribution Lists The subscriber to your Distribution Lists will receive a welcome email informing them thay they have been subscribed to your Distribution Lists 2.5 Conclusion Now that you have configured your ChilliDB system to support online subscriptions, you should have your website developers use the ChilliDB Web Controls Developers Guide to integrate the ChilliDB web controls into your website. 3 Membership Management 3.1 Overview These controls provide the ability to expose features of the “Membership” Module to visitors to your website. In order to capture applications on your website, visitors will need to provide some basic information which can be used to create the Member record against the nominated Membership Package. If necessary, a Contact record will also be created within ChilliDB at the same time. The following basic information will be requested of the visitor to your site through the web control form fields: Email address – the address which will be registered onto the selected Membership Packages. Given Name – used to create the Contact in ChilliDB if required. Surname – used to create the Contact in ChilliDB if required. Membership Package – a selection of one or more nominated Membership Packages from within your ChilliDB system to which visitors can choose to apply. A sample Membership application form can be seen in the following figure. This is a default look for this web control and yours can be styled to look more like your website by your developers. 3.2 Configuring ChilliDB You will need to configure some data within your ChilliDB to allow successful use of the Membership Web Control. You will need to: Create a new organisation or identify an existing Organisation o Any Contacts created during the application process will be assigned to this
Organisation. o For example you could create an Organisation called “Website Memberships"
which is easy to remember and would easily allow you to search for any
Contacts linked to that Organisation within ChilliDB and move them around. Create one or more new Memberships Packages or identify existing Membership Packages o You will need to choose at least one Membership Package to be exposed
onto your website as a potential Membership Package for which your website
visitors can apply to join Create a new Contact Type or identify an existing Contact Type o Any contacts created during the application process will be categorised with
this Contact Type o For example, you could create one called “Website Members”, which is easy
to remember and would easily allow you to search for any Contacts created
within ChilliDB and move them around. Identify a ChilliDB User o This user will receive any ChilliDB Alerts to notify them when new applications
have been created within ChilliDB. Once the above data has been created or obtained, the next stage is to configure the contents of the ChilliDB web controls which are going to appear on your website. 3.3 Configuring ChilliDB Web Controls The ChilliDB Web Integration Configuration application allows you to modify the content elements of the ChilliDB Web Controls, such as the text of the web control page heading, section heading, page text, alert message, and the list items. The configuration application also allows you to customise the notification message of the emails or alerts which you would like to set against the new Membership application event. The screen to configure the ChilliDB Web Controls contents can be accessed from your ChilliDB system through the “Manage ChilliDB Web Controls” link when you go to the System Management screen. In order to access the ChilliDB Web Integration Configuration application, you will need to perform the following steps: 1. If you have not logged in, please login into your ChilliDB system using your username
and password 2. Navigate to the System Management screen by selecting the following menu item from
the ChillIDB top menu: System > System Management > Manage Note: If you do not have the menu item specified above, please contact your ChilliDB
administrator to enable the permission for you to access the screen. 3. Click the "Manage ChilliDB Webcontrols" link on the screen. Note: If you cannot find the “Manage ChilliDB Web Controls" link on the screen, please
contact the ChilliDB Support Team to enable this link for you. The ChilliDB Support
Team can be contacted via email at helpdesk@chillidb.com. 4. Clicking the “Manage ChilliDB Web Controls” link will bring you to the web controls
welcome screen. Click on Membership to manage membership web controls 5. The Membership configuration screen is accessed by editing or creating a new
membership web control. It allows you to configure the information shown on the
membership page on your website, which Membership Packages visitors may
subscribe to, where new Contacts and Organisations are created, and who is notified
when applications are processed. Each of the configurable areas will be explained in more detail below: a. Membership packages available on your website: The section controls the Membership Package items that are going to be exposed
as potential packages for the website visitor to apply to on your website. The
Membership Packages items list selection will be obtained from your
ChilliDB system. b. Membership Options Settings: This section controls how many options a visitor can apply for if the membership
package has additional options added to it c. ChilliDB Contact Defaults for Registration: This section controls the handling of the new Contact registration in the ChilliDB
system when the website visitor has opted to apply for ChilliDB Membership
Package items. The ChilliDB system will automatically create a Contact to be
associated with the new member and then assign the Contact record to the
visitor’s selected Membership Package. This section allows you to assign the default Organisation and Contact Type for
the new visitor’s registered Contact. d. ChilliDB Organisation Defaults for Registration: This section controls the handling of the new Organisation registration in your
ChilliDB system when the website visitor has opted to apply for ChilliDB
Membership Package items. The ChilliDB Web Controls will automatically create
an Organisation to be associated with the visitor’s Contact record. e. Notifications and Alerts for new Registration: This section controls the notification and alerts when the new visitor has applied to
join a Membership Package via the web controls. You will be able to enable email notifications to be sent to the visitors when they
have applied to join packages from your website. The section offers the capability
to customise the email subject and body text for the email notifications. The section also allows you to enable ChilliDB Alerts to be sent to your staff when
there is a new visitor who has applied to join a Membership Package via your
website. You will be able to configure who will receive the alerts as well as set the
alert text, importance, and comments. f. Customise the ChilliDB Web Controls Website Content: This section offers the capability to customise the text elements which appears on
the ChilliDB Web Controls. You will be able to change the page content to suit
your needs. g. ChilliDB Membership Package Registration Label Text Descriptions: Prompts on the form are customised here Once you are satisfied with the changes made to your Membership Management, you should select the “Save” option to save your changes. You should then refresh the Membership page on your website to see those changes and test that the process is working how you would like it to. You may then close the Membership Management screen and return to ChilliDB. 3.4 Processing Rules Information added by users of your website will be added to your ChilliDB system by the Membership Web Control using the following process: If the user supplied an “Organisation Name” value that Organisation record is retrieved or, if it doesn’t exist, created. If the Organisation Name field is blank, the Organisation defined in the configuration is used. ChilliDB is then searched for a Contact record using the “Last Name” and “Email” values supplied by the user. If no contact is found which matches these two fields, a new Contact record is created. In either case, a Contact being found or a new one created, the Organisation from the previous step is associated with the Contact record if it is not already. Once both the Contact and their associated Organisation are identified, the Member is added to the Membership Package. 3.5 Conclusion Now that your system is configured with the ability to have Members apply for Membership Packages via the ChilliDB Web Controls, you should have your website developers use the ChilliDB Web Controls Developers Guide to integrate the Membership Web Control into your website 4 Event Management 4.1 Overview These controls provide the ability to expose features of the “Events” Module to visitors of your website. In order to sign-up for Events on your website, visitors will need to provide some basic information which can be used to create an “Attendee” record for the nominated Event. If necessary, a Contact record will also be created within ChilliDB at the same time. The following basic information will be requested of the visitor to your site through the web control form fields: Email address – the address which will be registered onto the selected Events. Given Name – used to create the Contact in ChilliDB if required. Surname – used to create the Contact in ChilliDB if required. A sample Membership application form can be seen in the following figure. This is a default look for this web control and yours can be styled to look more like your website by your developers. 4.2 Configuring ChilliDB You will need to configure some data within your ChilliDB to allow successful use of the Event Web Control. You will need to: Create a new organisation or identify an existing Organisation o Any Contacts created during the application process will be assigned to this
Organisation. o For example you could create an Organisation called “Website Events"
which is easy to remember and would easily allow you to search for any
Contacts linked to that Organisation within ChilliDB and move them around. Create one or more new Events or identify existing Events o You will need to choose at least one Event to be exposed onto your website as
a potential Event for which your website visitors can apply to Attend Create a new Contact Type or identify an existing Contact Type o Any contacts created during the application process will be categorised with
this Contact Type o For example, you could create one called “Website Event Attendees”, which is
easy to remember and would easily allow you to search for any Contacts
created within ChilliDB and move them around. Identify a ChilliDB User o This user will receive any ChilliDB Alerts to notify them when new attendee
records have been created within ChilliDB. Once the above data has been created or obtained, the next stage is to configure the contents of the ChilliDB web controls which are going to appear on your website. 4.3 Configuring ChilliDB Web Controls The ChilliDB Web Integration Configuration application allows you to modify the content elements of the ChilliDB Web Controls, such as the text of the web control page heading, section heading, page text, alert message, and the list items. The configuration application also allows you to customise the notification message of the emails or alerts which you would like to set against the new Event registration event. The screen to configure the ChilliDB Web Controls contents can be accessed from your ChilliDB system through the “Manage ChilliDB Webcontrols” link when you go to the System Management screen. In order to access the ChilliDB Web Integration Configuration application, you will need to perform the following steps: 1. If you have not logged in, please login into your ChilliDB system using your username
and password 2. Navigate to the System Management screen by selecting the following menu item from
the ChillIDB top menu: System > System Management > Manage Note: If you do not have the menu item specified above, please contact your ChilliDB
administrator to enable the permission for you to access the screen. 3. Click the "Manage ChilliDB Webcontrols" link on the screen. Note: If you cannot find the “Manage ChilliDB Web Controls" link on the screen, please
contact the ChilliDB Support Team to enable this link for you. The ChilliDB Support
Team can be contacted via email at helpdesk@chillidb.com. 4. Clicking the “Manage ChilliDB Web Controls” link will bring you to the web controls
welcome screen. Click on Events to manage event web controls 5. The Event configuration screen is accessed by editing or creating a new
membership web control. It allows you to configure the information shown on the
Event registration page on your website, which Events visitors may apply to, where
new Contacts and Organisations are created, and who is notified when registrations
are processed. Each of the configurable areas will be explained in more detail below: a. ChilliDB Event Defaults for controlling Event appearances on your Website: This section controls which event items are going to be exposed on your website
and some basics regarding their appearance. This also shows whether the Events
or sessions are shown and the number of days ahead events are displayed on the
website. b. ChilliDB Contact Defaults for Registration: This section controls the handling of the new Contact registration in the ChilliDB
system when the website visitor has opted to register for ChilliDB Event items.
The ChilliDB system will automatically create a Contact to be associated with the
registered visitor and then assign the Contact record to the
visitor’s selected Event Registration This section allows you to assign the default Organisation and Contact Type for
the new visitor’s registered Contact. c. ChilliDB Organisation Defaults for Registration: This section controls the handling of the new Organisation registration in your
ChilliDB system when the website visitor has opted to register for ChilliDB Event
items. The ChilliDB Web Controls will automatically create an Organisation to be
associated with the visitor’s Contact record. d. Notifications and Alerts for new Registration: This section controls the notification and alerts when the new visitor has
registered on an Event via the web controls. You will be able to enable email notifications to be sent to the visitors when they
have registered on events from your website. The section offers the capability to
customise the email subject and body text for the email notifications. This section also allows you to enable ChilliDB Alerts to be sent to your staff when
there is a new visitor who has registered on an Event via your website. You will be
able to configure who will receive the alerts as well as set the alert text, importance,
and comments e. Customise the ChilliDB Web Controls Website Content: This section offers the capability to customise the text elements which appears on
the ChilliDB Web Controls. You will be able to change the page content to suit
your needs. f. ChilliDB Event Label Text Descriptions: Prompts on the form are customised here Once you are satisfied with the changes made to your Event Management, you should select the “Save” option to save your changes. You should then refresh the Event page on your website to see those changes and test that the process is working how you would like it to. You may then close the Event Management screen and return to ChilliDB. 4.4 Processing Rules Information added by users of your website will be added to your ChilliDB system by the Event Web Control using the following process: 1. If the user supplied an “Organisation Name” value, that Organisation record is
retrieved or, if it doesn’t exist, created. If the Organisation Name field is blank, the
Organisation defined in the configuration is used. 2. ChilliDB searches for a Contact record using the “Last Name” and “Email” values
supplied by the user. If no contact is found which matches these two fields, a new
Contact record is created. In either case, a Contact being found or new one created, the Organisation from the
previous step is associated with the Contact record if it is not already. 3. Once both the Contact and their associated Organisation are identified, an Event
Registration record is added with the status of “Registered Not Paid”. 4.5 Conclusion Now your system is configured with the ability to have visitors request attendance at an Event via the ChilliDB Web Controls, you should have your website developers use the ChilliDB Web Controls Developers Guide to integrate the Event Web Control into your website. Was this article helpful?
