Encontrar

Anuncio
· 2 jul, 2024

InterSystems Open Exchange Applications Digest, June 2024

Hello and welcome to the June 2024 Open Exchange Newsletter.
General Stats:
4 new apps in June
424 downloads in June
962 applications all time
35,278 downloads all time
2,728 developers joined
New Applications
AdvancedIRISBISamples
By Peter Steiwer
iris-flask-template
By Guillaume Rongier
iris-django-template
By Guillaume Rongier
iris-fastapi-template
By Guillaume Rongier
New Releases
SQL DATA LENS by Andreas Schneider
v3.17.0

3.17 released on 2024-05-30

  • ENH : New Driver 3.8.4 from InterSystems IRIS 2024.1 added
  • ENH : TableViewer : Some driver ignore the setMaxRows Paramter like DuckDB. So for some databases the row limitation is done by TOP x or LIMIT x
  • ENH : TableViewer : Column size in grid optimized
  • ENH : TableViewer : Count rows function recognizes keywords in object names that need to be quoted. So now less errors when counting on system tables.
  • ENH : Flat Look and Feel updated to 3.4.1 (https://github.com/JFormDesigner/FlatLaf) – more Windows 11 features
  • ENH : Many internal libs upgraded
  • FIXED: Notepad content was multiplied after close and reopen the notepad tab
  • ENH : DuckDB driver upgraded to 0.10.3
  • FIXED: SQL History : Threading issue fixed

3.16 released on 2023-10-08

  • ENH : TableViewer : “open in new tab” improved
  • ENH : Cached Queries : Delete selected cached query and delete all cached queries for selected tabel is now working for IRIS
  • ENH : SQL Editor : Copy table on server side works now for IRIS and use the CREATE TABLE
<
table> AS SELECT… syntax * ENH : SQL Editor : IRIS improvment: Within SQL Editor the plain execution plan can be shown * ENH : SQL Editor : New connect button on toolbar to switch fast to another server \ database * * ENH : Management\Databases : More details for IRIS and Caché are now displayed for database files * * ENH : Management\Log files : Log File viewer now with mono font * * ENH : Management\Log files : journal.log entries are now displayed for IRIS * ENH : Management\SQL Gateway : SQL Gateway entries can now be deleted * * ENH : Management\SQL Gateway : Create a server-side IRIS SQL Gateway connection based on local connections configured in SQL DATA LENS * ENH : Removed Caché database drivers older than 2018.1. This is now the only database driver for Caché that is included. * ENH : Removed IRIS database drivers for IRIS 2019.1, IRIS 2020.1, 2021.1, 2022.1 * The new default driver for InterSystems is IRIS 2023.1 * ENH : Support and Driver for DuckDB added * FIXED: Cached Queries node shows the correct item count * FIXED: Globals node shows the correct item count * FIXED: SQL Editor : better query plan support for IRIS * FIXED: Profiling : added PStats support for IRIS
v3.18.0
  • ENH : SQL Editor : More keywords for Intersystems IRIS integrated
  • ENH : TableViewer : Show storage details for IRIS, like table (global) sizes
  • ENH : The licensing system has been updated to fix issues with error code 28 based on a disabled network adapter. The activation process needs to read all of a computer’s components to get an accurate “fingerprint” of the computer, and this includes all real (aka non-virtualised) network adapters attached to the computer.
  • ENH : ServerNavigator : Database metadata viewer improved with more detail and better sorting
  • ENH : DuckDB (driver) upgraded to 1.0
  • ENH : New shortcut to create a in memory DuckDB connection
  • ENH : Simply drag and drop the csv\parquet\json file onto the DuckDB connection and the necessary SQL statements will be generated to read the file with ease.
  • FIXED: Connection dialogue box is now centred on the main frame
  • FIXED: DuckDB connections are created with the right duckDB icon. You need to recreate the entries to fix this problem for existing connections.
BridgeWorks VDM by Tony Coffman
v2024.5.28
Important Note
: We highly recommend clients do not update directly to production environments without first testing in a demo environment.

 

What's New?
Major development on core engine components that improve VDM's overall performance, scalability, stability and usability. (Task 1596) Replaced the Real data type for MDS / Datawarehouse with Dec (18,4). (Task 1578)

Bug Fixes

(Bug 1622) - VDM: Scheduler - Can't Access Execution (Bug 1617) - VDM: Scheduler - Calendar File Reading (Bug 1620) - VDM: Unable to Modify View Order in Job (Bug 1607) - VDM: Insights - Visualize Not Working (Bug 1609) - VDM: My SQL Errors reflect Katabat (Bug 1610) - VDM: MDS - Separate Session / MDS with Service (Bug 1600) - VDM: Tables and Fields - WebReports Form Cut Off (Bug 1601) - VDM: InterProse Connections - NBSP Special Character (Bug 1600) - VDM: Data Warehouse - Combo Box Duplicates Connection Profiles (Bug 1581) - VDM: Parameters - Number of Parameter Pages
v2024.6.18
What's New?
  • Major development on core engine components (23.2.6) that improve VDM's overall performance, scalability, stability and usability. (Task 1615)
  • VDM's Datawarehouse feature now stores Grid Level expressions for both the Detail and Summary Grids. (Feature 1627)
Bug Fixes
  • (Bug 1621) - VDM: Scheduler Appointment Options Differ Using Database vs Calendar File
    • When the Calendar file is used, we don't have all the options available. (Minutely / Hourly / Time Zone, etc.)
  • (Bug 1623) - VDM: Scheduler - Job Management Errors
    • After changing view / execution order and saving the job, the next job you would open will have the wrong order of your jobs.
    • Adding views to an existing job would cause job to inherit the execution of the selected view when clicking add.
  • (Bug 1624) - VDM: VDM: Finished Reports - Designer Button Opening Multiple Tabs
    • When clicking on the FInished Report Designer Button with the designer already open, VDM would open another tab for the Finished Report.
BridgeWorks WebReports by Tony Coffman
v2024.5.28

 

What's New?
  • This is the latest release available to match the current VDM release (2024.2.6.0) as of 2/6/2024.
    • We always recommend that the latest (matching) version of VDM and WebReports are installed.
  • We have added WebReports compatibility for the following VDM features: (Feature 1591)
    • Cleaning MDX queries for characters
    • The ability to run multi dimensional MDX queries
    • The ability to run MDX MQ views
    • The ability to differentiate between PivotExecute and MDXExecute
    • Added to Intersystems IRIS BI
  • Add the functionality needed to execute single level MDX Queries to IRIS Analytics BI/DeepSee to WebReports (Feature 1593)
Breaking Changes:
The connection string requires the following added to work with .Net 8.
  • ;Encrypt=Yes;TrustServerCertificate=Yes;
 
Version 2024.x.x requires .Net 8 (Download)
  • Replaced the Real data type for MDS / Datawarehouse with Dec(18,4). (Task 1579)
  • We have updated the Default Connection String in the appsettings.json for WebReports. This will address the Breaking Change in this build for any new users of WebReports (any users with existing appsettings file will have to update it manually.) (Task 1594)
  • Major development on core engine components that improve VDM's overall performance, scalability, stability and usability. (Task 1596)

 

Bug Fixes
  • (Bug 1580) - WebReports: Parameters - Visualize Parameters Not Being Passed
  • (Bug 1605) - WebReports: MFA - 400 Error
  • (Bug 1619) - WebReports: Error Updating Roles (More than 1024 Items)
v2024.6.18
What's New?
  • Major development on core engine components (23.2.6) that improve WebReports's overall performance, scalability, stability and usability. (Task 1616)
iris-angular-template by Elijah Tamarchenko
v0.2.0
  • Added isc.codetidy to repository
DeepSeeWeb by Anton Gnibeda
v3.2.25
  • fixed issue with slow data refresh on chart widgets
v3.2.26
  • fixed default filter value with "Not" issue
Metrics example by David Underhill
v1.0.1
Including R Cemper's Docker updates
samples-bi-demo by Evgeny Shvarov
v1.0.1
Fixed the issue with the Map Widget
Intersystems-Monitoring by Teunis Stolker
v1.0.10
  • Simplified IRISELK.BusinessOperation.LogstashOutbound
  • Allowed for monitoring subnode in configuration.json
v1.0.11
Installer improvements
v1.0.12
Fixed message mapping in LogstashOutbound
v1.0.13
Added update for Intersystems-Monitoring in Config.LoadFile()
Most downloaded
WebTerminal
By Nikita Savchenko
MDX2JSON
By Eduard Lebedyuk
DeepSeeWeb
By Anton Gnibeda
passwordless
By Sergey Mikhailenko
ssl-client
By Evgeny Shvarov
Test Coverage Tool
By Timothy Leavitt
iris-cron-task
By Evgeny Shvarov
Intersystems-Monitoring
By Teunis Stolker
csvgen
By Evgeny Shvarov
June, 2024Month at a GlanceInterSystems Open Exchange
Comentarios (0)1
Inicie sesión o regístrese para continuar
Pregunta
· 2 jul, 2024

getFile from rest api and swagger

I use a swagger file and ##class(%REST.API).CreateApplication to create the rest api.

There is an interesting post: https://community.intersystems.com/post/download-file-rest-api-operation, but it is code, not a swagger configuration. disp.cls returns always a header content : application/json that of course fails as I am not always returning a json

I can not figure out what to put in swagger. Some examples I tried:

produces:
- application/pdf
- image/png

responses:
   200:
      schema:
           type: file
responses:
   200:
       schema:
           type: string
           format: binary

Thank you

2 comentarios
Comentarios (2)0
Inicie sesión o regístrese para continuar
Pregunta
· 2 jul, 2024

How to call another method in a generated method

I have a class with two methods

Class Foo.Bar
{

ClassMethod Helper()
{
// do something
}

ClassMethod Generated() [ CodeMode = objectgenerator ]
{
do ..Helper()
// do something else
}

}

Since the method Generated is run before the class is compiled, the call to do ..Helper() fails. Is there a way around this other than manual inlining?

3 comentarios
Comentarios (3)3
Inicie sesión o regístrese para continuar
Job
· 2 jul, 2024

Looking for Integration Engineer expertise in IRIS

Hello All,

I am looking for some Integration engineers who have expertise in IRIS/Healthshare in North America.

Have a project going on , if interested please feel free to reach out to me.

1 Comentario
Comentarios (1)2
Inicie sesión o regístrese para continuar
Pregunta
· 2 jul, 2024

Help Needed: Empty Bundle When Converting CCDA to FHIR in InterSystems IRIS

Hello Community,

I'm a beginner and currently working on a project to convert CCDA files to FHIR using InterSystems IRIS. I have developed a web form to upload CCDA files, and I'm attempting to convert the uploaded CCDA files to FHIR. However, I am encountering an issue where the conversion process results in an empty entry.
Here's the Output it displays on HTML page:

Size of CCDA Stream: 74152
vR4
{"resourceType":"Bundle","type":"transaction","entry":[]}

Here is my code: CCDtoFHIR.csp

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <meta name="viewport" content="width=device-width, initial-scale=1.0">
    <title>CCDA to FHIR Converter</title>
</head>
<body>
    <section>
        <div>
            <p>CCDA to FHIR Converter</p>
            <div>
                <div>
                    <h1>Upload CCDA File</h1>
                    <form id="fileUploadForm" enctype="multipart/form-data" method="post" action="CCDtoFHIR.csp">
                        <div>
                            <label for="file">Upload CCDA File</label>
                            <input type="file" name="file" id="file" required>
                        </div>
                        <div>
                            <button type="submit">Upload</button>
                        </div>
                    </form>
                    <csp:if condition='($data(%request.MimeData("file",1)))'>
                        <hr><br>
                        <b>FHIR Conversion Result:</b><br>
                        <ul>
                            <script language="cache" runat="server">
                                try {
                                    // Read the uploaded file stream
                                    set ccdaStream = ##class(%Stream.TmpBinary).%New()
                                    do ccdaStream.CopyFrom(%request.MimeData("file",1))
                                    
                                    // Ensure the stream is an object
                                    if ('$isobject(ccdaStream)) {
                                        write "Failed to read uploaded file stream"
                                        quit
                                    }
                                    
                                    // Debug: Output the size of the CCDA stream
                                    write "Size of CCDA Stream: ", ccdaStream.Size, "<br>"
                                    
                                    // Read some content from the stream for debugging
                                    do ccdaStream.Rewind()

                                    // Determine the appropriate XSLT transform based on the document type
                                    set xsltTransform = "SDA3/CCDA-to-SDA.xsl"  // Default to CCDA-to-SDA
                                    
                                    // Convert CCDA to SDA3 using HealthShare's built-in methods
                                    set tTransformer = ##class(HS.Util.XSLTTransformer).%New()
                                    set tSC = tTransformer.Transform(ccdaStream, xsltTransform, .tSDA3Stream)

                                    if $$$ISERR(tSC) {
                                        write "Transformation to SDA3 failed", "<br>"
                                        quit
                                    }
                                    
                                    set sdaStream = ##class(%Stream.TmpBinary).%New()
                                    do tSDA3Stream.Rewind()
                                    do sdaStream.CopyFrom(tSDA3Stream)
                                    
                                    // Convert SDA3 to FHIR using HealthShare's built-in methods
                                    set fhirStream = ##class(%Stream.TmpBinary).%New()
                                    set SDA3ToFHIRObject = ##class(HS.FHIR.DTL.Util.API.Transform.SDA3ToFHIR).TransformStream(tSDA3Stream, "HS.SDA3.Container", "R4")

                                    // Check if the transformation returned a valid bundle
                                    if '$isobject(SDA3ToFHIRObject.bundle) {
                                        write "Failed to transform SDA3 to FHIR", "<br>"
                                        quit
                                    }

                                    // Serialize the FHIR bundle to JSON
                                    do SDA3ToFHIRObject.bundle.%ToJSON(fhirStream)
                                    do fhirStream.Rewind()

                                    // Write the FHIR data to the response
                                    while ('fhirStream.AtEnd) {
                                        write fhirStream.ReadLine(), "<br>"
                                    }
                                } catch (ex) {
                                    // Handle exceptions
                                    write "Error during conversion: ", ex.DisplayString(), "<br>"
                                }
                            </script>
                        </ul>
                    </csp:if>
                </div>
            </div>
        </div>
    </section>
</body>
</html>

 

Problem Description:

  • The CCDA file uploads successfully, and I can see the size of the uploaded stream.
  • The transformation to SDA3 seems to work fine without errors.
  • The conversion from SDA3 to FHIR appears to be successful, but the resulting FHIR bundle is empty.

Debugging Steps:

  • I've ensured that the CCDA stream is read correctly.
  • I confirmed that the transformation to SDA3 does not produce any errors.
  • I attempted to output some content from the SDA3 stream, which seems fine.
  • The FHIR transformation does not produce any errors, but the resulting FHIR bundle is empty.

Questions:

  1. What could be the reason for obtaining an empty FHIR bundle after the transformation?
  2. Are there any additional debugging steps or checks I can perform to identify the issue?
  3. Is there a specific configuration or additional steps required for the HS.FHIR.DTL.Util.API.Transform.SDA3ToFHIR transformation process?
9 comentarios
Comentarios (9)1
Inicie sesión o regístrese para continuar