Summary

This release focuses on improving platform usability and configuration, simplifying user management workflows, and safeguarding the Primary Key field. 

Key Updates

Updates include streamlining file processing by alleviating pain points and mitigating some error risk with filename and lastRow configuration, improving system transparency with updated administrator filters, and improving the user experience with user-friendly updates to the Runs Overview page, File Management screen, menu labels for scheduling, and email alert URLs.
 

Customer Access

The following updates will automatically be available to all customers next time they log into Zone Data Portal. 

New Features & Improvements (8)

Platform Experience (3)

Improved File Processing Configuration

Removed the legacy configuration that restricted file processing based on a parameterized filename list. File processing logic is now fully governed by the filenamePattern and filenameAntiPattern settings within FileConfiguration, providing a clearer and more predictable configuration model. Additionally, the filenamePattern and filenameAntiPattern fields in FileConfiguration are now displayed side by side, making it easier to review and manage file processing logic.

• What does this mean? With previous settings, for files to be processed they required multiple steps to configure a filename pattern. This has been updated. All users can now use only the filenamePattern and filenameAntiPattern settings within FileConfiguration to configure files for processing. To make this easier, the two fields (filenamePatter and filenameAntiPattern) are now displayed side by side. This should alleviate manual naming errors.

Update Made on LastRow in File Configuration 

Updated the user interface for a better experience with file naming. The enhanced file processing control now allows users to set lastRow to null (0). This enables processing of all rows within a delimited file. Previously, lastRow was primarily used to exclude trailing rows (e.g., summary totals). 

• What does this mean? When configuring a file, if the last row value is edited, the last row value must be a negative integer. However, this means that users were unable to “null” the row. With this update, users can now “null” the last row by using a 0 value. This value will not flag as an error, and the file can still be saved and configured. 

Improved Email Alert URL Handling

Email notifications now properly support URL, allowing users to click links directly from email alerts without manual adjustments.

• What does this mean? Previously, alert email notifications included a broken URL link, this has now been updated and taking action from email alerts will now be much faster. 

Customer Impacts

These updates improve the customer experience by alleviating pain points around file configuration by reducing potential errors and the complexity of the configuration process. The improved email alerts will make it easier for customers to take action by clicking on the URL within the alert.

User Management (1)

New User Categories & Filtered User Views for Administrators 

New user categories and filtered views were created to improve efficiency and visibility. Note that filters are not available to all users.

Customer Impacts

These updates were made to drive efficiency for Administrators. The new user manager categories and filters will give them better visibility with faster insights about their users.

Improvements to the User Experience (3)

Updated Usability on Runs Overview – File Section 

Improved file sorting by status and standardized status color indicators to align with platform UI conventions (e.g., red for errors/failures, yellow for warnings). This increases clarity and accelerates issue identification. [add image, have]

• What does this mean? After running batch jobs in the Zone Data Portal, users check the status of their files on Runs Overview. The platform changed the way they display these jobs to make reviewing file statuses easier. Now, files with a positive status (loaded, received, staged, published) will be green. Files with an error or failure message will be red, and files with a warning will be yellow. Additionally, the list of files will automatically sort any red and yellow status first, making it easier to take action on these issues. 

File Management Auto-Load

The File Management screen now automatically loads data from the first configured folder, reducing clicks and improving workflow efficiency.

• What does this mean? Previously, users landing on the File Management screen were not shown any data, creating the appearance that there were no files attached to their account. Accessing these files required multiple clicks. This has been updated so that data from the first configured folder automatically appears on the screen.  

Updated Menu Labels for Scheduling

Zone updated the menu labels to better reflect configuration intent and avoid confusion with scheduling.

• (legacy term) Run Definitions → (new term) Flow Schedule
• (legacy term) Schedules → (new term) Replicated SQL Schedule

Customer Impacts

User experience updates were driven by feedback from our customers and developers. All three of the above updates improve Zone Data Portal’s ease of use, making it more intuitive for our users.

Schema Management (1)

Added Safeguard

Added an additional guardrail to protect Primary Key integrity. When attempting to remove or modify a field designated as a Primary Key, users will now see a confirmation prompt requiring them to first uncheck the Primary Key setting before the field can be removed.

• What does this mean: Prior to the latest code update, it was possible for the Primary Key field to be removed, resulting in a corrupted scheme, blocked users, failed deployments, and manual updates. To mitigate this risk, the new updates ensure that the only Primary Key Field cannot be removed. Messaging informs users that this field cannot be removed. If required, an alternate Primary Key field can be identified (by checking “Primary Key”).