Entity Relationship Diagram Tool

Hi Colin I found graphviz (https://www.graphviz.org/) You just have to create a textfile with all relations (form UCRELSH) and graphviz will "paint" the diagram. Here are some example what's possible by graphwiz: https://www.graphviz.org/gallery/ I you have time and muse, one can enrich the graphic by various attribute found in UCRELSH,UCKEY,UCTABLE,UCGROUP,UCFIELD,... BTW: Read out UXCROSS and you have a call-graph of your components. But this could very, very large and unreadable :-) Ingo

Hi Col, the "Define Application Model Properties" form has a button "Diagrams..." HIH from Frankfurt/Germany, Uli

Hi At OpenUnifaceCommunity I shared an Uniface's plugin to extract entity relationships in DOT language (from graphviz, more info in link shared by Ingo). The plugin's name is Uniface DOT language interface and ask you the entity name and the number of "jumps" to get a picture of what is around. In this example, was selected entity WPVUSU with 2 jumps. Shows inter-model relationships as a dashed line. Also, it is able to extract a complete data model. For the same price ;-) you can do something similar with components. It uses a graphviz's javascript to paint the diagram in a form or you can export it as a file.   I guess you need to sign up at OpenUniface gitlab's site. Feel free to use it.   Regards   Luis Vila

I have just signed up and I can't see it anywhere, clicking the link gives me a 404 error.  Regards,  Iain

Thank you for saying it. It is at Add-ons section. I am contacting with administrator to solve the problem.   Regards Luis Vila

ulrich-merkel said Hi Col, the "Define Application Model Properties" form has a button "Diagrams..." HIH from Frankfurt/Germany, Uli  

Thanks Uli, I've probably seen that button every working day for years and it never registered with me.   Col Douglass

Hi Col, I re-learned the diagrams attending the "Uniface First Class Training – Essentials & Client/Server" recently. Pretty good to get back "the complete picture" of U97 after 25 years with uniface as a tool.

luis.vila said At OpenUnifaceCommunity I shared an Uniface's plugin to extract entity relationships in DOT language (from graphviz, more info in link shared by Ingo). It uses a graphviz's javascript to paint the diagram in a form or you can export it as a file. Luis Vila  

Great job, Luis And if one wants to include the diagrams into a documentation: With the windows package of graphviz downloaded so we have dot.exe and its dlls, the exported .GV file can be converted to graphic files like bmp, gif, svg, png or even pdf. Looking into the powerful grammar of DOT, there are a lot of nice options from extending the information by adding some interactive tooltips to the diagram. Uli

Thanks Uli  DOT is wonderful. At the very beginning I had a daily process that built component diagrams using SQL scripts just to see how my projects were growing. After this, it is evolving as a tool to understand customers' systems I have to [understand and] repair. My wish is to get a configurable data model diagram like this: And to implement a more sophisticated and useful component diagram like this one:   The project is at OpenUnifaceCommunity to be possible anyone could participate.   Regards

Hi Luis, in the last years I created a couple of Codegenerators based on Xtext/Xtend. One option is split your current module to support 2 steps: At first, we generate a "raw data" version of the DSL file (which is not DOT langauge) from your repository (as you do already).

entity EntA entity EntB relationship EntA -> EntB

Then one can use the Eclipse based editor for a controled annotation of the raw data (like a "reddish" display).

entity EntA reddish entity EntB relationship EntA -> EntB

Saving the DSL file will result in the generation of the .GV file where EntA will be in red. Generating the raw data will help you a lot as all you have to do is adding the annotation and it is only highlevel info provided. If you are interested in a cooperation, send me a mail, Uli

It just crossed my desc, maybe it can advance supporting graphics like Sequence Diagram, Flowcharts, Class diagrams or GANTT, the mermaid looks promising at: https://github.com/knsv/mermaid as it's are based on a pretty simple specification text

I've been using the tool when it was available. It was very useful. After its gone i started using Creately as an alternative