Re: ORDA - NOT(IN)

[Douglas Cryer via 4D_Tech]

Adrian,

I honestly believe this to be a bug and hope that in the future it will be 
fixed.

Below does not work:

$vc_exclude:=New collection //make a simple empty collection
$es_MySel:=ds.myTable.query("not(myField in :1)";$vc_exclude)

Here are few ways around it:

Option 1 - Check and do something different
$vc_exclude:=New collection //make a simple empty collection
If($vc_exclude.length>0)
$es_MySel:=ds.myTable.query("not(myField in :1)";$vc_exclude)// Could 
have other fields as well
Else
$es_MySel:=ds.myTable.all() //Or a query without the no in
End If

Option 2 - Add a fixer value to the collection
$vc_exclude:=New collection //make a simple empty collection
If($vc_exclude.length=0)
$vc_exclude.push("")// Add a value to the collection that I would never 
expect to find (of the right type)
End If
$es_MySel:=ds.myTable.query("not(myField in :1)";$vc_exclude)// now the query 
will work

Option 3 - take the in away from the query
$vc_exclude:=New collection //make a simple empty collection
$es_MySel:=ds.myTable.all().minus(ds.myTable.query("myField in 
:1";$vc_exclude)// now the query will work

The .all() above could be the a .query() if you are trying to query on multiple 
properties.

Personally I like option 3 best.

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)
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: ORDA - NOT(IN)

[Douglas Cryer via 4D_Tech]

Tom,

Re:
Why is my query of
NOT(IN [])
   versus
NOT(IN [""])
producing difference results?

I noticed this a few weeks back.  The empty collection I was using was the 
result of a previous query that returned a collection.  I had to code around it 
so if the myCollection.length was zero I had to do something else.  4D will 
probably say feature but I say annoying.

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)
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: An API for my 4D app

[Douglas Cryer via 4D_Tech]

Pat,

You mean something like: https://www.ilevelsoftware.co.uk/help/api/index.html

I have written a REST API for our main system and implemented it in a number of 
others.  Fairly generic 4D code.  It needs a web server license.  By comparison 
the RESTfull API. V18 looks pretty  good but each connection can use licenses 
up.  For our use case the RESTfull API. V18 is a no go although I would agree 
it looks pretty nice.

I would be happy to share my code and provide you some time to assist with 
implementation if you contact me off list.

Other options are:
- A stack of SOAP functions.  This is so old school but our application still 
supports over 40 SOAP functions.
- SQL 4D's SQL server is good although I have never used it in production.  Not 
sure what the licensing is.

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)
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: Entity Selection Listbox with Image

[Douglas Cryer via 4D_Tech]

Update.

Having run many tests it would appear that I was experiencing some data issues 
possibly due to some internal data conversion.

Having reset all the thumbnail images in the table the awful lag that was being 
experienced when using an entity selection with a list box went away.  I then 
re-populated those thumbnails that were previously present and all was still 
good.

Classic (current selection) is still ever so slightly quicker on the scroll 
than entity selection but nothing to be worried about IMHO.

Bob Miller said:
I’m very interested in your approach to creating the generic listing.  Have you 
found a demo somewhere that shows how to do this?  I'm just opening the book on 
ORDA and this is one of the first projects I'd like to try, but am befuddled 
where to start.

What are the features of your generic listing?  What does it look like?  Can 
you share a bit about your spec and how you are going about creating this?

It is a bit too much for this list but maybe we could touch base offline.  4D 
showed a demo at the World Tour and I am sure someone else will be doing 
something at the Summit.  In short our approach is as follows:

We are writing as a component as it will eventually replace the existing 
"classic" Browser component that we have been using for many years.  We are 
using the project methodology as this works really well for writing components.
The interface is largely driven by a single window made up of:
- Side bar to list the tables
- Data list area which is populated based on what is selected from the sidebar
- Header/button area that is populated by buttons many of which have standard 
options mixed with actions governed by the host via callbacks

The component will require the host to have a single table to hold objects for 
the various tool elements such as:
- Saved searches to be used by the components search editor
- Saved views to allow the user to have multiple view definitions
- Saved selections to allow the user to save selections and manipulate them 
like sets via Venn diagrams
- Saved sorts to allow the user to apply a predefined sort to selection

So far we have been working on it in our spare time for less than a month so it 
is very early days.  We have a working model and are building out the 
functionality when we have a spare moment from our heavy workload.

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)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Entity Selection Listbox with Image

[Douglas Cryer via 4D_Tech]

Hi Folks,

We have been working on moving our generic listing over to using ORDA.  To do 
this we realise that we would need to use entity selections with list boxes.

This has gone really well but we have now hit a very road bump and I need some 
advice on how to overcome it.

Two of our tables have picture fields containing thumbnails that can be added 
to a listing view.  In classic list box using selection this works really well 
to display the thumbnail so the user knows visually what the line is.  The data 
loads quickly and scrolls smoothly.  However, when a picture is put into a list 
box with an entity selection it appears to kill performance.  
- The data takes ages to load (15 seconds with 4K records) even when all 
picture fields are empty!
- The scroll is jerky and makes the view unusable.

I feel I must be missing something.  Is there some new trick to displaying 
pictures in list boxes that are using entity selections.

We are using the new v18 LTS release so I am concerned that our dreams of an 
ORDA future have just been put on hold.

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)
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 is equivalent to SELF when a form object's "variable or expression" is an object attribute?

[Douglas Cryer via 4D_Tech]

Chris,

Is it not just:
Object get pointer(Object current)->:=Uppercase(Object get
pointer(Object current)->)

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)
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: Citrix Playbook

[Douglas Cryer via 4D_Tech]

Rudy,

Re: My customers run on Citrix on a daily basis.
Do you manage that or is the Citrix part managed by the customers IT?

  Re: No such errors, ever.

Do you run the Citrix server and the 4D server on the same LAN?  I have 
proposed two solutions to the IT company but they have declined to follow 
through on either.
1 - They build a server in their own data centre to host the 4D database so 
they can have the server on the same LAN as the Citrix servers.  We would 
rather have a happy customer than the small amount of revenue we generate from 
the rented server.
2 - We create a VPN between our networks to try and improve network stability.  
We have a CISCO ASA5515 that all traffic goes through.

Re: Regarding the error message, it may be of help to let the Citrix people 
know that 4D is using multiple ports: by default 19812 and 19813, and then 
19815 or so for SQL server.  You can see on 4D server which ports are actually 
being used, and you can set them to other values.

They have all port information.  We do use different port assignments from the 
IANA defined ports as from time to time they run more than one database on the 
same server, but that works for many other far more saturated servers.  Our 
server is dedicated too running 4D but we have no clue what they run on their 
Citrix servers.

I was thinking of setting up an alternative Citrix solution so we could gain 
some experience with it, do some testing and advise but I have always believed 
Citrix is quite an expensive setup.

Re: Just curious: how fast (or slow) is the direct client connection in 
comparison to the Citrix 4D client connection?

Where clients have a leased line the difference is negligible with great 
stability.  Where clients use ADSL the connection is mostly acceptable although 
occasional dropouts can occur.

Any other experiences from yourself or anyone else would be welcome.

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)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Citrix Playbook

[Douglas Cryer via 4D_Tech]

Hi folks,

Most of our clients connect to their databases over the internet directly with 
4D in client server mode.  We have one client where they have an company 
running their IT and do everything via a Citrix connection.  They have been 
having on-going issues with the connection dropping and causing fairly random 
4D errors on the client.   The latest is "Only one usage of each socket address 
(protocol/network address/port) is usually permitted."

Some of their people have used the system in direct connection mode for days 
and do not experience these disconnects.  So we suspect it is an issue with the 
Citrix setup or the network connection from the Citrix server and the 4D Server.

We do not know Citrix in any detail nor do we have access to their Citrix 
Server.  The IT company has no experience of 4D and are blaming it for the 
issues.

Does anyone have a Citrix playbook that we could read and pass on to them in 
order to establish a more sensible dialog.

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)
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: Capturing barcodes without a 'text' field

[Douglas Cryer via 4D_Tech]

Peter,

As Pat said a barcode scanner is nothing more than an input device so it 
operates like a keyboard.  So an enterable text area is the easiest way to 
manage the input.

We do an awful  lot of barcode processing in our EPOS app as well as in our 
main ordering system.   It is about managing the focus of your text area 
whether it be visible of not, when you are in scanning mode.  My advice is try 
not to complicate it.  If there is a lot of things going on in your screen make 
the user make a conscious choice to go into or come out of scanning mode.

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)
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+ SQL access other system

