Re: Windows Build - STR# 10135, 18/19 Folders

[John J Foster via 4D_Tech]

Hi Allan,

> Did you ever get to the bottom of this?

Not that I recall. I discovered that I could just go inside the folder and use 
the compiled app.

However, I have been using 4D v17R5 and I don’t see it anymore. And I’m not 
sure when it stopped being created?

Sorry I can’t be more help Allan.

John...


> On Dec 11, 2019, at 5:25 PM, Allan Udy  wrote:
> 
> Hi John
> 
> Did you ever get to the bottom of this?
> 
> I've just had v17R6 start to do this to me under Windows 10 when I attempt to 
> compile/merge engine an app that compiled perfectly fine with v17R5.
> 
> In my case the Server and Clients apps are in a folder called 
>   STR# 10135, 20
> 
> Any light you can shed on this would be hugely appreciated.
> 
> Cheers
> Allan
> 
> 
> 4d_tech-requ...@lists.4d.com  wrote on 
> 11/03/19 3:34 AM:
>> From: John J Foster  
>> To: 4D iNug Technical <4d_tech@lists.4d.com> 
>> Subject: Windows Build - STR# 10135, 18/19 Folders
>> 
>> Hey All,
>> 
>> I couldn’t find anything in KB that explained this situation.
>> 
>> Windows 10 - 4D v17r4
>> 
>> I just noticed that the build of an engined version of my app creates two 
>> foldersnamed:
>> 
>> STR# 10135, 18 -> Appname.4dbase -> includes the .4DC/.4DIndy files
>> STR# 10135, 19 -> Appname -> includes executable
>> 
>> Is this related to the application build XML or JSON file?
> 
> 
> 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: PRINT SETTINGS Not setting OK to 1

[John J Foster via 4D_Tech]

Hey Tim (et al),

Some curious facts:

1. Placing PRINT SETTINGS in the on load works and returns OK=1 if Print or PDF 
selected.

2. Once the form is loaded and a button is clicked - really any button - the 
same PRINT SETTINGS command will be equal to 0 (zero) no matter what is 
selected.

3. There are no OK buttons being set in any code related to this method and 
dialog objects.

Weird!

I persevere …

John...

> On Dec 11, 2019, at 2:28 PM, John J Foster  wrote:
> 
> Hey Tim,
> 
> So created a new db with only this code appears to work:
> 
> PRINT SETTINGS
> If (OK=1)
>   ALERT("Print!")
> Else 
>   ALERT("Cancelled!")
> End if 
> 
> So there is something in our application that has caused this behavior.
> 
> So I’ll have to figure a way to troubleshoot.
> 
> I guess that’s progress!
> 
> Thanks Tim,
> John…
> 
> 
>> On Dec 11, 2019, at 2:03 PM, Tim Nevels  wrote:
>> 
>> On Dec 11, 2019, at 3:38 PM, John J Foster  wrote:
>> 
>>> Well I did fail to mention I ma running Windows 10 Pro on parallels 15.1.
>>> 
>>> But my client is also running Windows 10 Pro but on a windows only computer.
>>> 
>>> I’ll test your ideas - as always very reasonable - and let you know.
>> 
>> Hi John,
>> 
>> I’m running Windows 10 Home on Parallels 14.1.3.
>> 
>> 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
**

Re: AW: HTTP Upload file size too low

[Jim Labos - infobase via 4D_Tech]

Ok thanks for the link Jim.

Essentially what 4D is saying (and it makes sense) is that the BLOB will
need a contiguous block of memory and so if memory is fragmented and no
block large enough exists 4D rejects the entire upload. That may be why I
was getting inconsistent limits on different days.

To break it up in chunks is not a solution I am looking for. I will be
looking into FTP. My users will be needing to click on a button on a form to
upload documents. I have other problems of which one is that there has to be
a button for each specific document uploaded as it has to go into a specific
folder. Naming the button gives me that ability. There the problem is that
thye could select many documents before uploading any of them and then any
"submit" button would Post the form and there comes all these documents at
once (so now that memory issue is increased even more). I am looking into
the selection and upload being one operation and not 2. Which would force
the upload everytime instead of waiting for a Post event.

