I've got a whopper of a project we're working on for this release and I seriously don't believe it's feasible.
First, some background: as I mentioned previously, our product is used in hospital systems. One of the features of this product is that we can transmit HL7 data to the hospital's HIS. Up to this point the mechanism that we used to massage data into a form that the HIS accepts is via an old-ass Visual Basic 6 application. We have an entire department whose function is to modify VB6 scripts to transform the data into whatever the client needs.
It's works great and we can pretty much do whatever the client requires since we have the full power of a programming language (e.g. conditionals, loops, wealth of string formatting options, etc.) Problem is, it being VB6 is starting to cause problems and it's really at a point where it needs replacing. What sucks is that any replacement will require touching every deployed system out there since the code is specific to Visual Basic 6. There's no porting it to straight into a .NET version or anything. Basically we're looking at a complete rewrite for every site. It sucks and there isn't any way around that.
However, for it's replacement TPTB wants a dumbed-down GUI-based tool that will allow formostof the functionality of the VB6 app. Conceptually, the tool will have drop-down pick-lists for "IF THEN ELSE", "STRING CONCAT", "STRING APPEND" -- shit like that. In my opinion, this is insane. Absolutely insane. MAYBE this would be feasible if we had real UI experts working for us, but we don't. Most of our devs are back-end guys with minimal UI experience. In fact the demo tool that the team spent months working on is pretty ugly. It actually works okay for simple scenarios but it quickly explodes into an unwieldy mess once one needs to do nested conditionals and stuff (which is a pretty common requirement).
Anyway, I'm wondering if anyone has had experience with any sort of tool that does this sort of thing (i.e. a UI-based script engine). I really would like to see some examples of their approach. I also toyed with the idea of creating our own VERY simple scripting language but, man, I have no idea where to begin on that one. And I realize that itself is no simple task.
Lastly, don't even attempt to recommend third-party solutions such as Mirth. Not-Built-Here-Syndrome is strong with us.