Hi, we are a veterinary lab and we use both the LAB and FIN systems of Antrim. Now we are looking to expose the data in a SQL/Object compatible way so we were wondering if same / similar things had been done by other community members already? If so, could you please share your approach / experience / gotchas with us and we are all ears. I can be reached at yang.jiao@antechmail.com . Thank you!
Mapping
When compiling in 2018.1.2 using $system.OBJ.CompileAllNamespaces() I am seeing the following errors on some of our Record Maps.
Last answer 4 October 2019
I am putting together a new interface to take in a CSV file and output an HL7 message.
I have used the record mapper to create the source class and I am putting together the transform, but when trying to test it I am not seeing the data populate the HL7 as intended.
Last answer 23 August 2019 Last comment 23 August 2019
We can load a CCDA xml document into SDA3 object.
Once parsing SDA3 object, how do we determine from which XPATH from CCDA the specific SDA3 elements were mapped to.
Is there any way?
Last answer 21 March 2019
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)
Last answer 11 March 2019 Last comment 13 March 2019
Found a strange documentation block about Python bindings in Chapter 3.6 of the Caché manipulation functions with time and date. It looks like this text accidentally copied one to one of the Perl binging documentation.
Last answer 14 January 2019 Last comment 15 January 2019
I created a record map and my DTL works fine. I would like to query one of the values in my input record mapped class. How would I do that? I've tried request.Field1, document.Field1 and can't see to get my rule to work. Any help would be appreciated. Thanks.
Last answer 20 October 2017 Last comment 1 November 2018
I have been building Business Processes in Ensemble for a few months and in a process i'd use a combination of data from the request that started the process and context variables that where filled by earlier calls in the process as input for a data transformation. I do not know how to achieve that.
Last answer 23 August 2017 Last comment 9 October 2018
Hi -
I need an example of what I need to "map" to have a common dashboard defined so it will visible/usable in multiple namespaces.
I have created a dashboard in "SAMPLES" (namespace and database) and I would like to have this dashboard be accessable/useable from a 2nd namespace, but I'm not having any success in doing mappings (global/package/routine/data) to be able to get DeepSee to be able to see/display the dashboard.
What is the minimum that I need to map?
Last answer 20 August 2018 Last comment 25 November 2015
To deploy a DeepSee solution, the docs recommend that you define a namespace on the reporting (mirror) server, and "define mappings to access the application data, application code, DeepSee cube definitions, and DeepSee data on this server". (http://docs.intersystems.com/ens20152/csp/docbook/DocBook.UI.Page.cls?KEY=D2IMP_ch_overview#D2IMP_overview_architecture)
Last answer 5 January 2016 Last comment 19 August 2018
I'm creating patient extensions and I'm sending an SDA file to be interpreted by Information Exchange.
How do I map the custom SDA3 so that Information Exchange can see these new extensions?
I'm using SDA3.
Last comment 1 June 2018
Some of our interfaces use globals for lookups, but we are currently looking at putting a groups of (document) interfaces in a separate production with a shared ‘Default Database for Routines’ to reduce code duplication.
Last answer 15 January 2018 Last comment 11 October 2017
Hi folks!
Is there a one line command to map class package A to Namespace ASPACE?
Last answer 30 November 2017 Last comment 30 November 2017
I have a text file that is fixed width delimited and am using a BPL to process this file, ultimately performing a transform from the text file to an HL7 message. I created a DTL, mapping from the recordmap to the HL7. In my BPL, I am performing some loops and other logic (that all is working). My issue is what to do when I perform the Transform.
Last answer 2 November 2017
Hello Community,
I need advice converting a comma delimited string container with multiple records into some type of recordmap that iterates through all the records.
My string container has several records and I would like to loop through the number of records in the string container and transform each record in the container individually. Number of records will vary but the number of fields per record is static (28 fields). Meaning after every 28 fields, a new record begins. The goal is to convert to individual delimited flat file records.
Last answer 23 October 2017 Last comment 16 October 2017
For a HL7 production, How will I be able to use two different segment level transformation (sub transform) in the main transform.
For Ex:
Few mappings from source PID --> target ZAX segment (subtransform 1)
Few mappings from source PV1 --> target ZAX segment (subtransfrom 2),
In the main mappings, I have used subtransform 1 followed by subtransform 2. It doesn't seem working fine.
Any suggestions please. Thanks:)
Last answer 11 September 2017
Hello,
Are there any utilities/api in HealthConnect 2016.2.1 that will allow conversion of XML virtual document to Json format? We were thinking to convert HL7 ADT message to XML via Ensemble DTL and then send it to another BP to convert to Json format for transmission via Web Services. To my understanding there isn't anyway to represent Json as a virtual object so it can be use for direct mapping of HL7 2.x message to Json via Ensemble DTL.
Thanks
Yuriy
Last answer 20 July 2017 Last comment 15 May 2017
Hi all,
We faced a problem where we would like to map a $lb object to its corresponding data model structure in order to later on export it as JSON.
So imagin that we have something like this that actually maps to a persistent table with its structure.
$lb("",,,,,"",,,"BOOLEAN","0",2,2,"1",,"bla",$lb(,,"bla","20050502123400"),"",1,"bla",,0)
Is there a way to transform this $lb (without the need of openig the object itself) to a JSON object with the proper table fields as properties?
Many thanks
Last answer 14 July 2017 Last comment 14 July 2017
Hi,
We are wondering how to create translation profile for HL7 to SDA in "HEALTH SHARE". can you please help us with the class definition containing the mapping for that(so that we can import directly and understand the mapping).
Thanks,
Sam
Last comment 12 July 2017
Hi people,
I am migration my web application of Cache 2013 to Cache 2016, in Cache 2013 I have a integration with a Java aplication using Java Gateway mapping proxy classes and consuming a method that param is a object, and it works perfectly.
But in Cache 2016 this integration don't work, I send the param as object but Cache send as String with the ref of object...
Last answer 7 June 2017 Last comment 7 June 2017
I'm doing a REST service. A method has as body parameter a JSON corresponding to a class A.
In my production I have class A so that I retrieve the parameters using a dynamic object, such that:
Set body = ##class(%DynamicObject).%FromJSON(%request.Content) Set myObjectA = ##class(A).%New() Set myObjectA.Id = body.Id Set myObjectA.Name = body.Name Set myObjectA.Date = body.Date Set myObjectA.Salary = body.Salary
I would like to know if I can avoid doing the manual mapping, doing a casting, since I am sure that FromJSON will return a class A. Something like this:
Last answer 1 June 2017 Last comment 2 June 2017
I am inserting rows in a table. This table is appearing in all namespace as I did global mapping.
So once I run insert command from a method, it insert the rows. When I run the same insert command from other namespace, it replace the existing data in table.
Insert command is same in all namespace but the data I m inserting is different.
Last answer 30 May 2017
What is Purpose of DeepSee and how to we mapping the Deepsee concepts with in Class file.Please give a simple program for how to we learn on Deep see.
Last answer 25 May 2017
Hi,
I would like to list out unchecked mapped items ( classes in management portal ) classes of a particular namespace. Is there any code or terminal command which i can use ?
I am able to list out classes of namespace . But I need to list out unchecked mapped items classes
do ##class(%SYSTEM.OBJ).GetClassList(.result)
Last answer 11 May 2017 Last comment 12 May 2017
Is there any good book where is described process of mapping globals to classes? And book about Storage?
I didn't find much information about these questions in documentation :-(
Last answer 10 May 2017 Last comment 10 May 2017
I created a DTL to do HL7 mapping. The test function in the tools works the DTL perfectly but when used by the rule in my business process, the OBX segments are stripped and the MRN is gone. The assigning authority and ID type are added into the PID but the actual patient MRN is blank (3.1 value).
Here is the source code.
Last answer 6 April 2017 Last comment 6 April 2017
I've got an issue trying to write a code which should add some global mapping to already existing namespace. Here is its skeleton:
Last answer 3 April 2017 Last comment 2 April 2017
Currently, we have an application running in one namespace ("Database B") that has globals and routines mapped to another database ("Database A"). After enforcing clean up on Database A, we found that 90% of the disk is free. We would like to compact Database A and release the unused space. However, we are running OpenVMS, which seems to be the issue.
For databases consisting of only globals, we are able to use ^GBLOCKCOPY; however, we need to ensure that the routines and mappings are also copied.
Last answer 23 March 2017 Last comment 9 January 2017
I've been building up a REST services API, consisting of a dozen or so classes referenced from a Dispatch class, which has route mappings for the first piece of the URI. I'd like to have the Dispatch class be able to output all of the available Services, with some documentation. Is there something like a %Library resource that I could use to pull this information from each of the classes?
Thanks
Chris
Last answer 17 March 2017 Last comment 9 June 2016