Got some research to do.

Cheers



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

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

[Ken Eyring via 4D_Tech]

Hi Everyone,

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


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


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


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


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


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



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


Thanks,
Ken


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

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

[Robert McKeever via 4D_Tech]

Yep, this is a pain.

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

Now start your database.

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

Now quit your database.

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

Now quit your database.

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

> On Dec 12, 2019, at 10:20 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi Everyone,
> 
> I'm migrating from 4D v15.4 32-bit to v17.3 64-bit.  At the same time, I am 
> also moving my development machine from Mac OS 10.9.5 to Mac OS 10.15.2.
> 
> So far it's going fairly smoothly, but a few quirks have come up regarding 
> plugins.  When I launch v17.3 on Mac OS 10.15.2, I get the following alerts 
> for these 4D Plugins:
> 
> - "4D InternetCommands.bundle" cannot be opened because the developer cannot 
> be verified
> 
> - "4D ODBC Pro.bundle" cannot be opened because the developer cannot be 
> verified
> 
> - "4D for OCI.bundle" cannot be opened because the developer cannot be 
> verified
> 
> I'm assuming there is a configuration somewhere that I can set to allow the 
> plugins to be opened - but can't find where.
> 
> 
> I'm also trying to find a way to capture the MAC address on Macs and Windows. 
>  Up until now, I've been using Miyako's Media Access Control.bundle, but it 
> doesn't look like it works with v17.  Any suggestions to accomplish this task 
> would be appreciated.
> 
> Thanks,
> Ken
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **

_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.com




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

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

[Chip Scheide via 4D_Tech]

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

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

Chip

On Thu, 12 Dec 2019 13:20:19 -0500, Ken Eyring via 4D_Tech wrote:
> Hi Everyone,
> 
> I'm migrating from 4D v15.4 32-bit to v17.3 64-bit.  At the same 
> time, I am also moving my development machine from Mac OS 10.9.5 to 
> Mac OS 10.15.2.
> 
> So far it's going fairly smoothly, but a few quirks have come up 
> regarding plugins.  When I launch v17.3 on Mac OS 10.15.2, I get the 
> following alerts for these 4D Plugins:
> 
> - "4D InternetCommands.bundle" cannot be opened because the developer 
> cannot be verified
> 
> - "4D ODBC Pro.bundle" cannot be opened because the developer cannot 
> be verified
> 
> - "4D for OCI.bundle" cannot be opened because the developer cannot 
> be verified
> 
> I'm assuming there is a configuration somewhere that I can set to 
> allow the plugins to be opened - but can't find where.
> 
> 
> I'm also trying to find a way to capture the MAC address on Macs and 
> Windows.  Up until now, I've been using Miyako's Media Access 
> Control.bundle, but it doesn't look like it works with v17.  Any 
> suggestions to accomplish this task would be appreciated.
> 
> Thanks,
> Ken
> 
> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

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

[Cannon Smith via 4D_Tech]

Hi Ken,

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

HTH.

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




> On Dec 12, 2019, at 11:20 AM, Ken Eyring via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> So far it's going fairly smoothly, but a few quirks have come up regarding 
> plugins.  When I launch v17.3 on Mac OS 10.15.2, I get the following alerts 
> for these 4D Plugins:
> 
> - "4D InternetCommands.bundle" cannot be opened because the developer cannot 
> be verified
> 
> - "4D ODBC Pro.bundle" cannot be opened because the developer cannot be 
> verified
> 
> - "4D for OCI.bundle" cannot be opened because the developer cannot be 
> verified
> 

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

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

[Ken Eyring via 4D_Tech]

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


Ken



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

Yep, this is a pain.

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

