Re: QuickBooks / PowerShell Question for John Baughman

[Ken Eyring via 4D_Tech]

I am so sorry to hear that. John was a really nice person, always very 
helpful.


Thank you for letting me know.

Ken



On 03/05/23 5:03 PM, Douglas von Roeder via 4D_Tech wrote:

Ken:

John passed away
<https://www.dignitymemorial.com/obituaries/kaneohe-hi/john-baughman-10298943>
a few years ago.

--
Douglas von Roeder
949-910-4084


On Sun, Mar 5, 2023 at 9:47 AM Ken Eyring via 4D_Tech <4d_tech@lists.4d.com>
wrote:


A couple of years ago, John Baughman provided me with some code that
replaced Myles Wakeman's QuickBooks 4D plugin. I got it to work in my
office environment, but when I finally went to deploy the new code at my
customer's location - I received an error that appears to be related to
PowerShell - which his code is dependent upon.

I tried to reach out to John directly, but an email to his previous
email address was rejected.  Does anyone know how I can get a hold of him?

Thanks,
Ken
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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)
New Forum: https://discuss.4D.com
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)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

QuickBooks / PowerShell Question for John Baughman

[Ken Eyring via 4D_Tech]

A couple of years ago, John Baughman provided me with some code that 
replaced Myles Wakeman's QuickBooks 4D plugin. I got it to work in my 
office environment, but when I finally went to deploy the new code at my 
customer's location - I received an error that appears to be related to 
PowerShell - which his code is dependent upon.


I tried to reach out to John directly, but an email to his previous 
email address was rejected.  Does anyone know how I can get a hold of him?


Thanks,
Ken
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: File Excel created from 4D

[Ken Eyring via 4D_Tech]

I use the Pluggers plugin for some simple excel document control. It 
does work very well.


Ken


On 09/14/21 11:05 AM, Pat Bensky via 4D_Tech wrote:

We use
https://www.pluggers.nl/product/xl-plugin/

Pat

On Tue, 14 Sept 2021 at 15:32, Koen Van Hooreweghe via 4D_Tech <
4d_tech@lists.4d.com> wrote:


Hi Ferdinando,

It depends of what your needs are.

The very basic is a tab delimited txt file or an csv file which you can
open/import in Excel. No formatting.

Second option is to create a text file containing a html formatted table
usingtags. Formatting possible using css. Can be easily
imported in Excel too.

Third possibility is to use 4D View Pro, which has an export to Excel. 4D
native, but license required.
Op 14 sep. 2021, om 16:20 heeft stardata.info via 4D_Tech <

4d_tech@lists.4d.com> het volgende geschreven:


I need to create an excel file from 4D application.

Someone know how i can do?





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

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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)
New Forum: https://discuss.4D.com
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: Looking to Replace Specific Win32API Commands to enable smooth upgrade to v17

[Ken Eyring via 4D_Tech]

Hi Jody,

I haven't read the documentation on printing in a while - especially for 
Windows.  I have done something similar for Macs to what I think you are 
suggesting for Windows.  For Macs, I select a printer from a printers 
list, then call the page setup and save it for that printer for each 
work station.  Then I can switch between each printer on the fly for 
various types of reports that need to be printed to specific printers 
and trays.


I had a rube goldberg way of making this work with Windows - but maybe 
there is a better way to do that now with the new functionality you 
mentioned.  I'll take a look, thanks!


**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Looking to Replace Specific Win32API Commands to enable smooth upgrade to v17

[Ken Eyring via 4D_Tech]

Thank you Chip!

Unfortunately, I tried to download what I thought was the latest version 
of Win32API and it was compiled back in Nov 7, 2019 at 12:13p.


That version does not work with v17.3HF2 32-bit Client (with a 64-bit 
server).  At least on my end it doesn't.


I also thought I saw someone said Orchard Software was not going to 
update the Win32API to work with v17... which is why I'm looking for an 
alternative.


I'll have to take a look at the internal 4D Window commands and see what 
it takes to convert over the Win32API code to the 4D native code.


I was hoping not to have to do that... as my first look indicates it may 
take some time to get things working as they were with the Win32API plugin.


Thank you for your thoughts!
Ken



On 04/04/21 7:34 PM, nug wrote:

Ken,
I am not sure but I think there is a v17/18 compatible version of Win32api

in addition, there are native 4D commands which do many those tasks,
at least for windows inside 4D,
(not the commands but the areas covered)
Window rectangle
front most window

not sure what restrict does, but you set window types to control window 
appearance and behavior

I think you can also get and set default printer - but never did this myself.


Chip


On Apr 4, 2021, at 4:58 PM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> wrote:

I am looking to replace the following Win32API commands as I migrate from v15 
to V17 on Windows. Any help is greatly appreciated.

Window Commands:

gui_GetWndRect
sys_GetWindowMetrics
gui_GetWindow
gui_RestrictWindow
gui_SetWndRect
gui_RestrictWindow
gui_SubClassInit

Printing Commands:

sys_SetDefPrinter
sys_GetDefPrinter

Thank you,
Ken

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Looking to Replace Specific Win32API Commands to enable smooth upgrade to v17

[Ken Eyring via 4D_Tech]

I am looking to replace the following Win32API commands as I migrate 
from v15 to V17 on Windows. Any help is greatly appreciated.


Window Commands:

gui_GetWndRect
sys_GetWindowMetrics
gui_GetWindow
gui_RestrictWindow
gui_SetWndRect
gui_RestrictWindow
gui_SubClassInit

Printing Commands:

sys_SetDefPrinter
sys_GetDefPrinter

Thank you,
Ken

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Foundation Upgrade Question

[Ken Eyring via 4D_Tech]

Thanks Randy, I have that utility from when I upgraded another 
application.  The conversion tool was extremely helpful.

I appreciate you help!


On 02/02/21 5:50 PM, Randy Kaempen wrote:

Ken,

On Feb 2, 2021, at 4:43 PM, Ken Geiger Gmail via 4D_Tech 
<4d_tech@lists.4d.com > wrote:


The foundation for 4D v16 and above is v5.7. This version eliminates 
the PICTS.


Keep in mind that if your database contains PICTs on forms, you need to 
fix that by the 32 bit v16 before going to 64 bit v16 or any later versions.


JPR has a tool and instructions for how to convert the PICTs and I have 
used it numerous times.  It’s much faster than trying to do it by hand.



Randy Kaempen
Intellex Corporation


**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Foundation Upgrade Question

[Ken Eyring via 4D_Tech]

Thanks Guy!

I went onto the foundationshell.coom website and it looks like the 
component for 4D v15.x is the same component for v17.x and v18.x - so 
I'm hoping that I should be all set for now (regarding Foundation).  I 
still need to deal with a few other considerations before I can try to 
build a v17 version of the database.


I appreciate the offer for help!

Best regards,
Ken



On 02/02/21 2:31 PM, Guy Algot wrote:

Hey Ken,

I’m very similar to Randy. Used it for many years and it is in all my 
projects.


I’ve also done many upgrades from older versions of Foundation to a 
version that supports v17 & v18 so if you need help, let me know.


On Feb 2, 2021, at 11:13 AM, Ken Eyring via 4D_Tech 
<4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> wrote:


I am not at all familiar with Foundation.

I inherited a customer that has a 4D database that is currently 
compiled with 4D v15.1.  That database uses the Foundation_560.4dbase 
component.


I'd like to upgrade the customer to v17.3HF2 (and eventually to v18).

I'd like to know if the component that is currently being used 
(mentioned above) will work with 4D v17.3HF2 (and v18.x)?


Thanks in advance!
Ken

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

**



Later,

Guy


--

Guy Algot, Solutions Specialist

