AW: IP address problem

2020-06-04 Thread Epperlein, Lutz (agendo) via 4D_Tech
Hi Chip,
That's a very good answer. Are you able to post this on the new forum? Chuck 
posted the same question there. You can find it here:
https://discuss.4d.com/t/ip-adress-issue-on-server/14033?u=epperlein.lutz

Regards
Lutz

-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Chip Scheide 
via 4D_Tech
Betreff: Re: IP address problem

Chuck,
There are 2 ways to resolve this, and using both is probably best.
(following assumes DHCP)

1 - put a battery on the computer (server) so that when power goes down during 
tests the computer does not turn off.
1a - if this is already the case (it should be if it is a server) and IP 
addresses are being changed on the server then there is a switch in the network 
who's battery has failed - and Enterprise IT should track it and fix it ( might 
need to enter a ticket)

2 - talk with the IT/network people, give them the server's MAC ID (network 
card ID) and request a fixed IP address server through DHCP 
Notes on #2 : the network admin can assign a specified IP address to a specific 
MAC address, which is assigned via DHCP, then regardless of power outage, 
server reboot, etc and generally the time off the network, the IP address of 
the computer does not change.

and BTW 
- MAC is a network card term and refers to the network card's ID
- Mac(intosh) is an Apple Computer Co. computer.

DHCP with manual address usually means that the IP address has been assigned by 
specific computer Admin, rather than network admin. The IP address assigned 
this way can (and appears to) conflict with the DHCP server assigning addresses.
This is because, as I understand it, the DHCP server does not 'know' about the 
manual address.

Quickly:
DHCP hands out IP addresses in a specified range xxx.xxx.xxx.1 - 255. the range 
can be restricted, say xxx.xxx.xxx.100 - 200.
and/or the DHCP server can hand out specific IP addresses to specified MAC 
address, and random to all others.
Where I was working, IT did all of this.
Servers, and other devices which required that IP address NOT change over time, 
(requested to be fixed), were assigned in the range 1- 30, 31 - 220 were for 
network attached devices (computers, tablets etc), and 220 - 254 were for 
reserved for printers.
However, ALL addresses were assigned via DHCP - assigning a manual address was 
not allowed because:
the DHC server did not know about it, and could/would hand out the manual IP 
address to another device - creating a conflict.


Hope this helps

Chip


> Hi All,
> 
> We have a built Client server v 16.x running on a MAC
> 
> Network set up is
> DHCP with manual address
> 
> This has been working till about 6n months ago.
> 
> The hospital seems to test power outages on  fairly regular basis. 
> When they do change over to emergency power
> 
> The network pane in system preferences loses all except the IP 
> address and her we go
> 
> The 4D server running starts listening on a different IP address. Has 
> anyone ever seen this before. Tech support is telling me to switch to 
> manual address.
> 
> I have run and used this setup at many other customers
> 
> Thanks and regards
> 
> Chuck
> 
>  Chuck Miller Voice: (617) 739-0306
>  Informed Solutions, Inc. Fax: (617) 232-1064   
>  mailto:cjmillerinformed-solutions.com 
>  Brookline, MA 02446 USA Registered 4D Developer
>Providers of 4D and Sybase connectivity
>   http://www.informed-solutions.com  
> 
> This message and any attached documents contain information which may 
> be confidential, subject to privilege or exempt from disclosure under 
> applicable law.  These materials are intended only for the use of the 
> intended recipient. If you are not the intended recipient of this 
> transmission, you are hereby notified that any distribution, 
> disclosure, printing, copying, storage, modification or the taking of 
> any action in reliance upon this transmission is strictly 
> prohibited.  Delivery of this message to any person other than the 
> intended recipient shall not compromise or waive such 
> confidentiality, privilege or exemption from disclosure as to this 
> communication. 
> 
> **
> 4D Internet Users Group (4D iNUG)
> New Forum: https://discuss.4D.com
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

Hell is other people 
 Jean-Paul Sartre
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: 

AW: PDF to Jpeg

2020-05-28 Thread Epperlein, Lutz (agendo) via 4D_Tech
That's a rather strange task, I just imagine I would get the 28-page-PDF in 
front of me as a jpeg.

Anyway, I would investigate some research in using the ImageMagick command 
"convert". There are a plenty of options for conversion from almost any format 
to almost any other format. And then start it using LAUNCH EXTERNAL PROCESS.

https://imagemagick.org/script/convert.php

Regards
Lutz

-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Chuck Miller 
via 4D_Tech
Gesendet: Donnerstag, 28. Mai 2020 04:23
Betreff: PDF to Jpeg

Hi all has any one written code that wil convert amulti page  pdf to 1 jpeg 

Thanks and regards

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

AW: iNUG Messages ― Is it time for it to be more than just 'plain text' ???

2020-05-07 Thread Epperlein, Lutz (agendo) via 4D_Tech
The old 4D forum is now accessible in read-only mode at the old location.
And most of the old forum posts have been migrated to the new forum. Which 
posts were transferred is described here: 
https://discuss.4d.com/uploads/short-url/6GUCGwxhG3VLP7zWpUntMDe9u5x.pdf
to be found at 
https://discuss.4d.com/t/frequently-asked-questions/93

Regards
Lutz

-Ursprüngliche Nachricht-
Von: Paul Dennis via 4D_Tech
Betreff: Re: iNUG Messages ― Is it time for it to be more than just 'plain 
text' ???

Makes sense to me. It would be really useful if 4D were able to archive this
list plus the old 4D forum. I use nabble to search this list which works ok.
Paul

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

New Forum (was: AW: 4D Summit Videos)