[Douglas Cryer via 4D_Tech]

Chip,

What you are trying to do is all possible and I have done it with many 
different SQL databases over the years with various SQL backends such as DEC 
RDB, Sharebase, Terradata, Oracle, MS SQL, Firebird, MySQL, SQLite and 
PostgreSQL.  

Some of these do not exist anymore the main ones I would expect you would hit 
are: Oracle, MS SQL, MySQL, PostgreSQL

For each there are either general tools or specialist tools which can be used 
from 4D.  My favourite tools are Pluggers options for MySQL, SQLite and 
PostgreSQL

For other databases the base option is to use 4D ODBC Pro apart from Oracle 
where you could use 4D for OCI

I have always liked SQL although each system has it's own variations from the 
standard.

You said you were in the 'can this be done?' phase.  I would say it can be done 
the extent to which it is reasonable depends on your budget and time to learn.  
Sometimes simpler solutions are better.  For instance there are a number of 
tools that will allow you to run a select script which could be written to a 
file and then imported.  That would allow you to separate the SQL scripting 
from the report storage and data processing.

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)
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: v15 - what code runs before On Startup?

[Douglas Cryer via 4D_Tech]

Chip,

Re: 
Component interpreted: the alert is never encountered before the Out of stack 
space issue.
Component compiled (built): the alert is displayed, and the host starts normally

That is strange is it a component Cache issue?  Are you running client server 
or standalone.  I know that in the past I have had issues when switching 
between compiled and uncompiled components that were solved by clearing the 
component cache from the server.

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)
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: v15 - what code runs before On Startup?

[Douglas Cryer via 4D_Tech]

Chip,

Do you have anything in the "On Host Database Event" method in the component?

If you have the database setting on the host as: 'Execute "On Host Database 
Event" method of the components' set then any component might be running 
something.

Re: The ON STARTUP of the component is empty (no code).
As far as I know this method would not run anyway in a component.  I never use 
it so I am not sure.

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)
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: POS Systems

[Douglas Cryer via 4D_Tech]

Hi David,

I have done a few POS related projects in the past 20 years.  What is meant by 
POS can be quite wide.  When I refer to it I mean retail till systems.

I currently have a number of systems that use a 4D solution for till sales in 
fashion clothing boutiques.  Integrated with Card payment systems, receipt 
printers, CCTV time matching against receipts, real-time warehouse stock 
checking.  Nothing particularly ground breaking.  Our own till system is a 
small part of our retail work.  In the UK we have integrations with over 30 
retailers where we push up products and prices to their own till systems and 
receive back sales on a daily basis.

I did also look at doing a hospitality solution but I decided without a sponsor 
it would just turn into an academic exercise. 

What are you trying to do and in what marketplace?

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)
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 Web Log Out

[Douglas Cryer via 4D_Tech]

Lutz,

Re:
>  I'm not really understand your problem. What do you mean with "the browser 
> still persists with the username and password"? Does it mean that you > send 
> these credentials with every request to the web server?

> What we do is this:
> If the browser makes a request without a cookie or with wrong cookie, the 
> server sends a http 401 response and the user gets a login dialog, after
> checking the credentials on the server side the server sends a cookie. All 
> subsequent requests will carry the cookie, the browser does this for you. 
> And the server checks at every request if the cookie is valid.
> If the user press the logout button the server sends a cookie as a response 
> with a cookie expiration of 0 or an expiration date in the past.
> The built in 4D sessions work the same way AFAIK.

In our case we land the user at a login page which handles the httpAuth send 
avoiding the nasty dialog.
If the user is not authenticated they do not get in.  No problem there.
If the user is authenticated then they are taken to the application (written in 
Angular)
At some point they will click the logout button/link and this would cause the 
session to close (WEB CLOSE SESSION) and they are redirected to the login page.

If they then typed in the index of the application index.shtml file the browser 
was still passing in the old username and password so the client was getting 
through the On Web Authentication and was issued with a new session ID and 
could use the system as before the logout.

What I have done today is when the logout happens I now place a call using JS 
from the logout page with invalid (null) credentials which causes the username 
and password to be cleared.  Having carried out significant testing we have not 
been able to get back in to an application page following a log out using this 
method.

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 


 

On 01/03/2019, 15:56, "4d_tech-boun...@lists.4d.com on behalf of 
4d_tech-requ...@lists.4d.com" <4d_tech-boun...@lists.4d.com on behalf of 
4d_tech-requ...@lists.4d.com> wrote:

I'm not really understand your problem. What do you mean with "the browser 
still persists with the username and password"? Does it mean that you send 
these credentials with every request to the web server?

What we do is this:
If the browser makes a request without a cookie or with wrong cookie, the 
server sends a http 401 response and the user gets a login dialog, after 
checking the credentials on the server side the server sends a cookie. All 
subsequent requests will carry the cookie, the browser does this for you. And 
the server checks at every request if the cookie is valid.
If the user press the logout button the server sends a cookie as a response 
with a cookie expiration of 0 or an expiration date in the past.
The built in 4D sessions work the same way AFAIK.





**
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 Web Log Out

[Douglas Cryer via 4D_Tech]

Dani,

Re: Have you looked at the "WEB CLOSE SESSION” command?
   That is probably what you are looking for assuming you are using the 
built in 4D sessions.

Yes I have looked extensively at that command and I am using it.  The examples 
all deal with how you would use it with regards the "On Web Connection" method 
and handling storage of session data for future use.

The problem is that the browser still persists with the username and password 
so it is able to re-authenticate getting a new session and continuing as if the 
user was OK.  The only way we can currently think of is to make a call from the 
logout page with invalid credentials forcing a rejection and thus resetting any 
good credentials that are persisting on the client.

We plan to try this today but I feel this is wrong and I must be missing 
something.

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)
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 Web Log Out

[Douglas Cryer via 4D_Tech]

Hello folks,

Forgive me if this question has been asked many times before  but I am a bit 
stumped.

Logging on to 4D via a web page is relatively simple wither using the nasty 
dialog or rolling your own page to submit the httpauth details.

Logging off however is proving to be more difficult.

I can give the impression of logging off but the username and password seems to 
persist on the client browser so re-entering a previously visited page that 
pulls data just continues to work.  If I manually clear the browser cookies 
then the access gets denied but the 4DSID cookie cannot be cleared by 
javascript...

What are the correct steps to achieve this.  I need help...

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)
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 of Telemetry Data

[Douglas Cryer via 4D_Tech]

Robert,

I am up for exchanging ideas and I recognise some of the things that you want 
to do as things that have been done in a variety of ways in the past in various 
systems I have worked on.

For one of our systems licenses are managed via a simple file placed on an FTP 
which the system with the corresponding license code picks up and either starts 
a count down or in severe cases can put them on immediate stop.  Of course 
there is a mechanism that kicks in when the "call home" fails over a period to 
prevent in house servers from going into off-line mode to keep using the 
license.

We also make use of the REST API built into all our systems now to obtain 
version data and counts of key data that affects billing.  This is a "call in" 
rather than a "call home" method.

What you suggest could be implemented very simply from the systems using a 
HTTP/S call to a simple 4D database receiving the calls.  You would need very 
few methods:  A logging method which saves the telemetry data to a file or a 
table in the database and a method to run on a scheduled basis to send the log 
data to the telemetry system.  You could even send some messages in real time 
if required.

Background
I have a support team of 4 to 5 people who log and resolve customer issues, 
raise change requests, carry our testing and train customers on the system use 
for one of the systems I work on.  For several years they have been using OTRS 
with ITSM which is a very good "open source" web based ticket system.   But it 
was getting increasingly frustrating trying to upgrade it; it was too complex 
for our requirements and we could not (cost effectively) integrate the growing 
amount of installation and customer data that is required to manage the many 
systems.  This led to too many excel spreadsheets being managed by the support 
team.

So we started building our own in-house system.  Step one was to move the 
change requests out, stage two was to include some of the customer and 
installation data.  The next stage to be completed soon will be to switch on 
the ticket system which involves a lot of email threading, merging an more 
complex issues.  We are currently also working on providing more telemetry data 
for billing and management to expand what we already have.  Every change we 
make is driven by a business need to make the small team we have more efficient.

One of the biggest challenges has been that this system had to be fully web 
based for the users and we have few web development skills.

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)
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: SOAP over HTTPS

[Douglas Cryer via 4D_Tech]

Keisuke and Lutz,

Thank you again for your comments.  I have now worked out what is not working...

