New post

Rechercher

Announcement
· Sep 3, 2024

HealthShare Unified Care Record Fundamentals – In Person September 23-27, 2024 - Registration space available

#HealthShare

HealthShare Unified Care Record Fundamentals – In Person * Cambridge, MA September 23-27, 2024

* Please review the important prerequisite requirements for this class prior to registering.

  • Learn the architecture, configuration, and management of HealthShare Unified Care Record.
  • This 5-day course teaches HealthShare Unified Care Record users and integrators the HealthShare Unified Care Record architecture and administration tasks.
  • The course also includes how to install HealthShare Unified Care Record.
  • This course is intended for HealthShare Unified Care Record developers, integrators, administrators and managers.

SELF REGISTER HERE

Discussion (0)1
Log in or sign up to continue
Announcement
· Sep 3, 2024

[Video] Unleash the Power of Your Data with InterSystems

#Global Summit 2024 #Video #Summit #InterSystems IRIS

Hey Community,

Watch this video to learn how InterSystems can help you access, understand, and use your data quickly and easily:

⏯ Unleash the Power of Your Data with InterSystems @ Global Summit 2024

Presenters:
🗣 @Michael Hom, Financial Solutions Executive, InterSystems
🗣 @Amir Samary, Director, Solution Architecture, InterSystems  

Subscribe to our YouTube channel InterSystems Developers to stay in touch!

Discussion (0)1
Log in or sign up to continue
Announcement
· Sep 3, 2024

Winner of the InterSystems Developer Community AI Sweepstakes

#Artificial Intelligence (AI) #IRIS contest

Hi Community!

We hope you enjoyed our Developer Community AI sweepstakes and learned something new while interacting with our DC AI. Now, it's time to announce the winner!

And the winner of the sweepstakes is @Akio Hashimoto. Congratulations! We will get in touch soon to deliver your prize, which is a Patagonia Black Hole® MLC™ Cube:

 
If you're curious to see what questions were asked, here are all 28 of them that took part in the sweepstakes:

Our sincerest congratulations to our winner! And better luck next time to everyone else who took part!

1 Comment
Discussion (1)3
Log in or sign up to continue
Question
· Sep 3, 2024

Count XML Elements EnsLib.EDI.XML.Document

#XML #Health Connect

Hello everyone,

I'm a bit confused about the number of elements in an XML object.
I have an object of the class EnsLib.EDI.XML.Document
The xsd structure ( DocType)  is an SDA Object

</container>
<Patient>
</Patient>
<Documents>
<Document>
    <DocumentNumber>0000000000000010008162012</DocumentNumber>
    <DocumentCompletionStatus><Code>IP</Code></DocumentCompletionStatus>
    <FileType>XML</FileType>
    <Stream>PD...</Stream>
</Document>
<Document>
    <DocumentNumber>0000000000000010008157893</DocumentNumber>
    <DocumentCompletionStatus><Code>IP</Code></DocumentCompletionStatus>
    <FileType>XML</FileType>
    <Stream>PD94bT....4=</Stream>
</Document>
</Documents>
</container>

 

How can I count the number of document? I have already tried to use the method choiceGetCount but get no result.

Generating an Xpath object and counting the elements did not work either.

Does anyone have an idea for me. I am sure that it is actually not difficult :-(

Kind regards

Armin

2 Comments
Discussion (2)1
Log in or sign up to continue
Question
· Sep 3, 2024

Autocommit pandas dataframe rows into IRIS

#Python #InterSystems IRIS

Hi,

I'm getting an unexpected behavior when using pandas function to_sql(), which uses sqlalchemy-iris. After the first execution, a transaction seems to be opened and all rows inserted are lost after closing the connection:

engine = create_engine(f"iris://{args['username']}:{args['password']}@{args['hostname']}:{args['port']}/{args['namespace']}")
conn = engine.connect()

# rows are kept after close connection
train_df.to_sql(name='table1', con=conn, if_exists='replace', index=False)

# rows **aren't** kept after close connection
train_df.to_sql(name='table2', con=conn, if_exists='replace', index=False)

conn.close()
engine.dispose()

I did some research and based on this stackoverflow post and this and this doc pages, I changed the connection and it worked:

conn = engine.connect().execution_options(isolation_level="AUTOCOMMIT")

Is this the best way to achive the desired behavior?

2 Comments
Discussion (2)1
Log in or sign up to continue