Displaying ICE messages

The ice_messaging drupal module is used to access the MS SQL database containing the received ICE messages.

Some of the drupal 7 documentation still refers to the old syntax for database queries, even while demonstrating the drupal database abstraction layer. The best and most consistent documentation for building database queries is ​http://drupal.org/node/310075

ice_messaging uses the datatables module to provide fancy presentation. The datatables modules requires manual installation of the DataTables jQuery plugin, and this is very fussy about directory names. Just be careful.

Within drupal, switching to the alternative database is done using:

  db_set_active('YourDatabaseKey');

  // execute queries here

  db_set_active(); // without the paramater means set back to the default for the site

This assumes the YourDatabaseKey connection has been defined in /sites/default/settings.php

The sqlsrv project provides a SQL server driver, but it only works on Windows servers. There's a fork of sqlsrv which uses dblib to work on linux: ​http://drupal.org/sandbox/rgeorgy/1775970

To run that, we need to 'sudo apt-get install php5-sybase git' then 'git clone ​http://git.drupal.org/sandbox/rgeorgy/1775970.git dblib_driver_for_sql_server'

Apache needs restarting in order for the php5-sybase / dblib library to be recognised.

Then 'sudo drush dl datatables'. Then do the manual installation of DataTables jQuery plugin, rename the intermediate directory to 'dataTables' and then 'sudo drush en datatables'. That will enable the necessary additional prerequisites.

Then enable the dblib module and set up a link from /includes/database/dblib to the module's dblib directory.

Finally, enable the ice_messaging module. After that, everything should work.

• Note regarding css in datatables - there's a discrepency in the style sheet interactions between the datatables code and the drupal theme code. I have resolved this for our deployment by hard-coding font color and background color into the dataTables/media/css/demo_table.css as follows:

/* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
 * DataTables sorting
 */

.sorting_asc {
        background: url('../images/sort_asc.png') no-repeat center right;
        color: rgb(128,128,128);
}

.sorting_desc {
        background: url('../images/sort_desc.png') no-repeat center right;
        color: rgb(128,128,128);
}

.sorting {
        background: url('../images/sort_both.png') no-repeat center right rgb(255,255,255);
        color: rgb(128,128,128);
}

.sorting_disabled {
        background: rgb(255,255,255);
        color: rgb(128,128,128);
}

.sorting_asc_disabled {
        background: url('../images/sort_asc_disabled.png') no-repeat center right;
        color: rgb(128,128,128);
}

.sorting_desc_disabled {
        background: url('../images/sort_desc_disabled.png') no-repeat center right;
        color: rgb(128,128,128);
}

th:active {
        outline: none;
}

Processing recruitment

As of version 1.1.0, the ice_messaging module also provides one-click loading of patients and GENVASC study enrolment into the CiviCRM database, using the CiviCRM API v3.