Hi,
I have written a procedure with the help of object scripting to export data to a csv file. There is more data than the csv limit.
Can anyone please tell me how to get the row count of csv file using object scripting, so that I can write an if condition and write to a second csv file.
Please find the code writing to the csv given below.
HI,
I am planning to build a WebApp that will have tons of data to display in tables, ability to add comments on that table rows and may be some few more small features as we move on.
1. It has to be Secure
2. It has to be fast
3. It has to be Non CSP / Non Zen
4. Will have Cache DB to pull records from but should be flexible to do that from any odbc resource
5. Version 2018 Ensemble
My first step would have been to investigate different options for technologies that would make it work and best suited with Ensemble 2018
Hello, InterSystems community!
Lately, you have probably heard of the new InterSystems Package Manager - ZPM. If you're familiar with it or with such package managers as NPM, Dep, pip/PyPI, etc. or just know what is it all about -- this question is for you! The question I want to arise is actually a system design question, or, in other words, "how should ZPM implement it".
I am trying to use the %ListOfDataTypes functionality, but am hitting a limit of 50 characters for each entry, when being used in a Web Service. Is there a way to increase the number of characters that can be used in the %ListOfDataTypes through a web service?
s txt(1)="1"
s txt(2) = "2"
s txt(3)="3"
...
s txt(n)="n"
Instead of hardcoding "d ..write(txt1(1),txt(2),txt(3))"
Is it possible to write code to generate the input parameters to do d ..write(txt1)...txt(n))?
{
Good day,
We upload images into the database with this code :
<td align="right">FileName</td>
<td><input type=file size=200 name=FileStream></td>
</tr>
s FileName = ##class(%File).GetFilename(FullFilename)
s ItemImage.FileName = FileName
Is there a way to get a good performing index on a date field? I have tried various date property indexes and the query plan is always in a pretty high range. Below are query plan result values I have observed:
StartDate > '2019-12-01' --cost = 699168
StartDate = '2019-12-21' --cost 70666
StartDate between '2019-12-21' and '2019-21-28' --cost = 492058
The query plans above were for type %TimeStamp.
Hello All,
We need to develop a small csp application which shows data in simple paginated / searchable table for business users.
It is to be built on an old version of Cache and is not a big full fledged application but something temporary. We can't use Zen and using a combination of csp & Bootstrap as bootstrap makes the pages look beautiful with little effort.
I have built the table in boostrap and it works fine with pagination and search working perfectly
Can anyone clarify to me about the differences between these two classes?
People in this topic https://community.intersystems.com/post/using-class-queries-sqlstatement-versus-libraryresultset stated that %SQL.Statement (I am assuming they mean to talk about %SQL.StatementResult) is newer than %Library.ResultSet. But I don't really know what are the advantages of %SQL.Statement over %Library.ResultSet as the people in the topic somehow didn't mention them.
Hi all...
I am testing this project:
https://intersystems-community.github.io/webterminal/
Is there any way to be able to record a log of what is done on this terminal?
Does anyone use this in production?
The message in Ensemble has been retained for only 20 days, but the amount of data is still more than 300G. What should be done to reduce the storage capacity?
Hi,
I've heard from two different sources the SMP (or parts of it) and for sure the DTL front end (in studio? via SMP?) have been rewritten to be more modern. But on a latest IRIS Community download everything looks the same to me. Am I missing something or is this Marketting Spin?
Hopefully I won't get banned for this post aswell......
Hello Community,
I would like to work in SQL developer with the tables from Caché.
Is it possible with JDBC tool?
What is the whole process in order to work in SQL developer? I have the access information to Caché, but i can only choose in SQL Developer software only Oracle or MySQL database type, therefore i think, that have to install any other tool.
Thank you in advance for your help!
br,
bálint
I need to ran a task on a specified days (once a month but a different day each month).
How can I do that in Task Manager?
Hello team,
I am trying to do a basic read file of HL7 messages. Need to count how many FT1 segments are there in each file and how many messages are in each file.
Any help will be appreciated. I have the stream object.
Just need to loop through the stream and get the info in some way.
Any help will be appreciated.
Thanks,
Jimmy Christian.
Hi,
The class %JSON.Adaptor is very convenient,
I wonder if anyone faced the following scenario using it-
Exporting an object, that has a many to many relationship, and getting the details of the related objects.
For example, if we have three classes - Teachers, Students, and an intermediate class TeacherStudent .
The classes extend %JSON.Adaptor, and we would like to open a Student object, use %JSONExport, and get a JSON
That includes the details of the student and all the teachers that teach the student, something like:
Hi,
On a persistent class, I have defined an %OnNew method that validate some properties with appropriate status code for each kind of error.
Question is: how do you catch the specific error when %New is called on this class?
Surrounding %New method with a try-catch not seems to work.
Thanks
Hello,
I would like to catch an Adapter error in a try/catch. I have a problem with SMTP and SFTP adapter when the connection failed after 15 seconds.
Here is an example of my code for the SFTP adapter:
Hi Folks,
I would like to visulaize the tables and data on Power BI, so I try to connect the romote server to Power BI to access the tables and data of remote server. I can able to connect that remote server to our Studio also able to view class files.
But I couldn't able to connect the remote server to power BI. I'm getting the below error while click on the tables
"Expression.Error: This native database query isn't currently supported"
Hello All
Could someone help me in the details of the ODBC connection I need to connect to the Healthshare Cache databases for the CMC application?
Much appreciated in advance
Andrew
Hello All,
I am working on Files where I have to compare contents of two files and display result.
e.g Suppose file1 contains data in Name and Roll form and file2 contains data in name and class form, so it should compare name from file1 and file2 and display those matching data(Name,Roll,class).
I have piece of idea about file system so any help would be appreciated.
Thanks in advance.
Regards,
Gunwant
I am converting an object to json, but in the result a "_class" property appears, is there any way to remove this?
.png)
Result:
.png)
Hi folks,
how do people run iris-community edition nowadays? It seems there are some incantations needed that are not documented here:
https://hub.docker.com/_/intersystems-iris-data-platform/plans/222f869e-...
When I follow these, I am only getting an error:
Hi all...
I am try to execute a class method from JDBC connection. My method are simple, just create a file at $HOME like this:
set sc='$zf(-1,"touch $HOME/lixo.txt > /var/tmp/log666 2>&1")
I put a log file to this commnad because it's don't work, and in log file i get this:
touch: cannot touch ‘/root/lixo.txt’: Permission denied
after to try other commands I found that user and enviromnent variables are diferents:
I try this:
I configured a SQL inbound adapter to monitor my local Cache database.
But I got "ERROR <Ens>ErrOutConnectFailed: ODBC Connect failed for 'SAMPLES' /
'' with error ERROR #6022: Gateway failed: DSN/User Connect."
Same error if the DSN setting is blank or set to my namespace.
Question is whether SQL inbound adapter is for external database server ONLY?
Does anyone know of an API that will do a hostname look-up based on IP? We could of course use call-out but the format of the results vary based on OS and if there is already an ObjectScript tool which will parse this then we'd rather use what is already available.
Thanks!
Ben
Hello guys,
Is it possible to map a package as read only?
I know it is possible to mount the source database as read only and map the package in the target namespace. But I would like to make the mapping read only so that the package would be "read only" only in the target namespace.
This would avoid someone to forget to set the database read only again if a modification in the package is needed.
Thanks in advance.
Jonas Zanon
Hi,
We need to implement Oauth2 Code Flow + PKCE. Any experience with InterSystems OAuth2 Server on this would be welcome.
What parameters did you setup on OAuth 2 server configuration page to make it work?
Thanks!
