RE: iNUG List "From" Change

[Epperlein, Lutz (agendo) via 4D_Tech]

Which mailer do you use? Apple Mail? Outlook on Windows shows something like 
that:
"4D_Tech <4d_tech-boun...@lists.4d.com>; im Auftrag von; Cannon Smith via 
4D_Tech <4d_tech@lists.4d.com>" 

It's a German Outlook version, "im Auftrag von"  means "on behalf of".

In the headers there is presently (showing only a part):

MIME-Version: 1.0 (Mac OS X Mail 10.2 \(3259\))
Subject: iNUG List "From" Change
Date: Fri, 17 Feb 2017 06:54:55 -0700
To: 4D iNUG Technical <4D_Tech@lists.4D.com>
List-Id: 4D iNug Technical <4d_tech.lists.4d.com>
List-Unsubscribe: ,
 
List-Post: 
List-Help: 
List-Subscribe: ,
 
From: Cannon Smith via 4D_Tech <4d_tech@lists.4d.com>
Reply-To: 4D iNug Technical <4d_tech@lists.4d.com>
Cc: Cannon Smith 
Errors-To: 4d_tech-boun...@lists.4d.com
Sender: "4D_Tech" <4d_tech-boun...@lists.4d.com>

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: Why doesn't 4D generate a crash log or report?

[Epperlein, Lutz (agendo) via 4D_Tech]

Two remarks to the Windows crash dump:

