Question Scott Roth · Apr 21, 2021 First REST Operation - Custom Header I have a vendor that is sending an HL7 message. But when I asked for more detail about their mapping tables, they told me they typically don't supply that but supply an API for customers to call so they don't have to define tables and it is more dynamic. So with that being said I am creating my first REST operation. I understand the gist of how a REST operation works in working with other types out Non HL7 Operations (SOAP, SQL) before. You send a request and get a response back, that part I understand. #HL7 #REST API #Ensemble 0 14 2 905
Question Scott Roth · Mar 23, 2021 Using ChildCount from EnsLib.HL7.Message to get repeatable fields A while back I asked the developer community for a way to loop through repeatable HL7 segments and check them against a Data Lookup table within a Business Rule. The example I got was the following... #Business Rules #ObjectScript #Caché #HealthShare 0 1 0 644
Question Scott Roth · Feb 23, 2021 Sending request data to Business Object through Object Script So now that I have figured out how to send a Page via HTTP.OutboundAdapter, I have another question. I want to use a Function that all I have to do is pass two variables and it is sent to the HTTP.OutboundAdapter I created to send the Page. So.. If I have a class file that Extends Ens.Rule.FunctionSet, how do I force it to send a Request to my HTTP Business Operation, without having to go through a DTL, or Business Process? Thanks Scott #Business Operation #ObjectScript #Ensemble 0 3 0 744
Question Scott Roth · Feb 23, 2021 Using HTTP.OutboundAdapter to send Page I am trying to figure out how to send a Page via a HTTP.OutboundAdapter to a URL from Ensemble. We have a URL that I am able to pass PNo=xxxx%PMsg=xxxx as parameters to send the page to a pager. http://xxxxx.xxxxx.xxx/Employee/Tools/Paging/SendPage.aspx?PNo=1817&PMsg... When I send the above URL through a REST client I receive a Response of "SENT". But when I try to send it through the HTTP.OutboundAdpater I do not get a response. #Business Operation #ObjectScript #Ensemble 0 3 0 280
Question Scott Roth · Feb 4, 2021 What is the best practice when sending data via HTTPS outside a Hospital Network We are getting more and more request wondering if we could send/receive data via HTTPS to the outside world from within our Hospital Network. As you can imagine our Ensemble/Cache productions are not exposed to the DMZ or has access outside of the network. We only communicate with external vendors through a VPN, so communicating not using a VPN is rather new to us. Currently there is a project to get rid of using Proxy, and instead of through a Load Balancer that can use rules to filter out traffic, which adds another layer of complexity. #Business Operation #Business Service #SSL #System Administration #Ensemble 1 3 0 276
Question Scott Roth · Jan 14, 2021 SQL Inbound Adapter settings In the Inbound SQL Adapter settings, is it possible to specify more than 1 field as the Key Field Name? Because of the way the Query is being index in Ensemble by the Key Field Name, sometimes transactions get missed and I would like to see if we can add an additional key to the mix to ensure all the transactions are picked up. In this case the InterfaceTrigger is an ID that is auto generated by the table, and I would like to use that as well to ensure we don't miss transactions, and it does not throw any warning messages when it executes the Delete Query. #Business Service #SQL #Ensemble 0 1 0 325
Question Scott Roth · Jan 13, 2021 Handling Errors I have a case where our EMR is sending data, but not all the values needed for the Ancillary are valued properly and causes that message to error/halt processing on the Ancillary system, not ideal but its what they do. I would expect them to still process the message except that 1 field, but they don't. I want to add validation to make sure certain fields are valued correctly for the Vendor. So I add some statements to take those items that don't pass this validation out to a batch file with headers. #Business Operation #Business Process (BPL) #Code Snippet #DTL #Error Handling #Caché #Ensemble 0 9 0 968
Question Scott Roth · Jan 7, 2021 Looking up value in Cache Table via a Business Rule (Routing) I need another set of eyes to look at the following. Instead of a Data Lookup table, I wanted to try to lookup a value against a Cache table that I had build. So I thought I could write a function to run a simple SQL query against the Cache Table and return me a %Boolean value back to my routing rule. However today I found that it was not working properly. Can someone take a look at the following method and verify that I am doing this correct? index = column name value = HL7 field that I am passing into the method #Business Rules #ObjectScript #Caché #Ensemble 0 4 0 440
Question Scott Roth · Dec 9, 2020 Code migration using VSCode I am fairly new to using VSCode. I have used VSCode to create some files on our Test Server, now I need to move them to Production. Looking through the VSCode extension documentation, maybe I missed it but how to I migrate code from one workspace to another. In Studio I was use to exporting the code into an XML and just being able to import it on the Production server version of Studio. Thanks Scott #ObjectScript #Caché #VSCode 0 9 0 787
Question Scott Roth · Dec 7, 2020 Linked Table vs Connecting to outside DB using JDBC and a Business Process (BPL) I have a case where I need to look up the NPI provider against an External MS SQL database to retrieve our Provider Identifier to send to a downstream system. In the past I would use a Business Process (BPL) to connect to the outside MS SQL via JDBC and get that information for me. But I was thinking instead of creating a BPL process to do this, would it be better just to link to the outside MS SQL database table to retrieve the information in a SQL statement within a DTL? #Business Process (BPL) #Databases #DTL #JDBC #ObjectScript #SQL #Ensemble 0 3 0 329
Question Scott Roth · Nov 2, 2020 Missing Extensions in Action Bar within VSCode This may not be the right place to ask, but I am having some issues with the VSCode setup. I have installed the InterSystems Extensions but I am not seeing the InterSystems icon on the Action Bar long the left side of the screen. Can someone point me in the correct direction of what I need to do to fix this issue? Thanks Scott #VSCode #Other 0 1 0 1.4K
Question Scott Roth · Oct 9, 2020 Adding a Hidden Date (Date Inserted) column to a RecordMap Generated Cache Table I noticed when creating Record Map's within Ensemble that it is creating a Persistent cache table as it translates the file and puts it into the Record Map data structure. I was wondering if there was a way to add a column to the cache table that is Hidden from the record map, but is a calculated date value on when that record was inserted? #ObjectScript #Relational Tables #SQL #Caché #Ensemble 0 4 0 252
Question Scott Roth · Oct 8, 2020 Displaying Trace statements in DTL Editor Testing Tool (EnsPortal.Dialog.TestTransform.cls) Someone may have asked this before but is there a way to return the TRACE statements that we have placed in the Data transformation within the DTL Editor Testing Tool (EnsPortal.Dialog.TestTransform.cls)? Is this something we can get in an Enhancement request in for? It would save sometime in troubleshooting where an error might be in the DTL. Just wondering... Thanks Scott #Debugging #DTL #Testing #Tools #Ensemble 0 1 0 303
Question Scott Roth · Oct 6, 2020 Securing your Management Web Portal moving from http:// to https:// I was wondering if there was a certain procedure or documentation on securing (Https://) the Web Portal into IRIS/Ensemble? Currently we are using LDAP Delegated Authentication to access the Web Portal using LDAP. However as more and more emphasis is put on securing applications within networks, I can see Management/Security asking us to make sure that the web portal is more secure. #Security #SSL #System Administration #Ensemble #HealthShare 1 6 1 1.1K
Question Scott Roth · Aug 12, 2020 Is there a way to trigger system functions from Alerting in Ensemble We have a vendor that every couple of days will just stop transmitting messages, but still hold the TCP/IP connection open. No matter how many times we troubleshoot and talk with them, they don't seem to think its an issue with system. Normally if I just restart the service it will get the data flowing again. #Business Service #Error Handling #ObjectScript #Ensemble 0 3 0 281
Question Scott Roth · Jun 9, 2020 Querying a Cache Table from a Business Rule After all these years of doing basic Ensemble work, I am just beginning to venture into using Cache Tables instead of either Data Lookup tables, or what I know of Outside SQL tables using JDBC. I have several Cache SQL tables that I am building for a project I am working on. #Business Rules #ObjectScript #SQL #Ensemble 0 9 0 450
Question Scott Roth · Jun 3, 2020 Routing Rule - Syntax Error Cache for UNIX (IBM AIX for System Power System-64) 2018.1.3 (Build 414U) Mon Oct 28 2019 11:24:02 EDT [HealthShare Modules:Core:15.032.9026 + Linkage Engine:15.032.9026] #Business Rules #Ensemble 0 3 0 228
Question Scott Roth · Feb 6, 2020 Whats the difference between the CLS files and CSP pages Throughout my years working within HealthShare\Ensemble, I have been able to mimic the Data Lookup page trimming it down to give our Ancillary areas access to modify their own data Lookup tables. I am currently working on building a CSP application to allow certain users to update MS SQL tables by going through HealthShare. I thought all I had to was create the CSP pages and grant access. I am able to access it off my desktop, but when I have a user try to access the application, they get the sign in but then it doesn't do anything. So I think I might be missing something. #CSP #HealthShare 0 1 1 466
Question Scott Roth · Jan 23, 2020 Uploading gif/image into CSP page Ok so I am way outside of my comfort zone, and had to build an application using CSP to give users the ability to access SQL configuration tables. These SQL Configuration tables will affect the data that is sent to the downstream system. I saw in the examples where we were able to import GIF's/IMAGES into the CSP folders to use as a reference in our CSP pages. My question is how do you do that? If I try to import through studio, it tells me the file is invalid. Just trying to make it a little more user friendly then blocks on a page. #Beginner #CSP #HTML #SQL #Studio #HealthShare 0 1 0 966
Question Scott Roth · Jan 10, 2020 Remote Gateway Error: JDBC Gateway SP execute(0) error 0: Access to the remote server is denied because no login-mapping exists. I am working on a BPL to take data from a MS SQL database and create an HL7 Materials Message for our EMR. I have done this plenty of times in the past however I am running into an error. "Remote Gateway Error: JDBC Gateway SP execute(0) error 0: Access to the remote server is denied because no login-mapping exists." What is confusing is that this BPL doesn't differ from any of my other BPLs in connecting to MS SQL Server. I know I am missing something.. #Business Operation #Business Process (BPL) #Callout #ObjectScript #SQL #Ensemble 0 3 0 741