Re: catalina and 4D

[Keisuke Miyako via 4D_Tech]

if notarisation is the only issue:

keep in mind that notarisation is a guard against downloaded apps,
meaning, it only applies to apps you installed after you upgraded to Catalina,
and apps you downloaded from the internet (HTTP, FTP, AirDrop file transfer).
it does not apply to apps you already installed and launched in your Mojave 
days or earlier,
it does not apply to apps you copied outside the internet (external removable 
drive, etc).

2020/01/14 13:08、Ken Eyring via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
I'm running Catalina Mac 10.15.2 with 4D v17.3 HF2.  It seems to work fine here.



**
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: catalina and 4D

[Ken Eyring via 4D_Tech]

Hi Chuck,

I'm running Catalina Mac 10.15.2 with 4D v17.3 HF2.  It seems to work 
fine here.


HTH,
Ken



On 01/13/20 5:03 PM, Chuck Miller via 4D_Tech wrote:

Hi All,

I have new laptop that I bought without thinking too hard. It only tuns 
Catalina. I am trying to run v17.3 and have some issues. Is anyone using 
catalina and if so what might I do to fix the slowness I am seeing. Should I be 
using an R  release and if so which one

Thanks and regards


Chuck

  Chuck Miller Voice: (617) 739-0306
  Informed Solutions, Inc. Fax: (617) 232-1064
  mailto:cjmillerinformed-solutions.com
  Brookline, MA 02446 USA Registered 4D Developer
Providers of 4D and Sybase 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)
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: Document encoding

[Keisuke Miyako via 4D_Tech]

alternative solutions for guessing plain text encoding

https://opensource.google/projects/ced

also

https://github.com/miyako/4d-plugin-text-convert


$err:=CP Get good encodings ($euc;$codepages)


$err:=ICU Get good encodings ($euc;$encodings;$languages;$confidences)

but I agree with Koen, to request UTF-8 “encoding” for PDF seems like a 
misunderstanding by the end user.

I know Adobe Acrobat phrases it that way

https://helpx.adobe.com/acrobat/using/file-format-options-pdf-export.html

but in reality, PDF has an embedded font mapping system for rendering,
which makes “text encoding” kind of irrelevant for rendering.
you might have seen PDF that display fine but copy and paste or searching is 
garbage.
I think that it the scenario the user want’t to avoid.

2020/01/14 2:35、Koen Van Hooreweghe via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
FWIW, BBEdit also guesses what the text file encoding could be. It does a good 
job, but it can be fooled.



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

Locking (restrict Editing) PDF document with 4D

[Luc Devar via 4D_Tech]

Oops… disregard my last request, just found that QPDF does it nicely.


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

Locking (restrict Editing) PDF document with 4D

[Luc Devar via 4D_Tech]

I am creating different PDF documents via Rob Laveaux’s QPDF Plugin. I would 
like to restrict editing the document afterward.
Is there a way to do that with 4D or any other plugin?  I can always ask my 
client to open the PDF in Acrobat and hit save as with this option on.
But this extra step that I am trying to avoid.

Anyone ever did something similar ?

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

[MEETING] Montreal 4D Club Meeting

[Thierry Daigneault via 4D_Tech]

The next meeting of the Montreal 4D Club will be held Wednesday January 15th at 
7 PM.


The schedule for the next meeting is as follows:
News
Questions
Presentations
- François Cloutier will have two presentations. The first on the labels 
manager and the second about the web and Orda.
End of the meeting

We usually end up at some sort of restaurant after each meeting. Come and join 
us!



Address
---
Softconcept Canada
4378 Av Pierre-De Coubertin (coin Bennett)
Montréal



Anyone can attend. Please note that the meetings are usually held in French.

If you need more information, you can check out our web page at:
http://www.macapa.com/4dmtl 

You can also write to our communications officer:
Thierry Daigneault: tdaignea...@macapa.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: catalina and 4D

[Cannon Smith via 4D_Tech]

Hi Chunk,

Make sure you are using at least v17.3 HF1. Anything prior to that is rather 
fruitless on a new machine.

HTH.

--
Cannon Smith
Synergy Farm Solutions Inc.



> On Jan 13, 2020, at 3:03 PM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have new laptop that I bought without thinking too hard. It only tuns 
> Catalina. I am trying to run v17.3 and have some issues. Is anyone using 
> catalina and if so what might I do to fix the slowness I am seeing. Should I 
> be using an R  release and if so which one

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

catalina and 4D

[Chuck Miller via 4D_Tech]

Hi All,

I have new laptop that I bought without thinking too hard. It only tuns 
Catalina. I am trying to run v17.3 and have some issues. Is anyone using 
catalina and if so what might I do to fix the slowness I am seeing. Should I be 
using an R  release and if so which one

Thanks and regards