- If the app is running in a by Windows write protected folder the crash dump 
is saved in the so called virtual store, e.g. if the 4D.exe of 4D V15.3 is 
crashed you will find the dump under 
"C:\Users\\AppData\Local\VirtualStore\Program Files (x86)\4D\4D 
v15.3\4D\4D.exe.dmp"
There was just one from yesterday :-(

- Usually the crash dump by Windows doesn't contain sufficient information.

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

How to digitally sign an XML document

[Epperlein, Lutz (agendo) via 4D_Tech]

The subject says it. How do I do this with 4D? 

I found a description how to do it using the .NET Framework: 
https://msdn.microsoft.com/de-de/library/ms229745(v=vs.110).aspx
The following question is the question for verifying of signed xml documents. 
There exists a .NET reference too: 
https://msdn.microsoft.com/de-de/library/ms229950(v=vs.110).aspx
There using some .NET classes, of course there aren't available in 4D. But is 
there an easy way to achieve the same with 4D?

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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: tab seperated text - what to use for Cr

[Epperlein, Lutz (agendo) via 4D_Tech]

The easiest way to get what Excel wants to get, is creating example data in 
Excel and exporting it as a tab delimited file.

The problematic characters are line wraps, tabs and quotes inside a cell.

The rules:

- field delimiter is tab, record delimiter is CR LF (0x0d 0x0a)

- Tabs inside cells are not allowed in tab delimited format.

- line wraps in cells are encoded as LF (0x0a), the whole cell content is 
enclosed in double quotes (0x22)

- double quotes in cell content are escaped with double double quotes and again 
the cell is wrapped in double quotes



Example:

"first line

second line"abc tab

do or don't "some text ""quoted""."



Hex view:

000 22 66 69 72 73 74 20 6c 69 6e 65 0a 73 65 63 6f  >"first line.seco<

020 6e 64 20 6c 69 6e 65 22 09 61 62 63 20 74 61 62  >nd line".abc tab<

040 0d 0a 64 6f 20 6f 72 20 64 6f 6e 27 74 09 22 73  >..do or don't."s<

060 6f 6d 65 20 74 65 78 74 20 22 22 71 75 6f 74 65  >ome text ""quote<

100 64 22 22 2e 22 0d 0a >d""."..<



HTH

Regards Lutz





> -Original Message-

> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Tim Nevels 
> via

> 4D_Tech

> Sent: Wednesday, March 15, 2017 8:39 PM

> To: 4d_tech@lists.4d.com

> Cc: Tim Nevels 

> Subject: Re: tab seperated text - what to use for Cr

>

> On Mar 15, 2017, at 2:00 PM,Chip Scheide wrote:

>

> > I am trying to export some data to tab separated format.

> > it is possible that there are carriage returns in the data.

> > Is there a character (or combination) that I can use to replace the

> > return to get excel to automatically wrap the text into one cell?

>

> “Space" will work and had no cross-platform macOS/Windows Excel issues. I do 
> this

> whenever

>

> You might also try option-space if you are on macOS. That used to represent a 
> “hard

> space” that some Mac software would recognize and treat like a “soft return”. 
> You

> would have to do some testing to verify how current versions of Excel handle 
> this and

> how it is handled on Windows.

>

> On Windows Excel will handle alt-Enter as a special line break character. But 
> I believe

> this is just a LF — line feed, char(10) — character so it may be problematic 
> since end

> of record delimiters are typically CR+LF.

>

> Tim

>

> 

> Tim Nevels

> Innovative Solutions

> 785-749-3444

> timnev...@mac.com

> 

>

> *

> *

> 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

> *

> *
**
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 Server Crashes When Tracing Buggy Web Connection Code

[Epperlein, Lutz (agendo) via 4D_Tech]

To be honest, I don't understand these problems. Our main product relies 
heavily on the 4D webserver on the server, for years. So far there aren't any 
serious problems. If there are any, we wouldn't use 4D anymore.
And running the webserver on a client isn't an option for us.

The only problem we experienced which causes a server crash is accessing an 
array with a negative index. But such things are caused by serious bugs (during 
development).
What compiler settings do you use? 

Regards
Lutz

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Joshua Hunter
> via 4D_Tech
> Sent: Thursday, April 6, 2017 11:56 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Joshua Hunter 
> Subject: RE: 4D Server Crashes When Tracing Buggy Web Connection Code
> 
> The web server process is very sensitive to any bugs. We ran into the exact 
> problem
> you are having. Our web team was suddenly very unpopular with the other
> developers. Any bug and the whole app would crash.
> 
> We no longer run any code on the web server process on 4D server. Instead we 
> run a
> client application that acts as a web server. This works pretty well.
> 
> The code that gets traced is the code on the machine that handled the 
> request. So if
> you make the request to your web server client application it will trace 
> there. The web
> server on client can run on the same physical server as your 4D server so 
> long as
> they aren't both handling requests on the same port.
> 
> The biggest hurdle we had was getting the correct 4D licensing. There was a 
> special
> license to make the client run the web server. This may be made more difficult
> because we are an OEM.
> 
> Joshua Hunter
> jos...@dwdev.com
> (425)673-1974
> www.dwdev.com
> Dataworks Development, Inc.
> Providing secure and configurable data management solutions for research and 
> clinical
> labs since 1987.
> 
> 
> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Sannyasin
> Siddhanathaswami via 4D_Tech
> Sent: Thursday, April 6, 2017 2:14 PM
> To: 4D iNug Tech
> Cc: Sannyasin Siddhanathaswami
> Subject: 4D Server Crashes When Tracing Buggy Web Connection Code
> 
> Aloha,
> 
> If I trace On Web Connection code on 4D Server v15.3 Mac, and I goof and 
> reference
> an out of index array (I know I’m the first to ever do that), our server 
> crashes. It just
> quits to the Finder, no error message nothing. I view the trace via screen 
> sharing to
> the server machine.
> 
> This is disastrous when other people are using 4D!!
> 
> Have others run into this? What’s the best way to debug On Web Connection code
> without crashing the server?
> 
> Maybe starting the webserver on 4D client? But how does adding a “Trace" On 
> Web
> Connection code work? Won’t it still trace on the 4D Server?
> 
> Sannyasin Siddhanathaswami
> *
> *
> 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
> *
> *
> *
> *
> 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
> *
> *
**
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 Server Crashes When Tracing Buggy Web Connection Code

[Epperlein, Lutz (agendo) via 4D_Tech]

To refer to the original cause of the crash ...
Unfortunately the compiler doesn't find such problems (negative array index 
variable), this is a typical runtime problem. All what you can do is to write 
"defensive" code, e.g. checking the value of an index variable, using error 
handler, don't change the size of an array in a FOR loop whilst accessing of 
array elements using an index variable and so on. 
As others mentioned already ...

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: 4D unit testing framework

