All time

New to Python. Attempting to use pypyodbc to select data from a table in one Cache database, and inserting into a similarly configured table in another. Process works fine except for tables containing Date types. NULL values in date columns are handled without issue, but when data is present, insert fails with:

An error occurred: argument 7: TypeError: 'NoneType' object cannot be interpreted as an integer.

Source table:

0 2
0 174
InterSystems Developer Community is a community of 25,928 amazing developers
We're a place where InterSystems IRIS programmers learn and share, stay up-to-date, grow together and have fun!

I can START and STOP a business process via its Schedule setting.

Is it possible to change the value of another Setting in an analogous way?

I can imagine a SettingSchedule that could look like

action:YYYY-MM-DDThh:mm:ss[,action:YYYY-MM-DDThh:mm:ss]

But rather than just START or STOP, action could be "SET Setting = value", overriding whatever the normal value is.

Is there an existing way of achieving this kind of functionality?

0 4
0 172

Hi:

I have been adapting the IRIS WHIZ addon as part of the contest. I will soon fork the code on github so the changes are available.

The next phase is I am storing the date from and to time for a more complete search cache

zenPage.getComponent(36).value

it works in the chrome console ok

I'm not sure in external JS how to set the page it is on as a zenpage to use the zenpage functions

0 3
0 173

Hi Community,

I hope this message finds you well. I am reaching out because I have encountered an issue with a new dimension I created, named "Region," and I could use your assistance in resolving it.

The problem is that when I open the cube analyzer, the "Region" dimension does not populate data as expected. Instead, it merely displays the text "sourceRegion," which I specified as an expression in the architect.

0 1
0 175

Hey Community,

Join us to have a look back at recent developments in care planning and coordination and a look forward at what is on the horizon:

Unified Care Record: New & Next 2022 @ Global Summit 2022

https://www.youtube.com/embed/8HFIJ1D5h-A
[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
0 176

Hey Developers,

We love Global Masters program for dynamic, fun and networking. We love that we can get to know you better and provide you with some valuable things.

We are excited to have more members in Global Masters, and we'd like to ask your help on that:

❔ Do you know other developers who work with InterSystems technology and would love Global Masters?

Here's the dedicated GM Referral page where you can leave your colleague or co-worker contact details, or get your unique referral link - to send it yourself 😊

0 0
0 176
Question
· Jun 30, 2021
OnMouseOver in a TablePane

Hi Guys,

is there a Onmouseover event in TablePane?

I'm looking to show an image when the user hover with the mouse on a specific Cell in a tablepane, any Ideas?

Thanks'

0 1
0 175

Hi developers!

We had a set of technology bonuses for the InterSystems Multi-Model contest.

And here is how projects collected it:

Project Docker zpm Key-Value SQL Object Your Model Total Bonus
zapm 2 2 2 2 2 10
iris-vaccine-tracker 2 2 2 2 2 10
qewd-jsdb-kit-iris 2 2 2 6
BeI-MultiModel 2 2 2 2 2 10
iris-image-index-demo 2 2 2 2 2 2 12
IRIS Publisher 2 2 2 2 8
iris-sftp-logs 2 2 2 2 2 10
iris-multimodel-suite 2 2 2 2 2 10
GeoDatas 2 2 2 6
HealthInfoQueryLayer 2 2 2 6

0 0
0 176

img

This will be a short article about Python dunder methods, also known as magic methods.

What are Dunder Methods?

Dunder methods are special methods in Python that start and end with double underscores (__). They allow you to define the behavior of your objects for built-in operations, such as addition, subtraction, string representation, and more.

Some common dunder methods include:

5 0
2 175

Hi,

Experienced Senior Full Stack Developer with 16+ years of expertise specializing in InterSystems technologies and modern front-end frameworks looking for opportunities. Proficient in MUMPS, Cache, IRIS, PSL, GTM, ZEN, REST API and Ensemble (Interoperability), with a proven track record of building robust, scalable systems for healthcare, finance and gaming industries.

2 0
0 175

Hey Community,

Watch the new video on InterSystems Developers YouTube:

Securing AI Implementations - Moving from Experimentation to Production @ Global Summit 2024

https://www.youtube.com/embed/HZn4jazdowY
[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 2
1 135

Hello community

I sent a http post message with a large message body (approx. 200 kB) to a standard EnsLib.REST.GenericService using a standard EnsLib.HTTP.InboundAdapter.

When inspecting the message in the message viewer I expected to see a HTTPMessage XML in the Contents preview, but I found a GenericMessage with no HTTPHeaders section. After a while, I found out that the display in the message's Visual Trace differs from what is shown, when going to the View Full Contents view in the Contents tab of the message viewer.

0 2
0 173
Question
· Sep 19, 2024
Access Windows file server

we are trying to access a windows file server from our file adaptor, which has been setup using a Linux CIFS mount
The mount requires a user/password to access the files on the windows server. How do we get the integration engine
to pickup the right username/password?

0 2
0 173
Question
· Jun 27, 2024
ZF(-100) and qpdf

Hi,

I have seen your post on using qpdf with the zf(-100) function and was wondering if you could be so kind to share an example line of code. I can use pdf from the DOS command line no problems with the following:

qpdf --encrypt test123 test123 256 -- c:\test\basement.pdf c:\test\basementenc.pdf

Trying the following from the iris terminal I get a RET=2 in messages.log and the PDF is not created.

d $ZF(-100,"/logcmd", "qpdf", "--encrypt test123 test123 256 --", "C:\test\basement.pdf", "c:\test\basementenc.pdf")

Kind Regards,

Jason

1 1
2 174

The SYS.Mirror CatchupDB() method requires a System File Number/Inode value as a parameter. I have not yet found a suitable internal method to get this value. Is anyone aware of a utility method that would do this? I do know I can get this value with a small amount of Python or by calling out to the OS. However I wanted to stick with pure Objectscript in this project if possible.

Failing in this I will use embedded python to run the line or two of Python needed to get this value.

Thank you for any hints

0 5
0 170

Hi Community,

I have below scenario

We have IRIS BI Reports in my application. Now these reports currently being acessed by users through dashboard url's.

I want to create a automated utility (background cache system task) which run these bi reports and export them to a specific path.

I am looking for a system method through which we can open these dashboard url's through code and export the excel report to a speciific path.

Thanks in advance.

0 1
0 174