Re: Find in field

[Randy Jaynes via 4D_Tech]

First, as I know others have encouraged you, this list list is 
effectively dead.


You should go to https://discuss.4d.com/ and use the online forum there 
and forget this email address even exists. ;-)


It’s much better anyhow as you can post pictures and code more easily 
than this simple mailing list ever allowed.


As to your question, the best way I can think is to use a 3rd process 
(or maybe a CALL WORKER process) whose sole function is to return 
sequence numbers outside of transactions.


SUSPEND TRANSACTION/RESUME TRANSACTION _may_ work for giving you a 
sequence number outside of the transaction, but I’ve only done this 
for related tables in code where I’m doing the full CRUD on the 
related record and want to be sure it’s outside the current 
transaction.


The separate process for grabbing sequence numbers is the cleanest way I 
can think of.


HTH,
Randy

--
Randy Jaynes

DocketManager & PrintPoint Development and Support

For all PrintPoint support inquiries, please email 
printpointsupp...@docketmanager.ca or call 845-687-3741.


On 30 Jul 2024, at 5:03, stardata.info via 4D_Tech wrote:

I use the command " Find in field " for obtain a unique id during a 
record creation during TRANSACTION .

I have two process that use this command into transaction.
Process1 obtain a unique id and is in trasaction, the id is 1
Process2 request an id with " Find in field " and have the same id 
number, and in SAVE RECORD have an error of duplicate key.


How i can do to solve this case?

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

**
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: Client communication

[Randy Jaynes via 4D_Tech]

An old trick I used to use in days gone by was a BLOB field in the table
whose trigger needed the extra info.

I'd use VARIABLE TO BLOB to put in all the information needed just before
calling SAVE RECORD on the table. Then the trigger has the field and can
use BLOB TO VARIABLE to unpack what it needs and clear the BLOB field so it
wouldn't take any room up on the actual save.

I can't remember that far back, but if Object fields are available in v16,
go that route instead. Objects are so much easier to deal with.

I generally simply named the field Trigger_Info in every table where I
needed to do this.

HTH,
Randy

On Tue, Mar 5, 2024 at 12:09 PM David Samson via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> looks like VARIABLE TO VARIABLE would help.
>
> David Samson
>
>
> Message: 1
> > Date: Mon, 4 Mar 2024 16:01:40 +0100
> > From: "stardata.info" 
> > To: 4d_tech@lists.4d.com, 4d_tech-requ...@lists.4d.com
> > Subject: Client communication
> > Message-ID: <51ecb4f8-c681-402e-8a9d-e1da6ef49...@stardata.info>
> > Content-Type: text/plain; charset=UTF-8; format=flowed
> >
> > Hi all,
> >
> > I use 4D V16 on window.
> >
> > I need to share informations from the process executed on server and the
> > clients.
> >
> > The process executed on server, put the informations into some
> > interprocess array.
> >
> > Someone know how i can do?
> >
> > Thanks
> >
> > Ferdinando
> >
> >
> >
> >
> **
> 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: error 9922 o SQL Execute? what does that mean?

[Randy Jaynes via 4D_Tech]

Julio,

http://forums.4d.com/Post/EN/27095796/1

https://bugs.4d.com/fixes?version=16_R2 shows 

ACI0095714  ODBC driver returns error #9922 if last character in a word is 
a diacritical sign as è,é or ä (using fields).

You would think your version is not susceptible to that because it was fixed in 
15.3 HF1 and 16 R2.

But it looks like there are other ODBC errors with data getting truncated to 
255 characters by some drivers, etc.

Is it possible that the data you’re trying to INSERT is causing the SQL 
statement to exceed some ODBC limitation of the driver you’re using?

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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




Please send all emails to supp...@printpoint.com




> On Oct 8, 2021, at 10:37 AM, Julio Carneiro via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 4d iDoes anyone here know what error 9922 means (not -9922)? this is 4D 
> v17.5, and I am doing a SQL EXECUTE(“INSERT….“), via a ODBC connection. 
> Can’t find that error code anywhere, not on 4D docs and not even on 4D Today. 
> The error only comes up some times, for some statements. 
> I could not spot any significant difference between “INSERT” that pass and 
> those that fail. Even to the same table. 
> 
> Any link/hints will help
> --
> Julio Carneiro
> jjfo...@gmail.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: [EXTERNAL] Re: Run v15.4 in demo mode

[Randy Jaynes via 4D_Tech]

Brad,

I have most of the older installers if you need something. I can PM you dropbox 
links for what you need. I have versions of v15 up to v15.5 HF1.

Version 16 to 16.2HF1 … I think I skipped a few versions of this one and went 
into v17.

Something I do for these situations is to have virtual machines in Parallels 
with older operating systems so that I can more easily run these older versions 
of 4D.

Good luck!

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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




Please send all emails to supp...@printpoint.com




> On Aug 25, 2021, at 4:56 PM, Perkins, Bradley D via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi Randy,
> 
> I do have an both compiled and uncompiled structures. If I could find a v16 
> installer will that run on Catalina? Also do you know if there is still an 
> ftp site that has older version downloads that isn't restricted to Partners?
> 
> Thanks,
> Brad
> 
> From: Randy Kaempen 
> Date: Wednesday, August 25, 2021 at 2:49 PM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Cc: Bradley Perkins 
> Subject: [EXTERNAL] Re: Run v15.4 in demo mode
> 
> Brad,
> 
> 
> On Aug 25, 2021, at 3:44 PM, Perkins, Bradley D via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I've had a request to retrieve some data from a v15.4 database that was last 
> used in early 2019. The customer still has the server with DB installed and a 
> compatible client machine, but the machines are in storage and off-network. 
> Given the current situation getting them online and remotely accessible isn't 
> possible. I am working remotely. I have a copy of the DB on an older Macbook 
> Pro, but it had been upgraded to Catalina and 15.4 will no longer open. I get 
> a '4D.app' needs to be updated dialog when attempting to launch. I expect 
> that is likely due to drop of 32-bit support in Catalina. My installed 
> licenses on the MPB were also those granted annually through the partner 
> program and have expired.
> 
> If I could copy the 4D.app and the structure and data files back to an 
> earlier MacOS Yosemite machine will I be able to temporarily run 4D v15.4 in 
> demo mode, or will 4D immediately request activation? I need less than 15 
> minutes to retrieve the requested data.
> 
> Beyond that I may need to travel to their site and hook the client and server 
> together with a crossover cable or maybe run a client from the server if one 
> is installed. Their institutional IT policies would not allow them to place 
> the machines on the network now (running very outdated OS versions, plus 
> these were in a DMZ that they no longer have access to). I'd prefer to try 
> off-site.
> 
> My last 4D experience was with v15 and I understand that things have changed 
> a lot. Could newer versions open the v15.4 DB in demo mode with minimal 
> effort?
> 
> Is the database compiled?  If not, a newer version will open it and convert 
> it.  There are commands which are obsolete in the later versions, but you 
> should still be able to work.  Picture fields will be an issue unless they 
> are converted before going to 64 bit versions of 4D.
> 
> If the database is compiled, later versions will not be able to open it.
> 
> 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
> **

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

[Randy Jaynes via 4D_Tech]

I’ve started using object fields for stuff like this to avoid all the parsing.

Object fields can be queried now so it really is nicer to use, as well as 
easier to debug.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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




Please send all emails to supp...@printpoint.com




> On Jul 13, 2021, at 6:04 AM, stardata.info via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I All,
> 
> I need to save some information of several type in one record.
> 
> 
> For example for one test i need to save more than one result.
> 
> These results are variables, 20/30/40 results for every test.
> So for one test, I need to save a variable number of rows.
> For every row, I have more than one information (code, value, times and other 
> )
> 
> Use the object field is a correct solution?
> Or is better to use a text field with field separators and row delimiters?
> 
> Thanks
> Ferdinando
> 
> 
> **
> 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: Any Success Running 4D v13.6 on Win 10 Pro?

[Randy Jaynes via 4D_Tech]

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 • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 




Please send all emails to supp...@printpoint.com




> On Jan 19, 2021, at 10:47 AM, Ken Eyring via 4D_Tech <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: V18 plugins not showing as Notarized?

[Randy Jaynes via 4D_Tech]

I’ve found that you also have to be careful when copying your development 
structure from 1 machine to another.

When you copy or unzip a version on the Catalina machine, it invalidates the 
notarization of the plugins and you get the alerts when opening the database 
that the plugins are damaged.

They’re not.

You then have to go to System Preferences > Security & Privacy > General to use 
the “Blah blah anyway” button. Multiple times if you have several plugins with 
the issue.

As a result I have a folder on the desktop of my Catalina testing machine where 
all the plugins are noticed in case I forget again.

I found I have to use Miyako’s buildApp database to codesign each plugin.bundle 
when this happens.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com



> On May 1, 2020, at 1:06 AM, Ronald Rosell via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I knew it would be something simple.  I’d actually completely forgotten that 
> 4D InternetCommands is included in the 4D application package … I’ve 
> generally had a copy in the database folder -> Plugins when compiling.
> 
> I just took that latter copy out, relaunched, and problem solved!  Thank you 
> Miyako!
> 
> Ron Rosell
> __
> 
> Ron Rosell
> President
> StreamLMS
> 
>> On Apr 30, 2020, at 9:29 PM, Keisuke Miyako via 4D_Tech 
>> <4d_tech@lists.4d.com> wrote:
>> 
>> only the plugins pre-installed with the application (inside 4D or 4D Server) 
>> are notarised.
>> 
>> the folder adjacent to the application are copies for distribution and 
>> therefore not code signed at all.
>> 
>>> On May 1, 2020, at 12:00, Ronald Rosell via 4D_Tech <4d_tech@lists.4d.com> 
>>> wrote:
>>> Executing codesign --verify -- verbose against 4D InternetCommands.bundle, 
>>> for example, brings back:
>>> /Applications/4D v18.1/Plugins/4D InternetCommands.bundle: code object 
>>> is not signed at all
>> 
>> **
>> 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: WAN vs LAN Cache

[Randy Jaynes via 4D_Tech]

Well that sucks. That really helped out in some tricky situations over the 
years.

Admittedly, been a couple months since I last tried it. I swear it was with a 
v17 R version, but I can definitely see it’s not working anymore with R6 or 
v18.1

Sitting down. Head hung.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com



> On Apr 29, 2020, at 9:32 AM, Paul Dennis via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hello Randy,
> 
> You can no longer use the client local folder.  It was deprecated with V17
> R5
> 
> https://forums.4d.com/Post/EN/30742975/1/30761022#30761022
> 
> Regards
> Paul
> 
> 
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
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: WAN vs LAN Cache

[Randy Jaynes via 4D_Tech]

I believe you can still put a folder named ‘clientlocal’ in the same path as 
the 4D.exe(windows) or 4D.app (mac).

This lets you keep the cache for a specific 4D application right in the same 
folder as the application itself.

The only potential downside to this is if you use the same app to connect to 
different 4D servers you’ll be replacing the cache folder each time you log 
into a different server.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com



> On Apr 29, 2020, at 4:49 AM, Paul Dennis via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> There is a thread about this problem on the old 4D forum. 
> 
> https://forums.4d.com/Post/EN/34156307/1/34663615#34663615
> 
> With version 18 you can no longer define the location of the client folder
> it is automatically created. 4D uses a combination of the IP address and the
> hash to create the path to the folder. 
> 
> As mentioned above if you use a different on your machine it creates a new
> folder. If you make any changes to the network settings same applies. It may
> be worth checking if you have legacy networks selected incompatibility I had
> that problem.
> 
> It is frustrating that we cannot define the path for the client folder. My
> 4d folder in user profile/Appdata/4D Is already over a gigabyte. Furthermore
> if you use built application and the user wants to uninstall this will not
> be removed.
> 
> Paul
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
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: New Notarization Issues

[Randy Jaynes via 4D_Tech]

Jeremy,

I won’t tell you how many day's worth of hours it took me to get my stuff 
through the process.

I was cursing Apple frequently and for the first time in 20+ years (did I 
really say that?) seriously considering becoming a Windows only programmer.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com



> On Apr 28, 2020, at 10:47 AM, Jeremy Roussak via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Randy and Spencer,
> 
> Thanks. That’s exactly what I did and my application is now successfully 
> notarized.
> 
> I wish I understood what notarization actually involves. One day…
> 
> Jeremy
> 
>> On 28 Apr 2020, at 14:04, Randy Jaynes > > wrote:
>> 
>> For that one I was able to replace it with the php-fcgi-4d from the recent 
>> release of 4D v18.
>> 
>> Randy
>> 
>> --
>> Randy Jaynes
>> Senior Programmer and Customer Support
>> 
>> http://printpoint.com  • 845.687.3741 • PrintPoint, 
>> Inc • 57 Ludlow Lane • Palisades, NY 10964 
>> Please send all email contacts to supp...@printpoint.com 
>> 
>> 
>> 
>>> On Apr 28, 2020, at 7:33 AM, Jeremy Roussak >> > wrote:
>>> 
>>> Randy, thanks for that pointer and Miyako, thanks very much indeed, as 
>>> ever, for that marvellous application.
>>> 
>>> The huge slew of notarization errors has now been reduced to just one:
>>> 
>>>  "issues": [
>>>{
>>>  "severity": "error",
>>>  "code": null,
>>>  "path": "PI_Calculator.app-1.84.app.zip/PI 
>>> calculator.app/Contents/Resources/php/Mac/php-fcgi-4d",
>>>  "message": "The binary uses an SDK older than the 10.9 SDK.",
>>>  "docUrl": null,
>>>  "architecture": "x86_64"
>>>}
>>>  ]
>>> It seems I need a new version of the PHP binary. I seem vaguely to remember 
>>> that this was discussed before, but I can’t recall what the solution was. 
>>> Is there one somewhere?
>>> 
>>> Jeremy
>>> 
 On 27 Apr 2020, at 21:28, Randy Jaynes >>> > wrote:
 
 Jeremy,
 
 I would RUN to Miyako’s buildApp 
 (https://github.com/miyako/4d-utility-build-application 
 )
 
 I found on the Catalina build machine that I’m using, I have to constantly 
 sign the entire plugins folder.
 
 This database has been nothing short of a miracle for this process.
 
 There was a test method in there that is already pretty much set up to go 
 down through the whole chain of all the folders, frameworks, plugins, … 
 you name it. 
 
 Randy
 
 --
 Randy Jaynes
 Senior Programmer and Customer Support
 
 http://printpoint.com  • 845.687.3741 • 
 PrintPoint, Inc • 57 Ludlow Lane • Palisades, NY 10964 
 Please send all email contacts to supp...@printpoint.com 
 
 
 
> On Apr 27, 2020, at 3:14 PM, Jeremy Roussak via 4D_Tech 
> <4d_tech@lists.4d.com > wrote:
> 
> 4Dv17R5, Mac Mojave
> 
> An application which I have previously codesigned and successfully 
> submitted for notarization is now failing to be notarized. The log file 
> contains a stream of errors, complaining about 4D InternetCommands, 
> InstallTool, Updater.app and others, the errors being invalid signature, 
> signature algorithm is too weak, executable does not have hardened 
> runtime enabled, and so on.
> 
> I’ve changed nothing since January, when it was notarized just fine. 
> codesign —verify says it’s OK.
> 
> Help!
> 
> Jeremy
> 
> The log file is at
> 
> https://osxapps-ssl.itunes.apple.com/itunes-assets/Enigma113/v4/03/70/62/03706243-2acd-5546-7a56-0fc4bda885a1/developer_log.json?accessKey=1588208394_8709044140572407954_aq%2Fu1eNX3LZEeLteCNikuUhL0w2W6BTpOHDmSGWv6lff9IL9W2H%2BGZI1WIfIm6R1rcc0fM1dEsPP43G5FhGjzCQUrvPwYL41E2YoNZSUzqtk1p1xkzmU%2BbjTpJ7s9RmairuCloWnEEFJsKbehxOX6EEY7i3Y5E%2FdrELaMZv1d2c%3D
>  
> 
>  
> 

Re: New Notarization Issues

[Randy Jaynes via 4D_Tech]

For that one I was able to replace it with the php-fcgi-4d from the recent 
release of 4D v18.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com



