[Kimberly Drew]

Good morning,  Thank you Paul for getting right back to me.

I was able to add the ?wsdl to the URL the state provided and was able to generate the xsd files that then compiled in the xml package manager

But I must be missing something else cause when I run xlate through the testing tool not sure it looks right as I don’t see the soap header.

Also the VXU message that we are getting from the system to send to the state sends Batch headers and trailers.  So I would assume I would need to do something with those also?

I have attached the setup that I have done based on the post.

Please let me know when you would have time to chat about this.  thank you again for all of the help and patience.

 

 

 

Attachments:

You must be logged in to view attached files.

[Kimberly Drew]

Hello,

We have been asked to send immunizations VXU message to the state using SOAP and this is our first time so we are very new at using Web services.  The state provided us with URL/Endpoint information and web services credentials, but I’m not sure I really know how to proceed.  I have been reading the Infor Cloverleaf Application Adapter Web services User guide and other related articles to try to figure out what I need to do.  Should the state also provide me with the WSDL?  also not sure how to create the  soap envelope that is needed.  I am probably making this more difficult than what it is, so I apologize if I’m asking stupid questions.  Any help you can provide would be greatly appreciated.

We are 6.2.0.2, windows, and we do have web services as we have the various GUI tools and protocols that are described within the document from Infor.  I would also assume that we would use the protocol of ws-client on the outbound thread to the state.

thanks

[Kimberly Drew]

Thank you Jim for taking the time to talk to me about this post.  I have attached a screenprint of what we needed to add to each xlate that was using OBR.32 and OBR.33.  Also in our testing we found that we had to do the same type of code for OBR.15.

[Kimberly Drew]

Hello – just checking to see if anyone has an update as to when INFOR may put out a patch for this bug.  thanks

[Kimberly Drew]

Hello – we are in the process of upgrading from 6.0 to 6.2 and noticed this similar thing happening.  Would you be able to share some of the wisdom that Jim provided to you about what the release notes said about this situation? I did the straight copy of the individual fields for OBR.32 but the outcome was still not what we wanted, so I was thinking that there may be more we need to do.  thank you

[Kimberly Drew]

Thanks for the additional update.  Last week when you mentioned to me about using the catch and timeout in the tclscript, I also saw this same document within the sqlite documentation that your referring to for locking handling.

[Kimberly Drew]

ok thanks

[Kimberly Drew]

no I don’t have the catch or the dbcmd timeout in the code.  I have attached the ADT proc and the results proc that i currently have in TEST for your review.

[Kimberly Drew]

No – we haven’t seen any locking issues as of yet, but this is only in our test cloverleaf where there isn’t as much activity as there would be in PROD.   we are trying to be proactive.

[Kimberly Drew]

Hello –  We are updating a sqlite db with specific patient MRNs in the ADT process, which is in 1 site, and then we need to read that db to know if that is a valid patient to send the results and also documents to that receiving system. Both the results and document interfaces are in separate sites.  the ADT tclproc will be the only tclproc that will issue the “delete” or “insert” commands, where the other sites will only “select” from the same db to see if that patient exists. Support had mentioned that we could access the db from the other sites by using the full path, but that we needed to be carfeul to program SQLite  db lock handling into the scripts.  We have been successful in accessing the db from the other sites, but the question is about making proper lock handling that is there.  the sqlite databases that we have are only used by that same process, and are updated from a backend command line tcl.  this is new to us and would like to know if the Sqlite experts have any useful ideas.  thanks

[Author]

Replies