Edmonton, Alberta

(780) 974-8538


hardware, installation, training, support, programming, internet

specializing in 4th Dimension

=-= =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

"Microsoft is a cross between the Borg and the Ferengi. Unfortunately,

they use Borg to do their marketing and Ferengi to do their programming."

-- Simon Slavin





**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Anyone Heard of the Component called iLB_Component_v15?

[Ken Eyring via 4D_Tech]

Thank you very much!



On 02/02/21 1:31 PM, Gerald Balzer (neu) via 4D_Tech wrote:

That’s Listmagic. A component for easier listbox handling. to my knowledge 
barc...@icomponline.com was the developer.

Cheers

Gerald

BALZER COMPUTING • Breitensteinstr. 88 • CH-8037 Zürich • Tel.: +41-44-4404605 
• Fax: +41-44-4404609
Mitglied im Entwicklernetzwerk die4dWerkstatt


Am 02.02.2021 um 19:26 schrieb Ken Eyring via 4D_Tech <4d_tech@lists.4d.com>:

I inherited a customer that has a 4D database that is currently compiled with 
4D v15.1.  That database uses a component called iLB_Component_v15.

I did a search on the 4D website and via the web and nothing came up. Has 
anyone heard of this component?  I'd like to upgrade the customer to 4D 
v17.3HF2 and eventually to v18.x.

Thanks in Advance for your help!
Ken

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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)
New Forum: https://discuss.4D.com
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)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Anyone Heard of the Component called iLB_Component_v15?

[Ken Eyring via 4D_Tech]

I inherited a customer that has a 4D database that is currently compiled 
with 4D v15.1.  That database uses a component called iLB_Component_v15.


I did a search on the 4D website and via the web and nothing came up. 
Has anyone heard of this component?  I'd like to upgrade the customer to 
4D v17.3HF2 and eventually to v18.x.


Thanks in Advance for your help!
Ken

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

Foundation Upgrade Question

[Ken Eyring via 4D_Tech]

I am not at all familiar with Foundation.

I inherited a customer that has a 4D database that is currently compiled 
with 4D v15.1.  That database uses the Foundation_560.4dbase component.


I'd like to upgrade the customer to v17.3HF2 (and eventually to v18).

I'd like to know if the component that is currently being used 
(mentioned above) will work with 4D v17.3HF2 (and v18.x)?


Thanks in advance!
Ken

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Any Success Running 4D v13.6 on Win 10 Pro?

[Ken Eyring via 4D_Tech]

Thank you everyone who responded.  We tried to disable DEP and that did 
not solve the issue.


The first time the issue arose, it looked like it was running as a 
service - (the status said it was running), but no one could log into 
the built server.  Clients would receive a -10002 error.


Because the application was needed for production and they were already 
down for a day+, they reverted back to Win 7.


I'm looking into upgrading their application to the latest version of 4D.

This list has been a wonderful resource during my many years of using 
4D.  I don't come here often, but when I do... I always find excellent 
advice.  As always, my sincere thanks to all who share their knowledge.


Best regards,
Ken


On 01/19/21 11:05 AM, Randy Jaynes wrote:
Depending on where you have the built application installed, Windows may 
be moving the app into a ‘protected folder’ as the application is 
starting up, effectively pulling the carpet out from under your application.


I would suspect something like this if it’s in one of the Program Files 
folders.


Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com <http://printpoint.com> • 845.687.3741 
• PrintPoint, Inc • 57 Ludlow Lane • Palisades, NY 10964




*Please send all emails to supp...@printpoint.com 
<mailto:supp...@printpoint.com>*





On Jan 19, 2021, at 10:47 AM, Ken Eyring via 4D_Tech 
<4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> wrote:


I'm trying to help out a user of a 4D v13.6 Built Server.  They 
upgraded from Win 7 to Win 10 Pro without asking - and the built 
server will not run.


Ken Geiger said he believed 4D v13 and Win 10 Pro were not compatible. 
Thanks Ken!


Before I tell the end user that they need to either upgrade their 4D 
application or revert back to Win 7... Has anyone had success running 
v13.6 on Win 10 Pro?



**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Need Help! - Customer upgraded from Win 7 to Win 10 Pro. 4D v13.6 Built Server Won't Run

[Ken Eyring via 4D_Tech]

Thank you everyone who responded.  We tried to disable DEP and that did 
not solve the issue.


The first time the issue arose, it looked like it was running as a 
service - (the status said it was running), but no one could log into 
the built server.  Clients would receive a -10002 error.


Because the application was needed for production and they were already 
down for a day+, they reverted back to Win 7.


I'm looking into upgrading their application to the latest version of 4D.

This list has been a wonderful resource during my many years of using 
4D.  I don't come here often, but when I do... I always find excellent 
advice.  As always, my sincere thanks to all who share their knowledge.


Best regards,
Ken




On 01/19/21 7:35 PM, Kevin Abraham wrote:

We run v13.5 on Win 10 on just not on the Server End. If you are running a 4D 
Server on Win 10 as opposed to Win Server, I would check that there was Windows 
where you had to open up ports in the Win Fire Wall and also allow for Code 
Execution from a separate file.

Thanks,
Kevin Abraham
Digital Retirement Solutions
kabra...@drs401k.com



On Jan 19, 2021, at 8:39 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
wrote:

It crossed my mind that v13 may not run on Win 10 Pro.

The upgrade from Windows 7 was done without my knowledge - or I would have 
asked this list for previous experiences.

Thanks,
Ken




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

Any Success Running 4D v13.6 on Win 10 Pro?

[Ken Eyring via 4D_Tech]

I'm trying to help out a user of a 4D v13.6 Built Server.  They upgraded 
from Win 7 to Win 10 Pro without asking - and the built server will not 
run.


Ken Geiger said he believed 4D v13 and Win 10 Pro were not compatible. 
Thanks Ken!


Before I tell the end user that they need to either upgrade their 4D 
application or revert back to Win 7... Has anyone had success running 
v13.6 on Win 10 Pro?


Thanks,
Ken

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Need Help! - Customer upgraded from Win 7 to Win 10 Pro. 4D v13.6 Built Server Won't Run

[Ken Eyring via 4D_Tech]

It crossed my mind that v13 may not run on Win 10 Pro.

The upgrade from Windows 7 was done without my knowledge - or I would 
have asked this list for previous experiences.


Thanks,
Ken





On 01/19/21 10:36 AM, Kenneth Geiger wrote:

I believe that 4D v13 and Win10 are not really compatible. I also believe that 
4D v15 is the oldest version supported on Win10.


On Jan 19, 2021, at 8:21 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
wrote:

I am trying to help a business that has a Built 4D Server (v13.6) that was 
developed by another developer.

It was running fine on Friday - while running on Win 7.

Their IT upgraded the server OS to Win 10 Pro, Windows Experience Pack 
120.2212.551.0.

When I attempt to launch the built server after the Windows upgrade, I get a prompt “No 
data file was found”.  I choose the "Open" option and navigate to the data 
file, but after selecting the data file I get a runtime error message “Cannot open 
structure of database”

When I try to launch the built application again and choose to "Create" a data 
file (to see if that would allow the built server to run) - I get the same error message 
that the structure cannot be opened.

I’m not a Windows expert - and any help that can be provided is very much 
appreciated!
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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)
New Forum: https://discuss.4D.com
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: Need Help! - Customer upgraded from Win 7 to Win 10 Pro. 4D v13.6 Built Server Won't Run

[Ken Eyring via 4D_Tech]

Thank you for responding.

The structure and data files are NOT set to Read Only.  They are read-write.

Any other suggestions are greatly appreciated.  I'm at a loss...

