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: 4D Web Server Security

>> What does putting something in front of 4D gain? 4D claims and I have tested, out of the box 4d will get A+ ratings on security checks... as long as you are using the latest version and latest operating systems you are OK. Neil -- Privacy Disclaimer: This message contains

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: 4D Web Server Security

I’m only interested in serving through On Web Connection, no static pages. So why do I need anything in front of 4D? Are there known vulnerabilities in 4D other than bad programming? Is there anyway to “break” into the data? Or “break” into files that don’t exist in the web folder? What does

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/