> On Apr 28, 2020, at 7:33 AM, Jeremy Roussak  wrote:
> 
> Randy, thanks for that pointer and Miyako, thanks very much indeed, as ever, 
> for that marvellous application.
> 
> The huge slew of notarization errors has now been reduced to just one:
> 
>   "issues": [
> {
>   "severity": "error",
>   "code": null,
>   "path": "PI_Calculator.app-1.84.app.zip/PI 
> calculator.app/Contents/Resources/php/Mac/php-fcgi-4d",
>   "message": "The binary uses an SDK older than the 10.9 SDK.",
>   "docUrl": null,
>   "architecture": "x86_64"
> }
>   ]
> It seems I need a new version of the PHP binary. I seem vaguely to remember 
> that this was discussed before, but I can’t recall what the solution was. Is 
> there one somewhere?
> 
> Jeremy
> 
>> On 27 Apr 2020, at 21:28, Randy Jaynes > > wrote:
>> 
>> Jeremy,
>> 
>> I would RUN to Miyako’s buildApp 
>> (https://github.com/miyako/4d-utility-build-application 
>> )
>> 
>> I found on the Catalina build machine that I’m using, I have to constantly 
>> sign the entire plugins folder.
>> 
>> This database has been nothing short of a miracle for this process.
>> 
>> There was a test method in there that is already pretty much set up to go 
>> down through the whole chain of all the folders, frameworks, plugins, … you 
>> name it. 
>> 
>> Randy
>> 
>> --
>> Randy Jaynes
>> Senior Programmer and Customer Support
>> 
>> http://printpoint.com  • 845.687.3741 • PrintPoint, 
>> Inc • 57 Ludlow Lane • Palisades, NY 10964 
>> Please send all email contacts to supp...@printpoint.com 
>> 
>> 
>> 
>>> On Apr 27, 2020, at 3:14 PM, Jeremy Roussak via 4D_Tech 
>>> <4d_tech@lists.4d.com > wrote:
>>> 
>>> 4Dv17R5, Mac Mojave
>>> 
>>> An application which I have previously codesigned and successfully 
>>> submitted for notarization is now failing to be notarized. The log file 
>>> contains a stream of errors, complaining about 4D InternetCommands, 
>>> InstallTool, Updater.app and others, the errors being invalid signature, 
>>> signature algorithm is too weak, executable does not have hardened runtime 
>>> enabled, and so on.
>>> 
>>> I’ve changed nothing since January, when it was notarized just fine. 
>>> codesign —verify says it’s OK.
>>> 
>>> Help!
>>> 
>>> Jeremy
>>> 
>>> The log file is at
>>> 
>>> https://osxapps-ssl.itunes.apple.com/itunes-assets/Enigma113/v4/03/70/62/03706243-2acd-5546-7a56-0fc4bda885a1/developer_log.json?accessKey=1588208394_8709044140572407954_aq%2Fu1eNX3LZEeLteCNikuUhL0w2W6BTpOHDmSGWv6lff9IL9W2H%2BGZI1WIfIm6R1rcc0fM1dEsPP43G5FhGjzCQUrvPwYL41E2YoNZSUzqtk1p1xkzmU%2BbjTpJ7s9RmairuCloWnEEFJsKbehxOX6EEY7i3Y5E%2FdrELaMZv1d2c%3D
>>>  
>>> 
>>>  
>>> >>  
>>> >
>>> 
>>> 
>>> **
>>> 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
Optio

Re: New Notarization Issues

[Randy Jaynes via 4D_Tech]

Jeremy,

I would RUN to Miyako’s buildApp 
(https://github.com/miyako/4d-utility-build-application 
)

I found on the Catalina build machine that I’m using, I have to constantly sign 
the entire plugins folder.

This database has been nothing short of a miracle for this process.

There was a test method in there that is already pretty much set up to go down 
through the whole chain of all the folders, frameworks, plugins, … you name it. 

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com



> On Apr 27, 2020, at 3:14 PM, Jeremy Roussak via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> 4Dv17R5, Mac Mojave
> 
> An application which I have previously codesigned and successfully submitted 
> for notarization is now failing to be notarized. The log file contains a 
> stream of errors, complaining about 4D InternetCommands, InstallTool, 
> Updater.app and others, the errors being invalid signature, signature 
> algorithm is too weak, executable does not have hardened runtime enabled, and 
> so on.
> 
> I’ve changed nothing since January, when it was notarized just fine. codesign 
> —verify says it’s OK.
> 
> Help!
> 
> Jeremy
> 
> The log file is at
> 
> https://osxapps-ssl.itunes.apple.com/itunes-assets/Enigma113/v4/03/70/62/03706243-2acd-5546-7a56-0fc4bda885a1/developer_log.json?accessKey=1588208394_8709044140572407954_aq%2Fu1eNX3LZEeLteCNikuUhL0w2W6BTpOHDmSGWv6lff9IL9W2H%2BGZI1WIfIm6R1rcc0fM1dEsPP43G5FhGjzCQUrvPwYL41E2YoNZSUzqtk1p1xkzmU%2BbjTpJ7s9RmairuCloWnEEFJsKbehxOX6EEY7i3Y5E%2FdrELaMZv1d2c%3D
>  
> 
> 
> 
> **
> 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: 28 character file name limit for binhex encode SMTP_attachments?

[Randy Jaynes via 4D_Tech]

Oh, yeah…that too!

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com



> On Apr 23, 2020, at 2:49 PM, Randy Kaempen via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> That has been around a while.  You also have to worry about the ‘.b64’ added 
> at the end

**
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: 28 character file name limit for binhex encode SMTP_attachments?

[Randy Jaynes via 4D_Tech]

Yes.

This is a long-standing problem with 4D internet commands. It goes back to at 
least v6. I know it’s still present in v13 for sure, and you are confirming 
it’s in v16.4R4.

If I remember, I think it may also be limited to 256 total characters in the 
full path on Windows (maybe Mac too), so you have to be careful of files that 
are buried several folders deep. 

This is one of the issues I’m hoping the SMTP Transporter in v18 does not have 
a problem with.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com



> On Apr 23, 2020, at 2:41 PM, Joe Dombroski via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have been having occasional -43 protocol not supported errors when I
> attach files to an email. I finally dug in and found that I must keep the
> file name under 29 characters.  Anyone else notice this? I am on 16.4r4.
> 
> Joe Dombroski
> Brandywine Electronics, LTD

**
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: Drop User NOT working (after client disconnected using Force Quit)

[Randy Jaynes via 4D_Tech]

In some situations where the 'drop user’ was failing, I have been able to 
switch over to the list of processes and abort each of the user’s processes.

The user was dropped when the last process successfully aborted.

I can say that this hasn’t succeeded every time, but it has worked for me.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com



> On Apr 15, 2020, at 11:28 AM, John J Foster via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hey All,
> 
> 4D v17.2 64bit Windows
> Windows 10 Pro
> 
> Another issue (last month actually) that I’m not sure if there is a fix. 
> Although client believes there is one! Here’s what happened:
> 
> A User (client) froze up in the application and so they excited improperly by 
> quitting the 4D through the Task Manager. However they still show as being 
> logged in on the server. So on 4D Server -> Users tab they highlight the User 
> they want to Disconnect and hit Drop User…..it doesn’t work.
> 
> And since 4D “thinks” they were still logged in then they couldn’t reconnect 
> as that user.
> 
> Tried many times and the only fix was to restart the server.
> 
> Is there something that can be done besides reminding them to not “Force 
> Quit”, bringing the 4D Server down and restarting?
> 
> Anyone else experience this issues?
> 
> Thanks,
> John…
> 
> 
> **
> 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: Multiple instances of 4D Client

[Randy Jaynes via 4D_Tech]

I’ve found it to be any way you want it.

It’s like a 4D Easter Egg…if this folder is present next to the application 
(.exe or .app) then that’s where it puts its cache folder instead of in the 
normal place.

It makes it easy to have a copy of 4D set aside specifically for connecting to 
1 server.

Keep in mind that if you then use that app to connect to multiple servers 
(quit, connect to server 2, quit, connect to server 3, etc) then each server is 
REPLACING the connects of the cache files from the previous server.

4D v17.5 changed the way it names the cache folder, so in most cases this is no 
longer necessary.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com



> On Apr 2, 2020, at 3:48 PM, Tom Benedict  wrote:
> 
> Is that needed when connecting to two clients on one machine to two different 
> 4D Servers or only when connecting two clients on one machine to the same 4D 
> Server?
> 
> Tom Benedict
> 
>> On Apr 2, 2020, at 12:36, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Create a folder named ‘ClientLocal’ in the folders where the 4D.exe is (the 
>> one being used as a client).
>> 
>> Randy
>> 
>> --
>> Randy Jaynes
>> Senior Programmer and Customer Support
>> 
>> http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
>> Palisades, NY 10964 
>> Please send all email contacts to supp...@printpoint.com
>> 
>> 
>>> On Apr 2, 2020, at 3:13 PM, Ken Geiger Gmail via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> Hi all,
>>> 
>>> Dumb question. I have a customer with two 4D C/S databases that are running 
>>> simultaneously on two instances of 4D Server. He would like to launch two 
>>> instances of 4D Client on his workstation so he dies not have to keep 
>>> quitting and launching the Client to access either of his apps. Windows 10, 
>>> 4D 16.2. 
>>> 
>>> Regards,
>>> 
>>> Ken Geiger
> 

**
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: Multiple instances of 4D Client

[Randy Jaynes via 4D_Tech]

Create a folder named ‘ClientLocal’ in the folders where the 4D.exe is (the one 
being used as a client).

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com



> On Apr 2, 2020, at 3:13 PM, Ken Geiger Gmail via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Hi all,
> 
> Dumb question. I have a customer with two 4D C/S databases that are running 
> simultaneously on two instances of 4D Server. He would like to launch two 
> instances of 4D Client on his workstation so he dies not have to keep 
> quitting and launching the Client to access either of his apps. Windows 10, 
> 4D 16.2. 
> 
> Regards,
> 
> Ken Geiger
> 
> Sent from my iPhone
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Windows XPS Document Writer Preview problem

[Randy Jaynes via 4D_Tech]

XPS Viewer is not installed in Windows 10 by default any more.

https://www.tenforums.com/tutorials/109719-add-remove-xps-viewer-app-windows-10-a.html
 


I would follow Option 1 to add it.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support


> On Sep 30, 2019, at 12:36 PM, David Rose via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> In a 4D v15 database running on Windows 10 computers, clicking the Preview 
> box in the print settings screen invokes the Windows XPS Document Writer, and 
> works fine on all existing computers. I just installed 4D and the database on 
> a brand new Win 10 computer, and clicking the Preview box on this computer 
> does not produce the preview screen - nothing happens.
> 
> The Windows XPS Document Writer is installed on this computer (I know it was 
> phased out by Microsoft in the 1803 version, but it is in the printer list). 
> The printer port for this driver is set to the default PORTPROMPT, and all 
> controls on the Port tab of the Printer Preferences screen are disabled.
> 
> I tried selecting the Windows XPS Document Writer in the print settings 
> screen - same result.
> 
> Any ideas besides Miyako's xpsview solution?
> 
> David
> 
> **
> 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 immediately quits on launch

[Randy Jaynes via 4D_Tech]

Sounds like the GateKeeper behavior on Mac when it’s not installed with a 
signed DMG or application.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com



> On Sep 27, 2019, at 9:04 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Got a client who has just upgraded to v17.
> He has installed it on a number of computers and they work OK. But on his
> own, it simply quits as soon as he tries to launch it. He's on Mac OS
> 10.2.6 and the version is 17.3.
> 
> Any suggestions on what to look for? He's tried the obvious things (delete
> prefs, restart the computer, etc.)
> 
> Pat
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Sending Text Messages From 4D

[Randy Jaynes via 4D_Tech]

Jim,

Have you tried using the PostMan application 
(https://www.getpostman.com/postman ) to 
work out the proper form of sending these requests?

I found it helped a lot in trying to figure out how to build the request to a 
couple REST APIs a last year.

It lets you build up the command string and see what you’re sending and what 
you’re getting back. From there it’s then easy to translate into the 
appropriate commands and variables to build the HTTP Request call you need in 
4D.

It may or may not help in this case, but it did make it faster and easier to 
see things when I was working on this stuff.

HTH,
Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com



> On Aug 5, 2019, at 3:42 PM, Jim Labos - infobase via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> Thanks Koen, but with the headers I get a 404. Not sure but I believe the
> headers are optional. My guess is that the "$tRequest" var is not formatted
> correctly.
> 
> I'm going to ask Twilio if they can help here.
> 
> Cheers
> 
> Jim Labos - infobase
> 
> 
> 
> -
> Jim Labos - infobase
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
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: Migrating 4D Write Pictures to 4D Write Pro Objects

[Randy Jaynes via 4D_Tech]

John,

Not sure about the component you mention, but you most likely have to run this 
in a 32bit version of v17 in order for it to work.

I worked through this by creating a method in my v13 structure doing this:

  
//-
ALL RECORDS([Letter])

$numRecs:=Records in selection([Letter])
$numRecsStr:=String($numRecs)

$wr_letter:=WR New offscreen area 
$path:=Util_File_getPathName (Structure file)+"Letters"+Folder separator
If (Test path name($path)#Is a folder)
CREATE FOLDER($path)
End if 

For ($i;1;$numRecs)
   If (Picture size([Letter]WR_Letter_)>0)

//-
//- LOAD THE LETTER INTO AN OFFSCREEN AREA -

//-
WR PICTURE TO AREA ($wr_letter;[Letter]WR_Letter_)


//-
//- SAVE THE AREA TO A DOCUMENT  
-

//-
//must have the .4W7 or the WP IMPORT DOCUMENT command will fail in v16+
  $fileName:=$path+"Letter_"+String([Letter]Letter_PK)+".4w7"
  WR SAVE DOCUMENT ($wr_letter;$filename;wr 4D Write document)
   End if 

   NEXT RECORD([Letter])
End for 
WR DELETE OFFSCREEN AREA ($wr_letter)
  
//-

The advantage here was that I had 4D Write in v13 exporting to its native .4W7 
files, and then 4D Write Pro in v17 was smoothly importing and converting the 
letters.

Not sure if that will help any, but this process has worked well for dozens of 
upgrades for our OEM database.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 



> On May 14, 2019, at 4:56 PM, John J Foster via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Hi All,
> 
> 4D v17R4 Windows and Macintosh Stand alone and 4D Server
> I do not have an old 4D Write plugin only the new 4D Write Pro
> App upgraded from 4D 2012 to 4D V17
> 
> I am working on the final v17 conversion piece migrating older 4D Write saved 
> in picture field to 4D Write Pro saved in object field. I am using the the 
> code from the component on the blog 
> "https://blog.4d.com/migrate-4d-write-documents-stored-in-picture-fields/#component
>  
> ”.
> 
> However, as I watch the code in the debugger, this is what I see:
> 
> $blob:=_Extract4W7From4DPicture ($1)
> If (BLOB size($blob)=0)
>   GET PICTURE FORMATS($1;$codecIDs)
>   If (Size of array($codecIDs)=1)
>   If ($codecIDs{1}=".pict”)
>   !!! // makes it to here so “knows” it’s a pict.
>   $blob:=_Extract4W7FromMacPicture ($1)
>   !!! // returns an empty blob
>   End if 
>   End if 
> End if 
> 
> Inside this routine "Extract4W7FromMacPicture ($1)” this line executes
> 
> PICTURE TO BLOB($1;$blob;"PICT") 
> 
> Always returns an empty blob even though $1 is a picture with a size like 
> 25ko.
> 
> So not sure what;’s going on and why it doesn’t work.
> 
> Does anyone have any experience with converting an older 4D Write saved in a 
> picture field into a 4D Write Pro object?
> 
> Appreciate,
> John…
> 
> 
> 
> 
> **
> 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: CSV import with version 13

[Randy Jaynes via 4D_Tech]

Chuck,

Try this: https://kb.4d.com/assetid=50956 

Charlie Vass wrote this Tech Note years ago (v11 era).

I adapted it to make a generate CVS_ParseLine utility in my database and it’s 
come in handy several times over the last few years.

HTH,
Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 



> On Apr 29, 2019, at 1:32 PM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Hi. All does anyone have v13 code that will do this they are willing to 
> share. I have new client still at 13 and I need to write import before I can 
> do upgrade
> 
> Thanks and regards
> 
> Chuck
> 
> Sent from my iPhone
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html 
> 
> Options: https://lists.4d.com/mailman/options/4d_tech 
> 
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
> 
> **

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

Re: CONVERT PICTURE v17

[Randy Jaynes via 4D_Tech]

You have to be careful about the transparency, though.

After doing this conversion with transparency, I found that some of our 
pictures in the picture library (and static pictures on forms) need white in 
some areas to be meaningful. So we had to carefully look at each one to be sure 
that transparency conversion didn’t take anything away and redesign the ones 
that needed white put back in certain areas.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 






> On Mar 9, 2019, at 9:35 PM, Charles Miller via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> You need to do convert in 32 bit and make sure to take care of transparency
> Chuck
> 
> On Sat, Mar 9, 2019 at 2:17 PM Wayne Stewart via 4D_Tech <
> 4d_tech@lists.4d.com > wrote:
> 
>> Are you running the code in 32 bit mode on a computer with QuickTime
>> installed?
>> 
>> On Sat, 9 Mar 2019 at 19:27, David Garrard via 4D_Tech <
>> 4d_tech@lists.4d.com >
>> wrote:
>> 
>>> I have some legacy pictures fields with .PICT pictures in them in my
>>> Windows database that I am converting to v17 64 bit.  Here is my code to
>>> convert the pictures to JPG format.
>>> 
>>> ALL RECORDS([DOCC_Document])
>>> For ($i;1;Records in selection([DOCC_Document]))
>>> GOTO SELECTED RECORD([DOCC_Document];$i)
>>> GET PICTURE FORMATS([DOCC_Document]Document_Icon;$aTPictureFormats)
>>>CONVERT PICTURE([DOCC_Document]Document_Icon;".jpg")
>>> SAVE RECORD([DOCC_Document])
>>> End for
>>> 
>>> The documentation suggests that this would convert the pictures in the
>>> database to jpg format and they would lose the "ugly big cross on PICT"
>>> replacement icon.  But I see no changes.
>>> 
>>> I must be doing something fundamentally wrong... Any ideas?
>>> 
>>> David Garrard
>>> **
>>> 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 
>>> 
>>> **
>> 
>> --
>> 
>> Regards,
>> 
>> Wayne
>> **
>> 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
>  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: Switching from FTP to Dropbox

[Randy Jaynes via 4D_Tech]

Tim,

I would think you could use their API with the HTTP Request command, and maybe 
some cURL calls for the actual file downloading.

The API looks similar to other REST APIs we’ve had to work with, so it _looks_ 
like it should work similarly.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 






> On Mar 1, 2019, at 10:20 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> I’m considering switching from using FTP to host update files to using my 
> Dropbox account. I’m wondering if anyone has written some 4D code that allows 
> uploading files to Dropbox and downloading files from Dropbox. 
> 
> I could get by uploading files to Dropbox via the macOS Finder integration 
> option. For downloading a dropbox file, can you just use the 4D HTTP Request 
> command?
> 
> Has somebody written a Dropbox Component?
> 
> 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
> **

**
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: Crash on startup, v17.1 merged app

[Randy Jaynes via 4D_Tech]

Yeah…that’ll show you.

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 email contacts to supp...@printpoint.com 
<mailto:supp...@printpoint.com>





> On Feb 28, 2019, at 1:17 PM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com 
> <mailto:4d_tech@lists.4d.com>> wrote:
> 
> Thanks Randy ... you are absolutely correct :) I had simply Zipped the
> files up. I created a signed installer with DropDMG and now it's OK.
> 
> That'll teach me to be lazy :)
> Pat
> 
> On Thu, 28 Feb 2019 at 16:00, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com 
> <mailto:4d_tech@lists.4d.com>>
> wrote:
> 
>> 1) Permissions issue on the folder on the Mac.
>> 
>> 2) Did you install it using a signed installer or DMG so that OS X
>> Gatekeeper recognizes it as a registered program.
>> 
>> This sounds more like #2 to me, but in the past I’ve solved #1 by creating
>> an Applications folder inside the user’s home folder, and putting the
>> application there.
>> 
>> Starting with High Sierra, I’ve been having to use a signed PKG installer
>> I made with Packages.app
>> 
>> HTH,
>> Randy
>> 
>> --
>> Randy Jaynes
>> Senior Programmer and Customer Support
>> 
>> http://printpoint.com <http://printpoint.com/> <http://printpoint.com/ 
>> <http://printpoint.com/>> • 845.687.3741 •
>> PrintPoint, Inc • 57 Ludlow Lane • Palisades, NY 10964
>> Please send all email contacts to supp...@printpoint.com 
>> <mailto:supp...@printpoint.com> > supp...@printpoint.com <mailto:supp...@printpoint.com>>
>> 
>> 
>> 
>> 
>> 
>>> On Feb 28, 2019, at 10:41 AM, Pat Bensky via 4D_Tech <
>> 4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com> 
>> <mailto:4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>>> wrote:
>>> 
>>> Running a compiled & merged single-user app v17.1 on a customer's Mac (OS
>>> v. 10.12.6), the app crashes soon after startup - before it has asked
>> for a
>>> data file.
>>> Of course, it runs OK on any other Mac we try it on :)
>>> If I hold down the Alt key as it's starting up, it never gets to the open
>>> options dialog.
>>> It just bounces in the cost a few times, then quits.
>>> Here is the relevant bit from the crash log:
>>> 
>>> 
>>> Thread 0 Crashed::  (id = 775)  Dispatch queue: com.apple.main-thread
>>> 0   4d.com.CattoGallery v9.1.app   0x0001034fc161
>>> MacStringToVString(unsigned char const*, int, xbox::VString&,
>>> VUniToMacConverter*) + 274
>>> 1   4d.com.CattoGallery v9.1.app   0x0001036e262e
>>> V4DLocalizationManager::_LocalizeStrSharpCode(int, int, xbox::VString&) +
>>> 174
>>> 2   4d.com.CattoGallery v9.1.app   0x00010388e82c
>>> V4DCoreApplication::RetainFolder(unsigned int) const + 94
>>> 3   4d.com.CattoGallery v9.1.app   0x00010388cf8b
>>> V4DCoreApplication::_Init_ResourceChain() + 99
>>> 4   4d.com.CattoGallery v9.1.app   0x00010388c909
>>> V4DCoreApplication::Init(unsigned int) + 445
>>> 5   4d.com.CattoGallery v9.1.app   0x0001035857bb
>>> V4DApplication::Init(unsigned int) + 95
>>> 6   4d.com.CattoGallery v9.1.app   0x0001036c7487 _main() + 40
>>> 7   libdyld.dylib 0x7fff9fa84235 start + 1
>>> 
>>> Can anybody shed any light on what this means?
>>> 
>>> Thanks!
>>> 
>>> Pat
>>> 
>>> --
>>> *
>>> CatBase - Top Dog in Data Publishing
>>> tel: +44 (0) 207 118 7889
>>> w: http://www.catbase.com <http://www.catbase.com/> 
>>> <http://www.catbase.com/ <http://www.catbase.com/>>
>>> skype: pat.bensky
>>> *
>>> **
>>> 4D Internet Users Group (4D iNUG)
>>> Archive:  http://lists.4d.com/archives.html 
>>> <http://lists.4d.com/archives.html> <
>> http://lists.4d.com/archives.html <http://l

