Qld govt develops open source record-keeping CMS

In-house development now available to the world

A lack of a suitable record-keeping Web content management system has led one Queensland local government council to develop its own application which has since been released as an open source project.

Thuringowa City Council in mid-North Queensland was looking to deploy an enterprise content management system with the same capacity to keep records of Web content with the same integrity as other types of more regulated content like e-mail and financial documents.

However, when the idea surfaced three years ago there was no significant budget for such a project and council did not perceive the project as a huge requirement.

The council's Web developer Scott Barnett then evaluated a number of open source ECMs and discovered the main constraint among them was a lack of support for record keeping.

"We ended up saying it would be too difficult to modify an existing application as they couldn't publish binary files in a record keeping environment," Barnett said.

To solve the problem, Barnett, with support from his employer, began development of the Stronghold CMS with open source components to ensure records for Web documents were supported inside the application.

"We developed a beta and presented it to management and they thought it was cool and started saying we needed it yesterday," he said, adding Stronghold also had the framework for a legislative compliance system.

After an initial pilot phase, Stronghold went into product about two years ago and now has some 50 people using it throughout the council.

"It's been a frustrating journey from our perspective as a lot of content systems were designed with technology in mind, but we are concerned with publishing and business processes," Barnett said.

Stronghold is written in [ArtId:1241831333|PHP]] with the primary database being PostgreSQL and uses a Samba module for Active Directory integration and single sign-on, and the FCKEditor for WYSIWYG editing of content.

Support for Oracle, MySQL, and SQL Server - using a native database abstraction layer, not the popular PEAR-DB - will be in the next release which is due this month.

Barnett describes Stronghold as providing wiki-style editing of documents, but more user-friendly as wikis have no standard way of storing the data which may need to be retrieved in the future.

"Stronghold can manage multiple domains with the same interface which excludes a whole stack of products," he said.

Once developed, the council did not want Barnett to work on Stronghold full-time so, after some deliberation, the decision was made to release the application as an open source product under the terms of the GNU General Public License (GPL) version 3.

"The council was very apprehensive to release it as an open source project and approval had to come down from executive level," he said. "When you talk to management they ask how they can make money out of it, but then we would have to support other councils. Also, we really leveraged some open source components and we could release it to the public and the public could improve it."

Join the PC World newsletter!

Error: Please check your email address.
Rocket to Success - Your 10 Tips for Smarter ERP System Selection
Keep up with the latest tech news, reviews and previews by subscribing to the Good Gear Guide newsletter.

Rodney Gedda

Computerworld
Show Comments

Most Popular Reviews

Latest Articles

Resources

PCW Evaluation Team

Matthew Stivala

HP OfficeJet 250 Mobile Printer

The HP OfficeJet 250 Mobile Printer is a great device that fits perfectly into my fast paced and mobile lifestyle. My first impression of the printer itself was how incredibly compact and sleek the device was.

Armand Abogado

HP OfficeJet 250 Mobile Printer

Wireless printing from my iPhone was also a handy feature, the whole experience was quick and seamless with no setup requirements - accessed through the default iOS printing menu options.

Azadeh Williams

HP OfficeJet Pro 8730

A smarter way to print for busy small business owners, combining speedy printing with scanning and copying, making it easier to produce high quality documents and images at a touch of a button.

Andrew Grant

HP OfficeJet Pro 8730

I've had a multifunction printer in the office going on 10 years now. It was a neat bit of kit back in the day -- print, copy, scan, fax -- when printing over WiFi felt a bit like magic. It’s seen better days though and an upgrade’s well overdue. This HP OfficeJet Pro 8730 looks like it ticks all the same boxes: print, copy, scan, and fax. (Really? Does anyone fax anything any more? I guess it's good to know the facility’s there, just in case.) Printing over WiFi is more-or- less standard these days.

Ed Dawson

HP OfficeJet Pro 8730

As a freelance writer who is always on the go, I like my technology to be both efficient and effective so I can do my job well. The HP OfficeJet Pro 8730 Inkjet Printer ticks all the boxes in terms of form factor, performance and user interface.

Michael Hargreaves

Windows 10 for Business / Dell XPS 13

I’d happily recommend this touchscreen laptop and Windows 10 as a great way to get serious work done at a desk or on the road.

Featured Content

Latest Jobs

Don’t have an account? Sign up here

Don't have an account? Sign up now

Forgot password?