I'm assuming that v13.6 should run on Win 10 Pro.



On 01/19/21 10:27 AM, Spencer Hinsdale wrote:


Does this maybe mean the Structure is locked?  Restart the computer to release 
any hold Windows has on it.  Get Properties and change Permissions as needed.  
Set the preference inside 4D Server to Allow Read Only Structure...



On 1/19/21, 7:21 AM, "4D_Tech on behalf of Ken Eyring via 4D_Tech" 
<4d_tech-boun...@lists.4d.com on behalf of 4d_tech@lists.4d.com> wrote:

  “Cannot open structure of database”



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

Need Help! - Customer upgraded from Win 7 to Win 10 Pro. 4D v13.6 Built Server Won't Run

[Ken Eyring via 4D_Tech]

I am trying to help a business that has a Built 4D Server (v13.6) that 
was developed by another developer.


It was running fine on Friday - while running on Win 7.

Their IT upgraded the server OS to Win 10 Pro, Windows Experience Pack 
120.2212.551.0.


When I attempt to launch the built server after the Windows upgrade, I 
get a prompt “No data file was found”.  I choose the "Open" option and 
navigate to the data file, but after selecting the data file I get a 
runtime error message “Cannot open structure of database”


When I try to launch the built application again and choose to "Create" 
a data file (to see if that would allow the built server to run) - I get 
the same error message that the structure cannot be opened.


I’m not a Windows expert - and any help that can be provided is very 
much appreciated!

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Can't Disable Catalina Prompt "Do you want the Applicaiton "ApplicationName" to accept incoming network connections?

[Ken Eyring via 4D_Tech]

I will try to place the built app in the Applications folder to see if 
that remedies the issue.


Thank you to all who have responded!


On 08/24/20 2:30 AM, Bernd Fröhlich via 4D_Tech wrote:

Ken Eyring:


No, I put the built application into another folder.  Should that make a
difference?


When you drag an application into the applications folder, gatekeeper asks you 
for your admin credentials and removes any quarantine bits from the app.
After that is done you should be able to put the app whereever you like.

Greetings from Germany,
Bernd Fröhlich

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Can't Disable Catalina Prompt "Do you want the Applicaiton "ApplicationName" to accept incoming network connections?

[Ken Eyring via 4D_Tech]

No I did not.  Why would that cause this problem I described below?

Thank you,
Ken



On 08/18/20 10:05 AM, Robert McKeever via 4D_Tech wrote:

Before you built the app, probably before you compiled the app, did you disable 
the web server upon startup and the SQL server upon startup under Database 
Settings?


On Aug 17, 2020, at 9:02 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
wrote:

I've compiled and built a standalone version of my 4D database (with v17.3HF2), and every 
time that I run it on Mac OS X 10.15.5 (Catalina), I get a prompt "Do you want the 
Application 'ApplicationName' to accept incoming network connections?"

I click "Yes" and the application opens.  I have also added the name of my standalone 
application into the Security & Privacy control panel as an exception to "allow incoming 
connections"... but I still get the prompt every time I open the application.

Any suggestions on what I need to do to get the prompt to stop popping up is 
greatly appreciated.

Thank you,
Ken


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


_
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)
New Forum: https://discuss.4D.com
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)
New Forum: https://discuss.4D.com
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: Can't Disable Catalina Prompt "Do you want the Applicaiton "ApplicationName" to accept incoming network connections?

[Ken Eyring via 4D_Tech]

No, I put the built application into another folder.  Should that make a 
difference?


Thank you for your thoughts,
Ken




On 08/18/20 2:27 AM, Bernd Fröhlich via 4D_Tech wrote:

Ken Eyring:


I've compiled and built a standalone version of my 4D database (with
v17.3HF2), and every time that I run it on Mac OS X 10.15.5 (Catalina),
I get a prompt "Do you want the Application 'ApplicationName' to accept
incoming network connections?"

I click "Yes" and the application opens.  I have also added the name of
my standalone application into the Security & Privacy control panel as
an exception to "allow incoming connections"... but I still get the
prompt every time I open the application.

Any suggestions on what I need to do to get the prompt to stop popping
up is greatly appreciated.



Did you move the app into the applications-folder?
**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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)
New Forum: https://discuss.4D.com
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: Can't Disable Catalina Prompt "Do you want the Applicaiton "ApplicationName" to accept incoming network connections?

[Ken Eyring via 4D_Tech]

I did not code sign and notarize the application.  I'm not familiar with 
how to do that.  Is there a list of instructions somewhere that explains 
how to do this?


But... even though I do want to distribute the built app to a customer, 
the problem occurred on my computer as well.


Thank you for your thoughts,
Ken




On 08/17/20 4:06 PM, Keisuke Miyako via 4D_Tech wrote:

Did you code sign and notarise your application?

These are mandatory steps to distribute an app over the internet.

2020/08/18 1:02、Ken Eyring via 4D_Tech 
<4d_tech@lists.4d.com<mailto:4d_tech@lists.4d.com>>のメール:
Any suggestions on what I need to do to get the prompt to stop popping up is 
greatly appreciated.

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Can't Disable Catalina Prompt "Do you want the Applicaiton "ApplicationName" to accept incoming network connections?

[Ken Eyring via 4D_Tech]

I've compiled and built a standalone version of my 4D database (with 
v17.3HF2), and every time that I run it on Mac OS X 10.15.5 (Catalina), 
I get a prompt "Do you want the Application 'ApplicationName' to accept 
incoming network connections?"


I click "Yes" and the application opens.  I have also added the name of 
my standalone application into the Security & Privacy control panel as 
an exception to "allow incoming connections"... but I still get the 
prompt every time I open the application.


Any suggestions on what I need to do to get the prompt to stop popping 
up is greatly appreciated.


Thank you,
Ken


**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Pluggers XL_Plugin Format Question

[Ken Eyring via 4D_Tech]

Awesome, thank you!



On 05/28/20 1:46 AM, lists via 4D_Tech wrote:

Ken,

You build the format and assign the different attributes to it (one of which 
can be the locked flag, a font etc).

$ YourDefinedFormat:=xlBookAddFormat ($xlBook)
$font:=xlBookAddFont ($xlBook)
xlFormatSetFont ($YourDefinedFormat;$font)
xlFontSetName ($font;"Arial")
xlFontSetSize ($font;10)
xlFormatSetLocked( $YourDefinedFormat; 1 )

Then, when you assign a cell value, you also assign the format as in:

xlSheetSetCellNumber ($sheet;$row;$col;$cellData;$YourDefinedFormat)

HTH

Lahav


**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Pluggers XL_Plugin Format Question

[Ken Eyring via 4D_Tech]

Thanks for responding Doug.

I looked at the code but did not see anything that jumped out at me 
regarding formatting.


I look forward to seeing your sample code when you have a chance!  Very 
much appreciated!


Ken



On 05/27/20 9:41 PM, Douglas von Roeder via 4D_Tech wrote:

Ken:

I haven’t used that particular format but I suspect that it is used like
the other formats. If you haven’t created formats, check the code in the
demo. It’s not extensive but, if you hold your head just right, things will
make sense.

At the moment, I’m away from a computer but I’ll post some code in the AM.

On Wed, May 27, 2020 at 6:03 PM Ken Eyring via 4D_Tech <4d_tech@lists.4d.com>
wrote:


I'm taking a look at buying the Pluggers XL_Plugin and most of my test
went very quickly.  Looks like a spectacular plugin.

It was real easy to open a spreadsheet and insert values into specific
cells.

I ran into some confusion though, when I tried to set a cell's format,
e.g. to Locked, or change the font name or font size, etc...

Here are the instructions for xlFormatSetLocked, but I'm not sure what
to pass in:

