Re: Options To Put Data Into Existing Excel Spreadsheets?

2018-05-08 Thread Douglas Cryer via 4D_Tech
Allan, Until recently we were using Keisuke's component. Clients were asking for more, in particular images so we looked around and found the Pluggers Plugin. Yes it does mean going from a free option to a paid option but equally it is like going from a 2CV to a Ferrari. It does much more, f

Re: HTTPS Connection for Web Module

2018-05-08 Thread Douglas Cryer via 4D_Tech
Ronnie, As painful as it may seem I would second the comment made by Dani: > I would consider putting Apache or NGINX in front of your 4D v11 application > and configure Apache/NGINX as a reverse proxy to your 4D app. > There has > been messages on the nug that can tell you how to do that. I

Re: Options To Put Data Into Existing Excel Spreadsheets?

2018-05-08 Thread Arnaud de Montard via 4D_Tech
> Le 8 mai 2018 à 09:14, Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com> a > écrit : > > 2CV to a Ferrari What's the difference? -- Arnaud de Montard ***

Google Authenticator Integration

2018-05-08 Thread Douglas Cryer via 4D_Tech
Hi folks, In my quest for building better security solutions I am currently looking at implementing 2FA specifically Google Authenticator Two Factor Authentication. Has anyone done this with 4D code and is willing to share an example? Seems like the building blocks are there: QR Code generation

OPEN FORM WINDOWS

2018-05-08 Thread stardata.info via 4D_Tech
Hi All, I work 4D V16 on windows. Using this code in one button of output form for doing a queries: $Win:=Open form window("form";Palette form window;Horizontally centered;Vertically centered;*) DIALOG("form") CLOSE WINDOW i notice that the selection of the records are not upgraded in the outp

Re: Google Authenticator Integration

2018-05-08 Thread Chip Scheide via 4D_Tech
personally, I do not believe anything from Google can be considered to be 'secure'... YMMV I would try a different 2FA app. My Wife's employer uses something called Duo On Tue, 08 May 2018 12:21:41 +0100, Douglas Cryer via 4D_Tech wrote: > Hi folks, > > In my quest for building better securi

Re: v13+ - method comments (the Explorer Pane)

2018-05-08 Thread Chip Scheide via 4D_Tech
Dani, Wayne, Thanks On Mon, 07 May 2018 21:59:39 +, Wayne Stewart via 4D_Tech wrote: > Chip, > > I wrote some code to do that for Foundation it relies on some discipline in > creating your header comments of course. > > > // > // Projec

Re: SSL cipher list

2018-05-08 Thread Douglas Cryer via 4D_Tech
Jim and Mike, Thank you for your inputs on this. The resource: https://mozilla.github.io/server-side-tls/ssl-config-generator/ was very helpful in creating a cipher list that 4D would accept and which got rid of all the insecure options. With regards: I would guess its a syntax issue with

Re: SPAM-LOW: Re: Google Authenticator Integration

2018-05-08 Thread Douglas Cryer via 4D_Tech
Chip, Thank you for the input. I am trying to build to what people expect. My target market in this instance is trading exchange users crypto exchanges in particular. In this market 2FA is used extensively as a secondary or tertiary security level. As example Binance but may others use 2FA

Re: HTTPS Connection for Web Module

2018-05-08 Thread Tom DeMeo via 4D_Tech
Hi, One of the main reasons to use 4D to publish on the web is the efficient simplicity of the architecture. There may be circumstances where putting another web server such as Apache in front is worth the trouble, but all too often, its done for no good reason. Getting the correct files for

Re: Google Authenticator Integration

2018-05-08 Thread Douglas Cryer via 4D_Tech
Chip, Thank you for the input. I am trying to build to what people expect. My target market in this instance is trading exchange users crypto exchanges in particular. In this market 2FA is used extensively as a secondary or tertiary security level. As example Binance but may others use 2FA

Standalone application connection to 4D Server

2018-05-08 Thread David Loeppky via 4D_Tech
I have a standalone 4D application that needs to occasionally connect to our 4D Server to exchange some data. Realizing there are a few different architecture approaches to take, I'd appreciate some advice as to the easiest way to approach this. Thanks. -- Regards, David Loeppky Co-Owner T:

Re: Standalone application connection to 4D Server