Chuck

 Chuck Miller Voice: (617) 739-0306
 Informed Solutions, Inc. Fax: (617) 232-1064   
 mailto:cjmillerinformed-solutions.com 
 Brookline, MA 02446 USA Registered 4D Developer
   Providers of 4D and Sybase 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)
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: Document encoding

[Koen Van Hooreweghe via 4D_Tech]

Hi Rudy,

IMHO UTF-8 encoding only makes sense in the context of plain text files 
(character based files like txt, csv, tsv, xml, json, html,...). But it has no 
meaning for binary files (PDF, pictures).
xlsx and docx files are essentially zip archives containing a bunch of xml 
files. For xml files UTF-8 is the default encoding. But you (or you customer) 
should not worry about those.

The real problem arises when trying to import and process plain text files. 
Especially for the high character codes. MacRoman encoding of some characters 
is different than eg Latin-1 and those encodings have a limited range.

Unfortunately, as Lutz also mentions, it is not possible to determine in all 
cases the used character encoding when receiving a text file. The BOM is an 
indication for UTF files, but in my experience rarely used. BOM is not required.

FWIW, BBEdit also guesses what the text file encoding could be. It does a good 
job, but it can be fooled.
Eg. create a new file in BBEdit and set the encoding to Windows Latin-1. Enter 
the text ˧ and save the file. Close it and reopen it in BBEdit. It will now 
say UTF-8 and show a different content.

HTH
Koen

> Op 10 jan. 2020, om 22:58 heeft Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com> het volgende geschreven:
> 
> If, e.g., I look at a pdf file in BBEdit, it says ‘Mac Roman’.




Compass bvba
Koen Van Hooreweghe
Kloosterstraat 65
9910 Aalter
Belgium
tel +32 495 511.653

**
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 Authentication not working as expected

[Eric Naujock via 4D_Tech]

Good day,
I have seen that issue as well. I have a function that prior to running 
a backup is saves the users and groups to a blob using user to blob and puts 
them in the database. I have seen this issue where when a restore the users and 
groups the memberships in the groups get botched. This mostly affects new users 
or settings that were changed prior to my uploading the new .4db code. It 
really can make a mess of things if I took a few months to create a new .4db 
file and was working on features. I think the issue may be that while the users 
and groups are replaced the users group memberships are restored to the saved 
values and if anything causes a change or is different the memberships do not 
restore right. 

I am hoping that the new v18 way of holding this data in the JSON file 
will help alleviate the problem since I can use Version tracking on the JSON 
data file to monitor and fix things. But I have not seen how the JSON file 
works since I am not running the v18 beta.

> On Jan 13, 2020, at 10:45 AM, Doug Hall via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I thought I'd replace hand-written code I got from Mark Mitchenall many
> years ago, since 4D had since come out with two commands (since 15.4?)
> which theoretically, would make that code unnecessary -- blob to users and
> users to blob.
> 
> From what I understood, the users, groups, and modifications made by the
> Administrator user would be deleted and replaced upon execution of blob to
> users. Great! I could create a routine which would export those changes
> when bringing down the server, and import them when starting the server!
> 
> Well, as it turns out, for some reason, the modifications (membership)
> changes made by my Administrator changes are not all being retained. I
> tried this two different ways, too: First, by executing blob to users in 4D
> local mode, when signing in as Designer on my development and production
> machines. This way, when I built the resulting compiled structure, it would
> be up-to-date already. The second way, was as I described above, by simply
> executing blob to users in the "on 4D Server Startup" method. Neither
> method retained my change. To test this, I logged in as Administrator and
> simply changed one membership status of a person added by the
> Administrator. The Groups were all added by the Designer user, since I
> don't want these particular groups to ever disappear. Does it matter that
> the groups were created by the Designer? The way the documentation reads,
> any group "created or modified by the administrator" should be affected.
> 
> I am using the latest hotfix of 17.3. Where did I go wrong?
> 
> Thanks,
> Doug
> **
> 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: 4D write pro add a new section.

[Eric Naujock via 4D_Tech]

Thanks, 
I never though about using an insert break to add a new section, or a 
section break. But I could see it now that it's brought to my attention. The 
issue with page numbers may prevent me from using this to get two columns. 
Though it seemed like to most elegant way to accomplish this. I will probably 
fall back to the bad old days of web development and use a table to creat my 
two signature blocks at the end of my document. But I can see where this 
knowledge may come in handy later on. 
I presume then that a new section will also end up add in an effective 
page break at the position since it resets the page count. 

