Re: 2017 World Tour Component

[Brian Young via 4D_Tech]

Hi Jim,

The PDF that accompanies the component lists 4D v16.x or above as a requirement 
to run the demo database:

  Demo Requirement
- 4D v16.x or Above (32bit AND 64-bit versions)
- PICT_Convert Component
- MoreObjects example database

I haven’t spoken to JPR, who authored the component, but I believe it will only 
work when used with v16.  That is the case in our tests within the office.

Regards

-Brian






> On Apr 12, 2017, at 10:14 AM, Jim Medlen via 4D_Tech <4d_tech@lists.4d.com> 
> wrote:
>
>
>
> Trying to use the PICT_Convert.4dbase from the 2017 World Tour
>
> I placed the component in the components folder for 4D v15.4 and received an
> Error
>
> Can¹t load component ³PICT_Convert.4DB
>
> Disk NbPart. Type Name   Media Type   Speed
> Total Size Description
> * NameBSD_ID  Disk_IDNumPart.   Writable
> Total Size  FileSystem
>
>
> Thanks,
>
> Jim Medlen
> Computer & Information Systems
> Functional Devices, Inc.
> j.med...@functionaldevices.com
> phone (765) 883-5538 x 428
> fax (765) 883-4262
> http://www.functionaldevices.com
>
> This email was transmitted on 100 percent recycled electrons
>
>
>
>
> **
> 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: Questions about the 'Sum' function

[Tim Nevels via 4D_Tech]

On Apr 12, 2017, at 2:00 PM,Kirk Brooks wrote:

> Sum works fine on a selection of records or on an array. It used to be a
> little slow but not now.

Sum and the other series commands are optimized and will use the index on field 
a field if it exists. Saves loading all the records in the selection into the 
data cache. 

> If you are working on 4D server it's useful to build some functions that
> will run on the server to speed things up even more. Using your example you
> could write:
> 
> // Customer_get_invoiceSum (id)
> QUERY([INVOICE];[INVOICE]customer=$1)
> $0:=Sum([INVOICE]amount)
> UNLOAD RECORD([INVOICE])
> 
> Set the Execute on server attribute and use it as
> 
> $total:= Customer_get_invoiceSum(2)

The series command are also optimized for 4D Server. So it will already do the 
Sum on 4D Server. 4D has already done the optimizations for you with the Series 
commands. Doing the work on 4D Server and using indexes is what makes this 
super fast.

Tim


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

2017 World Tour Component

[Jim Medlen via 4D_Tech]

Trying to use the PICT_Convert.4dbase from the 2017 World Tour

I placed the component in the components folder for 4D v15.4 and received an
Error

Can¹t load component ³PICT_Convert.4DB

Disk NbPart. Type Name   Media Type   Speed
Total Size Description
* NameBSD_ID  Disk_IDNumPart.   Writable
Total Size  FileSystem


Thanks,

Jim Medlen
Computer & Information Systems
Functional Devices, Inc.
j.med...@functionaldevices.com
phone (765) 883-5538 x 428
fax (765) 883-4262
http://www.functionaldevices.com

This email was transmitted on 100 percent recycled electrons




**
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: Questions about the 'Sum' function

[Kirk Brooks via 4D_Tech]

Peter,
Sum works fine on a selection of records or on an array. It used to be a
little slow but not now.

If you are working on 4D server it's useful to build some functions that
will run on the server to speed things up even more. Using your example you
could write:

// Customer_get_invoiceSum (id)
QUERY([INVOICE];[INVOICE]customer=$1)
$0:=Sum([INVOICE]amount)
UNLOAD RECORD([INVOICE])


Set the Execute on server attribute and use it as

$total:= Customer_get_invoiceSum(2)


If you are actually on a server this will not change the selection of
invoices on your client machine.


On Wed, Apr 12, 2017 at 4:22 AM, Peter Jakobsson via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi
>
> Occasionally I’d like to use the “Sum” function on a current selection but
> am hesitant because of distant memories of it only being supported in
> certain circumstances (e.g. in reports, on single user.not client server
> etc).
>
> Do people use this outside of a report context and on any current
> selection ? e.g. can you safely just do this…
>
> QUERY([INVOICE];[INVOICE]customer=2)
> $total:=Sum([INVOICE]amount)
>
> Is anyone aware of any circumstance where this won’t work ?
>
> Thanks in advance !
>
> Peter
>
> **
> 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
> **




