Re: 4D Database Server Hardware recommendation

[Ronnie Teo via 4D_Tech]

Hi,

I’m interested to learn more about the nuances of this too.

Say if the client were to go for Windows Server 2012 + 8GB or 16GB RAM + a 
database of say 5GB data file with an average of 30 concurrent logins, how 
would we decide on the memory allocation in order to best utilise the hardware 
resources?

Regards,
Ronnie
Tarawerkz

> On 13 Jul 2017, at 3:00 am, 4d_tech-requ...@lists.4d.com wrote:
> 
> Brad,
> 
> We are recommending Dell XEON E5-26xx servers
> Powerful enough for most applications
> 16GB RAM
> SSD Drive is always great, especially PCIe.
> E.g. Samsung 960 Pro
> 
> Randy Engle
> XC2 Software LLC – XC2LIVE!
> 
> 
> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com 
> ] On Behalf Of Perkins, Bradley D via 
> 4D_Tech
> Sent: Wednesday, July 12, 2017 10:02 AM
> To: 4d_tech@lists.4d.com 
> Cc: Perkins, Bradley D >
> Subject: 4D Database Server Hardware recommendation
> 
> A customer needs to replace aging Windows server hardware. I haven't spec'd 
> any Windows server hardware in a long time and am looking for recommendations.
> The primary use is to host 4D Server.  This isn't a large database, but does 
> need to run near 24/7/365.
> The are currently running 4D v15.*
> They'll want Dell. Server needs to be rack-mounted. Lower cost is fine. These 
> are replacing R610 models bought in 2010.
> They'll also have to upgrade from Windows Server 2008 r3 to some version of 
> Windows Server 2012. Are there any things I should be aware of related to 
> that?
> 
> What models are people using recently for 4D Server deployments?
> 
> Thanks,

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

Wiki software: Confluence

[David Adams via 4D_Tech]

I've tried a few different wiki packages down the years, sometimes setting
them up from scratch and sometimes using one someone else configured. At
the moment I'm using Atlassian's Confluence as set up by someone else.

It's great.

As I'm working along, figuring things out I can put down some notes to
refer back to. If I have to figure out some kind of algorithm that's new to
me (or long forgotten), I can write it up for others in a team setting.
(I've been doing a bunch of interval math lately which I thought I hated. I
don't hate it, I just didn't know where to look for the right information.)

I understand that a lot of people don't like writing and that it's a chore.
As I just heard it put from someone (in voice mail)

"Because I hate writing. Period."

Confluence (or similar) isn't the product for people in this camp ;-) But
if you do find it helpful to write things down in a place that you can find
them latter, I'm really pleased with Confluence.

A couple of notes:
* There are only a handful of styles and formatting options. A bit
frustrating for someone like me who misses character-level
stylesheets...but then you end up wasting very little time on formatting.
(At times, I make myself write in BBEdit so that I don't get caught up in
pointless tweaking too early.) After using Confluence's options for a few
days I stopped and noticed, 'Hey! Everything looks great!" They've saved me
from wasting time and from doing hideous things ;-)

