hi
I need help to import the HL7 message file into sql server using SAP Data Services..
anyone who did it before please help..
Regards
Announcements
Caché 2018.1.2 and Ensemble 2018.1.2 maintenance releases are now available.   Â
Last comment 11 days ago
Hi -
I'm having odd behaviors on my EC2 hosted IRIS Community instance.
When I configure a "custom login page" in the System Management Portal for my web application I'm seeing a few different behaviors that are under documented (and also undesired)
The old Caché documentation indicates that the custom login page could be a ".csp" file, but this seems to nor be the case (i kept getting "not found" errors, even though I could bring up the page directly from the url FOR the login.csp file. To get around this, I created an HTML file and then, at least, the login page could be found to be rendered
Last answer 11 days ago
In recent discussion on CachéQuality I was (friendly) blamed for old syntax promotion and deliberate obfuscation of the code. Therefore I decided to clarify my point and shed some light on one of possible source of side effects that may unexpectedly occur with RETURN command with an argument.
Last comment 11 days ago
Â
Keywords: Anaconda, Jupyter Notebook, Tensorflow GPU, Deep Learning, Python 3 and HealthShare  Â
1. Purpose and Objectives
This "Part I" is a quick record on how to set up a "simple" but popular deep learning demo environment step-by-step with a Python 3 binding to a HealthShare 2017.2.1 instance . I used a Win10 laptop at hand, but the approach works the same on MacOS and Linux.
Last week it was noticed that Python overtook Java by becoming the most popular language in PYPL Index. Tensorflow is a powerful computation engine, which is very popular in research and academic worlds too. HealthShare is a data platform that provides an unified care record of patients for care providers
Hello everyone 
I have a server configuration in a CSP Gateway installed on a PC (let's call it S2) different from the main one (let's call it S1). This configuration allows me to access a web application that is installed on S1, from a client C asking S2 for this webapp. But for now it works only in HTTP between C and S2, and we would like to use HTTPS (as it already works between S2 and S1).
First here are the tutos found in the doc:
https://docs.intersystems.com/latest/csp/docbook/DocBook.UI.Page.cls?KEY...
Last answer 12 March 2019 Last comment 12 days ago
InterSystems supports use of the InterSystems IRIS Docker images it provides on Linux only. Rather than executing containers as native processes, as on Linux platforms, Docker for Windows creates a Linux VM running under Hyper-V, the Windows virtualizer, to host containers. These additional layers add complexity that prevents InterSystems from supporting Docker for Windows at this time
Last comment 12 days ago
I am validating a v3 document against one xsd and using %XML.SAX.ContentHandler class . My requirment is to find the xpath of the error location. There is no method which does it.
I can find the line and offset using LocatePosition method.Â
Can someone help me on this.
ThanksÂ
Suman
Last answer 12 days ago
How can a remote webserver be configured to access the application on a different application server ?
Example: customersdomain.com running on the customer's server, to access the csp application running on the service provider's own server ?
Last answer 12 days ago
Hi there,
  I'm trying to develop a  program calling Cache REST service twice with Cors. The first is fetching some information of a patient with GET request, the second is using obtained information to call another REST service(implemented in the same class though) with POST to  perform other tasks.
Last answer 29 October 2018 Last comment 12 days ago
I am using EnsLib.RecordMap.Operation.FileOperation to write a daily file with the name %Y%m%d.txt so that every day I will have one file as that day's date and a .txt extension.Â
Â
What I want to do is every morning around 1am or so, use EnsLib.RecordMap.Service.BatchFileService to pick up that recently completed file.Â
Â
Can you use operands in the File Spec field? I am assuming that %Y%m%d-1.txt will not work.
Â
Thanks in advance.
Last answer 13 days ago Last comment 13 days ago
HiÂ
Can I use a the SQL 'Table-Valued Parameter' when i call a store procedure in sql outbound adapter using ExecuteProcedure?
to pass multiple rows all together as a block, I need to process all the records in one transaction using commit and rollback (if failure)
ThanksÂ
Gadi
Â
Â
Last answer 13 days ago
Hope most of you already familiar with project CachéQuality from @Daniel Tamajon. For those who don’t know about it, it is a static syntax analyzer for your code written for InterSystems products. It may help you to find and solve many different types of issues in your code, and even possible bugs before clients will find it in production. So, with help of CachéQuality you will be able to deliver a better product. You can find the complete list of rules used to check ObjectScript code here.
It was already available in Studio. And now it is also available in VSCode.
Last comment 13 days ago
Sometimes global mapping of the same globals can be defined in different ways. E.g., I need to define it for 3 globals ^qAuditC, ^qAuditLog, ^qAuditLogC from the same database named APP-NOJOURN. Which approach should be better from the performance point of view?
1) qAudit* => APP-NOJOURN (one record in global mapping table)
or
2) qAuditCÂ =>Â APP-NOJOURN
qAuditLog =>Â APP-NOJOURN
qAuditLogC => APP-NOJOURN (three records in global mapping table)
From one hand, the less records in global mapping table, the better. From other hand, * can cause additional processing at run time. Global mapping table for a namespace contains about 20 records and can be compressed to 15 ones if "unduplicated" such way.
Any advice will be great appreciated.
P.S. I'm pretty sure that there would be no globals masked as qAudit* but those listed above.
Last answer 11 March 2019 Last comment 13 days ago
Hi Everyone!
New session recording from Global Summit 2018 is available on Developer Community YouTube Channel:
Â
So I have an interesting problem. I am going to be using a process and rule to determine if an HL7 message qualifies to be sent out, then using a record map to write certain aspects of that HL7 message to disk (with an HL7 to record map DTL). This is simple enough but the recipient of this file is requiring a single record map entry per DG1 segment in the HL7 message.
Â
For instance if said HL7 message for PATIENT^TEST Â has 3 DG1 segments, I would need to write three lines (or records) like so:
123^^^^MR|TEST|PATIENT|DG1(1) TEXT|DG1(1) CODE|DG1(1) DATE
123^^^^MR|TEST|PATIENT|DG1(2) TEXT|DG1(2) CODE|DG1(2) DATE
123^^^^MR|TEST|PATIENT|DG1(3) TEXT|DG1(3) CODE|DG1(3) DATE
Â
Â
Is there a way to do this? I know I can make repeating fields in the record map and can loop over repeating fields/segments in a DTL but I am not sure how to write multiple lines using one incoming message
Last answer 11 March 2019 Last comment 12 March 2019
This is my first post, I have only been using Healthshare for a year.
We support multiple Healthshare test and development environments. We are trying to come up with the best solution for building an environment from scratch, as well as incremental updates. I am interested in hearing the pros and cons between using the Ensemble -> Export Production feature versus creating custom classes to do the install and setup
Last answer 12 March 2019 Last comment 11 March 2019
Why method and class method are different? . What is the purpose for using these are seperatly?
Â
ClassMethod Test(){
}
Method Test() {
}
Last answer 12 March 2019
I need to start doing unit testing for some of my code.
Why does it delete the unit testing class from Cache when I run the test?
Is there a way to turn this off?
Last answer 16 August 2018 Last comment 12 March 2019
Class User.samplexlsconversion Extends (%Persistent, %Populate) [ Owner = {_PUBLIC} ]
{
Property name As %String;
Property DOB As %Date;
Property address As %String;
Last comment 12 March 2019
I'm able to log into my local instance of HealthShare through the Management Portal, but once I've done so, the screen is entirely blank. I'm still able to access Terminal and Studio without any issue, as well as a hosted instance's Management Portal. I've tried stopping and starting HealthShare, no luck. I've been working on this instance for the past several months and haven't experienced anything like this, and I don't know of anything that I was doing that would have broken the Management Portal. Anyone have a suggestion as to where to go from here?
Last answer 11 March 2019 Last comment 6 February 2019
Is there a quick way to see if an SSL/TLS configuration name is valid, short of switching over to %SYS and checking Security.SSLConfigs:Exists?
Last answer 11 March 2019 Last comment 11 March 2019
InterSystems Data Platform includes utilities and tools for system monitoring and alerting, however System Administrators new to solutions built on the InterSystems Data Platform (a.k.a Caché) need to know where to start and what to configure.
This guide shows the path to a minimum monitoring and alerting solution using references from online documentation and developer community posts to show you how to enable and configure the following;
-
Caché Monitor: Scans the console log and sends emails alerts.
-
System Monitor: Monitors system status and resources, generating notifications (alerts and warnings) based on fixed parameters and also tracks overall system health.
-
Health Monitor: Samples key system and user-defined metrics and compares them to user-configurable parameters and established normal values, generating notifications when samples exceed applicable or learned thresholds.
-
History Monitor: Maintains a historical database of performance and system usage metrics.
-
pButtons: Operating system and Caché metrics collection scheduled daily.
Remember this guide is a minimum configuration, the included tools are flexible and extensible so more functionality is available when needed. This guide skips through the documentation to get you up and going. You will need to dive deeper into the documentation to get the most out of the monitoring tools, in the meantime, think of this as a set of cheat sheets to get up and running.
Last comment 11 March 2019
Hello.
There is a way to install and try Cachè 2018.1 on Ubuntu 16.04 distribuition or it's necessary use Red Hat/Suse distribuition to try Cachè on Linux?
Last answer 10 March 2019 Last comment 10 March 2019
Hi Community,
I have to make a daily task (Job) which will run (7 am to 7 pm)Â in a day at an interval of 3 hours. Timings are as (7:00 am, 10:00 am,13:00 pm,16:00 pm,19:00 pm). But at each time when task will run i have to set a variables as per below condition
Sample:
1) If task run at 2019-03-19 07:00 am in morning
I have to set two variables (start and end) whose value will become like this
(set starttime= 2019-03-09 07:00:00.00 and set endtime=2019-03-09 10:00:00.00)
2) But if task run at 2019-03-19 10:00 am in morning, the value should change as per below
(set starttime= 2019-03-09 10:00:00.00 and set endtime=2019-03-09 01:00:00.00
Â
For setting the above variable as (set startime=2019-03-09 07:00:00.00) at 07.00 am on a particular day.
Query:1
I can use ($ztimestamp) to get UTC time and then convert it into local time i am using the below way is this correct
Last answer 9 March 2019 Last comment 9 March 2019
Hi community,
I have a rights problem when giving a user permission to perform some select queries on particular tables. So I have created a user with the following rights.
.png)
So this all works well. No problem so far. But the customer is using a program where you can easily build visually the query by selecting the table, choose the right colums etc. So the problem we have is when I give the user the Role %All the tables are shown.
.png)
And the user is allowed to query all tables. But we only need to see the granted tables granted, so role %All is not valid but is the only Role, Permission I have tried so far that shows the table information correctly.
So what do I need to do for only showing table information (schema information) for the granted tables.Â
Â
Last answer 7 March 2019 Last comment 9 March 2019