Now start your database.

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

Now quit your database.

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

Now quit your database.

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


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

Hi Everyone,

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

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

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

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

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

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


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

Thanks,
Ken


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


_
Bob McKeever  http://www.mswl.com 
McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.com




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


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

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

[Ken Eyring via 4D_Tech]

I got it sorted out, thanks.

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


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


Thanks for your help!

Ken




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

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

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

Chip

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

Hi Everyone,

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

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

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

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

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

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


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

Thanks,
Ken


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

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


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

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

[Ken Eyring via 4D_Tech]

Hi Cannon,

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


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


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


Thanks for your help!

Ken





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

Hi Ken,

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

HTH.

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





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

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

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

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

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



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


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

Re: v17.3 on Mac OS 10.15.2 Plugins "cannot be opened because the developer cannot be verified" (SOLVED)

[Ken Eyring via 4D_Tech]

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


Thanks again to everyone who helped!

Ken


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


Ken



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

Yep, this is a pain.

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

Now start your database.

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


Now quit your database.

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


Now quit your database.

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

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


Hi Everyone,

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


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


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


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


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


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



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


Thanks,
Ken


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


_
Bob McKeever  http://www.mswl.com 


McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.com




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


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

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

Re: PRINT SETTINGS Not setting OK to 1

[John J Foster via 4D_Tech]

Hi Tim (et al),

This is just weird!

If I trace it and look to see the value of the OK button it’s alway zero.

If I place this code:

PRINT SETTINGS
If (OK=1)
ALERT("Print OK=1")
Else 
ALERT("Cancel OK=0")
End if 

