Re: Managing 4D Server as a service

[JOHN BAUGHMAN via 4D_Tech]

Tim,  thank you for that most informative post. It really helps. I will be 
switching my client's 4D Server to a service later this evening for the first 
time. After reading your post I feel far more confident going forward.

> On May 9, 2019, at 11:25 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> When interact with desktop is working you will see a program in the Taskbar 
> with a name like “Interactive Services”. It shows a small window with a 
> button you can click. Click the button and the screen changes and you switch 
> — to the "console user" I think it is called — and you will then see the 4D 
> Server Administration window. Desktop disappears. Then everything looks and 
> works just as expected. Error dialogs are displayed. You can edit Database 
> Settings, backup settings, switch tabs in the Administration window, etc. 


The client is running v16R6 on Windows Server 2008 R2. You pointed me in the 
right direction and it appears in this configuration Interactive Services works 
great. I suspect that the client will continue using Win Server 2008 until they 
are forced to upgrade, but I will be moving them to v17 shortly. Hopefully 
Interactive Services will continue to work with v17.

Thank s again,

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

Re: Managing 4D Server as a service

[Tom Benedict via 4D_Tech]

On May 9, 2019, at 14:25, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> On May 9, 2019, at 2:00 PM, JOHN BAUGHMAN wrote:
> 
>> I am new to this and am wondering how does one manage a 4D Server running as 
>> a service. If, for example, the server throws an error there is no way to 
>> see the error. I guess what I am asking is to confirm that there is no way 
>> to see the server gui while it is running as a service.
> 
> Finally, you can write your own 4D Server Administration window and duplicate 
> almost all — but not everything — using various commands and methods with the 
> Execute on Server property set. I think their goal is to provide commands so 
> that EVERYTHING you can currently do and see on the 4D Server Administration 
> window will be doable from 4D Client. That includes all the graphs you see on 
> the “Monitor” tab. OPEN ADMINISTRATION WINDOW may not even be needed. They 
> are not there yet… maybe with v18 they will finish the command set to make it 
> possible. 
> 

The 4D World Tour example disk include a Server Administration Web Interface, 
which is really the way to do remote administration. I haven’t tried it, but it 
looks pretty slick.

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

Re: Printing structures

[Tom Dillon via 4D_Tech]

John J Foster via 4D_Tech wrote:

>So that's why I have some tables that the size of Canada! 

It's in Mercator projection mode.

-- 
   --
   Tom Dillon  375 S Main St #405
   DataCraft   Moab, UT 84532
   tomdil...@datacraft-inc.com   720/209-6502
   --
 The evolution of the brain not only overshot the needs of
 prehistoric man, it is the only example of evolution providing
 a species with an organ which it does not know how to use.
 - Arthur Koestler - British columnist
   --


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

Re: Managing 4D Server as a service

[Tim Nevels via 4D_Tech]

On May 9, 2019, at 2:00 PM, JOHN BAUGHMAN wrote:

> I am new to this and am wondering how does one manage a 4D Server running as 
> a service. If, for example, the server throws an error there is no way to see 
> the error. I guess what I am asking is to confirm that there is no way to see 
> the server gui while it is running as a service.
> 
> Also, I am not sure what "Allow service to interact with desktop" does. I am 
> still confused after reading up on this option.I have it checked as what I 
> have read leads me to believe that I need it checked for 4D server to access 
> thins like the file system, clibboard, email, etc. 
> 
> Maybe someone can help me better understand the ins and out of running 4D 
> server as a service.

First things first. Interact with desktop works fine with older versions of 4D 
Server and older versions of Windows Server. Newer versions have issues. Some 
combinations it’s just not going to work at all. Others you can get it to work 
if you do some Windows Registry setting changes. 4D v16+ and Windows Server 
2012+ take the most effort to get it to work. And some IT departments have 
Windows Server configured and user accounts configured to where it is just 
about impossible to get it to work. You’ll have to provide specific version of 
4D Server you will be using and version of Windows Server you will be using for 
me to comment on how easy/hard it will be to get it working.

When interact with desktop is working you will see a program in the Taskbar 
with a name like “Interactive Services”. It shows a small window with a button 
you can click. Click the button and the screen changes and you switch — to the 
"console user" I think it is called — and you will then see the 4D Server 
Administration window. Desktop disappears. Then everything looks and works just 
as expected. Error dialogs are displayed. You can edit Database Settings, 
backup settings, switch tabs in the Administration window, etc. 

There is also a small window — usually hidden behind the 4D Server MDI window — 
that has a button to allow you to return to the Desktop. Click that and you are 
back to Windows Server Desktop that you started from. That is basically it. 

Microsoft has decided that Interactive Desktop Services is now a bad idea and 
has depreciated it. It still works, but they block it from working with 
Registry entries in current Windows Server versions. You can edit the Registry 
and turn on some Windows Services and it still works. But they make it hard and 
a PITA to make you not want to use it. But I have used it — and currently are 
using it — and it works just fine. You want details on how to make it work, 
Google it or send me a private email and I’ll give you the info to make it work.

Current 4D recommendations is to not use interact with desktop when running 4D 
Server as a service and to handle everything yourself. Always install ON ERR 
CALL method on everything that runs on 4D Server and log the error somehow so 
you will never have a runtime error dialog appear. 