2018-05-08 Thread Charles Miller via 4D_Tech
It all depends. How much data is exchanged? How automated do you need it to be? How often will you be doing this? Is data movement bi-directional? The most straightforward IMO is SQL, but you could also use SOAP, text(XML files), HTTPS Regards Chuck On Tue, May 8, 2018 at 10:48 AM, David Loeppk

RE: Options To Put Data Into Existing Excel Spreadsheets?

2018-05-08 Thread Randy Engle via 4D_Tech
Another "plug" for Pluggers XCEL plugin. We use it exclusively. Full control of the spreadsheet. Randy Engle, Director XC2 Software LLC – XC2LIVE! -Original Message- From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Douglas Cryer via 4D_Tech Sent: Tuesday, May 8, 2018 12:15 AM To

Re: Standalone application connection to 4D Server

2018-05-08 Thread Kirk Brooks via 4D_Tech
David, What version of 4D are you using? If it's v15+, with respect to Chuck's suggestion, I'd use HTTPS for the data transfers and JSON/c-objects. It's pretty easy to write an API on the server side to manage such a request and shuffle the data between the two endpoints. JSON is a lot easier to wo

Re: Standalone application connection to 4D Server

2018-05-08 Thread Milan Adamov via 4D_Tech
> On May 8, 2018, at 4:48 PM, David Loeppky via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > I have a standalone 4D application that needs to occasionally connect to > our 4D Server to exchange some data. Realizing there are a few different > architecture approaches to take, I'd appreciate some

Re: OPEN FORM WINDOWS

2018-05-08 Thread stardata.info via 4D_Tech
Hi Kristopher, Below my answers. Thanks Ferdinando Il 08/05/2018 17:46, Kristopher Merolla ha scritto: Hi Ferdinando, In 16.3 HF2 I put together a simple case, making a custom output form for a table with two buttons. One button runs your first block of code to open a Palette window and t

Re: Standalone application connection to 4D Server

2018-05-08 Thread Charles Miller via 4D_Tech
If you use SQL there is no additional licensing needed. The other SOAP or HTTPS means another license either for soap server or web server on the 4d server Regards Chuck On Tue, May 8, 2018 at 11:53 AM, Kirk Brooks via 4D_Tech < 4d_tech@lists.4d.com> wrote: > David, > What version of 4D are you

Re: Standalone application connection to 4D Server

2018-05-08 Thread Kirk Brooks via 4D_Tech
Chuck, Good point. I assumed he already has a web license but if that's not the case you are correct. On Tue, May 8, 2018 at 9:25 AM Charles Miller via 4D_Tech < 4d_tech@lists.4d.com> wrote: > If you use SQL there is no additional licensing needed. The other SOAP or > HTTPS means another license

Error -19191 ?

2018-05-08 Thread Bob Miller via 4D_Tech
Hi Everyone, I have a 4D Client user (v15r5, Windows) who can't connect, with error -19191. I can't find this error in either the language ref, the server reference, or the design ref. Does anyone have an idea of what this error is? Thanks, Bob Miller Parker Hannifin Corp. l

Re: Error -19191 ?

2018-05-08 Thread Spencer Hinsdale via 4D_Tech
It is old client cannot update via new network layer... http://kb.4d.com/assetid=77427 > On May 8, 2018, at 9:53 AM, Bob Miller via 4D_Tech <4d_tech@lists.4d.com> > wrote: > > Hi Everyone, > > I have a 4D Client user (v15r5, Windows) who can't connect, with err

Re: Standalone application connection to 4D Server

2018-05-08 Thread Wayne Stewart via 4D_Tech
Hi, Chipping in on the licensing question. What is the standalone? If it’s a sponsored 4D engine app then you are limited to two connections per day. If it’s SQL desktop app then you can connect whenever you want. I assume the same for the developer editions too. The oem desktop product could

Re: Options To Put Data Into Existing Excel Spreadsheets?

2018-05-08 Thread Wayne Stewart via 4D_Tech
2cv is faster than a Ferrari: https://goo.gl/images/2yZ2L9 On Wed, 9 May 2018 at 01:16, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> wrote: > Another "plug" for Pluggers XCEL plugin. > We use it exclusively. > Full control of the spreadsheet. > > Randy Engle, Director > XC2 Software LLC – XC2L