@cindy-summer
Forum Replies Created
-
AuthorReplies
-
That is where the problem starts. These tables are used by others and I can’t delete columns or add columns. Isn’t there a stored procedure that creates a temptable. I remember a co-worker used them.
Two excellent answers…. Just to clarify….
I am pulling data of a SQL table and using tcl procedure to create a batch HL7 and sending it a Listening port.
The data is being pick up out of SQL and xlate translate the csv file to HL7 and a tcl procedure adds it to a batch format. Then pdl-tcp sends the HL7 file to a listening port. All this works great!!!!
Except:::::
Right now the Inbound Protocol keep sending the rows in SQL over and over and over.
To the point I am unable to tell what’s new and what’s old.
I would like to use the stored procedure approach,
so I can end the looping.
In addition to creating a statement that ‘states If createdate is > then send row of data else note date and stop.
I hope that makes sense#&%^(
Thank you Peter!
I have heard reliable sources that you are very good with Cloverleaf and Databases. Do have any information on how I can set a beginning and end point, so SQL will just cycle the table one time. THen run the cycle again starting from the last record picked up from cloverleaf.
I hope you will accept my sincere apology for any negative frustration they may have been convagued from this post.
To clear up a couple of things, I mentioned. First, I was definitely not trying to promote another product.
Most importantly, I have received excellent support from Cloverleaf Support professionals. A couple weeks ago, I sent an email stating how professional and customer-oriented the Cloverleaf support professional were.
We are going to use the dft portion of the process in Cloverleaf, but having problems with picking up where the last thread ended.
I truly am sorry and meant no harm.
I realize Cloverleaf probably has a lot of a great components, but by the time you find them you are close to your project deadline. Why design software that is so difficult to maneuver. There are a tons of Interface Engines that are so user friendly and can do everything that Cloverleaf can do.
My concern is whether you want it to be user friendly or are you looking to make money on licensing, training, consulting, etc. People are building their own interfaces now, so to have a product so locked down will most likely keep it down.
Sorry if this sounds so negative, but we really gave Cloverleaf a chance and it distributes me when it takes several different departments to give one answer.
We started with License.
We got the wrong host id in the license.
We then got a temp license.
We then received a 3 thread limited license.
We then were told we had unlimited license.
We installed another temp license only to learn we did not have unlimited license.
Soooo we reinstalled the 3 thread license.
In the meantime, I was sent to 7 different cloverleaf support/license techs.
That was the start of about 5 other major issues that we still haven’t resolved. No need to complete them. We completed them in Mirth in 1 day, tested the next day and it goes live next week. SWEET!!!
Yes I have tested it in SQL and it works. I also performed the same steps for configuring Database shema. This is a polluted product, so I am moving everything into a different interface engine. Good Luck if you stay with this product.
Thank you for getting back with me.
Output Message Format is set to Database Schema,
Connection jdbc
table schema is dbo
Protocol database outbound
Properties same
Using SQL statement Insert
yes: INFO: Running the doInit method in database-outbound protocol
msgState : Disallowed Gateway routing (106)
recovery db state is 11
-
AuthorReplies