I was dumb enough to think that all SOAP clients would be equal.  In fact when 
I tried from SOAPUI the HTTTPS call worked fine.  When I tried from 4D v17 the 
HTTPS call also worked fine.

My original call that was failing was being made from 4D 2004 system which just 
fails.  So I can only assume that for whatever reason HTTPS support never 
existed in that version.

This is really not a problem as this system is weeks away from it's v17 release.

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)
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: SOAP over HTTPS

[Douglas Cryer via 4D_Tech]

Keisuke and Lutz,

Thank you for your comments.

Lutz said:
"is not only necessary to access the endpoint with https:// you have to offer 
the service as a https:// service, e.g. you have to adjust the settings in 4D 
to modify the wsdl in the proper way."

This sounds like the key, so I will look into that.  Any clues on what this 
involves as the WSDL is automatically generated by 4D and I do not see general 
controls for SOAP and https settings like you have for the web server.

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)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

SOAP over HTTPS

[Douglas Cryer via 4D_Tech]

Hi folks,

I need some advice on what I need to do to make 4D Web Services accept HTTPS 
calls.  I am using v17 64bit server.

In my naivety I assumed that it would just be a case of changing the URL in the 
SOAP calls to point at the https endpoint.  But this does not work and returns 
"SOAP server not reachable"

The web server works fine on https.  Whilst I can continue using HTTP for SOAP 
it means that I cannot enable HSTS which in turn means I can only achieve an A 
rating on my SSL certificate instead of and A+

Any ideas as to what I am missing?

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)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Quit Action on Windows Close Box

[Douglas Cryer via 4D_Tech]

I have a niggly issue with v17 4D 64bit,

Usually when I click the close box  on the main application window it triggers 
the associated menu  that has the quit action on it.  It is one of those 
automatic things that I have never tried to find a code alternative for.

This still works with v17 32bit but it seems to be disabled in v17 64bit.

Is there a code way to set the quit action for the main application window 
close box?

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)
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: Selection to JSON Date Conversion

[Douglas Cryer via 4D_Tech]

Helge,

Re:
use

SET DATABASE PARAMETER([Booking];JSON use local time;0)  // scope current 
process

before the json command.

Many thanks, that is exactly what I was looking for __.  I had already post 
parsed everything to fix the dates.  It has little impact and removes the 
useless time portion so I will stick with that till v17.

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 


 

On 10/10/2018, 12:48, "4d_tech-boun...@lists.4d.com on behalf of 
4d_tech-requ...@lists.4d.com" <4d_tech-boun...@lists.4d.com on behalf of 
4d_tech-requ...@lists.4d.com> wrote:

use

SET DATABASE PARAMETER([Booking];JSON use local time;0)  // scope current
prosess

before the json command.





**
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: Selection to JSON Date Conversion

[Douglas Cryer via 4D_Tech]

Miyako,

Based on your reply it looks like I have to accept that I will either have to 
write my own version of Selection to JSON or I will have to post parse the 
resulting dates to correct them at least while I am still on v15 4D.  I have 
already seen the impact of setting the "Dates inside objects" parameter in v17 
and know that solves the problem in the future.  I should have been more 
specific in my query to see if there was an easy fix in v15 and v16.

It is a shame that the person who wrote Selection to JSON did not put a little 
more thought into the data conversion issue.  It is a date only field after all 
there is no implication on time other than within the date.  Good to see this 
has been rectified in v17 but that does not help me...

Re: Patrick Emanuel - is that helpfull ?
No.

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)
Archive:  http://lists.4d.com/archives.html
Options: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Selection to JSON Date Conversion

[Douglas Cryer via 4D_Tech]

Help,

I have just hit a problem with Selection to JSON that has me floored and I am 
hoping somebody can point me to missing setting or to my ignorance.

When including date fields in a template and using it with Selection to JSON 
dates that fall inside of BST the dates are being corrupted by taking off an 
hour making them the day before.

So a date like !18/05/2018! Is output as "2018-05-17T23:00:00" (date is in BST)

Whereas a date like !17/03/2018! Is output as "2018-03-17T00:00:00" (date is in 
GMT)

I am sure that 4D is trying to be very clever but I just don't get it and I am 
hoping that someone can tell me what I am missing and how to fix this other 
than rolling my own version of Selection to JSON...

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)
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: Defining and documenting

[Douglas Cryer via 4D_Tech]

Paul,

I think I get where you are coming from.  With a defined structure, table and 
field names it is fairly easy to see what the model is.  What you see is pretty 
much what you get.

Introduce objects and you suddenly have hidden data structures.  Indeed those 
data structures can vary by record which makes them even more mysterious.  Not 
dissimilar to the content of BLObs or for that matter large text fields. When I 
first started using object fields I largely confined them to holding program 
managed properties which I documented in the code.  This still accounts for 
more than 80% of our object field use.

Of course with the power and flexibility of object fields and ORDA it would be 
a crying shame to relegate objects to being an entirely developer toy.  They 
can deliver such power and joy to the users.  Managing properties naming and 
existence then becomes the challenge...  Some ideas I have had is:

External manual documentation - Takes a lot of commitment and keeping on top of 
especially with a development team.  A new field slipped in is immediately 
visible and can be questioned and QC'd.  A new property is invisible except in 
data and so bad naming choices may not be caught till testing generates that 
element.

The only way to know all the properties and values in an object is to parse all 
records with the object field.  This could be a costly process, I have not 
tried it on millions of records.  The alternative is what?  Have a common set 
of properties even if empty/null for every record?  I feel that kind of defeats 
the object __

I am still feeling my way with this and recognise it as a potential to be a 
gotcha.  I have found implementing a REST interface to get at data very useful 
for seeing what is in my records.  Objects of course just naturally show their 
entire structure within the returned JSON.  In some systems I have reference 
records that I can just filter for to give me the entire user data structure 
with data examples.

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)
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: Thoughts and Suggestions?

[Douglas Cryer via 4D_Tech]

Ken,

We have two similar use  cases linked to our i.LEVEL solution.
Order Taker - This is for sales agents throughout Europe selling a large range 
of fashion clothing and jewellery
Store Controller - This is for concession store managers travelling the country 
visiting their concessions in hundreds of retail chains

Both systems download sync code data before  they head off to do their jobs and 
when next able upload orders, store notes images and recommendations.  The 
comms is done via REST as we have built a full REST stack into the main system. 
 The Order Taker was originally built on SOAP but we are now transitioning away 
from that and next season it will be fully REST based.

No iPads though.  One or two clients originally suggested that they wanted 
iPads but when we offered them a far cheaper, more reliable  solution (written 
in 4D) that could be used on Mac or PC laptops as well as cheap as chips 
windows 10 tablets we got real traction on sales.  We now have more than half a 
dozen clients using the solutions and approaching hundreds of agents and store 
controllers.

4D is not the best application to write touch based applications in, as it 
still has some issues, but it is an effective and cost effective solution.

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)
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 Networking or Notworking

[Douglas Cryer via 4D_Tech]

Hi all,

In the past few years there has been an increasing trend towards  Virgin Cable 
internet in the UK.  We have Virgin at our offices now and were using it for 
our primary connection with a fail over back to our existing ADSL connection.  
Increasingly we were seeing a significant number of drop outs connecting to 4D 
databases held at various data centres.  As a result the Virgin connection 
spends more time disconnected than connected and I am waiting for the end of 
the contract period to ditch it entirely.

As well as 4D Client Server we have developed a few strategic applications 
(written in 4D standalone) which run on tablet and laptops for field agents.   
The first of these was implemented using SOAP and would have the occasional 
glitch when syncing but overall was stable and fairly fast.  The second was 
implemented on HTTP REST calls using 4D's HTTP Request function.  This appeared 
both fast and stable until we tested it on the Virgin connection and started 
seeing reports from field use.

Parts of the syncing were taking significantly longer (4 to 5 times the 
duration) than our previous tests and drop-outs were a big problem.  We tried 
many things to solve this but nothing worked other than switching to our ADSL 
where everything ran well.

Frustrated and trying hard to find a solution I decided to try using Pluggers 
NTK which we have a cross platform license for but have never used for very 
much.  There were examples which we were able to modify for our usage and we 
were quickly able to replace the HTTP AUTHENTICATE AND HTTP Request methods.

This was like a magic bullet not only did our REST calls perform consistently 
well on both ADSL and Virgin cable there was a marginal improvement in speed on 
both.  We are moving away from SOAP anyway so having a reliable fast REST 
option makes me very happy.

So this got me to thinking about the whole network part in 4D and the issues we 
have been having with 4D Client v15, 16 and 17 with dropouts on some networks.