> On Jan 11, 2020, at 9:27 PM, Jeremy French  wrote:
> 
> Hi Eric,
> 
> 
>> I see I can add a new subsection.
> 
> Write Pro subsections pertain to headers and footers, not the document body.
> 
> 
>> …trying to figure out how I would create new sew section object to append to 
>> a document
> 
> Use the command "WP INSERT BREAK" with break type "wk section break”.
> 
> 
>> I see I need to have a second section to change from a one column layout to 
>> a 2 column layout. 
> 
> 
> Beware section breaks currently create a new page, which may not be what you 
> want.
> 
> Documents always start off with a single section numbered 1.
> 
> To figure out what section you are in, use the "WP Get position" command.
> 
> More info at:
> 
> https://doc.4d.com/4Dv17R6/4D/17-R6/WP-INSERT-BREAK.301-4433899.en.html 
> 
> 
> https://doc.4d.com/4Dv17R6/4D/17-R6/WP-Get-position.301-4433868.en.html 
> 
> 
> 
> Best regards,
> Jeremy French
> 
> 
> 

**
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 Authentication not working as expected

[Doug Hall via 4D_Tech]

I thought I'd replace hand-written code I got from Mark Mitchenall many
years ago, since 4D had since come out with two commands (since 15.4?)
which theoretically, would make that code unnecessary -- blob to users and
users to blob.

From what I understood, the users, groups, and modifications made by the
Administrator user would be deleted and replaced upon execution of blob to
users. Great! I could create a routine which would export those changes
when bringing down the server, and import them when starting the server!

Well, as it turns out, for some reason, the modifications (membership)
changes made by my Administrator changes are not all being retained. I
tried this two different ways, too: First, by executing blob to users in 4D
local mode, when signing in as Designer on my development and production
machines. This way, when I built the resulting compiled structure, it would
be up-to-date already. The second way, was as I described above, by simply
executing blob to users in the "on 4D Server Startup" method. Neither
method retained my change. To test this, I logged in as Administrator and
simply changed one membership status of a person added by the
Administrator. The Groups were all added by the Designer user, since I
don't want these particular groups to ever disappear. Does it matter that
the groups were created by the Designer? The way the documentation reads,
any group "created or modified by the administrator" should be affected.

I am using the latest hotfix of 17.3. Where did I go wrong?

Thanks,
Doug
**
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
**

Citrix Playbook

[Douglas Cryer via 4D_Tech]

Hi folks,

Most of our clients connect to their databases over the internet directly with 
4D in client server mode.  We have one client where they have an company 
running their IT and do everything via a Citrix connection.  They have been 
having on-going issues with the connection dropping and causing fairly random 
4D errors on the client.   The latest is "Only one usage of each socket address 
(protocol/network address/port) is usually permitted."

Some of their people have used the system in direct connection mode for days 
and do not experience these disconnects.  So we suspect it is an issue with the 
Citrix setup or the network connection from the Citrix server and the 4D Server.

We do not know Citrix in any detail nor do we have access to their Citrix 
Server.  The IT company has no experience of 4D and are blaming it for the 
issues.

Does anyone have a Citrix playbook that we could read and pass on to them in 
order to establish a more sensible dialog.

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : jdcr...@telekinetix.com  Web : http://www.telekinetix.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
**

AW: Document encoding

[Epperlein, Lutz (agendo) via 4D_Tech]

I think you should first think about what encoding means, in general file 
encoding means the encoding of text files. If you use your code below with pdf 
files you destroy the pdf in a very reliable way, since pdf files are binary 
files. The same is with nearly all picture formats (and with Word and Excel 
files).
But binary files can contain section with text, this text has to be encoded in 
a certain way. To know which sections are to be encoded, you have to consult 
the documentation of the file formats. But usually tools which generate such 
files have options to do this setting by the user.

Regarding the second part of the question, how to detect the current encoding:
This can be a bit cumbersome, since plain text files doesn't have a marker 
which encoding is used. Sometimes there is a so-called BOM in the first bytes 
of the file if it is in Unicode encoding, but you can't rely on it. 
4D can help a bit: If you try to read a text file with the wrong encoding (and 
it contains bytes that can't be decoded) you will get an empty result. But it 
could be possible that the content is decoded in a wrong way and you don't get 
the right result.

Regards 
Lutz


-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Two Way 
Communications via 4D_Tech
Betreff: Document encoding

Hi All,

An important customer of mine has requested that all documents, sent to him, 
are UTF-8 encoded.
This concerns PDF files, text files, Word, Excel, picture files.

I did some tests, but can’t figure out how to do that.

If, e.g., I look at a pdf file in BBEdit, it says ‘Mac Roman’.

Then I tried to open that file in 4D (v17, UTF-8) with document to blob
then:

DOCUMENT TO BLOB(document;$blob)
$DocBlobtxt:=Convert to text(blob;2027)  // 2027 = MacOS Roman  
TEXT TO BLOB($DocBlobtxt;$docblobUTF8;UTF8 text without length)

It seems to do that correctly, but then, this file cannot be opened in preview 
( Opens, but content is blanc)

The other thing is that I need to know the encoding of the file before using 
‘Convert to text’. That is not always possible.

Is this request feasible to start with?

Any ideas how to accomplish that?   


Regards,

Rudy Mortier
Two Way Communications bvba 

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