National Data Archive (NADA) is an open source data cataloging system that serves as a portal for researchers to browse, search, compare, apply for access, and download relevant census or survey information. It was originally developed to support the establishment of national survey data archives.
Note: If upgrading from an older version of NADA, make sure to update the database:
CREATE TABLE `survey_data_api` (
`id` int NOT NULL AUTO_INCREMENT,
`sid` int DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`description` varchar(500) DEFAULT NULL,
`db_id` varchar(45) DEFAULT NULL,
`table_id` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
)AUTO_INCREMENT=1;
ALTER TABLE `users` MODIFY COLUMN `forgotten_password_code` varchar(100) DEFAULT NULL;
ALTER TABLE `users` ADD COLUMN `forgotten_code_expiry` int DEFAULT NULL;
For upgrading from NADA 5.3, run these
CREATE TABLE `survey_data_api` (
`id` int NOT NULL AUTO_INCREMENT,
`sid` int DEFAULT NULL,
`title` varchar(255) DEFAULT NULL,
`description` varchar(500) DEFAULT NULL,
`db_id` varchar(45) DEFAULT NULL,
`table_id` varchar(100) DEFAULT NULL,
PRIMARY KEY (`id`)
)AUTO_INCREMENT=1;
ALTER TABLE `users` MODIFY COLUMN `forgotten_password_code` varchar(100) DEFAULT NULL;
ALTER TABLE `users` ADD COLUMN `forgotten_code_expiry` int DEFAULT NULL;
Updated to support PHP 8.x
ALTER TABLE `surveys` ADD `subtitle` varchar(255) DEFAULT NULL;
ALTER TABLE `data_files` ADD `metadata` varchar(5000) DEFAULT NULL;
CREATE TABLE `data_access_whitelist` (
`id` int NOT NULL AUTO_INCREMENT,
`user_id` int DEFAULT NULL,
`repository_id` int DEFAULT NULL,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1;
Note PHP7 has reached end-of-life, this is the last release of NADA supporting PHP 7. All new releases will require PHP 8.
This is a major release with changes to the UI and functionality of NADA. Please visit our demo catalog to see the new features or visit NADA documentation.
- See our guide to upgrade here
Added: Pagination for browsing variables on study detail page Added: Catalog search now supports searching for country by using ISO2, ISO3 or country name Fixed: Database installation script for Microsoft SQL Server (SQLSRV) Updated: Licensed requests admin page optimized to handle large number of requests Updated: Licensed requests 'export to CSV', exports all fields to CSV Updated: Updated version of JQuery to v3.5.1 Updated: Updated mpdf and phpmailer to newer versions
DB changes:
ALTER TABLE `api_keys` DROP INDEX `key_UNIQUE`;
ALTER TABLE `api_keys` CHANGE `key` `api_key` VARCHAR(255) NOT NULL;
ALTER TABLE `api_keys` ADD UNIQUE KEY `idx_api_key_unq` (`api_key`);
To upgrade from NADA 5.4, please follow these steps:
application and themes.alter table dd_projects
add `key_variables` varchar(500) DEFAULT NULL,
add `sensitive_variables` varchar(500) DEFAULT NULL;
To upgrade from any previous versions of NADA 5, please follow these steps:
application and themes.CREATE TABLE `variable_groups` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`sid` int(11) DEFAULT NULL,
`vgid` varchar(45) DEFAULT NULL,
`variables` varchar(5000) DEFAULT NULL,
`variable_groups` varchar(500) DEFAULT NULL,
`group_type` varchar(45) DEFAULT NULL,
`label` varchar(255) DEFAULT NULL,
`universe` varchar(255) DEFAULT NULL,
`notes` varchar(500) DEFAULT NULL,
`txt` varchar(500) DEFAULT NULL,
`definition` varchar(500) DEFAULT NULL,
PRIMARY KEY (`id`)
) AUTO_INCREMENT=1 DEFAULT CHARSET=utf8;
ALTER TABLE `users` ADD `otp_code` varchar(45) DEFAULT NULL;
ALTER TABLE `users` ADD `otp_expiry` int(11) DEFAULT NULL;
Use the patch file (nada-v5.0.3-update.zip) to update existing NADA 5.x. To apply the patch, just unzip the patch into your NADA5.