It seems to me that if the HTTP Request and WEB SERVICE CALL methods are being 
so affected by networks like Virgin then it is also likely that the 4D client 
connections would be affected in the same way.

Can any body answer the following:
Are there some magic tuning tips that people can share?
Why is it that NTK can be some much more consistent on different networks?
Why are 4D not making the network resilience and speed their top priority and 
talking to people who have clearly made better solutions?

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)
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 Find in Design Client Server

[Douglas Cryer via 4D_Tech]

Hi Folks,

More than 80% of my development effort is spent using client server.  The main 
system I work on these days had 10 years development before I got involved so 
although I have been working on the code for nearly as long I still have to use 
Find in Design daily.  Lets face it we all need it in systems large and small.

So imagine my horror when I am seeing searches which would take several seconds 
to complete in v15 taking several minutes to complete in v17.  This will mean 
more cups of tea, followed by more trips to the toilet and overall reduced 
productivity.

It is probably time someone at 4D optimised this to run the find at server and 
return the results.  My question here though is are you seeing this too or is 
there something else at play that I can affect?

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)
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: Export text columns containing carriage returns to Excel?

[Douglas Cryer via 4D_Tech]

Brad,

My stock answer to questions like this is.  Get yourself a copy of : 
http://www.pluggers.nl/product/xl-plugin/

If you are doing anything serious with excel files this is the easiest and best 
solution and well worth the outlay.

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)
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 do you use to monitor your offsite servers?

[Douglas Cryer via 4D_Tech]

Hi there,

I thought I would chime in as I may have something useful to contribute for 
once __

My support team manage over 30 hosted Windows servers mostly at our data centre 
but some at client sites.  For server remote control we almost exclusively use 
RAdmin.  Unfortunately there is no Mac client so I have to use parallels on my 
Laptop when I am away from the office.  Radmin is really fast and allows more 
than one person at a time to be on the same server under the same account which 
is a huge thing for us.

We also use a product called SimpleHelp.  SimpleHelp is not as fast but it 
solves a completely different use case for us that is supporting and training 
drop in users as well as supporting our EPOS till estate.  Simple help is a web 
Java based tool (Mac, Windows, Unix) that allows on demand or persistent access 
to any remote machine.  So users can connect to a queue where our support team 
can pick up the connection or we can connect to a persistent connection that 
has been previously created.  We run simple help on a UNIX server and have a 
concurrent license which fits the needs of our small support team.

Hope this is useful.

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: XSLT APPLY TRANSFORMATION

[Douglas Cryer via 4D_Tech]

Miyako and Koen,

Many thanks.  The plugin works brilliantly as a direct replacement.

Re: but if it is a command you "never use or know much about" why is it even 
being called..?

I often get asked by clients to look at code that has been written by someone 
else decades ago.  Usually the developer has either retired or moved away from 
4D on some sad occasions, as a result of how long 4D has been around they may 
even have passed on.  Usually, I know what is going on but in this case it was 
something I had never used.  Despite doing loads of XML DOM and SAX 
implementations I had never used the transformation stuff.  I could understand 
what it was doing but not how I could easily replace it.

Thank you again for your input.

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

XSLT APPLY TRANSFORMATION Replacement

[Douglas Cryer via 4D_Tech]

Hi there,

I have a client who has just hit a problem with a deprecated command _o_XSLT 
APPLY TRANSFORMATION

Seems to be two issues.  One the command is deprecated and two the command 
returns a message that it cannot be executed on server.

Does anybody have a viable direct replacement for this command they would care 
to share.  It is not a command I have ever used or know much about so I am 
looking for as quick a fix as possible.

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: MySql login problem

[Douglas Cryer via 4D_Tech]

Pat,

Where is the MySQL database hosted?  If the clients IP has not changed it is 
possible that the IP is restricted by a time rule rather than an IP rule.

We have had this issue more often with FTP than databases but I have seen it.

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Google Authenticator Integration

[Douglas Cryer via 4D_Tech]

Chip,

Thank you for the input.  I am trying to build to what people expect.  My 
target market in this instance is trading exchange users crypto exchanges in 
particular.  In this market 2FA is used extensively as a secondary or tertiary 
security level.  As example Binance but may others use 2FA linked with Google 
authenticator so my potential user base will already have an app for that and 
just need to add a new site entry.

Duo looks to be a good product but does not seem to fit the use case as far as 
I can see.  It is more for corporate use and is priced by user, which would 
make it expensive for a general web solution.  It would be like using 4D Mobile 
REST services and having to pay for all the licenses that could entailand not 
knowing how many people could hit your website at a given time...

I am looking at Authy as well although I do not yet understand the real 
differences.  So I am going to read through:
https://blog.devolutions.net/2016/10/most-popular-2-factor-authentication-2fa-compared
and see if I can educate myself.

It seems, regardless of the app used by the end user, the work in 4D would be 
about the same as the process is to generate a matching time sensitive key 
against which to match.  I have been looking at 
https://www.codementor.io/slavko/google-two-step-authentication-otp-generation-du1082vho

But I got a bit stuck at Step C: as I did not understand what was required.

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 


 On 08/05/2018, 15:05, "Chip Scheide" <4d_o...@pghrepository.org> wrote:

personally, I do not believe anything from Google can be considered to 
be 'secure'... YMMV

I would try a different 2FA app.  
My Wife's employer uses something called Duo

 



**
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: SPAM-LOW: Re: Google Authenticator Integration

[Douglas Cryer via 4D_Tech]

Chip,

Thank you for the input.  I am trying to build to what people expect.  My 
target market in this instance is trading exchange users crypto exchanges in 
particular.  In this market 2FA is used extensively as a secondary or tertiary 
security level.  As example Binance but may others use 2FA linked with Google 
authenticator so my potential user base will already have an app for that and 
just need to add a new site entry.

Duo looks to be a good product but does not seem to fit the use case as far as 
I can see.  It is more for corporate use and is priced by user, which would 
make it expensive for a general web solution.  It would be like using 4D Mobile 
REST services and having to pay for all the licenses that could entailand not 
knowing how many people could hit your website at a given time...

I am looking at Authy as well although I do not yet understand the real 
differences.  So I am going to read through:
https://blog.devolutions.net/2016/10/most-popular-2-factor-authentication-2fa-compared
and see if I can educate myself.

It seems, regardless of the app used by the end user, the work in 4D would be 
about the same as the process is to generate a matching time sensitive key 
against which to match.  I have been looking at 
https://www.codementor.io/slavko/google-two-step-authentication-otp-generation-du1082vho

But I got a bit stuck at Step C: as I did not understand what was required.

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 


 On 08/05/2018, 15:05, "Chip Scheide" <4d_o...@pghrepository.org> wrote:

personally, I do not believe anything from Google can be considered to 
be 'secure'... YMMV

I would try a different 2FA app.  
My Wife's employer uses something called Duo

 



**
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: SSL cipher list

[Douglas Cryer via 4D_Tech]

Jim and Mike,

Thank you for your inputs on this.

The resource: 
https://mozilla.github.io/server-side-tls/ssl-config-generator/ was very 
helpful in creating a cipher list that 4D would accept and which got rid of all 
the insecure options.

With regards:
I would guess its a syntax issue with 4D.  Can you get the current cipher
list from 4D and just change one piece at a time until you get rid of the
weak portions?

Get database parameter(SSL cipher list;$vt_CipherList) returns an empty string 
till you set it.  So you do not seem to be able to get a list of the defaults.  
Maybe you need to dig into the OpenSSL library (yuck)...

Mike also thank you for your list, although it did not make things better.

Even with the config -generator whilst the resulting cipher list removed all 
orange options it did nothing to improve the bars on the already A+ rating.

As far as I can tell this is about as good as it gets.  I have two outstanding 
orange text pieces:
DNS CAA - No  : This appears to be more about who you buy your certificate from 
and the level of purchase (which is where it can get expensive). Also the 
message ECDH public server param reuse - Yes  : I see no way to affect this.  I 
tried switching off the cache to see if it made a difference but no...

If anyone else has any gems I will leave it there happy in the knowledge I have 
matched the target sites I was trying to match and exceeded many high street 
baking establishments.

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Google Authenticator Integration

[Douglas Cryer via 4D_Tech]

Hi folks,

In my quest for building better security solutions I am currently looking at 
implementing 2FA specifically Google Authenticator Two Factor Authentication.

Has anyone done this with 4D code and is willing to share an example?

Seems like the building blocks are there:
QR Code generation via 4D Barcodes component
Hashing encryption vai Common Crypto.bundle

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: HTTPS Connection for Web Module

