Hi,

I need to read a UTF8 encoded text file and translate the content to 8-bit.

Using %File class and $ZCVT(TXT,"I","UTF8") works , but I see that if the content is larger than max string  (32000) and we cut the content

To max string chunks, we can get a <translate> error if we cut it in the "wrong" point..

Is there a better way to do this task?

My code looks like this:

    S file=##class(%File).%New(..LocalFileName)
    D file.Open("R")
    While 'file.AtEnd {    
        S Line=$ZCVT(Line,"I","UTF8")
    }
    D file.Close()

and an example of such an error:

USER>s str=$C(215)
USER>w

I currently have an Ensemble production which accepts and handles SOAP requests.  I now need to support the exact same data, but instead of coming in as a SOAP request, comes in as a multipart/form-data request.  The body of the message would look something like:

I have looked

I created a Custom Business Service to receive a multipart message with a file and I need to save only the file, not all message. How Can I extract only the file from the pInput to save in a File? This is my code:

If you want get a file from a multipart API or html form request use ReadMIMEMessage, see my sample.

Free certification exam attempt for all attendees of Virtual Summit 2020!

InterSystems is proud to offer free InterSystems Certification exam attempts to all attendees of InterSystems Virtual Summit 2020. The one free exam attempt will be made available to all registered attendees and can be used at any time until December 31, 2020.

This is our standard online exam service with online proctoring that is normally priced at $150 per attempt. 

Get your hands on our technology with On-Demand Experience Labs available now through November 6^th. Each lab is paired with an office hour session scheduled for this week. Learn more about how you can get hands-on with our technology. 

Join the office hours to get answers your questions about the labs, talk about how the technology fits into your environment, and discuss implementation. Sign up for the Office Hours/On-Demand Experience Labs today. The labs have gotten great reviews so far!

We released a new version of ZPM (Package Manager)

New in this release:

1) Interoperability support - support for dtl, bpl, lut, esd, x12 in module.xml

Now it's allowed to refer to DTL and BPL files. ZPM stores and uses them as CLS. 

Position: Intersystems Developer / IRIS Developer (Please send me your resume to  raju@intellisofttech.com  )

Location: 100% Remote

Duration: 6 Months Contract To Hire

Skills:   Cache DB, Object Script, Intersystem, Ensemble (oldest one , )Healthconnect (Middle version ), Healthshare(Latest version ), Mumps

Top Requirements:

• IRIS for Health / Ensemble / Healthconnect / Healthshare – multiple versions released over time, 3+ years
• ETL – Will need to be familiar on transforming data into new IRIS instances
• Object Script – will do some cache development
• Software Development Background –

Using the Java Gateway to speed development

InterSystems IRIS includes dynamic object gateways for Java, .NET, and (now) Python.  These gateways allow your IRIS application to use libraries in these languages, removing the need to create everything from scratch in ObjectScript.

In this example, we use the iTextPdf and Apache PdfBox libraries to read a text file and produce a basic PDF from it. These libraries are deep and rich PDF controls, so a little bit of development could produce an example application that produces far more compelling results for your needs.

Hi Community!

We are pleased to invite all the developers to the upcoming InterSystems Interoperability Contest Kick-off Webinar! The topic of this webinar is dedicated to the Interoperability Contest.

In this webinar, we will talk about the interoperability capabilities of InterSystems IRIS, will do a demo of building the basic IRIS interoperability solution, and demo how to use the PEX. Also, we’ll discuss and answer the questions on how to build interoperability solutions using InterSystems IRIS and IRIS for Health.

Date & Time: Monday, November 2 — 10:00 AM EDT

Speakers:  
🗣 @Stefan Wittmann, InterSystems Product Manager 
🗣 @Eduard Lebedyuk, InterSystems Sales Engineer
🗣 @Evgeny Shvarov, InterSystems Developer Ecosystem Manager

Hi All,

  I know hundreds of people have done this but I'm looking for some DTL's as a start to do HL7 to FHIR, I appreciate everyone's HL7 is slightly different, but just some starter DTL's would be much appreciated?  Can anyone help?

  Regards

InterSystems is offering  a new and easy challenge as part of Global Summit 2020. As you know IRIS Data Platform 2020.4 and IRIS for Health 2020.4 are now in preview release. We are looking to improve the developer experience in migrating from earlier 2020 container release(s) of these products  to the 2020.4 preview release.
We invite you to complete a survey and get 7000 points on Global Masters🎁

This may not be the right place to ask, but I am having some issues with the VSCode setup. I have installed the InterSystems Extensions but I am not seeing the InterSystems icon on the Action Bar long the left side of the screen.

Can someone point me in the correct direction of what I need to do to fix this issue?

Thanks

Scott

Migrate from Java Business Host to PEX

With the release PEX in InterSystems IRIS 2020.1 and InterSystems IRIS for Health 2020.1, customers have a better way to build Java into productions than the Java Business Host. PEX provides a complete set of APIs for building interoperability components and is available in both Java and .NET. The Java Business Host has been deprecated and will be retired in a future release.

Advantages of PEX

• Allows developers to create any Production component in either Java or .NET
• More complex message structures can be passed between components
• Simplified settings
• Simp

Hey Developers,

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

I'm looking for the best strategy for extracting data from a Cache table that houses 86 Million lines of data and around 190 columns. I'm currently using DBeaver and the Invoice Service dates go back to 1996. Optimistically I'm looking to pull to a pipe delimited flat file, but even a year's worth of data takes many hours to get query results.

Any suggestions for the best practice/strategy?

Thanks,

John

IRIS is an excellent option for machine learning projects with massive data operation scenarios, because the following reasons:

1. Supports the use of shards to scale the data repository, just like MongoDB.
2. Supports the creation of analytical cubes, this in association with sharding allows to have volume with performance.
3. Supports collecting data on a scheduled basis or in real time with a variety of data adapter options.
4. It allows to automate the entire deduplication process using logic in Python or ObjectScript.
5.

Class Queries in InterSystems IRIS (and Cache, Ensemble, HealthShare) is a useful tool that separates SQL queries from Object Script code. Basically, it works like this: suppose that you want to use the same SQL query with different arguments in several different places.In this case you can avoid code duplication by declaring the query body as a class query and then calling this query by name. This approach is also convenient for custom queries, in which the task of obtaining the next row is defined by a developer. Sounds interesting? Then read on!

Hi Developers!

Here're the technology bonuses for the InterSystems Interoperability Contest that will give you extra points in the voting:

• Business Process BPL or Business Rule DTL Usage
• Custom Interoperability Adapter Usage
• Production EXtension(PEX) Java or .NET usage
• Workflow Engine usage
• ZPM Package deployment
• Docker container usage

See the details below.

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. 

Smart Factory Starter Pack   One highlight that got a lot of attention today was the release of the InterSystems IRIS Smart Factory Starter Pack on OpenExchange.

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 

Your questions are read

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

This is a very cool initiative as it provides a platform for lots of different people to implement technically different solutions for both the back- and

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

Even better,