[Epperlein, Lutz (agendo) via 4D_Tech]

We use it with 4D V15.3, there aren't any serious problems with. Not tested 
with V16 yet.
We implemented some minor changes in the past, mostly cosmetically by the help 
of a trainee. We plan an overhaul of the component to adapt it better to our 
processes. Unfortunately the trainee isn't available to us anymore, so we 
haven't a schedule for doing it.
But so far, it works and it is open-sourced.

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

IMAP_Download and "Error with IMAP PARTIAL"

[Epperlein, Lutz (agendo) via 4D_Tech]

Hi,

I'm just investigating to solve an error while downloading an email using IMAP. 
But so far I'm stuck. 
After using the command "IMAP_Download" of the Internet Commands plugin I got 
an error with code 10099 and the description "Error with IMAP PARTIAL".

I'm not have any clue how to solve the problem, any ideas?

Regards
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: Methods, Components, Comments, and Tooltips

[Epperlein, Lutz (agendo) via 4D_Tech]

Hi Nigel,

basically I'm interested, we are following a similar approach. I should explain 
it a bit.

At first we use a modified version of the mentioned vc-framework component. It 
saves all changes in the code to text files immediately and keeps track of the 
timestamps of the changes in an external database. The text files can be 
committed to a source code versioning tool like svn, mercurial, git ...
This is the basic idea behind the vc-framework. 

We extended it a bit to allow reimporting of the exported code. So we are able 
to switch between branches and we can do team development without a development 
server and dev clients. All members of our team use single user instances of 
4D. The result of the development will be compiled into a built/merged server 
application. 
A very old version (V13 yet) with import code can be found on Github: 
https://github.com/elutz/vc-framework-v13

But there are some disadvantages of this approach, all based on the limitations 
of 4D's way to handle the code. 
At first, the comparison of the exported and the present code in the database 
is based only on timestamps, that is a bit fragile. Most of the time it works, 
but if problems are happening the solution is sometimes difficult and a bit 
time consuming (re-export and re-import of thousands of methods). 
Another problem is the reliability of the component since 4D V15. Very often 
the immediate export of the code doesn't work and you have to trigger it 
manually. If the developer forget this additional step, he will check in only a 
part of his new code.
Because of that we don't recommend to take it 1:1 regardless we are using it a 
quite long time. 
As a task we have to invest time to improve and adapt the component to make it 
more reliable again.

I hope, there were some interesting thoughts ...

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: Methods, Components, Comments, and Tooltips

[Epperlein, Lutz (agendo) via 4D_Tech]

> 1 - how does one get access to the 4D source code outside of 4D?  Is there a 
> magic
> command to get 4D to regurgitate its code into plain text?

METHOD GET CODE
Since V13
Than you can do what you want with the text. An example is the VC-Framework 
component by J. Fletcher: https://github.com/4D/vc-framework-v13


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: Methods, Components, Comments, and Tooltips

[Epperlein, Lutz (agendo) via 4D_Tech]

Kirk,

Interesting approach. And your remark about deleted methods rings a bell ...

> Something this won't catch that Josh's VC did is deleted methods...

Yes, the vc-framework handles deleted methods for export. It means if I delete 
a method in 4D the former exported text file with the code is deleted too. But 
in our extended version with import this is an issue. There is no way in 4D to 
delete a method via programming I'm aware of. So we have to use intense 
communication, say I have to tell my colleagues there is an deleted method 
please delete it too. A check-out of the repository isn't enough.

**
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: Methods, Components, Comments, and Tooltips

[Epperlein, Lutz (agendo) via 4D_Tech]

> Do your apps use 4D forms? If so, how do you deal with them with respect to 
> version
> control?

No, our approach doesn't cover forms, it is usable only for methods like 
project methods, object methods, form methods, short: all methods editable in 
the method editor of 4D.
Since our application is a web app mainly, this isn't such a great problem, at 
least not for us.
**
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: IMAP_Download and "Error with IMAP PARTIAL"

[Epperlein, Lutz (agendo) via 4D_Tech]

Hi Armin,

