Re: Create SQL DB ERD from 4D Export Structure XML File?

I tried Miyako’s Structure to SVG tool and generated a fine structure.svg file. Now I’m trying to find a freeware tool to edit it. I’m trying Inkscape right now, but it’s very pokey (lots of “Not Responding” when selecting objects etc). Mostly unusable. Any recommendations on free SVG editing

Re: Create SQL DB ERD from 4D Export Structure XML File?

I think he has already posted an explanation to this thread, But the reason is that the colour by default (displayed grey in structure editor) is rgb(0,0,0) So you need to code exceptions for tables that do not have a custom colour defined. > 2019/11/26 8:42、Cannon Smith via 4D_Tech

Re: Create SQL DB ERD from 4D Export Structure XML File?

Hi Tom, As for Alexander’s code, I noticed the following sometime ago. Maybe something this simple is causing the blackness as well? > Just a heads up on a bit of code that won’t work in countries that use a > decimal place instead of a comma. In the method xml_atts2ob, lines 50, 54, > 58,

Re: Create SQL DB ERD from 4D Export Structure XML File?

Thank you for correcting me Miyako! I should have dug deeper. I’ll check it out. Tom Benedict > On Nov 25, 2019, at 08:02, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > For reference: > > I do not use native XSLT commands, > the component has a CLI xsltproc, > so the remarks

Re: Create SQL DB ERD from 4D Export Structure XML File?

For reference: I do not use native XSLT commands, the component has a CLI xsltproc, so the remarks “It is now deprecated” is incorrect in this instance. https://github.com/miyako/4d-utility-structure-to-svg-converter-v2 2019/11/25 22:00、Tom Benedict via 4D_Tech

Re: Create SQL DB ERD from 4D Export Structure XML File?

Am 25.11.2019 um 14:00 schrieb Tom Benedict via 4D_Tech <4d_tech@lists.4d.com>: > > Alexander’s code ended with a number of black tables. Hi Tom, sorry for that, I take the color commands from the xml structure definitions. If you like, you could send me the XML structure and I check if I can

Re: Create SQL DB ERD from 4D Export Structure XML File?

Thanks for the reply Arnaud, Yes. I’ve tried the SVG exports posted on the forum and they run into issues, at least for me. Perhaps my structure is too large? 225 tables. My results with Vincent’s code have overlapped tables and relation lines which don’t line up correctly. Miyako’s code

Re: Create SQL DB ERD from 4D Export Structure XML File?

> Le 24 nov. 2019 à 18:54, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com > > a écrit : > > [...] > To that end, I’m investigating whether there is a way to use the XML file > that 4D creates via the EXPORT STRUCTURE command in a non-4D tool (like SQL > Server

Re: Create SQL DB ERD from 4D Export Structure XML File?

Am 24.11.2019 um 18:54 schrieb Tom Benedict via 4D_Tech <4d_tech@lists.4d.com>: > > I have a 4D method which generates a SQL DDL, but it doesn’t include > relations. So now I’m looking at the XML structure file as a possibility. Look at my Blog http://blog.heintz.net/sql-structure-access/

Create SQL DB ERD from 4D Export Structure XML File?

I’d like to use an external data modeling tool to display my 4D structure file. Ultimately I want to print the 4D Structure. I’ve tried all the 4D components and scripts and they all seem to have shortcomings. Right now I’m in the middle of a tedious screenshot, export, panoramic merge in