RE: Unusual crash / failure to start 4D - Solved

[Magnus Torell via 4D_Tech]

Dear Mike,

I'm glad I could help.

Best Regards

Magnus



--
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: [off-ish] Regex help

[Vincent de Lachaux via 4D_Tech]

Hello Chip,

Did you try this: $x:=Split string($pathname;Folder separator)

Vincent




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

Mojave

[Cannon Smith via 4D_Tech]

I don’t believe 4D has released a version that is fully compatible with Mojave, 
unless I missed an announcement. But I’m getting outside pressure to upgrade 
from Sierra to Mojave and may have to do it anyway. From what I’ve heard, v17 
seems to work good enough for development at least in Mojave, but my main 
concern is v16r6. I’ll still need to do some development and building in that 
version for a couple months. Is anyone using that version in Mojave and could 
comment on how well it is working? (Comments about v17 in Mojave are also 
welcome.)

Thanks!

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




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

[Pat Bensky via 4D_Tech]

I am likewise curious about this ... and what about v13? We still have some
customers on that version. Will we need to maintain separate machines with
different versions of the OS installed?

On Fri, 30 Nov 2018 at 14:18, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com>
wrote:

> I don’t believe 4D has released a version that is fully compatible with
> Mojave, unless I missed an announcement. But I’m getting outside pressure
> to upgrade from Sierra to Mojave and may have to do it anyway. From what
> I’ve heard, v17 seems to work good enough for development at least in
> Mojave, but my main concern is v16r6. I’ll still need to do some
> development and building in that version for a couple months. Is anyone
> using that version in Mojave and could comment on how well it is working?
> (Comments about v17 in Mojave are also welcome.)
>
> Thanks!
>
> --
> Cannon.Smith
> Synergy Farm Solutions Inc.
> Hill Spring, AB Canada
> 403-626-3236
> 
> 
>
>
> **
> 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
> **



-- 
*
CatBase - Top Dog in Data Publishing
tel: +44 (0) 207 118 7889
w: http://www.catbase.com
skype: pat.bensky
*
**
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: PDF - TEXT CONVERSION

[Tom Dillon via 4D_Tech]

Ferdinando,

Rob Laveaux has some PDF plugins. I used one that does this.



-- 
   --
   Tom Dillon  375 S Main St #405
   DataCraft   Moab, UT 84532
   tomdil...@datacraft-inc.com   720/209-6502
   --
Imagination is more important than knowledge,
because everything we know, first had to be imagined.
--- Albert Einstein 
   --


stardata.info via 4D_Tech wrote:

>Hi all,
>
>In one 4D application, I need to convert one pdf document in a text file.
>
>Someone know a plugin that does this?


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

Miyako’s curl ftp

[cjmiller--- via 4D_Tech]

Hi all are there examples for the plug in 
Regards 

Chuck
Sent from my iPhone
**
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: Mojave

[John Baughman via 4D_Tech]

I had to convert all my pict format graphics, static and in the picture 
library.  Otherwise 4D would crash when a form containing one or more of them 
was displayed.

16R6.. client is experimenting with a couple of clients running Mojave. So far 
no complaints since fixing the pics. Not tried server yet. 

John Baughman
Kailua, Hawaii
john...@hawaii.rr.com

> On Nov 30, 2018, at 4:38 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I am likewise curious about this ... and what about v13? We still have some
> customers on that version. Will we need to maintain separate machines with
> different versions of the OS installed?
> 
> On Fri, 30 Nov 2018 at 14:18, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> 
>> I don’t believe 4D has released a version that is fully compatible with
>> Mojave, unless I missed an announcement. But I’m getting outside pressure
>> to upgrade from Sierra to Mojave and may have to do it anyway. From what
>> I’ve heard, v17 seems to work good enough for development at least in
>> Mojave, but my main concern is v16r6. I’ll still need to do some
>> development and building in that version for a couple months. Is anyone
>> using that version in Mojave and could comment on how well it is working?
>> (Comments about v17 in Mojave are also welcome.)
>> 
>> Thanks!
>> 
>> --
>> Cannon.Smith
>> Synergy Farm Solutions Inc.
>> Hill Spring, AB Canada
>> 403-626-3236
>> 
>> 
>> 
>> 
>> **
>> 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
>> **
> 
> 
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 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
**