many thanks for your code. I implemented it in our app and it works like a 
charm. 
But we do an upgrade of 4D the same time. And now, believe it or not, it works 
with the IMAP_Download command from the Internet Commands plugin too.

But that is not all of the story. There wasn't a 4D bug in the old version 
regarding mail download. Instead we detecting a serious bug in our code while 
implementing the workaround.
Look at this pseudo code:

For ($msgIndex;1;$msgCount)
  $error:=IMAP_Download
  If ($error=0)  
  IMAP_Delete // that's the culprit!
  end if
End For

This code works only in the case if there is a lonely mail in the mailbox. If 
there are several mails errors are arising beginning with the second mail  
no further comments.
So it's better to delete the mails after downloading all of it! Something like 
that:

For ($msgIndex;1;$msgCount)
  $error:=IMAP_Download
End For
If ($error=0)  
  IMAP_Delete 
End if

Regards
Lutz

> try this workaround. I thought this was a problem with v12 only, but it
> should work with newer versions too
**
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: v15 - html/help viewer documentation

[Epperlein, Lutz (agendo) via 4D_Tech]

Just read your posting and I thought, ahh, it's a good idea to download the 
language reference to have an offline access. But the download links are broken 
on http://doc.4d.com/4Dv15/4D/15.4/4D-Language-Reference.100-3273598.en.html:

Souce code:
Doc_HTML_multilang_4Dv15.zip (736,54 Mo)

No comment ...

Normally you get the html version in a zip archive this way.

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: Backup files - restoring backup

[Epperlein, Lutz (agendo) via 4D_Tech]

> I think the .bk files must be there somewhere - they just can't find them.

Maybe. Or they have only a (very large) journal file ...
Because the backup isn't configured, but the writing the journal file is 
active. 

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: sending mail with Exchange server

[Epperlein, Lutz (agendo) via 4D_Tech]

Hi,



you just opened the whole box of Pandora regarding email sending. In the last 
years more and more techniques are evolved to prevent spam, SPF, DKIM, DMARC to 
name a view. And if someone argue "it worked in the past for years" it is the 
best sign, there could be something wrong. We are not anymore in the past ...



But seriously, email sending is a complex thing. If someone gets the mail in 
the spam folder and someone not, it is as best a sign, that in the second case 
is something wrong with email configuration on the server side.

As an example, there is an interesting software called Discourse 
(http://www.discourse.org/) which heavily based on sending of emails. They give 
you interesting hints what to do to get the emails running. I quote it here:

Email deliverability is complicated. Here are a few important things you should 
check first:

·Be sure to set the notification email from: address correctly in your 
site settings. The domain specified in the "from" address of the emails you 
send is the domain your email will be validated against.

·Know how to view the raw source of the email in your mail client, so 
you can examine email headers for important clues. in Gmail, it is the "show 
original" option in the drop-down menu at the top right of each mail.

·IMPORTANT: Does your ISP have a reverse DNS record entered to 
associate the domain names and IP addresses you send mail from? Test your 
Reverse PTR record here. If your ISP 
does not enter the proper reverse DNS pointer record, it's very unlikely any of 
your email will be delivered.

·Is your domain's SPF record 
correct? Test your SPF record here. 
Note that TXT is the correct official record type for SPF.

·Is your domain's DKIM record correct? This will 
significantly improve email deliverability. Test your DKIM 
record here.

·If you run your own mail server, check to make sure the IPs of your 
mail server are not on any email 
blacklists. Also verify that it 
is definitely sending a fully-qualified hostname that resolves in DNS in its 
HELO message. If not, this will cause your email to be rejected by many mail 
services.

·We highly recommend you send a test email to 
mail-tester.com to verify that all the above is 
working correctly.

I recommend mail-tester.com too. It helps really and gives you exact steps to 
solve problems. The most problem are to solved on the sender’s side.



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: Bug or feature?

[Epperlein, Lutz (agendo) via 4D_Tech]

> Most programming environments have a way to deal with runtime errors. Many
> good ones have constructs like try/catch/throw. 4D really needs something
> like this.

I second this too, it would be much better than the present state.
But regarding the discussion about runtime errors, pl4ease read this short 
article about Java's RunTimeException (a more or less official statement in the 
docs of Java):


