Hi,

         Can anyone please recommend an editor for cache database. I am looking for free version.

I am using winsql free version but data is missing while extracting or copying data from winsql.

Thanks

Jude

It's a wrap!    All of the focus sessions have aired now.  Of course, all of our 102 pre-recorded focus sessions are available on-demand now, so you can watch any and all of them, even if you missed the opportunity for live Q&A.

Speaking of live Q&A - we've had 6 live sessions, and these too are available for you to watch.  I wrote about this, and how your questions make us better, in a separate blog article. 

Hello,

I have a csp that occasionally will show Timeout error.

I am looking at the SQL Statements tab of the SQL Explorer:

The Average time is around 1.4, what would cause the CSP page to timeout if the query average time is 1.4 while the CSPGateway Server Response Timeout and Queued Request Timeout are default to 60 seconds? Does sql query from CSP that causes web pages to timeout get logged into SQL Statements ?

Thanks

Hi All,

Can you please guide me on how to restore the .cbk file from the 2015 Cache version into the 2017 version or any other versions of Cache or IRIS software? I have a new instance on my server. It's an entirely new server. I have a .cbk backup file.  I want to restore the backup file into a new namespace which one I will create on my new server.  When I am trying on ^DBREST utility, I am getting "This is not a Cache Backup File" this error. 

Please advise on this. It's a bit urgent.

Thanks,

Arun Kumar. 

Hey Developers,

We remind you about a great opportunity to make a live conversation with InterSystems Product Managers Team on Live Q&A Sessions at Virtual Summit 2020! 

🗓 TODAY at 12:40 PM EDT at https://intersystems.6connex.com/event/virtual-summit/en-us/contents/43…

And now we've added more options to make it even easier for you to ask questions upfront:

✅ Submit your questions in the comments to this post

✅ Submit your question to our Discord Channel: discord.gg/WqVjtD

✅ Submit your questions to VS2020questions@InterSystems.com

✅ Send your question personally to @Anastasia Dyubaylo or @Evgeny Shvarov in Direct Messages on the community

✅ Submit your question to Q&A Chat on the conference platform during the session 

Note: We will pass all your questions to the PM team, and you'll receive answers during the Live Q&A Sessions.

I've been impressed at the quality of the questions at our live Q&A sessions!  

These sessions were meant as a way for you to ask anything you want (I call this playing "stump the chumps").

They're all recorded and available for review later; here're the links:

• Live Q&A session 1 - 26 Oct 11:40PM EST 
• Live Q&A session 2 - 27 Oct 12:40PM EST 
• Live Q&A session 3 - 27 Oct 11:40PM EST  
• Live Q&A session 4 - 28 Oct 12:40PM EST  
• Live Q&A session 5 - 28 Oct 11:40PM EST 

It's not too late to join the last one live! 

• Live Q&A session 6 - 29 Oct 12:40PM EST 

Hi Community!

Watch a demonstration of Production Extension Framework (PEX) in InterSystems IRIS that uses a Kafka integration as an example:

⏯ PEX: Production Extension Framework Demo

Those of you who are following the FullStack competition here in the Developer Community will know that I submitted an entry named qewd-conduit.  I wanted to summarise why I think it's something worth you taking a bit of time to check out.

qewd-conduit uses the Node.js-based QEWD framework alongside IRIS to implement the back-end REST APIs for something known as the RealWorld Conduit application:

https://github.com/gothinkster/realworld

One of the most useful features in Studio is code snippets.

Here's how to add snippets to VSCode.

Here's a generalized instructions.

1. Go to File - Preferences - User Snippets and choose objectscript.

2. Add your snippet, here's an example:

"SQL Statement": {
    "prefix": ["sql"],
    "body": ["#dim rs As %SQL.ISelectResult",
            "set rs = ##class(%SQL.Statement).%ExecDirect(,\"SELECT * FROM\")",
            "while rs.%Next() {",
            "\twrite rs.ID, !",
            "}"]
}

In here:

• prefix - what you need to type for the snippet to appear
• body - snippet body

Get all the info you need about Experience Labs, Personal Training, free certification exams, and more! 

Check out this month's Learning News newsletter, and subscribeto receive the newsletter in your inbox each month.

We've just finished the second day of focus sessions - with a LOT of great content!  With parallel tracks, it's hard to keep up - but one advantage of a virtual conference is that you can watch anything you missed on-demand!

In yesterday's blog (Highlights of Day 1), I covered most of the special announcements such as InterSystems IRIS Adaptive Analytics and the FHIR Accelerator Service, so time to turn to a few broader strategic themes today.

Hi All,

I'm being asked if I can set up a AWS EC2 containerised version of IRIS and a separate AWS EC2 installation of Apache to serve IRIS web files.

Creating the Apache EC2 and containerised IRIS EC2 is the simple bit but getting them both to talk to each other does not seem quite so simple and I cannot find any documentation to describe how this can be achieved.

Has anyone else managed to achieve this?

I am trying to configure IRIS using python. The first task I wanted to do it change the journal directory. I cannot figure out the right way to work with the Config.Journal class with python. I can get the text to query the current setting.

returnValue = dbnative.classMethodValue("Config.Journal","GetList")
print(returnValue )

But I don't see a straightforward way to parse the $List returned by GetList() I was hoping there was an easier way.

