RE: 4D Write Pro: traverse throught all available headers and footers

2018-05-29 Thread Piotr Chabot Stadhouders via 4D_Tech
Yes, I mean the loop doesn't take into account mixed content

I had the feeling that one of the goals of the tip 
(http://kb.4d.com/assetid=77422) was to make an efficient loop, meaning that 
homogenous parts of the content can be skipped
Why else use the variables $startBlock and $endBlock, but maybe I was wrong
, because then you also have to test on mixed type content
Starting with this :

$start:=ST Start text
$end:=$start+1

does the trick, but then again it means just testing every "character" in the 
content for being an expression.
This doesn't feel efficient to me

> -Oorspronkelijk bericht-
> Van: Keisuke Miyako 
> Verzonden: dinsdag 29 mei 2018 17:30
> Aan: 4D iNug Technical <4d_tech@lists.4d.com>
> Onderwerp: Re: 4D Write Pro: traverse throught all available headers and
> footers
> 
> when you say "it misses an expression"
> 
> do you mean ST Get content type doesn't report "ST Expression type" (for
> instance you get mixed type) or do you mean ST Get expression doesn't return
> an expression (maybe you should start from 1, not ST Start text)
> 
> ?
> 
> > 2018/05/30 0:05、Piotr Chabot Stadhouders via 4D_Tech
> > <4d_tech@lists.4d.com> のメール:
> > What do you think?
> 
> 
> 

**
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: Best way to test for a specific version of an application

2018-05-29 Thread Keisuke Miyako via 4D_Tech
if you are using AppleScript there is a version property available in the 
language.
it should be better to query the information in the same execution context.

2018/05/30 11:24、Jeffrey Kain via 4D_Tech 
<4d_tech@lists.4d.com> のメール:
 Excel via AppleScript



**
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: Best way to test for a specific version of an application

2018-05-29 Thread Keisuke Miyako via 4D_Tech
I remember used the same tip in this one:

https://github.com/miyako/4d-plugin-office-document-converter

2018/05/30 11:24、Jeffrey Kain via 4D_Tech 
<4d_tech@lists.4d.com> のメール:

Due to sandboxing requirements with Office 2016 and Sierra, you have to jump 
through some hoops to control Excel via AppleScript without getting a lot of 
dialogs constantly asking you to Grant Access, etc.. There's a special 'safe' 
directory buried deep in ~Library that you can use as a temp directory to hold 
your Applescripts to prevent all that user interaction, so I want to know which 
version of Office I have installed so I know what I can use as my temp 
directory.


**
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: Best way to test for a specific version of an application

2018-05-29 Thread Jeffrey Kain via 4D_Tech
Thanks Miyako and Jörg for the ideas.

> On May 29, 2018, at 9:14 PM, Keisuke Miyako via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> my question is, why do you need to know the version?

Due to sandboxing requirements with Office 2016 and Sierra, you have to jump 
through some hoops to control Excel via AppleScript without getting a lot of 
dialogs constantly asking you to Grant Access, etc.. There's a special 'safe' 
directory buried deep in ~Library that you can use as a temp directory to hold 
your Applescripts to prevent all that user interaction, so I want to know which 
version of Office I have installed so I know what I can use as my temp 
directory.

Ultimately it won't matter. Office 2011 and older aren't supported anymore so 
everything will someday be 2016 or higher.
**
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: Best way to test for a specific version of an application

2018-05-29 Thread Keisuke Miyako via 4D_Tech
it's possible to install in non-standard locations, more specifically, 
arbitrary sub-directories.
it's possible to install/launch multiple version of Office on the same computer,
It's possible to install select items out of the Office suite.

so the request must be define more specifically.

---

if you are interested in the default (as preferred by launch services) 
"Microsoft Excel"
then I guess you could do something like

mdfind 'kMDItemDisplayName="Microsoft Excel"'

and then use the path like

mdls -name kMDItemVersion '/Applications/Microsoft Excel.app'