I quote from there:
> Here's the bottom line guideline: If a client can reasonably be expected to 
> recover 
> from an exception, make it a checked exception. If a client cannot do 
> anything to 
> recover from the exception, make it an unchecked exception.

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

JSON/objects and two-dimensional arrays

[Epperlein, Lutz (agendo) via 4D_Tech]

> JSON Validate, Collections and a NULL command!
> 
> http://blog.4d.com/en-whats-new-in-4d-v16-r4/

Nice improvements.
Unfortunately they didn't remove the limitation of the OB SET ARRAY command 
regarding the support of two-dimensional arrays. At least the docs say:

> Note: It is not possible to use two-dimensional arrays.

Because of that I posted a new feature request on the forum. If you like, 
please vote for it:
http://forums.4d.com/Post//19953344/1/

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: Wiki software: Confluence

[Epperlein, Lutz (agendo) via 4D_Tech]

> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Jeffrey Kain 
> via
> 
> Jira sucks.

That's a statement, it would be interesting to know why do you think so?
Or are you convinced the TAOW (https://taow.4d.com/Home/home.en.html) by 4D is 
better? (To throw in a complete different system) :-)

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: PHP Execute

[Epperlein, Lutz (agendo) via 4D_Tech]

> (please say yes)

Yes!

What's the reason of the question? Or, why do you think PHP and 4D don't work 
in a compiled environment?

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: 2dim json arrays with scalar values

[Epperlein, Lutz (agendo) via 4D_Tech]

Sounds good, how is it with the other way around?
Say, I have a 2dim longint array and would like to stringify it to json.