-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

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

Another woe of compiler complacency in v15.4

[Kirk Brooks via 4D_Tech]

I'm using Query by formula with Match regex to search for email addresses.
I believe I got this idea from the 4D docs but could have been somewhere
else. Anyway, here's what I'm doing:

SET QUERY DESTINATION(Into set;"emailMatch")
$pattern:="(?i)"+$email
QUERY BY FORMULA([WebUser_subMgr];Match
regex($pattern;[WebUser_subMgr]primaryEmail);1)

​The sharp eyed among you will notice the error here. The compiler does
not. ​The correct syntax is:

QUERY BY FORMULA([WebUser_subMgr];Match
regex($pattern;[WebUser_subMgr]primaryEmail;1)
​)​


​The erroneous code compiles and even runs compiled on my Mac server but
fails when running​ on a windows server. I'm lucky I noticed this early on
- this is the type of error that could take a long time to finally
pinpoint. I put in a bug report too.

​
-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

*- Edmund Burke*
**
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: Replacing - OAuth.bundle

[Kirk Brooks via 4D_Tech]

Miyako,
Your github account is an absolute trove of useful information and
resources for a 4D dev. Your repos organization reflects, I think, the
focus and drive I see when you work so there's nothing to apologize for.

Github isn't the optimal format for 4D style resources but like Sujit said
it's pretty much the acknowledged go-to source for code sharing these days
so it's in our interest to learn how to navigate it.

On Wed, Apr 12, 2017 at 12:53 AM, Keisuke Miyako via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hello,
>
> in general, only the source files (plain text) are expected to be under
> source-control,
> as well as common format documents such as PDF or images.
>
> large binary files are expected to be published under "Releases".
>
> 4D is an unusual case,
> because the source code (the structure file) is actually a binary file.
>
> ideally, the built plugin (bundle) should be under "Releases",
> the C files under source-control,
> and the unit test structure should be written to build itself
> by importing method code from a set of external text files.
>
> but as of today, I am just publishing my local workspace "as is".
> it is terribly bad practice...


-- 
Kirk Brooks
San Francisco, CA
===

*The only thing necessary for the triumph of evil is for good men to do
nothing.*

*- Edmund Burke*
**
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: Questions about the 'Sum' function

[Peter Jakobsson via 4D_Tech]

On 12 Apr 2017, at 13:38, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> wrote:

> My understanding is a selection or array i think it works for both.

Thanks !

Peter
**
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: Questions about the 'Sum' function

[Sujit Shah via 4D_Tech]

Just recalling the term series from memory. Something I read in the manual.
My understanding is a selection or array i think it works for both.

Not in front of computer so not 100% sure.
On Wed, 12 Apr 2017 at 9:34 pm, Peter Jakobsson via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> On 12 Apr 2017, at 13:29, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com>
> wrote:
>
> > Sum has always worked on a series
>
> Thanks Sujit. But what’s the definition of a ‘series’ ?
>
> Does a field from a current selection qualify as a ‘series’ ?
>
> Peter
>
> **
> 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
> **

-- 

xxx
"There must be ingenuity as well as intention, strategy as well as
strength. "
**
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: Questions about the 'Sum' function

[Peter Jakobsson via 4D_Tech]

On 12 Apr 2017, at 13:29, Sujit Shah via 4D_Tech <4d_tech@lists.4d.com> wrote:

> Sum has always worked on a series

Thanks Sujit. But what’s the definition of a ‘series’ ?

Does a field from a current selection qualify as a ‘series’ ?

Peter

**
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: Questions about the 'Sum' function

[Sujit Shah via 4D_Tech]

Perhaps you are confusing it with subtotal?

Sum has always worked on a series

E&OE


On Wed, 12 Apr 2017 at 9:22 pm, Peter Jakobsson via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Hi
>
> Occasionally I’d like to use the “Sum” function on a current selection but
> am hesitant because of distant memories of it only being supported in
> certain circumstances (e.g. in reports, on single user.not client server
> etc).
>
> Do people use this outside of a report context and on any current
> selection ? e.g. can you safely just do this…
>
> QUERY([INVOICE];[INVOICE]customer=2)
> $total:=Sum([INVOICE]amount)
>
> Is anyone aware of any circumstance where this won’t work ?
>
> Thanks in advance !
>
> Peter
>
> **
> 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
> **

-- 

xxx
"There must be ingenuity as well as intention, strategy as well as
strength. "
**
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
**