Re: Crash on startup, v17.1 merged app

[Randy Jaynes via 4D_Tech]

1) Permissions issue on the folder on the Mac.

2) Did you install it using a signed installer or DMG so that OS X Gatekeeper 
recognizes it as a registered program.

This sounds more like #2 to me, but in the past I’ve solved #1 by creating an 
Applications folder inside the user’s home folder, and putting the application 
there.

Starting with High Sierra, I’ve been having to use a signed PKG installer I 
made with Packages.app

HTH,
Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 






> On Feb 28, 2019, at 10:41 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Running a compiled & merged single-user app v17.1 on a customer's Mac (OS
> v. 10.12.6), the app crashes soon after startup - before it has asked for a
> data file.
> Of course, it runs OK on any other Mac we try it on :)
> If I hold down the Alt key as it's starting up, it never gets to the open
> options dialog.
> It just bounces in the cost a few times, then quits.
> Here is the relevant bit from the crash log:
> 
> 
> Thread 0 Crashed::  (id = 775)  Dispatch queue: com.apple.main-thread
> 0   4d.com.CattoGallery v9.1.app   0x0001034fc161
> MacStringToVString(unsigned char const*, int, xbox::VString&,
> VUniToMacConverter*) + 274
> 1   4d.com.CattoGallery v9.1.app   0x0001036e262e
> V4DLocalizationManager::_LocalizeStrSharpCode(int, int, xbox::VString&) +
> 174
> 2   4d.com.CattoGallery v9.1.app   0x00010388e82c
> V4DCoreApplication::RetainFolder(unsigned int) const + 94
> 3   4d.com.CattoGallery v9.1.app   0x00010388cf8b
> V4DCoreApplication::_Init_ResourceChain() + 99
> 4   4d.com.CattoGallery v9.1.app   0x00010388c909
> V4DCoreApplication::Init(unsigned int) + 445
> 5   4d.com.CattoGallery v9.1.app   0x0001035857bb
> V4DApplication::Init(unsigned int) + 95
> 6   4d.com.CattoGallery v9.1.app   0x0001036c7487 _main() + 40
> 7   libdyld.dylib 0x7fff9fa84235 start + 1
> 
> Can anybody shed any light on what this means?
> 
> Thanks!
> 
> Pat
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com 
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html 
> 
> Options: https://lists.4d.com/mailman/options/4d_tech 
> 
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
> 
> **

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

Re: Comparing two structures...

[Randy Jaynes via 4D_Tech]

I would open copies of the 2 structures in v17R3 and use the export function 
from that so you get all the form objects and everything.

Then a diff tool (I use DeltaWalker) can compare everything for you.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.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: Sales Tax Solutions for 4D

[Randy Jaynes via 4D_Tech]

Jason,

Try setting up the REST call using the PostMan app at https://www.getpostman.com

It will be much faster to debug how to get your API calls set up properly. It 
was very helpful last month for me to get my REST calls for a Web2Print site 
set up properly.

My calls were generally like this:

//-
 
//- BUILD THE HEADER INFO WE NEED
--
//-
 ARRAY TEXT($aHeader_Name;0)
 ARRAY TEXT($aHeader_Value;0)
 APPEND TO ARRAY($aHeader_Name;"Content-Type")
 APPEND TO ARRAY($aHeader_Value;"application/json; charset=utf-8")
 APPEND TO ARRAY($aHeader_Name;"Authorization")
 APPEND TO ARRAY($aHeader_Value;"token "+$token)

 
//-

 //- SEND THE REQUEST TO PRESSERO 
--
 
//-
 $request:=""   
 $oResponse:=OBJ_Create 
 
$URL:="https://admin.chi.v6.pressero.com/api/calculators/?pageNumber="+String($startPage)+"&pageSize="+String($pageSize)+"&includeDeleted=false"

 ok:=1
 ON ERR CALL("pressero_REST_OnErrorHandler")  // LM: LRJ (Dec 19, 2018  9:27 
PM) 
 $Status:=HTTP Request(HTTP POST 
method;$url;$request;$oResponse;$aHeader_Name;$aHeader_Value)
 ON ERR CALL("")
If (ok=1)
// process the $oResponse   
End if  

HTH,
Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com






> On Jan 4, 2019, at 3:44 PM, JasonH via 4D_Tech <4d_tech@lists.4d.com> wrote:
> 
> Trying out Taxjar, but need a little help to get started.
> 
> I'm currently sending the following to https://api.taxjar.com (or
> api.sandbox.taxjar.com)
> $vt_HTTP_Request:=\
> "GET /v2/rates/"+$vt_Zip+<>CRLF+\
> "Host: "+$vt_Service_URL+<>CRLF+\
> "Connection: close"+<>CRLF+\
> "Cache-Control: no-cache"+<>CRLF+\
> "Content-type: text/html; charset=utf-8"+<>CRLF+\
> "Content-length: "+String($vi_Content_Length)+<>CRLF+\
> "Authorization: Bearer "+$vt_API_Key+<>CRLF+<>CRLF+\
> $vt_HTTP_Request
> 
> The actual HTTP request is blank, it's just all header.
> 
> The service is returning:
> {"error":"Unauthorized","detail":"Not authorized for route 'GET
> /v2/rates/98052'","status":401}
> 
> I feel like the zip should be part of the request, but the cURL example has
> it in the address.
> 
> Any ideas what I'm doing wrong?
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
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: looking for example of REST calls

[Randy Jaynes via 4D_Tech]

Chuck,

I’m in the process of finishing REST calls to the Pressero web2print API.

The majority of the methods I had to write are quite similar and go something 
like this:



ARRAY TEXT($aHeader_Name;0)
ARRAY TEXT($aHeader_Value;0)
APPEND TO ARRAY($aHeader_Name;"Content-Type")
APPEND TO ARRAY($aHeader_Value;"application/json; charset=utf-8")
APPEND TO ARRAY($aHeader_Name;"Authorization")
APPEND TO ARRAY($aHeader_Value;"token "+$token)

$oRequest:=OBJ_Create 
$oResponse:=OBJ_Create 

$URL:="https://admin.chi.v6.pressero.com/api/site 
/"+$siteDomain+"/users/"+$userGUID

$Status:=HTTP Request(HTTP get 
method;$url;$oRequest;$oResponse;$aHeader_Name;$aHeader_Value)

If ($status=200) //the status will be defined by your API…generally 200 or 201 
for a success, 400 range for a failure

   $oUser:=OB Copy($oResponse) //this obviously varies depending on your API

end if
——

Things that I learned along the way:

1) The API should tell you which type of method to use in the HTTP Request 
command (GET / PUT / POST / etc)

2) The API will tell you what (if any) items need to go into the 2 header arrays

3) Sometimes the $oRequest or $oResponse is a JSON object, other times 1 or 
both are simply text. It will depend on their end.

4) Postman is a great application to use to figure out what you need to do: 
https://www.getpostman.com/apps 

it helps you construct the URL properly with the necessary parameters, as well 
as the things you would need to put into the
headers (the 2 arrays I set up above) or include in the parameters of the URL 
you’re sending

I can’t recommend the Postman app highly enough for this.

Happy to answer any questions on this.

HTH,
Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 







> On Dec 11, 2018, at 9:43 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Hi all 
> 
> subj says it all. I may have to connect to a rest server and deliver a file 
> in that manner for one of my clients. As I have never used rest before, I was 
> hoping for an example of how that would be done. I looked on 4D web site and 
> in knowledge base but could not find what I was looking for. Any help 
> appreciated
> 
> 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: Anybody running v17 server on Windows 2008r2?

[Randy Jaynes via 4D_Tech]

Pat,

We have a couple users still using Windows Server 2008r2.

The only thing we ran into was an issue trying to use PHP Execute to unzip some 
files.

We found this tip
http://kb.4d.com/assetid=77608 

There is a note at the bottom that says
In order to properly use PHP in v14 and v15, the Microsoft Visual C++ 2008 SP1 
Redistributable Package (x86) 
 or .Net 
Framework 3.5 needs to be installed. 

I had to use the Server Manager to install the .NET framework and then we were 
good.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 






> On Nov 29, 2018, at 9:00 AM, Pat Bensky via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> And if so, do you have any problems with it?
> 
> Thanks
> Pat
> 
> -- 
> *
> CatBase - Top Dog in Data Publishing
> tel: +44 (0) 207 118 7889
> w: http://www.catbase.com 
> skype: pat.bensky
> *
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html 
> 
> Options: https://lists.4d.com/mailman/options/4d_tech 
> 
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
> 
> **

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

Re: Explorer bottom toolbar not displaying...

[Randy Jaynes via 4D_Tech]

First guess is to quit 4D and throw out the folder "4D Window Bounds v15” in 
your 4D folder.

On Mac, this is
~/Library/Application Support/4D/4D Window Bounds v15/

In Windows it’s somewhere in the C:/ProgramData folder I think.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 






> On Nov 20, 2018, at 2:32 PM, Garri Ogata via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Hello,
> 
> 4D v15.3 explorer is not displaying the bottom toolbar. There is no add, 
> minus (delete), or arrow for  preview or comments button. How do you get 
> these to reappear?
> 
> Thanks,
> Garri Ogata
> **
> 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
**

temporary folder command returning empty

[Randy Jaynes via 4D_Tech]

A customer just turned up a case running 4D Server v17HF2 on a Windows Server 
2012 box where the 4D command ’Temporary folder’ is returning an empty string.

Has anyone ever seen this before??

The command is being executed in a method with the ‘Execute on Server’ checkbox 
selected in the method’s properties.

Thanks,
Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.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: Mac Mojave and v17?

[Randy Jaynes via 4D_Tech]

4D (v17 and all the way back to v13.5) is having some issues with an internal 
MacOS drawing routine that is causing funkiness in:
1) ALP plugin drawing vertical text, the separator lines get a little 
“squiggle” to them
2) ALP drawing checkboxes in a boolean column
3) SOME, not all, pictures displayed in the Toolbox Resources/Images 
viewer don’t get drawn properly in the toolbox or on forms

I’ve already submitted a bug with 4D tech support related to this.

The 2 ALP issues are something tied to an internal plugin call, so it’s out of 
their hands…they have to wait for 4D to fix it.

This drawing issue appeared in the later versions of Mojave beta, about 2 weeks 
before the official release.

It’s definitely something changed in MacOS that 4D has been using internally 
for many years. 

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 






> On Nov 9, 2018, at 3:24 PM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Nothing too serious in my experience. There's some odd flickering when you 
> resize windows, but I haven't had any functionality issues.
> 
>> On Nov 9, 2018, at 3:18 PM, Dave Nasralla via 4D_Tech <4d_tech@lists.4d.com 
>> > wrote:
>> 
>> Anyone have any experience with this? I just picked up one of the new
>> 6 core Mac Minis with 32GB of RAM. Just wondering if anyone is aware
>> of any gotcha's or issues. I'll be running 64bit v17 apps and one v17
>> 32bit app.

**
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: Cross-platform Migration v15 App

[Randy Jaynes via 4D_Tech]

I did a move like this 10+ years ago.

The biggest thing I can remember is file path issues. There were places in the 
database where files were being saved with file names generated from the user 
data, so the code was only checking for path naming issues relevant to the Mac 
OS.

