[Jim Kosloskey]

Ron,

I have a Tcl script that does what you want I think but at least a starting point. This proc though requires the file be accessible vioa the file system not FTP.

If you would like that proc and its User Doc, email me.

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Jim Kosloskey]

Yes, you want pre.

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Jim Kosloskey]

This can be done by using HRL (which probably will have multiple VRLs).

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Jim Kosloskey]

Have you tried turning the noise level up (verbose) on the protocol to see if anything informative shows up in the log?

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Jim Kosloskey]

So the vendor is ACKing your ACK? Some clarification is warranted here, I think.

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Jim Kosloskey]

If an unsolicited reply is received, it can end up in the recovery DB. This can happen when there is a timing issue as a result of the timeout value being exceeded.  Sometimes during high volume, the vendor cannot keep up and upping the timeout value may resolve. The 1% occurrence lends itself to this theory.

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Jim Kosloskey]

Good idea. Unfortunately, I do not have an INFOR account so I can’t add my voice to the request there, but if you make this a poll here those of us without INFOR accounts can add weight and you could use the poll results with INFOR to bolster your request.

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Jim Kosloskey]

See attached. If Cloverleaf is fully installed, you should be able to click on help then follow the attachment submenus. Once you click on Open, you can search for the items of interest

Attachments:

You must be logged in to view attached files.

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Jim Kosloskey]

One thing to do is to check with the vendor to see if they have any customers using Cloverleaf to integrate. If they do, get a contact person at that customer site and pick their brains.

Given the spec, I still think this can be done in Cloverleaf which will provide management and monitoring benefits if it is accomplished. I think PDL will be needed, however.

A challenge may be defining the message structure as it is not a standard. You may need a combination of HRL with VRL.

I would not get thrown by the vendor wanting to be the Server when initiating transactions, that is not a showstopper – I have done that many times within Cloverleaf without issue (if everybody plays the game right).

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Jim Kosloskey]

I think this could be done. There will be challenges as pointed out by others. Since no HL/7 acknowledgments are being used, you might HAVE to use PDL but if you can figure out a way to do it without PDL I think you might be better off.

While not the same, I did something like this way back in an earlier release of CL. If you are on a later release (you do not mention the release), you may find the TCP/IP ‘Encapsulated Options’ in properties might be able to help.

Since each Cloverleaf thread has an inbound and outbound side, a thread can indeed be bi-directional.

Will the system in question be acting as a client or server?

A big challenge will be if they cannot reliably flip their connection from send to receive in synch with the arrival rates. It is possible you may see periodic (or consistent) pending messages but message flow still progressing. That would be a support issue in that someone may erroneously assume the thread is stuck. Consider how you will handle that situation so you can recognize the thread is definitely stuck and not simply obstructed by the other system’s handling of send/receive modes.

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Jim Kosloskey]

I am assuming you want to strip out some text from the OBX-5 field and place that in OBX-6. I will assume by your example, the text can vary in length and content. If that is true, then you need some sort of ‘anchor’ I think.

For example, if the text always began or ended with something you can count on, or the following text always began a certain way, or there are a predictable number of spaces, or it starts the text for a specific length. That knowledge will help construct a reliable solution.

BTW – shameful plug – I have a package that goes into a lot of detail regarding the STRING Action Functions and includes some additional functions I have written. You can have a copy if you email me (email in signature).

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Jim Kosloskey]

FWIW attached are my notes guiding me drilling down into the Xlate Info from NCI. Very crude notes at this point but might be useful. Eventually, my intent is to produce some more polished level of documentation as well as a hopefully useful proc for extracting NetConfig Info.

As you will see (and this is indicated in CL Help) the NCI only takes you so far and then you need to understand the structure of the various lists and keyed lists. There is no documentation for those and I would not expect to ever see documentation distributed. That would make reverse engineering by competitors less painful.

The caution I see is what if we code to those structures and in a future release the structure is altered. How will we be protected or won’t we? Another Challenge for INFOR.

• This reply was modified 2 months, 3 weeks ago by Jim Kosloskey.

Attachments:

You must be logged in to view attached files.

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Jim Kosloskey]

Basically in more current releases, the NCI is intended for Integration Engineers to query (query only) instead of tclib stuff.

I have started constructing a Tcl proc to exploit NCI hopefully to its current capability. Certain data retrieval requires understanding the lists, list of lists, list of keyed lists, and lists inside keyed lists. As I discover those, I am producing a result of my findings which I hope to make available to the group.

I am concerned the reliance on still understanding the underlying structure may present an opportunity for Cloverleaf to change that structure, so the engine still works but direct retrieval (after the NCI call) nay break.

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Jim Kosloskey]

Ditto – but it is one of those things that is so painful you NEVER forget the experience. 🙂

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Jim Kosloskey]

I am assuming you are exporting the spreadsheet to a csv file then running that for conversion. I have a proc that works if you would like that but like Jason says a likely culprit is a duplicate in the left column if the table is one-way or column if it is a 2-way table.

I would see if you have a tool that will check the file first for duplicates and have that let you know where duplicates exist rather than just unilaterally eliminating duplicates (how do you know which dupe should remain otherwise?).

email: jim.kosloskey@jim-kosloskey.com 30+ years Cloverleaf, 61 years IT – old fart.

[Author]

Replies