Be aware that sometimes you just have to launch 4D Server not as a service to 
deal with some things. Like you install a new structure file and you need to 
set the data file location. You start 4D Server as a Windows Service it will 
immediately quit. Since you can’t see the “select data file” dialog box, it 
just quits. So you have to start 4D Server on the Desktop, select the data file 
and then quit. Then you can start 4D Server as a service and it will stay 
running since it does not need to show the select data file dialog box. 

Also some other obscure error dialogs will display and the only way to see them 
and deal with them is to start 4D Server from the Desktop — not as a service — 
to see those dialog boxes and deal with them. It is challenging to run 4D 
Server as a Windows Service 100% of the time. It is supposed to be possible, 
but I’ve never been able to do it. Every once and a while I have to start it up 
from the Desktop and deal with a dialog box or message or make some setting 
change. 

To see the 4D Server Administration window, you can get it to show from 4D 
Client. Use the command OPEN ADMINISTRATION WINDOW from 4D Client. If you are 
using 4D Users and Groups you have to be logged in as Designer for it to work. 
You can’t do everything from this window that you can on the 4D Server machine, 
but you do a lot. 

Finally, you can write your own 4D Server Administration window and duplicate 
almost all — but not everything — using various commands and methods with the 
Execute on Server property set. I think their goal is to provide commands so 
that EVERYTHING you can currently do and see on the 4D Server Administration 
window will be doable from 4D Client. That includes all the graphs you see on 
the “Monitor” tab. OPEN ADMINISTRATION WINDOW may not even be needed. They are 
not there yet… maybe with v18 they will finish the command set to make it 
possible. 

Tim

Re: Printing structures

[John J Foster via 4D_Tech]

Hey Cannon,

So that’s why I have some tables that the size of Canada! 

Thanks for the heads up.

John…


> On May 9, 2019, at 12:00 PM, 4d_tech-requ...@lists.4d.com wrote:
> 
> Just a heads up on a bit of code that won’t work in countries that use a 
> decimal place instead of a comma. In the method xml_atts2ob, lines 50, 54, 
> 58, and 62 convert the decimal point in the height, left, top, and width of 
> the XML values to a comma. For values that have a decimal place, this can 
> make for some really, really big table widths and heights!

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

AreaList Pro version 10.2 released

[Philippe Ganter via 4D_Tech]

AreaList Pro version 10.2 is now available at http://www.e-node.net/alp

Changes include:
- New property for checkbox focusability (ALP_Column_FocusableCheckbox)
- AL_SuperReport now sets SRP_Column_ExecutionLevel to 1 for related fields
- DisplayList can leave the first row unselected when multiple row selection is 
used 
- Improved bidirectional text support
- XML for area now includes row and cell options


The following 4D v17 databases are also available:

- AreaList Pro Demonstration database 
(http://www.e-node.net/ftp/AreaListPro/AreaListPro_Demo_v17.zip)
- New AreaList Pro v10 features specific demo 
(http://www.e-node.net/ftp/AreaListPro/AreaListPro_v10_NewFeatures_v17.zip)
- Transpose/Rotate AreaList Pro demonstration: make a 4D object properties 
palette with AreaList Pro! 
(http://www.e-node.net/ftp/AreaListPro/AreaListPro_v10_Transpose_v17.zip)
- AreaList Pro - MySQL direct connection 
(http://www.e-node.net/ftp/AreaListPro/AreaListPro_PrintListPro_MySQL_v17.zip)
- AreaList Pro Tutorial examples 
(http://www.e-node.net/ftp/AreaListPro/AreaListPro_Examples_v17.zip)
- AreaList Pro Drag and drop to and from objects of all kinds 
(http://www.e-node.net/ftp/AreaListPro/AreaListPro_DragAndDrop_v17.zip)
- Drag and Drop between AreaList Pro and CalendarSet 
(http://www.e-node.net/ftp/AreaListPro/AreaListPro_CalendarSet_Drag_Demo_v17.zip)
- One code line printing an AreaList Pro area with SuperReport Pro 
(http://www.e-node.net/ftp/AreaListPro/AreaListPro_SuperReportPro_Demo_v17.zip)


Regards,
-- 
Philippe Ganter
www.e-node.net 
































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

Managing 4D Server as a service

[JOHN BAUGHMAN via 4D_Tech]

I am new to this and am wondering how does one manage a 4D Server running as a 
service. If, for example, the server throws an error there is no way to see the 
error. I guess what I am asking is to confirm that there is no way to see the 
server gui while it is running as a service.

Also, I am not sure what "Allow service to interact with desktop" does. I am 
still confused after reading up on this option.I have it checked as what I have 
read leads me to believe that I need it checked for 4D server to access thins 
like the file system, clibboard, email, etc. 

Maybe someone can help me better understand the ins and out of running 4D 
server as a service.

Thanks,

John




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

Printing structures : Update

[Herr Alexander Heintz via 4D_Tech]

I was told there are countries out there that use the „.“ as decimal separator…
This lead to interesting results when parsing the xml.
Made a small change to the code, new version is online and can be downloaded 
here:

http://blog.heintz.net/wow-i-cant-believe-it/ 


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