V5.5

Updates and fixes

• Added driver-based email system supporting SMTP and SendGrid/API.
• Catalog search API updated to accept user-defined filters and include DOI and optional country lists.
• Support for replacing study IDNO via identifiers in metadata import.
• Support for custom fields on the public request form.
• Added tables API endpoint to download table data as CSV or JSON.
• CSV export option added for the catalog admin page for licensed requests.
• Site-wide CSRF protection enabled; CSRF tokens added for data deposit uploads.
• Session regeneration on login to reduce session fixation risk.
• CSP support added (disabled by default) — administrators can enable/configure as needed.
• Forgot-password throttling (default limit 3 requests in 5 minutes) and increased DB column size for reset codes.
• SQLSRV installation script updated
• Fixed XML/DDI encoding (use htmlspecialchars with ENT_XML1, improved handling of quotes).
• Fixed display and grouping of external resources.
• Fixed study thumbnail upload failing with 400.
• Fixed a number of admin UI issues (breadcrumb links, resources download links).

Database changes

ALTER TABLE `users` 
ADD COLUMN `forgot_request_ts` INT NULL,
ADD COLUMN `forgot_request_count` INT DEFAULT 0;


ALTER TABLE `public_requests` 
ADD COLUMN `title` VARCHAR(500) NULL AFTER `surveyid`;

V5.4.1

Fix issues with 5.4 release

• Unable to create new user accounts via site administration
• Study thumbnail shows a 400 error
• Catalog administration page search does not work

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;

V5.4

What's Changed

• Show citations using Datacite API for studies with DOIs
• Export of citations to RIS and BibTeX formats using DataCite API
• Translations updates for French, Spanish and Arabic
• Fixed: Add checks for expiration date and for licensed data download
• Fixed: Data deposit exported DDI missing IDNO #92
• Fixed: Data deposit auto-fills fields #91
• Added zip preview for external resources
• Updated Scripts, Geospatial and Microdata Schema
• For Microdata schema, country is no longer a required field
• Updated study detail display with new template to show all Microdata/DDI fields

Critical security fixes

• Enable CSRF tokens site-wide
• Regenerate sessions on login
• Expire page cache for admin pages
• Fixed access control issues across site admin

Database changes

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;

V5.3

Updated to support PHP 8.x

V5.2.1

Fixes and updates

• Updates and fixes for all data types (schemas), including Microdata, Table, Document, Image, Video, and others
• Updates and fixes for display for all data types
• Fixed issues with the NADA-generated DDIs not readable by Nesstar Publisher
• Added subtitle field for Microdata
• Updated formatting of the related studies tab
• Added feature to white list data access for users by collections
• Fixed issues for licensed request admin page not showing all requests
• Improvements for geospatial metadata display
• Misc. fixes and updates for API
• Integrated full-text search using SOLR
• Misc. updates for the home page
• Fixed: Variable statistics were not displayed correctly
• Fixed: Replace DDI fails to update some studies
• Updated SQLSRV database installation script

Database changes:

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.

V5.2

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.

What’s new

• Application UI has been improvised with a new design
• Catalog keyword search has been redesign to use a single search box to search both study and variable level metadata
• Support for creating custom search filters/facets has been added
• New and improved cards layout for catalog entries with support for showing thumbnails
• Data types supported by NADA now include Microdata (DDI/Codebook 2.5), Time series, Geospatial, Document, Table, Image (IPTC), Video, and Scripts.
• Improvements and new UI for browsing, searching, and comparing variables for Microdata
• Revamped user roles and permissions with more flexibility for custom roles
• New design for site administration pages
• Built-in support for enabling Google Analytics, see the site configurations page
• Bug fixes and improvements for API to manage the catalog
• A new built-in metadata editor (beta) for creating and editing content for Documents, Tables, Images, Time series, Microdata (limited to study level metadata)
• Integration with SOLR for better fulltext search

How to upgrade

- See our guide to upgrade here

Fresh installation

- See section on installation here

V5.0.6

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:

• Renamed field 'key' to 'api_key' for table 'api_keys'. To update the database, run the following SQL:

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`); 

V5.0.5

• Added import of data access type set in DDI
• Updated API to find studies using both the codeBook IDNo and numeric ID values
• Added API endpoint for generating PDF documentation
• Added missing DDI fields on study information page
• Fixed issue with the display of weighted variables and summary statistics
• Added variable groups on study info pages under data dictionary
• Added two new fields for data deposit (key_variables, sensitive_variables) and some UI fixes
• Updated catalog search to return results matching all keywords
• Added configuration option to set default sort order for catalog results
• Fixed download report for study data and other file downloads
• Fixed RDF import ignoring the resource 'abstract' field
• Fixed RDF import skipping resources as duplicates
• Added export to CSV for licensed requests on the license requests site admin page
• Fixed issue with replace DDI not updating all fields
• Added page titles and auto generated meta description for study info pages

To upgrade from NADA 5.4, please follow these steps:

1. Backup the folders application and themes.
2. Download and unzip the latest source code on your computer and remove the user configuration files to make sure, your settings are not overwritten:

• application/config/config.php
• application/config/template.php

3. Upload files to your server to replace existing files
4. To update the database run the following SQL:

alter table dd_projects
add `key_variables` varchar(500) DEFAULT NULL, 
add  `sensitive_variables` varchar(500) DEFAULT NULL;

5. Done

V5.0.4

• Fixed multiple UI issues on catalog admin page
• Updated API and API documentation
• Added JSON-LD to study information pages
• Added import and display of variable groups
• Added support for complex IDNO - issue #10
• Fixed issues with DDI batch refresh - issue #6
• Fixed citations tab display
• Fixed catalog page navigation issues for collections - issue #14
• Fixed title does not include the study subtitle

To upgrade from any previous versions of NADA 5, please follow these steps:

1. Backup the folders application and themes.
2. Download and unzip the latest source code on your computer and remove the user configuration files to make sure, your settings are not overwritten:

• application/config/config.php
• application/config/template.php

3. Upload files to your server to replace existing files
4. To update the database run the following SQL:

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;

5. Done

V5.0.3

• Updated display for collections on frontend/backend
• Fixed collection history page
• Updated site admin reports
• Updated study information page to hide empty columns, convert links into hyperlinks
• Updated language files for English to include missing translations
• Added system language files for Spanish and French
• Fixed export search results to CSV on catalog page
• Replace old Google Recaptcha v1 with v2

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.