Pseudo code ( I don't know (yet) the API of the NTK plugin):


ARRAY LONGINT($values;1;1)
$values{1}{1}:=4711

JSON Set Array($object;”values”;$values)
$resultText:=JSON to Text($object)


The result should be:
{ "values": [
[ 4711 ]
] }

Is this possible too?

Thanks in advance
Lutz Epperlein


> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Rob Laveaux
> via 4D_Tech
> Sent: Thursday, July 27, 2017 2:35 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Rob Laveaux <rob.lave...@pluggers.nl>
> Subject: Re: 2dim json arrays with scalar values
> 
> 
> > On 27 Jul 2017, at 14:09, Epperlein, Lutz (agendo) via 4D_Tech
> <4d_tech@lists.4d.com> wrote:
> >
> > Is there any way to get the wanted result?
> 
> 
> Hi Lutz,
> 
> Yes, there is. Use the JSON commands from NTK Plugin.
> 
> Here is some example code:
> 
> $object:=JSON Parse Text($json)
> If ($object#0)
>   $array1:=JSON Get Array($object;”values”)
>   $count1:=JSON Count Items($array1)
>   For($i;1;$count1)
>   $array2:=JSON Get Array($array1;String($i))
>   $count2:=JSON Count Items($array2)
>   For($j;1;$count2)
>   $value:=JSON Get Number($array2;String($j))
>   End for
>   End for
>   JSON Release($object)
> End if
> 
> HTH,
> 
> - Rob Laveaux
> 
> 
> Pluggers Software
> Scholekstersingel 48
> 2496 MP  Den Haag
> The Netherlands
> 
> Email: rob.lave...@pluggers.nl <mailto:rob.lave...@pluggers.nl>
> Website: http://www.pluggers.nl <http://www.pluggers.nl/>
> 
> 
> 
> 
> 
> **
> 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
> **
**
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
**

2dim json arrays with scalar values

[Epperlein, Lutz (agendo) via 4D_Tech]

Hi,

Maybe it is related to the recent discussion pro and contra the quality of 4D's 
JSON implementation. I think I found a serious problem, a real limitation of 
4D's JSON.

4D's JSON resp. object implementation is able to handle arrays, so far, so 
good. But even the doc states that it doesn't work with 2dim arrays:
http://doc.4d.com/4Dv15/4D/15.4/OB-SET-ARRAY.301-3274736.en.html
> Note: It is not possible to use two-dimensional arrays.

Now we have got a requirement to fulfill a certain API to deliver exactly such 
arrays in a JSON structure. The result as JSON should be something like this:

{"values": [
  [0, 5606],
  [1, 5956],
  [2, 6228],
  [3, 6668]
]}

We have already a complex object structure where this values property is only a 
part of. Is there any way to get the wanted result? Or is 4D the wrong tool for 
this?

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: 2dim json arrays with scalar values

[Epperlein, Lutz (agendo) via 4D_Tech]

> The result should be:
> { "values": [
> [ 4711 ]
> ] }
> 
> Is this possible too?

OK, found it. It is possible. (To be honest, I didn't expect anything else)

The only question is now, how do I combine the code developed using 4D's object 
commands with the NTK JSON API?
E.g., I have a C_OBJECT variable $c_object. 
Is this possible:
JSON Set Object ($ntkObject;"chart";$c_object)

I assume the other way, setting a NTK object to a 4D C_OBJECT isn't possible, 
is it?

Remains the third way, rewriting all the code to the NTK API ...

Regards
Lutz

P.S: OK, there is a fourth way, don't use 4D for this, but this leads to 
complete rewrite.


**
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 and Git Connection

[Epperlein, Lutz (agendo) via 4D_Tech]

We use this component daily:
https://github.com/elutz/vc-framework-v15

After export, which happens instantaneously, the changes are committed into a 
Mercurial VCS. We do the check in manually, but it would be possible to define 
hooks to do an automatic check in. All is explained on the github page. The 
component is based on the work of Josh Fletcher, who developed it for V13 and 
extended it for V 14.

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: Getting back to interpreted mode

[Epperlein, Lutz (agendo) via 4D_Tech]

Start 4D, use the Open File dialog (Ctrl-O on Windows), choose your .4DB file 
and select the option "Interpreted application" of the Open button of the file 
dialog.

HTH
Lutz

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Doug 
> Cottrill via
> 4D_Tech
> Sent: Wednesday, August 23, 2017 1:57 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Doug Cottrill 
> Subject: Getting back to interpreted mode
> 
> Hi all,
> 
> I’m in v15.3 on Windows 10.  I just set my structure to run compiled to do 
> some
> testing, but now I can’t get it back into interpreted mode.  I have a menu bar
> command to take me back to User Mode, but in THIS structure, it does not 
> switch the
> menu bar to give the run menu with the “Restart Interpreted” option.  So, any 
> ideas
> on what to do?  I’d rather not go back to a backup version.  Thanks!
> 
> DKC
> 
> 
> --
> Doug Cottrill
> PTM Software
> 
> **
> 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
> **
**
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: SMTP error 10113 Error with Authentication

[Epperlein, Lutz (agendo) via 4D_Tech]

Try 4DIC Plugin 15.0

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of David
> Ringsmuth via 4D_Tech
> Sent: Wednesday, May 10, 2017 5:41 PM
> To: Timothy Penner via 4D_Tech <4d_tech@lists.4d.com>
> Cc: davidi...@gmail.com
> Subject: SMTP error 10113 Error with Authentication
> 
> OSX 10.12.3
> 4D 15.3HF1
> 4D Server
> Compiled
> 4DIC Plugin 15.3
> 
> Also tested with:
> 15.4 (211153) with 4DIC plugin 15.4, Compiled
**
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: Migrating OS X server to Windows Server

[Epperlein, Lutz (agendo) via 4D_Tech]

My 2 cents:
http://kb.4d.com/assetid=77769

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 crashes compiled and freezes

[Epperlein, Lutz (agendo) via 4D_Tech]

My first favorite cause of crashing compiled databases is a negative array 
index. That's very reliable, hard to find.
The best way to avoid such problems is to code defensively while handling 
arrays.

Good luck
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: Preemptive mode flaw

[Epperlein, Lutz (agendo) via 4D_Tech]

http://doc.4d.com/4Dv16R2/4D/16-R2.1620/Preemptive-4D-processes.300-3111846.en.html

look at "Availability of preemptive mode"

The use of preemptive mode is available in 4D 64-bit versions only. The 
following execution contexts are currently supported:
Preemptive execution
4D Server   X
4D remote   -
4D single-user  X
Compiled mode   X
Interpreted mode-



> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Jeffrey Kain 
> via
> 4D_Tech
> Sent: Monday, May 8, 2017 2:47 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Jeffrey Kain 
> Subject: Re: Preemptive mode flaw
> 
> Is it still the case that client/server applications are excluded from 
> running preemptive
> 4D code?
> 
> --
> Jeffrey Kain
> jeffrey.k...@gmail.com
**
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: Check if DOM element has attribute

[Epperlein, Lutz (agendo) via 4D_Tech]

I don't think so.

But you can build your own implementation using 
- DOM Count XML attributes
- DOM GET XML ATTRIBUTE BY INDEX

Or
- DOM GET XML ATTRIBUTE BY NAME in conjunction with an error handler

HTH
Lutz Epperlein


> Is there a 4D equivalent of: DOMElement::hasAttributeNS — Checks to see if
> attribute exists
**
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: Configure SSL Web Server on 4Dv15

[Epperlein, Lutz (agendo) via 4D_Tech]

Hi Andrea

Look here: http://forums.4d.com/Post/DE/17153654/1/17153655#17153779 (in 
German, but you can translate it in a good quality with 
https://www.deepl.com/translator). Here is it done for you:

---
The certificates must be in "pem" format, see:
http://doc.4d.com/4Dv16/4D/16.2/Using-TLS-Protocol.300-3434024.en.html

key. pem (document with the private encryption key) and cert. pem (document 
with the certificate):
in 4D in local mode or 4D Server, these files must be located next to the 
application's structure file,
in 4D in remote mode, these files must be located in the 4D application's Local 
Resources folder on the remote computer. For more information, see the 4D 
Client Database Folder section. Note that you must manually copy these files to 
the remote computer.

You must either request the certificate as a pem from the IT department - or 
convert it yourself.
Google search for "crt to pem".
This is usually done via OpenSSL. With chain certificates this is even more 
complicated, they have to be connected.
---

For chaining look here: 
https://www.digicert.com/ssl-support/pem-ssl-creation.htm
The order is significant!

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: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

RE: 4D Write Pro - WP EXPORT DOCUMENT to WORD?

[Epperlein, Lutz (agendo) via 4D_Tech]

+1 for exporting 4D Write Pro documents to MS Word (aka Office Open XML 
format). Maybe this could be worth feature request?
Here it is: http://forums.4d.com/Post//20813501/1/
Please vote for it.

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: What to do about users who won't follow instructions?

[Epperlein, Lutz (agendo) via 4D_Tech]

Did you read this: http://www.clarify-it.com/blog/the-future-of-clarify: The 
Future (or Lack Thereof) of Clarify and Clarify-it.com

Regards
Lutz

> 
> For short documentation/training, I use Clarify:
> 
> http://www.clarify-it.com/learn 
> 
> It is on Mac & Windows.
> 
> Great product with good training.
**
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

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

RE: QUERY BY ATTRIBUTE is slow af

[Epperlein, Lutz (agendo) via 4D_Tech]

Since the feature of object fields is very near the concept of NoSQL databases 
like MongoDB and so on (at least it is partly stolen from their) ... 
I think the following article by Sarah Mei summarizes the discussion in the 
this thread in a way: 
http://www.sarahmei.com/blog/2013/11/11/why-you-should-never-use-mongodb/

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: QUERY BY ATTRIBUTE is slow af

[Epperlein, Lutz (agendo) via 4D_Tech]

Maybe there is an issue with @ character in the search string ...
I've no idea how to circumvent it.

HTH
Regards
Lutz

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Jeffrey Kain 
> via
> 4D_Tech
> Sent: Tuesday, September 12, 2017 5:23 PM
> To: 4d_tech@lists.4d.com
> Cc: Jeffrey Kain 
> Subject: QUERY BY ATTRIBUTE is slow af
> 
> Trying to figure out why our experience with QUERY BY ATTRIBUTE is so 
> different than
> the demos at the last 4D Summit.
> 
> We're running 4D Server 16.2 64-bit on Windows. The Invoices table has about 9
> million rows, and we added an index to the Extra field in this table which is 
> an object
> field.
> 
> The following query always runs sequentially - i.e. very very slowly. 
> Thinking it might be
> a wildcard issue with the email we also tried strings with no '@', but no 
> matter what we
> do the query runs sequentially.
> 
> QUERY BY ATTRIBUTE \
>   ([Invoices];\
>[Invoices]Extra;\
>"gift_card_line_items[].to_email";=;"desig...@sweetwater.com")
> 
> 
> What are we doing wrong here? The query returns one row, 20 minutes later.
> *
> *
> 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
> *
> *
**
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: NGINX Config

[Epperlein, Lutz (agendo) via 4D_Tech]

SSL certificates are tied to a domain, not to physical computer. A client 
(browser) is not able to resolve to a physical machine. And this is a good 
thing! I can't imagine what will happen if clients would get information of our 
physicals machines even it would be the MAC address only.

The browser is able to check the domain the responses come from.

Regards
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 Doug Hall via
> 4D_Tech
> Sent: Monday, October 2, 2017 5:31 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Doug Hall 
> Subject: Re: NGINX Config
> 
> RE: Note if you enable 443 and ssl for any server you must have a cert for
> all
> servers listening on 443 you cant mix them up.
> 
> We only have the one physical server (running 4D in remote mode). You
> aren't talking about the different domains being served from that one
> machine are you? SSL certificates are tied to the physical server
> (computer), not nginx server block/domain name, right?
> 
> Thanks,
> Doug
**
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: Making LOG EVENT thread-safe

[Epperlein, Lutz (agendo) via 4D_Tech]

I asked because we use a little own implementation of writing log files. This 
is all before V16. We use semaphores to avoid race conditions while writing to 
the file. 
And one of our first projects after updating to V16 should be the rewriting of 
this code using workers. So I'm a bit disappointed to hear that.

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: Making LOG EVENT thread-safe

[Epperlein, Lutz (agendo) via 4D_Tech]

A question:
What other approaches did you try to implement a logging feature using 
preemptive threads. I'm pretty sure there is something buried in the threads of 
this mailinglist but I'm not able to find it.

Thanks
Lutz Epperlein

> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of David Adams 
> via
> 4D_Tech
> I finally got around to checking, and LOG EVENT is not a thread-safe
> command. Pity! It would be very handy if this command were usable from a
> preemptive process as it would give us a great way to stream log data out
> to the system for collection by an "agentless" (cough-cough) tool like
> Loggly.
**
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

[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

[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

[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.

[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: Server Process "Frozen"-ish

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

RE: POP3 Email Processing

[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: 4D v16 Server and Windows Server 2016

[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: Query for null/empty UUID

[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 Server as a Service

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

[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: Who’s the Gestapo?

[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: Server Monitoring...

[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: Storage — Server vs Client

[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: Storage — Server vs Client

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

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

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

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

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

RE: Signed emails to the list?

[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) 
> 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: Signed emails to the list?

[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: v13+ LEP - What is sent to OS

[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: v13+ LEP - What is sent to OS

[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: Detection of 4D running in a VM

[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: Web Service Call in 4Dv15

[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: Signed emails to the list?

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

RE: v13 -Automatically repaired method

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

AW: Collections

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

RE: Leaving the .4DB behind??

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

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

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

[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: SOAP over HTTPS

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

RE: Using 4D with Git...

[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: Backing up a VM - is it dangerous ?

[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...?

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

AW: SOAP over HTTPS

[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: what to do when I don't want back button funtionality in a browser of pages from 4d

[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: 4Dv15 applications as a Service in Windows Server 2012

[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: button picture problems in v16 and v17

[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: Excel copy error while 4D is running (Windows)

[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: Excel copy error while 4D is running (Windows)

[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: v13 - Exporting tab delimited

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

[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: 4D Structure Export...

[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: Unusual crash / failure to start 4D

[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: 4D Structure Export...

[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: 4D and Subversion

[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: PDF generation on Windows - Latest Thinking

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

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

[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: Creating Word docs in 4D

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

[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: Auto Updating 4D Not Working

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

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

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

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

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

[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: 4D Web Log Out

[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?

[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: 4D Web Log Out

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

[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

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