* Overall, I've probably spent 30-45 minutes figuring out various features
and where options are. The hardest was figuring out where attachments are
organized. (There's a little paperclip symbol that's only visible when
you're not editing. A bit weird, but not a big deal.)

If anyone has used Confluence and/or anything else and wants to post some
comparisons (now or six months from now, I'll still be interested), please
do.
**
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: Automatic Font

[Keisuke Miyako via 4D_Tech]

some developer use

$autofont:=OBJECT Get font(*;"")

but

$autofont:=_o_Font name(0)

also works.

but to set at runtime,

I think it is better to

OBJECT SET STYLE SHEET(*;"";Automatic style sheet)
OBJECT SET STYLE SHEET(*;"";Automatic style sheet_additional)
OBJECT SET STYLE SHEET(*;"";Automatic style sheet_main)


> 2017/07/13 8:45、Wayne Stewart via 4D_Tech <4d_tech@lists.4d.com> のメール：
>
> Is there a way to get the name of the "Automatic" (application/system etc)
> font name at runtime?




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

Automatic Font

[Wayne Stewart via 4D_Tech]

Hi,

Is there a way to get the name of the "Automatic" (application/system etc)
font name at runtime?

Elsewhere I use Object Set Font & may want to use the "automatic one"

​Thanks
,

Wayne


[image: --]
Wayne Stewart
[image: http://]about.me/waynestewart

**
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: Function to return the date/time of the next scheduled backup

[Tony Ringsmuth via 4D_Tech]

Hey Chuck.

I parse, and read, and write the contents of  Backup.xml file all the time.

However, the calculation as to when the next backup should be is somewhat 
complex:  may take a few hours to code: if you want to be right:  Consider 
scenarios like:

Every Tuesday and Friday at 10PM

And cases like: if the backup is over-due, it should run now.

Regards,
Tony
 

On 7/12/17, 4:13 PM, "4D_Tech on behalf of Charles Miller via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

I have not but it would appear that you would first open the xml get last
backup date and time
The get backup frequency and perform a calculation I do not think backup
save next date in the xml

Hope this helps

chuck

On Wed, Jul 12, 2017 at 4:42 PM, Tony Ringsmuth via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Does anyone have code that correctly calculates, from the
> /preferences/Backup.xml file, the Date/Time of the next scheduled 4D 
Backup?
>
> If so, could you please share it?
>
>
>
> Thanks!
>
> --
>
> Tony Ringsmuth
>
> Business Brothers Inc.
>
> 763-420-8686
>
> **
> 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
> **




-- 

-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Sever connectivity
  http://www.informed-solutions.com

-
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law.  These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited.  Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**
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: Someone help me out, how do you get good information out of 4D

[bob.miller--- via 4D_Tech]

RE> The people I meant to write to know perfectly well my history and what 
I'm talking about - and know that it's form a quarter of a century ago. 
(By now, virtually no one from those days
is even around.)

David,

Virtually no one?  Really?  Come back to the US for the next Summit and 
you'll see all of us  :)


Bob Miller
Chomerics, a division of Parker Hannifin Corporation



**
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: Function to return the date/time of the next scheduled backup

[Herr Alexander Heintz via 4D_Tech]

have a look at my blog post:

http://blog.heintz.net/to-backup-or-not-to-backup/ 


should do what you are looking for, the command

ScheduleObject:=BACKUP_GetSchedule(xmlBupReference)

should help here

cheers

Alex

> Am 12.07.2017 um 22:42 schrieb Tony Ringsmuth via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> Does anyone have code that correctly calculates, from the 
> /preferences/Backup.xml file, the Date/Time of the next scheduled 4D Backup?
> 
> If so, could you please share it?
> 
> 
> 
> Thanks!
> 
> --
> 
> Tony Ringsmuth
> 
> Business Brothers Inc.
> 
> 763-420-8686
> 
> **
> 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: Function to return the date/time of the next scheduled backup

[Charles Miller via 4D_Tech]

I have not but it would appear that you would first open the xml get last
backup date and time
The get backup frequency and perform a calculation I do not think backup
save next date in the xml

Hope this helps

chuck

On Wed, Jul 12, 2017 at 4:42 PM, Tony Ringsmuth via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Does anyone have code that correctly calculates, from the
> /preferences/Backup.xml file, the Date/Time of the next scheduled 4D Backup?
>
> If so, could you please share it?
>
>
>
> Thanks!
>
> --
>
> Tony Ringsmuth
>
> Business Brothers Inc.
>
> 763-420-8686
>
> **
> 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
> **




-- 
-
 Chuck Miller Voice: (617) 739-0306 Fax: (617) 232-1064
 Informed Solutions, Inc.
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D, Sybase & SQL Sever connectivity
  http://www.informed-solutions.com
-
This message and any attached documents contain information which may be
confidential, subject to privilege or exempt from disclosure under
applicable law.  These materials are intended only for the use of the
intended recipient. If you are not the intended recipient of this
transmission, you are hereby notified that any distribution, disclosure,
printing, copying, storage, modification or the taking of any action in
reliance upon this transmission is strictly prohibited.  Delivery of this
message to any person other than the intended recipient shall not
compromise or waive such confidentiality, privilege or exemption
from disclosure as to this communication.
**
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
**

Function to return the date/time of the next scheduled backup

[Tony Ringsmuth via 4D_Tech]

Does anyone have code that correctly calculates, from the 
/preferences/Backup.xml file, the Date/Time of the next scheduled 4D Backup?

If so, could you please share it?

 

Thanks!

--

Tony Ringsmuth

Business Brothers Inc.

763-420-8686

**
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 Database Server Hardware recommendation

[Randy Engle via 4D_Tech]

Brad,

We are recommending Dell XEON E5-26xx servers
Powerful enough for most applications
16GB RAM
SSD Drive is always great, especially PCIe.
E.g. Samsung 960 Pro

Randy Engle
XC2 Software LLC – XC2LIVE!


-Original Message-
From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Perkins, 
Bradley D via 4D_Tech
Sent: Wednesday, July 12, 2017 10:02 AM
To: 4d_tech@lists.4d.com
Cc: Perkins, Bradley D 
Subject: 4D Database Server Hardware recommendation

A customer needs to replace aging Windows server hardware. I haven't spec'd any 
Windows server hardware in a long time and am looking for recommendations.
The primary use is to host 4D Server.  This isn't a large database, but does 
need to run near 24/7/365.
The are currently running 4D v15.*
They'll want Dell. Server needs to be rack-mounted. Lower cost is fine. These 
are replacing R610 models bought in 2010.
They'll also have to upgrade from Windows Server 2008 r3 to some version of 
Windows Server 2012. Are there any things I should be aware of related to that?

What models are people using recently for 4D Server deployments?

Thanks,

Brad Perkins
**
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: v13+ - How to do a 'Find in array' with a picture array?

[Herr Alexander Heintz via 4D_Tech]

use a parallel array with hashes of the pictures.

$MD5_1RF:=Generate digest($FirstBlobRF;MD5 digest 
)

one problem though: you will need to set the pictures into blobs first

PICTURE TO BLOB ( Bild ; BildBlob ; Codec )

should do the trick,
so the digest (a rather short string) will be identical for 2 identical 
pictures and thus easy to compare:

for each array element calculate the hash and keep it in a parallel text array

then calculating the hash for each picture to compare, you can even search in 
array!

Hope this helps,
cheers
Alex


> Am 12.07.2017 um 19:03 schrieb Chip Scheide via 4D_Tech 
> <4d_tech@lists.4d.com>:
> 
> I have a picture array which has icons
> I want to use it as a key to the contents of other (parallel) arrays.
> 
> basically 
> if icon{1} = pic1 - do something
> if icon{1} = pic2 - do something else
> etc
> .
> .
> .
> 
> 
> any ideas? code?
> 
> Thanks
> Chip
> 
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 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 Database Server Hardware recommendation

[Perkins, Bradley D via 4D_Tech]

A customer needs to replace aging Windows server hardware. I haven't spec'd any 
Windows server hardware in a long time and am looking for recommendations.
The primary use is to host 4D Server.  This isn't a large database, but does 
need to run near 24/7/365.
The are currently running 4D v15.*
They'll want Dell. Server needs to be rack-mounted. Lower cost is fine. These 
are replacing R610 models bought in 2010.
They'll also have to upgrade from Windows Server 2008 r3 to some version of 
Windows Server 2012. Are there any things I should be aware of related to that?

What models are people using recently for 4D Server deployments?

Thanks,

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

v13+ - How to do a 'Find in array' with a picture array?

[Chip Scheide via 4D_Tech]

I have a picture array which has icons
I want to use it as a key to the contents of other (parallel) arrays.

basically 
if icon{1} = pic1 - do something
if icon{1} = pic2 - do something else
etc
.
.
.


any ideas? code?

Thanks
Chip

---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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
**