xlFormatSetLocked( format ; locked )
→ longint → integer
Sets the locked protection property: 1 - true, 0 - false.

I expected to define a sheet, row and column to identify the cell I
wanted to set the format for - but I don't see how to define which cell
I want to affect.

If someone wouldn't mind sending a simple snippet of code that shows how
to set a specific cell's format using this plugin I would really
appreciate it.

Thanks,
Ken

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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)
New Forum: https://discuss.4D.com
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Pluggers XL_Plugin Format Question

[Ken Eyring via 4D_Tech]

I'm taking a look at buying the Pluggers XL_Plugin and most of my test 
went very quickly.  Looks like a spectacular plugin.


It was real easy to open a spreadsheet and insert values into specific 
cells.


I ran into some confusion though, when I tried to set a cell's format, 
e.g. to Locked, or change the font name or font size, etc...


Here are the instructions for xlFormatSetLocked, but I'm not sure what 
to pass in:


xlFormatSetLocked( format ; locked )
→ longint → integer
Sets the locked protection property: 1 - true, 0 - false.

I expected to define a sheet, row and column to identify the cell I 
wanted to set the format for - but I don't see how to define which cell 
I want to affect.


If someone wouldn't mind sending a simple snippet of code that shows how 
to set a specific cell's format using this plugin I would really 
appreciate it.


Thanks,
Ken

**
4D Internet Users Group (4D iNUG)
New Forum: https://discuss.4D.com
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: Poor Image Quality When Converting Pict Image to JPG and TIF Using CONVERT PICTURE (SOLVED)

[Ken Eyring via 4D_Tech]

Hi Chuck,

Thank you for raising the potential issues with Windows.  As you pointed 
out - I cannot view on Windows the PDF images in a form that displays 
the image field, and I cannot print the images using a variable.


I do not have these issues with Mac OS X, but some of my customers are 
cross platform, so it appears I still have an issue to get the images 
properly converted so they can be used on both platforms.


Tom Benedict sent me a conversion component that I'll have to try later 
today when I can find the time.


It's always something...

Thanks again!
Ken




On 02/07/20 9:54 AM, Charles Miller via 4D_Tech wrote:

Hi ken. I assume you hav no PCs that uses this database. If you do viewing
PDFs may not yield the same result. You also as far as.i know can’t display
in a picture variable or print them in a picture variable

Chuck
On Fri, Feb 7, 2020 at 6:36 AM Ken Eyring via 4D_Tech <4d_tech@lists.4d.com>
wrote:


Converting to PDF instead of PNG, JPG or TIF solved the blurry issue.

Thank you very much!



On 02/06/20 4:25 PM, Keisuke Miyako via 4D_Tech wrote:

Hello,

PICT is a container format, it can contain either raster or vectorial

images.

it sounds like you have vectorial images.

on Mac, you can use the command to convert PICT to PDF,
which will result in "sharp" images.

otherwise you need to scale up the image before converting it to a

rasterised image such as PNG, TIF or JPG.






On Feb 7, 2020, at 2:00, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com>

wrote:


CONVERT PICTURE([Logos]Logo;".TIF")

I also get the same issue when trying to convert to jpg:

CONVERT PICTURE([Logos]Logo;".JPG")

Any thoughts how I can best convert the images in my data file without

losing any quality?


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



**
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: Poor Image Quality When Converting Pict Image to JPG and TIF Using CONVERT PICTURE (SOLVED)

[Ken Eyring via 4D_Tech]

Converting to PDF instead of PNG, JPG or TIF solved the blurry issue.

Thank you very much!



On 02/06/20 4:25 PM, Keisuke Miyako via 4D_Tech wrote:

Hello,

PICT is a container format, it can contain either raster or vectorial images.
it sounds like you have vectorial images.

on Mac, you can use the command to convert PICT to PDF,
which will result in "sharp" images.

otherwise you need to scale up the image before converting it to a rasterised 
image such as PNG, TIF or JPG.





On Feb 7, 2020, at 2:00, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> wrote:

CONVERT PICTURE([Logos]Logo;".TIF")

I also get the same issue when trying to convert to jpg:

CONVERT PICTURE([Logos]Logo;".JPG")

Any thoughts how I can best convert the images in my data file without losing 
any quality?


**
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: Poor Image Quality When Converting Pict Image to JPG and TIF Using CONVERT PICTURE

[Ken Eyring via 4D_Tech]

Hi Tom,

I took a look at the methods that are available in the component you 
sent.  It's not clear to me what I need to do in order to convert the 
image format of an image that is stored in a picture field.


Is there any documentation available?

Thanks again,
Ken




On 02/06/20 1:15 PM, Tom Benedict wrote:

You should be able to automate conversion of most PICTs using JPR’s 
PICT_Convert. However, if you have static PICTs pasted directly onto forms, 
those will need to be individually visited. A v17 MSC log will give you a 
listing of those, I think.

Tom Benedict


On Feb 6, 2020, at 09:40, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> wrote:

Hi Steve,

I tried converting the images to .jpg. ipng and .tif using CONVERT PICTURE.  
Each format I tried resulted in blurry images.

To follow up on your question... I opened up a window that displayed one of the 
images that is stored in a field.  I copied the image into Preview on a Mac, 
then saved it as a .png file format.  That worked fine.

To verify, I then copied the .png image back into my 4D database and saved it.  
That image was also stored properly -- without being blurry.

I have a work around for changing the format of the images, but I really don't 
want to do this one-by-one for each image that is in every customer database 
that will eventually need to be updated.

Any suggestions are greatly appreciated.

Thanks,
Ken




**
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: Poor Image Quality When Converting Pict Image to JPG and TIF Using CONVERT PICTURE

[Ken Eyring via 4D_Tech]

Thanks Steve.  I appreciate your taking the time to help.



On 02/06/20 1:25 PM, Stephen J. Orth wrote:

Ken,

The reason for my question was to determine if this was something related to 
the 4D command.  If you can convert the image properly, external of 4D, then is 
seems to be something in the way 4D does the conversion.

Unfortunately I have no suggestions because we always do image 
design/manipulation outside of 4D, so as to achieve the best image quality.


Steve

-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Ken Eyring via 4D_Tech
Sent: Thursday, February 6, 2020 11:41 AM
To: '4D iNug Technical' <4d_tech@lists.4d.com>
Cc: Ken Eyring 
Subject: Re: Poor Image Quality When Converting Pict Image to JPG and TIF Using 
CONVERT PICTURE

Hi Steve,

I tried converting the images to .jpg. ipng and .tif using CONVERT PICTURE.  
Each format I tried resulted in blurry images.

To follow up on your question... I opened up a window that displayed one of the 
images that is stored in a field.  I copied the image into Preview on a Mac, 
then saved it as a .png file format.  That worked fine.

To verify, I then copied the .png image back into my 4D database and saved it.  
That image was also stored properly -- without being blurry.

I have a work around for changing the format of the images, but I really don't 
want to do this one-by-one for each image that is in every customer database 
that will eventually need to be updated.

Any suggestions are greatly appreciated.

Thanks,
Ken




**
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: Poor Image Quality When Converting Pict Image to JPG and TIF Using CONVERT PICTURE

[Ken Eyring via 4D_Tech]

I want to clarify a typo...

The formats I tried to convert to were ".jpg", ".png", and ".tif".  I 
wrote "ipng" below for "png" format.





On 02/06/20 12:40 PM, Ken Eyring via 4D_Tech wrote:

Hi Steve,

I tried converting the images to .jpg. ipng and .tif using CONVERT 
PICTURE.  Each format I tried resulted in blurry images.