> On Oct 30, 2018, at 2:55 AM, Ronnie Teo via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi,
> 
> I have a client who has been running a pure-Mac environment for years.
> The current iteration is a v15 database application.
> 
> Going forward, their IT is toying with the idea of moving the 4D Server to a 
> Windows Server.
> The client users will all remain on the Mac.
> 
> Are there are any gotchas to take note of when converting this application 
> from v15 to v17 or later?
> Thanks.
> 
> Regards,
> Ronnie

**
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: What causes a record to be Locked but Locked By has no info?

[Randy Jaynes via 4D_Tech]

My first thought is transaction in another process somewhere.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Oct 11, 2018, at 1:48 PM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have a method that tests if a record is locked and if it is attempts to
> figure out by whom:
> 
> $text:="["+Table name($1)+"] "
> 
> LOCKED BY($1->;$process;$4Duser;$machineName;$p_Name)
> PROCESS
> PROPERTIES($process;$processName;$procState;$procTime;$procVisible;$uniqueID;$origin)
> 
> Case of
> : ($process=-1)
> 
> $text:=$text+"The record has been deleted."
> 
> : ($process=0)
> 
> $text:=$text+" is locked but there is no information available about who
> has it."
> 
> Else
> 
> $text:=$text+\
> 
> "Record number "+String(Record number($1->))+" is locked.\r"+\
> 
> "It's open by "+$4dUser+".\r\r"+\
> 
> "  Process : "+$p_Name+"\r"+\
> 
> "  Machine : "+$machineName+"\r\r"+("-"*20)+"\r"+\
> 
> "   Proc # : "+String($process)+"\r"+\
> 
> " Alt name : "+$processName
> 
> End case
> 
> 
> I've been using this for years. Recently I noticed (but it may have been
> going on for a while) records will return true for locked but LOCKED BY
> doesn't have any process associated with it. The only way I've been able to
> recreate this is to open a record in User Mode and attempt to load the
> record from another process. This works as expected. Then if I close the
> record in User and click off of it to deselect attempting to load from
> another process shows the record locked but no info.
> 
> It also occurs other times though I haven't been able to replicate it.
> Regardless, what to do?
> 
> This is v15 running on Mac Mojave so there is all sorts of possibilities
> for weirdness there. Wondering if anyone else has come across this?
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

**
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: Notes on converting pictures to v17

[Randy Jaynes via 4D_Tech]

Chip,

Try this: I know v13 doesn’t have the Transparency constant, so not sure which 
version of 4D it comes into play, but this was part of one of the conversion 
routines I ran into a while ago when I had to do this:

TRANSFORM PICTURE($Pict_G;Transparency;0x00FF)  //convert the WHITE to 
Transparent  

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Oct 8, 2018, at 11:19 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I have done this, although in v13.  I found that all my images now have 
> white backgrounds 
> any way to fix this without manually editing every single one??
> 
> On Mon, 8 Oct 2018 08:12:44 -0700, Kirk Brooks via 4D_Tech wrote:
>> I'm preparing to move a large, established project from v15 to v17 and
>> finally had to deal with the pictures. I've been putting this off at least
>> partly because of just not wanting to deal with this. Turns out it's not
>> that big a deal, at least for me.
>> 
>> When I've just done the conversion to see what happened lots of old forms,
>> the ones 4D creates, had the dreaded red X in the button icons. Most of my
>> forms were fine because for a long time I've been using icons from the
>> resource folder which were already .png. But I still had to do something
>> about the legacy images.
>> 
>> 1) converting the picture library
>> This was really easy. As numerous folks have pointed out this is where to
>> start:
>> 
>> http://kb.4d.com/assetid=76775
>> 
>> I don't have 4D Pack installed any more and didn't see an easy, native way
>> of determining what kind of file a picture library resource is. But then I
>> realized I really don't care what they were because I was going to make
>> them all .png now. So I modified the loop to simply convert all the images
>> to .png.
>> 
>> I did this in the v15 version.
>> 
>> 2) the outliers
>> A number of forms have static images in them. This illustrated the various
>> strategies 4D has used over the years for building the default forms. I
>> didn't pay enough attention to determine which versions did what but some
>> forms have static images as backgrounds that are incompatible and some
>> don't.
>> 
>> I quickly noticed lots of them were named "Picture6". Doing a find in
>> design located all the forms with "Picture6" and opened each one deleting
>> the obsolete image. Sometimes the image was OK. None of these forms are
>> user-facing so they don't really matter but the point is it's easy to find
>> them and relatively quick to delete them.
>> 
>> Bottom line - this wasn't nearly as painful or time consuming a deal as I
>> feared.
>> 
>> Unexpected discovery - the picture library is still a useful thing!
>> 
>> I had equated the library with .pict files and stopped paying attention to
>> it. This isn't the case and the tools for managing what's in the library
>> are simple to use. You can't edit images directly anymore (that's way gone)
>> but storing .png files is a snap and for me a lot easier than managing them
>> from Resources.
>> 
>> It's also easier if you have a large collection of icons but only use a
>> few. I have a set of icons I like and use but there are hundreds of them in
>> my development resources folder. I don't want to include all of them in
>> deployed databases so I have this method that loops all the forms and all
>> the objects making a list of the ones I actually use and then creating a
>> subset folder of just those icons for shipping. It's a PITA.
>> 
>> I am going to be changing that so I'll loop through all the form objects as
>> now but if I refer to a file in my icons folder I'll put a copy of that
>> icon in the library and change the ref in the object. This way I will be
>> able to refer to the full icon set during development but not ship it.
>> 
>> -- 
>> Kirk Brooks
>> San Francisco, CA
>> ===
>> 
>> *We go vote - they go home*
>> **
>> 4D Internet Users Group (4D iNUG)
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

***

Re: Notes on converting pictures to v17

[Randy Jaynes via 4D_Tech]

Kirk,

There is an easier way.

If you open a copy of your database in v17, and run MSC > Verify Application on 
it, it will point out all the bad form objects for you. The log file will show 
you entries like this in the sections where it is checking your project forms 
and table forms:

PrintPoint Home.Page0.ComponentGroup uses a deprecated picture format: PICT.
PrintPoint Home.Page0.rolloverEstimates uses a deprecated picture format: PICT.
PrintPoint Home.Page0.Picture6 uses a deprecated picture format: PICT.
PrintPoint Home.Page0.Picture7 uses a deprecated picture format: PICT.
 
Saves you from writing any code. :-)

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Oct 8, 2018, at 11:12 AM, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I'm preparing to move a large, established project from v15 to v17 and
> finally had to deal with the pictures. I've been putting this off at least
> partly because of just not wanting to deal with this. Turns out it's not
> that big a deal, at least for me.
> 
> When I've just done the conversion to see what happened lots of old forms,
> the ones 4D creates, had the dreaded red X in the button icons. Most of my
> forms were fine because for a long time I've been using icons from the
> resource folder which were already .png. But I still had to do something
> about the legacy images.
> 
> 1) converting the picture library
> This was really easy. As numerous folks have pointed out this is where to
> start:
> 
> http://kb.4d.com/assetid=76775
> 
> I don't have 4D Pack installed any more and didn't see an easy, native way
> of determining what kind of file a picture library resource is. But then I
> realized I really don't care what they were because I was going to make
> them all .png now. So I modified the loop to simply convert all the images
> to .png.
> 
> I did this in the v15 version.
> 
> 2) the outliers
> A number of forms have static images in them. This illustrated the various
> strategies 4D has used over the years for building the default forms. I
> didn't pay enough attention to determine which versions did what but some
> forms have static images as backgrounds that are incompatible and some
> don't.
> 
> I quickly noticed lots of them were named "Picture6". Doing a find in
> design located all the forms with "Picture6" and opened each one deleting
> the obsolete image. Sometimes the image was OK. None of these forms are
> user-facing so they don't really matter but the point is it's easy to find
> them and relatively quick to delete them.
> 
> Bottom line - this wasn't nearly as painful or time consuming a deal as I
> feared.
> 
> Unexpected discovery - the picture library is still a useful thing!
> 
> I had equated the library with .pict files and stopped paying attention to
> it. This isn't the case and the tools for managing what's in the library
> are simple to use. You can't edit images directly anymore (that's way gone)
> but storing .png files is a snap and for me a lot easier than managing them
> from Resources.
> 
> It's also easier if you have a large collection of icons but only use a
> few. I have a set of icons I like and use but there are hundreds of them in
> my development resources folder. I don't want to include all of them in
> deployed databases so I have this method that loops all the forms and all
> the objects making a list of the ones I actually use and then creating a
> subset folder of just those icons for shipping. It's a PITA.
> 
> I am going to be changing that so I'll loop through all the form objects as
> now but if I refer to a file in my icons folder I'll put a copy of that
> icon in the library and change the ref in the object. This way I will be
> able to refer to the full icon set during development but not ship it.
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

sql server unavailable

[Randy Jaynes via 4D_Tech]

What does it mean when a method suddenly starts getting a runtime error in a 
compiled database that says

Remote SQL Server is not available

The line number it gives is the End SQL line in the method.

The SQL code is a simple
SELECT field1, field 2 from table where (field3 = value) into var1, 
var2.

This is an older database using 4D v13.5, but the code has been running for a 
couple years and this is the first report of this issue.

Is it possible network department started blocking ports on their firewall, or 
just another  random SQL Server issue in 4D?

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.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: Anyone using FTP_Receive under 64-bit?

[Randy Jaynes via 4D_Tech]

Allan,

Here is a zip file with 4 methods to send and receive using callbacks for 
optional debugging messages and using the progress bar component for the 
uploads and downloads.

https://www.dropbox.com/s/ey2600zfie7o42i/cURL_FTP.zip?dl=0 


The cURL_Debug_Callback uses an interprocess messaging system to just display 
whatever message is passed. I didn’t include that because it’s a lot of arrays, 
interprocess communication, etc.

HTH,
Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Aug 15, 2018, at 6:59 PM, Allan Udy  wrote:
> 
> Hi Randy,
> 
> I'd greatly appreciate seeing a bit of example code that works. Many thanks.
> 
> 
> Randy Jaynes wrote on 16/08/18 9:25 AM:
>> Yes it does. I have it implemented if you’d like a copy of the method I can 
>> email it directly to you.
>> It’s fairly generic, but I can strip out the application specific stuff and 
>> comment it before sending.
> 
> Cheers,
> Allan Udy
> 
> Golden Micro Solutions Ltd, Blenheim, New Zealand
> http://www.golden.co.nz   
> 

**
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: Anyone using FTP_Receive under 64-bit?

[Randy Jaynes via 4D_Tech]

Yes it does. I have it implemented if you’d like a copy of the method I can 
email it directly to you.

It’s fairly generic, but I can strip out the application specific stuff and 
comment it before sending.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Aug 15, 2018, at 5:19 PM, Keith Culotta via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> FTP_Receive used to show the progress of the download.  That is no longer 
> available, and I think throws an error if it's used.
> 
> I think the cURL plugin shows the progress, or allows you to figure it out 
> somehow.
> 
> Keith - CDI
> 
>> On Aug 15, 2018, at 4:10 PM, Allan Udy via 4D_Tech <4d_tech@lists.4d.com 
>> > wrote:
>> 
>> Hi all,
>> 
>> I'm having a problem with Internet Commands FTP_Receive under 64-bit -- the 
>> command immediately returns a -2201 error and nothing is received (on Mac 
>> and Windows).
>> 
>> Using 4D v16R6 32-bit, the code works fine and files can be received. Same 
>> code using v16R6 64-bit fails.  The 64-bit version will successfully log in 
>> to the FTP site, and will retrieve a directory listing etc, but will not 
>> allow file download.
>> 
>> I've checked that the correct IC bundle is installed.  Have also tested with 
>> v16rR4 and v16.3. Have tested with two different FTP sites. Same issue.
>> 
>> Anyone else seeing this?  Anyone successfully using FTP_Receive under 64-bit.
>> 
>> What are the advantages/disadvantages of re-writing the code to use Keisuke 
>> Miyako’s cURL FTP plugin?
>> 
>> 
>> Cheers,
>> Allan Udy
>> 
>> Golden Micro Solutions Ltd, Blenheim, New Zealand
>> http://www.golden.co.nz 
>> >
>> 
>> **
>> 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: startup progress on server

[Randy Jaynes via 4D_Tech]

> On Aug 6, 2018, at 12:39 PM, Timothy Penner via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Regarding  the menu bars on server -
> 
>> Calling SET MENU BAR during On Server Startup
>> - this crash will occur in a test database with only this line of code in 
>> the On Server Startup method
> 
> This *was* a known issue, it was filed as ACI0097391. It should be fixed in 
> the latest v16 and v17 releases, I am not sure about the R release.
> 
> However, keep in mind that the command SET MENU BAR is documented to have no 
> effect on the server;
> http://doc.4d.com/4Dv17/4D/17/Stored-Procedures.300-3743249.en.html 
> 
> ^ So calling SET MENU BAR on the server is a mistake.
> 
> A wrapper for the SET MENU BAR command could look like this:
> 
> If(Application type#4D Server)
>SET MENU BAR($1)
> End if

Already done. We knew it was being ignored on server so hasn’t been an issue 
until now. It was the first change I made in trying to track this all down.

> 
> Regarding the progress window -
> 
>> opening a small window for showing progress messages during the startup 
>> routine. Especially important while running internal data update routines
> 
> The documentation summarizes it like this:
> {
> Generally speaking, stored procedures executed on the server should not deal 
> with interface items (such as menus, windows, forms...). Indeed the interface 
> is not managed on the server's side.
> Commands displaying dialog boxes on the server machine as well as dialog 
> boxes dealing with data entry should be avoided.
> }

Which we do in general, yes.

> 
> So I think this should probably be avoided also.

So what’s the recommendation on giving startup progress so they know that the 
server hasn’t frozen at some point during the startup method?

We do a simple order like
open window
… do stuff
DISPLAY  RECORD   <——displays a form with a picture and a text variable that we 
update
…do stuff
DISPLAY  RECORD
…do stuff
close window

We’ve been doing this for at least 18 years.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.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: startup progress on server

[Randy Jaynes via 4D_Tech]

SET MENU BAR has never actually done anything to change the menu bar on the 
server, so I think it’s just been ignored all these years.

It’s never been a problem until v16R6 Server. Of course, this is the first time 
we’ve had 64bit on Mac, so it may be related to that.

Either way, starting a stored procedure on server seems to be ignoring it 
again, so I’ve got that going for me.

Will test the 32 vs 64bit questions later.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Aug 6, 2018, at 11:54 AM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Just curious, does SET MENU BAR actually work from a Stored Procedure process 
> on 4D Server?I thought this was not supported. 
> 
> You can open a window from a Stored Procedure on 4D Server but I didn’t think 
> you could install your own menu bar, and have your own items in the menu bar 
> that you could select and have them perform actions. 

**
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: startup progress on server

[Randy Jaynes via 4D_Tech]

There could be, sure.

John DeSoi makes  a good point that it could b the 64bit version as opposed to 
32bit.

As I mentioned, the startup method was working fine up through v15.4 HF3, which 
was the last version before jumping to v16R6, but we went right to the 64bit 
version of that so I’ll have to test to be sure on that.

For now, I’m fine with using a stored procedure for the startup method.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Aug 6, 2018, at 10:24 AM, Dennis, Neil  > wrote:
> 
> Randy
> 
> There might be something else in the mix, all of my databases do a set menu 
> bar during startup and open a window for progress. I'm not having the same 
> crash you are. However I haven't tested with 4D v16r6.
> 
> Neil

**
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: startup progress on server

[Randy Jaynes via 4D_Tech]

We call QUIT 4D directly with no timer.

Our On Exit and On Server Shutdown methods already do checks to be sure the 
processes we started are dead.

I’m hoping for sure this is all that is needed. I didn’t think to test if this 
was only an issue related to 64bit version of server on Mac.

I’ll have to give that a shot as well. Regardless, at the moment at least, 
starting a new Stored Procedure to run the startup code seems to have done the 
trick for me.

I’ll test 32bit server on Mac later today. Have some other TS issues to catch 
up on first.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Aug 6, 2018, at 10:54 AM, John DeSoi via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Randy,
> 
> I'll be interested to hear if this permanently fixes the problem. I'm still 
> having random crash on quit errors on 4D Server (16.3HF4, 64-bit). Never a 
> problem in version 15, 32-bit. I have never connected crashing to a status 
> interface, but in my case it has always run in a separate process. I just 
> made a change to ensure that process is dead before QUIT 4D is called on the 
> server. Maybe that will completely solve it.
> 
> Did you look at the backtrace from the crash log? I would be interested to 
> see if we are experiencing the same issue. Below is what I see. I wonder if 
> that is related to displaying the countdown timer - I'm quitting with QUIT 
> 4D(60).

**
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: startup progress on server

[Randy Jaynes via 4D_Tech]

Ok. So moving our STARTUP method into a stored procedure using
$procID:=New Process(“STARTUP”;512000;”On Server Startup)

takes care of BOTH problems.

So it looks like the Application Server process on 4D Server v16R6 and higher 
is more sensitive to interface related commands like
OPEN WINDOW
SET MENU BAR
DISPLAY RECORD

For the record, this startup method was fine up through 4D v15.4 HF3.

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 email contacts to supp...@printpoint.com 
<mailto:supp...@printpoint.com>




> On Aug 6, 2018, at 10:15 AM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com 
> <mailto:4d_tech@lists.4d.com>> wrote:
> 
> I’ve spent the morning trying to track down why our database started crashing 
> when we quit 4D Server v16R6 on Mac OS…I haven’t tested yet to see if it 
> affects the Windows version as well.
> 
> I have tracked down 2 contributors to the crash.
> 
>   1) Calling SET MENU BAR during On Server Startup
>   - this crash will occur in a test database with only this line 
> of code in the On Server Startup method
>   
>   2) opening a small window for showing progress messages during the 
> startup routine. Especially important while running internal data update 
> routines
> 
> We use the same STARTUP method for both a client’s On Startup method and 
> server’s On Startup method, putting checks for (Application Type = 4D Server) 
> in appropriate places to skip over some pieces of code not needed on the 
> server.
> 
> So, item #1 is easy to fix by checking if I’m running on server or not.
> 
> Item #2, however, I need to solve a different way.
> 
> So the question to everyone here is: how to do you give feedback to the user 
> when starting up 4D Server?
> 
> My first attempt after this email is to move the current STARTUP method into 
> a stored procedure on the server using New Process to see if it just runs as 
> is.
> 
> I just wanted to see what others might suggest as well.
> 
> This STARTUP method has been working fine through many versions of 4D and 4D 
> Server. I know every new version of 4D gets tighter and tighter in its 
> behavior and coding needs and I have to adapt. Not complaining. Just need to 
> find out how to get my code tighter. :-)
> 
> Randy
> 
> --
> Randy Jaynes
> Senior Programmer and Customer Support
> 
> http://printpoint.com <http://printpoint.com/> <http://printpoint.com/ 
> <http://printpoint.com/>> • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
> Palisades, NY 10964 
> Please send all email contacts to supp...@printpoint.com 
> <mailto:supp...@printpoint.com> <mailto:supp...@printpoint.com 
> <mailto:supp...@printpoint.com>>
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> 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>
> **

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

