Rechercher

Article
· Juin 12, 2024 3m de lecture

Main dish of the Global Summit 2024

Hello Community!

The past two days at the InterSystems Global Summit have been nothing short of extraordinary, and I'm thrilled to share the highlights of this incredible experience with you!

From the early hours, @Anastasia Dyubaylo and me welcomed our friends from the Community at our booth

which became a bustling hub of activity.

@Guillaume Rongier, Luc Chatty, @Raj Singh, @Dmitry Maslennikov, @Olga Zavrazhnova, Lucian Rotar, @Thomas Dyar, @Irène Mykhailova

@Claudio Devecchi, @Anastasia Dyubaylo, @Irène Mykhailova, @Daniel Franco

 
@Olga Zavrazhnova, @Dean Andrews@Anastasia Dyubaylo

We were delighted to welcome developers from all corners, eager to exchange ideas and explore the latest innovations.

@Jennifer Hack, @Jochen Deubner 

@Irène Mykhailova, @Guillaume Rongier, Luc Chatty, @Adeline Icard  

The conversations were lively, ideas flowed freely, and the positive energy around our booth was infectious.

@David Reche, @Dmitry Maslennikov, @Rochael Ribeiro, @Anastasia Dyubaylo, @Olga Zavrazhnova, @Irène Mykhailova, @Eduard Lebedyuk  

Each interaction enriched our community and strengthened our bonds.

@Stephen Morrison, @Raj Singh, @Irène Mykhailova

The sessions over the past two days have been a phenomenal success, filled with inspiring presentations and passionate discussions. One of the highlights of the day was the fascinating session dedicated to using Python, led by one of our brilliant moderators @Guillaume Rongier.

Another of our talented moderators, @Dmitry Maslennikov, was the presenter of a highly anticipated session on "InterSystems IRIS Vector Search and the Python Ecosystem".

After a busy day of inspiring sessions and discussions, we had the chance to relax and have fun at the Smithsonian National Museum of American History.

The evening was livened up by a fantastic performance by the group Integrity Check, who ignited the atmosphere with their catchy music.

As the Summit drew to a close, it was time for heartfelt goodbyes.

@Olga Zavrazhnova (Global Masters), @Vita Tsareva (Caelestinus), @Dean Andrews (head of the Developers Relations team), @Anastasia Dyubaylo (Developer Community), @Irène Mykhailova (Developer Community)

With the sessions concluded, everyone gathered for final exchanges and farewells. The goodbyes were filled with promises to reunite at the next Summit. Smiles, hugs, and warm conversations marked the end of this event, highlighting the success of the Summit and the strength of our community.

The past two days at the InterSystems Global Summit have been a perfect blend of learning, sharing, and camaraderie. We all leave this Summit enriched by the encounters and exchanges, with unforgettable memories and plenty of ideas for the future.

Thank you to everyone who participated and contributed to making this Summit an exceptional experience. Stay connected, and see you at the next Summit for even more discoveries and innovations!

Safe travels and see you soon!

11 Comments
Discussion (11)4
Connectez-vous ou inscrivez-vous pour continuer
Article
· Juin 12, 2024 2m de lecture

La fin du Global Summit 2024

Bonjour à tous !

Aujourd'hui a été une journée riche en émotions au Global Summit, et je suis impatiente de partager avec vous les moments forts de cette dernière journée incroyable !

Dès le matin, notre stand de la Communauté des Développeurs a été le centre d'attraction de nombreux visiteurs enthousiastes.

@Guillaume Rongier, Luc Chatty, @Raj Singh, @Dmitry Maslennikov, @Olga Zavrazhnova, @Lucian ROTAR, @Thomas Dyar, @Irène Mykhailova

Luc Chatty, @Guillaume Rongier, @Dmitry Maslennikov, Lucian Rotar, @Thomas Dyar

Voici notre équipe de Relations avec les développeurs présente au Global Summit qui fait de l'écosystème des développeurs un endroit formidable.

@Olga Zavrazhnova (Global Masters),  @Vita Tsareva (Caelestinus), @Dean Andrews (chef du DevRel), @Anastasia Dyubaylo (Developer Community), @Irène Mykhailova (Developer Community)

Et bien sûr, notre équipe française qui anime la communauté des développeurs en français (avec un ami).

@Irène Mykhailova, @Guillaume Rongier, Luc Chatty, @Adeline Icard 

À la fin du Global Summit, il était temps de dire au revoir. Les sessions étant terminées, tout le monde s'est réuni pour échanger une dernière fois et se dire au revoir. Les adieux étaient empreints de promesses de se retrouver lors du prochain Summit. Les sourires, les accolades et les échanges chaleureux ont témoigné de la réussite de cet événement et de la force de notre communauté.

