queXC is a Web-based data cleaning and coding/classification system that takes a data file (such as data collected from a questionnaire) and cleans the text input fields by spacing them and spell checking them. It allows operators to code text fields to existing coding schemes, or to create a coding scheme on the fly. Multiple operators can code and clean simultaneously, with the ability to assign operators to do particular codes. The queXC system includes some coding schemes created from ABS (Australian Bureau of Statistics) data. It can be used as an open source replacement for Nvivo in some situations.
oo.WebsiteTools is a set of basic tools which are needed on almost every Web site. Using these tools speeds up your Web development radically. It consists of three different parts: oo.Admin, oo.Sql, and oo.Ajax. oo.Admin is used to administer the site and allow users to manage their accounts. oo.Sql lets you change database backends without changing your SQL code. oo.Ajax is an AJAX library that can load and update div elements, send forms without reloading the page, and more.
PSX is a PHP framework for creating RESTful APIs. It helps you to build clean URLs serving Web standard formats like JSON, XML, Atom, and RSS. It includes a handler system that abstracts away SQL queries from domain logic, a routing system that executes correct controller method for the location of the controller and the method annotation, and a flexible data system that converts database records into formats like JSON, XML, Atom, and RSS. A lightweight DI container handles dependencies. The controller supports request and response filters that can modify the HTTP request or response, and filters are provided for Basic and Oauth authentication.
XMLToaster is a tool for extracting and loading XML from databases. It provides a modified version of SQL which has XML mapping extenstions. It can be compared to the "for xml" command in MS SQL Server 2008, but it runs on all common databases and scales to handle very large XML mappings without too much complexity. It is used as a Java library to write XML interfaces, but can also be run as a command line tool.
csv2mysql is a Web-based tool that converts CSV files to MySQL tables. It asks for the location of the CSV file, type of the CSV file, and access info (server address, table name, username, and password) for the MySQL database, and lets users map the fields of a CSV file to the fields of a MySQL table.