startup progress on server

[Randy Jaynes via 4D_Tech]

I’ve spent the morning trying to track down why our database started crashing 
when we quit 4D Server v16R6 on Mac OS…I haven’t tested yet to see if it 
affects the Windows version as well.

I have tracked down 2 contributors to the crash.

1) Calling SET MENU BAR during On Server Startup
- this crash will occur in a test database with only this line 
of code in the On Server Startup method

2) opening a small window for showing progress messages during the 
startup routine. Especially important while running internal data update 
routines

We use the same STARTUP method for both a client’s On Startup method and 
server’s On Startup method, putting checks for (Application Type = 4D Server) 
in appropriate places to skip over some pieces of code not needed on the server.

So, item #1 is easy to fix by checking if I’m running on server or not.

Item #2, however, I need to solve a different way.

So the question to everyone here is: how to do you give feedback to the user 
when starting up 4D Server?

My first attempt after this email is to move the current STARTUP method into a 
stored procedure on the server using New Process to see if it just runs as is.

I just wanted to see what others might suggest as well.

This STARTUP method has been working fine through many versions of 4D and 4D 
Server. I know every new version of 4D gets tighter and tighter in its behavior 
and coding needs and I have to adapt. Not complaining. Just need to find out 
how to get my code tighter. :-)

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.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: picture of a form

[Randy Jaynes via 4D_Tech]

Sadly…that happened to me a couple weeks ago. Thankfully it was only the 
family, but our 20 year old son has latched onto it as never-ending source of 
personal glee.

I’m going through is childhood photos looking for some ammunition of my own. :-)

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 email contacts to supp...@printpoint.com 
<mailto:supp...@printpoint.com>




> On Jul 27, 2018, at 9:53 AM, Stephen J. Orth  <mailto:s.o...@the-aquila-group.com>> wrote:
> 
> Chip,
> 
> Not sure about you, but this has happened to me more than once.
> 
> Completely embarrassing when you do this in front of others.  I'm just so
> used to having them on my head, you forget they are there.
> 
> 
> Steve
> 
> 
> -Original Message-
> From: Chip Scheide [mailto:4d_o...@pghrepository.org 
> <mailto:4d_o...@pghrepository.org>] 
> Sent: Friday, July 27, 2018 8:48 AM
> To: 4D iNug Technical <4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>>
> Cc: Stephen Orth  <mailto:s.o...@the-aquila-group.com>>; Randy Jaynes
> mailto:ra...@printpoint.com>>
> Subject: Re: picture of a form
> 
> have you checked on top of your head?
> 
> :)
> 
> On Fri, 27 Jul 2018 09:27:02 -0400, Randy Jaynes via 4D_Tech wrote:
>> 
>> Now if only I could remember where my glasses are.
>> 
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> 
> 

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

Re: picture of a form

[Randy Jaynes via 4D_Tech]

Yep…Thanks, guys.

Good to know the rocker is still holding me up ok. :-)

Now if only I could remember where my glasses are.

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 email contacts to supp...@printpoint.com 
<mailto:supp...@printpoint.com>




> On Jul 26, 2018, at 4:42 PM, Stephen J. Orth  <mailto:s.o...@the-aquila-group.com>> wrote:
> 
> Randy,
> 
> I think its FORM SCREENSHOT
> 
> 
> Steve
> 
> 
> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com 
> <mailto:4d_tech-boun...@lists.4d.com>] On Behalf Of Randy Jaynes via 4D_Tech
> Sent: Thursday, July 26, 2018 3:38 PM
> To: 4D iNug List <4d_tech@lists.4D.com <mailto:4d_tech@lists.4D.com>>
> Cc: Randy Jaynes mailto:ra...@printpoint.com>>
> Subject: picture of a form
> 
> My feeble mind says there is some fairly new command that lets us get a 
> ‘screenshot’ of the current window or form.
> 
> Can’t think of right words to search because I’m not finding anything on KB 
> or searching documentation.
> 
> Am I off my rocker?
> 
> Randy
> 
> --
> Randy Jaynes
> Senior Programmer and Customer Support
> 
> http://printpoint.com <http://printpoint.com/> <http://printpoint.com/ 
> <http://printpoint.com/>> • 845.687.3741 • PrintPoint, Inc • 57 Ludlow Lane • 
> Palisades, NY 10964 
> Please send all email contacts to supp...@printpoint.com 
> <mailto:supp...@printpoint.com> <mailto:supp...@printpoint.com 
> <mailto:supp...@printpoint.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
**

picture of a form

[Randy Jaynes via 4D_Tech]

My feeble mind says there is some fairly new command that lets us get a 
‘screenshot’ of the current window or form.

Can’t think of right words to search because I’m not finding anything on KB or 
searching documentation.

Am I off my rocker?

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





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

Re: 4D Write PRO: editing a table / collections

[Randy Jaynes via 4D_Tech]

Another thing we’re struggling with is that we’re building 4D WP documents 
using code and make tables so that the resulting area can be easily turned into 
an HTML email.

Unfortunately, that makes the Write area awkward for a user to modify. It’s not 
easy to manipulate the tables (delete/add columns or rows, or delete the whole 
table).

We opted for this route in order to be able to go to HTML easily because we 
found that using tab stops didn’t translate well.

Seems to be a catch-22. We tried v17 today to see if it was any better than 
v16R6, but doesn’t seem to be.

Your solution for tracking the collection would seem to help if we were doing 
everything with code, but seems like it doesn’t change anything with regard to 
letting a user make changes themselves.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Jul 10, 2018, at 5:45 PM, Two Way Communications via 4D_Tech 
> <4d_tech@lists.4d.com > wrote:
> 
> I love the concept of tables in 4D Write Pro.
> 
> You can only add or change them by code, which is fine by me for the  moment.
> But what to do if a table has been created, and, in the 4D Write Pro 
> document, you would want to add a column, or a row? Or change the width, the 
> borders etc?
> 
> Apparently there is no way to select the table object. I have tried WP Get 
> selection, but that doesn’t work for tables. Or maybe I am missing something.
> 
> I found out that I can select the table again (in code) using WP 
> SELECT($tableObj). So, as soon as I have created the table in code, I copy 
> the table object in a collection. (Yes, I am using deep copy)
> I do that for every table created in the 4D Write Pro document.
> When I save the record, I put the collection variable in a blob (VARIABLE TO 
> BLOB), so I can retrieve the objects again.
> 
> When I open the record, I read the collection from the blob (BLOB TO 
> VARIABLE), but OK returns 0, and the collection variable stays empty.
> 
> Here’s the code:
> 
> C_COLLECTION(c4WRTableCollections)
> c4WRTableCollections:=New collection
> BLOB TO VARIABLE([_10_Report_templates]Blob_4WR_tbls;c4WRTableCollections)
>   
> 
>   
> Any idea why it’s doing that, and how one could create a table in a 4D Writw 
> PRO document, save it, open it again, and edit the table?
> 
> 
> 
> Regards,
> 
> Rudy Mortier
> Two Way Communications bvba 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html 
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Converting pictures on 4D forms (Windows) to get transparency

[Randy Jaynes via 4D_Tech]

> On Jul 9, 2018, at 3:28 PM, Bob Miller via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Randy - RE: You can use the MSC in v16 to flush out all the forms
> 
> Yes, this works well, and JPR's component does a lot of the same thing. In 
> working out the problems, I found however that what looked to be a 
> transparent background in 32 bit is not transparent in 64 bit (see above, 
> I now have a white box around many of my icons), so I think I need an 
> external drawing program to somehow convert the white background to 
> "transparent".

We had resolved this by using the picture conversion method from a tech note or 
tech tip…not sure if it’s the one others pointed out, but we did have to use 
that to export our entire picture library out to PNG files and get the 
transparency.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Converting pictures on 4D forms (Windows) to get transparency

[Randy Jaynes via 4D_Tech]

Bob,

You can use the MSC in v16 to flush out all the forms where bad pictures are 
located, as well as bad picture library items and their references.

Then use the picture conversion routine mentioned to convert the pictures to 
PNGs. We did this a couple months ago to prepare for our move to v16 and it 
worked well.

After doing all this, I discovered that there will also be potential issues 
with logos and pictures that you allowed users to put into their data. When you 
display the picture fields on a form, if the it is in PICT format you'll get 
that pretty camera with an X through it. ;-)

At any rate, start with the MSC in v16. It will quickly and easily point out 
what you need to fix in your structure.

HTH,
Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Jul 9, 2018, at 11:20 AM, Bob Miller via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Hi Everyone,
> 
> I'm in the process of going through a database to convert all the 
> pictures, icons, and such in it so I can use the database with 64-bit 4D 
> v16 (and eventually v17).
> 
> The documentation is pretty clear that even though any images pasted in 
> did not start life as PICTS - and I'm talking about things like arrows, 
> some icons, line drawings, navigation tools, etc., that are part of the 
> user interface, not actual photo type pictures -  4D would receive and 
> store them as PICTS, so you have to find each one and convert it.
> 
> To do this, I'm using JPR's Picture Conversion utility that he provided on 
> the 2017 4D Road Tour.  It does a fine job as it can scan all the forms, 
> find the offending pictures, list them, and then provides a utility where 
> you can either convert them and put them into the picture library or 
> convert them and put them into an external folder.
> 
> One thing I'm finding is that the conversion doesn't support transparency, 
> so I end up with pictures that have white backgrounds, which doesn't look 
> nice.  Here is part of a thread from me to JPR:
> 
> Me: When I drag a Static Picture to the converter, then back to the form, 
> it seems to lose its transparency, even though the 'Transparent' property 
> is turned ON.  How can this be fixed?
> JPR> It cannot. The transparency done previously by 4D was just a trick 
> replacing the white pixels with the background color dynamically, because 
> the concept of transparency didn't exist at this time (like in PICT, JPEG, 
> etc.) 
> JPR> Now 4D uses the modern toolbox which relies on the picture 
> transparency information coming from the alpha channel. So if you want 
> transparent pictures, you must convert into a format supporting alpha 
> channel (like PNG) and use any software able to add the alpha layer to 
> your pictures.  On Mac, the simplest one to add alpha channel is 
> PaintBrush (from Soggy Waffles). You add transparency with the paint Fill 
> tool
> 
> 
> The problem is that I'm on Windows.  Does anyone have a recommendation for 
> fast technique that they've used that supports this "alpha channel' so I 
> can convert my non-transparent images so that they are transparent again? 
> It looks so bad having an arrow on a form with a big white background.
> 
> Thank you -
> 
> 
> Bob Miller
> Chomerics, a division of Parker Hannifin Corporation 
> 
> 
> ll
> "PLEASE NOTE: The preceding information may be confidential or privileged. It 
> only should be used or disseminated for the purpose of conducting business 
> with Parker. If you are not an intended recipient, please notify the sender 
> by replying to this message and then delete the information from your system. 
> Thank you for your cooperation."
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html 
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Printing Write Pro to PDF

[Randy Jaynes via 4D_Tech]

Armin,

I would love to try it out. I’ll raise the subject in our next development 
meeting.

I’m tired of all these PDF driver headaches on Windows over all these years, so 
a single solution that I never have to worry about installation issues and 
missing stuff on a client computer or bad Windows permission or  would definitely be a welcome relief.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Jun 20, 2018, at 1:47 PM, ADeeg via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Randy,
> 
> as mentioned before, try our plugin, within 5 minutes you have a working
> solution. It produces very small pdf files and has a lot of features on top.
> And yes the sample database has also a Write Pro area to print
> 
> The plugin comes with a silent driver installer and works from WinXP up to
> the the latest win10
> 
> http://www.node.de/indexplug.htm 
> 
> Regards Armin 
> 
> P.S.: I've tried the Win 10 internal pdf printer from 4D v16.3hf3 32Bit. The
> result produces big pdf files and the pdf files are corrupted
> 
> 
> 4D Tech mailing list wrote
>> Tim,
>> 
>> As I mentioned in my original message, I cannot use PDFCreator. So this
>> does not work for me on Windows:
>>> SET PRINT OPTION(Destination option;3;fileName)
>> 
>> as per documentation, but that was why I mentioned that I wasn't using
>> PDFCreator.
>> 
>> As per docs, It works fine on Mac, but not Windows. Which is ok. I was
>> having issues getting to the other drivers.
>> 
>> For years we’ve been doing this with 4D Write by simply changing printers
>> to
>>  Adobe PDF
>>  Win2PDF
>>  PDF995
>> 
>> Each of these print drivers provides a way to programmatically set the
>> document name so the driver works.
>> 
>> So I have managed to make this block of code work for all drivers but
>> Adobe PDF:
>> 
>>  GET PRINT OPTION(Destination option;$saveDestination;$savePath) 
>>  SET PRINT OPTION(Destination option;2;$tFullDocumentPath)
>> 
>>  WP PRINT($WriteArea;wk 4D Write Pro layout)
>> 
>>  SET PRINT OPTION(Destination option;$saveDestination;$savePath)
>> 
>> I still have to use the mechanisms that each of the printer drivers
>> themselves require for giving the driver the document path, but WP PRINT
>> still requires me to use the SET PRINT OPTION command to set the path or
>> it puts up the save as dialog to get a name even though the printer driver
>> itself doesn’t need it or use it.
>> 
>> So now all I have to do is figure out what the heck is wrong with Acrobat
>> PDF. It works fine and produces a proper PDF if I manually print and
>> choose Acrobat PDF, but generates a corrupt PDF if try to do the above
>> code programmatically.
>> 
>> The file is not readable by any application (except a text editor) AND
>> it’s 11MB in size, where the other printer drivers product a 209KB file.
>> 
>> Fun. Fun. Fun.
>> 
>> Getting there, though.
>> 
>> Randy
> 
> 
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html 
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Printing Write Pro to PDF

[Randy Jaynes via 4D_Tech]

No difference when using OPEN PRINTING JOB.

It doesn’t appear to be related to WP PRINT specifically because I’m also 
getting bad PDFs generated when trying similar code like
OPEN PRINTING JOB
PRINT SELECTION (tableptr->;*) //also tried with  ;> and no 2nd 
parameter 
CLOSE PRINTING JOB

It fails on both a Windows 10 machine and a Windows 7 machine. No clue why.

Other PDF drivers are working fine and producing better PDFs anyhow, so I’m not 
going to worry about it at the moment.

It totally appears to be an Acrobat PDF issue right now, so I’m moving on.