Merci à tous ceux qui ont participé et contribué à faire de ce Global Summit une expérience exceptionnelle. Restez connectés, et rendez-vous au prochain Summit pour encore plus de découvertes et d'innovations !

À bientôt et bon voyage à tous !

Discussion (0)1
Connectez-vous ou inscrivez-vous pour continuer
Question
· Juin 12, 2024

Trouble running healthshare_unifiedcarerecord_insight_patientindex containers

Im trying to run a local instance of the UCR/Patient Index in a container but its giving me an error. 

Here is my docker compose file:

version: "3.2"

services:
  iris:
    image: container.intersystems.com/intersystems/healthshare_unifiedcarerecord_insight_patientindex:2023.2
    platform: linux/amd64
    command: --key /dur/key/iris.key
    ports:
      # 1972 is the superserver default port
      - "9091:1972"
      # 52773 is the webserver/management portal port
      - "9092:52773"
      # 52773 is the JDBC Gateway port
      - "9093:52773"
    volumes:
      - ./data:/dur

    environment:
      - ISC_DATA_DIRECTORY=/dur/iris_conf.d
      - ISC_CPF_MERGE_FILE=/dur/merge/merge.cpf

it gives me an error - 

[+] Running 1/0
 ✔ Container iris-iris-1  Created                                                                                                                                                     0.0s
Attaching to iris-1

iris-1  | [INFO] Executing command /home/irisowner/irissys/startISCAgent.sh 2188...
iris-1  | [INFO] Writing status to file: /home/irisowner/irissys/iscagent.status
iris-1  | Reading configuration from file: /home/irisowner/irissys/iscagent.conf
iris-1  | ISCAgent[67]: Starting
iris-1  | ISCAgent[73]: Starting ApplicationServer on *:2188
iris-1  | [INFO] ...executed command /home/irisowner/irissys/startISCAgent.sh 2188
iris-1  | [INFO] Copying InterSystems IRIS license key from /dur/key/iris.key to /usr/irissys/mgr...
iris-1  | [INFO] ...copied key
iris-1  | [INFO] Starting InterSystems IRIS instance IRIS...
iris-1  | [ERROR] iris: instance 'IRIS' not found
iris-1  | [ERROR] Command "iris start IRIS quietly" exited with status 256
iris-1  | [ERROR] See the above messages or /dur/iris_conf.d/mgr/messages.log for more information
iris-1  | [FATAL] Error starting InterSystems IRIS
iris-1 exited with code 1

Any thoughts on what might be going on - do i need to run a separate iris instance before i run healthshare?

4 Comments
Discussion (4)2
Connectez-vous ou inscrivez-vous pour continuer
Article
· Juin 12, 2024 3m de lecture

Unir bases de dados de excel com IRIS

Olá a todos! 

Trabalho há muitos anos com Excel e, ultimamente, foquei no tratamento de bases de dados.

Realmente minha experiencia com Excel foi para trabalhos financeiros, não tanto analíticos de dados em si, mas em um projeto recente pude trabalhar muito com SQL e me interessei um pouco pelo tema (não sou nenhuma uma especialista, já aviso!)

Me perguntei como poderia unir vários excels em um para, por exemplo, entregá-lo à Análise de dados utilizando a tecnologia InterSystems. Juntei toda a informação em um pequeno artigo. Espero que seja útil e, é claro, estou aberta a correções.

Vamos utilizar o InterSystems IRIS. O que buscaremos é ler os arquivos Excel, processá-los e por último fundi-los.

PRIMEIRO: O que necessitaremos

Bem, para começar deveríamos ter instalado InterSystems IRIS.

Necessitaremos instalar as livrarias de Pyhon pandas e openpyxl para poder trabalhar com Excel.

Importante: tenha certeza de ter o InterSystems Embedded Python habilitado no ambiente IRIS.

SEGUNDO: Leitura de um Excel com Python

Como InterSystems IRIS suporta a integração com Python, podemos ler/manipular arquivos Excel. Por exemplo poderíamos usar este script: 

import pandas as pd

def merge_excels(file_paths, output_path):

    dataframes = []

    

    for file in file_paths:

        df = pd.read_excel(file)

        dataframes.append(df)

    

    merged_df = pd.concat(dataframes, ignore_index=True)

    merged_df.to_excel(output_path, index=False)

    

    return output_path

# Exemplo de uso:

files = ['file1.xlsx', 'file2.xlsx', 'file3.xlsx']

output_file = 'merged_output.xlsx'

merge_excels(files, output_file)

TERCEIRO: integração em IRIS