[Douglas Cryer via 4D_Tech]

Ronnie,

As painful as it may seem I would second the comment made by Dani:

>  I would consider putting Apache or NGINX in front of your 4D v11 application 
> and configure Apache/NGINX as a reverse proxy to your 4D app. >  There has 
> been messages on the nug that can tell you how to do that.

I have done this with Apache.  It took a lot of reading and trial and error.  
It was somewhat frustrating but it was secure.  It does have some additional 
benefits too as you can display a maintenance page when your 4D system is down.

With v11 you can get HTTPS but if your client's IT do any testing you will 
quickly find it rather lacking when compared against todays stringent security 
requirements.  With v15/v16 you can get an A rating with v17 you can get an A+ 
rating.  With v11 native not so good...

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Options To Put Data Into Existing Excel Spreadsheets?

[Douglas Cryer via 4D_Tech]

Allan,

Until recently we were using Keisuke's component.  Clients were asking for 
more, in particular images so we looked around and found the Pluggers Plugin.  
Yes it does mean going from a free option to a paid option but equally it is 
like going from a 2CV to a Ferrari.  It does much more, far faster and far more 
efficiently.  Keisuke himself said that the component was written as an example 
and he never expected it to be used in production systems.

Since adopting the Excel Plugin we have converted many outputs and our clients 
love it.  They have commissioned more reports and we have been able to recoup 
the cost of the plugin easily within months of purchase.

If you still need the component I am sure I can dig you out a copy but I would 
urge you to either fund the cost of the plugin yourself or get your client to 
do so.  You will not be sorry.

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

SSL cipher list

[Douglas Cryer via 4D_Tech]

Hi folks,

I have been working on a project which requires strong web encryption and high 
rating.  The latest FPS and HSTS blog from 4D has allowed me to get an A+ 
rating and compared with the target site I was trying to match I meet all the 
criteria.  There are two of the bars though that are only on 90%.

Key Exchange - I suspect this is a little more involved and may require doing 
dome research into DNS CAA

Cipher Strength - This one I suspect can be improved but I need some help...

The report comes back with the following in ORANGE:

TLS_RSA_WITH_AES_128_GCM_SHA256 (0x9c)   WEAK   128
TLS_RSA_WITH_AES_256_GCM_SHA384 (0x9d)   WEAK   256
TLS_RSA_WITH_AES_128_CBC_SHA256 (0x3c)   WEAK   128
TLS_RSA_WITH_AES_128_CBC_SHA (0x2f)   WEAK  128
TLS_RSA_WITH_AES_256_CBC_SHA256 (0x3d)   WEAK   256
TLS_RSA_WITH_AES_256_CBC_SHA (0x35)   WEAK  256
TLS_RSA_WITH_CAMELLIA_256_CBC_SHA (0x84)   WEAK 256
TLS_RSA_WITH_CAMELLIA_128_CBC_SHA (0x41)   WEAK 128

I was hoping that I could mitigate these by excluding them using something like 
the following:

C_text($cipherList)
$cipherList:="!TLS_RSA_WITH_AES_128_GCM_SHA256:!TLS_RSA_WITH_AES_256_GCM_SHA384"
SET DATABASE PARAMETER(SSL cipher list; $cipherList)

This fails with an error about no cipher match.  So what do I do?
Is what I am trying to do achievable?
Is there a definitive list of the ciphers that can be included/excluded 
relative to 4D and specific enough to omit the ones reducing the score?

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Image Madness

[Douglas Cryer via 4D_Tech]

Cannon,

I tried your code on the supplied image and had to swap the values for 6 & 8 
as, after rotation, the image was upside down.

So
 : ($lOrientation=8)  //Left 90˚, so need to rotate right 90˚
  $gPicture:=Photo_Rotate ($gPicture;90)

   : ($lOrientation=6)  //Right 90˚, so need to rotate 270˚
  $gPicture:=Photo_Rotate ($gPicture;270)

Became
 : ($lOrientation=6)  //Left 90˚, so need to rotate right 90˚
  $gPicture:=Photo_Rotate ($gPicture;90)

   : ($lOrientation=8)  //Right 90˚, so need to rotate 270˚
  $gPicture:=Photo_Rotate ($gPicture;270)

I expect your code is right so does that mean the camera was inverted 
originally to create my odd results?

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Picture Madness

[Douglas Cryer via 4D_Tech]

I have a picture puzzle that I hope someone may be able to help me with.

We are doing the following:
C_PICTURE(vg_Picture)
READ PICTURE FILE("";vg_Picture)

To load a picture to a screen variable.  My colleague has complained that when 
he loads some pictures they as he puts it "lay down".  I got him to send me an 
example and what I found is that despite the image loading into every other 
application as portrait the image loads in 4D as landscape.

The OS (Windows and Mac) sees the file as 3056x4592 but when I examine the EXIF 
pixel x  & y dimensions they do confirm it is a landscape picture 4592x3056.  I 
can only assume that the image was originally landscape and was rotated at the 
OS level but the EXIF properties (which are read only) remained.

What I want to do is load the picture based on its file property dimensions and 
not the EXIF property dimansions.  Is there anyway to do this in 4D code?  I 
hope I have explained the issue correctly...

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Installing a Wildcard SSL Certificate

[Douglas Cryer via 4D_Tech]

Pascal,

Re:
Does the server start up correctly ?

How did you make the cert.pem file ? Make sure it does not contain any 
invisible characters and the linefeeds should be just regular linefeeds not 
windows linefeeds.

Yesterday I was getting no error starting and stopping the web server and I 
relaunched the application several times trying various things.

Today I get an error message “PROGRESS” although I do not know what it means…

Error when executing the method "Server_Window_8 (runtime)" at line number 3

Failed to set SSL certificate

Error code: 46
Failed to set SSL certificate
component: 'srvr'
task -1, name: 'User Interface'

Error code: 49
SSL internal error : error:0906D06C:PEM routines:PEM_read_bio:no start line
component: 'srvr'
task -1, name: 'User Interface'

Error code: 49
SSL internal error : error:0906D06C:PEM routines:PEM_read_bio:no start line
component: 'srvr'
task -1, name: 'User Interface'

So then I found another article: http://kb.4d.com/assetid=77137 


This one explained the above error as I had left the pub.pem file in the 
folder.  It also suggested that it was no longer necessary to put both 
certificates in one file.

Here is where I am now...

When I combine both certificates in the same file and connect from a browser I 
get a message :
“Performing TLS handshake to dev.ilevelportal.co.uk 
…”
This eventually times out and I get nowhere…

When I use two separate .pem files (in addition to the key.pem) cert.pem and 
dev.pem I get a message:
“Connecting to dev.ilevelportal.co .uk”
which quickly times out and I get nowhere...

Clearly I have got something wrong.  Does 4D support wildcard SSL certs?  Mine 
is from rapidSSL.

When I got the email I received:
Web Server CERTIFICATE
INTERMEDIATE CA:

When I look in account I seem to have 3 certificates:
Certificate (CRT)
CA Bundle (Root & Intermediate Certificates) - This is two certificates 
combined.

I have tried using all 3 in various combinations.  No joy...

I would say I am pulling my hair out but I have so little to start with…

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 

 

> On 10 Apr 2018, at 18:40, 4d_tech-requ...@lists.4d.com wrote:
> 
> Installing a Wildcard SSL Certificate

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

Installing a Wildcard SSL Certificate

[Douglas Cryer via 4D_Tech]

Hi folks,

It has been some time since I have installed an SSL certificate with 4D and I 
seem to be having little success.

In this case I want to use a wildcard SSL certificate so I found an article 
that explained what you had to do with the intermediate part of the 
certificate.  

I have followed:
http://doc.4d.com/4Dv15/4D/15.5/Using-TLS-Protocol.300-3576925.en.html 

and
http://kb.4d.com/assetid=34856 

I believe I have done everything I need to but for the life of me I cannot get 
a connection to the server via HTTPS.  I have tried to get it running on port 
19225 but when that did not work I also tried on standard 443

Server is responding fine on HTTP (19223) and the correct ports are open on 
both Windows firewall and the physical CISCO firewall.

Is there anybody out there who has loads of experience can either give me some 
tips or sell me some time to get this sorted?

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: 4D Summit 2018 Comments

[Douglas Cryer via 4D_Tech]

I am very excited about ORDA.  Hopefully it will help to attract more young 
developers.