Re: Mojave

[Kirk Brooks via 4D_Tech]

Canon,
I haven't had any issues running v17 on Mojave. I'm not really doing
anything with v16 anymore so can't speak to that. v15 is mostly OK except
for issues with the web area.

On Fri, Nov 30, 2018 at 6:18 AM Cannon Smith via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I don’t believe 4D has released a version that is fully compatible with
> Mojave, unless I missed an announcement. But I’m getting outside pressure
> to upgrade from Sierra to Mojave and may have to do it anyway. From what
> I’ve heard, v17 seems to work good enough for development at least in
> Mojave, but my main concern is v16r6. I’ll still need to do some
> development and building in that version for a couple months. Is anyone
> using that version in Mojave and could comment on how well it is working?
> (Comments about v17 in Mojave are also welcome.)
>
> Thanks!
>
> --
> Cannon.Smith
> Synergy Farm Solutions Inc.
> Hill Spring, AB Canada
> 403-626-3236
> 
> 
>
>
> **
> 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
> **



-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
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: Windows Server Hardware Recommendations for 4DServer v17 Application

[Neal Schaefer via 4D_Tech]

Thanks Chuck! Good point on the Pro versions of SSDs. Our data file is 32GB, 
and 14GB index file (about 1080 indexed fields). Would love your thoughts on 
appropriate RAM and processor speed for our scenario. Thanks again!

-Neal

==

Date: Thu, 29 Nov 2018 17:53:32 -0500

From: Charles Miller mailto:miller.c...@gmail.com>>

To: 4D iNug Technical <4d_tech@lists.4d.com>

Subject: Re: Windows Server Hardware Recommendations for 4DServer v17

Application

Message-ID:


mailto:cadksfq7kwjxccy32ppg2elyqavvbwl_tlw6x3tncnx3uik2...@mail.gmail.com>>

Content-Type: text/plain; charset="UTF-8"



How big is data file? You will need this for how much memory. Indexes? I would 
also recommend a raid SSD setup.  More memory is always better. If you want to 
have your entiore data file in cache you wil need requisite memory. Also make 
sure to get Pro versions of SSDs not consumer versions.



Hope this helps?



Regards


Chuck

From: Neal Schaefer
Sent: Thursday, November 29, 2018 2:34 PM
To: '4d_tech@lists.4d.com' <4d_tech@lists.4d.com>
Subject: Windows Server Hardware Recommendations for 4DServer v17 Application

We're planning to upgrade to v17 in Q1 this coming year. We're currently 
running our 4DServer v16 r6 application on a Windows 2008r2 server (DELL Server 
PER420 with Xeon CUP E5-2407 v2 @2.40Ghz 2.40 Ghz (2 processors) with 32GB RAM, 
64-bit). Our budget for the coming year includes funds for a new server 
machine. I'm looking for hardware recommendations based on our current users 
and setup. We average about 45 concurrent users via 4D client/server and 
another 50 - 70 web connections.

4D doesn't like to make recommendations beyond minimum requirements, so I'm 
wondering if anyone on the list has a similar scenario and could recommend 
processor speed, RAM, etc.

Thanks in advance!

Neal Schaefer
Director, Product & Content Management Systems

ABC-CLIO
130 Cremona Drive, Suite C | Santa Barbara, CA | 93117
nschae...@abc-clio.com | 
www.abc-clio.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
**

Re: Miyako’s curl ftp

[Charles Miller via 4D_Tech]

Never mind. I downloaded wrong curls for Miyako. Once I got to ftp one I was 
all set. Sorry for wasting bandwidth

Regards

