Release Notes 11.3

This document describes the technical enhancements to Generate version 11.3 released in February 2024. The purpose of this document is to communicate the technical updates made to Generate in version.

Release Overview

Generate version 11.3 is primarily focused on Directory, small user interface changes, and NodeJS updates. We also added the hotfix changes from the last round of Assessment submissions and Discipline views (emailed 2/5) to this release.

Required State Changes

For states that do not have internet access from their Generate server, we have modified the Update logic so that you can leverage the auto-update process, with two manual steps.

1. You will receive an update package from us. When you do:

   • Upload it to the /Updates folder found within both the /web and /background directories on your web server.

2. Open the configuration file and change the “callservice” setting to false.

   • On your webserver, navigate to the location of the /web files and then go to /wwwroot/assests/config

NOTE: There may be more than one file in that location depending on how you installed/configured Generate. Make the change to any config files in that location.

Run the update process from the UI as normal.

Important Updates

The below items do NOT require state action, but we wanted to bring your attention to:

• If you are submitting Directory (FS029) through Generate and you run into an issue creating a csv submission file because there are commas in the incoming data, we have an open ticket to address escaping the commas. That work is not complete so if you do experience that issue you can either remove the commas from the incoming data or create a TAB delimited submission file.

• We added a new Staging Table Snapshot utility. The documentation for this utility is available here - Staging Table Snapshot

• We now have a new way of displaying report data in the User Interface that will help us in promoting Generate to the Source Community. The new method is currently applied to most student-level reports only. The look and feel are slightly different, and we will be working on the next release making to make it faster as well. There is a new search feature will allow you to search for elements to filter to leverage for your data analysis. Turn on the search feature by selecting “Search” and then use categories to set filters.

How to Use the New Search Feature

1. Activate the search functionality by selecting the “Search” option.

Select the search box to view the filters

1. Utilize categories to set filters, narrowing down your analysis to the most relevant data.

Filter options displayed for SEA, SEA ID, Disability Category, Sex, and Racial Ethnic fields, facilitating refined data selection within the interface.

The Search feature is currently case and text specific.

Example: To filter by Disability Category, ensure you input the category name exactly as it appears. For instance, to filter for Deaf-blindness, type it with the capital 'D', the dash, and the lowercase 'b'.

Filtering by Disability Category: Ensure precise input for accurate results.

---

Generate Enhancements

The following EDFacts reports were updated in this release.

Type of Impact:

• Data – the changes will improve data quality and completeness.

• User Interface – the changes impact the Generate User Interface and/or migration process.

• Source to Staging ETL – the changes may require modifications to the SEA’s Source to Staging ETL

• Performance – the changes improve the performance of the application.

• Migration – the changes impact a data migration process.

• Submission Files – the changes may impact submission file(s)

• Database – changes to the Generate database structure.

Directory

Report	Approved Change	Ticket #	Type of Impact
FS029	Create delimiter handling for EDFacts Report Exports	CIID-2627	Data
	The column lengths for the Organization Address fields were different between staging and the RDS. We added code to ensure there are no issues with the migrations while we look at structural changes to permanently address it.	CIID-5241	Data
	We corrected the date-handling logic in Staging-to-FactOrganizationCounts so that it can handle multiple LEAs when some of them are future dated.	CIID-5731	Data
	The logic used in the migration of LEA data to determine whether to use NA or NOTCHR for the LEA Charter Status was incorrect, that has been corrected	CIID-6462	Data
	Corrected an issue in the code that was preventing Charter Primary and Secondary Authorizer data from displaying in the UI and in the submission file.	CIID-6484	Data
	Corrected a mapping issue that was preventing Charter School Authorizer Type Codes from migrating into the Data Warehouse with the proper values	CIID-6468	Data
	Corrected the PV for GunFreeSchoolsActReportingStatusCode because it was displaying the dimension code value, not the EDFacts code in the UI and the submission file	CIID-6467	Data
FS163	Corrected the PV for GunFreeSchoolsActReportingStatusCode because it was displaying the dimension code value, not the EDFacts code in the UI and the submission file	CIID-6467	Data
FS116	Corrected an issue in the Directory export that was excluding Prior LEA Identifier, Effective Date, and Updated Operational Status.	CIID-3963	Data

Assessment

Discipline

Child Count

Immigrant

Title III

Staff

General

Upgrade Procedure

No changes have been made to the Generate upgrade procedure for this release. Follow the standard Generate upgrade process to install version 11.3.

Compatible Systems

Generate was tested on the following operating systems and browsers:

• Windows 10 Pro

• Google Chrome, Version 68 0.3440.106 (Official Build) (64-bit) and Firefox Quantum 61.01 (64 bit)

---

Office Hour

Generate 11.3 Office Hour Recording