I am however somewhat cautious about the potential GOTCHAS that will 
undoubtedly come out from using it.  A few early examples:
I find the having to restart the server if an entity or property (table or 
field) name is changed very un 4D like.  This could be a real pain in team 
development on server.
The entity and property names are not tokenised so to avoid breaking code we 
will have to use Table name and Field name then use the result.
To use ORDA on a table or field you must have the “Expose with 4D Mobile 
Service” checkbox ticked on any table or field you need to use it on.  Not sure 
if that is intended but it is how it currently works :-(
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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: Import from Excel

[Douglas Cryer via 4D_Tech]

Another vote for Pluggers Excel plugin.
https://www.pluggers.nl/product/xl-plugin/ 


You will not regret it for creating and reading excel files it is simply the 
best, just as you would expect from Pluggers.

For my usage it has paid for itself over and over and just keeps giving…

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: REST server component?

[Douglas Cryer via 4D_Tech]

> On 13 Feb 2018, at 20:00, 4d_tech-requ...@lists.4d.com wrote:
> 
> Anyone have a full-featured, debugged REST server component for 4D?

I am doing a session at the Conference in Paris which will demonstrate a REST 
implementation in 4D.  It will not be a component but an example database with 
methods showing how REST can be implemented in 4D with the built in web server.

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: https://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**

Re: HTTP Body Size

[Douglas Cryer via 4D_Tech]

Re:

> On 8 Feb 2018, at 15:57, 4d_tech-requ...@lists.4d.com 
> <mailto:4d_tech-requ...@lists.4d.com> wrote:
> 
> I wouldn't do this, it trims the BLOB at 32K unless you specify the UTF8 
> constants (see docs).
> you might want to consider CONVERT FROM TEXT instead.
> 
>> 2018/02/08 17:36、Douglas Cryer via 4D_Tech <4d_tech@lists.4d.com 
>> <mailto:4d_tech@lists.4d.com>> のメール：
>> TEXT TO BLOB($vt_Request;$vx_Request)
> 


My bad.  In fact I was doing TEXT TO BLOB($vt_Request;$vx_Request;UTF8 text 
without length)  I missed that when typing it into the email.

We have also tried sending the image as the payload instead of making it JSON 
as well as many other things.

I forgot to mention we are doing the call from v16R5 desktop application to a 
v15.4 server not that that should make a difference but possibly someone knows 
different.

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 <mailto:jdcr...@telekinetix.com>  Web : 
http://www.telekinetix.com <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
**

Re: HTTP Body Size

[Douglas Cryer via 4D_Tech]

Jeremy,

Re:
> Instead of a text variable, you can also use a blob variable to avoid the 
> size limitation.
> 
> http://doc.4d.com/4Dv16R5/4D/16-R5/WEB-GET-HTTP-BODY.301-3481155.en.html 
> 

Yes in fact I am declaring the body variable as a BLOb and passing a BLOb from 
the client.

Roughly speaking here is what I am doing on the client:

C_LONGINT($vl_MyID)
C_PICTURE($vg_Image)
C_BLOB($vx_ImageBlob;$vx_Request)
C_TEXT($vt_ImageB64Text;$vt_Request;$vx_Response)
C_OBJECT($vo_Object)
$vl_MyID:=1
PICTURE TO BLOB($vg_Image;$vx_ImageBlob)
BASE64 ENCODE($vx_ImageBlob;$vt_ImageB64Text)

$vo_Object:=New object
$vo_Object.id :=$vl_MyID
$vo_Object.image:=$vt_ImageB64Text

$vt_Request:=JSON Stringify($vo_Object)
TEXT TO BLOB($vt_Request;$vx_Request)

HTTP AUTEHNTICATE(“TEST”;”TESTPASS”)
$vl_Status:=HTTP Request(HTTP Post Method;”MYURL”;$vx_Request;$vx_Response)  
//Also tried adding various headers
$vt_Response:=BLOB to text($vx_Response;UTF8 text without length)
$vo_Response:=JSON parse($vt_Response;Is object)

I have built dozens of POST methods like this and all have worked till I try to 
put a relatively small BASE64 encoded image into the JSON and the subsequent 
BLOb.  I have also built several rest calls that send out images following a 
GET Request.  The POST just seems to cause the Web Server some major problems.  
It seems to hang the On web authentication part...

I am looking for a way to send the images that works.

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

HTTP Body Size

[Douglas Cryer via 4D_Tech]

Hi folks,

I am working on a Windows tablet application where I am using RESTful services 
between a 4D App and a 4D Webserver.

I have now hit a snag when I try and pass images back to the server with the 
HTTP client.  The package is being truncated due to the image size.  I read the 
docs and under On Web Connection it states that there is a 32K limit on the 
body.  So I am thinking how can I do this.

I look at another part of the docs and under WEB GET HTTP BODY it specifies 
that the body parameter can receive up to 2GB of text.

Clearly I am not understanding something?

The weird thing is that the POST sometimes works but usually not?

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

Re: The writing is on the wall

[Douglas Cryer via 4D_Tech]

The title of the post is correct.  Here is my view…

Since the new network layer was introduced I have tried firing up various 
databases with this setting on.  In every case I have changed it back after a 
day or two as it was so unstable and was causing me so many issues.  These were 
existing systems under test, new projects under development and even a 
production system that had been upgrade and the setting was missed.

All servers run 64bit but we currently have no plans for 64bit clients so this 
is not immediate issue but as you say the “Writing is on the wall” and the 
clock is ticking as it has been for the past few years.

90% of all our deployments and development are running on hosted servers in the 
cloud and rely on any number of broadband providers and cabling solutions.  All 
of which works well enough via the legacy network layer but is unstable via the 
new networking layer.

I do not have resources to carry out in depth analysis and reporting on stuff 
like this.  We pay good money for a good product and I can only hope that 4D 
will continue to work on the network layer and make it stable and usable for 
all parties.

I have read the long descriptions of the history of the legacy network layer 
and all the work arounds.  I fully understand the pain of trying to implement 
something new but I cannot afford to take that pain on.  I will keep trying it 
with every release and when it appears stable I will deploy it.

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

Re: Capture Image on Tablet

[Douglas Cryer via 4D_Tech]

Tim and Timothy,

Thanks for the information.  I thought it was going to be the solution as it 
works really well on a Windows 10 desktop with a plugin USB web cam.  However, 
we have not been able to get it to recognise a tablets built in cameras.  We 
have tried updating the js source code but no joy with getting the camera to 
appear on the list f devices.

Camera show up under device manager and we have set Windows to allow apps to 
access camera but no joy…

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

Capture Image on Tablet

[Douglas Cryer via 4D_Tech]

Hi folks,

I am writing a new tablet based app for store controllers who visit stores to 
have on hand stats fort the store they are visiting.

One of the functions I want to be able to provide is to take a picture with the 
tablets camera directly inside of the 4D application.

These will be Windows 10 tablets like we use for our salesforce application but 
I have never had a need to get a photo before.  I want to avoid the obvious 
take the picture; browse for the picture load the picture paradigm.

What is the easiest way to achieve this?
Can it be done with 4D code only or will I need a 3rd party plugin?

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

Re: Microsoft Outlook Integration

[Douglas Cryer via 4D_Tech]

Tim,

I have some code that I think does what you are asking for.  Essentially I have 
written some methods that execute VBScript for Windows and Applescript for Ma.  
This supports calling Outlook on both platforms and Mail on Mac to send emails. 
 It also gets the list of email accounts from the users outlook/mail so you can 
do a popup in your interface.

I have not done this in a component or anything so it will take an hour or so 
to pull it out and give it to you in a form that will make sense.

Let me know if this is of interest.

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

Re: HTTP Request PATCH

[Douglas Cryer via 4D_Tech]

Koen,

Re:
>  There is no PATCH constant defined in 4D, but you can use “PATCH” as string 
> for http method as the first parameter:
>  HTTP Request(“PATCH”;$url;…)

Many thanks.  I had that thought in the waking hours and was going to try it.  
I had not spotted it was a string constant.

The call works fine now :-)

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 

 

> On 22 Nov 2017, at 20:00, 4d_tech-requ...@lists.4d.com wrote:
> 
> HTTP Request PATCH

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

Apache Kafka

[Douglas Cryer via 4D_Tech]

Hi all,

Has anyone had any experience communicating to an Apache Kafka service for 
sending or receiving data?

If so how did you do this and what were your experiences (if willing to share).

I will be needing to do this next year and wanted to get the jump on it...

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

POP3 Email Processing

[Douglas Cryer via 4D_Tech]

Hi folks,

After many years using OTRS for our help ticketing and change control we have 
recently decided to roll our own 4D based solution.  This is partly a cost 
thing; partly a support/functionality thing and partly to get our teeth into a 
project where we can get used to the latest version of 4D while we wait for v17 
R3 :-).

