Required Registration Option with Registrant Report

Are you responsible for making OCS work -- installing, upgrading, migrating or troubleshooting? Do you think you've found a bug? Post in this forum.

Moderators: jmacgreg, michael, John

Forum rules
The Public Knowledge Project Support Forum is moving to

This forum will be maintained permanently as an archived historical resource, but all new questions should be added to the new forum. Questions will no longer be monitored on this old forum after March 30, 2015.
Posts: 45
Joined: Wed May 29, 2013 10:19 am

Re: Required Registration Option with Registrant Report

Postby jcurtis » Mon Aug 19, 2013 8:16 am

Hi Alec,

Since the fix for the patch, the new registration form elements have been working perfectly.

In Addition, Prasad Rajandran and myself at Science Atlantic developed additional code to write the information from the database into the Registrant Report.

We hope that this could help with the registration forms patch potentially.

To begin, because the title and the description are entered in the same text box, it was decided that generic titles would be generated for each column title (ex. Option 1, Option 2).

The follow are how the following registration form elements are displayed in the .csv:
Check boxes - A number is displayed for each box that is checked (ex. if one and three were checked it would display 1, 3). If the check box is empty, nothing will display.

Radio buttons and drop down menu: Displayed in the same way as the order. (ex. if the 4th option is selected, 4 will appear)

Text boxes - Displayed the way the user entered

Because I wasn't sure how OCS connects to the database, I created a new connection using mysqli_connect(). In order to use this, one must write their database information into the mysqli_connect query.

James Curtis
this is a .inc.php entension
(6.64 KiB) Downloaded 65 times

Posts: 10015
Joined: Wed Aug 10, 2005 12:56 pm

Re: Required Registration Option with Registrant Report

Postby asmecher » Mon Aug 26, 2013 2:59 pm

Hi James,

Thanks for contributing! FYI, it's easier (for me, anyway) to exchange code modifications as patch files, generated by the standard "diff" tool.

For DB queries we use ADODB, which allows queries to support MySQL and PostgreSQL; see the review report plugin for an example.

Alec Smecher
Public Knowledge Project Team

Posts: 45
Joined: Wed May 29, 2013 10:19 am

Re: Required Registration Option with Registrant Report

Postby jcurtis » Tue Sep 10, 2013 10:17 am

Hi Alec,

No problem! I was hoping that this could help in the development of the patch because I found it very useful.

James Curtis

Return to “OCS Technical Support”

Who is online

Users browsing this forum: No registered users and 3 guests