Re: View Pro - How to protect a sheet

[Scott Staley via 4D_Tech]

Doug,

Thanks for the advice.  I've used excel since it was created back in about
1984/85 but wasn't familiar with the underlying file structure of a current
excel file.  Just opened one with BBEdit.  A lot more to it than I thought. 
I'll see if I can figure out in the file structure where the protection info
is stored and see if I can do anything with it.  I would rather avoid a
separate plugin for this one issue.  View Pro is somewhat surprisingly
working very well for what I need.



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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 Application as a 3-tier System

[Neil Dennis via 4D_Tech]

As you already know a textbook three tier application would be web based…

HTML/Javascript/CSS - Front End
PHP/JS/ASP… many others - Middleware
MySQL, Oracle etc - Backend

The key points being:
Front end handles the presentation
Middle ware handles the business logic and application flow talks between the 
front end and any other resources needed
Backend a connection to permanent data usually through SQL

There is no reason that 4D couldn’t be used in all three, but it really doesn’t 
make sense…
Front End - 4D handling the presentation with screens (but no database nor 
tables) making calls to the middle layer… and accepting data and navigation 
from the middle layer (via REST or some other communication)
Middleware - Use 4D code to handle requests from the front end, validate data, 
handle the controller part (again no database nor tables)… make calls the 
backend (REST etc. or using v18 ORDA to make direct queries)
Backend - Use 4D structure with data but no code (expose with REST or ORDA)

A couple of possibilities maximizing 4D use:
Web Browser -> 4D middleware server -> 4D backend
Web Browser -> 4D Client -> 4D Server

Anyway in short I don’t know of a way to go three tier without a lot of work. 
And for a true 3 tier, web is a good way to do it.

Neil


> On Jan 27, 2020, at 8:48 PM, Tarawerkz via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi All,
> 
> I have an application running in a hospital environment for a number of years.
> In the light of the increasing awareness of data security, the client’s IT in 
> their own words are looking at "redoing the whole 4dcis database onto 2 or 3 
> tier system where there is a database separation from application layer”
> 
> The current setup is a v15 client-server application, with about 80 
> concurrent client licenses serving users located at 2 separate locations.
> 
> As it stands, a 4D application already has a 2-layer architecture being a 
> client-server application.  
> We could perhaps enhance it a little to make it a 2-tier environment by 
> moving the segregating the 4D Server software and the 4D structure files 
> (business logic) on to one server and the 4D data files (database) on to a 
> separate server.  Doing that however has no effect on the 4D database 
> architecture, it still remains a 2-layer database architecture.
> 
> Apart from re-developing the application into a complete web-based 
> application, how can a 4D application be refreshed into a 3-tier system?
> 
> I would like to tap on the collective wisdom of the forum to gather some 
> views on the plausibility of the above.
> Thank you.
> 
> 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
**

4D Application as a 3-tier System

[Tarawerkz via 4D_Tech]

Hi All,

I have an application running in a hospital environment for a number of years.
In the light of the increasing awareness of data security, the client’s IT in 
their own words are looking at "redoing the whole 4dcis database onto 2 or 3 
tier system where there is a database separation from application layer”

The current setup is a v15 client-server application, with about 80 concurrent 
client licenses serving users located at 2 separate locations.

As it stands, a 4D application already has a 2-layer architecture being a 
client-server application.  
We could perhaps enhance it a little to make it a 2-tier environment by moving 
the segregating the 4D Server software and the 4D structure files (business 
logic) on to one server and the 4D data files (database) on to a separate 
server.  Doing that however has no effect on the 4D database architecture, it 
still remains a 2-layer database architecture.

Apart from re-developing the application into a complete web-based application, 
how can a 4D application be refreshed into a 3-tier system?

I would like to tap on the collective wisdom of the forum to gather some views 
on the plausibility of the above.
Thank you.

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

Re: View Pro - How to protect a sheet

[Douglas von Roeder via 4D_Tech]

Scott:

The Excel plugin from Pluggers has a command *xlSheetSetProtected* which
you could use to update the workbook after it’s been created using 4D VP.

