Hi,

I'm trying to ultimately create a function that I can use with HL7 messages that calls a stored procedure held on a SQL Server.

Initially I tried extending the function class to use the sql inbound adapter and/or EnsLib.SQL.Common, but this wouldn't work from the class method for the function.

Then I attempted to use the linked stored procedure using the wizard where it connected fine and I could find the sp but but it wouldn't return any data when ran. The test sp should just return an int.

The class document produced is this.

What is npm-iris? 

N.P.M stands for "No Project Mess."

N.P.M. is a Project & Task Management app that uses InterSystems IRIS and Bootstrap 4.

No Project Mess is created to help developers and small business companies to reduce complexity in their daily problems, with a simple and intuitive projects and tasks management software. 

It offers different views for your tasks, from a spreadsheet, kanban, calendar, or even Gantt!

Hey Developers!

We're pleased to announce the next competition of creating open-source solutions using InterSystems IRIS! Please welcome:

⚡️ InterSystems Full Stack Contest ⚡️

Duration: September 21 - October 11, 2020

Hello, we would need some help:

We would like to use a Transformation to convert an ORU_R30 2.3 to ORU_R30 2.5

However Ensemble does not have a HL7 Schema for ORU R_30 2.3

So then our original message is not being recognized:

→ How could we let Ensemble recognize the ORU R30 2.3 structure to be able to use a Transformation?

We have read:

https://cedocs.intersystems.com/latest/csp/documatic/%25CSP.Documatic.c…

https://docs.intersystems.com/irisforhealthlatest/csp/docbook/DocBook.U…

https://cedocs.intersystems.

Hi Community, 

We introduced Business Services Rewards on Global Masters, so now you have a great opportunity to highlight applications, solutions, services of your company on Developer Community and our social media, and even redeem a Google AdWords campaign for your OEX application!

Hi Community:

He switched gears fast, from HIV to #COVID19. Meet Dr. Bruce Walker. Learn about his work on a vaccine for #COVID19. Register now for Virtual Summit
 

If a global node contains special characters, (eg : a line returns), it will be displayed like this in Portal ("System > Globals > View Global Data" panel) :

^A(1) = "this is"_$c(13,10)_"a test"

I would like to export global data to a txt file using a similar format.

I already wrote the main code (that loops on all nodes and dump them to file), the problem is how to handle special characters.
For the moment I replace them manually one by one. It works, but it's far from perfect :

set text = .

Hi Team, 

      My Cache license expired, where do I get a developer license (not production). Please guide me.

Thanks & Regards,

Ponnumani Gurusamy.

I'm not sure how to go about building this scenario:

1. I FTP PUT a file "data.txt" to external directory
2. 3rd party processes that file
3. 3rd party creates a log file "errors.txt" into the same directory
4. My integration build should now 
   1. notice that there is a "errors.txt" file
   2. FTP GET that log file, delete it from server and process it 
   3. but we should also delete the "data.txt" from the server as it is "used" and should no longer be there. It is essential that "data.txt" must only be deleted if there is an "errors.txt" file and we have downloaded it

Can steps 4.1 - 4.

Hello,

We would need your help:

We are processing a HL7 message.

Its OBX segment has 4318 characters

1) We get the OBX with the following line of code:

set textoCompleto = request.GetValueAt("5:3.2")

When we output its length with:

$$$LOGINFO("textoCompleto: "_textoCompleto)

It shows:

     $LENGTH(textoCompleto): 3497

 - So as we see it is being shortened

2) We get the OBX with the following line of code:

