[Ab Lugtenburg]

Hi i think you can look in the DTC thread , it is a little complicated but there is a webinair made by Rob Abbot. I’m not allowed to link the url here. Or look it up in the help file . In the help file there are also examples

 

 

 

[Ab Lugtenburg]

As i remember right you can skip the private key under client mode for SFTP
For a http-client you maybe can use the curl option for using a certificate in a clientanon setup

[Ab Lugtenburg]

Hi Mike,

I saw this in an other case on our cloverleaf , first you have to find out is the command in upper or lowercase

Further on teh tab FTP options you can find a “Dir list Command” box here you can put in the right command to use

In my case here i found the solution

[Ab Lugtenburg]

Hi Rob,

Just one quick question in this research of inform it involves also the webserver use for the api ?
Just asking because we use this once a day and so the webserver is running

[Ab Lugtenburg]

Hi,

At the point of peformance i can tell you that if you encrypt (base64 in my case) and the file are big (say about 500 mb  or bigger) you have a performance issue under windows 2016. At our site all i made an extra site with these threads so the regular threads in the master site did not have a problem (my hl7 adt etc)

 

[Ab Lugtenburg]

Hi al and thanks for your thoughts, remarks and workouts etc etc.

After 2 months we discoverded the problem is a bug (infor confirmed this by my supplier)

it seems that the regional settings is the cause our settings set a , instead of a . in the decimal numbers thats is the problem and the workaround is to change that at your cloverleaf server . From version 20.1.0.0 ths bug is fixed

It also explains why the most of you guys no problems discovered. I think you uses the american region and i  live and work in the netherlands ;->>

 

 

[Ab Lugtenburg]

Oke , i think i am missing some kind of overview or something like that but i made a HRL with 2 vrl ,one vrl s not repeating and the other one is repeating .

I put in the attachment a zip file containing the hrl, vrl, xlate, json and the json test file

I really don’t understand why the json is not repeated in the xlate , also tried debug but after the first record there is no other the xlate debug say.

 

Attachments:

You must be logged in to view attached files.

[Ab Lugtenburg]

Hi all,

Just to busy but i’am today working on this problem so first i am going to find check the vrl an hrl, i will keep you informed

[Ab Lugtenburg]

Hi All,

 

Most of the time i just have not the time answer.

There by i try to work with the cloverleaf tools as much as possible , because our clover is running on windows. On this forum there are mainly linux/unix systems . At this point is see that ie. web services en HTTP request are mostly run with scripts at the server and not with the clover http client .

So the solutions i can deliver are mostly not compatible with the original setup.

[Ab Lugtenburg]

oke thx i’m gonna report it

[Ab Lugtenburg]

Hi Jim and  all,

I ‘m sorry for my late reply but i was rather busy .

I think i know what the cause is , the only thing i do not know the solution

The Json is read as one long string and not parsed at al in the xlate, you can see this in the attachment. It is a very strange thing

Attachments:

You must be logged in to view attached files.

[Ab Lugtenburg]

Hi Jim ,

All the named actions controls i already did and over and over. Thats why i’m now on the forum ;->>

I put an  json config.doc with screenshots in the attachment

Did by the way also this with an vrl / db / hl7  but the xlate doen’t start an iterate

Our cloverleaf 19.1 is running on a windows 2016 enviroment

I just made a solution with a tcl converion script to a CSV and use this for update my db but it is kind of strange an would rather use the direct json to sql with a xlt translation

 

Attachments:

You must be logged in to view attached files.

[Ab Lugtenburg]

Hi i saw this on both 19.1 and 6.2 cloverleafs

it seems to happen when there is a internal network scan and the port is at that moment not busy or connected. This is all i find out about this. When i restart the thread the problem is solved.

The same error is saw on my 19.1 version when there is a new thread and i started this a first time. It seems to have an issue with the smart sql teh first time so i start the new thread and stop it then start it again ;->>

 

[Ab Lugtenburg]

All of above in just the same order ;->>

 

[Ab Lugtenburg]

Just use xlate and iterate on the zbx segement, with an by example if statement you can do a string compare and copy your data if needed

[Author]

Replies