Thanks,
Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Jun 20, 2018, at 12:38 PM, Timothy Penner  > wrote:
> 
> It doesn’t look like you are using a printing job. 
> http://doc.4d.com/4Dv15/4D/15.6/OPEN-PRINTING-JOB.301-3818590.en.html 
> 
>  
> Does using one make any difference?
>  
> GET PRINT OPTION(Destination 
> option;$saveDestination;$savePath)   
> SET PRINT OPTION(Destination option;2;$tFullDocumentPath)
>  
> OPEN PRINTING JOB
> WP PRINT($WriteArea;wk 4D Write Pro layout)
> CLOSE PRINTING JOB
>  
> SET PRINT OPTION(Destination 
> option;$saveDestination;$savePath)
>  
> I am not sure if it will help with the corrupt PDF or not, but encapsulating 
> the print operation in a printing job has been the suggested way of printing 
> since v11.
>  
> -Tim 
>  
> 
> 
>   
> Timothy Penner
> Senior Technical Services Engineer
> Email:tpen...@4d.com 
> Web:  www.4D.com  
> 4D Inc
> 95 S. Market Street, Suite #240
> San Jose, CA 95113
> United States
> Telephone:+1-408-557-4600

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Printing Write Pro to PDF

[Randy Jaynes via 4D_Tech]

Tim,

As I mentioned in my original message, I cannot use PDFCreator. So this does 
not work for me on Windows:
> SET PRINT OPTION(Destination option;3;fileName)

as per documentation, but that was why I mentioned that I wasn't using 
PDFCreator.

As per docs, It works fine on Mac, but not Windows. Which is ok. I was having 
issues getting to the other drivers.

For years we’ve been doing this with 4D Write by simply changing printers to
Adobe PDF
Win2PDF
PDF995

Each of these print drivers provides a way to programmatically set the document 
name so the driver works.

So I have managed to make this block of code work for all drivers but Adobe PDF:

GET PRINT OPTION(Destination option;$saveDestination;$savePath) 
SET PRINT OPTION(Destination option;2;$tFullDocumentPath)

WP PRINT($WriteArea;wk 4D Write Pro layout)

SET PRINT OPTION(Destination option;$saveDestination;$savePath)

I still have to use the mechanisms that each of the printer drivers themselves 
require for giving the driver the document path, but WP PRINT still requires me 
to use the SET PRINT OPTION command to set the path or it puts up the save as 
dialog to get a name even though the printer driver itself doesn’t need it or 
use it.

So now all I have to do is figure out what the heck is wrong with Acrobat PDF. 
It works fine and produces a proper PDF if I manually print and choose Acrobat 
PDF, but generates a corrupt PDF if try to do the above code programmatically.

The file is not readable by any application (except a text editor) AND it’s 
11MB in size, where the other printer drivers product a 209KB file.

Fun. Fun. Fun.

Getting there, though.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Jun 19, 2018, at 7:13 PM, Timothy Penner  > wrote:
> 
> Hi Randy
> 
>> However, I don’t seem to be able to do my 4D Write way of change
>> - switch printer to Adobe PDF / Web2Print / PDF995
>> - WR Print 
>> - switch back to normal printer
> 
> Where are you setting the filename?
> 
> Typically this is done with SET PRINT OPTION:
> http://doc.4d.com/4Dv16R4/4D/16-R4/SET-PRINT-OPTION.301-3318228.en.html 
> 
> 
> {
> Using a PDF option code (Windows)
> In order to be able to use a PDF option code in the option parameter, you 
> must have installed the PDFCreator driver in your 4D environment (for more 
> information, refer to the Integration of PDFCreator driver under Windows 
> section). Moreover, in order for option codes to be taken into account, you 
> need to have enabled control of PDF printing for 4D using the following 
> statement:
> 
> SET PRINT OPTION(Destination option;3;fileName)
> }
> 
> This KB article about printing 4D Write (not Pro) also seems to use the SET 
> PRINT OPTION:
> http://kb.4d.com/assetid=77200
> 
> -Tim
> 
> 
> 
> Timothy Penner
> Senior Technical Services Engineer
> 
> 4D Inc
> 95 S. Market Street, Suite #240
> San Jose,CA 95113
> United States
> 
> Telephone: +1-408-557-4600
> Fax:   +1-408-271-5080
> Email: tpen...@4d.com
> Web:   www.4D.com
> 

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Printing Write Pro to PDF

[Randy Jaynes via 4D_Tech]

So you mean maybe setting the document name in the WP Object?

Will research that and let you know.

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 email contacts to supp...@printpoint.com 
<mailto:supp...@printpoint.com>




> On Jun 19, 2018, at 5:18 PM, Charles Miller via 4D_Tech <4d_tech@lists.4d.com 
> <mailto:4d_tech@lists.4d.com>> wrote:
> 
> I think it sued work if you set window title to the name, the document
> would have that name. Not sure about now.
> 
> Regards
> 
> Chuck
> 
> On Tue, Jun 19, 2018 at 5:10 PM, Randy Jaynes via 4D_Tech <
> 4d_tech@lists.4d.com <mailto:4d_tech@lists.4d.com>> wrote:
> 
>> Has anyone successfully used WP Print to print a 4D Write Pro area in v16
>> to a PDF?
>> 
>> It seems we’re expected to go to PDFCreator, which I can’t do.
>> 
>> However, I don’t seem to be able to do my 4D Write way of change
>>- switch printer to Adobe PDF / Web2Print / PDF995
>>- WR Print 
>>- switch back to normal printer
>> 
>> We replaced the code for Wr Print with a call to WP Print, but we can’t
>> automatically name the document. WP PRINT throws up the SAVE AS dialog to
>> name the document.
>> 
>> I don’t see a way around this. Is there something I’m missing in the docs?
>> 
>> Thanks,
>> Randy
>> 
>> --
>> Randy Jaynes
>> Senior Programmer and Customer Support
>> 
>> http://printpoint.com <http://printpoint.com/> <http://printpoint.com/ 
>> <http://printpoint.com/>> • 845.687.3741 •
>> PrintPoint, Inc • 57 Ludlow Lane • Palisades, NY 10964
>> Please send all email contacts to supp...@printpoint.com 
>> <mailto:supp...@printpoint.com> > supp...@printpoint.com <mailto:supp...@printpoint.com>>
>> 
>> 
>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html <http://lists.4d.com/faqnug.html>
>> 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>
>> **
> 
> 
> 
> 
> -- 
> -
> 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
>  http://www.informed-solutions.com 
> <http://www.informed-solutions.com/>
> -
> This message and any attached documents contain information which may be
> confidential, subject to privilege or exempt from disclosure under
> applicable law.  These materials are intended only for the use of the
> intended recipient. If you are not the intended recipient of this
> transmission, you are hereby notified that any distribution, disclosure,
> printing, copying, storage, modification or the taking of any action in
> reliance upon this transmission is strictly prohibited.  Delivery of this
> message to any person other than the intended recipient shall not
> compromise or waive such confidentiality, privilege or exemption
> from disclosure as to this communication.
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html <http://lists.4d.com/faqnug.html>
> 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>
> **

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

Printing Write Pro to PDF

[Randy Jaynes via 4D_Tech]

Has anyone successfully used WP Print to print a 4D Write Pro area in v16 to a 
PDF?

It seems we’re expected to go to PDFCreator, which I can’t do.

However, I don’t seem to be able to do my 4D Write way of change
- switch printer to Adobe PDF / Web2Print / PDF995
- WR Print 
- switch back to normal printer

We replaced the code for Wr Print with a call to WP Print, but we can’t 
automatically name the document. WP PRINT throws up the SAVE AS dialog to name 
the document.

I don’t see a way around this. Is there something I’m missing in the docs?

Thanks,
Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: issue on windows 10 and 4D 15

[Randy Jaynes via 4D_Tech]

Chuck,

We’ve had weird display issues on specific machines when the user has set the 
display properties to more than 100% or they’ve selected a theme other than the 
default Windows theme.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Jun 15, 2018, at 8:09 AM, Chuck Miller via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Hi All,
> 
> I have one windows ten machine where pictures of buttons do not display 
> properly. They do on all other instances. We have deleting local files, 
> reinstalling 4D, to no avail. Any ideas out ther greatly appreciated
> 
> Thanks and regards.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: v13 - [Warning] Caomiler misses syntax problem

[Randy Jaynes via 4D_Tech]

v16R6 will catch yours as well as these 2 additional ones
C_Boolean($var1;;$var2)
C_Boolean($var1;)

4D Versions up through v15.4 HF3 missed all 3 of these mistakes.

V16R6 caught several errors in our database with all 3 of these items. I just 
had to fix several of these back on Thursday or Friday.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Jun 11, 2018, at 12:29 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> given:
> C_Boolean(;$My_Local_Var_Name)
> 
> Compiler fails to find the syntax error in the above.  During execution 
> (nterp) this results in My_Local_Var_Name being undefined.
> 
> hint in case you do not see the syntax error
> (;
> 
> Chip
> 
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html 
> Archive:  http://lists.4d.com/archives.html 
> 
> Options: https://lists.4d.com/mailman/options/4d_tech 
> 
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
> 
> **

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

Re: Analyzing .4BL Files

[Randy Jaynes via 4D_Tech]

I was just looking at this tech note last week
http://kb.4d.com/assetid=77626 

It’s a 4D Summit attendee only database, but I was impressed at how well it 
worked.

Now I have to go look at LogTools.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On May 16, 2018, at 11:59 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> i never done this with 4bl files, just a suggestion
> open with a text editor and examine the a 'real' log fuel and one of the 4bl 
> files
> usually the first few characters will determine the file type.
> 
> on a copy you could try changing the first few characters to match a 'real' 
> log file
> 
> ex: opening a pdf file with a text editor, a pdf has PDF1.1 (or whatever 
> version) as the first few characters 
> 
>> You know how you can open the MSC, go to Activity Analysis, and the 
>> Analyze the current log file? And export it to text? I need to go 
>> through a similar process with some log files that were backed up, 
>> but without integrating them. In the MSC there is a Browse button, 
>> but it won’t let me choose a .4BL file. Is there a trick to getting 
>> it to realize the .4BL file is a log file? I tried just changing the 
>> extension to .journal, but that didn’t work. Any ideas?
>> 
>> Thanks.
>> 
>> --
>> Cannon.Smith
>> Synergy Farm Solutions Inc.
>> Hill Spring, AB Canada
>> 403-626-3236
>> mailto:can...@synergyfarmsolutions.com>>
>> http://www.synergyfarmsolutions.com/>>
>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html 
>> Archive:  http://lists.4d.com/archives.html 
>> 
>> Options: https://lists.4d.com/mailman/options/4d_tech 
>> 
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
>> 
>> **
> 
> Hell is other people 
> Jean-Paul Sartre
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html 
> 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)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Write Pro Interface component v16R6

[Randy Jaynes via 4D_Tech]

So much stuff to try and remember.

Like Jody said…now I just have to remember _this_ link for the next time!

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On May 13, 2018, at 10:11 PM, cswirth via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Randy,
> 
> I encountered the same problem but then remembered 4D's caveat about
> widgets... they only will initialize properly on pages 0 and 1. This is
> documented here among other places.
> 
> http://doc.4d.com/4Dv16R6/4D/16-R6/4D-Widget-components.300-3713598.en.html 
> 
> 
> Regards,
> Scott Wirth
> 
> 
> 
> --
> Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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 Write Pro Interface component v16R6

[Randy Jaynes via 4D_Tech]

Just a word of warning to prevent headaches for anyone else in the future.

I just finished spending a few hours trying to figure out why the widget in the 
‘4D Write Pro Interface’ component embedded in v16R6 (and some earlier versions 
of v16) wouldn’t work in my database, I finally tracked it down.

The widget that includes both a WPArea and accompanying palette subform will 
not work properly unless it is on page 1 for your form.

It’s a timing issue. The On Load event in the WPArea object is defining some 
pointers and trying to get a selection from the WPArea C_Object, but 4D has not 
created the WPArea object yet, so errors occur in the On Load. Unfortunately, 
this prevents any of the code in the palette subform from working.

So the short is, you must keep the objects in this widget on page 1 of your 
form.

I submitted this as a bug, but until it is fixed, keep this in mind.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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 (US) Mirror site for downloading 4D Products?

[Randy Jaynes via 4D_Tech]

I’m not aware of US Mirrors, but I can send you a dropbox link(s) off list if 
you’d like.

Which platform? Or Both? 32bit or 64 bit Windows?

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Apr 20, 2018, at 5:04 PM, Dave Nasralla via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Hey All,
> 
> I'm trying to download a few things from 4D (Like a new installer for
> v16R6), but I'm getting speeds like 70Kb/sec which will take a couple
> of hours. Is there a US Mirror?
> 
> d
> 
> -- 
> David Nasralla
> Clean Air Engineering
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html 
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: Old versions of Area List Pro

[Randy Jaynes via 4D_Tech]

I have the installers for both mac & windows of the 7.5 that I mentioned.

I can shoot you a dropbox link for them if you need, or email them if you’d 
like. They’re about 3MB in size.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Mar 28, 2018, at 10:02 AM, Tom Dillon via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Milan Adamov via 4D_Tech wrote:
> 
>> is there an archive of old versions? I have to open of my very old
>> projects from year 2000 or 2001, I have serial numbers in code, but not
>> a copy of ALP plugin. What was the version number back then?
> 
> I have back to 6.0 for Mac, if you need. If so, use the email address below.

**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: Old versions of Area List Pro

[Randy Jaynes via 4D_Tech]

Looking back through my archives, I have ALP 7.5 from ForeSight dated Mar 
11,1999 so I’d start there.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Mar 28, 2018, at 5:44 AM, Milan Adamov via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Hi,
> 
> is there an archive of old versions? I have to open of my very old projects 
> from year 2000 or 2001, I have serial numbers in code, but not a copy of ALP 
> plugin. What was the version number back then?
> 
> Milan
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html 
> 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)
FAQ:  http://lists.4d.com/faqnug.html
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: overlapping subforms

[Randy Jaynes via 4D_Tech]

I have a form with 3 subform container objects sitting on top of each other. I 
just use OBJECT SET VISIBLE to hide the ones that don’t need to be seen at the 
moment.

They all occupy the same space on the parent form, so because I hide the 2 not 
needed, the ordering on the form does not matter.

I use a tab to control which one is visible at the moment. Your buttons could 
serve the same purpose.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Mar 19, 2018, at 4:40 AM, Piotr Chabot Stadhouders via 4D_Tech 
> <4d_tech@lists.4d.com > wrote:
> 
> Hi,
> 
> I have a form with a couple of subforms on it
> Now I want to add another subform, that is on top of 3 others, and becomes 
> visible when pressing a button
> You can see it as a kind of popup viewer
> Because the subform must show in front of the others, in design mode I put 
> the subform container to the front
> However, when I save the form the subform container disappears to the back 
> again
> 
> Are there known problems putting subforms on top of each other?
> 
> Gr,
> 
> Piotr
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html 
> 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)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

time entry filter

[Randy Jaynes via 4D_Tech]

Does anyone know of a filter string or something that can be done so people 
don’t have to be entering times in a time field/variable in 24h format?

The display of HH:MM AM/PM is great, but when you click into the field it 
switches to 00:00:00 and shows the nice 4:08 PM as 16:08:00 and expects you to 
enter as 24h format.

I hate to think I have to create a method myself to do something this basic. I 
must be missing something in these docs, right?

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





**
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
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: "Failed to synchronize Resources folder." Error

[Randy Jaynes via 4D_Tech]

No issues with plugins, but we have a similar issue where 1 single user at 1 
single location is getting errors logging in once or twice in the morning 
(random times) with a runtime error dialog saying

Cannot delete folder C:\Users\{user name}\AddData\Local\Temp\4D\{component 
name}_{random long string}\.

Cannot delete folder C:\Users\{user name}\AddData\Local\Temp\4D\{component 
name}_{random long string}\ not empty.

The ‘problem’ folder changes though.

We may get a screenshot one week where the folder for {component name} is 
XML_Tools and 4D Widgets. She’ll be fine for a few days or weeks, then she gets 
it again and its SVG_Area and 4D Widgets.

Then a few days later its 4D Widgets and 4D Progress.

Its all random. The problem folders are not always in the components folder 
(XML_Tools and SVG_Area only), but they are always in the \temp folder path 
where the user should have full permissions anyhow.

And all of this is before we ever even get into our On Startup method, so 4D is 
still doing its internal housekeeping stuff.

This is an OEM version of 4D v13.5, and only this 1 user amongst hundreds at 
many locations.

This one just happens to be an Enterprise level user with their own in house IT 
people (separate server and desktop teams)….been fun.

Just clueless. It started happening last September. Once per week, different 
days, for a while. Then nothing for the first couple weeks in December.

Bizarre, but true: When the user gets this dialog, she can continue on in. Then 
immediately log out, then log back in with no issues. 