The core of a system like this is reading in Email messages.  I have done 
simple parsing of emails in the past (long past) but looking at it now I was 
surprised at how little the internet commands actually do for you before you 
have to get down and dirty with loads of parsing.

Essentially we need to create a HTML file with the email body and inline 
images.  Plus all the attachments; recipients; subject; dates and other info.

We are looking at using a 3rd party product called "EAGetMail POP3/IMAP4 
Component” - https://www.emailarchitect.net/eagetmail 
 to do all the heavy lifting.  Before 
I go ahead and purchase this is does anyone else have any other ideas or 
options?

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

Deprecated Constants

[Douglas Cryer via 4D_Tech]

Hi all,

I just ran an upgrade to v16 (R5) to see what work might be required.  By far 
the biggest issue will be images that still reside in the library.  Aside from 
that I got 19 instances of constants that are now deprecated:

_o_Mac To ISO - 1 Instance no longer required…

_o_Extras Folder - 9 instances but could not find any mention of this in the 
deprecated features.  What is the general migration policy as I assume the 
Extras Folder will no longer be supported?

The other 9 entries relate to List Box constants:
_o_lk_header height - used to be Listbox header height
_o_lk_hor scrollbar position - used to be Listbox hor scrollbar position
_o_lk_ver scrollbar position - used to be Listbox ver scrollbar position

also Listbox display header has not been deprecated but has now become lk 
display header.  What is the “lk" ?

Any thoughts would be appreciated…

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

Re: What to do about users who won't follow instructions?

[Douglas Cryer via 4D_Tech]

Pat,

An age old question.  I have a few thoughts around this.

My baseline is to start with the assumption that it is not the person but the 
system or the explanation that they have been given that needs improvement.  I 
suspect that you do this also but sometimes people can confound us.

Firstly, I employ people with more patience than myself for dealing with people 
who do not follow instructions we have provided.
We have policies about training that ensures a certain level of competency with 
our customers and their users.  We will not support all users just those who 
have been trained and have competency.
In really severe cases we have banned certain individuals from contacting our 
support team.

Sometimes the message needs to be adapted to the user as not everybody thinks 
the same way.  A bit like when somebody repeats back a telephone number in a 
different way to how you say it to them and you cannot check it :  I say 01234  
- 271 - 930 and they say back 012 - 342 - 719 - thirty…

Taking a little walk and having a scream sometimes also helps :-)

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

Re: 4D v16.2 false record locks

[Douglas Cryer via 4D_Tech]

Yes please, what David said…

> David Adams wrote:
> 
> ...but seriously, what I'd like to see 4D do is an *entire release* that
> consists of *nothing* but fixing bugs - as many as they can find, as many
> as we can find and longstanding annoyances. No fancy new features. Just
> cleaning up crashes, usability bugs (I see lingering 2004 or V11 usability
> bugs in the Design environment every single day in V16) and other weird
> stuff.


Hopefully v17 will bring with it some stability.  Looking back we skipped v12, 
v14 and so far have not used v16 in production.

My job is not to spend time identifying and reporting bugs to 4D.  My job is 
delivering solutions to my customers.  Sometimes that involves using non 4D 
solutions, sometimes it involves working around long standing bugs or 
undesirable features of 4D.  When 4D becomes an open source project then I will 
contribute to its development but while I am paying hard cash it is 4D’s job to 
provide the debugging, analysis and fixing resources.  If a version or feature 
is unstable, untrusted or unusable I simply do not adopt it or I adopt it in a 
way that is not going to hurt my clients, that is my job.

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

Re: Programmatic control of accept/reject new connections

[Douglas Cryer via 4D_Tech]

Hi there,

I thought this could be done with the “On Server Open Connection” Method.

Not used it in a long time but if it returns false your client will be refused 
connection.

http://doc.4d.com/4Dv15/4D/15.4/On-Server-Open-Connection-Database-Method.301-3286437.en.html
 


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

Re: v13.6 - 2 servers same network, how to make it work

[Douglas Cryer via 4D_Tech]

Alan,

If you are running the databases on different servers each with their own IP 
address you should not need to change the ports at all.  In this case, if both 
are set with the default ports then they will both be visible under available.

If you are running two or more servers on the same server/ip address then you 
must change one of the databases to broadcast on different ports.  The server 
with the changed ports will not be visible under available to a client that has 
not itself been customised.

Instead you would need to click on the server that is available then go to the 
custom tab change the name and add the port number to the end of the IP address 
with a colon at the start such as “:19001”

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

Re: Getting image from JSON

[Douglas Cryer via 4D_Tech]

OK I have figured it out…

BASE64 DECODE($vt_Image;$vx_BLOb)
BLOB TO PICTURE(vx_BLOb;$vg_Picture;”.png”)

Works…

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

Getting image from JSON

[Douglas Cryer via 4D_Tech]

Hopefully this is a simple one for many people out there.

I am working with a REST service that is returning an image in a JSON response.

The image is coming back as a long text value and I am not sure what steps I 
need to go through to convert it to an image.

I tried : 
TEXT TO BLOB($vt_Image;$vx_BLOb;UTF8 text with length)
BLOB TO PICTURE(vx_BLOb;$vg_Picture;”.png”)

Rather nave I know…

I also want to reverse the process for something else so I can send images via 
JSON.

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

Re: Image Export to Excel

[Douglas Cryer via 4D_Tech]

Douglas,

Re:
> 
> One of the best kept secrets of the 4D plugin world — the XL Plugin from 
> Pluggers.
> 

Many thanks.  I do not know how I have missed that for so many years given my 
usage and love of Robs work.

Looks like I have a lot of work to do converting existing reports but I think 
it will be worth the work as I can see it will be neater, faster and give me 
greater flexibility.


Regards,  Dougie
**
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: Image Export to Excel

[Douglas Cryer via 4D_Tech]

Miyako,

Thank you for your reply a while back...
> On 19 Jul 2017, at 20:00, 4d_tech-requ...@lists.4d.com wrote:
> 
> the component was meant to be a simple demonstration of how one can call 
> AppleScript and VBA from 4D.
> it was never meant to be an "out of the box" kind of production tool.
> 
> if possible, you should consider writing your own script rather than using 
> the component "as is".
> calling those segmented commands is going to be extremely slow and 
> inefficient.
> 
> Google "AppleScript excel insert image" or "VBA excel insert image"
> you should find lots of examples.

I was a little surprised at the response but understand it.  I believed that 
you had written the component to fill a woeful gap in 4D’s capability to 
communicate to the most widely used spreadsheet and reporting tool in the 
western world.  I also think you did rather a good job at it.

So when you say it was a simple demonstration I was surprised.  I did google 
inserting images but on the VB side I could not really figure out which 
articles were useful and which were dead ends.  I did not get as far as the 
AppleScript side.

I previously spent days doing VB/Apple script for communicating to Outlook 
(just getting account data and sending emails) and that really challenged me as 
I do not work with these languages on a daily basis.

I will ask again before I go and spend days on this, has anyone else extended 
Miyako's library to insert an image from 4D into Excel?

Regards,  Dougie
**
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
**

Image Export to Excel

[Douglas Cryer via 4D_Tech]

Hi all,

I use the excel component written by Miyako to output all kinds of data to 
excel.  I want to be able to insert images into some spreadsheets, either as 
actual images or via URL’s which can then be transformed in some way.

Does anyone have a method / technique of doing this that they are willing to 
share?

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

Expose with 4D Mobile Service

[Douglas Cryer via 4D_Tech]

Hello,

Is there any way to get or set the property in 4D tables and fields to identify 
if a field or table is exposed with 4D Mobile Service.

Is there any penalty or risk associated with having this setting on?  It seems 
like everything just got it when we upgraded and the only way to unset it is to 
manually go through every field and table and uncheck the box.

I will likely never use this feature for a variety of reasons, but if the 
setting could be read and set I could use it with my own REST implementation.

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

Error -19191

[Douglas Cryer via 4D_Tech]

Hi,

We have a client trying to connect to a database from Austria and they are 
getting a -19191 error when trying to connect.

Anyone know what this error is?

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

Re: Website development path

[Douglas Cryer via 4D_Tech]

Joshua,

I read a post you made in January (below).  I am currently building out a REST 
interface for a system.  I am finding writing the REST calls fun and 
challenging but the 4D language has a lot of stuff that helps.  What I am not 
having much fun with is the documentation.  I know what I want to document but 
I am not sure what the best approach is.

