go to post Scott Roth · Apr 15, 2020 I would believe the only way to put a schema filter in would be within your query and not in the connection string.
go to post Scott Roth · Mar 2, 2020 I found with create a Inbound BS, you can't really use the Delete query as an update statement. Either you place the update statement within your BPL, or truly make the Delete query a Delete query on your inbound service.
go to post Scott Roth · Jan 29, 2020 Make sure you are also using EnsLib.RecordMap.Operation.BatchFileOperation as your operation and you define the header in it as well.
go to post Scott Roth · Nov 15, 2019 Have you used JDBC drivers before? I have a couple of connections that I have created through JDBC to connect to Oracle to pull data from an Oracle table to create an HL7 message. Currently we are using the Oracle JDBC driver to connect to the Oracle system.
go to post Scott Roth · Oct 30, 2019 I figured it out on my own. It did not like <assign value='source.GetFieldStreamRaw(.tStream,"ORCgrp(1).OBRgrp(1).OBXgrp(k1).OBX:ObservationValue(1).AlternateText}",tRemainder)' property='tSC' action='set' /> I had to change it to <assign value='source.GetFieldStreamRaw(.tStream,"ORCgrp(1).OBRgrp(1).OBXgrp("_k1_").OBX:5.5",.tRemainder)' property='tSC' action='set' />
go to post Scott Roth · Oct 14, 2019 When we were going through our conversion from egate to Ensemble, it was suggested not to have anymore that 25 rules within a Business Router. Anymore than that caused us severe performance issues when it came to making sure our downstream systems was receiving the messages in time. Scott Roth
go to post Scott Roth · Oct 8, 2019 I am not aware that a CSV could be read in via EnsLib.File.PassthroughService. From what I was taught a CSV would have to be mapped to a RecordMap then you can parse out the CSV using EnsLib.RecordMap.Service.FileService. https://docs.intersystems.com/healthconnect20191/csp/docbook/DocBook.UI.Page.cls?KEY=EGDV_recmap Scott
go to post Scott Roth · Sep 19, 2019 Not sure if this will answer your question or not, but we had to move to the jTDS JDBC driver in order to pass an AD account through a connection. jdbc:jtds:sqlserver://(server name/port) ;instance=tp;domain=osumc;useNTLMv2=true;cacheMetaData=true;prepareSQL=2;
go to post Scott Roth · Aug 29, 2019 https://www.amazon.com/Cach%C3%A9-ObjectScript-MUMPS-Technical-Learning/dp/1466499087/ref=sr_1_fkmr0_1?keywords=Cache%60+object+script+and+mumps&qid=1567084211&s=gateway&sr=8-1-fkmr0
go to post Scott Roth · Mar 7, 2019 With a little help I have built the following Method to Decode and save off the Encoded pdf but return me the directory that I saved the PDF under....ClassMethod DecodeBase64HL7ToFile(base64 As %Stream.GlobalBinary, Ancillary As %String, FileName As %String) As %String{set ArchDir = "/ensemble/data/transfer/AncillaryPDF/"set ArchAncDir = ArchDir_Ancillary_"/"set FaxDateDir = ArchAncDir_$PIECE($ZDATE($HOROLOG,7)," ",1)_"-"_$PIECE($ZDATE($HOROLOG,7)," ",2)_"-1/"if '##class(%Library.File).DirectoryExists(ArchDir){do ##class(%Library.File).CreateDirectory(ArchDir) }if '##class(%Library.File).DirectoryExists(ArchAncDir){do ##class(%Library.File).CreateDirectory(ArchAncDir) }if '##class(%Library.File).DirectoryExists(FaxDateDir){do ##class(%Library.File).CreateDirectory(FaxDateDir) }set Oref = ##class(%FileBinaryStream).%New()///$$$LOGINFO(FaxDateDir_FileName)set Oref.Filename = FaxDateDir_FileNameDo base64.Rewind()While 'base64.AtEnd { set ln = base64.ReadLine() set lnDecoded = $system.Encryption.Base64Decode(ln)do Oref.Write(lnDecoded)}Do Oref.%Save()set PDFFilePath = FaxDateDir_FileNamereturn PDFFilePath}
go to post Scott Roth · Feb 13, 2019 the Syntax for MAXLEN was wrong. Instead of MAXLEN(5000) it should of been MAXLEN = 5000
go to post Scott Roth · Feb 6, 2019 We are still somewhat old school eGate folks in this sense. We send all of our transactions to flat files, then we can use those files to feed in data into the test system if needed. We did this when we moved from eGate to Ensemble to make sure we were getting the same transactions and counts.
go to post Scott Roth · Feb 6, 2019 Suggest that WRC is probably the best option to help you troubleshoot this issue. It can be numerous things from Security, or the system not running like it should.
go to post Scott Roth · Feb 5, 2019 You can use split on ZC02, get the length, then for each number that it split you create a separate DFT message.
go to post Scott Roth · Jan 10, 2019 I didn't originally write the code but it works. My guess is my teammate who wrote it was trying to compensate for partial values, as in decimals.
go to post Scott Roth · Jan 10, 2019 Here is a method we built for our use.ClassMethod IsNumeric(value As %String) As %Boolean{//Load value into local var tNumberset tNumber = value//Use $extract to get the FULL VALUE into an internal format for $isvalidnumset tFullValue = $EXTRACT(tNumber,1,$length(tNumber))//Use $isvalidnum to check if the full value is numeric (ex: 123456789 = true, 123456789x = false)set tNumberIsValid = $ISVALIDNUM(tFullValue)//At this point, we simply return tNumberIsValid (it will either be 1, true or 0, false)quit tNumberIsValid}
go to post Scott Roth · Jan 4, 2019 It seems Node .js is not going to be a viable option. My systems folks said it was compliled with a different GCC than what we have loaded on our AIX Server. If we were to load Node.js it would mess up the rest of the scripting (PERL, Shell) we do on the server.Javascript was just one idea, I bet there are many other types of code that can be used to adjust an image resolution. Is there anything that can be called from Atelier without having to install a bunch of software on the server?
go to post Scott Roth · Dec 20, 2018 Here is the same code but from the Studio (class view)<assign value='##class(%Stream.GlobalCharacter).%New()' property='tStream' action='set' /><assign value='source.GetFieldStreamRaw(.tStream,"ORCgrp(1).OBRgrp(1).OBXgrp(1).OBX:ObservationValue(1).AlternateText",.tRemainder)' property='tSC' action='set' /><if condition='..Length($get(tSC))>0' ><true><assign value='"1"' property='target.{ORCgrp(1).OBRgrp(1).OBXgrp(1).OBX:SetIDOBX}' action='set' /><assign value='"ED"' property='target.{ORCgrp(1).OBRgrp(1).OBXgrp(1).OBX:ValueType}' action='set' /><assign value='"7"' property='target.{ORCgrp(1).OBRgrp(1).OBXgrp(1).OBX:ObservationIdentifier.Identifier}' action='set' /><assign value='"URL"' property='target.{ORCgrp(1).OBRgrp(1).OBXgrp(1).OBX:ObservationIdentifier.Text}' action='set' /><assign value='"EXTLRR"' property='target.{ORCgrp(1).OBRgrp(1).OBXgrp(1).OBX:ObservationIdentifier.NameofCodingSystem}' action='set' /><assign value='"1"' property='target.{ORCgrp(1).OBRgrp(1).OBXgrp(1).OBX:ObservationSubID}' action='set' /><assign value='"PDF"' property='target.{ORCgrp(1).OBRgrp(1).OBXgrp(1).OBX:ObservationValue(1).Identifier}' action='set' /><assign value='"TMSAUDIO"' property='target.{ORCgrp(1).OBRgrp(1).OBXgrp(1).OBX:ObservationValue(1).Text}' action='set' /><assign value='"PDF"' property='target.{ORCgrp(1).OBRgrp(1).OBXgrp(1).OBX:ObservationValue(1).NameofCodingSystem}' action='set' /><assign value='"Base64"' property='target.{ORCgrp(1).OBRgrp(1).OBXgrp(1).OBX:ObservationValue(1).AlternateIdentifier}' action='set' /><assign value='target.StoreFieldStreamRaw(tStream,"ORCgrp(1).OBRgrp(1).OBXgrp(1).OBX:ObservationValue(1).AlternateText", tRemainder)' property='tSC' action='set' /><assign value='""' property='$P(tRemainder,"|",11)' action='set' /></true></if>
go to post Scott Roth · Dec 19, 2018 With the help from WRC we converted the OBX stream to a GlobalCharacter Stream. See below as an example.