Chuck
> On Nov 30, 2018, at 11:15 AM, cjmiller--- via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi all are there examples for the plug in 
> Regards 
> 
> Chuck
> Sent from my iPhone
> **
> 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
**

RE: Windows Server Hardware Recommendations for 4DServer v17 Application

[Chip Scheide via 4D_Tech]

Always...

more is better
faster is better

:)


On Fri, 30 Nov 2018 17:29:42 +, Neal Schaefer via 4D_Tech wrote:
> Thanks Chuck! Good point on the Pro versions of SSDs. Our data file 
> is 32GB, and 14GB index file (about 1080 indexed fields). Would love 
> your thoughts on appropriate RAM and processor speed for our 
> scenario. Thanks again!
> 
> -Neal
> 
> ==
> 
> Date: Thu, 29 Nov 2018 17:53:32 -0500
> 
> From: Charles Miller mailto:miller.c...@gmail.com>>
> 
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> 
> Subject: Re: Windows Server Hardware Recommendations for 4DServer v17
> 
> Application
> 
> Message-ID:
> 
> 
> 
mailto:cadksfq7kwjxccy32ppg2elyqavvbwl_tlw6x3tncnx3uik2...@mail.gmail.com>>
> 
> Content-Type: text/plain; charset="UTF-8"
> 
> 
> 
> How big is data file? You will need this for how much memory. 
> Indexes? I would also recommend a raid SSD setup.  More memory is 
> always better. If you want to have your entiore data file in cache 
> you wil need requisite memory. Also make sure to get Pro versions of 
> SSDs not consumer versions.
> 
> 
> 
> Hope this helps?
> 
> 
> 
> Regards
> 
> 
> Chuck
> 
> From: Neal Schaefer
> Sent: Thursday, November 29, 2018 2:34 PM
> To: '4d_tech@lists.4d.com' <4d_tech@lists.4d.com>
> Subject: Windows Server Hardware Recommendations for 4DServer v17 
> Application
> 
> We're planning to upgrade to v17 in Q1 this coming year. We're 
> currently running our 4DServer v16 r6 application on a Windows 2008r2 
> server (DELL Server PER420 with Xeon CUP E5-2407 v2 @2.40Ghz 2.40 Ghz 
> (2 processors) with 32GB RAM, 64-bit). Our budget for the coming year 
> includes funds for a new server machine. I'm looking for hardware 
> recommendations based on our current users and setup. We average 
> about 45 concurrent users via 4D client/server and another 50 - 70 
> web connections.
> 
> 4D doesn't like to make recommendations beyond minimum requirements, 
> so I'm wondering if anyone on the list has a similar scenario and 
> could recommend processor speed, RAM, etc.
> 
> Thanks in advance!
> 
> Neal Schaefer
> Director, Product & Content Management Systems
> 
> ABC-CLIO
> 130 Cremona Drive, Suite C | Santa Barbara, CA | 93117
> nschae...@abc-clio.com | 
> www.abc-clio.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
> **
---
Gas is for washing parts
Alcohol is for drinkin'
Nitromethane is for racing 
**
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: Windows Server Hardware Recommendations for 4DServer v17

[Benedict, Tom via 4D_Tech]

Hi  Neal,



>We're planning to upgrade to v17 in Q1 this coming year. We're currently 
>running our 4DServer v16 r6 application on a Windows 2008r2

>server (DELL Server PER420 with Xeon CUP E5-2407 v2 @2.40Ghz 2.40 Ghz (2 
>processors) with 32GB RAM, 64-bit). Our budget for the

>coming year includes funds for a new server machine. I'm looking for hardware 
>recommendations based on our current users and setup.

>We average about 45 concurrent users via 4D client/server and another 50 - 70 
>web connections.