https://developer.apple.com/legacy/library/documentation/Darwin/Reference/ManPages/man1/mdfind.1.html
https://developer.apple.com/library/content/documentation/CoreServices/Reference/MetadataAttributesRef/Reference/CommonAttrs.html

my question is, why do you need to know the version?

> 2018/05/30 9:32、Jeffrey Kain via 4D_Tech <4d_tech@lists.4d.com> のメール:
> On macOS, what's the best way to check from 4D Remote if a specific version 
> of an application is installed?




**
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: Best way to test for a specific version of an application

2018-05-29 Thread Jörg Knebel via 4D_Tech

> On 30 May 2018, at 10:32 AEST, Jeffrey Kain via 4D_Tech 
> <4d_tech@lists.4d.com> wrote:
> 
> On macOS, what's the best way to check from 4D Remote if a specific version 
> of an application is installed? 

Try this in the Terminal via LEP:

mdls -name kMDItemVersion $Path_To_Application

and you’ll get this: kMDItemVersion = “XX.yy.zz”

HTH

Cheers
Jörg
**
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
**

Best way to test for a specific version of an application

2018-05-29 Thread Jeffrey Kain via 4D_Tech
On macOS, what's the best way to check from 4D Remote if a specific version of 
an application is installed? 

I'm trying to figure out if the version of Office installed is 2016, but this 
doesn't appear in the .plist file, and GET DOCUMENT PROPERTIES doesn't have a 
selector for file version.


--
Jeffrey Kain
jeffrey.k...@gmail.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: Moving data storage from outside the database to in the record

2018-05-29 Thread Timothy Penner via 4D_Tech
> What am I missing?

Just a guess - after the SAVE RECORD, try calling LOAD RECORD before calling 
GET EXTERNAL DATA PATH

-Tim



**
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: 15.5 The database cannot be published

2018-05-29 Thread Kirk Brooks via 4D_Tech
Rudy,
It would be specific to that machine I believe. See Tim's post also. For me
it's usually because I, or some other program, is running some sort of web
server on the same machine.

On Tue, May 29, 2018 at 8:42 AM Two Way Communications via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi Kirk,
>
> I asked my customer… he was going to check.
>
> Do you mean on the same machine or in the entire LAN?
>
> > On 28 May 2018, at 17:06, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
> >
> > Rudy,
> > Check to see if there is another web server running  and using the same
> > port.
>
-- 
Kirk Brooks
San Francisco, CA
===

*We go vote - they go home*
**
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: 15.5 The database cannot be published

2018-05-29 Thread Timothy Penner via 4D_Tech
Maybe its related to one of these?

Tech Tip: Skype can prevent publishing of Web Server ports
http://kb.4d.com/assetid=77827

Tech Tip: Starting Web Server on Mac OS X
http://kb.4d.com/assetid=50304

Tech Tip: Installing HelperTool on Mac OS X
http://kb.4d.com/assetid=76962

Tech Tip: Checking for open ports in 4D v11 SQL
http://kb.4d.com/assetid=76029




**
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: 15.5 The database cannot be published

2018-05-29 Thread Two Way Communications via 4D_Tech
Hi Kirk,

I asked my customer… he was going to check.

Do you mean on the same machine or in the entire LAN?


Regards,

Rudy


> On 28 May 2018, at 17:06, Kirk Brooks via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
> 
> Rudy,
> Check to see if there is another web server running  and using the same
> port.
> 
> On Mon, May 28, 2018 at 4:40 AM Rudy.Mortier--- via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
> 
>> Hi Doug,
>> 
>> I am having the same problem. Where can I find the Active4D thread?
>> 
>> Regards,
>> 
>> Rudy
>> 
>> 
>> Never mind. I just saw the Active4D thread that most likely will fix this.
>> 
>> 
>> 
>> On Thu, Oct 26, 2017 at 9:21 AM, Doug Hall  wrote:
>> 
>>> After updating to 15.5, I'm getting this error on my Mac web client: "The
>>> database cannot be published. (:Users::
>>> Library:Caches:4D:<4DCacheFolder>)."
>>> 
>>> Any idea what might be causing this? I removed the cache folder, so that
>>> it would recreate it, but it gives the same error.
>>> 
>>> Thanks,
>>> Doug
>>> 
>> **
>> 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
>> **
>> 
>> Quoted from:
>> 
>> http://4d.1045681.n5.nabble.com/15-5-The-database-cannot-be-published-tp5754999p5755001.html
>> 
>> 
>> _
>> Sent from http://4d.1045681.n5.nabble.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
>> **
> 
> 
> 
> -- 
> Kirk Brooks
> San Francisco, CA
> ===
> 
> *We go vote - they go home*
> **
> 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: traverse throught all available headers and footers