How do I

1. Query configuration parameters?

2. Set configuration parameters?

Using python?

Hello Everyone,

We are working on growing the InterSystems Certification program, and would like to gather some input from the community.

Please participate in this brief 6-minute survey to share your thoughts with us regarding the new certification exams we have planned and other program improvements that we are considering.

https://www.surveymonkey.com/r/2ZVHNPS
 

Thanks for your help!

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

Hi Community,

Please welcome the new video recorded by @Robert Cemper on InterSystems Developers YouTube:

⏯ ZPMshow Demo

The second week of Virtual Summit 2020 kicked off with the first day of focus sessions. We covered a LOT of great content - 38 sessions across a wide range of subjects. I thought it would be valuable to recap and review some of the bigger announcements and talking points.

$LIST string format and %DynamicArray and %DynamicObject classes

IRIS, and previously Cache, contain several different ways to create a sequence containing a mixture of data values.  A data sequence that has been available for many years is the $LIST string.  Another more recent data sequence is the %DynamicArray class, which along with the %DynamicObject class, is part of the IRIS support for JSON string representation.  These two sequences involve very different tradeoffs.

$LIST String Format

Newbie Warning...

I have a DTL which accepts HL7 2.3:ORU_R01 And Transforms to Custom Request Target

the target request contains  an array of a custom class named OBXobj with some %string properties which  Extends (%RegisteredObject, %XML.Adaptor)

in the DTL i have a for each loop which should copy OBX segments to the the request.

the DTL test tools works and builds a XML with the OBX info.

when running the Production i get NULL in the Object.

see attached images

1. Test

2. Message sent.

3. Transformation

Whats my problem?

Thanks!

Hi Developers,

If you are planning to attend the Focus Sessions of InterSystems Virtual Summit 2020, please do not miss the session dedicated to InterSystems Developer Community and Open Exchange!

⚡️ "Developer Ecosystem: Developer Community forum and Open Exchange applications gallery" session ⚡️

Speakers: 
🗣 @Anastasia Dyubaylo, Community Manager, InterSystems 
🗣 @Evgeny Shvarov, Startups and Community Manager, InterSystems 

What awaits you?

Hey Community,

We're pleased to invite you all to the Virtual Summit 2020 session dedicated to InterSystems online programming contests, best winning projects, and their developers! Please join:

⚡️ "Best applications of InterSystems programming contest series: Best IntegratedML, FHIR, REST API, Native API, ObjectScript solutions" session ⚡️

Please check the details below.

Now that 1.0 has shipped and is featuring in various sessions at Virtual Summit 2020 it seems like a good time to offer some guidance on how to report problems.

InterSystems ObjectScript for VS Code consists of three collaborating VS Code extensions. For ease of installation and management there's a fourth entity, the InterSystems ObjectScript Extension Pack. It's a great way to get started with minimum clicks, and handy to have even if you have already installed the other extensions.

Hi Community,

At this year's Virtual Summit, we have 100+ Live Focus Sessions on Best Practices, New Technology & Roadmaps. 

Also, you have a great opportunity to submit your questions for Live Q&A Sessions with InterSystems Product Managers on October 27-29, 2020!

To join Live Q&A: 

Hey, 

I have a value in epoch time in which I need convert in order to be able to lookup a table that has dates in YYYY-MM-DD HH:MM:SS format

I thought the below would work but it is not.

select COUNT ('Arrival Time') FROM dbo.table where 'Arrival Time' < DATEADD(ms, CONVERT(int,LEFT(1603173432000, 20)), '1970-01-01 00:00:00')

The first full release of our iKnow open-source NLP library is now available on GitHub and PyPI! 

Presenter: Anton Umnikov
Task: Identify your slowest SQL queries and tune them for better performance
Approach: Use InterSystems’ query profiling and analysis tools. Discuss how system configuration can affect performance
 

This session will show you how you identify the weakest link in your application SQL and introduce you to the fine art of tuning those queries. To do this we will take a look at InterSystems query profiling and analysis tools, as well as how system configuration can impact SQL performance.

Problem: Obscurity on how our SQL engine works

Content related to this session, including slides, video and additional learning content can be found here.

Hello,

In Atelier IDE, there is option to import source from XML, how to do this from VS Code?

Thanks

Today we are pleased to publish a new extension pack for Visual Studio Code. This pack provides a convenient way to install and manage a set of extensions which together make VS Code a great tool for ObjectScript developers.

I'm attempting to extract some very large messages from Interoperability/Ensemble, and I'm just not getting something right ...

The closest I've come to getting something useful is this:

ClassMethod GetHL7Msg(pId As %String) As %Stream.TmpCharacter [ SqlName = GetMsg, SqlProc ]
{
    Set tHl7 = ##class(EnsLib.HL7.Message).%OpenId(pId,,.tSC)
    Throw:$$$ISERR(tSC) ..GetErr(-400, "HL7 Message with ID "_pId_" Not Found.")
    Set tMsg = ##class(%Stream.TmpCharacter).%New()
    Set tSC = tHl7.OutputToLibraryStream(.tMsg)
    Do tHl7.%Close()
    Return tMsg
}

Hi

We have multiple edge production namespaces and want to run query to get errors/alerts from Ens_Util.Log table across namespaces. is it possible?