To follow up on your question... I opened up a window that displayed one 
of the images that is stored in a field.  I copied the image into 
Preview on a Mac, then saved it as a .png file format.  That worked fine.


To verify, I then copied the .png image back into my 4D database and 
saved it.  That image was also stored properly -- without being blurry.


I have a work around for changing the format of the images, but I really 
don't want to do this one-by-one for each image that is in every 
customer database that will eventually need to be updated.


Any suggestions are greatly appreciated.

Thanks,
Ken





On 02/06/20 12:07 PM, Stephen J. Orth wrote:

Ken,

Just curious...

Do you get different results if you use a graphic's application for 
the conversion?



Steve


-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Ken Eyring 
via 4D_Tech

Sent: Thursday, February 6, 2020 11:00 AM
To: 4d_tech@lists.4d.com
Cc: Ken Eyring 
Subject: Poor Image Quality When Converting Pict Image to JPG and TIF 
Using CONVERT PICTURE


I have a table that stores all of the images that are used on reports 
and labels, and some of them are PICT format.  Since this format is 
not supported on 64-bit, I want to convert them in v15 prior to 
migrating over to v17 64-bit.  However, when I call the following line 
of code, the resulting image is blurry.


CONVERT PICTURE([Logos]Logo;".TIF")

I also get the same issue when trying to convert to jpg:

CONVERT PICTURE([Logos]Logo;".JPG")

Any thoughts how I can best convert the images in my data file without 
losing any quality?


Thanks,
Ken


**
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: Poor Image Quality When Converting Pict Image to JPG and TIF Using CONVERT PICTURE

[Ken Eyring via 4D_Tech]

Hi Steve,

I tried converting the images to .jpg. ipng and .tif using CONVERT 
PICTURE.  Each format I tried resulted in blurry images.


To follow up on your question... I opened up a window that displayed one 
of the images that is stored in a field.  I copied the image into 
Preview on a Mac, then saved it as a .png file format.  That worked fine.


To verify, I then copied the .png image back into my 4D database and 
saved it.  That image was also stored properly -- without being blurry.


I have a work around for changing the format of the images, but I really 
don't want to do this one-by-one for each image that is in every 
customer database that will eventually need to be updated.


Any suggestions are greatly appreciated.

Thanks,
Ken





On 02/06/20 12:07 PM, Stephen J. Orth wrote:

Ken,

Just curious...

Do you get different results if you use a graphic's application for the 
conversion?


Steve


-Original Message-
From: 4D_Tech <4d_tech-boun...@lists.4d.com> On Behalf Of Ken Eyring via 4D_Tech
Sent: Thursday, February 6, 2020 11:00 AM
To: 4d_tech@lists.4d.com
Cc: Ken Eyring 
Subject: Poor Image Quality When Converting Pict Image to JPG and TIF Using 
CONVERT PICTURE

I have a table that stores all of the images that are used on reports and 
labels, and some of them are PICT format.  Since this format is not supported 
on 64-bit, I want to convert them in v15 prior to migrating over to v17 64-bit. 
 However, when I call the following line of code, the resulting image is blurry.

CONVERT PICTURE([Logos]Logo;".TIF")

I also get the same issue when trying to convert to jpg:

CONVERT PICTURE([Logos]Logo;".JPG")

Any thoughts how I can best convert the images in my data file without losing 
any quality?

Thanks,
Ken


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

Poor Image Quality When Converting Pict Image to JPG and TIF Using CONVERT PICTURE

[Ken Eyring via 4D_Tech]

I have a table that stores all of the images that are used on reports 
and labels, and some of them are PICT format.  Since this format is not 
supported on 64-bit, I want to convert them in v15 prior to migrating 
over to v17 64-bit.  However, when I call the following line of code, 
the resulting image is blurry.


CONVERT PICTURE([Logos]Logo;".TIF")

I also get the same issue when trying to convert to jpg:

CONVERT PICTURE([Logos]Logo;".JPG")

Any thoughts how I can best convert the images in my data file without 
losing any quality?


Thanks,
Ken
**
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: Is There a Win32API.bundle For v17.3HF2? (SOLVED)

[Ken Eyring via 4D_Tech]

My apologies to this list and especially to Orchard Software.

I moved some files around to cleanup my development environment to work 
with 4D v17.3 HF2 and inadvertently moved the plugins folder out of the 
same folder that contained the data files.


