RE: LEP that will quit Chrome?

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/

RE: LEP that will quit Chrome?

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

RE: 4D Web Log Out

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 so

RE: Securing sensitive data in a 4D data file (Chip Scheide)

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:\Curr

RE: Auto Updating 4D Not Working

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 adjus

RE: Creating Word docs in 4D

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 Au

RE: Best scripting language to use with LEP (docx to PDF)

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

RE: Best scripting language to use with LEP (docx to PDF)

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 want

RE: Best scripting language to use with LEP (docx to PDF)

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

RE: Best scripting language to use with LEP (docx to PDF)

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 sh

RE: Benchmark Speed Test Method

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

RE: LEP - hide console?

SET ENVIRONMENT VARIABLE("_4D_OPTION_HIDE_CONSOLE";"true") And see: https://doc.4d.com/4Dv17/4D/17.1/LAUNCH-EXTERNAL-PROCESS.301-4178683.en.html 9. To launch a command with the current directory and without displaying the console: SET ENVIRONMENT VARIABLE("_4D_OPTION_CURRENT_DIRECTORY";"C:\\4D

RE: Double Clickable app where should plugins be?

I would use these commands to detect which plugins and components are available: COMPONENT LIST PLUGIN LIST These are the plugins and components loaded by 4D. So they are working. It's not only a list of a folder's content. Just my 2 cents Regards Lutz ***

RE: 4D Security White Paper

There is something like that: https://blog.4d.com/4d-security-guide/ I don't know if that gives you the information you need. Regarding encryption there is something in v17R5: https://blog.4d.com/get-started-with-encryption-in-4d/ Regards Lutz > Does anyone know if 4D have published any white p

RE: Managing 4D Server as a service

We use Windows Services all the time with success. But we have to launch the server application from time to time as a desktop application as John said, but it is pretty rare. Nearly all errors we try to catch and write the messages to a log file. But there are situations where this isn't possib

RE: Managing 4D Server as a service

Ahh, there are at least two feature requests, meaning more or less the same: - https://forums.4d.com/Post/EN/19227573/1/19227655 - https://forums.4d.com/Post/EN/17994245/1/17994246 Therefor: double voting! Lutz -- Lutz Epperlein -- Agendo Gesellsc

RE: V17R3 vs PowerShell

Hi, we use Powershell a lot, even in conjunction with 4D. But we never divide between 32bit and 46bit-Powershell. Since you use the Powershell via LAUNCH EXTERNEL PROCESS (LEP) the architecture (bitness) of the Powershell binary shouldn't matter. And a question: Regarding your script how do you

RE: Dot Notation in Legacy 4D Code

If you deal with variables you can use "Rename..." in the context menu of the method editor too. Regards Lutz ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/

RE: What is wrong with this statement?

If $Return_ptr and $Column1 are pointers, you have to dereference them: $Result:= $Column1->{ $Return_ptr->{$Item} } For better clarity I would extract $Return_ptr->{$Item} $index_col:= $Return_ptr->{$Item} $Result:= $Column1->{ $index_col } HTH Regards Lutz ***

AW: Query by Formula Join vs. Comparison

Put the contents of the field you want to compare to in a variable, then use the variable instead of the field in the query. HTH Regards Lutz -Ursprüngliche Nachricht- Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Jim Medlen via 4D_Tech Gesendet: Mittwoch, 24. Juli

AW: can't load internal 4D component

