Release Date: May 9, 2018

Jill Wilson (Unlicensed) 1 (2447 days ago), Kyle Hutson (Unlicensed) 1 (2020 days ago), Wenjun He (Unlicensed) 1 (2423 days ago)

Research Master ID Site New Features and Bug Fixes (v1.2.0)

1. (RMID/SPARC API) Upgrade to Ruby on Rails 5.1.5
In this release, the RMID/SPARC API framework has been updated to use Rails 5.1.5, for maintenance and better performance.

2. (SPARC API) Remove Custom DB connection
The SPARC API previously had its own database, but now pulls data directly from the SPARCRequest production site to improve accuracy.

3. (RMID) Audit Trail Feature
An audit table, with its related features, has been added to the RMID application. The audit trail feature enables tracking of creation, updates, and destroys of records, by both users and the application programming interfaces (APIs).

4. (RMID) Improved Protocol Update Method
Previously there were scenarios where the PI name displayed for protocols associated to a Research Master record was different from the current PI name shown in SPARCRequest, or eIRB. These scenarios were caused by the PI change in different systems not being updating in the RMID back-end. The protocol update method has been since improved to compare every protocol-level field and then determine whether an update to the protocol record is needed.

5. (RMID) Research Master PI Update and Notification According to Verified eIRB Record
When a RMID is used in the eIRB system and the corresponding eIRB record has been in an approved and beyond status, in addition to the titles of the Research Master record, the Primary PI-associated data (Name and netID) are now also updated accordingly.

In addition, the system is now sending automatic emails to the previous PI, creator, as well as the updated PI of the record, to notify users of the PI change when the PI on the research master record is updated according to the eIRB record.

Example Research Master PI Update Notification

6. (RMID) Admin Message Feature

In case that an RMID administrative user needs to contact the users in regards of the Research Master record, there is now a "Send Notification" button available on each record for registered admin users. With this new feature, admins can now send messages to the creator and PI of the RMID record to their MUSC email addresses directly if desired.

Notification Window for Admin Users	Example Notification Email

7. (RMID) Edit Button Bug Fix

In this release, we have fixed a potential security issue where an admin user could change the property of a disabled "Edit" button on a Research Master record from browser console and make it editable. This bug has since been fixed, and even admin users are not able to edit a verified record.

8. (RMID) Associated Popup Bug Fix

Previously, when clicking on an existing RMID, a pop-up box did not appear for those that had no associated records. This bug has since been fixed and the pop-up box now appears for all Research Master records (see below for screenshots).

RMID with Associated Protocols	RMID without Associated Protocols

9. (RMID) CoeUs Record Association Display Bug Fix