Very frustrating.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Jan 16, 2018, at 12:55 PM, Tim Nevels via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> I’ve recently seen a big increase in this error message reported by two 
> clients running 4D Server v14.4. 
> 
> Also have seen “The plug-in method cannot be executed.” error message that 
> appears to be connected to this in some situations.
> 
> Client reports this for some users, but not all. Some users have never gotten 
> this error message, others have received it several times over the last few 
> month. Both clients are all Windows 10 users. 
> 
> Doing my tech support on this I have tracked this down to the “resources” or 
> “local cache files” that 4D creates. The location is: 
> "C:\Users\{userName}\AppData\Local\{programName}”. 
> 
> I would go try to delete this folder and Windows Explorer would report it was 
> unable to because it contains files that were in use. It was necessary to 
> restart the computer to be able delete the folder. Once the folder is deleted 
> 4D Remote would startup and recreate the folder without error.
> 
> One guess is anti-virus software. I’m wondering if that could be scanning or 
> fooling around with this folder and making 4D Remote think it needs to 
> rebuild the Resources folder. Of course I’ve not installed new versions of my 
> 4D application so there should be no need to do this. So why are some users 
> seeing this happen?
> 
> Is it possible the anti-virus software — and I don’t know which one the 
> clients are using — is seeing ".dll” files in this folder and freaking out 
> and doing something to them that is triggering this mess. Doing a restart of 
> the machine and then immediately deleting the folder always fixes the 
> problem. 
> 
> Something has changed for some users that is causing this problem to start 
> happening, but I’m not sure what it is.
> 
> Has anyone else seen an increase in this error message from clients in the 
> past few months? 
> 
> Tim
>   
> Tim Nevels 
> timnev...@mac.com   >
> Innovative Solutions
> 785-749-3444
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html 
> Archive:  http://lists.4d.com/archives.html 
> 
> Options: http://lists.4d.com/mailman/options/4d_tech 
> 
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
> 
> **

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

Re: v12 & v13 server - compatability with OS X High Sierra (10.13)

[Randy Jaynes via 4D_Tech]

chip,

A big issue we’re seeing with v13.5 and High Sierra is copy/paste.

Pasting works fine in design environment, but in runtime, at random times, it 
can cause the app to go ‘rainbow cursor’ for a couple minutes before the Mac 
gives up and returns control to the user…and you don’t end up with your pasted 
text in place either.

Unfortunately, the user generally thinks the app has crashed after maybe 30 
seconds.

I don’t know if this is in certain window types on Mac, or just dialogs.

I just tried some random tests to try and make it fail, but of course 
everything worked fine. Perhaps the yesterday’s MacOS update fixed it for me??

Now I have to look into this too.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com  • 845.687.3741 • PrintPoint, Inc 
• 57 Ludlow Lane • Palisades, NY 10964 
Please send all email contacts to supp...@printpoint.com 





> On Jan 10, 2018, at 10:20 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> I understand these versions are NOT certified.
> anyone have experience?
> do wither of these versions of 4D worK on High Sierra (10.13)?
> 
> 
> Thanks!
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html 
> Archive:  http://lists.4d.com/archives.html 
> 
> Options: http://lists.4d.com/mailman/options/4d_tech 
> 
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
> 
> **

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

Re: 4D v6.8

[Randy Jaynes via 4D_Tech]

I’m glad I’m not the only one who keeps a Mac 10.6 Server kicking around in 
VMWare.

Pretty much the same reason. :-)

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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






> On Nov 16, 2017, at 3:32 PM, Charles Miller via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Great idea I have 10.6.8 server running as a VM ware partition for exactly
> that reason. Jody, if you can nto get this I will be more than happy to
> install 6.87 and remove whatever you tell me from the source.
> 
> I bought 10.6.8 server from Apple for about 20 bucks. I would bet it is

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

Re: subforms and object focus

[Randy Jaynes via 4D_Tech]

Cannon,

YOU WIN!!!

We did the following (so everyone else knows:

1) Create a new method pEst_SF_SetTimer which simply calls
SET TIMER (-1)

2) Turn on the On Timer even on the subform

3) Add the following code to the form method of the subform
Case of 
: ($evt=On Timer)
   GOTO OBJECT([Estimate]Job_Name)
   SET TIMER(0)
End case 

4) Add the following code to the On Load case of the parent form
EXECUTE METHOD IN SUBFORM("estSubform";"pEst_SF_SetTimer")  //set timer for 
subform

The GOTO OBJECT call is then executed in the context of the subform AFTER the 
full ON LOAD cycle has finished, and has the added benefit of automatically 
having all of the text highlighted so we don’t have to worry about the 
HIGHLIGHT TEXT shortcoming.

Piece of cake (4 hours later). 

I guess I should throw out the “I’d like to make a phone call” statement 
earlier in the game and get to the prize more quickly. :-)

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 






> On Nov 15, 2017, at 12:52 PM, Cannon Smith via 4D_Tech <4d_tech@lists.4d.com 
> <mailto:4d_tech@lists.4d.com>> wrote:
> 
> Hi Randy,
> 
> You have to call the GOTO OBJECT in the next execution cycle of the form. One 
> way to do this is call SET TIMER(-1) and then run the GOTO OBJECT in the On 
> Timer event.
> 
> HTH.
> 
> --
> Cannon.Smith
> Synergy Farm Solutions Inc.
> Hill Spring, AB Canada
> 403-626-3236
> mailto:can...@synergyfarmsolutions.com>>
> http://www.synergyfarmsolutions.com/>>
> 
> 
>> On Nov 15, 2017, at 10:34 AM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com 
>> <mailto:4d_tech@lists.4d.com>> wrote:
>> 
>> The idea here is that I open the parent form and I want to be sitting in the 
>> first field on the subform with all of its text highlighted.
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html <http://lists.4d.com/faqnug.html>
> Archive:  http://lists.4d.com/archives.html 
> <http://lists.4d.com/archives.html>
> Options: http://lists.4d.com/mailman/options/4d_tech 
> <http://lists.4d.com/mailman/options/4d_tech>
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
> <mailto:4d_tech-unsubscr...@lists.4d.com>
> **

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

Re: subforms and object focus

[Randy Jaynes via 4D_Tech]

I tested the firing sequence of On Load and got this:

1) object method of an object on subform
2) form method of the subform
3) object method of the subform container on the parent form
4) form method of the parent form

We tried doing the GOTO OBJECT call in each of these places, using both forms 
of the call
GOTO OBJECT([estimate]job_name)
GOTO OBJECT (*;”jobName”)

When those 8 tests failed, we moved to a method and calling that method using
EXECUTE METHOD IN SUBFORM

Again testing calling the method in all 4 places, and again using the other way 
of calling GOTO OBJECT.

Totally at a loss. The conflicting notes about GOTO OBJECT in the docs seem to 
point toward it just doesn’t work.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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






> On Nov 15, 2017, at 2:27 PM, Jeremy Roussak via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> How about putting the GOTO OBJECT in the On load phase of the subform’s form 
> method?

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

Re: subforms and object focus

[Randy Jaynes via 4D_Tech]

Ok…so HIGHLIGHT TEXT docs say it doesn’t work in subforms, so I guess that’s 
out.

But it seems I still can’t get GOTO OBJECT to work in a subform either.