You may not need any more hardware than you already have. Or you might! What 
I'm saying is that the only way to know if you are approaching (or already 
exceeding) the capability of your hardware is to measure performance. If you 
don't already have Thomas Schulmberger's Info Component installed, that would 
be a good place to start. You should be able to find it online, or contact 4D 
Tech Support. That will give you lots of key performance data which can be 
directly impacted by hardware. For example, it will tell you how often the 4D 
cache is being purged and how long it takes. Additionally, if you don't already 
have built-in application metrics, like how long it takes to do certain user 
tasks, that is something to start doing ASAP. Your users can tell you where the 
bottlenecks are, so those are things you need to collect data on. It will help 
you determine priorities. And if you can cut 10 seconds off a task done 100 
times a day by 45 users that's a massive payback.



How long does it take to run MSC on your current data file? Does it take so 
long that you have to interrupt business to do routine maintenance tasks like 
Compacting or Re-indexing? If new hardware allows you to reduce the maintenance 
burden, that alone could be a reason to upgrade. But you need to collect the 
data to know what to do.



But if you have a budget and it needs to be spent, I'd look at your disk 
subsystems. If you aren't running solid state drives that would be a great 
investment. You'll see reports run in seconds instead of minutes.



HTH,



Tom Benedict

This e-mail, including attachments, may include confidential and/or
proprietary information, and may be used only by the person or entity
to which it is addressed. If the reader of this e-mail is not the intended
recipient or his or her authorized agent, the reader is hereby notified
that any dissemination, distribution or copying of this e-mail is
prohibited. If you have received this e-mail in error, please notify the
sender by replying to this message and delete this e-mail immediately.
**
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
**

SQL query for the current date

[Jeffrey Kain via 4D_Tech]

I'm trying to query 4D Server via the SQL engine from another application, and 
it seems like if you use CURRENT_DATE() or CURDATE(), the query is always 
sequential even if an index is available.

Example:

  SELECT InvoiceID from Invoices
  WHERE CreatedDate=CURRENT_DATE()

... does a sequential scan of the Invoices table, even though 
Invoices.CreatedData is indexed. This takes a very long time - probably close 
to a half an hour.

If I rewrite the where clause as:

  WHERE CreatedDate='2018-11-30'

... it takes milliseconds.

Is there a trick to being able to write a script that can generically select 
against the current date?  This is from some php code, fyi... but it's easily 
reproduced inside of 4D itself.


Thanks!
Jeff
**
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: Windows Server Hardware Recommendations for 4DServer v17 Application

[Chuck Miller via 4D_Tech]

For your data size I would look at 500 gig suds and 64 or greater memory if you 
can afford it

If you assign 32 gig to cache most will be in memory. You can even preload 
commonly used data on server startup


Regards

Chuck
> On Nov 30, 2018, at 12:29 PM, Neal Schaefer via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Thanks Chuck! Good point on the Pro versions of SSDs. Our data file is 32GB, 
> and 14GB index file (about 1080 indexed fields). Would love your thoughts on 
> appropriate RAM and processor speed for our scenario. Thanks again!
> 
> -Neal

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

[Cannon Smith via 4D_Tech]

Thanks John and Kirk. I appreciate the feedback. If anyone else has more 
information, feel free to chime in.

Thanks.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Hill Spring, AB Canada
403-626-3236




> On Nov 30, 2018, at 9:59 AM, John Baughman via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I had to convert all my pict format graphics, static and in the picture 
> library.  Otherwise 4D would crash when a form containing one or more of them 
> was displayed.
> 
> 16R6.. client is experimenting with a couple of clients running Mojave. So 
> far no complaints since fixing the pics. Not tried server yet. 

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

v13 - Odd behavior

[Chip Scheide via 4D_Tech]

I was testing some code. The method presents the user with a 
confirmation dialog, and returns value as the user response. I copied 
my intended message, and the method call for the confirmation into a 
testing method (so I can run just the message).

$msg:="blah blahl Blah"
(utl_msg_4ButtonConfirm ($msg;"Umm No";"Confirm") 

When I tested this, the dialog was presented, as it should have been, 
then it was presented a SECOND time!

NOTE: there is a left parenthesis in the method call. For whatever 
reason, the extra paren caused 4D to execute the method call 2x.

Odd

Chip

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