Previously, when moving the association of a SPARC protocol from using one RMID (i.e RMID#1) to the another RMID (i.e. RMID#200), associated CoeUs record(s) (i.e. MIT Award Number 020045-001) were also removed inadvertently from the displayed association of the original RMID (i.e. RMID 1). The removal of the CoeUs association was not intended and should not have been dissociated from the RMID (i.e. RMID 1). This association bug has since been fixed.

Before Changing RMID in SPARCRequest	After Changing RMID in SPARCRequest

10. (RMID) Automatic Filter Added for Special Characters

To avoid the errors caused by special characters for systems that are not compatible with them (such as Epic) and improve the data consistency, we have added automatic filters for special characters and excessive blanks in the text fields of RMID.

Example Text Fields with Special Characters	After Automatic Filtering

11. (RMID) Add netID Information to Users table
The netID column has been added to the users table, for ground work in the next releases for condensing the Primary PI information from different systems into linked users' records, which will improve the system efficiency.

Release Date: May 9, 2018

Research Master ID Site New Features and Bug Fixes (v1.2.0)

1. (RMID/SPARC API) Upgrade to Ruby on Rails 5.1.5
In this release, the RMID/SPARC API framework has been updated to use Rails 5.1.5, for maintenance and better performance.

2. (SPARC API) Remove Custom DB connection
The SPARC API previously had its own database, but now pulls data directly from the SPARCRequest production site to improve accuracy.

3. (RMID) Audit Trail Feature
An audit table, with its related features, has been added to the RMID application. The audit trail feature enables tracking of creation, updates, and destroys of records, by both users and the application programming interfaces (APIs).

In addition, the system is now sending automatic emails to the previous PI, creator, as well as the updated PI of the record, to notify users of the PI change when the PI on the research master record is updated according to the eIRB record.

6. (RMID) Admin Message Feature

Notification Window for Admin Users

Example Notification Email

7. (RMID) Edit Button Bug Fix

In this release, we have fixed a potential security issue where an admin user could change the property of a disabled "Edit" button on a Research Master record from browser console and make it editable. This bug has since been fixed, and even admin users are not able to edit a verified record.

8. (RMID) Associated Popup Bug Fix

Previously, when clicking on an existing RMID, a pop-up box did not appear for those that had no associated records. This bug has since been fixed and the pop-up box now appears for all Research Master records (see below for screenshots).

RMID with Associated Protocols

RMID without Associated Protocols

9. (RMID) CoeUs Record Association Display Bug Fix

Before Changing RMID in SPARCRequest

After Changing RMID in SPARCRequest

10. (RMID) Automatic Filter Added for Special Characters

To avoid the errors caused by special characters for systems that are not compatible with them (such as Epic) and improve the data consistency, we have added automatic filters for special characters and excessive blanks in the text fields of RMID.

Example Text Fields with Special Characters

After Automatic Filtering

11. (RMID) Add netID Information to Users table
The netID column has been added to the users table, for ground work in the next releases for condensing the Primary PI information from different systems into linked users' records, which will improve the system efficiency.

(RMID) PI Updates (compile all of these)

In this production, the following PI updates have been made:

PI Name has been removed from the research_masters column

PI Information is now linked back to the users table

(RMID) Investigate Missing net_id in primary_pis

(RMID) Investigate Missing pi_id in research_masters Record

Research Master ID version 1.2.0

Release Date: May 9, 2018

Research Master ID Site New Features and Bug Fixes (v1.2.0)

1. (RMID/SPARC API) Upgrade to Ruby on Rails 5.1.5In this release, the RMID/SPARC API framework has been updated to use Rails 5.1.5, for maintenance and better performance.

2. (SPARC API) Remove Custom DB connectionThe SPARC API previously had its own database, but now pulls data directly from the SPARCRequest production site to improve accuracy.

3. (RMID) Audit Trail FeatureAn audit table, with its related features, has been added to the RMID application. The audit trail feature enables tracking of creation, updates, and destroys of records, by both users and the application programming interfaces (APIs).

In addition, the system is now sending automatic emails to the previous PI, creator, as well as the updated PI of the record, to notify users of the PI change when the PI on the research master record is updated according to the eIRB record.

6. (RMID) Admin Message Feature

Notification Window for Admin Users

Example Notification Email

7. (RMID) Edit Button Bug Fix

In this release, we have fixed a potential security issue where an admin user could change the property of a disabled "Edit" button on a Research Master record from browser console and make it editable. This bug has since been fixed, and even admin users are not able to edit a verified record.

8. (RMID) Associated Popup Bug Fix

Previously, when clicking on an existing RMID, a pop-up box did not appear for those that had no associated records. This bug has since been fixed and the pop-up box now appears for all Research Master records (see below for screenshots).

RMID with Associated Protocols

RMID without Associated Protocols

9. (RMID) CoeUs Record Association Display Bug Fix

Before Changing RMID in SPARCRequest

After Changing RMID in SPARCRequest

10. (RMID) Automatic Filter Added for Special Characters

To avoid the errors caused by special characters for systems that are not compatible with them (such as Epic) and improve the data consistency, we have added automatic filters for special characters and excessive blanks in the text fields of RMID.

Example Text Fields with Special Characters

After Automatic Filtering

11. (RMID) Add netID Information to Users tableThe netID column has been added to the users table, for ground work in the next releases for condensing the Primary PI information from different systems into linked users' records, which will improve the system efficiency.

(RMID) PI Updates (compile all of these)

In this production, the following PI updates have been made:

PI Name has been removed from the research_masters column

PI Information is now linked back to the users table

(RMID) Investigate Missing net_id in primary_pis

(RMID) Investigate Missing pi_id in research_masters Record

1. (RMID/SPARC API) Upgrade to Ruby on Rails 5.1.5
In this release, the RMID/SPARC API framework has been updated to use Rails 5.1.5, for maintenance and better performance.

2. (SPARC API) Remove Custom DB connection
The SPARC API previously had its own database, but now pulls data directly from the SPARCRequest production site to improve accuracy.

3. (RMID) Audit Trail Feature
An audit table, with its related features, has been added to the RMID application. The audit trail feature enables tracking of creation, updates, and destroys of records, by both users and the application programming interfaces (APIs).

11. (RMID) Add netID Information to Users table
The netID column has been added to the users table, for ground work in the next releases for condensing the Primary PI information from different systems into linked users' records, which will improve the system efficiency.