New Features in Builder v2.17 | Knowledge Base

Added ability to Export forms to Excel

You can now export forms to Excel. This improves collaboration on form design and allows for increased visibility of forms for non Builder users.

The Exports screen now has a drop down that allows you to export to your Imosphere data entry solution and Excel.

The Exports screen now has a drop down that allows you to export to your Imosphere data entry solution and Excel. Exports are downloaded as before but can be identified by the new Type column.

The Excel Export has tabs for:

Forms
Form lines
Form line drop down list options
Form line constraints

There is also a System info tab containing meta data about the export and global calculations to enable internal sheet linking.

There are links to enable simple navigation between forms, form lines, etc. When selected, the link will navigate to the relevant tab and highlight all the related records

For example, selecting the first form lines link will move to the form lines tab and select all the form lines for that form.

Bug Fixes

Area of System	Bug Fix Details
Auto ETL	Data aliases functionality for drop down list items on coding system forms has now been corrected for systems upgrading to Atmolytics V3.2 from Atmolytics V2.70.
Auto ETL	The SSIS ETL AdmissionStaff.StaffRoleName lookup for ArgonWeb.dbo.Responsibilities.ResponsibilityName was case sensitive and would cause the ETL to fail if the casing was different.
Auto ETL	The Atmolytics Auto ETL setup requires the first step in the SQL agent job to be “Backup Databases”. This step has been added to the Auto ETL documentation.
Auto ETL	The PurgeArchiveData has been corrected to support deleting invalid data.
Auto ETL	The numeric validation now correctly supports the maximum value the SQL data type Decimal(18,5) supports (9,999,999,999,999.99999).
Auto ETL	A new rule has been added to the staging database called “NoOverlapWithAdmissions” when the “Connected to your Imosphere data entry solution” option is checked
Builder	The staging API methods for returning patients at a location with update required will no longer return patients who have a pending update to their registration form (or other non-location-based record) unless they also have forms or admission in the location.
Builder	SQL snippets are now moved below the navigation bar
Exports	ETL packages that finish generating while the user is viewing the Exports page will no longer cause an error to be thrown in the frontend.
Form Designer	Incorrect Icon used for import fixed.
Form Designer	Spacing now appears under the Add option button.
Infrastructure	Stability improvements to login should reduce the frequency of errors and make it easier to login.