Questions about the 'Sum' function

[Peter Jakobsson via 4D_Tech]

Hi

Occasionally I’d like to use the “Sum” function on a current selection but am 
hesitant because of distant memories of it only being supported in certain 
circumstances (e.g. in reports, on single user.not client server etc).

Do people use this outside of a report context and on any current selection ? 
e.g. can you safely just do this…

QUERY([INVOICE];[INVOICE]customer=2)
$total:=Sum([INVOICE]amount)

Is anyone aware of any circumstance where this won’t work ?

Thanks in advance !

Peter

**
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: Replacing - OAuth.bundle

[Sujit Shah via 4D_Tech]

Thank god there are still some people who find websites and web
applications non ituitive. But GitHub is used by millions so you cannot
really argue.

;-)

On Wed, 12 Apr 2017 at 4:38 am, Kirk Brooks via 4D_Tech <
4d_tech@lists.4d.com> wrote:

> Clive,
>
> I'm reading this and thinking you're asking for a little assistance dealing
> with github's interface. It is a bit obtuse if you're coming to it from a
> 4D perspective and haven't worked with it before.
>
> If you follow this link:
>
> https://github.com/miyako
>
>
> it takes you to Miyako's github account. From here you can search or browse
> for the specific repositories you want.
>
> When you find one, 4d-plugin-curl, for example, click on it - you don't
> need to go any deeper. You will see a green button labeled 'Clone or
> download' on the upper right hand side.
>
> Click it and choose Download ZIP.
>
> This will download the entire repo. Depending on exactly what's in it there
> may be a lot of material you won't need. Don't worry about it. Unzip it and
> look around in the contents until you find the plugin. Sometimes this might
> be inside of an example database package.
>
> Move it to your working directory and you can delete the rest.
>
> Hope this helps.
>
> On Tue, Apr 11, 2017 at 9:49 AM, Clive Wilson via 4D_Tech <
> 4d_tech@lists.4d.com> wrote:
>
> > Hi Guys,
> >
> > I'm moving my application from v14 to v16r2 .
> >
> > I have used Miyako's OAuth.bundle extensively for exchanging data with
> > remote systems.Using OAuth and JSON.
> > This bundle is being deprecated and the version that I have been using
> has
> > a modified date of Oct 2012.
> >
> > Miyako has replaced this with a group of plugins - 4d-plugin-zip,
> > 4d-plugin-curl, 4d-plugin-common-crypto, 4d-plugin-json.
> > These are all on GITHub.
> >
> > My question is not strictly 4D, but I really need help on this.
> > How do you convert downloaded (from GITHub) into "xxx.bundle"  files that
> > I can replace the old "OAuth.bundle" with.
> > Or, where can I get the "xxx.bundle" 's for 4d-plugin-zip,
> 4d-plugin-curl,
> > 4d-plugin-common-crypto, 4d-plugin-json.
> >
> > Thanks
> > Clive Wilson
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> >
> > **
> > 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
> > **
>
>
>
>
> --
> Kirk Brooks
> San Francisco, CA
> ===
>
> *The only thing necessary for the triumph of evil is for good men to do
> nothing.*
>
> *- Edmund Burke*
> **
> 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
> **

-- 

xxx
"There must be ingenuity as well as intention, strategy as well as
strength. "
**
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: Replacing - OAuth.bundle

[Keisuke Miyako via 4D_Tech]

Hello,

in general, only the source files (plain text) are expected to be under 
source-control,
as well as common format documents such as PDF or images.

large binary files are expected to be published under "Releases".

4D is an unusual case,
because the source code (the structure file) is actually a binary file.

ideally, the built plugin (bundle) should be under "Releases",
the C files under source-control,
and the unit test structure should be written to build itself
by importing method code from a set of external text files.

but as of today, I am just publishing my local workspace "as is".
it is terribly bad practice...



**
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: Replacing - OAuth.bundle

[Douglas Cryer via 4D_Tech]

Kirk,

Thank you for a very clear, concise description of how to navigate GitHub 
repositories.

I too have struggled with the interface and terminology.  Your description 
demystifies it all.

Regards,  Dougie


telekinetix Limited- J. Douglas Cryer
Phone : 01234 761759  Mobile : 07973 675 218
2nd Floor Broadway House, 4-6 The Broadway, Bedford MK40 2TE
Email : jdcr...@telekinetix.com   Web : 
http://www.telekinetix.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
**