Syndicate content 0  
 
All time
Question
· Jan 7, 2021
How to audit data change?

Hi guys,

In our clients environment, multiple sources will connect to one DB (all through JDBC connections) and perform various operations. Sometimes they found some data was deleted without reason. Thus they want some feature like SQL Server Database Audit Specifications that can log who at what time with which IP deleted data in a specific DB.

I've checked IRIS Audit but I didn't find feature about that . How can we audit and log delete of a known DB? The deletions might be performed by delete statament or truncate table stattement.

Thanks.

0 5
0 624
Question
· May 26, 2020
accented characters

How do you allow accented chracters to flow through the engine without erroring out? I read something about adding a "!" in MSH-18 to accept the default coding, but now it gives me an error about "No translation table found". Does InterSystems have anything out of the box to account for accented letters? Does this need to be coded?

1 6
0 623

Hi Community,

We are pleased to announce the Global Summit 2019 social media contest called "Twitter Rush"!

Help us share Global Summit 2019 with the world by tweeting live about the keynotes, breakout sessions, newest technologies and awesome moments as they happen! To participate in the contest, post your updates to Twitter with the hashtag #GlobalSummit19 between the dates September, 19 – September, 25 2019.

Our #1 social media Ambassador will win a 10.5-inch iPad Air Wi‑Fi 64GB!

🎉Check out the winner announcement below! 🎉

2 1
0 609

Hi!

Suppose I have a project in Atelier with two classes: Class A and Class B and develop it in my local Caché installation.

If I decide to delete Class A and delete it in Atelier project will it be deleted in Caché automatically or should I do it manually?

Or what is the suggested workflow in this case?

Same question is if I decide to rename Class B to Class C.

1 4
0 625
Article
· Feb 8, 2022 1m read
GlobalToJSON-embeddedPython-pure

I have created a package to export a Global into JSON object file and to re-create it by reloading from this file
embeddedPython refers to the new available technologies. It should be understood as a learning exercise of
how to handle the language interfaces. Only Global nodes containing data are presented in the generated JSON file.
Differently from the previous example, this one is using embedded Python only, no ObjectScript. Therefore PURE

8 2
0 588
Question
· Oct 25, 2021
Problem with sftp

Hello, everyone,

I have the problem that when trying to connect to the SFTP server the error appears, the user and password are wrong. However, these are correctly stored under login data and I entered! SFTP in SSL Config. The connection works wonderfully with Filezilla. Anyone else has a tip for me?

greeting

0 2
0 626 
Hello! I have a question how to parse Library.ListOfObjects to JSON

I send post data like this from client using rest and want parse "templates", after save "codeForm","codeName" in database

{
    "whoIs": "",
    "templates": [{
            "codeForm": "FORM_FIOGROUP",
            "codeName": "operationDate",
            "orderNumber": "1",
            "codeFormat": "YYYY-MM-DD",
            "header": "DATE",
            "dbfFormatType": "Date",
            "dbfFormatLength": "8",
            "valueFrom": "Payment"
        }, {
            "codeForm": "FORM_FIOGROUP",
0 4
0 624
Question
· Jul 20, 2020
IDX Groupcast system from Cache'

Hello,

I posted in another thread a short while back regarding accessing (extracting) data from the Cache' database.

I am now told that the (healthcare) system is IDX Groupcast. The kick off project has not started yet but I would like to do some 'homework' and see the data model. I couldn't find too much about this in a Google search. Would anyone have a link or advise for doing some preliminaries? I am already versed in SQL server.

Thanks,

John Lisa

0 8
0 620

A permanent job opportunity has arisen for a Caché/Ensemble developer with at least 5 years experience. My client is a specialist resource provisioner of developers for high profile clients in the finance, healthcare, retail, distribution and credit business that are mainly based in central London. My client is looking for a highly-motivated individual who thrives in an environment where problems are open-ended.

0 0
0 628

A client stated to me that they are trying to eliminate SMTP servers from their network and want all email to be sent through their Microsoft Exchange Server. Admittedly I am not very knowledgable of the workings of Exchange Server.

Are there customers sending email notifications through Exchange Server? How is this accomplished? Does Exchange Server act as a SMTP server allowing use of the Email adapter or is there some other mechanism that must be used to communicate with a Microsoft Exchange Server?

0 2
0 626

Given I have a property 

Class All.AllBooks Extends %Library.Persistent
{

Property ID As %Integer;

Property Title As User.Book;

}

In the class method

ClassMethod GetABookById(id As %Integer) As %Status
{

SET MyBooks = ##class(All.Allbooks).%OpenId(id)

SET obj = {

     "ID" : (MyBooks.%Id())

     "Title" : (MyBooks.Title)

}

WRITE obj.%ToJSON()

Quit 1
}

How do Access the foreign key in JSON() data

0 7
0 620