2018-05-29 Thread Keisuke Miyako via 4D_Tech
when you say "it misses an expression"

do you mean ST Get content type doesn't report "ST Expression type" (for 
instance you get mixed type)
or do you mean ST Get expression doesn't return an expression (maybe you should 
start from 1, not ST Start text)

?

> 2018/05/30 0:05、Piotr Chabot Stadhouders via 4D_Tech <4d_tech@lists.4d.com> 
> のメール:
> What do you think?




**
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: traverse throught all available headers and footers

2018-05-29 Thread Piotr Chabot Stadhouders via 4D_Tech
Hi Miyako,

Did you mean to respond to my "get all expressions" post?

For that I use a code snippet found in a tech tip on kb.4d.com that traverses 
through all expressions in a section, see http://kb.4d.com/assetid=77422
It finds all expressions using ST Get content type
Beside the fact that I don't completely understand the way the loop works, it 
misses an expression when it is the first element in the content

What do you think?

> -Oorspronkelijk bericht-
> Van: Keisuke Miyako 
> Verzonden: vrijdag 25 mei 2018 23:46
> Aan: 4D iNug Technical <4d_tech@lists.4d.com>
> Onderwerp: Re: 4D Write Pro: traverse throught all available headers and
> footers
> 
> Hello,
> 
> the command is ST Get content type
> 
> http://doc.4d.com/4Dv16/4D/16.3/ST-Get-content-type.301-3652488.en.html
> 
> > 2018/05/26 0:46、Piotr Chabot Stadhouders via 4D_Tech
> <4d_tech@lists.4d.com> のメール:
> > I need to traverse through all expressions
> 
> 

**
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: "Your password does not allow you to use this form"

2018-05-29 Thread Pat Bensky via 4D_Tech
I determined that the problem only occurred when a specific table was
involved.
I opened the MSC and repaired the structure file. That fixed it :)

PB


On 25 May 2018 at 06:55, JPR via 4D_Tech <4d_tech@lists.4d.com> wrote:

> [JPR]
>
> Hi Pat,
>
> Yes, I did write the Label Editor long time ago.
>
> But no, I don't have the slightest idea regarding this problem :-(
>
> Anyway, if it's a problem in V13, it should have arisen years ago, and I
> received no complains regarding this splendid jewel of a code used
> enthusiastically by labels fanatics since 6.5 ;-)
>
> More seriously, the problem probably comes from licences, for it has never
> been decided that old label editor would be connected with VP.
>
> My very best,
>
> JPR
>
> > On 24 May 2018, at 21:00, 4d_tech-requ...@lists.4d.com wrote:
> >
> > Message: 6
> > Date: Thu, 24 May 2018 18:47:44 +0100
> > From: Pat Bensky 
> > To: 4D iNug Technical <4d_tech@lists.4d.com>
> > Subject: Re: "Your password does not allow you to use this form"
> > Message-ID:
> >k...@mail.gmail.com>
> > Content-Type: text/plain; charset="UTF-8"
> >
> > Hey John,
> > Hmmm, I don't think so ... Also I don't think I can get support form 4D
> on
> > this as it's V13, not a current version.
> > Maybe JPR can offer some help - I believe he wrote the label editor.
> >
> > JPR? Hello!
> >
> > Pat
>
> **
> 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
> **
>



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