Mac OS Catalina, V16.6, permissions, etc.

2019-10-31 Thread Robert McKeever via 4D_Tech
Out of necessity, I’ve updated my MacBook Air to Catalina.

I’ve made a stripped down single user version of my app to run on a couple of 
users that updated without asking me about it.

One such client is in Nova Scotia and I have good access to his machine via 
Teamviewer. Since the root level of the hard drive is now ‘off limits’, 
Catalina nicely moved the folders elsewhere. I’ve had to modify several java 
scripts to accommodate the change, and a bit of coding to modify how 4D finds 
and calls the scripts.

No end of trouble with a client here and permissions regarding Teamviewer. 
Kind-of looks like some of the permissions are not sticking. I’ll look into it 
on-site tomorrow.

I’ve had to open all disk access, etc., to the single user app so I can create 
the billing files to be sent to the government so they can get paid. Sure 
doesn’t seem very secure to me that way.

Now for my MacBook Air. 8Gb memory. I’ve been trying to open the source 
database. I’ve gone through two rounds of authorizing the OS to go ahead and 
open plug-ins that were downloaded months ago under 10.14.x. Then 4D has a 
spinning beachball cursor and goes unresponsive. Yet the single user app made 
under 10.14.6 and v16.6 opens fine on the client machines.

I asked my son (a software engineer at Apple in Cupertino who works on stuff he 
can’t tell me about until it is released) about folders at the root level. He 
said, nope, they can’t even do it in development. Even if you hacked a way to 
make the folders at the root level, the next OS Update will move them again.

Anyone else having permission problems with Catalina?
_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.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: How to view PDF's on Windows with 4D V16

2019-10-31 Thread Tim Nevels via 4D_Tech
On Oct 31, 2019, at 2:00 PM, Robert McKeever wrote:

> I’ve tried PDF View, and the PDF’s fail to load. Works fine on the Mac.

This turns out to be a rather complicated and tricky area. 

First, just to get it out of the way, I’ve never had any trouble opening PDFs 
on macOS with Preview. It just works. Doesn’t complain that the PDF is damaged 
or that “an error exists”. Don’t matter if the PDF was created on macOS, on 
Windows with PDFCreator or on Windows with Microsoft Print to PDF (any 
version). No issues on macOS.

But recently I had to deal with a problem where a client reported they could 
not open a PDF generated by 4D that was emailed to them. I could open the PDF 
on macOS no problem. I could also open the PDF on Windows 10 using the default 
Edge web browser. But the PDF would not open using the most current version of 
Acrobat Reader DC. The PDF would open and part of it would display, but not all 
of it. You would receive this message:

“An error exists on this page. Acrobat may not display the page correctly. 
Please contact the person who created the PDF document to correct the problem.”

https://www.dropbox.com/s/wiz1a4ef04xucxg/Acrobat%20Reader%20DC%20Error.PNG?dl=1

The PDF was created by 4D v17.3 HF1, on Windows Server 2016 Datacenter version 
1607 build 14393.2097, and using the built in Microsoft Print to PDF printer 
driver. (All this version info turns out to be important.)

I could reproduce the problem on that machine, but on my development machine 
the PDF created would opened without error in Acrobat Reader DC. My machine was 
Windows 10 Home version 1809 build 17763.775. I had access to several machine 
with different version of Windows that were running the same 4D database, so I 
did a test to see what machines had the problem. 

Windows Server 2016 Datacenter version 1607 build 14393.2097 — error
Windows 10 Home version 1809 build 17763.775 — no problem
Windows 10 Pro version 1803 build 17134.523 — no problem
Windows 10 Home version 1809 build 17763.737 — no problem

I then switched from Microsoft Print to PDF driver on the problem machine and 
used PDF Creator 1.7.3. Problem disappeared. So that became the solution. 

I say all this to let other know a few things I’ve come to realize:

1. Just because a PDF opens on macOS is not a guarantee that it will open on 
Windows with Acrobat Reader DC