Vamos executar esse script de Python no InterSystems IRIS. Para isso, vamos recorrer ao suporte de Embedded Python. O que teríamos que fazer é criar uma class (ou classe, vai) em ObjectScript para chamar ao script acima.

Class ExcelApp.ExcelMerger Extends %RegisteredObject

{

    ClassMethod MergeExcelFiles(filePaths As %String, outputFile As %String) As %String [ Language = python ]

    {

        import pandas as pd

        def merge_excels(file_paths, output_path):

            dataframes = []

            

            for file in file_paths:

                df = pd.read_excel(file)

                dataframes.append(df)

            

            merged_df = pd.concat(dataframes, ignore_index=True)

            merged_df.to_excel(output_path, index=False)

            

            return output_path

        files = filePaths.split(",")

        result = merge_excels(files, outputFile)

        return result

    }

}

QUARTO: fusionar no IRIS

Por último, com o método MergeExcelFiles no InterSystems IRIS poderíamos fusionar os arquivos Excel.

Set filePaths = "file1.xlsx,file2.xlsx,file3.xlsx"

Set outputFile = "merged_output.xlsx"

Set result = ##class(ExcelApp.ExcelMerger).MergeExcelFiles(filePaths, outputFile)

Write "Arquivos fusionados e guardados em: ", result

POR FIM:

Não sei se esse é o jeito mais eficiente ou útil, como digo, sou bastante novata em tratamento de dados. Se conhece algum tutorial para potencializar o uso de Excel nesse sentido, será bem recebido.

Se eu seguir entrando em projetos onde me peçam esse tipo de tarefas, seguirei investigando pouco a pouco. Obrigada!

Discussion (0)1
Connectez-vous ou inscrivez-vous pour continuer
Annonce
· Juin 12, 2024

Vote for Microsoft Change For Support of Source Management and CI/CD of Power BI Reports

TL;DR: My comment to Microsoft when I voted: Our team has implemented most of what we need for source management of Power BI Report files in Perforce. The missing piece? Automated creation of ".pbix" files from ".pbit" template files that can deployed to the Power BI Report Server. Let's get the manual “Power BI Desktop->File->Save As” step out of the process to make report deployment totally automated.

 

Our team has implemented change management for some critical Power BI Reports used by other teams at InterSystems. We do this by extracting the “.pbix” zip file that makes up a report and storing the individual files into Perforce. We use CCR for tracking changes to the report and, most helpfully, for deploying the changes made on our development system to our test and production systems.

One problem that we and many other Power BI users looking to manage changes and implement CI/CD of their reports is the size of the data part of the “pbix” versions of the reports. A file named “DataSource” holds the report’s data at the time the “.pbix” file was last saved with Power BI Desktop.

This file can get very large. We have reports whose “DataSource” files contain almost 200 MB of binary data. It’s not a good idea to put these into source file systems made for smaller text-based files, especially since tracking differences between versions of these data files is not useful nor often even possible.

Power BI Report Desktop provides a way to save reports as “.pbit” templates. These are also zip files that are nearly identical to the “.pbix” files and would be a better alternative for change management. They have the benefit of replacing the large “DataSource” file with a much smaller text file named “DataModelSchema”. This smaller file appears to have enough information (specs of the data source connection, names of tables, names of columns from the tables, etc.) to be able to recreate the “DataSource” file.

Currently however, the only way to do this “re-creation” and produce a publishable version of a report from a “.pbit” template is for a human to use Power BI Desktop to “Save As” a “.pbix” file for later upload to the report server or directly to the report server. (This is also the only way to do this with the new, potentially promising “.pbip” files currently in review, see link below).

Having a script that replaces the manual Power BI Desktop “Save As” step or at least recreates the “DataSource” would be ideal for inclusion in an automated report deployment process.

Unfortunately, I have not been able to find such a script from Microsoft after exploring multiple support sites. I’ve since had a call with Microsoft support and they’ve confirmed that there is currently no way to do this conversion automatically.

What I did find in my online searches was an MS support response that included a link to this page where interested parties can vote up a feature that would address this issue:

https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=e41d996b-1fc4-463a-b8ab-bdedb73728d3&page=8

In my call with Microsoft support, they confirmed that getting this feature many votes increases the likelihood that it will be implemented in a future version of Power BI.

I ask readers of this post to spread the word to Power BI Report users and organizations who would benefit from this proposed feature…and please ask them to vote up the idea. 😊

Thank you.

P.S. Here is a link to the potentially promising new file format (."pbip") for Power BI Reports, "Power BI Desktop Projects":

https://learn.microsoft.com/en-us/power-bi/developer/projects/projects-overview

2 Comments
Discussion (2)2
Connectez-vous ou inscrivez-vous pour continuer