go to post Oliver Wilms · Apr 2, 2022 In Cache or IRIS globals subscripts, numbers do not get quoted. There is no difference between ^GLOBAL(1) and ^GLOBAL("1")
go to post Oliver Wilms · Jan 15, 2022 I think dataset-finance should qualify as Unique Real Dataset.
go to post Oliver Wilms · Jan 10, 2022 Eduard, Ideally I would insert directly into date property from text value format 'MM/DD/YYYY'. I do not think we can use TO_DATE() or other SQL function with LOAD DATA. I decided to use a util class to reformat the date column and write a reformatted text file to use as input for LOAD DATA.
go to post Oliver Wilms · Jan 9, 2022 I created a util class with a classmethod to read the CSV and update the date format to yyyy-mm-dd. Thanks for the suggestion, Muhammad
go to post Oliver Wilms · Jan 9, 2022 I wonder if a method like TranDateODBCToLogical is executed when LOAD DATA tries to INSERT a row of data or is there any trigger that I could add to the class definition to convert the value "4/10/2021" to a %Date logical value?
go to post Oliver Wilms · Jan 9, 2022 Thank you for the suggestion, Robert. I tried to include TO_DATE inside VALUES, but it did not work with LOAD DATA
go to post Oliver Wilms · Jan 8, 2022 User Error identified: I missed adding USING {"from":{"file":{"header":"1"}}} at the end. The correct statement that skipped "Balance" column was: LOAD DATA FROM FILE '/irisrun/repo/data/finance-transactions-08-Jan-2022_08-25.csv'INTO dc_data_finance.transact(TranDate,CheckNumber,Merchant,Category,SubCategory,Memo,Credit,Debit,BillPay,DebitCard,Account,Status)VALUES("Date","Check",Merchant,Category,SubCategory,Memo,Credit,Debit,"Bill Pay","Debit Card",Account,Status)USING {"from":{"file":{"header":"1"}}}
go to post Oliver Wilms · Jan 8, 2022 I created a new class called "dc.data.finance.transact" avoiding RESERVED words DATE, CHECK, and TRANSACTION. Then I ran this command in SQL Management Portal: LOAD DATA FROM FILE '/irisrun/repo/data/finance-transactions-08-Jan-2022_08-25.csv' into dc_data_finance.transact Row count: 76 Performance: 4.318 seconds 91420 global references 1837548 commands executed 3 disk read latency (ms) Cached Query: %sqlcq.USER.cls23 Last update: 2022-01-09 00:04:31.471 Print 76 row(s) affected
go to post Oliver Wilms · Nov 20, 2021 I have tried to adapt your example to run on HealthShare 2019.1. I get an error when I call ..Adapter.ExecuteUpdateBatchParamArray from SQLInsertOperation. I debugged the OutboundAdapter code. The error happens on this line: Set pHS=..%JGProxy.prepareStatement(..%ConnHandle,pSQLStatement) ..%ConnHandle is not an Object. pSQLStatement looks okay. My code is here: https://github.com/oliverwilms/etl/blob/main/src/Oliver/SQL/OutboundAdap...(..%25ConnHandle%2CpSQLStatement) Any idea what is the problem?
go to post Oliver Wilms · Nov 19, 2021 I am looking at an interface written in Health Connect that inserts one row at a time using Outbound SQL Adapter. I have observed inserting 200k rows took 4 hours. Does this article say, if I use this adapter properly, I can reduce insert time a lot?
go to post Oliver Wilms · Nov 4, 2021 I like that idea, Henry. Either update real data to fake data or just create fake data for testing.
go to post Oliver Wilms · Oct 22, 2021 Hi Evgeny, I had never used the code quality tool before. It identified a bug which is now fixed. Please add bonus for code quality and article to interoperability-for-money. I think I will attempt to implement workflow as nobody else has done it in this contest.
go to post Oliver Wilms · Oct 8, 2021 I believe you need to add a volume to add a directory to the container and you can then browse to that location. docker run ... -v myFilePathOutside:myPathInsideContainer ...
go to post Oliver Wilms · Oct 4, 2021 The problem is only happening with quote-style escaping checkbox checked and it appears to be fixed in IRIS 2021.1
go to post Oliver Wilms · Sep 23, 2021 Hello, I want to post update that InterSystems told me they did not support mirror with AWS Fargate because mirror requires static ip. I wanted to use containers running on Fargate serverless which will change ip each time a new container starts.
go to post Oliver Wilms · Sep 12, 2021 It took a while, but I made some progress. I changed my cube name from iris-for-money to iris4money (no dashes) and then the project compiled with the latest community edition image. zpm behaved a little bit better in later image, but I still had to struggle a lot to get FileCopy to work so I had data to import when installing from zpm. I appreciate the help I got from Dmitry Maslennikov when I called ZPM 911 on Discord channel. He pointed out that FileCopy converted filename from export.csv to export.CSV. Eventually I got my zpm testing to complete without errors after I had changed the filename in my repo to export.CSV. Hopefully I will earn ZPM bonus which I have worked so hard for.
go to post Oliver Wilms · Sep 2, 2021 In my experience, this version of docker did not work properly with IRIS. Can you try to get on current Docker version?
go to post Oliver Wilms · Sep 2, 2021 Which version of docker are you using? I had such a problem when I started using docker 1.13 on Red Hat Linux. Things worked for me after I got on Docker 19 or 20
go to post Oliver Wilms · Aug 23, 2021 By default, only clients local to the Web Gateway’s hosting computer are allowed access to the Web Gateway Management pages. The browser through which the management forms are accessed must be running on the same machine as the web server and Web Gateway. For example: http://localhost:<port_no>/csp/bin/Systems/Module.cxw You can add additional clients to the list of authorized administrators by adding the client IP addresses to the System_Manager parameter in the SYSTEM section in CSP.ini (in install-dir\CSP\bin). The System_Manager parameter represents a comma- or plus-separated list of clients (by IP address) who may access the Web Gateway Management pages. The directive shown below grants access to three remote clients in addition to the default local access. [SYSTEM] System_Manager=190.8.7.6, 190.8.7.5, 190.8.7.4