How does that saying go?  Stupid is as stupid does.  :-(

Again, sorry for posting this,
Ken




On 01/12/20 7:08 AM, Charles Miller wrote:

I think it is a 32 bit and this will never run on 10.15

Regards

Chuck

On Sun, Jan 12, 2020 at 2:30 AM Ken Eyring via 4D_Tech 
<4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> wrote:


If there's a Win32API.bundle for v17.3 HF2, can someone please let me
know where I can find it?

I downloaded the 8.3 version from here:

https://github.com/OrchardSoftware/4D-Win32API/releases/download/8.3/4D-Win32API-master.zip

But it has errors when I run it on Windows with 4D v17.3 HF2 and other
4D v17.x versions.

Using Mac Server OSX 10.15.2 with 4D Server 17.3 HF2 64-bit with
Windows
10 Home 4D v17.3 HF2 (32-bit and 64-bit).  Both have the errors for the
Win32API plugin.

Thanks,
Ken




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

Is There a Win32API.bundle For v17.3HF2?

[Ken Eyring via 4D_Tech]

If there's a Win32API.bundle for v17.3 HF2, can someone please let me 
know where I can find it?


I downloaded the 8.3 version from here:
https://github.com/OrchardSoftware/4D-Win32API/releases/download/8.3/4D-Win32API-master.zip

But it has errors when I run it on Windows with 4D v17.3 HF2 and other 
4D v17.x versions.


Using Mac Server OSX 10.15.2 with 4D Server 17.3 HF2 64-bit with Windows 
10 Home 4D v17.3 HF2 (32-bit and 64-bit).  Both have the errors for the 
Win32API plugin.


Thanks,
Ken




**
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 v17 To QuickBooks Using Miyako's QBO.4DB

[Ken Eyring via 4D_Tech]

Hi John,

Thank you again for your offer to help!

I finally have time to formulate my questions for you.  I wanted to put 
together the info below to be efficient with your time.  I'm glad that 
you migrated from Myle's plugin, because it will help you understand 
where I am currently at, as well as what modifications need to be made. 
I understand that it is not always easy to revisit code that you have 
not looked at in a while.  Thank you again for offering to do so.


With Myles' plugin, I made sure the QB application was being run from 
the same machine as a 4D Client.


Each time my 4D Application made a call to QB, it always followed this 8 
step approach:


---

1. Open a connection by calling qb_OpenConnection:

$ret:=qb_OpenConnection ("";"";QB_LogInCode)

I check to make sure that $ret=0 (no errors)

Note: the 3rd parameter is the login password that QB expects from my 4D 
application


---

2. Open a ticket to a new QB session by calling qb_BeginSession:

$ret:=qb_BeginSession ("";2;vt_Ticket)

I check to make sure that $ret=0 (no errors)

Note: The vt_Ticket parameter is set by QB

---

3. I build the QBXML request in a Blob variable called "BLOB_XML_ToSend"

---

4. Process the request & receive the returned XML:

Using the ticket I received in step #2, I send the Blob I built in step 
#3, and capture the returned value in a Blob called BLOB_XML_Returned


$ret:=qb_ProcessRequest (vt_Ticket;BLOB_XML_ToSend;BLOB_XML_Returned)

I check to make sure that $ret=0 (no errors)

---

5. I process the returned data in the Blob variable "BLOB_XML_Returned" 
for SAX Compliance


---

6. Parse the Returned Results in "BLOB_XML_Returned" and save the data 
to the appropriate tables/fields


---

7. End the session

$ret:=qb_EndSession ($vt_Ticket)

I check to make sure that $ret=0 (no errors)

---

8. Close the connection

$ret:=qb_CloseConnection

I check to make sure that $ret=0 (no errors)

---




Two questions:

1. What is QB RDS client and server?  Are these apps that need to be 
installed on the client workstation and server?


2. Can you let me know how/if the approach I'm using above with Myle's 
plugin relates in any way to how you are using PowerShell?



Thank you again,
Ken








On 12/13/19 8:04 PM, JOHN BAUGHMAN via 4D_Tech wrote:

Ken,

I have a deployed 4D database talking to QB on Windows 10 and 4D17r5. 
It started  out using Myles’ plug in. For me I had to stop using the plug in 
when the client moved to Windows 7.

I was able to get it done using…

 QB RDS client and server: Client or Client/Server needed or not at all 
depending on where Quickbooks is located on the network in relation to the 
requesting 4D Client or requesting 4D Server.

Windows PowerShell: 4D creates the QB request with the help of Myles’ 
XML methods. It then packs it into a PowerShelll script. The script is saved to 
a script fil. Launch External Process is used to launch PowerShell to read the 
script file. PowerSell creates the QBXMLRP com object and sends the request. 
The response is written out to as file on the hard drive which is read by 4D.

This has worked quite well over the years. When the client moved to 
Windows 10 I needed to do a bit of massaging but got it to work.

Each time I revisit this project, it takes me a while to get my head 
around it all, but if you have any questions feel free to contact me off line. 
I will do my best… I am a MAC guy so my brain really needs a refresher each 
time I have to deal with Windows.

John


On Dec 13, 2019, at 9:47 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
wrote:

I have been using QBManager from Myles Wakeham up until now with version 15.4, 
but it will not work with v17.

I found this link (https://github.com/miyako/4d-tips-quickbook-integration) 
from the post (below) from Miyako in 2017 regarding integration to QuickBooks.

I've downloaded the database, but the code does not look familiar to QBManager 
in any way.

I'm not sure how to use Miyako's plugin to open a connection to QuickBooks and 
then subsequently send and retrieve data and then close the connection.

The QBManager plugin uses QBXML to do all of this.  I'm wondering if I need to 
re-write all of the code to use Miyako's plugin, or if some/most of it can be 
reused.

Is there any documentation or examples for Miyako's plugin that anyone is aware 
of and would be willing to share?

Thank you,
Ken Eyring





On 09/05/17 20:26 P

Re: 4D v17 To QuickBooks Using Miyako's QBO.4DB

[Ken Eyring via 4D_Tech]

Ohh...

My needs are for the desktop version, not for QuickBooks online.

Thanks for making that distinction and saving me the time/trouble of 
going down the wrong path.


I appreciate your help!
Ken



On 12/13/19 18:26 PM, Kirk Brooks via 4D_Tech wrote:

Hi Ken,
Reading through your messages you don't mention if you are accessing QBO
(quickbooks online) or the desktop version. As I recall Myle's product only
accessed the desktop version - but that a really old memory.

On Fri, Dec 13, 2019 at 2:34 PM Ken Eyring via 4D_Tech <4d_tech@lists.4d.com>
wrote:


Thanks for responding Miyako.

I'm not familiar at all with OAuth.  Can you point me in the right
direction where I can learn how to use an OAuth session for QB?

Thanks again,
Ken





On 12/13/19 16:58 PM, Keisuke Miyako via 4D_Tech wrote:

the component is an OAuth example.

it simply illustrates how to manage an OAuth session for QB.

everything else is generic XML/HTTP, not specific to OAuth,
so none of it is implement in the component.

QuickBooks is not used in my country,
I have no customers using it.


2019/12/14 4:47、Ken Eyring のメール:
Is there any documentation or examples for Miyako's plugin that anyone

is aware of and would be willing to share?





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





**
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 v17 To QuickBooks Using Miyako's QBO.4DB

[Ken Eyring via 4D_Tech]

Thanks for responding Miyako.

I'm not familiar at all with OAuth.  Can you point me in the right 
direction where I can learn how to use an OAuth session for QB?


Thanks again,
Ken





On 12/13/19 16:58 PM, Keisuke Miyako via 4D_Tech wrote:

the component is an OAuth example.

it simply illustrates how to manage an OAuth session for QB.

everything else is generic XML/HTTP, not specific to OAuth,
so none of it is implement in the component.

QuickBooks is not used in my country,
I have no customers using it.


2019/12/14 4:47、Ken Eyring のメール:
Is there any documentation or examples for Miyako's plugin that anyone is aware 
of and would be willing to share?





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

4D v17 To QuickBooks Using Miyako's QBO.4DB

[Ken Eyring via 4D_Tech]

I have been using QBManager from Myles Wakeham up until now with version 
15.4, but it will not work with v17.


I found this link 
(https://github.com/miyako/4d-tips-quickbook-integration) from the post 
(below) from Miyako in 2017 regarding integration to QuickBooks.


I've downloaded the database, but the code does not look familiar to 
QBManager in any way.


I'm not sure how to use Miyako's plugin to open a connection to 
QuickBooks and then subsequently send and retrieve data and then close 
the connection.


The QBManager plugin uses QBXML to do all of this.  I'm wondering if I 
need to re-write all of the code to use Miyako's plugin, or if some/most 
of it can be reused.


Is there any documentation or examples for Miyako's plugin that anyone 
is aware of and would be willing to share?


Thank you,
Ken Eyring





On 09/05/17 20:26 PM, Keisuke Miyako via 4D_Tech wrote:

you could start from here:

https://github.com/miyako/4d-tips-quickbook-integration


2017/09/06 8:18、Douglas von Roeder via 4D_Tech <4d_tech@lists.4d.com> のメール：
What's the best approach to take for that.





**
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)
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: v17.3 on Mac OS 10.15.2 Plugins "cannot be opened because the developer cannot be verified"

[Ken Eyring via 4D_Tech]

Hi Miyako,

Please don't misunderstand. I was not shooting the messenger.  Sorry if 
you thought that.  I know this wrinkle is due to changes on Apple's end.


Thanks for all that you do for the 4D community.

Best regards,
Ken




On 12/12/19 18:15 PM, Keisuke Miyako via 4D_Tech wrote:

that “something” would be, code signing and notarisation.

to illustrate,

I’ve uploaded a notarised version of

“Miyako's Media Access Control.bundle, but it doesn't look like it works with 
v17"

here:

https://github.com/miyako/4d-plugin-media-access-control/releases/tag/2.0

it should pass GateKeeper without error.

basically you need to do the same for every plugin, framework, dynamic library, 
helper, command line tools inside your 4D app, as well as the app itself.
please don’t shoot the messenger.
I didn’t make the rules...


**
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: v17.3 on Mac OS 10.15.2 Plugins "cannot be opened because the developer cannot be verified"

[Ken Eyring via 4D_Tech]

Chip, that's a very valid point.  I was just so focused on getting my  
new development environment up and running with v17.3 HF2 that I didn't  
look towards deployment.  Every client workstation will need to go  
through that setup.  Yuk.  Something needs to be done to fix this.


Thanks for your insights,
Ken



On 12/12/19 14:32 PM, Chip Scheide wrote:

if you are distributing this...
then every user will need to do this :(

Chip
On Thu, 12 Dec 2019 13:56:04 -0500, Ken Eyring via 4D_Tech wrote:

Awesome!  Great instructions!  It wasn't so bad to implement the
permissions - once I understood how.  Thank you!

Ken



On 12/12/19 13:33 PM, Robert McKeever via 4D_Tech wrote:

Yep, this is a pain.

Go to System Preferences, Security & Privacy, the General Tab.

Now start your database.

You will have to authorize each plug-in as not being recognized
(Allow apps downloaded from:…).

Now quit your database.

Now start your database again. Answer yes for each plug-in (sorry, I
don’t remember the dialog that comes up).

Now quit your database.

Now start your database again. You should be fine now.


On Dec 12, 2019, at 10:20 AM, Ken Eyring via 4D_Tech
<4d_tech@lists.4d.com> wrote:

Hi Everyone,

I'm migrating from 4D v15.4 32-bit to v17.3 64-bit.  At the same
time, I am also moving my development machine from Mac OS 10.9.5 to
Mac OS 10.15.2.

So far it's going fairly smoothly, but a few quirks have come up
regarding plugins.  When I launch v17.3 on Mac OS 10.15.2, I get
the following alerts for these 4D Plugins:

- "4D InternetCommands.bundle" cannot be opened because the
developer cannot be verified

- "4D ODBC Pro.bundle" cannot be opened because the developer
cannot be verified

- "4D for OCI.bundle" cannot be opened because the developer cannot
be verified

I'm assuming there is a configuration somewhere that I can set to
allow the plugins to be opened - but can't find where.


I'm also trying to find a way to capture the MAC address on Macs
and Windows.  Up until now, I've been using Miyako's Media Access
Control.bundle, but it doesn't look like it works with v17.  Any
suggestions to accomplish this task would be appreciated.

Thanks,
Ken


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


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


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

We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
   - unknown


**
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: v17.3 on Mac OS 10.15.2 Plugins "cannot be opened because the developer cannot be verified" (SOLVED)

[Ken Eyring via 4D_Tech]

Just wanted to repost this email so that others can find the solution 
with a quick search.


Thanks again to everyone who helped!

Ken


On 12/12/19 13:56 PM, Ken Eyring via 4D_Tech wrote:
Awesome!  Great instructions!  It wasn't so bad to implement the 
permissions - once I understood how.  Thank you!


Ken



On 12/12/19 13:33 PM, Robert McKeever via 4D_Tech wrote:

Yep, this is a pain.

Go to System Preferences, Security & Privacy, the General Tab.

Now start your database.

You will have to authorize each plug-in as not being recognized (Allow 
apps downloaded from:…).


Now quit your database.

Now start your database again. Answer yes for each plug-in (sorry, I 
don’t remember the dialog that comes up).


Now quit your database.

Now start your database again. You should be fine now.

On Dec 12, 2019, at 10:20 AM, Ken Eyring via 4D_Tech 
<4d_tech@lists.4d.com> wrote:


Hi Everyone,

I'm migrating from 4D v15.4 32-bit to v17.3 64-bit.  At the same 
time, I am also moving my development machine from Mac OS 10.9.5 to 
Mac OS 10.15.2.


So far it's going fairly smoothly, but a few quirks have come up 
regarding plugins.  When I launch v17.3 on Mac OS 10.15.2, I get the 
following alerts for these 4D Plugins:


- "4D InternetCommands.bundle" cannot be opened because the developer 
cannot be verified


- "4D ODBC Pro.bundle" cannot be opened because the developer cannot 
be verified


- "4D for OCI.bundle" cannot be opened because the developer cannot 
be verified


I'm assuming there is a configuration somewhere that I can set to 
allow the plugins to be opened - but can't find where.



I'm also trying to find a way to capture the MAC address on Macs and 
Windows.  Up until now, I've been using Miyako's Media Access 
Control.bundle, but it doesn't look like it works with v17.  Any 
suggestions to accomplish this task would be appreciated.


Thanks,
Ken


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


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


**
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: v17.3 on Mac OS 10.15.2 Plugins "cannot be opened because the developer cannot be verified"

[Ken Eyring via 4D_Tech]

Hi Cannon,

I forgot to accurately state that I am using v17.3 HF2 and still had the 
problem.


I followed the instructions that Robert McKeever sent and I got 
everything working pretty quickly.


The latest version of the Media Access Control.bundle also seems to 
working as well!


Thanks for your help!

Ken





On 12/12/19 13:36 PM, Cannon Smith via 4D_Tech wrote:

Hi Ken,

It is because the plugins aren’t notarized by 4D. If you move to at least v17.3 
HF1, you shouldn’t have a problem.

HTH.

--
Cannon.Smith
Synergy Farm Solutions Inc.
Aetna, AB Canada





On Dec 12, 2019, at 11:20 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
wrote:

So far it's going fairly smoothly, but a few quirks have come up regarding 
plugins.  When I launch v17.3 on Mac OS 10.15.2, I get the following alerts for 
these 4D Plugins:

- "4D InternetCommands.bundle" cannot be opened because the developer cannot be 
verified

- "4D ODBC Pro.bundle" cannot be opened because the developer cannot be verified

- "4D for OCI.bundle" cannot be opened because the developer cannot be verified



**
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: v17.3 on Mac OS 10.15.2 Plugins "cannot be opened because the developer cannot be verified"

[Ken Eyring via 4D_Tech]

I got it sorted out, thanks.

I just bought a new laptop and it came with Catalina on it.  I was not 
aware that there are issues with it when I picked it up.  There have 
been 2 OS updates since I picked it up from Apple a couple of weeks ago.


I've read that people are calling this Mac's equivalent of Vista.  I 
hope that is not the case.


Thanks for your help!

Ken




On 12/12/19 13:34 PM, Chip Scheide wrote:

OS X 10.15 -- catalina - I would suggest a not so good choice
however, given you can not/will not go back to 10.14

look online for how to disable gatekeeper (this is the software that is
stopping the plugins).
here are 2 i found, although they do not apply specifically to 10.15...
so your milage may vary in getting either of these to work
http://osxdaily.com/2015/05/04/disable-gatekeeper-command-line-mac-osx/
https://www.techjunkie.com/gatekeeper-macos-sierra/

Chip

On Thu, 12 Dec 2019 13:20:19 -0500, Ken Eyring via 4D_Tech wrote:

Hi Everyone,

I'm migrating from 4D v15.4 32-bit to v17.3 64-bit.  At the same
time, I am also moving my development machine from Mac OS 10.9.5 to
Mac OS 10.15.2.

So far it's going fairly smoothly, but a few quirks have come up
regarding plugins.  When I launch v17.3 on Mac OS 10.15.2, I get the
following alerts for these 4D Plugins:

- "4D InternetCommands.bundle" cannot be opened because the developer
cannot be verified

- "4D ODBC Pro.bundle" cannot be opened because the developer cannot
be verified

- "4D for OCI.bundle" cannot be opened because the developer cannot
be verified

I'm assuming there is a configuration somewhere that I can set to
allow the plugins to be opened - but can't find where.


I'm also trying to find a way to capture the MAC address on Macs and
Windows.  Up until now, I've been using Miyako's Media Access
Control.bundle, but it doesn't look like it works with v17.  Any
suggestions to accomplish this task would be appreciated.

Thanks,
Ken


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

We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
   - unknown


**
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: v17.3 on Mac OS 10.15.2 Plugins "cannot be opened because the developer cannot be verified"

[Ken Eyring via 4D_Tech]

Awesome!  Great instructions!  It wasn't so bad to implement the 
permissions - once I understood how.  Thank you!


Ken



On 12/12/19 13:33 PM, Robert McKeever via 4D_Tech wrote:

Yep, this is a pain.

Go to System Preferences, Security & Privacy, the General Tab.

Now start your database.

You will have to authorize each plug-in as not being recognized (Allow apps 
downloaded from:…).

Now quit your database.

Now start your database again. Answer yes for each plug-in (sorry, I don’t 
remember the dialog that comes up).

Now quit your database.

Now start your database again. You should be fine now.


On Dec 12, 2019, at 10:20 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
wrote:

Hi Everyone,

I'm migrating from 4D v15.4 32-bit to v17.3 64-bit.  At the same time, I am 
also moving my development machine from Mac OS 10.9.5 to Mac OS 10.15.2.

So far it's going fairly smoothly, but a few quirks have come up regarding 
plugins.  When I launch v17.3 on Mac OS 10.15.2, I get the following alerts for 
these 4D Plugins:

- "4D InternetCommands.bundle" cannot be opened because the developer cannot be 
verified

- "4D ODBC Pro.bundle" cannot be opened because the developer cannot be verified

- "4D for OCI.bundle" cannot be opened because the developer cannot be verified

I'm assuming there is a configuration somewhere that I can set to allow the 
plugins to be opened - but can't find where.


I'm also trying to find a way to capture the MAC address on Macs and Windows.  
Up until now, I've been using Miyako's Media Access Control.bundle, but it 
doesn't look like it works with v17.  Any suggestions to accomplish this task 
would be appreciated.

Thanks,
Ken


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


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


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

v17.3 on Mac OS 10.15.2 Plugins "cannot be opened because the developer cannot be verified"

[Ken Eyring via 4D_Tech]

Hi Everyone,

I'm migrating from 4D v15.4 32-bit to v17.3 64-bit.  At the same time, I 
am also moving my development machine from Mac OS 10.9.5 to Mac OS 10.15.2.


So far it's going fairly smoothly, but a few quirks have come up 
regarding plugins.  When I launch v17.3 on Mac OS 10.15.2, I get the 
following alerts for these 4D Plugins:


- "4D InternetCommands.bundle" cannot be opened because the developer 
cannot be verified


- "4D ODBC Pro.bundle" cannot be opened because the developer cannot be 
verified


- "4D for OCI.bundle" cannot be opened because the developer cannot be 
verified


I'm assuming there is a configuration somewhere that I can set to allow 
the plugins to be opened - but can't find where.



I'm also trying to find a way to capture the MAC address on Macs and 
Windows.  Up until now, I've been using Miyako's Media Access 
Control.bundle, but it doesn't look like it works with v17.  Any 
suggestions to accomplish this task would be appreciated.


Thanks,
Ken


**
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: Can't Define DEP Exception On Windows

[Ken Eyring via 4D_Tech]

Thanks Jeff!


On 12/11/19 09:45 PM, Jeffrey Kain via 4D_Tech wrote:

Hey Ken  -

DEP hasn't been an issue for a very long time, unless you have some old plug-in 
that's requiring it. I thought it was since v11 or maybe even v2004... for sure 
v15 doesn't need it.


On Dec 10, 2019, at 7:48 PM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
wrote:

Hi Everyone,

I have a customer who has a Windows 2008 R2 Server.  I had 4D v12.5 installed 
on the machine and added 4D Server and 4D Client v12 as DEP exceptions.  These 
ran with no problems for many years.  I want to update the 4D software on the 
same machine to v15.4 and when I attempt to add the 4D Server v15.4 and 4D 
Client v15.4 applications to the DEP exceptions list, Windows displays the 
following message:

"This program must run with data execution prevention (DEP) enabled.  You cannot 
turn off DEP for this program."

I'm wondering if the 4D v15.4 applications will run properly without the DEP 
exception, or if there is something that I need to configure in order to allow 
DEP exceptions to be added for the 4D Server v15.4 and 4D Client v15.4 
applications.


**
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: Can't Define DEP Exception On Windows

[Ken Eyring via 4D_Tech]

I did not upgrade to 15.6 because 15.4 was working fine.  I tend to 
stick with a point version unless it has issues.


Thanks,
Ken



On 12/11/19 08:41 PM, Charles Miller via 4D_Tech wrote:

Also why are you not running last version of 15 which I think is 15.6

Regards

Chuck

On Tue, Dec 10, 2019 at 7:49 PM Ken Eyring via 4D_Tech <4d_tech@lists.4d.com>
wrote:


Hi Everyone,

I have a customer who has a Windows 2008 R2 Server.  I had 4D v12.5
installed on the machine and added 4D Server and 4D Client v12 as DEP
exceptions.  These ran with no problems for many years.  I want to
update the 4D software on the same machine to v15.4 and when I attempt
to add the 4D Server v15.4 and 4D Client v15.4 applications to the DEP
exceptions list, Windows displays the following message:

  "This program must run with data execution prevention (DEP)
enabled.  You cannot turn off DEP for this program."

I'm wondering if the 4D v15.4 applications will run properly without the
DEP exception, or if there is something that I need to configure in
order to allow DEP exceptions to be added for the 4D Server v15.4 and 4D
Client v15.4 applications.

Any suggestions would be very much appreciated.

Thank you,
Ken Eyring
**
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: AW: Can't Define DEP Exception On Windows

[Ken Eyring via 4D_Tech]

The company is content to be using Windows Server 2008 for now, so 
that's not my call.  I expect they'll update it if it becomes an issue.


Thank you for letting me know that DEP exceptions are no longer needed. 
That takes a load off of my mind!


Best regards,
Ken



On 12/11/19 05:14 PM, Epperlein, Lutz (agendo) via 4D_Tech wrote:

Two things I see:

The first one, the Windows Server 2008 will not be supported anymore by 
Microsoft from the beginning of the next year. So it would be a very good idea 
to update the server OS, if someone will need it for production use (or even in 
other cases too).

And for the second, you don't need add such DEP exceptions anymore with newer 
versions of 4D. I don't remember which versions don't need this anymore, I 
think it started with version 4D v13.

Regards
Lutz

-Ursprüngliche Nachricht-
Von: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] Im Auftrag von Ken Eyring 
via 4D_Tech
Betreff: Can't Define DEP Exception On Windows

Hi Everyone,

I have a customer who has a Windows 2008 R2 Server.  I had 4D v12.5
installed on the machine and added 4D Server and 4D Client v12 as DEP
exceptions.  These ran with no problems for many years.  I want to
update the 4D software on the same machine to v15.4 and when I attempt
to add the 4D Server v15.4 and 4D Client v15.4 applications to the DEP
exceptions list, Windows displays the following message:

  "This program must run with data execution prevention (DEP)
enabled.  You cannot turn off DEP for this program."

I'm wondering if the 4D v15.4 applications will run properly without the
DEP exception, or if there is something that I need to configure in
order to allow DEP exceptions to be added for the 4D Server v15.4 and 4D
Client v15.4 applications.

Any suggestions would be very much appreciated.

Thank you,
Ken Eyring
**
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
**

Can't Define DEP Exception On Windows

[Ken Eyring via 4D_Tech]

Hi Everyone,

I have a customer who has a Windows 2008 R2 Server.  I had 4D v12.5 
installed on the machine and added 4D Server and 4D Client v12 as DEP 
exceptions.  These ran with no problems for many years.  I want to 
update the 4D software on the same machine to v15.4 and when I attempt 
to add the 4D Server v15.4 and 4D Client v15.4 applications to the DEP 
exceptions list, Windows displays the following message:


"This program must run with data execution prevention (DEP) 
enabled.  You cannot turn off DEP for this program."


I'm wondering if the 4D v15.4 applications will run properly without the 
DEP exception, or if there is something that I need to configure in 
order to allow DEP exceptions to be added for the 4D Server v15.4 and 4D 
Client v15.4 applications.


Any suggestions would be very much appreciated.

Thank you,
Ken Eyring
**
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
**

Test Post

[Ken Eyring via 4D_Tech]

My posts don't seem to be posted to the list.


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