I read Swagger all the time although some of the documentation I have seen 
where the developers say they have used Swagger is frankly not that great.  I 
am not sure how I would use Swagger with hand coded 4D REST calls.  Do you have 
any guidelines or advice?  I think it might be just about getting some good 
templates which is not my strongpoint.

Regards,  Dougie

> On 16 Jan 2017, at 20:00, 4d_tech-requ...@lists.4d.com wrote:
> 
> We wrote a REST API in 4D and expose it with the built in web server.  The 
> REST API serves up JSON docs formatted in Siren.  The API is documented in 
> Swagger. On the front end we wrote an AngularJS application that talks to the 
> REST API.
> 
> Advantages:
> * If we wanted to we could implement the same API somewhere else and the 
> front end would keep working. There isn't anything 4D-specific about the web 
> app.
> * Our customers can access the REST API directly and build their own tools 
> (and a few of them are!).
> 
> Disadvantages:
> * Creating a REST API in 4D is time consuming. There aren't any 
> tools/frameworks to make this happen or to automatically generate 
> documentation, etc.
> 
> I found these two books to be very helpful:
> AngularJS Up and Running: http://shop.oreilly.com/product/0636920033486.do 
> 
> RESTful Web APIs: http://shop.oreilly.com/product/0636920028468.do 
> 
> 
> Joshua Hunter



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

Re: 4D and Sage

[J. Douglas Cryer via 4D_Tech]

Pat,

Transpose is your best bet.  It does the automation and you can just
pickup and drop files.

Regards,  Dougie



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

[Douglas Cryer via 4D_Tech]

Pat,

We have done 3 things with regards Sage Integration.  It is important to note 
these are all in relation to Sage Line 50.

Simple Export
This is just exporting invoices in a text format for import into Sage using 
their standard import function.

Integration via Transpose - http://www.red-it.co.uk/transpose 

This is a middle ware application that will sit on the server with Sage and 
manage the communications via a selection of file based formats.  We have used 
this for many years but a while back the original developer sadly passed away 
and it was over a year before another company took up the product.  Thankfully 
it is supported well going forward.

Integration via Sagelink - http://www.eigergroup.co.uk/accounting/slink.html 

This is a similar solution to Transpose that we implemented for a client during 
the dark period where we could not get licenses or support for Transpose.

The 4th option I guess would be to become a Sage partner at a cost of £6.5K a 
year and write your own integration but not viable for most companies.

Maybe you could convince them to use Xero.  They have a great REST API which we 
have done a pretty full integration with.  We have not had a Sage integration 
request since we provided the Xero integration.

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

Re: Desktop DBMS engines

[J. Douglas Cryer via 4D_Tech]

How about:

Firebird 
SQLite

Both Can be used as desktop DBMS engines.



**
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: AS400 & 4D...

[J. Douglas Cryer via 4D_Tech]

>
>Robert,

You would need to use ODBC to connect to the DB2 database.  I have not
needed to do this since the 90¹s so no longer have any current information.

Often AS/400 systems have many well defined and documented file transfer
processes to allow communication with other systems so I would look out
for other ways to connect than just direct access.

Regards,  Dougie



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

Hex Colour Picker in Listbox

[Douglas Cryer via 4D_Tech]

Hello all,

I have a list of colours in my system and I have a corresponding hex colour 
code field but nobody has really used it.  I want to do a few things:
Automatically map common colours to hex colours (via a lookup
Provide a hex colour picker that I can use in a listbox
Use the returned/edited hex colour to do one of the following:
Set the text colour to the chosen hex value
Set the row or cell colour to the chosen hex value
Is there an example of this anywhere?

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

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

Anyone using v16 in WAN

[Douglas Cryer via 4D_Tech]

I would like to hear from anyone using v16 in a WAN environment.

Frankly every time I have tried out v16 or for that matter any v15 R release I 
have been shocked at how poor the network connection stability has been.

It seems to stem from the new networking layer and certainly it seems to be 
more stable when the legacy  networking checkbox is checked but frankly it 
scared me off being an early adopter.

I now have a little time to look at this again but wanted to gather some 
information from the community before I proceed with more testing.

Are there any recommended settings and configurations I should look at?  Some 
background:

All our servers are running on Windows Servers mixture of 2008 and 2012.
- 90% are dedicated hosted servers with a few in-house servers
- Multiple databases run on our hosted servers on separate ports
- WAN connection for each server is dedicated 100Mb
- Client connections vary from domestic grade ADSL, Virgin Cable and Leased 
lines
- Clients are a mixture of platforms 90% Windows 7, 8 & 10 and 10% OSX

We have occasionally had issues with certain clients broadband connections but 
all in all v15 stability has been good.

Issues I was seeing with v16 were:
- Client connection timeout errors
- Clients which had logged off, showing as connected to the server

Am I missing some key documentation in this area or maybe some new networking 
layer tech note?

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

Re: HTML Editor in 4D

[Douglas Cryer via 4D_Tech]

OK so within an hour of posting this and after a few dead end internet searches 
I found this:

https://4dtoday.eu/blog/2015/02/20/tinymce-html-editor-for-4d/ 


Which is exactly what I was trying to do :-)

So why did I not think this was possible to do?  The v15 Docs still say:

"You can call 4D methods from the JavaScript code executed in a Web area and 
get values in return.
Important: This feature is only available if the Web area uses the integrated 
Web Kit as the rendering engine."

In WA EXECUTE JAVASCRIP FUNCTION the docs also state:
"Important: Handling complex type results (objects, dates, etc.) is only 
possible if the Web area uses the embedded Web rendering engine."

Are these the same or contradictory statements?

In any case Rolf is doing exactly this with the Web Kit option off and it works 
like a charm.

Thank you Rolf Bachmann, I owe you at least a drink at the next 4D conference.

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

HTML Editor in 4D

[Douglas Cryer via 4D_Tech]

I have a requirement to provide HTML data for web site product descriptions, 
authored within a 4D database.

What is the best way to achieve this using v15.
The styled text area is not powerful enough even to do bullet points.
4D Write is an expensive option for just this purpose and I am not even sure if 
4D Write for v15 is production safe?
4D users and groups are not implemented in this system so everyone would need a 
Write license despite only one person needing it.
I have toyed with the idea of using a web area with TinyMCE but
I am not sure how I would get the edited content back
It does not work when the Use integrated Web Kit option is clicked (what does?) 
cutting options for interactivity down.
Anybody got any experience doing this or something similar?

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

What is Cadran?

[Douglas Cryer via 4D_Tech]

I have  number of EPOS tills which use an engined 4D application which has been 
in place for around 6 years with a few upgrades and version releases.  One of 
the till has just started reporting an error:

Error when executing the method “Cadran_1” at line number 8
The method cannot be executed
Project method cannot be found
Cadran

I am baffled as I have no such method?  Does anyone know what might be causing 
this?

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

Re: Strategy to allow one user to drop another from the server

[Douglas Cryer via 4D_Tech]

Kirk,

We had a similar requirement.  In our case it was users remaining logged on 
after they had gone home.  We needed them to be kicked off in order to run 
maintenance and so the backup was not slowed.

I used execute on client to display a dialog to the user informing them that 
they would be logged off in x seconds/minutes.  In our case they had a choice.  
If they were really there and wanted to continue working they could click one 
response, or they could click quit.  After the specified time the user was quit 
out.  It would be easy enough to write a corresponding reply to the original 
user to inform them that the target user did not wish to quit.

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

Re: Understanding 4D Mobile

[Douglas Cryer via 4D_Tech]

When Wakanda was first released and the 4D mobile concept came about I got 
really excited as I like you thought of all the small functions that I could 
publish like little dashboards, public information, company news.  I was never 
thinking lets re-write thousands of screens for internal users but via a web 
page.

But like you I quickly realised that the licence cost made this type of 
publication non viable.  For the type of function I would want to use I would, 
in many cases, I have an unknown user base.

I thought that as I had already purchased a web server license and in some 
cases also a web services license that I would have access to the nice 4D 
Mobile REST services.  I stated 4 years ago and I still believe it today that 
the decision that they made on licensing has held back adoption of the 4D 
Mobile and Wakanda projects.  I simply have not been able to make a business 
case for its use.  Whereas if it had been a simple license add on then I would 
have been able to buy the connector and buy the Wakanda developer kit and add 
the cost to the annual maintenance bill.

What I have done instead is use 4D’s web server and develop my own mini apps to 
hang off it.  My next project longer term project which I just started is to 
deliver a RESTful interface for a number of tables and functions so other 
people can do the pretty front end bit and I can concentrate on the data.

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