Hi David, a question regarding this compatibility mode: Did you try it with 4D v17R5 too? In your first posting you only mentioned v17R4. The Software requirements document (https://download.4d.com/Documents/Products_Documentation/LastVersions/Line_17R5/VIntl/4D_v17_R5_SystemRequirements_EN.pdf

AW: How to decode this text

Look here for further explanation: https://en.wikipedia.org/wiki/MIME#Encoded-Word Regards Lutz -Ursprüngliche Nachricht- Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Chip Scheide via 4D_Tech Gesendet: Dienstag, 30. Juli 2019 22:52 Betreff: Re: How to decode this te

AW: 4Dv15 app on Windows Service

That should be sufficient regarding rights. The question is which resource the server should access. If you run the service under the default system account, you could get problems accessing certain network resources, printer ... But I think this a known circumstance. Did you check the Windows e

AW: v13 or v15 Pic Library usage

How is it with this: http://association-qualisoft.eu/qs_toolbox/ Regards Lutz -Ursprüngliche Nachricht- do you have a link ? Thanks! > Hi Chip > > you can use QS_Toolbox. There is a tool which list you the objects > using pictures. > - > Patrick EMANUEL > ---

AW: Folder equivalent for: "SET DOCUMENT PROPERTIES"

For Windows: Don't use the old cmd, use powershell instead. For an example solution for your task see https://stackoverflow.com/a/24992975/1865659 HTH Regards Lutz Epperlein -Ursprüngliche Nachricht- Betreff: Re: Folder equivalent for: "SET DOCUMENT PROPERTIES" Narinder, Thanks for y

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

Use the so-called "Web decoy" technique. Basically you put your html files in another folder outside your html root. Then redirect all requests using ON WEB CONNECTION. For every http request 4D cannot serve directly, it uses ON WEB CONNECTION. This is more elaborated e.g. here: How to skip ov

AW: Error signing built app for Catalina

Maybe this: https://blog.4d.com/?s=notarization Regards Lutz Epperlein -Ursprüngliche Nachricht- Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Jeremy Roussak via 4D_Tech Gesendet: Donnerstag, 24. Oktober 2019 21:14 An: 4D iNug Technical <4d_tech@lists.4D.com> Cc: Jer

AW: 4D Web Application and SAML or OpenID Connect

Hi, we do something in this area. We use an Apache webserver in front of the 4D web server as a reverse proxy or gateway. There is an Apache module called mod_auth_openidc (https://github.com/zmartzone/mod_auth_openidc) which is configured to use an external identity provider (IP). In our case

AW: 4D Web Server Security

To be a bit illustrative ... From time to time we have to undergo security audits of our web application. The last time the IT security consultant, who made the audit, said he never found an application which so few security issues, because there weren’t any. Mostly they find some issues. -

AW: 4D Web Server Security

It depends ... If the customer wants to run the application on their own (virtual) hardware then port 80 and/or 443 is used. But this run configuration isn't in the focus of the audits. In all other cases, application is accessible over the internet, we use an Apache web server in front. But th

AW: 4D Web Server Security

Steve, we don't do any load balancing, so I'm afraid I can't contribute anything. But that's an interesting area. Regards Lutz -Ursprüngliche Nachricht- Betreff: RE: 4D Web Server Security Lutz, Perfect, this is the information I was looking for. In the Apache example, when you say y

AW: Constants in code.

You have to use xliff and you can find an example here: https://kb.4d.com/assetid=76583 Regards Lutz -Ursprüngliche Nachricht- Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Eric Naujock via 4D_Tech Betreff: Constants in code. Good morning, This seem pretty ru

AW: Can't Define DEP Exception On Windows

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

AW: HTTP Upload file size too low

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

Re: HTTP Upload file size too low

I did a short test with chunked uploads, that's not really a problem. We use a jquery widget (https://blueimp.github.io/jQuery-File-Upload/) on the frontend (the website) for file upload. It's easy to start chunked uploads. You have to handle it on the server side. One solution could be to save

AW: FLUSH BUFFER

Please use 0 as the value of the stack size. In most circumstances it is the best idea to leave the memory management to 4D. There was recently a thread about this topic on this mailing list or the forums. I can't find it just now. Regards Lutz -Ursprüngliche Nachricht- Von: 4D_Tech [ma

Re: HTTP Upload file size too low

I'm not sure if I understand your environment in which you would do that file upload. As I mentioned before, I did some little testing with chunked uploads using a web browser as a client and there a javascript library. At the server side I use WEB GET BODY PART in conjunction with WEB Get body

AW: Document encoding

I think you should first think about what encoding means, in general file encoding means the encoding of text files. If you use your code below with pdf files you destroy the pdf in a very reliable way, since pdf files are binary files. The same is with nearly all picture formats (and with Word

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

See also this thread on the forums: The idea is to get generic forms is using generic built listboxes or similar. And there already such components available, e.g. by Th. Maul called AutoForms. Regards Lutz ***

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

It's in the R-release channel > Beta version forum. The subject of the post is "Form wizard / assistant". Maybe you have to be a partner to access this forum, I don't know. Regards Lutz -Ursprüngliche Nachricht- Betreff: Re: 4D v18.0 LTS - Form Wizard Missing Hallo, can´t open the Link

AW: HMAC SHA256 in native 4D code?

Regarding JWT (JSON Web Token), there is another plugin by Miyako: https://github.com/miyako/4d-plugin-jwt Lutz Epperlein -Ursprüngliche Nachricht- Betreff: Re: HMAC SHA256 in native 4D code? Hi, I had to spend some time looking into this recently myself. You have two options: 1 - K.

AW: 4D v13 web service error: -9926

It may related to the XML content of your SOAP request or of response. Did you check that? Maybe you want to access some not existing elements. 9926 means -9926 The referenced element is invalid. https://doc.4d.com/4Dv17/4D/17.4/Database-Engine-Errors-10602-4004.300-4882076.en.html So it could

AW: CREATE DOCUMENT erors

Do you use an error handler with ON ERR CALL? I've just tested it and I get an error -120 Tried to access a file by using a pathname that specifies a non-existing directory. Or -54 Attempt to open locked file for writing. Maybe your error from the error stack comes from an older one in this proc

Decode Kerberos ticket for web authentification

Hi, Are there ways to decode a Kerberos ticket using 4D? Background: We have to implement a SSO login mechanism for web users using Kerberos authentication. The authorization within a web server (IIS) in front of the 4D server works so far. We get a http request containing a header line “Author

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

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

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

The old 4D forum is now accessible in read-only mode at the old location. And most of the old forum posts have been migrated to the new forum. Which posts were transferred is described here: https://discuss.4d.com/uploads/short-url/6GUCGwxhG3VLP7zWpUntMDe9u5x.pdf to be found at https://discuss.4

AW: PDF to Jpeg

That's a rather strange task, I just imagine I would get the 28-page-PDF in front of me as a jpeg. Anyway, I would investigate some research in using the ImageMagick command "convert". There are a plenty of options for conversion from almost any format to almost any other format. And then start

AW: IP address problem

Hi Chip, That's a very good answer. Are you able to post this on the new forum? Chuck posted the same question there. You can find it here: https://discuss.4d.com/t/ip-adress-issue-on-server/14033?u=epperlein.lutz Regards Lutz -Ursprüngliche Nachricht- Von: 4D_Tech [mailto:4d_tech-boun..

<    1   2