I’m so sad. :-(

Going to test with v16R4 just in case.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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






> On Nov 15, 2017, at 12:34 PM, Randy Jaynes  > wrote:
> 
> Has anyone figured out how go to a specific object in a subform when opening 
> the parent form (currently in v15.4 HF3)?
> 
> The docs for Page Subforms 
> (http://doc.4d.com/4Dv15/4D/15.4/Page-subforms.300-3285433.en.html 
> ) says
> 
>   The GOTO OBJECT command looks for the destination object in the parent 
> form even if it is executed from a subform.
> 
> While the docs for GOTO OBJECT 
> (http://doc.4d.com/4Dv15/4D/15.5/GOTO-OBJECT.301-3577086.en.html 
> ) says:
> 
> The GOTO OBJECT command can be used in the context of a subform. When it is 
> called from a subform, it first looks for the object in the subform, then, if 
> the search does not find anything there, it extends the search to objects of 
> the parent form.
> 
> I’ve tried calling a method using EXECUTE METHOD IN SUBFORM which does a GOTO 
> OBJECT followed by HIGHLIGHT TEXT, but nothing I do ever leaves me in the 
> object in the subform that I want.
> 
> The entry order on the subform doesn’t matter either.
> 
> The idea here is that I open the parent form and I want to be sitting in the 
> first field on the subform with all of its text highlighted.
> 
> I (3 of us together actually) cannot figure this one out.
> 
> Any ideas?
> 
> I’m going to convert a copy to v16R4 and test there to see if I’m crazy or 
> not.
> 
> Thanks,
> Randy
> 
> --
> Randy Jaynes
> Senior Programmer and Customer Support
> 
> http://printpoint.com  • 845.687.3741 • PrintPoint, 
> Inc • 57 Ludlow Lane • Palisades, NY 10964 
> 
> 
> 
> 
> 
> 

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

subforms and object focus

[Randy Jaynes via 4D_Tech]

Has anyone figured out how go to a specific object in a subform when opening 
the parent form (currently in v15.4 HF3)?

The docs for Page Subforms 
(http://doc.4d.com/4Dv15/4D/15.4/Page-subforms.300-3285433.en.html) says

The GOTO OBJECT command looks for the destination object in the parent 
form even if it is executed from a subform.

While the docs for GOTO OBJECT 
(http://doc.4d.com/4Dv15/4D/15.5/GOTO-OBJECT.301-3577086.en.html) says:

The GOTO OBJECT command can be used in the context of a subform. When it is 
called from a subform, it first looks for the object in the subform, then, if 
the search does not find anything there, it extends the search to objects of 
the parent form.

I’ve tried calling a method using EXECUTE METHOD IN SUBFORM which does a GOTO 
OBJECT followed by HIGHLIGHT TEXT, but nothing I do ever leaves me in the 
object in the subform that I want.

The entry order on the subform doesn’t matter either.

The idea here is that I open the parent form and I want to be sitting in the 
first field on the subform with all of its text highlighted.

I (3 of us together actually) cannot figure this one out.

Any ideas?

I’m going to convert a copy to v16R4 and test there to see if I’m crazy or not.

Thanks,
Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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






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

Re: find only partial strings

[Randy Jaynes via 4D_Tech]

Match RegEx should be able to do that for you.

Provided you get the pattern matching string correct.

That’s always a fun task. :-)

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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






> On Oct 27, 2017, at 3:07 PM, Peter Mew via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Hi
> If I have a document, that has both the word "seg" and the word "segment",
> is there a way I can find the positions of just the word "seg"
> I can look at the character following "seg" to see if its an "m", but I
> wondered if there was a more direct route.


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

Re: [offish]Volume of mail

[Randy Jaynes via 4D_Tech]

I think we’re all too lazy to get up and move all the way over to the 4D forums.

I do go there for research and find the forums much more active, and with far 
many more users than we see here.

And with 4D themselves pushing us in that direction, I see more and more of us 
who have been on this list for 20+ years posting less and less here.

I don’t think it’s a diminished community because the forums certainly seem to 
be thriving, and I have to admit the ability to add links and images and so on 
makes it easier to illustrate our problems. What I _don’t_ like is that it’s 
much more work to get it done.

I think mailing lists are just a thing of the past and a few of us are holding 
on for all we’re worth.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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





> On Oct 5, 2017, at 12:52 PM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> I know that many of you have been on this list for a long time, as have 
> I.
> 
> I have noticed, over the past couple of years, that the volume of email 
> on this list has dropped - a lot -. It used to be, that if I was out of 
> the office, or whatever, and unable/unwilling to check email for 1 or 
> more days, I could expect to see ~100 emails/day from this list. While 
> I have not done an actual count, I believe that currently this list 
> sees, on average about 100 emails a week.
> 
> While this might be a good thing (less bugs to report/talk about etc), 
> I find it troubling in that it likely reflects a significantly 
> diminished use of the 4D product.
> 
> Thoughts, Anyone?
> Chip

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

Re: CONVERT PDF TO PICTURE

[Randy Jaynes via 4D_Tech]

I use ImageMagick with Ghostscript.

I have utility method that I do this, and actually run it on the server so I 
only have to install it there rather than on every single client machine:

---
 
$srcPict:=$1
$width:=$2
$height:=$3
$fileExtension:=$4

  //- save the picture to a temporary file 
-
$srcFile:=Temporary folder+"tempPictFile."+$fileExtension
$dstFile:=Temporary folder+"tempPictFile_thumb.png"
WRITE PICTURE FILE($srcFile;$srcPict)

  //- convert it using ImageMagick -
$convertPath:=System folder(Applications or Program Files)+"ImageMagick\\"  
//user must install 32bit static version of IM and be sure to change the path 
at installation time (default path includes the version number)

If (Test path name($convertpath)=Is a folder)  //make sure user has it installed
   $srcFileCmd:=$srcFile+"[0]"  //add [0] because we only want page 1 of the 
document
   $cmd:="convert -thumbnail 
"+String($width)+"x"+String($height)+Char(Space)+Char(Double 
quote)+$srcFileCmd+Char(Double quote)+Char(Space)+Char(Double 
quote)+$dstFile+Char(Double quote)+Char(Carriage return)+Char(Line feed)

   SET ENVIRONMENT VARIABLE("_4D_OPTION_HIDE_CONSOLE";"true")
   SET ENVIRONMENT VARIABLE("_4D_OPTION_CURRENT_DIRECTORY";$convertPath)
   LAUNCH EXTERNAL PROCESS("cmd.exe";$cmd;$output;$errorTxt)
End if 

$0:=$dstPict

---
 I make sure that ImageMagick is installed into a folder in Program Files 
called ‘ImageMagick’ so that I can hard code the path to the ‘convert' function 
above.

HTH,
Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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





> On Sep 16, 2017, at 2:18 PM, stardata.info  via 
> 4D_Tech <4d_tech@lists.4d.com > wrote:
> 
> Hi,
> 
> What use on windows?
> 
> Thanks
> 
> /Ferdinando/
> 
> 
> Il 16/09/2017 19:43, Christian Sakowski ha scritto:
>>> Using 4D i need to convert one PDF documento to jpeg document.
>> CONVERT PICTURE on Mac only, and first page only. Other pages with hmFree.
>> --
>> 
>> Grüße/Regards,
>> [heubach-media] | Christian Sakowski
>> christian.sakow...@heubach-media.de 
>> 
>> iChat/AIM: SakowskiF
>> Tel: +49/(0)40/52 10 59-23
>> 
>> 
>> 
>>> Am 16.09.2017 um 12:14 schrieb stardata.info via 4D_Tech 
>>> <4d_tech@lists.4d.com>:
>>> 
>>> Hi All,
>>> 
>>> Using 4D i need to convert one PDF documento to jpeg document.
>>> Someone know how i can do?
>>> 
>>> Thanks
>>> Ferdinando
>>> **
>>> 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
>>> **
>> 
>> --
>> heubach media
>> Osterfeldstr. 12-14 | Haus 1 | Eingang Nord
>> 22529 Hamburg
>> tel: 040 / 52 10 59 - 10 | fax: -99
>> mail: i...@heubach-media.de
>> home: www.heubach-media.de
>> Geschäftsführer|CEO: Matthias Heubach
>> 
>> Mieten Sie Ihre Computer, iPads & Drucker für Ihre Events bei:
>> http://www.milo-rental.com
>> 
>> Diese E-Mail enthält vertrauliche und/oder rechtlich geschützte 
>> Informationen.
>> Wenn Sie nicht der richtige Adressat sind oder diese E-Mail irrtümlich 
>> erhalten haben,
>> informieren Sie bitte sofort den Absender und vernichten Sie diese Mail.
>> Das unerlaubte Kopieren sowie die unbefugte Weitergabe dieser Mail ist nicht 
>> gestattet.
>>  This e-mail may contain confidential and/or privileged information.
>> If you are not the intended recipient (or have received this e-mail in error)
>> please notify the sender immediately and destroy this e-mail.
>> Any unauthorized copying, disclosure or distribution of the
>> material in this e-mail is strictly forbidden.
>> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html 
> Archive:  http://lists.4d.com/archives.html 
> 
> Options: http://lists.4d.com/mailman/options/4d_tech 
> 
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
> 
> **

Re: v12 server - can not connect

[Randy Jaynes via 4D_Tech]

Firewall?

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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





> On Sep 11, 2017, at 11:44 AM, Chip Scheide via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> I am trying to move an older v12 database from one Mac to another
> The current mac is running 10.9.5, and v12.6 server - everything is 
> fine.
> 
> I am setting up a new server to handle the lab's file sharing needs 
> (old file server is a G5)
> The new Mac is running 10.9.5 Server. I have the v12 database copied, 
> and the server application starts.
> It claims to be running.
> 
> I attempt to connect from another Mac (10.9.5 OS), from which I have 
> connected to the old v12 database in the past. Up on connecting to the 
> new v12 server, I get connection has been disrupted or the connection 
> could not be established. Error -10002
> 
> Any clues?
> Thanks
> Chip
> ---
> Gas is for washing parts
> Alcohol is for drinkin'
> Nitromethane is for racing 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html 
> Archive:  http://lists.4d.com/archives.html 
> 
> Options: http://lists.4d.com/mailman/options/4d_tech 
> 
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com 
> 
> **

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

Re: Convert 4D data MSSQL

[Randy Jaynes via 4D_Tech]

Sure looks like it!

I wasn’t even aware of this command in 4D, but it calls it a ‘dump’, so that’s 
the kind of text file I would expect this to create.

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 





> On Sep 7, 2017, at 11:42 AM, Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com 
> <mailto:4d_tech@lists.4d.com>> wrote:
> 
> I think this is what SQL EXPORT DATABASE and SQL EXPORT SELECTION do.  You 
> might have some issues with date/time fields as well as object fields.
> 
> --
> Jeffrey Kain
> jeffrey.k...@gmail.com <mailto:jeffrey.k...@gmail.com>
> 
> 
> 
> 
>> On Sep 7, 2017, at 11:40 AM, Randy Jaynes via 4D_Tech <4d_tech@lists.4d.com> 
>> wrote:
>> 
>> Maybe you can write 4D code to create blocks of insert statements in a text 
>> file like
>> 
>> LOCK TABLES `CatalogPricing` WRITE;
>> 
>> INSERT INTO `CatalogPricing` (`catPriceID`, `catPriceCatalogID`, 
>> `catPriceQty`, `catPriceAmount`, `catPriceStatus`)
>> VALUES
>>  (2,2,1,15.00,'1'),
>>  (7,3,1,15.00,'1'),
>>  (9,4,1,14.95,'1'),
>>  (12,6,1,14.95,'1'),
>>  (14,8,1,14.95,'1'),
>> [...]
>> UNLOCK TABLES;
>> 
>> Then just import/run the SQL files in MSSQL.
>> 
>> There are some data types you might have to deal with in other ways, but 
>> this might handle most of what you need.
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Convert 4D data MSSQL

[Randy Jaynes via 4D_Tech]

Maybe you can write 4D code to create blocks of insert statements in a text 
file like

LOCK TABLES `CatalogPricing` WRITE;

INSERT INTO `CatalogPricing` (`catPriceID`, `catPriceCatalogID`, `catPriceQty`, 
`catPriceAmount`, `catPriceStatus`)
VALUES
(2,2,1,15.00,'1'),
(7,3,1,15.00,'1'),
(9,4,1,14.95,'1'),
(12,6,1,14.95,'1'),
(14,8,1,14.95,'1'),
(17,7,1,14.95,'1'),
(19,9,1,14.95,'1'),
(20,10,1,14.95,'1'),
(21,5,1,14.95,'1'),
(22,11,1,14.95,'1'),
(23,12,1,14.95,'1'),
(24,13,1,14.95,'1'),
(25,14,1,14.95,'1'),
(26,15,1,14.95,'1'),
(27,16,1,14.95,'1');

UNLOCK TABLES;

Then just import/run the SQL files in MSSQL.

There are some data types you might have to deal with in other ways, but this 
might handle most of what you need.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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



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

Re: Unable to Compile - Crash - looking for ideas - SOLVED

[Randy Jaynes via 4D_Tech]

Randy,

I would also recommend changing the settings from
Generate Typing
to
All Variables are typed

This gives you control over the typing of your variables, and the line you 
point out would have kicked out a compiler error about the unknown ‘variable1’ 
in your line of code.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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





> On Aug 21, 2017, at 11:42 AM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com 
> > wrote:
> 
> Hi Jody,
> 
> I went through all of my methods that I'd changed in the last 3 days 
> (fortunately, I commented changes with a datestamp!)
> 
> About 100 methods.
> Looked at each line of code 
> 
> FINALLY found the culprit
> 
> Method_Something(->variable1;"something else")
> 
> Where in the above line, the "1" at the end of the variable was a mistake.
> 
> So this faux variable was not typed at all.
> 
> Syntax Check, Generate Typing, Compiler didn't trap the error.
> 4D just quit.


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

Re: Missing Pict - 64bit Removes pictures from library

[Randy Jaynes via 4D_Tech]

Randy,

You can use 4D commands to figure out where these are used. I wrote a utility 
routine to track down things like this and where some formats are used so I 
could flush out the ones that aren’t in the Filters list in the Toolbox.

You should be able to find what you’re looking for using the commands
FORM GET OBJECTS
OBJECT Get Type
OBJECT Get format

These will let you get a list of objects on the form, loop through them, and 
check the objects. 

I found that objects from my picture library have a format like
?6909
?162
?32741

Objects that are pictures from our Resources folder have a format like
#images/Print_16x16.png
#images/magnify_blue_16x64.png

I have a method that I can call from a button on a form to dump everything on 
it, and then another method that will loop through all project forms and table 
forms to create a big dump file of the entire database.

Handy for tracking all the uses of these things so I can get them converted as 
we need.

Would love to get the handy JPR tool that Neil mentioned to see what that does.

HTH,
Randy

--
Randy Jaynes
Senior Programmer and Customer Support

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





> On Aug 9, 2017, at 3:00 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> FYI;
> 
> Been messing with 64bit v16r4
> 
> Found that most (not all) of my PICTURE LIBRARY pictures went south.
> 
> If I open the app in the 32 bit version, they are all still there.
> 
> So... what Christian said below, is more than a "good idea"
> 
> Not looking forward to redoing all of these pictures into the resources 
> folder and then finding all references to them.
> 
> Arrrgghhh!
> 
> 😉
> 
> Randy Engle, Director
> XC2 Software LLC – XC2LIVE!
> mailto:  randy.en...@xc2software.com
> PH:  800.761.4999 – 415.456.9200
> 
> 
> -Original Message-
> From: 4D_Tech [mailto:4d_tech-boun...@lists.4d.com] On Behalf Of Christian 
> Sakowski
> Sent: Thursday, January 26, 2017 6:29 AM
> To: 4D iNug Technical <4d_tech@lists.4d.com>
> Subject: Re: Missing Pict
> 
>> SET PICTURE TO LIBRARY($vpPict;$vPictRef;$vPictName)
> 
> FYI: Never use the library anymore. It's obsolete since v11. You have to use 
> the Resources-Folder. 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: 4D Not Seeing A Mounted Network Drive

[Randy Jaynes via 4D_Tech]

If this is 4D Server running as a *service* on Windows Server 2012R2, you have 
to be sure that the user under which the server runs has the network drive 
mounted.

This has been done for me by IT people at the places I’ve run into this, so I’m 
not really sure exactly what it is they are doing, but they had to modify the 
startup script (or something like that) to mount the drive for the user ‘Local 
System’ or whatever that default user for the 4D Service is.

I simply told them what user account and they did the rest.

HTH,
Randy

> On Jul 11, 2017, at 9:19 AM, John S. Poteat via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> I have a system where I am trying to create a folder or write a file to a 
> mounted network drive.
> When I try to create a folder or write a file to that drive, 4D comes back 
> with an error. If I try to
> do it to a physical drive on the computer, it has no problem.
> 
> Has anyone ran into this problem before and found a solution?
> 
> The system is running on Windows Server 2012R2 and using 4D version 15.2 HF1.
> 
> Thanks in advance for your help.
> 
> Thanks,
> John Poteat
> jpote...@gmail.com 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Finding where a filter or format is used in a structure

[Randy Jaynes via 4D_Tech]

I haven’t tried this - does the log let you know where these deletions occurred 
so you can go set them to more appropriate filters?

That was the reason I had written my method - I needed to track down 
inconsistencies.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • (845) 359-0298 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 




> On May 12, 2017, at 9:00 AM, Paul Lovejoy via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Yes, great idea. Deleting the filter and the repairing with MSC removes all 
> the filters in variables and fields.
> 
> Thanks for the tip.
> 
> 
> Paul
> 
>> Le 12 mai 2017 à 13:15, Keisuke Miyako via 4D_Tech <4d_tech@lists.4d.com> a 
>> écrit :
>> 
>> you could FORM GET NAMES ,
>> iterate with FORM LOAD, FORM GET OBJECTS, OBJECT Get filter
>> and process the results.
>> 
>> alternatively,
>> you could create a copy of the structure,
>> delete the filter in toolbox and run MSC verify.
>> 
>> 2017/05/12 20:08、Paul Lovejoy via 4D_Tech 
>> <4d_tech@lists.4d.com> のメール：
>> 
>> With the good old 4D Insider it was easy to find where filters and formats 
>> created in the Toolbox were used in a structure. This feature disappeared 
>> with v11 and I certainly miss it, as I have to remove filters from fields 
>> and variables in v15 which are causing problems with certain accented 
>> characters (per my topic "Circumflex strangeness with v15 on OS X 10.10.5”.
>> 
>> Is there a way in v15 to find where filters and formats are used?
>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> FAQ:  http://lists.4d.com/faqnug.html
>> Archive:  http://lists.4d.com/archives.html
>> Options: http://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: Finding where a filter or format is used in a structure

[Randy Jaynes via 4D_Tech]

I have a utility method and a calling method for looping through the forms that 
dumps the following information into a text file on desktop for all table forms 
and project forms.

The columns it writes are

Table
Form Name
Page #
Object Name
Variable / Field Name
Format
Help Tip
Filter

I created it for exactly the purpose you outlined, but it should be easy to add 
any additional info you want.

I’m happy to email them to you if it will help.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • (845) 359-0298 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 




> On May 12, 2017, at 7:15 AM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> you could FORM GET NAMES ,
> iterate with FORM LOAD, FORM GET OBJECTS, OBJECT Get filter
> and process the results.
> 
> alternatively,
> you could create a copy of the structure,
> delete the filter in toolbox and run MSC verify.
> 
> 2017/05/12 20:08、Paul Lovejoy via 4D_Tech 
> <4d_tech@lists.4d.com> のメール：
> 
> With the good old 4D Insider it was easy to find where filters and formats 
> created in the Toolbox were used in a structure. This feature disappeared 
> with v11 and I certainly miss it, as I have to remove filters from fields and 
> variables in v15 which are causing problems with certain accented characters 
> (per my topic "Circumflex strangeness with v15 on OS X 10.10.5”.
> 
> Is there a way in v15 to find where filters and formats are used?
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: PROCESS 4D TAGS

[Randy Jaynes via 4D_Tech]

Mitch,

I stumbled on this a few weeks ago. I think I tracked it down to a 
compatibility setting
Use 4DVAR comments instead of Brackets

I think my database had that turned off.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • (845) 359-0298 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 




> On Apr 28, 2017, at 9:44 AM, Mitchell Shiller via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> v14 OSX
> 
> HTML Template:
> 
> 
> 
>   
> 
> 
> 
>   
> 
> 
> 
> Method:
> 
> C_TEXT(tHTML;tTemplate;$tPathname;tData)
> $tPathname:=Get 4D folder(Current resources folder)+"Templates"+":"+"Test 
> Template.html"
> tTemplate:=Document to text($tPathname)
> tData:="Hello There"
> PROCESS 4D TAGS(tTemplate;tHTML)
> 
> Result:
> 
> The Template is loaded but tData is not replaced with “Hello There”. i.e. 
> tHTML is the same as 
> 
> 
> What am I missing?
> 
> Thanks
> 
> Mitch
> 
> 
> 
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: PDFCreator and Windows 7

[Randy Jaynes via 4D_Tech]

Maybe not helpful, but I gave up on PDFCreator long ago because of 
inconsistencies like this.

We moved to Win2PDF and life is much more sane. It works right out of the box 
and was easy to implement.

True, it’s not free, but in 6 years I’ve only had to contact their tech support 
people 2 times and they fixed my problem quickly and easily.

The $30 (or $35) that it costs is extremely cheap next to the amount of time 
spent trying to figure out what the heck PDFCreator is doing, especially the 
intermittent nature of what you’re seeing.

Also, you could upgrade to Windows 10 which has a built-in option that seems be 
working well.

Having been where you are, I just wouldn’t spend time trying to fight 
PDFCreator.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • (845) 359-0298 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 




> On Apr 14, 2017, at 11:23 AM, David Rose via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> I installed PDFCreator v1.7.3 on my Win 7 box. I am running 4D v15
> client/server. In 4D I want to programmatically set the destination folder and
> file name for pdf files. The code below works perfectly most of the time, but
> intermittently the PDFCreator file-saving dialog appears. My code looks like
> this:
> 
> $PDFFilePath_t:="(Full Path Here)"
> PAGE SETUP([MyTable];"MyList")
> SET CURRENT PRINTER(PDFCreator Printer name)
> FORM SET OUTPUT([MyTable];"MyList")
> SET PRINT OPTION("PDFOptions:UseAutosave";1)
> SET PRINT OPTION("PDFOptions:UseAutosaveDirectory";1)
> SET PRINT OPTION(Destination option;3;$PDFFilePath_t)
> PRINT SELECTION([MyTable];*)
> SET PRINT OPTION("PDFInfo:Reset standard options";0)
> 
> Any ideas how to fix this?
> David 
> **
> 4D Internet Users Group (4D iNUG)
> FAQ:  http://lists.4d.com/faqnug.html
> Archive:  http://lists.4d.com/archives.html
> Options: http://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

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

Re: sending mail with Exchange server

[Randy Jaynes via 4D_Tech]

Thanks, Lutz.

Will look into these.

I know it’s a Pandora’s box and it gets very frustrating, for sure. So many 
variables.

I suspect something on Exchange, but I’m told it’s managed by Comcast, so it’s 
not going to be fun getting any changes made that we might need.

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • (845) 359-0298 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 




> On Mar 10, 2017, at 9:55 AM, Epperlein, Lutz (agendo) 
>  wrote:
> 
> Hi,
>  
> you just opened the whole box of Pandora regarding email sending. In the last 
> years more and more techniques are evolved to prevent spam, SPF, DKIM, DMARC 
> to name a view. And if someone argue "it worked in the past for years" it is 
> the best sign, there could be something wrong. We are not anymore in the past 
> ...
>  
> But seriously, email sending is a complex thing. If someone gets the mail in 
> the spam folder and someone not, it is as best a sign, that in the second 
> case is something wrong with email configuration on the server side. 
> As an example, there is an interesting software called Discourse 
> (http://www.discourse.org/ ) which heavily based 
> on sending of emails. They give you interesting hints what to do to get the 
> emails running. I quote it here:
> Email deliverability is complicated. Here are a few important things you 
> should check first:
> 
> ·Be sure to set the notification email from: address correctly in 
> your site settings. The domain specified in the "from" address of the emails 
> you send is the domain your email will be validated against.
> 
> ·Know how to view the raw source of the email in your mail client, so 
> you can examine email headers for important clues. in Gmail, it is the "show 
> original" option in the drop-down menu at the top right of each mail.
> 
> ·IMPORTANT: Does your ISP have a reverse DNS record entered to 
> associate the domain names and IP addresses you send mail from? Test your 
> Reverse PTR record  here. If your 
> ISP does not enter the proper reverse DNS pointer record, it's very unlikely 
> any of your email will be delivered.
> 
> ·Is your domain's SPF record 
>  correct? Test your SPF record 
>  here. Note that TXT is the 
> correct official record type for SPF.
> 
> ·Is your domain's DKIM record  correct? This 
> will significantly improve email deliverability. Test your DKIM record 
>  here.
> 
> ·If you run your own mail server, check to make sure the IPs of your 
> mail server are not on any email blacklists 
> . Also verify that it is 
> definitely sending a fully-qualified hostname that resolves in DNS in its 
> HELO message. If not, this will cause your email to be rejected by many mail 
> services.
> 
> ·We highly recommend you send a test email to mail-tester.com 
>  to verify that all the above is working 
> correctly.
> 
> I recommend mail-tester.com  too. It helps really 
> and gives you exact steps to solve problems. The most problem are to solved 
> on the sender’s side.
>  
> Regards
> Lutz

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

sending mail with Exchange server

[Randy Jaynes via 4D_Tech]

We’ve been using 4D InternetCommands for many years to connect to SMTP servers 
directly and send emails out of our database.

In the last few years it’s been getting harder and harder to keep up with the 
various security requirements of different servers.

The most recent issue is that a customer has started having his emails go to 
his Spam folder when the emails have him set as a CC recipient so that his 
Outlook has an email trail for him.

The bad part is that his customers are having his emails go to their spam 
folder as well, so they don’t get his quotes.

We just spent a lot of time yesterday testing with his Exchange server, and we 
can create the exact same email in Outlook and send it with him as the sender 
and a CC recipient with no problem.

Try sending it from our database with him as the sender and any recipient (TO 
or CC or BCC) and it goes to Spam in Outlook.

It seems to be something without Outlook because when he sends them to one of 
our addresses, they don’t go to spam.

They only solution we have found is to have him call his recipients and make 
sure they whitelist his domain in their email application.

I looked at the mail headers and nothing is obvious as to what is causing 
Outlook to see these as Spam.

Anyone have clues why this has started happening. He says after the last update 
of our software (way back in August), but we haven’t changed this code in a 
couple years, so we may be victim to a coincidental upgrade in Exchange or 
something. Hard to say.

Just trying to find a way to prevent this from happening.

Any ideas?

Randy

--
Randy Jaynes
Senior Programmer and Customer Support

http://printpoint.com • (845) 359-0298 • PrintPoint, Inc • 57 Ludlow Lane • 
Palisades, NY 10964 




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