2020-04-23 Thread Epperlein, Lutz (agendo) via 4D_Tech
The forum is based on Discourse, a forum software I like very much. We used it 
to implement communication base between teachers, parents and off course 
students at the school of our children. If 4D had asked me, I would have 
recommended this software to them (they didn't ask).

More information about Discourse
https://en.wikipedia.org/wiki/Discourse_(software)
or direct at
https://www.discourse.org/

Regarding notification. You can adjust very granularly the frequent of 
notifications. It can be set in every subforum between "watching" over "normal" 
to "muted". It is the small button with the bell at the top right.
The other possibility is to enable the mailing list mode in your personal 
preferences. Then you get the full broadside as we say ...

Regards
Lutz


-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Kirk Brooks 
via 4D_Tech
Betreff: Re: 4D Summit Videos

...

I encourage you all to try the new Forum. They have opted to use a company
that does this for a living (Discuss) rather than write their own. It
doesn't use 4D as I think the old one did. So it doesn't have that
nostalgic feel of a 4D form form the '90s. It's a different approach so
getting everything emailed to you is probably not going to be very
enjoyable. If you can get over those two big issues I think it's pretty
good. A couple of other forums I participate on use Discuss as well so it
may be familiar. There is no Translate button, however.
 ...
**
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
**

Decode Kerberos ticket for web authentification

2020-04-15 Thread Epperlein, Lutz (agendo) via 4D_Tech
Hi,

Are there ways to decode a Kerberos ticket using 4D?

Background: We have to implement a SSO login mechanism for web users using 
Kerberos authentication.
The authorization within a web server (IIS) in front of the 4D server works so 
far. We get a http request containing a header line “Authorization: Negotiate 
…”.
After the Negotiate keyword the Kerberos ticket is following. 
The question is now, how to decode this ticket to get information about the 
logged in user, e.g. the username or groups the user belongs to.

Or is this a complete wrong approach? Should we use an extension of the IIS 
instead, which provides the wanted information in http header lines too?
The question is then, which extension?

This is with 4D Server v17.4 on Windows Server 2012 or 2016.

Regards
Lutz

**
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
**

AW: CREATE DOCUMENT erors

2020-04-09 Thread Epperlein, Lutz (agendo) via 4D_Tech
Do you use an error handler with ON ERR CALL?

I've just tested it and I get an error -120 Tried to access a file by using a 
pathname that specifies a non-existing directory.
Or -54 Attempt to open locked file for writing.

Maybe your error from the error stack comes from an older one in this process?

Regards
Lutz


-Ursprüngliche Nachricht-
Betreff: CREATE DOCUMENT erors

Using v17:

How can I find out exactly what the error is when CREATE DOCUMENT fails?
EG: disk full, pathname invalid, document already exists and can't be
deleted, etc.
I tried calling GET LAST ERROR STACK and the error it returned was 39 "The
set does not exist" which is clearly inappropriate.

Pat

**
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
**

AW: 4D v13 web service error: -9926

2020-04-02 Thread Epperlein, Lutz (agendo) via 4D_Tech
It may related to the XML content of your SOAP request or of response. Did you 
check that? Maybe you want to access some not existing elements.
9926 means 
-9926   The referenced element is invalid.
https://doc.4d.com/4Dv17/4D/17.4/Database-Engine-Errors-10602-4004.300-4882076.en.html

So it could be something wrong with your parsing code. But I'm guessing ...

HTH

Regards
Lutz Epperlein

-Ursprüngliche Nachricht-
Betreff: Re: 4D v13 web service error: -9926

Where oh where are your -9926 thoughts?

R

> On Apr 1, 2020, at 2:02 PM, Robert ListMail via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> With a somewhat older Mac-based, v13.6-based, 4D application running with 
> legacy Web Application Server license that has been running unaltered for 
> several months any idea why I might be getting a -9926 web service error? I’m 
> noticing some orders are not transmitting (SOAP calls)…don’t see any reason 
> why. When I check them out, its usually the next day now and the only thing I 
> see is that the request date is the day before the transmit date…so I adjust 
> it to the current date and then they go through…but they were current when 
> sent to the queue. Thoughts?

**
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
**

AW: HMAC SHA256 in native 4D code?

2020-03-20 Thread Epperlein, Lutz (agendo) via 4D_Tech
Regarding JWT (JSON Web Token), there is another plugin by Miyako: 
https://github.com/miyako/4d-plugin-jwt

Lutz Epperlein

-Ursprüngliche Nachricht-
Betreff: Re: HMAC SHA256 in native 4D code?

Hi, 

I had to spend some time looking into this recently myself. You have two
options:

1 - K. Miyako has a plugin - CommonCrypto. Easy to use.
$signature:=HMACSHA256 ($keyData;$stringData;Crypto BASE64)

2 - Use PHP execute, but then encode the result (assuming you need to)
  php way if we ever need it - do not delete
  $phpOK:=PHP
Execute("";"hash_hmac";$sigBlob;"sha256";$stringToSign;$key;True)
  BASE64 ENCODE($sigBlob)
  $signature:=Convert to text($sigBlob;"utf-8")


**
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
**

AW: 4D v18.0 LTS - Form Wizard Missing

2020-02-27 Thread Epperlein, Lutz (agendo) via 4D_Tech
It's in the R-release channel > Beta version forum.
The subject of the post is "Form wizard / assistant".

Maybe you have to be a partner to access this forum, I don't know.

Regards
Lutz


-Ursprüngliche Nachricht-
Betreff: Re: 4D v18.0 LTS - Form Wizard Missing

Hallo, can´t open the Link ?

Regards
Axel Kohlepp

**
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
**

AW: 4D v18.0 LTS - Form Wizard Missing

2020-02-27 Thread Epperlein, Lutz (agendo) via 4D_Tech
See also this thread on the forums:



The idea is to get generic forms is using generic built listboxes or similar. 
And there already such components available, e.g. by Th. Maul called AutoForms.

Regards
Lutz

**
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
**

AW: Document encoding

2020-01-13 Thread Epperlein, Lutz (agendo) via 4D_Tech
I think you should first think about what encoding means, in general file 
encoding means the encoding of text files. If you use your code below with pdf 
files you destroy the pdf in a very reliable way, since pdf files are binary 
files. The same is with nearly all picture formats (and with Word and Excel 
files).
But binary files can contain section with text, this text has to be encoded in 
a certain way. To know which sections are to be encoded, you have to consult 
the documentation of the file formats. But usually tools which generate such 
files have options to do this setting by the user.

Regarding the second part of the question, how to detect the current encoding:
This can be a bit cumbersome, since plain text files doesn't have a marker 
which encoding is used. Sometimes there is a so-called BOM in the first bytes 
of the file if it is in Unicode encoding, but you can't rely on it. 
4D can help a bit: If you try to read a text file with the wrong encoding (and 
it contains bytes that can't be decoded) you will get an empty result. But it 
could be possible that the content is decoded in a wrong way and you don't get 
the right result.

Regards 
Lutz


-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Two Way 
Communications via 4D_Tech
Betreff: Document encoding

Hi All,

An important customer of mine has requested that all documents, sent to him, 
are UTF-8 encoded.
This concerns PDF files, text files, Word, Excel, picture files.

I did some tests, but can’t figure out how to do that.

If, e.g., I look at a pdf file in BBEdit, it says ‘Mac Roman’.

Then I tried to open that file in 4D (v17, UTF-8) with document to blob
then:

DOCUMENT TO BLOB(document;$blob)
$DocBlobtxt:=Convert to text(blob;2027)  // 2027 = MacOS Roman  
TEXT TO BLOB($DocBlobtxt;$docblobUTF8;UTF8 text without length)

It seems to do that correctly, but then, this file cannot be opened in preview 
( Opens, but content is blanc)

The other thing is that I need to know the encoding of the file before using 
‘Convert to text’. That is not always possible.

Is this request feasible to start with?

Any ideas how to accomplish that?   


Regards,

Rudy Mortier
Two Way Communications bvba 

**
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: HTTP Upload file size too low

2020-01-09 Thread Epperlein, Lutz (agendo) via 4D_Tech
I'm not sure if I understand your environment in which you would do that file 
upload. As I mentioned before, I did some little testing with chunked uploads 
using a web browser as a client and there a javascript library. At the server 
side I use WEB GET BODY PART in conjunction with WEB Get body part count. I was 
able to upload file up to 4 GB.

It looks really simple:

For ($index;1;WEB Get body part count)

WEB GET BODY PART($index;$MimeBody;$name;$mimeType;$filename)

// do something with the chunk received in $MimeBody

End for

If you use another client than a web browser you have to mimic the appropriate 
request. Using 4D as a client shouldn't be a problem. Simply use HTTP Request 
and build appropriate headers and body. 

Regards
Lutz




**
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
**

AW: FLUSH BUFFER

2019-12-16 Thread Epperlein, Lutz (agendo) via 4D_Tech
Please use 0 as the value of the stack size. In most circumstances it is the 
best idea to leave the memory management to 4D.
There was recently a thread about this topic on this mailing list or the 
forums. I can't find it just now.

Regards
Lutz

-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von stardata.info 
via 4D_Tech
Betreff: Re: FLUSH BUFFER

New 
process("Wait_Lis";128*1024;[TABELLE]Descrizione;[TABELLE]Num_Ip;[TABELLE]Porta_Ip;[TABELLE]Codice;*)

The stack value is correct? or is better use 0 ?
**
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: HTTP Upload file size too low

2019-12-13 Thread Epperlein, Lutz (agendo) via 4D_Tech
I did a short test with chunked uploads, that's not really a problem. We use a 
jquery widget (https://blueimp.github.io/jQuery-File-Upload/) on the frontend 
(the website) for file upload. It's easy to start chunked uploads. You have to 
handle it on the server side. One solution could be to save the chunks as 
temporary files and then chain these temporary files. This way you can avoid 
the memory problems.

I want to avoid protocols other than http. FTP is not allowed in many 
environments, otherwise you have to deal with the customer's IT security staff.

Regards 
Lutz

**
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
**

AW: HTTP Upload file size too low

2019-12-11 Thread Epperlein, Lutz (agendo) via 4D_Tech
The thing with file upload seems to be a bit strange ...

I did some tests and upload a file with size 888.3 MB, no problem.
Another test with a larger file with size 4.4G didn't work. Only a chunk of 
334.9 MB (to be exact: 351255546 bytes) was handled. I'm not able to explain 
this behavior.

Regards 
Lutz

-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Jim Labos - 
infobase via 4D_Tech
Betreff: HTTP Upload file size too low

Settings for Web Option is at the max limit. However the largest file size I
can receive is around 600mb. The limit should be aprox. 2gb.

Same limit on v13 or v15. "WEB GET BODY PART" will receive zero bytes when
file is over aprox. 600mb. I have not done this kind of coding in years but
I recall testing uploads in the gb range with no problem. 

Any clues? Thanks.

**
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
**

AW: Can't Define DEP Exception On Windows

2019-12-11 Thread Epperlein, Lutz (agendo) via 4D_Tech
Two things I see:

The first one, the Windows Server 2008 will not be supported anymore by 
Microsoft from the beginning of the next year. So it would be a very good idea 
to update the server OS, if someone will need it for production use (or even in 
other cases too).

And for the second, you don't need add such DEP exceptions anymore with newer 
versions of 4D. I don't remember which versions don't need this anymore, I 
think it started with version 4D v13.

Regards
Lutz

-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Ken Eyring 
via 4D_Tech
Betreff: Can't Define DEP Exception On Windows

Hi Everyone,

I have a customer who has a Windows 2008 R2 Server.  I had 4D v12.5 
installed on the machine and added 4D Server and 4D Client v12 as DEP 
exceptions.  These ran with no problems for many years.  I want to 
update the 4D software on the same machine to v15.4 and when I attempt 
to add the 4D Server v15.4 and 4D Client v15.4 applications to the DEP 
exceptions list, Windows displays the following message:

 "This program must run with data execution prevention (DEP) 
enabled.  You cannot turn off DEP for this program."

I'm wondering if the 4D v15.4 applications will run properly without the 
DEP exception, or if there is something that I need to configure in 
order to allow DEP exceptions to be added for the 4D Server v15.4 and 4D 
Client v15.4 applications.

Any suggestions would be very much appreciated.

Thank you,
Ken Eyring
**
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
**

AW: Constants in code.

2019-12-09 Thread Epperlein, Lutz (agendo) via 4D_Tech
You have to use xliff and you can find an example here:
https://kb.4d.com/assetid=76583

Regards
Lutz

-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Eric Naujock 
via 4D_Tech
Betreff: Constants in code.

Good morning,
This seem pretty rudimentary, but I don’t seem find anything in the 
docs for this. 

Can you define your own Constants? I would like to define constants in my 
database to cover various groups for permissions. But what I am finding in the 
docs for v17r6 says they are listed in the constants window. But there does not 
seem to be anything that tells you how to create your own. Obviously there must 
be a way to do so since there are constants for plugins. 
**
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
**

AW: 4D Web Server Security

2019-11-26 Thread Epperlein, Lutz (agendo) via 4D_Tech
Steve,

we don't do any load balancing, so I'm afraid I can't contribute anything. But 
that's an interesting area.

Regards
Lutz

-Ursprüngliche Nachricht-
Betreff: RE: 4D Web Server Security

Lutz,

Perfect, this is the information I was looking for.

In the Apache example, when you say you are running multiple instances of your 
application, are you manually implementing the load balancing or somehow have 
Apache performing the load balancing?  

This load balancing is something of great interest to me, especially when 
wanting to run multiple instances, but it is an area I'm not very strong in.  
Are you using 4D Client as the "instances" all pointing to a single 4D Server?

Any insight is appreciated!

Best,


Steve
**
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
**

AW: 4D Web Server Security

2019-11-26 Thread Epperlein, Lutz (agendo) via 4D_Tech
It depends ...
If the customer wants to run the application on their own (virtual) hardware 
then port 80 and/or 443 is used. But this run configuration isn't in the focus 
of the audits.

In all other cases, application is accessible over the internet, we use an 
Apache web server in front. But the reason for that aren't security 
considerations, it is simply because we run multiple instances of our 
application behind it and we configure different virtual hosts for the Apache 
server, each virtual host works as a reverse proxy/gateway for each app 
instance. Then every application runs on an different port. From the outside it 
appears as port 80, since the Apache runs on this port.

The audits have different areas, so they pay special attention to our rather 
exotic server software. But as I said, the IT security guys were surprised 
about the high standard of 4D.

Regards
Lutz

-Ursprüngliche Nachricht-
Betreff: RE: 4D Web Server Security

Lutz,

What port are you serving your web application on?

Steve

**
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
**

AW: 4D Web Server Security

2019-11-26 Thread Epperlein, Lutz (agendo) via 4D_Tech
To be a bit illustrative ...
From time to time we have to undergo security audits of our web application. 
The last time the IT security consultant, who made the audit, said he never 
found an application which so few security issues, because there weren’t any.
Mostly they find some issues.


-Ursprüngliche Nachricht-
Betreff: 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 putting 
something in front of 4D gain?


Richard Wright
DataDomain
**
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
**

AW: 4D Web Application and SAML or OpenID Connect

2019-11-06 Thread Epperlein, Lutz (agendo) via 4D_Tech
Hi,

we do something in this area. We use an Apache webserver in front of the 4D web 
server as a reverse proxy or gateway. There is an Apache module called 
mod_auth_openidc (https://github.com/zmartzone/mod_auth_openidc) which is 
configured to use an external identity provider (IP). In our case this is a 
Keycloak server (https://www.keycloak.org/).
On the 4D side you have to check the additional headers delivered by the module 
only. 
Further questions regarding the configuration of the module I'm not able to 
answer, this were done by external colleagues. There is comprehensive 
documentation on the mentioned websites.

Regards
Lutz Epperlein






**
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
**

AW: Error signing built app for Catalina

2019-10-25 Thread Epperlein, Lutz (agendo) via 4D_Tech
Maybe this:

https://blog.4d.com/?s=notarization

Regards
Lutz Epperlein

-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Jeremy 
Roussak via 4D_Tech
Gesendet: Donnerstag, 24. Oktober 2019 21:14
An: 4D iNug Technical <4d_tech@lists.4D.com>
Cc: Jeremy Roussak 
Betreff: Error signing built app for Catalina

App built with v17R6. Trying to sign a built application gives this:

20:07:01.341: Error 105553143319120 signing '/Users/jbr/Desktop/Final 
Application/PI calculator - Working/PI 
calculator.app/Contents/Resources/Internal User Components/4D 
Report.4dbase/Resources/Images/tbSave.png': Error Domain=NSPOSIXErrorDomain 
Code=9 "Bad file descriptor"

Is there some documentation on the topic?

Jeremy
**
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
**

AW: Web aficionados - Not allow user to access file directly

2019-10-01 Thread Epperlein, Lutz (agendo) via 4D_Tech
Use the so-called "Web decoy" technique. Basically you put your html files in 
another folder outside your html root. Then redirect all requests using ON WEB 
CONNECTION. For every http request 4D cannot serve directly, it uses ON WEB 
CONNECTION.

This is more elaborated e.g. here:

How to skip over HTTP and redirect to HTTPS
https://kb.4d.com/assetid=75313
How to skip over HTTP and redirect to HTTPS: Part 2 (The Web decoy folder)
https://kb.4d.com/assetid=75753

And there was a book "The Web Companion" by David Adams, it's a bit old now, 
but the technique remains the same. If you can get a copy ...

HTH

Regards
Lutz

-Ursprüngliche Nachricht-
Betreff: Web aficionados - Not allow user to access file directly

Hi Web Experts,

I don't want the web users to access html files directly, without going through 
ON WEB CONNECTION.

e.g.

http://myweb/foobar.html

If "foobar.html" exists in the web folder, Users can put in this in the address 
and it will pull up the web page, but will not process the 4D Tags, etc.
Very, very funky.

So, I'm probably being a dope, but does anyone know what I can do to prevent 
accessing html files directly?

Gracious thanks

Randy Engle


**
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
**

AW: Folder equivalent for: "SET DOCUMENT PROPERTIES"

2019-09-03 Thread Epperlein, Lutz (agendo) via 4D_Tech
For Windows:
Don't use the old cmd, use powershell instead.

For an example solution for your task see  
https://stackoverflow.com/a/24992975/1865659

HTH
Regards
Lutz Epperlein

-Ursprüngliche Nachricht-
Betreff: Re: Folder equivalent for: "SET DOCUMENT PROPERTIES"

Narinder,

Thanks for your response.

> On 3 Sep 2019, at 20:04 AEST, Narinder Chandi via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> IS this for Mac/Windows or both? You can use the LAUNCH EXTERNAL PROCESS 
> command:


Yes it has to be for both platforms and I suspected to have to go down to 
Terminal/DOS-promt again but hoped that someone did it already - why inventing 
the wheel again?


Let’s see what else comes up.

Cheers
Jörg

**
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
**

AW: v13 or v15 Pic Library usage

2019-08-21 Thread Epperlein, Lutz (agendo) via 4D_Tech
How is it with this:
http://association-qualisoft.eu/qs_toolbox/

Regards
Lutz

-Ursprüngliche Nachricht-

do you have a link ?

Thanks!


> Hi Chip
> 
> you can use QS_Toolbox. There is a tool which list you the objects 
> using pictures.
> -
> Patrick EMANUEL
> 
> Administrator
> www.association-qualisoft.eu
> (Soft1002, Simply Asso & QS_Toolbox)
> --
**
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
**

AW: 4Dv15 app on Windows Service

2019-08-02 Thread Epperlein, Lutz (agendo) via 4D_Tech
That should be sufficient regarding rights. The question is which resource the 
server should access. If you run the service under the default system account, 
you could get problems accessing certain network resources, printer ...
But I think this a known circumstance.

Did you check the Windows event log? Are there some crashreport and /or dmp 
files?

We only experienced such crashes if the server machine wanted to shut down 
(because of a nightly system update) and the 4D service needed to much time to 
come down. That lead in some cases to corrupted data files so the restart of 
the service after the successful system update failed too.

Regards
Lutz


-Ursprüngliche Nachricht-
Von: 4D_Tech Im Auftrag von Tarawerkz via 4D_Tech
Gesendet: Donnerstag, 1. August 2019 18:58
Betreff: Re: 4Dv15 app on Windows Service

Hi David,

For reasons of security concerns raised by the client’s IT, we could only run 
the service with a service account with administrator permissions, not quite 
the full admin user.

Regards,
Ronnie

**
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
**

AW: How to decode this text

2019-07-31 Thread Epperlein, Lutz (agendo) via 4D_Tech
Look here for further explanation:

https://en.wikipedia.org/wiki/MIME#Encoded-Word

Regards
Lutz

-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Chip Scheide 
via 4D_Tech
Gesendet: Dienstag, 30. Juli 2019 22:52
Betreff: Re: How to decode this text

Thanks

I tried but I included the UTF and ?= portions which i why it did not work.

Chip
On Tue, 30 Jul 2019 14:08:35 -0600, Neil Dennis wrote:
> Just base 64 decode it.
> 
>   RG9lcyB5b3VyIGNvbXBhbnkgb2ZmZXIgaW5zdXJhbuKFvWU/
>  
> Decoded is
> 
>   Does your company offer insuranⅽe?
> 
> Neil
**
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
**

AW: can't load internal 4D component

2019-07-31 Thread Epperlein, Lutz (agendo) via 4D_Tech
Hi David,

a question regarding this compatibility mode: Did you try it with 4D v17R5 too? 
In your first posting you only mentioned v17R4. The Software requirements 
document 
(https://download.4d.com/Documents/Products_Documentation/LastVersions/Line_17R5/VIntl/4D_v17_R5_SystemRequirements_EN.pdf)
 by 4D states 4D v17R5 is supported by Windows Server Systems in the range of 
Windows Server 2012 – Windows Server 2019.
It would be at least disappointing if it we have to switch such a compatibility 
setting on. This means more or less 4D is even not compatible with Windows 
server 2019.

Or is your component the cause of the trouble?

Regards 
Lutz

-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von David 
Ringsmuth via 4D_Tech
Gesendet: Dienstag, 30. Juli 2019 21:09
Betreff: RE: can't load internal 4D component

FYI: This case is solved!

Windows Server 2019 may require a compatibility mode enabled to allow 4D to run.

When it was enables, the 4D sofware began running correctly.

David Ringsmuth
**
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
**

AW: Query by Formula Join vs. Comparison

2019-07-25 Thread Epperlein, Lutz (agendo) via 4D_Tech
Put the contents of the field you want to compare to in a variable, then use 
the variable instead of the field in the query.

HTH

Regards
Lutz

-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Jim Medlen 
via 4D_Tech
Gesendet: Mittwoch, 24. Juli 2019 22:29
An: 4d_tech@lists.4d.com
Cc: Jim Medlen 
Betreff: Query by Formula Join vs. Comparison


I am trying to do a Query Selection By Formula that links two tables by the 
filed ItemNum with the condition that the value of a field in the first table 
does not equal a value in the second table.

When I look at the ResultPlan there is a Join on the Price fields even when I 
used the # comparison.

How do I define a comparison vs a join ?


C_TEXT($vResultPlan;$vResultPath)
DESCRIBE QUERY EXECUTION(True) //analysis mode

Query Selection by Formula([ItemDiscounts];\ ( 
([ItemDiscounts]ItemNum=[Items]ItemNum) \ & 
([ItemDiscounts]BasePrice#[Items]PriceB) \ & ([Items]PriceA#0)))

$vResultPlan:=Get last query plan(Description in text format)
ConsoleMessage("vResultPlan\r"+$vResultPlan)
$vResultPath:=Get last query path(Description in text format)
ConsoleMessage("vResultPath\r"+$vResultPath)

DESCRIBE QUERY EXECUTION(False) //End of analysis mode


vResultPlan
Join on Table : Items  :  ItemDiscounts.ItemNum = Items.ItemNum & 
ItemDiscounts.BasePrice = Items.PriceB
Items.PriceA != 0
vResultPath
Join on Table : Items  :  ItemDiscounts.ItemNum = Items.ItemNum & 
ItemDiscounts.BasePrice = Items.PriceB
Items.PriceA != 0   (3247 records found in 4 ms)
--> 4030 records found in 22 ms
**
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: What is wrong with this statement?

2019-07-10 Thread Epperlein, Lutz (agendo) via 4D_Tech
If $Return_ptr and $Column1 are pointers, you have to dereference them:

$Result:= $Column1->{ $Return_ptr->{$Item} }

For better clarity I would extract $Return_ptr->{$Item}

$index_col:= $Return_ptr->{$Item}
$Result:= $Column1->{ $index_col }

HTH

Regards
Lutz
**
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: Dot Notation in Legacy 4D Code

2019-06-21 Thread Epperlein, Lutz (agendo) via 4D_Tech
If you deal with variables you can use "Rename..." in the context menu of the 
method editor too.

Regards
Lutz
**
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: V17R3 vs PowerShell

2019-05-31 Thread Epperlein, Lutz (agendo) via 4D_Tech
Hi,

we use Powershell a lot, even in conjunction with 4D. But we never divide 
between 32bit and 46bit-Powershell. Since you use the Powershell via LAUNCH 
EXTERNEL PROCESS (LEP) the architecture (bitness) of the Powershell binary 
shouldn't matter.
And a question: Regarding your script how do you determine the variables 
'32bit PowerShell' and '64bit PowerShell'?
I'm in doubt that you call the 64bit-Powershell using the 32bit-4D-Client. Are 
you really sure?

And I'm quite sure the cause of problem is the class ' 
QBXMLRP2.RequestProcessor'. It seems to exist as 32bit on your system, so you 
can use the 32bit-Powershell only. The dependency is between Powershell and 
Quickbooks, not between 4D and Powershell regarding the bitness.

HTH

Regards
Lutz Epperlein

**
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: Managing 4D Server as a service

2019-05-10 Thread Epperlein, Lutz (agendo) via 4D_Tech
We use Windows Services all the time with success. But we have to launch the 
server application from time to time as a desktop application as John said, 
but it is pretty rare. Nearly all errors we try to catch and write the 
messages to a log file. But there are situations where this isn't possible, 
e.g. starting with wrong journal file. These messages are generated by 4D 
processes unmanageable by programming or settings.
But there is a feature request that such error message should be logged all 
the time if the application runs as a service:
https://forums.4d.com/Post/DE/19227573/1/19227655#19227655

Regards
Lutz
**
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: LEP - hide console?

2019-04-09 Thread Epperlein, Lutz (agendo) via 4D_Tech
SET ENVIRONMENT VARIABLE("_4D_OPTION_HIDE_CONSOLE";"true")

And see:
https://doc.4d.com/4Dv17/4D/17.1/LAUNCH-EXTERNAL-PROCESS.301-4178683.en.html

9. To launch a command with the current directory and without displaying the 
console:

 SET ENVIRONMENT VARIABLE("_4D_OPTION_CURRENT_DIRECTORY";"C:\\4D_VCS")
 SET ENVIRONMENT VARIABLE("_4D_OPTION_HIDE_CONSOLE";"true")
 LAUNCH EXTERNAL PROCESS("mycommand")

Regards
Lutz

**
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: Benchmark Speed Test Method

2019-04-08 Thread Epperlein, Lutz (agendo) via 4D_Tech
> Also, has anyone moved up to v17 web server yet application? (Not "web
> area", but rather the full "web server application") Can you tell how it
> compares to v15 please? Any issues one should be aware of?

We are on V17, and didn't noticed any difference. But we didn't do a real 
benchmark.

Regards
Lutz

--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--


**
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: Best scripting language to use with LEP (docx to PDF)

2019-04-05 Thread Epperlein, Lutz (agendo) via 4D_Tech
Hi Alexander,

Some time ago we gave this tool a try. The results were really good.
There were two versions of the tool, the Total Doc Converter for desktop use 
and the Total Doc ConverterX for server use.

The testing of the desktop version shows a dialog with a progress bar, this is 
rather a showstopper for server use. Testing the server version was not 
possible at this time, there were only a trial version of the desktop variant 
available. And we don't want to buy a pig in a poke, too much bad experiences 
especially in this area.
But I see just now there is a trial version of Total Doc ConverterX too. 
That's new. We will give it a try again, I think.

Thanks
Lutz Epperlein


> For conversion to and from doc/docx (pdf/html/rtf/etc.) we have been using 
> an external
> tool (with command line interface).
> It does not require MS Word but you need to install the Office compatibility 
> library
> from MS (free).
> It works well as service and is quite stable, the results are good enough 
> for us.
> The tool is called Total Document Converter by CoolUtils.
**
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: Best scripting language to use with LEP (docx to PDF)

2019-04-05 Thread Epperlein, Lutz (agendo) via 4D_Tech
> An easy way to create Word files is:
> - create a file in XML format
> - Change the file extension from xml to docx
>
> Voila! AS long as your XML is well-formed and conforms to the Open XML
> standard, it works a treat.

That's nearly the same we do. With the difference that we don't create plain 
xml, we use templates generated from real docx files because of the complexity 
of the MS Word documents. At last this is XML  too.
More see in the mentioned thread "Creating Word docs in 4D" here at the iNUG.

Regards
Lutz

**
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: Best scripting language to use with LEP (docx to PDF)

2019-04-05 Thread Epperlein, Lutz (agendo) via 4D_Tech
Regarding the topic: MS Word on the server

In the past we use the following approach to generate native .doc files:
- The application on the server generated reports as html files
- These files got an extension .doc
These files were able to open in MS Word.
But there were problems e.g. if you wanted to forward these generated .doc 
files via e-mail. They lost the property to render as a MS Word document, they 
were plain .html files again.
So we did the following trick:
- We installed MS-Word on the server.
- And then we started a script (VBS in this case) ...
- .. to open the document in MS Word and to save it as a native MS 
Word-document in format .doc
- (It could be possible to generate PDF documents as well this way.)

Now we use another approach (see the thread "Creating Word docs in 4D").
Installing and using MS Word on a server in a context of Windows services is a 
rather bad idea. This is anything else but reliable.

The in the mentioned thread described process to generate .docx documents 
works well and is reliable. Now we have the requirement to convert these 
rather complex MS Word documents to PDFs. We didn't found a good solution yet.

Regards
Lutz



> -Original Message-
> Subject: Re: Best scripting language to use with LEP (docx to PDF)
>
> Good questions Lutz :)
> I'd like to think that it will work when running as a service as long as a)
> it runs silently and b) Word is installed on the server. But that is
> certainly something that will need to be tested.
>
**
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: Best scripting language to use with LEP (docx to PDF)

2019-04-05 Thread Epperlein, Lutz (agendo) via 4D_Tech
The more interesting question is, at least from my point of view, which tools 
do you use for the conversion from docx to PDF. And do this tools work in a 
context of Windows service. Does the conversion works reliable if started from 
a 4D app running as a Windows Service.

And as suggestion for a scripting language under Windows I second Tom's 
proposal: Use powershell.

Regards
Lutz

> -Original Message-
> Subject: Re: Best scripting language to use with LEP
>
> Hi Pat,
>
> I believe that PowerShell is included in all versions of Windows:
>
> https://docs.microsoft.com/en-us/powershell/scripting/install/installing-windows-
> powershell?view=powershell-6
>
> And I see that there is a version for MacOS too, but will need to be 
> installed:
> https://docs.microsoft.com/en-us/powershell/scripting/install/installing-powershell-
> core-on-macos?view=powershell-6
>
> Tom Benedict
> >
> > Windows
> > Any suggestions as to which language would be best? PERL? Java?
**
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: Creating Word docs in 4D

2019-04-05 Thread Epperlein, Lutz (agendo) via 4D_Tech
We do that nearly the same way, with the difference that we don't use 4D Write 
or Write pro. And for Zipping and unzipping we use PHP.

And with 4D 17R4 it should possible to export from Write Pro to docx.

Regards
Lutz

> -Original Message-
> Subject: Creating Word docs in 4D
>
> As of August 2018, Write Pro could not export to a Word doc. Has that 
> changed?
>
> I have a 4D v15 application that uses 4D Write pre-defined templates that 
> contain
> home-grown embedded variables, and the code uses the WR Replace command to
> substitute data for these variables.
> Then the Write docs are exported as Word docs. Works perfectly.
>
> But in v17, I have to come up with a way to replicate this functionality.
> Is anyone using the following methodology to do this?:
> Outside of 4D:
> 1. Create a template in MS Word, with home-grown embedded variables, and 
> save it as
> a .docx file. (Which is actually a zipped collection of xml and other 
> files.)
> 2. Change the file extension to .zip .
> 3. Unzip the file, which creates a number of folders and files.
>
> In 4D:
> 1. open the resulting document.xml file.
> 2. Replace the embedded variables with data.
> 3. Resave the file.
> 4. Zip the file, using Miyako's zip plugin for 4D.
> 5. Change the extension to .docx .
>
> Anyone doing this or something like it?
>
> David
**
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: Auto Updating 4D Not Working

2019-04-05 Thread Epperlein, Lutz (agendo) via 4D_Tech
We use our own update mechanism (introduced before SET UPDATE FOLDER and 
RESTART 4D).
But we tested the 4D mechanism some time ago (I think it was with 4D v13 or 
maybe v12).
The main problem was, that the application after calling RESTART4D doesn’t quit 
fast enough. And there was no way to adjust that. We never tested this update 
way again, so I can't say it is better with more recent 4D versions. 
Could that related to your problem?

Regards
Lutz
**
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: Securing sensitive data in a 4D data file (Chip Scheide)

2019-04-01 Thread Epperlein, Lutz (agendo) via 4D_Tech
Windows has some support of Public Key Infrastructure. Maybe that's useful for 
storing keys.

Some examples using Powershell:

To find all relevant Powershell commands:

Get-Command | where Source -eq pki

To list certificates:

Get-ChildItem Cert:

List user certificates

Get-ChildItem Cert:\CurrentUser\

List certificates of a certain publisher:

Get-ChildItem Cert:\CurrentUser -Recurse | where Issuer -like CN=Bundes*


More infos:
* https://technet.microsoft.com/de-de/library/hh848636(v=wps.630).aspx
* 
https://blogs.technet.microsoft.com/scotts-it-blog/2014/12/30/working-with-certificates-in-powershell/

Regards
Lutz

**
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 Log Out

2019-03-04 Thread Epperlein, Lutz (agendo) via 4D_Tech
Hi Douglas,

> In our case we land the user at a login page which handles the httpAuth send 
> avoiding
> the nasty dialog.
> If the user is not authenticated they do not get in.  No problem there.
> If the user is authenticated then they are taken to the application (written 
> in Angular)
> At some point they will click the logout button/link and this would cause the 
> session to
> close (WEB CLOSE SESSION) and they are redirected to the login page.

Nearly the same what we do. I don't see a problem here.

> If they then typed in the index of the application index.shtml file the 
> browser was still
> passing in the old username and password so the client was getting through 
> the On
> Web Authentication and was issued with a new session ID and could use the 
> system as
> before the logout.

That's a bit strange and I don't understand it fully. 
Only one guess:
You mentioned Angular as the web framework (some call it platform, anyway).
I don't know the architecture of your web app, but it seems the problem is 
buried there. With Angular you produce so-called single page applications 
(SPA). That means that all the data entered are stored in the front end. 
Angular works with scopes, where the data is stored. So I think you have a 
scope containing the user credentials and if you go back to your start page 
this credentials are there in this scope yet. The start page isn't really a new 
page since you have single page application.
What you have to do is deleting them or destroying the scope after sending the 
credentials to server. Your current solution (see below) tries to locate the 
problem in the backend/the server. But I'm quite sure the problem is related to 
your frontend code and has nothing to do with 4D.
And for security reasons it is better to delete the credentials immediately 
after the login request, whether it is successful or not. 

Disclaimer: This hint is a guess as I said already since I don't know enough 
about your application.

Regards
Lutz 

> What I have done today is when the logout happens I now place a call using JS 
> from
> the logout page with invalid (null) credentials which causes the username and 
> password
> to be cleared.  Having carried out significant testing we have not been able 
> to get back
> in to an application page following a log out using this method.
> 
> Regards,  Dougie
**
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: LEP that will quit Chrome?

2019-03-01 Thread Epperlein, Lutz (agendo) via 4D_Tech
A correction: At least in Windows Server 2008 *R2* Powershell is pre-installed.
So I think it is the same with Windows 7.

> Can't speak for Windows7 for sure, but in all newer versions it is
> integrated.
>
> >
> > is powershell now (win7+ standard?

Regards
Lutz
**
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: LEP that will quit Chrome?

2019-03-01 Thread Epperlein, Lutz (agendo) via 4D_Tech
Can't speak for Windows7 for sure, but in all newer versions it is
integrated.

> 
> is powershell now (win7+ standard?


--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--



**
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 Log Out

2019-03-01 Thread Epperlein, Lutz (agendo) via 4D_Tech
I'm not really understand your problem. What do you mean with "the browser 
still persists with the username and password"? Does it mean that you send 
these credentials with every request to the web server?

What we do is this:
If the browser makes a request without a cookie or with wrong cookie, the 
server sends a http 401 response and the user gets a login dialog, after 
checking the credentials on the server side the server sends a cookie. All 
subsequent requests will carry the cookie, the browser does this for you. And 
the server checks at every request if the cookie is valid.
If the user press the logout button the server sends a cookie as a response 
with a cookie expiration of 0 or an expiration date in the past.
The built in 4D sessions work the same way AFAIK.

Regards
Lutz

--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--



**
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: LEP that will quit Chrome?

2019-03-01 Thread Epperlein, Lutz (agendo) via 4D_Tech
We use powershell.
In powershell you can do

Get-Process chrome

And if you want to kill the process:

Get-Process chrome | Stop-Process

Calling with LEP can do this way:

$vtxtBatchName:="powershell.exe -executionpolicy remotesigned -OutputFormat 
Text "+\
"-File \""+$PathToScript+"\""+$parameter
LAUNCH EXTERNAL PROCESS($vtxtBatchName;$standard_input_x;$standard_output_x\
   ;$standard_error_x)

In this case you have to write a small script in beforehand.

Another way of calling powershell commands with LEP is using the standard input 
of the shell:

$command:="cd '"+Get 4D folder(Logs folder)+"'; $chdate = Get-Date "
$psScript:="powershell -NoProfile -Command -"
CONVERT FROM TEXT($command;"UTF-8";$standard_input_x)
LAUNCH EXTERNAL 
PROCESS($psScript;$standard_input_x;$standard_output_x;$standard_error_x)


HTH
Lutz

--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--



**
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: Can'r run as a service on Windows 2016

2019-02-28 Thread Epperlein, Lutz (agendo) via 4D_Tech
Pat,

Have a look at the docs:
https://doc.4d.com/4Dv17/4D/17.1/Registering-a-Database-as-a-Service.300-4203714.en.html

They recommend to run the server under an user account, if you want to use 
network shares, printers and so on. 
But we don't install the services this way, we stay at system account yet, and 
don't get any problems.
We don't have experiences with Windows Server 2016 (2012 R2 yet) and we don't 
use the feature of interacting with the desktop. And we are able to connect to 
server with a client from the same machine.

A question: how do you connect the client to the server? Which address do you 
use, localhost, an IP 127.0.0.1 or another IP, a named address? That could lead 
to problems with the firewall. In case you use localhost (or 127.0.0.1), the 
firewall shouldn't be involved AFAIK.

Regards
Lutz

--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--


**
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: Odd thing with iso dates

2019-02-08 Thread Epperlein, Lutz (agendo) via 4D_Tech
Jeremy is right, mind the "Z" at the end of the date string.


Regards
Lutz

> At a guess, it’s because at that time of year, British Summer Time is active; 
> so 00:00
> on 14th August local time is 23:00 on 13th August GMT.
> >
> > 2017-08-13T23:00:00Z
**
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-for-ios repo commit bonanza

2019-02-07 Thread Epperlein, Lutz (agendo) via 4D_Tech
Do you mean https://github.com/4d/4d-for-ios ?
Which branch?


--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--


**
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: Does 4D 64-bit Volume desktop use more than 1 core?

2019-01-31 Thread Epperlein, Lutz (agendo) via 4D_Tech
Right, I see the individual cores, but I'm not able to get the part a certain 
application uses. The summary view shows me that. See this screenshot:


4D.exe is selected, the orange line in the topmost graph shows the use by 4D, 
but this line is absent on the other graphs of the cores. It would be nice to 
know how much 4D (or another application) distributes its load to the 
individual cores.

Regards
Lutz

> You can click it right click on the summary graph and have it display
> individual cores.
**
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: Does 4D 64-bit Volume desktop use more than 1 core?

2019-01-31 Thread Epperlein, Lutz (agendo) via 4D_Tech
Just out of curiosity, how can I visualize the use of the CPU cores on Windows 
using some inbuilt tools of the OS?
The task manager shows a summary only. In the resource monitor I can see the 
use the total use of all cores by an application, not the use of individual 
cores.

Regards
Lutz
**
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: Does 4D 64-bit Volume desktop use more than 1 core?

2019-01-30 Thread Epperlein, Lutz (agendo) via 4D_Tech
> So then the real questions are :
>
>   *   Is it correct that 4D Volume desktop uses only 1 core?

No.

>   *   How can I enable 4D Volume desktop to use all cores?

No. There isn't such a switch.

It is a bit more complicated, a short query for "core" on the knowledgebase 
kb.4d.com reveals:

1. [4D Summit 2018] Preemptive Programming [EN]
Product: 4D | Version: 17 | Published on: May 16, 2018 | 
https://kb.4d.com/assetid=78035
2. Quick Comparison of Deployment Hardware for Mac vs Windows
Product: 4D | Version: 16 | Published on: April 19, 2017 | 
https://kb.4d.com/assetid=77769
3. [4D Summit 2016] Secure Your Business by Mirroring Your 4D Server 
[ENProduct: 4D Server | Version: 15.2 | Published on: June 17, 2016 | 
https://kb.4d.com/assetid=77560
4. [4D Summit 2014] Troubleshooting at the Engine's Core (EN
Product: 4D | Version: 14 R3 | Published on: July 29, 2015 | 
https://kb.4d.com/assetid=77336
5. How does 4D v13 optimize static requests?
Product: 4D | Version: 13.3 | Published on: April 12, 2013 | 
https://kb.4d.com/assetid=76806
6. Allocation Table Size in 4D v11 SQL and 4D v12
Product: 4D | Version: 12 | Published on: November 23, 2011 | 
https://kb.4d.com/assetid=76413

Have a look to the blog.4d.com too. You will find much more information about 
multi-threading, preemptive multi-tasking, workers etc.

Regards
Lutz


**
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 and Subversion

2019-01-14 Thread Epperlein, Lutz (agendo) via 4D_Tech
Look at this posting from last week: 


The other docu you find on GitHub 

And regarding the import feature: you can't import forms, it is implemented 
only for methods. But export works for both, methods and forms.
Another remark: The component is based on 
 by former 4D employee Josh Fletcher.

Regards
Lutz


> -Original Message-
> Subject: Re: 4D and Subversion
> 
> So using Lutz Epperlein’s vc-framework is the same process?
> 
> Thanks,
> Sandor Szatmari

--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--


**
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 Structure Export...

2019-01-11 Thread Epperlein, Lutz (agendo) via 4D_Tech
Hi Tom,

The use of the VC_Framework component is completely independent of the version 
control system. I don't know much about the Team Foundation Server, but in 
AFAIK it has means to manage the source code. 

But again, the approach works with 4D and the import functionality of the 
VC_Framework component, but has two limitations:

- Performing an additional step after checking out the code from the source 
code administration. The steps are: 
1. you need to open a method that you are sure is not included in the current 
changeset. This is because you cannot import methods that are already open in 
4D.
2. Then you need to select the import macro. This will trigger the import 
method within the component. The rest runs automatically. It is always a good 
idea to perform a syntax check afterwards.

- The other thing is that methods cannot be deleted during the import. The 
automatic export by the component deletes previously exported methods, but the 
re-import is not able to do this. So you have to do this manually and you have 
to communicate with your team about deleted methods.

I would recommend from time to time to use a new central copy of the 4D 
structure file and to do a re-import. There are so many things besides forms 
that are not handled by the component, e.g. changes in the database structure.
We copy the current structure file to certain archive folders on our file 
server during the build process so that we can use that copy.

But besides all the problems, we have been using the component very 
successfully for years. We are used to doing the additional steps now, that's 
not a real problem, you have to keep it in mind.

Regards
Lutz Epperlein


> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Tom Benedict 
> via
> 4D_Tech
> 
> Hi Lutz,
> 
> Sorry to bug you again, but we’re moving forward on a project where we are 
> consulting
> with a client who is setting up an agile development team to use 4D. They 
> will be
> managing this team with Microsoft Team Foundation Server. I’m thinking that 
> TFS
> should be able to serve as a repository for the 4D code (methods and forms) 
> using the
> VC_Framework component that you have updated.
> 
> > We have been doing something similar for some time with the VC_Framework
> component. The original version of the component doesn't support the 
> re-import of
> code so we extended it with an import function for methods. The procedure is 
> a bit
> inconvenient, you have to do an additional step (the import) manually after 
> checking
> out the code from the versioning system (Mercurial in our case) but it works 
> flawlessly.
> We use this workflow and the vc_framework component since 4d V13. Look here 
> if you
> are interested: https://github.com/elutz/vc-framework-v17
> 
> The part that isn’t completely clear to me is the Build/Release Management 
> part. I’m
> trying to figure now is how to link code in the repository to TFS work items 
> so that the
> release manifest that TFS produces includes all the methods and forms which 
> are code
> complete and validated by QA. In your process, how do you know which methods 
> to
> import?
> 
> Tom Benedict
> *
> *
> 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: Excel copy error while 4D is running (Windows)

2018-12-17 Thread Epperlein, Lutz (agendo) via 4D_Tech
Yes, I've seen this error message in the past too. But I wasn't aware there is 
a connection to 4D. I got it using Excel without 4D even on computers without 
4D installed.
And regarding the rdpclip.exe problem, AFAIK this bug is fixed in a recent 
version of 4D, I'm think at least in 4D V13 (but I'm not sure).

Sorry, I couldn't help

Regards
Lutz

> -Original Message-
> Subject: Re: Excel copy error while 4D is running (Windows)
> 
> I should have said - I've googled it myself and found the suggestions
> about  clearing the Excel/Office clipboard.  I've tried clearing the temp
> folder and the clipboard items from Excel.  It did not help.
> 
> We've seen this problem with the rdpclip.exe process in remote desktop
> sessions, and I've heard of it showing up with TeamViewer, Delphi, and
> third party clipboard managers.
> If you exit 4D, and keep copying in Excel, it stops happening, so it is
> definitely related to 4D, if not caused by 4D.
> The bottom line is that this happens consistently for a customer, and they
> know that if they exit 4D it stops happening, so they expect us to find a
> solution.
> 
> Thanks,
> 
> Jim
**
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: Excel copy error while 4D is running (Windows)

2018-12-17 Thread Epperlein, Lutz (agendo) via 4D_Tech
I'm pretty sure the problem hasn't any relation to 4D. A quick search with the
engine of your choice shows many results: "Excel The picture is too large and 
will be truncated"
e.g.
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10/error-the-picture-is-too-large-and-will-be/fc8f6431-13c8-47f2-a4ee-2e8c04e50227

In short: The user should delete the temp folder and all clipboard items.

Regards
Lutz


> -Original Message-
> We've seen this error over the years, but not so much recently.   Now it
> seems to be back.
> This is using Windows 10 build 1803, Office Professional Plus build 1811 ,
> 4D v12.6, _and_ 4D v17hf3 (32 bit).
>
> "The picture is too large and will be truncated"
>
> Select a fairly large Range in Excel and Copy.  If 4D is running and not
> minimized, you may get the message.
> Super annoying to accounting types who live in Excel.
>
> It may depend on what is showing in 4D. An window with enterable objects, a
> plug-in like AreaList, etc.
> It's similar to the old hang when running a Remote Desktop session to a
> server running 4D Server.  Killing the rdpclip.exe process fixed that.
>
> Does anyone have any answers to prevent this?  Can we tell 4D to not try to
> interpret the clipboard?
> "On Deactivate 4D" set Focus to a non-enterable form object?
>
> For what its worth, I did some tests with this code, based on the
> documentation.
> Copying a Sheet from Excel could produce a 100MB emf picture format, along
> with UTF16 and native text.
>
>
> ARRAY TEXT(4Dsignatures;0)
> ARRAY TEXT(nativeTypes;0)
> ARRAY TEXT(formatNames;0)
>
> GET PASTEBOARD DATA TYPE(4Dsignatures;nativeTypes;formatNames)
> $totalSize_r:=0
> For ($i;1;Size of array(4Dsignatures))
>   If (4Dsignatures{$i}#"")
> $size_r:=Pasteboard data size(4Dsignatures{$i})
> $totalSize_r:=$totalSize_r+$size_r
> $msg:=4Dsignatures{$i}+": "+String($size_r;"###,###,### bytes")
> ALERT($msg)
>   End if
> End for
>
> ALERT("Total Size:  "+String($totalSize_r;"###,###,###"))
>
> Thanks,
>
> Jim
> *
> *
> 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 Structure Export...

2018-12-10 Thread Epperlein, Lutz (agendo) via 4D_Tech
> Maybe we need to consider moving team development from the centralized 4D Team
> Developer model to a distributed model  using individual copies of 4D. That 
> would
> match the classic development model and practice which non-4D developers have
> enjoyed for decades Is anyone doing
> this yet? I would try it myself, but I’m not a Partner at this time.

We have been doing something similar for some time with the VC_Framework 
component. The original version of the component doesn't support the re-import 
of code so we extended it with an import function for methods. The procedure is 
a bit inconvenient, you have to do an additional step (the import) manually 
after checking out the code from the versioning system (Mercurial in our case) 
but it works flawlessly. We use this workflow and the vc_framework component 
since 4d V13. Look here if you are interested: 
https://github.com/elutz/vc-framework-v17

A remark: we don't use it for forms. An export of forms is possible using the 
VC_framework. But we don’t re-import  forms, since this is not possible before 
17R3. (And we don't do much GUI development in 4D, it is web development 
mostly). It might be possible with 17R3 but we have to extend the component 
again. If we start with 17R3 (or later V18) I think we will adapt the component 
using the new features.

Regarding this new features in 4D V17R3 I think they are based mainly on the 
code of this component, the exported results look very similar. But a more in 
depth test with the 17R3 we didn't do yet. 

Regards 
Lutz


--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--


**
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: [off-ish] Regex help

2018-11-29 Thread Epperlein, Lutz (agendo) via 4D_Tech
Peter answered already, but if you want to test your regex, you can use e.g.:
https://regexr.com/440e2
this is with Kirk's example.

You regex looks there:
https://regexr.com/440ee

This is a nice tool which provides explanations for your regex too.

Regards Lutz


> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip 
> Scheide via
> 4D_Tech
> Sent: Wednesday, November 28, 2018 7:29 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Chip Scheide <4d_o...@pghrepository.org>
> Subject: Re: [off-ish] Regex help
>
> Thanks Kirk,
>
> That will be useful, but mostly I am wondering based on what (very
> tiny) understanding I have of Regex why the previously posted statement
> does not do what your loop does.
>
> According to Wiki :
> . - matches any single character
> ( ) - defines a marked subexpression
> * - matches the preceding element zero or more times
> so... as I read the definitions...
> "(.*:)"
>
> match any character(s), before a ":"
> a file path (on a Mac) is  :  :  ... : 
>
> Match Regex says:
> "...If you pass arrays, the command returns the position and length of
> the occurrence in the element zero of the arrays and the positions and
> lengths of the groups captured by the regular expression in the
> following elements."
>
> so I would expect(ed)
> Match regex($folderPathMotif;$File_Path;1;$path_pos;$path_len)
>
> to populate the arrays with each occurrence of ":", as your supplied
> code appears to do,
> OR
> if the Match Regex does not find/report all occurrences of ":" to
> report the FIRST instance of a ":", not the last.
>
> Thanks
> again
> Chip
>
> On Wed, 28 Nov 2018 10:16:01 -0800, Kirk Brooks via 4D_Tech wrote:
> > Chip,
> >
> > I think what you want is to parse the path into its component parts.
> >
> > This this pattern for matching:
> >
> > ([ \w\d-_]+):
> >
> > This will match letters, numbers, spaces, underscores and dashes up to the
> > semi colon. You will want to use it in a loop like so:
> >
> > $pattern:="([ \\w\\d-_]+):"
> > $start:=1
> > While(Match regex($patters;$text;$start;$aPos;$aLen))  //  pass arrays for
> > pos and len
> >
> > //  $aLen[0]  will be the length of the entire match
> >
> > // $aLen[1] will be the length of the match within the parens
> >
> > APPEND TO ARRAY($aTheParts;Substring($text;$aPos{1};$aLen{1})
> >
> > $start:=$aPos{0}+$aLen{0}  // move up to the next match
> >
> > End while
> >
> >
> > On Wed, Nov 28, 2018 at 9:51 AM Chip Scheide via 4D_Tech <
> > 4d_tech@lists.4d.com> wrote:
> >
> >> can anyone who has a clue help me?
> >>
> >> I am looking at some code:
> >> Match regex($folderPathMotif;$File_Path;1;$path_pos;$path_len)
> >>
> >> where:
> >> ARRAY LONGINT($path_pos;0)
> >> ARRAY LONGINT($path_len;0)
> >> $folderPathMotif:="(.*:)"
> >> and
> >> File_Path is, well.., a file path on a Mac (so folder separator is ":")
> >>
> >> When the above regex runs, $Path_pos and $path_len each have 1 element,
> >> and that element is a reference to the LAST occurrence of ":" in the
> >> file path.
> >>
> >> Why does the regex not populate the arrays with the location of ALL
> >> occurrences of ":", or the first occurrence of ":"?
> >>
> >> Thanks for any help...
> >> and off Nug help is fine
> >> ---
> >> Gas is for washing parts
> >> Alcohol is for drinkin'
> >> Nitromethane is for racing
> >>
> *
> *
> >> 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
> >>
> *
> *
> >
> >
> >
> > --
> > Kirk Brooks
> > San Francisco, CA
> > ===
> >
> > *We go vote - they go home*
> >
> *
> *
> > 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
> >
> *
> *
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> *
> *
> 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: Unusual crash / failure to start 4D

2018-11-28 Thread Epperlein, Lutz (agendo) via 4D_Tech
Do you do some XML Processing?
If yes, you should request some data from this user try to reproduce the issue 
with this data. Maybe there is something wrong with parsong of XML in 4D.
The "" says only 4D is not able to produce a useful 
stacktrace of the crash.


HTH
Regards
Lutz

> Exception caught: EXCEPTION_ACCESS_VIOLATION
> Time: 2018-11-28T09:44:18
>
> xercesc_3_1::DOMImplementationRegistry::getDOMImplementation
> xercesc_3_1::DOMImplementationRegistry::getDOMImplementation
> 
> 
> 
> 
> 
> 
> 
> BaseThreadInitThunk
**
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: v13 - Exporting tab delimited

2018-11-28 Thread Epperlein, Lutz (agendo) via 4D_Tech
You have to escape the data cell containing the linefeed with double quotes. 
The linefeed has to be encoded as a LF (0x0a) or as CRLF (0x0d 0x0a).

E.g.
Data  data   data 
data  data   "line1 
line2"
datadatadata

This text file you can drag onto Excel to open it (Windows).
Double click on Windows Explorer doesn't work since it is a .txt file.

Better is to save it as a .csv file and use a semicolon ";" instead of a tab. 
So you can use double click to open it (again on Windows).

Regards
Lutz

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip Scheide 
> via
> 4D_Tech
> Sent: Tuesday, November 27, 2018 11:08 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Chip Scheide <4d_o...@pghrepository.org>
> Subject: v13 - Exporting tab delimited
> 
> I would like to be able to embed a return and/or line feed into column
> in a tab delimited file (opening with Excel).
> 
> ex:
> data  data  text data with return more data  data
> 
> 
> Excel will give me:
> Col1  Col2Col3
> Data  Datatext data with
> more data data
> 
> 
> I can not see a way to do this.
> Is it possible?
> if so, how?
> 
> Thanks
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing
> *
> *
> 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: Backing up a VM - is it dangerous ?

2018-11-05 Thread Epperlein, Lutz (agendo) via 4D_Tech
It will work, but it is *not* safe.

I would use a 4D backup anyway on the same drive the vm works. In this case 
they save with the snapshot of the vm the 4D backup files too.
Or you have to dive into the feature of volume shadow copies and the supporting 
of them by 4D.

Regards
Lutz


> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Peter 
> Jakobsson
> via 4D_Tech
> Subject: Backing up a VM - is it dangerous ?
> 
> Hi
> 
> One of my sites contracts out their server maintenance, procurement and 
> general
> support to an IT contractor. The contractor is fairly adaptable and I have 
> good
> professional relations with them, however I still have to work within certain 
> “overall
> parameters”.
> 
> One of these is that their 5-user 4D accounts server runs on a VM (Virtual 
> Machine).
> When I asked them about an external drive to hold the 4D backups, they 
> replied “don’t
> worry, the whole VM gets backed up once per day and the backup is held on 
> external
> drives”.
> 
> What are the implications of backing up the VM while 4D server is still 
> running ? On the
> old days this would have been a complete no-no because of un-flushed caches, 
> locked
> datafiles and all sorts of issues. Is anybody running this particular 
> configuration ?
> 
> Though I hopefully won’t be visiting the dentist anytime soon, Laurence 
> Olivier's words
> to Dustin Hoffman spring to mind…..”is it safe !?”  ;)
> 
> regards
> 
> Peter

**
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: Structure Location--Best Practices...?

2018-11-02 Thread Epperlein, Lutz (agendo) via 4D_Tech
We use

e.g.

C:\intraplan\intraplan server\intraplan.exe
C:\intraplan\intraplan server\server database\intraplan.4dc
C:\intraplan\intraplan.4DD
C:\intraplan\intraplan.4DIndx

... and so on ..

The folder C:\intraplan\intraplan server is generated by the built process of 
4D.
The advantage is here we can update the whole thing without touching/moving of 
the data file. The update package contains the mentioned folder "intraplan 
server".

Regards
Lutz

**
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: Using 4D with Git...

2018-11-01 Thread Epperlein, Lutz (agendo) via 4D_Tech
If bitbucket works like a usual git server (I don't have experiences with it), 
you have to *clone* your repository (the remote one at github or the local 
repo) to bitbucket. The repository contains the whole history of all commits. 
You don't lose anything. Subsequent sync operations such as push and pull 
synchronizes the repositories, again with all commits.

Regards
Lutz

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Robert 
> ListMail
> via 4D_Tech
>
> If you start with your own local git data and then publish the project to 
> GitHub and
> then move it to bitbucket do you get to see the granularity of the commits 
> and have all
> of the other options offered via Git? Or, do you lose the history with each 
> transition?
**
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: SOAP over HTTPS

2018-10-29 Thread Epperlein, Lutz (agendo) via 4D_Tech
Sorry, I was bit too fast with my answer. Especially about the configuration of 
the web service on the side of 4D. This was my from remembering of using a 4D 
web service for testing purposes in the past. At this time we built this test 
service as a mockup of another external web service, that should be used in 
production later. But as I said it was some time ago, so my assumption to 
configure a hardcoded endpoint in 4D was wrong.

I did a small test now, there wasn't any problem accessing the 4d web service 
via https. The mentioned endpoint is offered correctly by 4D. E.g. if you 
access an URL https://my.superwebservice/4dwsdl then this endpoint can be found 
within the wsdl. Accessing the wsdl using the 4d web services assistant works 
without any problem.
This was tested with 4D v16 and V17.

> -Original Message-
> Lutz said:
> "is not only necessary to access the endpoint with https:// you have to 
> offer the service
> as a https:// service, e.g. you have to adjust the settings in 4D to modify 
> the wsdl in
> the proper way."

Regards
Lutz

--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--


**
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
**

AW: SOAP over HTTPS

2018-10-26 Thread Epperlein, Lutz (agendo) via 4D_Tech
Only for clarification, do you offer a soap service over https using 4D? Or do 
you want to access an external soap service using 4D? 
The latter shouldn'nt be a problem. We use it in our since 4D 2004 without 
problems (beside a proxy problem).

In the first case, do you access the service with 4D too? It could be a problem 
with the certificates, but the 4D soap client doesn't mind that AFAIK, so it 
should work in this case. But other clients could be more picky. 
And it is not only necessary to access the endpoint with https:// you have to 
offer the service as a https:// service, e.g. you have to adjust the settings 
in 4D to modify the wsdl in the proper way.

These are something thoughts, maybe it helps. 

Regards Lutz 

Von: 4D_Tech [4d_tech-boun...@lists.4d.com] im Auftrag von Douglas Cryer via 
4D_Tech [4d_tech@lists.4d.com]
Gesendet: Freitag, 26. Oktober 2018 11:19
An: 4d_tech@lists.4d.com
Cc: Douglas Cryer
Betreff: SOAP over HTTPS

Hi folks,

I need some advice on what I need to do to make 4D Web Services accept HTTPS 
calls.  I am using v17 64bit server.

In my naivety I assumed that it would just be a case of changing the URL in the 
SOAP calls to point at the https endpoint.  But this does not work and returns 
"SOAP server not reachable"

The web server works fine on https.  Whilst I can continue using HTTP for SOAP 
it means that I cannot enable HSTS which in turn means I can only achieve an A 
rating on my SSL certificate instead of and A+

Any ideas as to what I am missing?

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.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
**
**
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: Leaving the .4DB behind??

2018-10-23 Thread Epperlein, Lutz (agendo) via 4D_Tech
No, I don't think so. It would be a complete different system. 4D relies on 
the structure file, it is a database of code and other information, UI and so 
on. And it is a kind of runtime environment. If you will run the 4D code only 
from text files (in a uncertain future) you end up with a system of a 
scripting language like PHP or Javascript. But I think this all is a bit 
useless speculation ...

Regards
Lutz

**
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: Help->v11 to v17 Upgrade or New?

2018-10-18 Thread Epperlein, Lutz (agendo) via 4D_Tech
If in doubt I would vote for a rewrite, even more if the old application is 
poor 
designed. We struggle from time to time with problems caused by using legacy 
4D code. E.g. sometimes there were assumptions made in the past regarding 
performance they are nowadays simply wrong and are causing now performance 
problems even more.
And new code written by yourself you are able to understand. You can use your 
conventions and rules of developing. In my experience old code is usually poor 
or wrong commented and often because of its complexity there is some effort to 
understand and fix it.
But if you are quite sure you have to move the whole thing to a new version 
only and you don't have to touch it anymore in the future, so you can migrate 
it only. But these assumptions are wrong in the most cases, this is at least my 
experience.

So IMHO it's better to bite the bullet and build a new one from scratch.

Only my 2 cents ...

Regards

--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--



**
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: Structure to TEXT files... GitHub

2018-10-17 Thread Epperlein, Lutz (agendo) via 4D_Tech
> So, could this structure data not be used to create a new 4D database?  Can 
> it be
> imported back into 4D…?

This question hits the nail on the head. So you can export all your code and 
the forms into text files and commit them into a source code revision system 
like git or hg. But this doesn't make possible really team development at 
different locations and you aren't able to use the advantages of the mentioned 
source code systems called distributed repositories.

The usual workflow with such systems is that one developer does a check-in of 
his code, another developer checks out this code, merges the code with his own 
code, maybe resolving conflicts and checks in this modifications. And so on. 
This is a completely usual process during software developing. For developing 
web applications you can use this approach with 4D too. But if you want to use 
this for the native 4D code you are lost. It will not work even with the new 
feature of 4D V14R3 since it supports only exporting of code.

To solve this problem for us we use, now since several years, this component: 
https://github.com/elutz/vc-framework-v15
(or for V17 https://github.com/elutz/vc-framework-v17, but it's basically the 
same). The component is based on J. Fletcher's work 
(https://github.com/4D/vc-framework-v14).

This component saves your code into text files (methods and forms, it looks 
like the new V17R3 feature is based on this component) automatically if you 
save a method. So far so good and this isn't really a big difference to this 
new 17R3 feature. But we extended the component with the possibility to 
re-import the code changes. The process is described in the Readme, it is a bit 
complicated using this import comparing to other software developing processes 
but it works flawlessly. As I said we do this for some years with success.

Regards
Lutz

--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--



**
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: how do I turn it into a component or a database

2018-10-16 Thread Epperlein, Lutz (agendo) via 4D_Tech
Thomas changed the Readme some hours ago. And in fact there is mentioned the
version 4D V17R3.
And ...
> This is export only, you cannot directly import them.

As I (and others) already said ...

Regards
Lutz Epperlein


--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--


> -Original Message-
> From: Chip Scheide [mailto:4d_o...@pghrepository.org]
> Subject: RE: how do I turn it into a component or a database
> 
> I just DLed the two github libraries
> they are BOTH from v17r3
> 
> so the versioning/feature set maybe important
**
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: what to do when I don't want back button funtionality in a browser of pages from 4d

2018-10-10 Thread Epperlein, Lutz (agendo) via 4D_Tech
Hi,

at first it isn't possible to switch off the back button in a browser. But 
there are some hacks around using javascript to mimic the behavior, e.g. look 
at https://stackoverflow.com/q/12381563/1865659.
But all these techniques are not safe, I wouldn't recommend any of them. 

Better is to deal with the input of the user in 4D avoid saving the same data 
again or something like that. You can do some locking, but that's difficult 
with http because it is a stateless protocol, but you can work around it with 
the use of cookies. E.g. you can generate an unique cookie (with a UUID value 
e.g.) with the request of your page 1, afterwards only one save request with 
this cookie is accepted by 4D. 

This are my 2 cents ...

Regards
Lutz Epperlein



> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of setar accnt 
> via
> 4D_Tech
> Subject: what to do when I don't want back button funtionality in a browser 
> of pages
> from 4d
> 
> Hi All,
> I am a fledgling developer trying to become more proficient in using 4D and 
> the web
> for in-house applications.
> 
> Sinds many years 4D is capable to send, to the Web browser, the HTML page of 
> the
> Web file stored in the document whose pathname is supplied.
> 
> Every page I send to the browser is cached (back), so if I send first :
> page 1, where user enters an account# or other unique identifier
>this info is send back to 4d, a query is made (if found)
> page 2, is shown with info to, possibly, change
>say the data is updated, the page info is send back to 4D, acknowledged
> page 3, is send stating successful acceptance of the data.   All 3 pages 
> designed with
> simple HTML and inline css.
> 
> If I have 15 such case one morning, I might have 15x 3 pages possibly in the 
> cache at
> that one station / smart device.
> Pressing the back-button I can go back and update the data once more and 
> again send
> the page to the 4d database,
> which is an absolute no-no.
> 
> Is there a technique or standard that is used with 4D environment that use a 
> different
> approach, besides elaborate javascripts that bent
> and force website behavior to behave, e.g. no back button which does work for 
> one
> browser and not another.
> 
> Any tips on this would be very welcome.
> 
> In my ignorance I am thinking like, put up 1 screen for input identifier
> same screen (with other html) put up the requested data
> at acknowledgement, redraw again screen 1 for input of identifier.
> 
> thus no back-button action possible (?), what’s wrong with this picture ?
**
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: button picture problems in v16 and v17

2018-09-21 Thread Epperlein, Lutz (agendo) via 4D_Tech
Which user mode component do you use, the really old one by Th. Maul or the 
slightly more up-to-date by Keisuke Miyako? Look here: 
http://kb.4d.com/assetid=76942

With Thomas' component you are out of luck. There isn't any source code 
available and it uses .pict pictures. And it isn't recommended for versions 
above V12 anyway.
Switch to Miyako's component. It uses your input and output forms. No need to 
copy resources into the Resources folder of the component. And it works out of 
the box.

HTH
Lutz

--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--



> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chuck 
> Miller via
> Subject: button picture problems in v16 and v17
>
> Hi All,
>
> I am using user mode component created many moons ago. I have updated my 
> input
> forms and now none of the pictures for the buttons show up.
>
> The input forms are of course in the host db. Buttons on those forms are 
> inside the
> images folder and appear during editing. I have copied the same folder 
> structure inside
> the component, thinking that would solve the problem, but alas it does not. 
> Any ideas
> as to what I might do
>
> I guess I could try putting in Picture library but am loath to do so
>
> Thanks and regards
>
>
> Chuck
**
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: PDF generation on Windows - Latest Thinking

2018-09-13 Thread Epperlein, Lutz (agendo) via 4D_Tech
I second the statement below. We did some testing with PDF Creator in the
Past and were not convinced. Especially we wanted to use it on the server
side,
creating PDFs for providing via the webserver.
First, it was not stable.
Second, we had to explain which software we want to install on the
customer's server and we are observed during the install process. And PDF
creator
showed a bit strange behavior, it didn't look like a professional software
at least
with the version 4D requires (1.7).
And last but not least, for any reason we leave an installation archive of
PDF creator on one of our developing servers and got recently an information
From our inhouse IT department because a virus scanner detected it as
malware:
Fileshare : \...\PDFCreator-1_7_3_setup.exe
Malware Severity: Severe
Category: Potentially Unwanted Software

Hmm ...

Regards
Lutz

> There is a risk using a particular version of utility software that is not
> being actively developed. There are a years of bug fixes and compatibility
fixes that are
> not there and there is always the risk that a future Windows or 4D update
could break the
> solution.
>
> With the strong focus on software security, audits of installed software
> highlight software that is out of date or no longer receiving updates. PDF
Creator
> v1.7 would fall in to the category.
**
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: Storage — Server vs Client

2018-09-10 Thread Epperlein, Lutz (agendo) via 4D_Tech
Maybe I didn't answer exactly enough: If you want to access the storage object 
of the server *from the client* you can use something like EXECUTE ON SERVER or 
the appropriate attribute of the method.
If you want the storage object of another client, EXECUTE ON CLIENT comes into 
my mind ...

Regards
Lutz

> Subject: Re: Storage — Server vs Client
> 
> I was hoping there was a way to access the storage object on the server from 
> a client.
> it would make a lot of things very simple. For example, the record key 
> sequencing
> would be very simple.
> 
> Is there a way to access the shared objects of another machine (i.e. server 
> or another
> client)?
> 
> regards,
> Chris
**
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: Storage — Server vs Client

2018-09-10 Thread Epperlein, Lutz (agendo) via 4D_Tech
If I'm not wrong the explanation is simple. If you access the storage on the 
client you get the storage of the client, on the server you get the storage 
object of the server. If you want to access the server's storage you can use 
something like EXECUTE ON SERVER or the appropriate attribute of the method.

Please correct me, if I'm wrong

Regards
Lutz

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chris 
> Belanger via
> 4D_Tech
> Sent: Monday, September 10, 2018 8:20 AM
> To: 4D iNUG Technical <4d_tech@lists.4d.com>
> Cc: Chris Belanger 
> Subject: Storage — Server vs Client
> 
> I am intrigued by the storage object.
> 
> The documentation says that there will be a storage object for the server and 
> for each
> client.
> 
> But I have not been able to see an explanation of how you directly use both.
> 
> So how are they differentiated in code?
> 
> — Thanks
> *
> *
> 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: 4Dv15 applications as a Service in Windows Server 2012

2018-09-04 Thread Epperlein, Lutz (agendo) via 4D_Tech
Do you run only one single 4d server on this Windows server?
If you have multiple 4d servers please set the SQL port to a different value 
even you don't use SQL (not only the common C/S ports).

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Ronnie Teo 
> via
> 4D_Tech
> Sent: Monday, September 3, 2018 10:35 AM
> To: 4D iNug Technical <4D_Tech@lists.4D.com>
> Cc: Ronnie Teo 
> Subject: 4Dv15 applications as a Service in Windows Server 2012
>
> Hi,
>
> I have not been able to run v15 applications as a service under Windows 
> Server 2012,
> using 4Dv15.5
> When the service is started, I am unable to connect to the database from a 
> client, the
> Available tab is also empty.
>
> It is not a problem when the same v15 application is launched directly with 
> the 4D
> Server application from the same 2012 server.
> If I launch a separate v13 application from the same 2012 server, it works 
> fine too.
> In both the above scenarios, there is no issue with client connections.
>
> Can anyone advise?  Is there some setting I have to carry out to facilitate 
> a v15 app
> running as a service?
>
> Regards,
> Ronnie
> Tarawerkz
>
> *
> *
> 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: Query for null/empty UUID

2018-08-21 Thread Epperlein, Lutz (agendo) via 4D_Tech
Found that:


> Subject: Query for null/empty UUID
> 
> What's the best way to query for a null/blank UUID () ?
**
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 v16 Server and Windows Server 2016

2018-07-25 Thread Epperlein, Lutz (agendo) via 4D_Tech
> I am leaning towards using a user to run the 4D servers and lock the session 
> between
> RDC sessions.

We have done this in the past. But we will never do it again. It's calling for 
trouble. Every nightly Windows update stops your application beside other 
problems, e.g. admins not aware that they must not close the server gui. And 
so on.
Even 4D server performs better as a service, at least is this our experience.

Regards
Lutz

**
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: v13 (+?) - Find in design

2018-07-20 Thread Epperlein, Lutz (agendo) via 4D_Tech
Supporting RegExp could be a way to construct more sophisticated queries.

Regards
Lutz

> does anyone else want  more capabilities with Find in Design?
**
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 Server as a Service

2018-07-20 Thread Epperlein, Lutz (agendo) via 4D_Tech
I can only guess ...
We experienced something similar in the past, but always it reveals to be a 
problem caused by us. An example: Usually our server apps are updated 
automatically during the night, so the service hat to be restarted by the 
update script. In nearly all cases it works very well, but it happened that 
there were an error in the startup code of the new version and we got a 
problem. Not nice, but ...

If we are faced with such problems, I restart the server app as a normal 
application not as a service, only to look if there are some error messages 
thrown by the 4D server. Unfortunately all these messages are not logged into 
a file by 4D, so I have to go the way via application start.

Theoretically it could be a problem with the interactive services if you use 
them. These services are more and more restricted by Microsoft. We don't use 
them.

Finding the real cause of the problem is rather difficult or even not 
possible. If you restarted the service and all was going well there isn't any 
chance to get the cause. You can try to have a look at the Windows Eventlog 
but the messages by 4D are mostly not helpful.

Regards
Lutz
**
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: Server Monitoring...

2018-07-17 Thread Epperlein, Lutz (agendo) via 4D_Tech
NAGIOS works very well, all our servers are monitored by NAGIOS. And that by 
simply monitoring the http(s) ports.

HTH

Regards
Lutz

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Who’s the Gestapo?

2018-07-16 Thread Epperlein, Lutz (agendo) via 4D_Tech
Below you can find a link to the list options: 
https://lists.4d.com/mailman/options/4d_tech
There you are able to adjust e.g. the setting:
> Receive your own posts to the list?
> Ordinarily, you will get a copy of every message you post to the list. If 
> you don't want to receive this copy, set this option to No.

May be you changed that in the past.

Regards
Lutz

> I post to this list from Outlook. I have no idea why, by my original post 
> doesn't
> *seem* to appear in the list. In other words, I don't get an email from the 
> list showing
> my original post. Curious. I can't explain it. (Not a problem for me)
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Web Service Call in 4Dv15

2018-04-19 Thread Epperlein, Lutz (agendo) via 4D_Tech
Not sure, but maybe there is an issue with the certificates on the v15 server. 
If I remember correctly, it isn't necessary to have a pub key file in the 
database folder, it could even be harmful to https connections.

HTH
Regards
Lutz Epperlein
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: v13+ LEP - What is sent to OS

2018-04-12 Thread Epperlein, Lutz (agendo) via 4D_Tech
AFAIK it is installed per default since Win XP, I'm sure that is installed in 
Win 7 and Win 10 and of course in the matching server versions.

Regards
Lutz

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip 
> Scheide via
> 4D_Tech
> Sent: Thursday, April 12, 2018 5:07 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Chip Scheide <4d_o...@pghrepository.org>
> Subject: Re: v13+ LEP - What is sent to OS
>
> I will investigate further, but as I understand:
> Robocopy is an EXTERNAL dos command, and as such is not (or may not) be
> installed on some/all Windows systems.
>
> xCopy is part of command.com, and as such exists on all windows systems
> (at least all that would be in use today).
> Chip
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: v13+ LEP - What is sent to OS

2018-04-12 Thread Epperlein, Lutz (agendo) via 4D_Tech
I second this recommendation. Robocopy is far better and more flexible than 
xcopy.
But the problem with escaping of paths remains the same.

Regards
Lutz

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Kenneth 
> Geiger
> via 4D_Tech
> Sent: Wednesday, April 11, 2018 11:51 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Kenneth Geiger 
> Subject: Re: v13+ LEP - What is sent to OS
>
> Have you tried ROBOCOPY instead of XCOPY?
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Detection of 4D running in a VM

2018-04-09 Thread Epperlein, Lutz (agendo) via 4D_Tech
A call to "aa4D_M_Get_Information_Text" from the Info-Report component gives 
such information.

E.g.

   EXECUTE 
METHOD("aa4D_M_Get_Information_Text";*;"Array_Profiler";->$infoReport)  // Get 
the content of the Array_profiler.txt

The result is:

Manufacturer : VMware
Model Identifier : VMware Virtual Platform
Memory : 12288
System version : Windows Server 2008 R2 Standard SP1 (64-bit)
...
and so on.

Regards
Lutz Epperlein




> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Jörg Knebel 
> via
> 4D_Tech
> Sent: Monday, April 9, 2018 3:46 PM
> To: 4D Tech Mailing List Technical <4d_tech@lists.4d.com>
> Cc: Jörg Knebel 
> Subject: Detection of 4D running in a VM
> 
> G’day all,
> 
> I’m wondering if someone managed to identify uniquely if a 4D-application is 
> running
> in a VM…
> 
> I’m testing an application in Windows10 Pro while Win10P is running in VM 
> Ware,
> Parallels, VirtualBox on a Mac.
> 
> To get hardware and software information in Windows I use the fast 
> command-variety
> of “wmic” on the Mac the terminal command “system_profiler” has proven to be 
> useful.
> 
> The idea behind this stunt is to allow/deny an application to run in a 
> VM-enviornment.
> 
> Big ideas??
> 
> Any help/hint/4D-code is appreciated.
> 
> Thanks
> 
> Cheers
> Jörg
> *
> *
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Signed emails to the list?

2018-04-05 Thread Epperlein, Lutz (agendo) via 4D_Tech
Hi Tim,

thanks, it seems to work, the signed email is delivered via iNUG.

Lutz

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Epperlein, 
> Lutz
> (agendo) via 4D_Tech
> Sent: Thursday, April 5, 2018 9:42 AM
> To: Timothy Penner <tpen...@4d.com>; 4D iNug Technical 
> <4d_tech@lists.4d.com>
> Cc: Epperlein, Lutz (agendo) <lutz.epperl...@agendo.de>
> Subject: RE: Signed emails to the list?
>
> Hi Tim,
>
> Ok, here is a signed one ...
> Background: It is a S/MIME-signed email using MS Outlook.
>
> Regards
> Lutz
>
> > -Original Message-
> > From: Timothy Penner [mailto:tpen...@4d.com]
> > Sent: Thursday, March 29, 2018 6:36 PM
> > To: 4D iNug Technical <4d_tech@lists.4d.com>
> > Cc: Epperlein, Lutz (agendo) <lutz.epperl...@agendo.de>
> > Subject: [Junk released by User action] RE: Signed emails to the list?
> >
> > Hi Lutz,
> >
> > > it seems signing of emails prevents the delivery ...
> >
> > I don't think that sending signed emails to the iNUG has ever worked...
> > However, I just
> > made a small modification to the list settings that may start to allow it 
> > to
> > work;  would
> > you like to retry sending a signed message?
> >
> > Kind Regards,
> >
> > Tim PENNER
> >
> >
> >
> > Timothy Penner
> > Senior Technical Services Engineer
> >
> > 4D Inc
> > 95 S. Market Street, Suite #240
> > CA 95113 San Jose
> > United States
> >
> > Telephone : +1-408-557-4600
> > Standard :  +1-408-557-4600
> > Fax :   +1-408-271-5080
> > Email : tpen...@4d.com
> > Web :   www.4D.com
> >
>
> *
> *
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Signed emails to the list?

2018-04-05 Thread Epperlein, Lutz (agendo) via 4D_Tech
Hi Tim,

Ok, here is a signed one ...
Background: It is a S/MIME-signed email using MS Outlook.

Regards
Lutz

> -Original Message-
> From: Timothy Penner [mailto:tpen...@4d.com]
> Sent: Thursday, March 29, 2018 6:36 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Epperlein, Lutz (agendo) <lutz.epperl...@agendo.de>
> Subject: [Junk released by User action] RE: Signed emails to the list?
>
> Hi Lutz,
>
> > it seems signing of emails prevents the delivery ...
>
> I don't think that sending signed emails to the iNUG has ever worked... 
> However, I just
> made a small modification to the list settings that may start to allow it to 
> work;  would
> you like to retry sending a signed message?
>
> Kind Regards,
>
> Tim PENNER
>
>
>
> Timothy Penner
> Senior Technical Services Engineer
>
> 4D Inc
> 95 S. Market Street, Suite #240
> CA 95113 San Jose
> United States
>
> Telephone : +1-408-557-4600
> Standard :  +1-408-557-4600
> Fax :   +1-408-271-5080
> Email : tpen...@4d.com
> Web :   www.4D.com
>

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: v13 -Automatically repaired method

2018-03-29 Thread Epperlein, Lutz (agendo) via 4D_Tech
Resend it, because the initial email was signed and signing isn't accepted by 
the iNUG ...

> -Original Message-
> From: Epperlein, Lutz (agendo)
> Sent: Wednesday, March 28, 2018 9:32 AM
> To: '4D iNug Technical' <4d_tech@lists.4d.com>
> Subject: RE: v13 -Automatically repaired method
>
> An alternative way is to use this component: 
> https://github.com/elutz/vc-framework-
> v15
> After every change of a project method the code is saved as a text file. 
> Saving means
> Ctrl-S or closing the method editor.
> It exports forms too. The component is based on work by Josh Fletcher and it 
> is a fork
> of his development.
> We extended the component to re-import code changes into project methods.
>
> HTH
> Lutz Epperlein
>
> --
> Lutz Epperlein
> --
> Agendo Gesellschaft für politische Planung mbH
> Köpenicker Str. 9
> 10997 Berlin
> http://www.agendo.de/
> --
>

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Signed emails to the list?

2018-03-29 Thread Epperlein, Lutz (agendo) via 4D_Tech
Ok, it seems signing of emails prevents the delivery ...
This email isn't signed ...

> -Original Message-
> From: Epperlein, Lutz (agendo)
> Sent: Thursday, March 29, 2018 9:06 AM
> To: '4d_tech@lists.4d.com' <4d_tech@lists.4d.com>
> Subject: Signed emails to the list?
>
> Could it be, that signed e-mails are not accepted by the iNUG?
> This email is signed.
>
> Regards
> Lutz Epperlein
>
> --
> Lutz Epperlein
> --
> Agendo Gesellschaft für politische Planung mbH
> Köpenicker Str. 9
> 10997 Berlin
> http://www.agendo.de/
> --
>

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

AW: Collections

2018-03-16 Thread Epperlein, Lutz (agendo) via 4D_Tech
For another reason using collections see this feature request: 
http://forums.4d.com/Post/DE/19953344/1/19953345#19954007

Regards
Lutz Epperlein

Von: 4D_Tech [4d_tech-boun...@lists.4d.com] im Auftrag von Jim Dorrance via 
4D_Tech [4d_tech@lists.4d.com]
Gesendet: Freitag, 16. März 2018 13:44
An: 4D iNug Technical
Cc: Jim Dorrance
Betreff: Re: Collections

Clearly explained. Thank you.

On Fri, Mar 16, 2018 at 1:23 PM, Jeff Grann via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Haven’t worked with them yet, but my understanding is that a collection is
> an ordered list of values of possibly varying types.  In 4D arrays, all of
> the values must be the same type.  In a 4D collection, you can use mixed
> types as the elements.
>
> Example:
>
> $MyCollection[0]:=“Hello”
> $MyCollection[1]:=5
> $MyCollection[2]:=$AnObject
> $MyCollection[3]:=$AnArray
> $MyCollection[4]:=True
>
> --
> Jeff Grann
> SuccessWare, Inc.
>
> > On Mar 15, 2018, at 10:43 PM, Keith Goebel via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> >
> > Hi all.
> > 4D seem to be really fired up about the new Collection object available
> in upcoming versions.
> > I’ve read the examples given in the blurb, but I have yet to read
> anything that would give me an idea as to why I would want to use a
> Collection instead of an Object.
> > It seems as though Collections are objects that don’t need a name
> parameter to identify the content; but if I have to name a Collection,
> what’s the difference between that and an Object item?
> >
> > There must be a very good reason for them, and I am sure I’m missing the
> point, but what is it?...
> > Cheers, Keith
>
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
>



--
Jim Dorrance
jim.dorra...@gmail.com
4...@dorrance.eu
www.4d.dorrance.eu

PS: If you know of anyone that needs an experienced 4D programmer to add
energy and experience to their team, please let me know. I have
experience in many areas. Reasonable rates. Remote or Paris only.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

AW: 4D data on the web - what do you use?

2018-03-14 Thread Epperlein, Lutz (agendo) via 4D_Tech
> One of the best JavaScript IDEs for Mac is WebStorm by JetBrains.

WebStorm runs on Windows too, I second Bernd's recommendation.

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

AW: 4D data on the web - what do you use?

2018-03-14 Thread Epperlein, Lutz (agendo) via 4D_Tech
We do the REST API thing. Since 4D introduced the object type it is easier than 
before.
For the frontend we use the Angular framework with a bunch of tools and 
widgets. 

In the backend we don't use any special thing, just plain 4D. We build a 
client/server application. At some customer sites a Apache or IIS is in front 
of the 4D web server as a reverse proxy.

For the frontend the core is the AngularJS framework and Bootstrap as the CSS 
framework. As said there are some other tools we use especially for the build 
process: grunt, sass-compiler, minimizer, uglifier, ant ... to mention a few.

So it is possible to decouple the frontend development and the developing of 
the 4D code. It easier to get new developers since most of them know HTML, 
Javascript, CSS, SASS, LESS and so on. If you ask them for 4D you get a 
confused look.

In theory we are able to exchange the complete backend with another one based 
on a different technology than 4D. We didn't do this in the past, because it is 
a remarkable effort to implement the complete bussiness logic in a new way. And 
4D simply works. After some discussions all customers accepted the decision for 
4D and are lucky with it in the daily operation.

Regards
Lutz
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: v13 - LEP and MS-DOS command line

2017-11-03 Thread Epperlein, Lutz (agendo) via 4D_Tech
Maybe the same thing like in this thread: Re: NTK plugin installed but not 
recognizing commands on client using server:

> Solution found:
>
> Database was not retokenizing procedures, even though NTK calls looked
> bold and active. I think putting the database through maintenance and
> repair may address this problem.

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

RE: v13 - LEP and MS-DOS command line

2017-11-02 Thread Epperlein, Lutz (agendo) via 4D_Tech
Regarding 'du' on Windows:
You don't need to install it on the client machine. Only copy the du.exe in an 
accessible directory with 4D means and run it with LEP. Of course it is an .exe 
file, maybe some security software will stop the execution. 

Only my 2 cents

Regards
Lutz



> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Chip Scheide 
> via
> 4D_Tech
> Sent: Thursday, November 2, 2017 5:51 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Chip Scheide <4d_o...@pghrepository.org>
> Subject: RE: v13 - LEP and MS-DOS command line
> 
> Thanks for the link to DU for Windows, but in this instance the
> software will not be on machines I control... so an additional piece of
> software (outside of 4D, plugins are OK) does not work.
**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: open gmail in browser from 4D

2017-11-02 Thread Epperlein, Lutz (agendo) via 4D_Tech
> open url(“mailto:some mail”;"https://mail.google.com/“)

Of course this doesn't work. The second parameter is called appName according 
the docs (http://doc.4d.com/4Dv15/4D/15.5/OPEN-URL.301-3576781.en.html). 4D 
will use the local system to search for such an app. "https://mail.google.com/“ 
isn't an app, it is an URL.

You can try 
OPEN URL("https://mail.google.com/mail/u/0/#inbox?compose=new;) 
Of course the user has to be logged in into Gmail already. 
Maybe there is some documentation on the Google developer pages to do it more 
reliable.

HTH

Regards
Lutz

--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--



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

RE: 4D Remote hanging at 3am after upgrading to Hi Sierra.

2017-10-30 Thread Epperlein, Lutz (agendo) via 4D_Tech
Brad, you wrote in your first posting, you saw a 4D error message very shortly. 
But you weren't able to read it. 
So it would be really helpful if a 4D Server would not show such messages only, 
they should also be logged into a file (or in system log) regardless of my 
settings, at least during the starting phase of the server.
The usual message in the (Windows) Event log that 4D is started is not really 
helpful.

I just filed a feature request, look here: 
http://forums.4d.com/Post//21398249/1/

This request doesn't help you so much in the present situation, but if this 
feature would exist already it would be really helpful and you would a step 
further in your problem solving, I think.


Thanks
Lutz Epperlein

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

RE: POP3 Email Processing

2017-10-27 Thread Epperlein, Lutz (agendo) via 4D_Tech
The main problem with 4D Internet Commands is: 
It blocks the whole application while waiting for and downloading messages from 
the server. This is because the plugin interface of 4D is designed to be in 
cooperative mode. Even switching to v16 and using preemptive threads will not 
help, the plugin interface isn't thread-safe.

So if you want to receive e-mails the best thing is to use a third party tool 
and develop a non-blocking interface to this tool. Developing a plugin will not 
help.

We are challenged with the same problem, so we decided to get the e-mails using 
a job in the night, so blocking of the server doesn't disturb anyone. For the 
requirements of our customers this is ok.

HTH
Lutz Epperlein


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

RE: Server Process "Frozen"-ish

2017-10-27 Thread Epperlein, Lutz (agendo) via 4D_Tech
> I am confident that 4D will find this bug and get it fixed. If it takes 6 
> months, then my
> upgrade plans will be on hold for 6 months. I’m in no hurry to upgrade right 
> now.

Is there a case (TAOW or anywhere) in progress?
I'm afraid that this discussion on the list doesn't lead to a solution of the 
problem, since 4D ignores it for its works.

I ask because we want to upgrade to v16 this year, so there are two months only 
...

Regards
Lutz


--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--



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

(Offish) RE: NB: Pre-emptive mode hassle

2017-10-12 Thread Epperlein, Lutz (agendo) via 4D_Tech
> Nobody likes when someone says “what’s wrong with you? You are a weirdo for 
> not
> thinking of this.”  
> 
> you are going to catch a lot more flies with honey than with vinegar. Give it 
> a
> try you are going to find it really does work.
> Who do you want to talk to or listen to? A “nice guy” or an “angry man 
> shaking his
> fist”.

I like that. :-)

Regards
Lutz

--  
Lutz Epperlein  
--
Agendo Gesellschaft für politische Planung mbH
Köpenicker Str. 9
10997 Berlin
http://www.agendo.de/
--


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

  1   2   >