-------------------------------------------------------------------------------- HL7 Tools Release Notes - https://www.raymarron.com/hl7/ -------------------------------------------------------------------------------- Key: + New feature or improvement - Feature deprecated or removed (deprecated items are removed after one year) * Bugfix ! Breaking change, attention required upon upgrade 2020-06-21 HL7Viewer 10.122 + Added the ability to run a script against just the selected message rather than all messages. 2020-06-18 THL7NamedFields class (all projects) + Improved error handling and messages to identify an otherwise generic error as having come from loading a named fields file/definition. + Improved HL7NamedFields.*.txt file comments. HL7Script 10.300 + Added the special "EOF" value for setting the __FilePos built-in variable. !- Removed the deprecated ability to create section variables without a prefix. This now raises an error. Special variables such as $ROWSAFFECTED and $XMLOK are no longer created with an unprefixed version for legacy scripts. HL7Viewer 10.121 * Fixed the #2 or higher segment sequence number not being stripped from the named key when showing both numeric and named keys, e.g. NTE#2.1 2.SetId 2020-05-16 HL7Script 10.251 + Added the __SegCountOut built-in variable. 2020-05-02 HL7Script 10.250 + Added the FILE OPEN command to support input as well as output. + Added the __FilePos built-in variable to set/get the current FILE position. + Added the HL7 LOADNEXT function to load the next message from the open FILE. + Added the __MsgStartValues built-in variable for HL7 LOADNEXT. 2020-04-25 HL7Viewer 10.120 + When "Show Named and Numeric Keys" is on, the numeric key is now shown first for improved visual alignment, and the segment ID is omitted from the named key to be less verbose. The "Copy Named Key" action still returns the full key including segment ID. 2020-04-18 HL7Script 10.240, HL7ScriptService 10.030 * Made polling and loop datasets readonly with a unidirectional static cursor to avoid a "Connection is busy with results for another hstmt" or "Invalid cursor position" on a large input set when also doing updates in the script. + Added the LOOP BIGQUERY command to use when a query is expected to be large. When used, the dataset is fetched in reasonable chunks (FetchOptions.Mode is set to fmOnDemand) rather than all at once (fmAll) which is now the default. 2020-04-11 HL7Viewer 10.110 + Added "Click to ..." hints to the status bar based on the current state. + During a database Watch, the connection remains active rather then being opened and closed on each interval. + Added the optional :WatchPK parameter to database watches so the query can return only new rows each interval. It contains NULL on the first query, or the last PK returned from the previous query (last should be highest). Example: SELECT pk, msg FROM hl7 WHERE pk > ISNULL(:WatchPK, 0) ORDER BY pk + Opening Find in Files/Data after an active Watch will re-select the Watch option rather than defaulting back to Clear. + Improved Find in Files/Data error handling, identifying the problem message and prompting the user to continue or cancel the search. * Fixed a Find in Files message parsing error caused by not resetting the encoding between files in a search of mixed ASCII/UTF-8 files. 2020-04-04 HL7Viewer 10.100 + Added the ability to Watch a directory or query from the Find in Files/Data dialog. It periodically checks the directory or query for new messages and adds them to the tree. If the maximum message count is reached, the oldest messages will be removed to make room for the new. + Added a script help button to the Count Unique Values dialog. 2020-02-29 HL7Script 10.237 + Attempting to assign a variable with a prefix-only name raises an error. HL7Viewer 10.061 + Run Script can now be cancelled. Post-processing will be skipped on cancel, abort, or error. The Finalization section is also skipped when cancelled. 2020-02-08 HL7Script 10.236 + Add a warning to the log whenever an un-prefixed variable is used as this was deprecated in June 2019 and will become an error in June 2020. HL7ScriptService 10.020 (and Config) !+ A global setting now controls whether the shared service variables (%%) are persisted between service starts. False by default, which differs from past behavior, so review upon upgrade if used previously. + If service variables are in use and set to persist, they will be saved periodically as well as at shutdown (just like the log) to prevent data loss in the event of power outage, etc. 2020-01-04 HL7Viewer 10.060 + Run Script now allows for a database connection to be selected and used in the script. 2019-12-21 HL7Viewer 10.051 * Fixed Find in Files search directory "..." button not doing anything. HL7Script 10.235 * Forgot to actually change the version constant in the last release. Now it properly displays as 10.235. 2019-12-08 HL7Script 10.235 + Added the special "ValidationInput" comment that allows the validation input prompt to be bypassed. See the script reference for more info. + On-screen validation output now labels "Errors:" and "Warnings:". 2019-11-29 HL7Script 10.234 + The LOOP SEGMENTS range now accepts segment keys as well as numeric indexes. HL7Viewer 10.050 + Added the "Run Script" item to the Messages menu. Runs an HL7Script against the current message list and shows the output in an on-screen log. It does a LOGVARS for post-processing by default, but you may turn it off or provide your own post-processing section. Handy for quick, one-off scripts. It will remember your script between runs unless the Save History preference is off. 2019-11-02 HL7Viewer 10.040 + Added the "Count Unique Values" feature to the Messages menu. Counts the unique values of a given key expression from the current message list. Much like doing a quick INC "%"+[key] script in HL7Script, but without the need to save a script file or re-select which messages to include. HL7Script 10.233 + Added the public EvalDataExpression method to the class for HL7Viewer's Count Unique Values feature. No changes to the language or behavior. 2019-10-13 HL7Script 10.232 + Only syntax-check uncached IF/ELSEIF/ELSE statements once when first parsed. + Using SET without an equal sign now raises an error saying so instead of one saying a blank variable name is not valid. 2019-09-28 HL7Script 10.231 + Allow for nested LOOP SEGMENTS. The ### replacement is always provided by its innermost parent segment loop. * Fixed LOOP SEGMENTS 0-0 from treating the zero upper bound as if no upper bound was provided and iterating over all segments. + Raise an informative script error immediately upon attempting to run a segment index, segment key, or field key LOOP when no input HL7 message is defined, rather than waiting to get one downstream. + Changed the value returned by __FileEncoding to be the numeric code page value instead of the full name, as that name is often not valid as input but the code page always is. HL7ScriptService 10.014 * Fixed a database connection being loaded as a file-based connection when the Service ID was non-blank (variable re-use without clear). 2019-09-21 HL7Script 10.230 + Added the ability to specify an AnyKey segment sequence on the HL7 DELSEG command to delete all segments of a given type (e.g. HL7 DELSEG NK1#*). + Added "OUT" versions of the following script functions that work on the output message instead of the input message: COMCOUNTOUT, FIELDCOUNTOUT, KEYEXISTSOUT, REPCOUNTOUT, SEGINDEXOUT, SEGKEYOUT, and SUBCOUNTOUT. - Deprecated the OUTKEYEXISTS function in favor of KEYEXISTSOUT. !- Removed variable loops (LOOP @VAR) that were deprecated in v9.4. !* Fixed FIELDCOUNT[OUT] including the segment ID itself (field 0). Now returns the more commonly expected count of fields 1..n, where FIELDCOUNT[OUT] = n. * Fixed AnyKey comparisons to blank (e.g. OBX#*.5 == "") always returning true because keys that don't exist return blank. A comparison will no longer be attempted unless the key exists. + Continued QA script improvements, adding tests for each new feature and fix as they are made. Now over 1500 lines. HL7Viewer 10.031 * Version bumped as it incorporates the above HL7Script AnyKey fix. 2019-09-02 All Projects + Added the THL7Message.Caching property. It caches the SegmentStr and FieldStr properties for speed if nothing has changed since the last time they were generated. The trade-off is the extra memory used to store those. On a contrived test generating SegmentStr values from 2000 messages x 100, it took about 12 seconds uncached, 0.3 cached! Typical usage wouldn't see huge gains like that, so it defaults to False to mimic current behavior. HL7Viewer 10.030 + Added the Caching option on the Messages menu. HL7Script 10.221 + Added the message Caching option on the Preferences dialog. Applies to both the input and output messages. !- Removed the deprecated support for LOADVARS Base64 encoding that was removed from SAVEVARS in v9.2. HL7ScriptService 10.013 (and Config) + Added the HL7 Caching option. Applies to both the input and output messages. + When the "Add ERR" option is on, added the system time in ERR.1.4.4. 2019-08-03 HL7Script 10.220 + Added the AGE script function. + LOOP QUERY now ignores the __MaxLoops limit like LOOP TEXT/CSV since a query has a finite but sometimes large number of rows returned. + Error processing will default to logging the error if the ERROR section is not provided. + EHL7ScriptError no longer gets raised with "Line #:" as the start of the error text, since that information is now available from __ErrorLine. The line number is still included when raised during Validation. + COMCOUNT, FIELDCOUNT, REPCOUNT and SUBCOUNT will raise an error if given an invalid HL7 key instead of just returning zero. * Fixed blank, null, or "NOW" input to DATEDIFF raising an EConvertError. * Fixed a series of cascading errors when validating a boolean expression with a parentheses mismatch. Properly handled in normal non-validation usage. - HL7Script.exe: Removed the "Prompt to Continue on Error" preference added in the last release and removed prompting on errors altogether. Processing just stops and displays the error message in the log window after an error. This brings the behavior more in line with the service. HL7ScriptService 10.012 + Avoid redundant logging of errors since error processing will now do so by default. The service will still log an error if the script can't due to the logging level being set lower than Info. 2019-07-20 All Projects + Added the THL7Message.MessageTime property. Returns MSH.7, FHS.7, or BHS.7 if one of those is the first segment. Otherwise blank. + Updated the THL7Message.ControlID property to return MSH.10, FHS.11, or BHS.11 if one of those is the first segment. Otherwise blank. Formerly it would return MSH.10 only. HL7Script 10.210 + Added the DATEDIFF script function. + Added the __ErrorLine built-in variable for use in error processing. + Refactored/simplified error handling for the error processing section. + HL7Script.exe: Added the "Prompt to Continue on Error" preference. I got tired of repeatedly being prompted while testing error handling. HL7ScriptService 10.011 + Refactored/simplified error handling for the error processing section. 2019-07-13 All Projects + Started moving release notes over one year old into releasenotes_old.txt. + Started removing deprecated features one year after deprecation. HL7Script 10.200 + Added the error processing section, . + Added the __ErrorText and __ErrorType built-in variables. + No longer force a prefix of "ERROR: " onto ERROR command text, but will default to "ERROR" if the text ends up blank. !- Removed the deprecated LOGGLOBALS command. !- Removed the deprecated use of LOADVARS with an equal sign in INIT section. HL7ScriptService 10.010 + Added handling of the script error processing section. + Added the :ErrorType parameter to the Error SQL. + The error type is included when the service logs errors as "[Type] Text". 2019-07-06 HL7Script 10.120 + Made the __OutputMsgStr/Text variables read-write to allow the output HL7 message to be set from any data, e.g. a message retrieved from a database. + Added the __AnonymizerDef and __NamedFieldsDef built-in variables to allow the definitions to come from data as well as a file. + Added the W@ Double Quote data modifier. + Added the J@ data modifier (the last remaining unassigned letter!) as a shortcut for the EXISTS script function. + Added the SLEEP command. + Added the EXECUTE script function. - Deprecated the SHELL script function in favor of the more flexible EXECUTE. + Continuing QA script coverage improvements (now over 1300 lines): * Fixed expression loops ignoring BREAK. * Fixed text/csv loops ignoring BREAK and QUIT. * Fixed blanks when reading the __DebugData and __Epsilon built-in variables. Assigning them worked as expected. * Fixed INC and DEC not allowing whitespace around the optional equal sign. 2019-06-29 HL7Script 10.110 + GREATLY improved the comprehensive test script which found the following: * No longer cache pre-parsed IF/ELSEIF/ELSE blocks inside of loops because the question marks and other replacements in the cached lines were not being updated for iterations beyond the first. * Fixed script function arguments being parsed like csv data and interpreting things like HL7 NULLs ("") as empty quotes. * Fixed XML GET prematurely evaluating the variable name argument. * Fixed some HL7 commands prematurely evaluating the segment/field key. * Fixed HL7 IREPLACE not properly finding case-insensitive values. * Fixed validation raising a closed dataset exception in LOOP QUERY. * Fixed validation warning on all properly prefixed variable names in SET. * HL7Script_NPPLang.xml was missing a few HL7 command keywords. + Added the HL7 REPLACE "WHOLE" option to match on whole values only. + LOGVARS now supports the full comma-separated wildcard list like SAVEVARS instead of only a single wildcard. 2019-06-22 HL7Script 10.101 * Fixed an "Invalid or blank variable name" error introduced in 10.100. Sorry! Poorly tested last-minute addition, improving automated tests. * Fixed the FILEPART script function not returning anything. + Added the "S" part to FILEPART to return the file Stripped of its extension. -------------------------------------------------------------------------------- For release notes older than one year, see releasenotes_old.txt --------------------------------------------------------------------------------