2. The default PDF viewer app on Windows 10 is the Edge web browser. It is more 
tolerant to “PDF issues” than Acrobat Reader DC

3. Some versions of Microsoft Print to PDF printer driver are — for lack of a 
better term — sh*tty. It can make PDFs that Acrobat Reader DC cannot open. (Do 
some Googling and you will see other have run into this too.) 

4. Some versions of Microsoft Print to PDF printer driver are better than 
others. And Microsoft does not provide a way to download Microsoft Print to PDF 
printer driver separately. It is part of a Windows install or update.

5. The exact same PDF created from the same 4D app on the same machine using 
PDF Creator is usually many times smaller — 8 times smaller in this case — than 
the one created by Microsoft Print to PDF. (PDF Creator PDF size = 42KB, 
Microsoft Print to PDF PDF size = 340KB)

So it’s not always what program you use to view a PDF that can be the problem. 
It is what PDF printer driver was used to create it, and which version of that 
driver that you use. 

Tim

*
Tim Nevels
Innovative Solutions
785-749-3444
timnev...@mac.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
**

4 write pro and rulers

2019-10-31 Thread Charles Miller via 4D_Tech
Hi All,

In working on conversion to write pro from 4d write, I can't figure
out how to copy ruler programmatically The 4D write version can do
this. How do I do this in write pro



-- 
-
 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 Server connectivity
  https://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: How to view PDF's on Windows with 4D V16

2019-10-31 Thread Charles Miller via 4D_Tech
I use open url on windows. It opens I web page or default reader depending
upon settings

Regards

Chuck

On Thu, Oct 31, 2019 at 11:07 AM Robert McKeever via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> I’ve tried PDF View, and the PDF’s fail to load. Works fine on the Mac.
>
> Any ideas?
> _
> Bob McKeever  http://www.mswl.com <
> http://www.mswl.com/>
> McKeever's Software Wizardry
> Port Coquitlam, B.C.
> bobmckee...@mac.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
> **

-- 
-
 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 Server connectivity
  https://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
**

How to view PDF's on Windows with 4D V16

2019-10-31 Thread Robert McKeever via 4D_Tech
I’ve tried PDF View, and the PDF’s fail to load. Works fine on the Mac.

Any ideas?
_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.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: VP IMPORT DOCUMENT in v17R6

2019-10-31 Thread Jeremy Roussak via 4D_Tech
I’m slightly surprised to have had no response to this, but maybe nobody is 
using VP IMPORT DOCUMENT, at least on Macs.

I have submitted a bug report: the command is broken in R16.

Jeremy

> On 30 Oct 2019, at 13:49, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Here’s a minuscule database and a version of the xlsx file, with useful data 
> removed.
> 
>   https://www.dropbox.com/s/ls7e695n046y63f/vp%20test.zip?dl=1 
> 
> 
> Open “Form1” and run it. Choose “test.xlsx”.
> 
> Under R5, it loads. Under R6, it doesn’t. 
> 
> Am I missing something? How do I report a bug?
> 
> Jeremy
> 
>> On 30 Oct 2019, at 11:34, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Forgot to mention: the document is a simple xlsx Excel document, with four 
>> sheets, 23k in size.
>> 
>> Jeremy
>> 
>>> On 30 Oct 2019, at 11:30, Jeremy Roussak via 4D_Tech <4d_tech@lists.4d.com> 
>>> wrote:
>>> 
>>> I call VP IMPORT DOCUMENT(“vp”;Form.path) in the On VP Ready form event. 
>>> Form.path contains a path in Mac system format, colon-delimited.
>>> 
>>> In v17R5, it works fine. In R6, on the same document, I get an empty 
>>> spreadsheet. No error; just an empty sheet.
>>> 
>>> Mac, Mojave.
>>> 
>>> Any suggestions gratefully received.
>>> 
>>> Jeremy
**
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
**