set textoCompleto = $PIECE(request.

Hey Developers,

Here is a digest of the Developer Community videos on InterSystems Developers YouTube Channel in September 2020:

Trying to extract "x, y", and only the "x" is being extracted because the "," is the separator  

The ":"  is set to extract everything after this 

"Working Example": xyz,

"Not  Working Example": "x,  y",

$EXTRACT($P($P(pData,",",78),":",2),2,$L($P($P(pData,",",78),":",2))-1)

Any ideas on how to extract the whole field on the example with the "," in the field

Hi Community,

I have a property in a class, properties Initial Expression set to 1 Property Test As %Status [ InitialExpression = "1" ];, while updating the property we have set to 0 through code. If I look the field in Logic Mode its shows 0 but in Display and ODBC mode why it shows, ERROR #00: (no error description). Does this Error cause any problem? What are the reasons for this error #00? Kindly help.

Thanks in advance.

I am looking to find a way to search Studio and find transforms that do NOT contain certain string or logic. How can I find the ones that do not have that string?

Hello!

I have installed windows 10 and cache 2018.1.0.184.0

I run terminal not from cache cube but through localDemon.exe (for report outputting from my programs to excel).

All worked fine but after some time error occured "Cannot load supporting modules"  (in attached file) and localDemon.exe is not launching.

But terminal from cache cube is still launching without problems (but from it reports are not working, localDemon.exe is required)

I thought it is windows defender or antivirus put some  localDemon.exe module to quarantine but quarantine is empty.

Hi Community:

Registration for the first-ever InterSystems Virtual Summit 2020 is now open! Join us for a multi-week event that, like Global Summit, ranges from thought leadership to technical Focus Sessions and even 1:1 “Ask the Expert” sessions. Register now. It's free.

So, one day you're working away at WidgetsDirect, the leading supplier of widget and widget accessories, when your boss asks you to develop the new customer facing portal to allow the client base to access the next generation of Widgets..... and he wants you to use Angular 1.x to read into the department's Caché server.   

There's only one problem:  You've never used Angular, and don't know how to make it talk to Caché.

This guide is going to walk through the process of setting up a full Angular stack which communicates with a Caché backend using JSON over

Hi, 

In Atelier I can click File --> New --> Class File, and File --> New --> Custom File etc to launch various wizards and templates to help me quickly create DeepSee KPI classes, %Installer manifests, Web Services and the like. Of course, all these are available through Studio as well. Is there anything similar in VSCode? If so where? I've looked at several videos and the documentation, but I haven't seen anything.

Thanks!

David

Hi Developers!

Please welcome the new video on InterSystems Developers YouTube:

⏯ Data Platform Scalability

Hi All,

I hope all are good.

I would like to know that whether InterSystems will support LDAPS or not. I have idea about LDAP but not about LDAPS. Please suggest me If anyone has any documents or links.

Thanks and Regards, Gunwant

I need to get a file in a directory and when clicking on the download button, this file will be downloaded on the client side.

</head>
<csp:class super="%CSP.Page,Relatorio.GeraCSV">
<body> <input type="button" value="Gera Relatório" onClick="#server(..serve())#"> </body>

ClassMethod serve() As %Status
{
set name = "C:\Users\gpemm\Desktop\myfile.csv"
    #dim sc As %Status = $$$OK
    #dim %response As %CSP.Response
    kill %request.Data
    set %request.Data("STREAMOID",1)= ##class(%CSP.StreamServer).Encrypt(##class(%CSP.StreamServer).GetOidForFile(name))
    if ##class(%CSP.StreamServer)

Hi developers!

Want to discuss with you the case of %Status.

If you familiar with ObjectScript you know what is it. I'd love to hear the history of the case why it had appeared in ObjectScript but it turned out that almost every system/library classmethods return %Status and there is a whole set of tools to deal with it.

What is does it gives you the responsibility to check the value or %Status of every system method you call.

E.g. if you save the data of the persistent class,  you should never call like this:

do obj.%Save()

you need to call:

set sc=obj.%Save()

if $$$ISERR(sc) do // something or quit.

Hi all, I am having problems trying to get Docker to run correctly on my Linux Mint machine.

I did the following:

1. Installed Docker.

docker --version

Docker version 19.03.6, build 369ce74a3c

docker-compose -v

docker-compose version 1.17.1, build unknown

2. Downloaded zip from https://github.com/intersystems-community/iris-fullstack-template/tree/42f9c174a9a4e63cb5eb3eb646abf3930a6e4d31

and unzipped it

3. Entered the following command:

docker-compose up -d

This generated the following error:

ERROR: Version in "./docker-compose.yml" is unsupported.

Hi,  Need to run the ^%G command from a program, send it the name of the global and capture the result into a variable,

I need it in a variable so that I can do a FIND on the result.

Thanks,
Bob

Hi, everyone!

InterSystems Certification is once again offering a promotion with InterSystems yearly conference, Virtual Summit 2020!

Read details here. Let's get certified!

Hi Developers!

How do you handle errors with &sql a.k.a. embedded SQL?
I think I found a universal error-handling template which works in any situation:

&sql(SELECT * FROM Sample.Person)

if SQLCODE < 0 throw ##class(%Exception.SQL).CreateFromSQLCODE(SQLCODE,"Context description")

What is your choice?

Whenever the Windows SNMP Service restarts, the snmpdbg log says the following.  

16:58:25 :Debug tracing enabled for SNMP agent
16:58:25 :SnmpExtensionInit called, pid=4432, tid=12276
16:58:25 :CreateEvent for CacheSNMPTrap suceeded
16:58:25 :register Cache OID 1.3.6.1.4.1.16563.1
16:58:25 :Get all Cache configs ... 16:58:25 :found 1 configs
16:58:25 :Add ENSEMBLE config to list ... 
16:58:25 :RegOpenKey for SOFTWARE\InterSystems\Cache\Configurations\ENSEMBLE\Properties
16:58:25 :Open config file

The InterSystems IRIS has an integration engine with these core elements:

1. Adapters: are inbound (data/message input/request) and outbound (data/message output/response)  integration logic specialized in the type of data or message protocol (file, http, etc.). They are the interface to allows connect with source or target data repositories or systems.

2. DTL: is a component to mapping and transform data between two components in the flow orchestration.

3. BPL: is a component executing BPEL language to execute integration/orchestration flow.

4. Native API: is possible integrate with Java, .