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

2019-11-25 Thread Tom Benedict via 4D_Tech
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 tools? 

Tom

> On Nov 25, 2019, at 08:48, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> 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 “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 
>> <4d_tech@lists.4d.com>のメール:
>> Miyako’s code requires XSLT, which is now deprecated, and I didn’t want to 
>> dive into modifying it to use
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: 4D Web Server Security

2019-11-25 Thread Dennis, Neil via 4D_Tech
>> 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 confidential information and is 
intended only for the named addressee. If you are not the named addressee you 
should not disseminate, distribute or copy this email. Please delete this email 
from your system and notify the sender immediately by replying to this email.  
If you are not the intended recipient you are notified that disclosing, 
copying, distributing or taking any action in reliance on the contents of this 
information is strictly prohibited.

The Alternative Investments division of UMB Fund Services provides a full range 
of services to hedge funds, funds of funds and private equity funds.  Any tax 
advice in this communication is not intended to be used, and cannot be used, by 
a client or any other person or entity for the purpose of (a) avoiding 
penalties that may be imposed on any taxpayer or (b) promoting, marketing, or 
recommending to another party any matter addressed herein.
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

2019-11-25 Thread Keisuke Miyako via 4D_Tech
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 <4d_tech@lists.4d.com>のメール:
> As for Alexander’s code, I noticed the following sometime ago. Maybe 
> something this simple is causing the blackness as well?




**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

2019-11-25 Thread Cannon Smith via 4D_Tech
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, and 62 convert the decimal point in the height, left, top, and width of 
> the XML values to a comma. For values that have a decimal place, this can 
> make for some really, really big table widths and heights!

--
Cannon.Smith
Synergy Farm Solutions Inc.
Aetna, AB Canada




> On Nov 25, 2019, at 6:00 AM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Alexander’s code ended with a number of black tables.

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Web Server Security

2019-11-25 Thread Richard Wright via 4D_Tech
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 putting 
something in front of 4D gain?


Richard Wright
DataDomain
rwri...@datadomainsoftware.com


> Date: Sat, 23 Nov 2019 03:04:43 -0700 (MST)
> From: Paul Dennis  >
> 
> I always run 4d webserver behind an niginx web proxy. Nginx can server static
> content then forward valid requests. You can use the rewrite rules to
> validate requests. 4D then does the rest via on web Connection
> authentication. Nginx is open source, I run the Windows version as a
> service.
> 
> http://nginx-win.ecsds.eu/ 
> 
> Paul

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

2019-11-25 Thread Tom Benedict via 4D_Tech
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 “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 
> <4d_tech@lists.4d.com>のメール:
> Miyako’s code requires XSLT, which is now deprecated, and I didn’t want to 
> dive into modifying it to use

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

2019-11-25 Thread Keisuke Miyako via 4D_Tech
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 
<4d_tech@lists.4d.com>のメール:
Miyako’s code requires XSLT, which is now deprecated, and I didn’t want to dive 
into modifying it to use



**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

2019-11-25 Thread Herr Alexander Heintz via 4D_Tech
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 correct 
this in code.
In the list of tables you should see a preview of the color it will render 
with, although I do not remeber if I added the option to change the color.
I did it with a structure of 374 tables und a truckload of relations and it 
worked.
Also you can export as SVG and this can be edited in some drawing apps (I use 
Illustrator).

Regards,
Alex
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

2019-11-25 Thread Tom Benedict via 4D_Tech
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 requires XSLT, which is now deprecated, and I didn’t want to dive 
into modifying it to use

Alexander’s code ended with a number of black tables.

My effort to stitch together screenshots involves 108 1920x1080 pictures, so 
even with Snagit’s panorama feature it takes hours of manual work. Perhaps I 
should have used that time to write code instead.

I guess that printing an ERD is not common among 4D developers.

Tom Benedict  

> On Nov 25, 2019, at 00:42, Arnaud init5 imap via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 
> 
>> 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 Management Studio, MySQL Workbench etc) to create an Entity 
>> Relationship Diagram which I can manipulate and print.
> 
> Hi Tom, 
> have you seen these? 
>  >
>  >
> Using the export structure file to draw structure with SVG. 
> 
> If often use yEd, I like it's automatic redrawing. But I use it before 
> working in 4d, not after until now, I don't know how to "import" 4d structure 
> with it. 
> 
> -- 
> Arnaud de Montard 

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

2019-11-25 Thread Arnaud init5 imap via 4D_Tech


> 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 Management Studio, MySQL Workbench etc) to create an Entity 
> Relationship Diagram which I can manipulate and print.

Hi Tom, 
have you seen these? 
>
>
Using the export structure file to draw structure with SVG. 

If often use yEd, I like it's automatic redrawing. But I use it before working 
in 4d, not after until now, I don't know how to "import" 4d structure with it. 

-- 
Arnaud de Montard 





**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

2019-11-25 Thread Herr Alexander Heintz via 4D_Tech
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/ 

This does export your structure as SQL table definitions, although without the 
relations (Foreign Key Constrains in MySQL speak).
Source available for a small donation.

Adding the export of the constrains should not be too hard, maybe I could do it 
if you really want to, otherwise here is the syntax:

FOREIGN KEY (PersonID) REFERENCES Persons(PersonID)

Easy as pie :-)

**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**