As an alternative, an Excel workbook is a handful of files bundled up in a
folder. You might be able to do a diff on a protected workbook vs one that
is not protected and then write some code to change the value. It most
likely that you can’t change the value to not-protected but you *might* be
able to get away with changing the value to protected.

--
Douglas von Roeder
949-910-4084


On Mon, Jan 27, 2020 at 4:52 PM Scott Staley via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> The subject pretty much says it all.  Anyone know how to tell View Pro to
> programmatically protect a sheet.
>
> fyi... I basically have an excel template that I import into View Pro and
> then populate with data and save it back as an excel file.  The excel file
> is then given to others that populate other parts of the sheet.  I would
> like to turn the sheet protection on so that the data populated by 4D and
> any other protected cells are not accidentally modified.  If I protect the
> sheet in excel, than I can't use 4D to populate the protected cells.  I
> generate several hundred files so I don't want to do it manually.
>
> I'm using 4D v17 R6
>
> Thanks in advance for any suggestions...
>
>
>
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 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
**

View Pro - How to protect a sheet

[Scott Staley via 4D_Tech]

The subject pretty much says it all.  Anyone know how to tell View Pro to
programmatically protect a sheet.

fyi... I basically have an excel template that I import into View Pro and
then populate with data and save it back as an excel file.  The excel file
is then given to others that populate other parts of the sheet.  I would
like to turn the sheet protection on so that the data populated by 4D and
any other protected cells are not accidentally modified.  If I protect the
sheet in excel, than I can't use 4D to populate the protected cells.  I
generate several hundred files so I don't want to do it manually.

I'm using 4D v17 R6

Thanks in advance for any suggestions...



--
Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
**
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: V18 and wakanda.

[Eric Naujock via 4D_Tech]

The good thing is I have discovered a new sit for documentation at 4D. While 
researching the 4D for IOS there is a new developer.4d.com 
 website with the REST documentation. It looks like 
there is a fair bit of documentation and stuff there to read.

> On Jan 24, 2020, at 9:55 AM, Eric Naujock via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Is anyone else using Wakanda with 4D server? If so what are you doing to 
> handle the change to 4d V18? I am seeing that it looks like the Wakanda 
> support for V18 is no longer listed but Im also not finding any docs in the 
> V18 section that discusses the REST interface for v18 server. Or how things 
> may be different with between the V17 and V18 implementation? 
> 
> Anyone out there with a strategy for going forward or is this all new 
> territory to be explored and struggled though?
> **
> 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
**

[ANN] AJUI_Button 1.3

[Maurice Inzirillo - AJAR via 4D_Tech]

  * * * AJUI_Button - Button widget for 4D * * * 

The new beautiful and powerful new release 4D V18 is now available and as 
promised we are ready !
  
We are proud to announce our new release of the 4D component AJUI_Button 1.3 
and it's Lab & HDI : AJUI_ButtonLab

What's new since version 1.3?
———

The component has been rewritten to be fully compliant with the new 4D V18 
Release (4DZ component)

It includes a new kind of buttons : the FAB (Floating Action Button). FAB's 
buttons are buttons floating above the user interface of a form. They act as 
call to action buttons, intended to represent a single action that users 
perform most on that particular form screen. Animation display is available 
when the secondary buttons are shown or hidden. Just beautiful !

AJUI_ButtonLab has been rewritten to be fully compatible with the new 4D V18 
version. It has been extended to handle the new functions of the FAB buttons. 
Eventually, we provide a new HDI for FAB buttons, which will provide you with a 
solid example for its implementation in your 4D applications.

Tip : when you override a default value of one property, this property is now 
in bold text which is consistent with the way 4D v18 handle the value in the 4D 
Form Property list 
(https://blog.4d.com/project-databases-new-possibilities-with-the-form-editor/)

All the manuals have been updated accordingly.

Bug fix : 
 - Set default value for picker color.


We now use Github as a repository. You will find the link on our website:

https://ch-fr.4d.com/ajuibutton


Best regards,

Maurice Inzirillo
-- 
AJAR S.A.

https://ch-fr.4d.com
twitter: ajar_info
Tél : +41 (0)323422684





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