Entity Relationship Diagram Tool | Uniface Development | Forum

Avatar

Please consider registering
guest

sp_LogInOut Log In sp_Registration Register

Register | Lost password?
Advanced Search

—  Results per page  —








— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters
For a group of consecutive words like 'end of support' use Match phrase

sp_Feed Topic RSS sp_TopicIcon
Entity Relationship Diagram Tool
24 May 2018
2:34 am
Avatar
Colin
Member
Forum Posts: 35
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Hello Everyone,

Uniface many years ago had a tool that would draw a diagram of a model including all the relationships etc.

That module had some problems and was withdrawn.

Is there anything I can use now to do the same thing? If not in Uniface is there some 3rd party software that can read a Uniface model and do the same thing?

I am currently using Uniface 9.7

Thanks,

Col Douglass

24 May 2018
6:51 am
Avatar
istiller
Member
Forum Posts: 251
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

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

24 May 2018
8:15 am
Avatar
ulrich-merkel
Frankfurt/Germany
Member
Forum Posts: 1782
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Hi Col,

the “Define Application Model Properties” form has a button “Diagrams…”

HIH from Frankfurt/Germany,
Uli

24 May 2018
10:06 am
Avatar
luis.vila
Spain
Member
Forum Posts: 34
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

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.

diagramImage Enlarger

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

24 May 2018
10:21 am
Avatar
Iain Sharp
Member
Forum Posts: 653
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

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

Regards, 

Iain

24 May 2018
10:34 am
Avatar
luis.vila
Spain
Member
Forum Posts: 34
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

Thank you for saying it.

It is at Add-ons section. I am contacting with administrator to solve the problem.

 

Regards

Luis Vila

25 May 2018
8:45 am
Avatar
Colin
Member
Forum Posts: 35
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

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

25 May 2018
10:24 am
Avatar
ulrich-merkel
Frankfurt/Germany
Member
Forum Posts: 1782
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

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.

01 Jun 2018
10:27 am
Avatar
ulrich-merkel
Frankfurt/Germany
Member
Forum Posts: 1782
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

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

01 Jun 2018
11:45 am
Avatar
luis.vila
Spain
Member
Forum Posts: 34
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

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:

Image Enlarger

And to implement a more sophisticated and useful component diagram like this one:

Image Enlarger

 

The project is at OpenUnifaceCommunity to be possible anyone could participate.

 

Regards

01 Jun 2018
2:24 pm
Avatar
ulrich-merkel
Frankfurt/Germany
Member
Forum Posts: 1782
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

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

03 Jun 2018
9:11 am
Avatar
ulrich-merkel
Frankfurt/Germany
Member
Forum Posts: 1782
Member Since:
01 Oct 2012
sp_UserOfflineSmall Offline

It just crossed my desc, maybe it can advance supporting graphics like Sequence Diagram, Flowcharts, Class diagrams or GANTT,

the mermaid looks promising at:

as it’s are based on a pretty simple specification text

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 131

Currently Online:
17 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

ulrich-merkel: 1782

Iain Sharp: 653

Theo Neeskens: 353

gianni: 301

rogerw: 260

istiller: 251

Knut: 211

lalitpct: 197

Arjen van Vliet: 175

sochaz: 173

Member Stats:

Guest Posters: 3

Members: 8718

Moderators: 0

Admins: 8

Forum Stats:

Groups: 1

Forums: 62

Topics: 2192

Posts: 9481

Newest Members:

VikaDit, Refomibon, NapsdqaLews, BssaeqiLews, vasin159, NYAlex, Demodom, DorrisSek, HousepfReviews2, gahaddence

Administrators: admin: 23, Adrian Gosbell: 317, diseli: 958, Bob Maier: 3, Nico Peereboom: 77, Michael Rabone: 4, richiet: 406, JanCees: 28