It correctly displays ALERT("Print OK=1”) although in TRACE OK=0.

So in this app the act of tracing is causing it to fail.

So I have been testing the reports and so far they seem to work. The code is 
acting like OK was properly set EXCEPT when traced.

In the new test database the OK button shows 1 in trace and in code. So 
something about this application I guess.

Not sure this will help anyone in the future. But it’s here if anyone 
experiences this unexpected TRACE behavior.

John…


> On Dec 12, 2019, at 6:47 AM, John J Foster  wrote:
> 
> Hey Tim (et al),
> 
> Some curious facts:
> 
> 1. Placing PRINT SETTINGS in the on load works and returns OK=1 if Print or 
> PDF selected.
> 
> 2. Once the form is loaded and a button is clicked - really any button - the 
> same PRINT SETTINGS command will be equal to 0 (zero) no matter what is 
> selected.
> 
> 3. There are no OK buttons being set in any code related to this method and 
> dialog objects.
> 
> Weird!
> 
> I persevere …
> 
> John...
> 
>> On Dec 11, 2019, at 2:28 PM, John J Foster  wrote:
>> 
>> Hey Tim,
>> 
>> So created a new db with only this code appears to work:
>> 
>> PRINT SETTINGS
>> If (OK=1)
>>  ALERT("Print!")
>> Else 
>>  ALERT("Cancelled!")
>> End if 
>> 
>> So there is something in our application that has caused this behavior.
>> 
>> So I’ll have to figure a way to troubleshoot.
>> 
>> I guess that’s progress!
>> 
>> Thanks Tim,
>> John…
>> 
>> 
>>> On Dec 11, 2019, at 2:03 PM, Tim Nevels  wrote:
>>> 
>>> On Dec 11, 2019, at 3:38 PM, John J Foster  wrote:
>>> 
 Well I did fail to mention I ma running Windows 10 Pro on parallels 15.1.
 
 But my client is also running Windows 10 Pro but on a windows only 
 computer.
 
 I’ll test your ideas - as always very reasonable - and let you know.
>>> 
>>> Hi John,
>>> 
>>> I’m running Windows 10 Home on Parallels 14.1.3.
>>> 
>>> 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
**

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

[Chip Scheide via 4D_Tech]

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

Chip
On Thu, 12 Dec 2019 13:56:04 -0500, Ken Eyring via 4D_Tech wrote:
> Awesome!  Great instructions!  It wasn't so bad to implement the 
> permissions - once I understood how.  Thank you!
> 
> Ken
> 
> 
> 
> On 12/12/19 13:33 PM, Robert McKeever via 4D_Tech wrote:
>> Yep, this is a pain.
>> 
>> Go to System Preferences, Security & Privacy, the General Tab.
>> 
>> Now start your database.
>> 
>> You will have to authorize each plug-in as not being recognized 
>> (Allow apps downloaded from:…).
>> 
>> Now quit your database.
>> 
>> Now start your database again. Answer yes for each plug-in (sorry, I 
>> don’t remember the dialog that comes up).
>> 
>> Now quit your database.
>> 
>> Now start your database again. You should be fine now.
>> 
>>> On Dec 12, 2019, at 10:20 AM, Ken Eyring via 4D_Tech 
>>> <4d_tech@lists.4d.com> wrote:
>>> 
>>> Hi Everyone,
>>> 
>>> I'm migrating from 4D v15.4 32-bit to v17.3 64-bit.  At the same 
>>> time, I am also moving my development machine from Mac OS 10.9.5 to 
>>> Mac OS 10.15.2.
>>> 
>>> So far it's going fairly smoothly, but a few quirks have come up 
>>> regarding plugins.  When I launch v17.3 on Mac OS 10.15.2, I get 
>>> the following alerts for these 4D Plugins:
>>> 
>>> - "4D InternetCommands.bundle" cannot be opened because the 
>>> developer cannot be verified
>>> 
>>> - "4D ODBC Pro.bundle" cannot be opened because the developer 
>>> cannot be verified
>>> 
>>> - "4D for OCI.bundle" cannot be opened because the developer cannot 
>>> be verified
>>> 
>>> I'm assuming there is a configuration somewhere that I can set to 
>>> allow the plugins to be opened - but can't find where.
>>> 
>>> 
>>> I'm also trying to find a way to capture the MAC address on Macs 
>>> and Windows.  Up until now, I've been using Miyako's Media Access 
>>> Control.bundle, but it doesn't look like it works with v17.  Any 
>>> suggestions to accomplish this task would be appreciated.
>>> 
>>> Thanks,
>>> Ken
>>> 
>>> 
>>> **
>>> 4D Internet Users Group (4D iNUG)
>>> Archive:  http://lists.4d.com/archives.html
>>> Options: https://lists.4d.com/mailman/options/4d_tech
>>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>>> **
>> 
>> _
>> Bob McKeever  http://www.mswl.com 
>> 
>> McKeever's Software Wizardry
>> Port Coquitlam, B.C.
>> bobmckee...@mac.com
>> 
>> 
>> 
>> 
>> **
>> 4D Internet Users Group (4D iNUG)
>> Archive:  http://lists.4d.com/archives.html
>> Options: https://lists.4d.com/mailman/options/4d_tech
>> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
>> **
>> 
> **
> 4D Internet Users Group (4D iNUG)
> Archive:  http://lists.4d.com/archives.html
> Options: https://lists.4d.com/mailman/options/4d_tech
> Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
> **
We have done so much, with so little, for so long;
We are now qualified to anything with nothing 
  - unknown
**
4D Internet Users Group (4D iNUG)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Automatic Excel to Text-tab delimited?

[rooftop99--- via 4D_Tech]

Hi 4D folks,

(Environment: All Windows, 4D server/client 16R4)

Just curious if anyone has found a way to automatically transform Excel 
documents to text-tab delimited documents?

The issue I am attempting to solved:  We have several system which produce 
document that need to be imported into a 4D application.  Some of these systems 
produce Excel documents.  To standardize I would like to automatically 
transform these Excel docs into a Text-Tab delimited doc.  This would need to 
be logic triggered by 4D.  (e.g. 4D identifies the doc as Excel and "does 
something" to transform to text-tab before import.)

Any thoughts?

Thanks in advance for the consideration and help!

Kirk


**
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: Automatic Excel to Text-tab delimited?

[Tom Benedict via 4D_Tech]

Hi Kirk,

Converting Excel to Text is a problem that others have tackled, so I would rely 
on their work rather than trying to build it yourself. Plugger’s XL Plugin is 
probably something you should look at, if you haven’t already. There are 
components and libraries that do similar things with Excel docs, but Rob’s 
stuff is very solid.

HTH,

Tom Benedict

> On Dec 12, 2019, at 11:59, rooftop99--- via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Hi 4D folks,
> 
> (Environment: All Windows, 4D server/client 16R4)
> 
> Just curious if anyone has found a way to automatically transform Excel 
> documents to text-tab delimited documents?
> 
> The issue I am attempting to solved:  We have several system which produce 
> document that need to be imported into a 4D application.  Some of these 
> systems produce Excel documents.  To standardize I would like to 
> automatically transform these Excel docs into a Text-Tab delimited doc.  This 
> would need to be logic triggered by 4D.  (e.g. 4D identifies the doc as Excel 
> and "does something" to transform to text-tab before import.)
> 
> Any thoughts?
> 
> Thanks in advance for the consideration and help!
> 
> Kirk
> 
> 
> **
> 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: PRINT SETTINGS Not setting OK to 1

[Tim Nevels via 4D_Tech]

On Dec 12, 2019, at 1:25 PM, John J Foster  wrote:

> This is just weird!
> 
> If I trace it and look to see the value of the OK button it’s alway zero.
> 
> If I place this code:
> 
> PRINT SETTINGS
> If (OK=1)
>   ALERT("Print OK=1")
> Else 
>   ALERT("Cancel OK=0")
> End if 
> 
> It correctly displays ALERT("Print OK=1”) although in TRACE OK=0.
> 
> So in this app the act of tracing is causing it to fail.
> 
> So I have been testing the reports and so far they seem to work. The code is 
> acting like OK was properly set EXCEPT when traced.
> 
> In the new test database the OK button shows 1 in trace and in code. So 
> something about this application I guess.
> 
> Not sure this will help anyone in the future. But it’s here if anyone 
> experiences this unexpected TRACE behavior.

Remember the problems Chip was having with his component that was causing an 
error to appear when he started the database?  There were probably 50 message 
posts from many people on trying to figure out what is going on.

He could put the component in a new, fresh database and it worked without the 
error, but in this one particular host database it would alway throw this error 
on startup. Before even any code was run in On Startup if I remember correctly.

He finally found the problem and it was related to a “Catch” or a “Break” — 
those things you can see in the Runtime Explorer — that was set somewhere that 
was making it happen. Those setting are stored inside the .4DB, not externally. 

Also, I am assuming the “Expression” area in your debugger is empty and 
contains nothing. But what if you had a method in the “Expression” area of the 
debugger and it was running commands that were setting the OK variable? 

Since a fresh new .4DB file does not exhibit your problem, my guess is some 
setting that is in the .4DB that is connected to the debugger that is causing 
this. 

Maybe you should investigate in these areas. 

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

Re: Automatic Excel to Text-tab delimited?

[Jeffrey Kain via 4D_Tech]

4D View Pro is also really nice and can read and write xlsx files. It’s a 
wrapper for spreadJS integrated into the 4D environment:

https://tinyurl.com/v7rz3r5

> On Dec 12, 2019, at 3:06 PM, Tom Benedict via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Converting Excel to Text is a problem that others have tackled, so I would 
> rely on their work rather than trying to build it yourself. Plugger’s XL 
> Plugin is probably something you should look at, if you haven’t already. 
> There are components and libraries that do similar things with Excel docs, 
> but Rob’s stuff is very solid.

**
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: Automatic Excel to Text-tab delimited?

[Tim Nevels via 4D_Tech]

On Dec 12, 2019, at 2:00 PM, Kirk wrote:

> (Environment: All Windows, 4D server/client 16R4)
> 
> Just curious if anyone has found a way to automatically transform Excel 
> documents to text-tab delimited documents?
> 
> The issue I am attempting to solved:  We have several system which produce 
> document that need to be imported into a 4D application.  Some of these 
> systems produce Excel documents.  To standardize I would like to 
> automatically transform these Excel docs into a Text-Tab delimited doc.  This 
> would need to be logic triggered by 4D.  (e.g. 4D identifies the doc as Excel 
> and "does something" to transform to text-tab before import.)
> 
> Any thoughts?
> 
> Thanks in advance for the consideration and help!

Get Rob’s Excel plugin. You can read and write Excel files with a crazy level 
of detail. Once you have it, you’ll find so many uses for it. It is worth the 
€600,00 for the cross platform license. 

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

Another option is the wonderful world of php and using one of the Excel file 
reader libraries. (But it could take you a while to get it into a shape where 
it works with 4D. Not all php libraries are drop-in-and-work with 4D. You may 
have to tweeks some of the files.)

https://github.com/nuovo/spreadsheet-reader

Or you could try one of the online services that will do this for you and try 
to build an automated way to interact with the website and make it happen. Also 
challenging. 

https://www.zamzar.com/convert/xlsx-to-txt/

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

Re: Automatic Excel to Text-tab delimited?

[Tim Nevels via 4D_Tech]

On Dec 12, 2019, at 2:00 PM, Kirk wrote:

> (Environment: All Windows, 4D server/client 16R4)
> 
> Just curious if anyone has found a way to automatically transform Excel 
> documents to text-tab delimited documents?
> 
> The issue I am attempting to solved:  We have several system which produce 
> document that need to be imported into a 4D application.  Some of these 
> systems produce Excel documents.  To standardize I would like to 
> automatically transform these Excel docs into a Text-Tab delimited doc.  This 
> would need to be logic triggered by 4D.  (e.g. 4D identifies the doc as Excel 
> and "does something" to transform to text-tab before import.)
> 
> Any thoughts?
> 
> Thanks in advance for the consideration and help!

I forgot the wonderful world of AppleScript on macOS and Visual Basic on 
Windows for controlling Excel and have it do the work for you. Of course you 
will need a copy of Excel installed on the machine for this to work.

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

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

[Ken Eyring via 4D_Tech]

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


Thanks for your insights,
Ken



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

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

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

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

Ken



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

Yep, this is a pain.

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

Now start your database.

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

Now quit your database.

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

Now quit your database.

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


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

Hi Everyone,

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

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

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

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

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

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


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

Thanks,
Ken


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


_
Bob McKeever  http://www.mswl.com

McKeever's Software Wizardry
Port Coquitlam, B.C.
bobmckee...@mac.com




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


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

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


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

Re: Automatic Excel to Text-tab delimited?

[Keisuke Miyako via 4D_Tech]

I agree that Plugger’s XL Plugin would be the best choice for processing XLSX 
files.

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

4D View Pro Area is a form object, meaning you would have to open a form and 
run asynchronous, callback-based coding to do the conversion.

https://blog.4d.com/work-with-xlsx-documents-using-4d-view-pro/

—

on the other hand, for really simple files, you could use

https://github.com/miyako/4d-plugin-xlsxio

> 2019/12/13 5:06、Tom Benedict via 4D_Tech <4d_tech@lists.4d.com>のメール:
>
> Converting Excel to Text is a problem that others have tackled, so I would 
> rely on their work rather than trying to build it yourself. Plugger’s XL 
> Plugin is probably something you should look at, if you haven’t already. 
> There are components and libraries that do similar things with Excel docs, 
> but Rob’s stuff is very solid.




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

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

[Keisuke Miyako via 4D_Tech]

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

to illustrate,

I’ve uploaded a notarised version of

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

here:

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

it should pass GateKeeper without error.

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

2019/12/13 5:27、Ken Eyring via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
Every client workstation will need to go through that setup. Yuk.  Something 
needs to be done to fix this.



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

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

[Chip Scheide via 4D_Tech]

I do not think anyone as trying to shoot the messenger..

Apple has gone overboard with this.


> 
> please don’t shoot the messenger.
> I didn’t make the rules...

Hell is other people 
 Jean-Paul Sartre
**
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: Naming a web process

[Keisuke Miyako via 4D_Tech]

Haven’t tried with HTTP processes, but have you looked into

https://blog.4d.com/whos-who-a-new-way-to-identify-users/

2019/12/08 20:37、Uist Macdonald via 4D_Tech 
<4d_tech@lists.4d.com>のメール:
Is it possible to name a web session so that the name is visible in 4D Server 
Processes tab?  I know, Why would you want to do that?



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

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

[Ken Eyring via 4D_Tech]

Hi Miyako,

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


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

Best regards,
Ken




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

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

to illustrate,

I’ve uploaded a notarised version of

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

here:

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

it should pass GateKeeper without error.

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


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

Automatic Excel to Text-tab delimited? - Code Sample

[Randy Engle via 4D_Tech]

Kirk,

Rob's plugin + below code should get you what you need:

Randy Engle




  // Method: 
  // EXCEL_TO_TAB_TEXT
  // 
  // User name (OS): Randy
  // Date and time: 12/12/2019, 15:33:17
  // 
  // Description
  // bld2770
  // 

  // V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^
  // V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^
  // V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^


C_LONGINT($book)
C_LONGINT($sheet)
C_LONGINT($startRow)
C_LONGINT($count_Rows)
C_LONGINT($startCol)
C_LONGINT($count_Columns)
C_TEXT($documentPath;$1)
C_TEXT($text_Value)
C_TEXT($packet)
C_TIME($doc_Ref)

$doc_Ref:=?00:00:00?

$documentPath:=$1

  //$documentPath:=System folder(Desktop)+"export.xlsx"

$CR:=Char(13)+Char(10)

Case of 
: (Test path name($documentPath)=Is a document)

$text_doc:=Replace string($documentPath;"xlsx";"txt")

$doc_Ref:=Create document($text_doc)

End case 

Case of 

: ($doc_Ref=?00:00:00?)
  // Not created

Else 

$book:=xlBookLoadFile ($documentPath)

If ($book#0)

  // Get a reference to the first sheet
$sheet:=xlBookGetSheet ($book;1)

$startRow:=xlSheetGetFirstRow ($sheet)
$count_Rows:=xlSheetGetLastRow ($sheet)

$startCol:=xlSheetGetFirstColumn ($sheet)
$count_Columns:=xlSheetGetLastColumn ($sheet)

Open window(200;200;800;400;4;"Importing")

For ($row;1;$count_Rows)

$packet:=""

For ($column;1;$count_Columns)

$text_Value:=""

$type:=xlSheetCellType 
($sheet;$row;$column)

Case of 
: ($type=xlCellType_Empty)  // 0

: ($type=xlCellType_Number)  //1

$num_Value:=xlSheetGetCellNumber ($sheet;$row;$column)

$text_Value:=String($num_Value)

: ($type=xlCellType_String)  //2

$text_Value:=xlSheetGetCellText ($sheet;$row;$column)

: ($type=xlCellType_Boolean)  
//3

$bool_Value:=xlSheetGetCellBoolean ($sheet;$row;$column)

$text_Value:=String($bool_Value)

: ($type=xlCellType_Blank)  //4

: ($type=xlCellType_Error)  //5

End case 

$packet:=$packet+$text_Value
Case of 
: ($column=$count_Columns)

$packet:=$packet+Char(13)+Char(10)
Else 
$packet:=$packet+Char(9)
End case 

End for 

SEND PACKET($doc_Ref;$packet)

MESSAGE(String($row)+" of 
"+String($count_Rows)+$CR)

End for 

xlBookRelease ($book)

CLOSE WINDOW

CLOSE DOCUMENT($doc_Ref)

End if 

 

Re: Automatic Excel to Text-tab delimited? - Code Sample

[rooftop99--- via 4D_Tech]

Thanks Randy and everyone else who chimed in so quickly  I have ordered Rob’s 
plugin.  (I have heard good thing about this plugin for years…)  Sounds like 
the best solution.

Best to all & happy holidays!
Kirk

> On Dec 12, 2019, at 3:54 PM, Randy Engle via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Kirk,
> 
> Rob's plugin + below code should get you what you need:
> 
> Randy Engle
> 
> 
> 
> 
>  // Method: 
>  // EXCEL_TO_TAB_TEXT
>  // 
>  // User name (OS): Randy
>  // Date and time: 12/12/2019, 15:33:17
>  // 
>  // Description
>  // bld2770
>  // 
> 
>  // V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^
>  // V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^
>  // V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^V^
> 
> 
> C_LONGINT($book)
> C_LONGINT($sheet)
> C_LONGINT($startRow)
> C_LONGINT($count_Rows)
> C_LONGINT($startCol)
> C_LONGINT($count_Columns)
> C_TEXT($documentPath;$1)
> C_TEXT($text_Value)
> C_TEXT($packet)
> C_TIME($doc_Ref)
> 
> $doc_Ref:=?00:00:00?
> 
> $documentPath:=$1
> 
>  //$documentPath:=System folder(Desktop)+"export.xlsx"
> 
> $CR:=Char(13)+Char(10)
> 
> Case of 
>   : (Test path name($documentPath)=Is a document)
>   
>   $text_doc:=Replace string($documentPath;"xlsx";"txt")
>   
>   $doc_Ref:=Create document($text_doc)
>   
> End case 
> 
> Case of 
>   
>   : ($doc_Ref=?00:00:00?)
> // Not created
>   
>   Else 
>   
>   $book:=xlBookLoadFile ($documentPath)
>   
>   If ($book#0)
>   
> // Get a reference to the first sheet
>   $sheet:=xlBookGetSheet ($book;1)
>   
>   $startRow:=xlSheetGetFirstRow ($sheet)
>   $count_Rows:=xlSheetGetLastRow ($sheet)
>   
>   $startCol:=xlSheetGetFirstColumn ($sheet)
>   $count_Columns:=xlSheetGetLastColumn ($sheet)
>   
>   Open window(200;200;800;400;4;"Importing")
>   
>   For ($row;1;$count_Rows)
>   
>   $packet:=""
>   
>   For ($column;1;$count_Columns)
>   
>   $text_Value:=""
>   
>   $type:=xlSheetCellType 
> ($sheet;$row;$column)
>   
>   Case of 
>   : ($type=xlCellType_Empty)  // 0
>   
>   : ($type=xlCellType_Number)  //1
>   
> $num_Value:=xlSheetGetCellNumber ($sheet;$row;$column)
>   
> $text_Value:=String($num_Value)
>   
>   : ($type=xlCellType_String)  //2
>   
> $text_Value:=xlSheetGetCellText ($sheet;$row;$column)
>   
>   : ($type=xlCellType_Boolean)  
> //3
>   
> $bool_Value:=xlSheetGetCellBoolean ($sheet;$row;$column)
>   
> $text_Value:=String($bool_Value)
>   
>   : ($type=xlCellType_Blank)  //4
>   
>   : ($type=xlCellType_Error)  //5
>   
>   End case 
>   
>   $packet:=$packet+$text_Value
>   Case of 
>   : ($column=$count_Columns)
>   
> $packet:=$packet+Char(13)+Char(10)
>   Else 
>   $packet:=$packet+Char(9)
>   End case 
>   
>   End for 
>   
>   SEND PACKET($doc_Ref;$packet)
>   
>