Upgrade from NADA 3¶
For users with an existing NADA 3.x catalog an upgrade script is included that will update your NADA 3.x database to NADA 4.x. The process involves modifying your NADA 3.x database and thus carries some risks. The script will add new tables to the NADA 3.x database. All user accounts and survey information will be retained by the upgrade.
Backup the NADA 3.x database before doing anything!!
- Follow the instructions on page 4 and set up a folder in the web root containing the NADA 4 files.
- Edit the database.php file as instructed in the section above: NADA database configurations for MySQL.
- Instead of entering a new database name, user account name and password -fill in the details of the existing NADA 3.x database.
These can be found by looking at the existing NADA 3.x database.php file and entering the settings into the NADA 4 database.php file.
- Save the file.
- Navigate to the URL for the NADA4 site: Example: http://your-nada-site/nada4/index.php/nada4_upgrade
- The following page loads:
Take note of the warnings and make any necessary corrections before clicking the “Upgrade database to NADA 4” button.
This step makes changes to your nada 3 database that are not undo-able so make sure you do make a database backup before this step.
Click on the “Upgrade database to NADA 4” button and wait for the page to reload. The output of the page will look something like below:
The script will print number of messages about failed table updates. This does not mean the script failed to upgrade. It just means some of the updates were not needed on your version of NADA 3. Different versions of NADA have different numbers of fields in the database and the upgrade script tries to fix the missing fields for all these different versions of NADA. If the existing NADA 3 database already has that field then it reports it as an error.
You can ignore the error messages that include the wording “Duplicate column name” or “Duplicate entry”.
Now your database has been migrated to NADA version 4.1. We will have to run one more upgrade script to for NADA version 4.2
- Navigate to the URL for the NADA4.2 site: Example: http://your-nada-site/nada42/index.php/nada42_upgrade
This step makes changes to your nada 4.1 database that are not undo-able. This page will not show any message on the screen. You will be getting blank page. Please do not repeat the process
8. To verify the database upgrade. Open the NADA catalog page by going to http://[your-nada4-site]/index.php/catalog page and verify all studies from NADA 3 are listed.
In NADA 4, more information is stored in the database from the DDI than in the NADA 3. To bring all these new fields into the imported studies it is necessary to refresh the DDI’s. The refresh DDI feature in NADA updates the database with metadata from the DDI without having re-uploading the DDIs. To update the metadata for all studies in your catalog:
- Open the following NADA 4 URL in your browser:
- Select all studies
- Click on the “Refresh DDI” button
NADA 4 has a collection management feature. When studies are imported from the NADA3 catalog into NADA4 they are put into a collection called DEFAULT. They need to be moved from this default system collection to the Central Data Catalog of the NADA4.
To do this:
- Go login to the Site Administration and navigate to the Studies, Manage Studies, Central Data Catalog page
- Select all the studies by ticking the check boxes next to each study on the right.
- Click on the dropdown menu and select Transfer owner
- From the Transfer study owner page: Select Central Data Catalog and then click transfer.
Updating the Site theme/template¶
You cannot use your NADA3 template in NADA4 without making some changes. Here are general guidelines but steps may differ depending on your nada site template.
Copy your NADA3 template to the NADA4 themes folder.
Edit the [nada4-root]/config/template.php following the steps below:
Look for the setting “theme_name”, by default it is set to ”wb”:
Change “wb” to the theme name you want to use. Theme name is the folder name you copied to [NADA4]/themes/[your-site-theme] from your nada3 site.
Save the file.
NB: The template may need some adjusting to run properly on the new NADA 4 site. This will involve editing the layout.php and other template files within the template folder which is now located in the NADA 4 themes folder.