All time
InterSystems Developer Community is a community of 23,228 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!
Learn more

Problems with Strings

I am accessing IRIS databases with JDBC (or ODBC) using Python. I want to fetch the data into a pandas dataframe to manipulate the data and create charts from it. I ran into a problem with string handling while using JDBC. This post is to help if anyone else has the same issues. Or, if there is an easier way to solve this, let me know in the comments!

I am using OSX, so I am unsure how unique my problem is. I am using Jupyter Notebooks, although the code would generally be the same if you used any other Python program or framework.

3 0
0 320
Announcement
· Jan 19, 2023
2023 Global Summit

We are starting the countdown to our 30th Global Summit, at the Diplomat Beach Resort in Hollywood, Florida. Only 136 more days until you can connect with fellow InterSystems product users, engage with product develops and hear all about the trends, challenges and solutions of data management with our technology.

Sign up for notifications today to be the first to register and see who our guest speakers will be!

0 1
0 300
Discussion
· Dec 15, 2021
UAE let’s meet

Hi, I’m recently decided to stay for some months in Dubai. And looking for new opportunities here, as well as even would like to meet in person with local people who works with InterSystems. I can share my knowledge and experience. What do you think? Do we have somebody from Dubai, or other from other parts of UAE?

1 1
0 319

Summary: Responsible for overseeing all aspects of the enterprise interface environment. This includes the implementation, configuration, coordination, maintenance, troubleshooting, security, monitoring, and support documentation of interfaces between various hospital applications. Integrations can include HL7, batch, custom scripts, etc. as required. Incumbent must ensure the interface environment maintains the highest reliability and performance along with keeping the environment on the cutting edge of current technologies.

0 0
0 320

Hi Community,

Let's meet together at the online meetup with the winners of the InterSystems Datasets contest!

You'll have an opportunity to have a discussion with InterSystems Product Managers on new LOAD DATA functionality, Q&A on datasets, etc. Our winners' demo included!

Date & Time: Thursday, January 20, 2022 – 11:00 EDT

https://www.youtube.com/embed/Cp6PfN0uTIY
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

6 2
0 280
Question
· Sep 19, 2019
Credentials - Domain Account

Hi,

I've a Service utilising the Adapter EnsLib.SQL.InboundAdapter, which uses a Credentials item set with the details of a local SQL account. This currently works, however, we're looking to use the credentials of an AD domain account.

The domain account is a member of an AD security group, which has the required permissions on the source SQL database. I've checked that access is possible with this account via SQL studio.

1 2
0 318

Hi,
I am facing issue during LDAP lookup like whenever I used product group parameter in AD explorer to search data from application I am getting empty result. If I set product group parameter as null then based on distinguished name result is generated in application. So if anyone knows about how LDAP works and how parameters are set in AD explorer then please let me know.

Thanks in advance.

0 1
0 319

Hi Developers,

Enjoy watching the new video on InterSystems Developers YouTube:

⏯ Developing Progressive Web Apps

https://www.youtube.com/embed/O8rPR3ovuFs
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

1 0
0 320

Hi Community,

The new video from Global Summit 2019 is already on InterSystems Developers YouTube:

⏯ Durable Data Storage with Containers

https://www.youtube.com/embed/kAlL0Ca9lWE
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 0
1 320

Hi Community,

The new video is available on InterSystems Developers YouTube Channel:

⏯ Collecting Healthcare Data with Alexa

https://www.youtube.com/embed/tl7heBWRrVQ
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

0 1
0 300

Hello,

When i click on the menu to run the Data import wizard from MP, i receive following CSP error

<UNDEFINED>zOnPageHEAD+229^%cspapp.exp.utilsqleximwizardcontent.1 *schemaname : CSP Error

It is happening for all the namespaces. Looks like some permission issue. Same issue with Data Export wizard. Help to resolve this will be appreciated.

I am using

Cache for Windows (x86-64) 2017.2.2 (Build 865_0_18763U)

Thanks,

0 3
0 317

Hi Community!

Please find the Developer Community video of the week:

Monitoring : Don't Turn a Drama into a Crisis

https://www.youtube.com/embed/T_RK5QzRZ0Q
[This is an embedded link, but you cannot view embedded content directly on the site because you have declined the cookies necessary to access it. To view embedded content, you would need to accept all cookies in your Cookies Settings]

2 0
0 320

Hi,

I just updated Atelier to 1.01.263 and now many of the Atelier icons/images are blurry and the spacing in the Atelier Explorer doesn't look right. This is on Windows 10. Is this a known issue? Are there any settings I need to adjust?

0 2
0 318

In Atelier when resolving conflicts with the server the screen shows the Local copy and Server copy and the differences, but depending on where the difference is you cannot tell what what the document is, you need to scroll to the top to see what it is before deciding what to do. It should indicate the class or routine name beside "Conflicting Server documents"

2 3
0 317