Re: ORDA - NOT(IN)
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 <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)
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 <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
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 <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
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 <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
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 <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?
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 <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
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 <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
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 <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
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 <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
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 <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?
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 <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?
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 <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
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 <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
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 <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
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 <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
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 <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
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 <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
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 <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
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 <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
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 <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
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 <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
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 <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
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 <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
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 <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
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 <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?
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 <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
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 <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
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 <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?
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 <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?
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 <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
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 <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
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 <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
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 <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
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 <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
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 <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
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 <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
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 <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
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 <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?
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 <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
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 <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
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 <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
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 <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
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 <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 <http://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 <http://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 <mailto:jdcr...@telekinetix.com> Web : http://www.telekinetix.com <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
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 <http://doc.4d.com/4Dv15/4D/15.5/Using-TLS-Protocol.300-3576925.en.html> and http://kb.4d.com/assetid=34856 <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 <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: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: 4D Summit 2018 Comments
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 <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: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Import from Excel
Another vote for Pluggers Excel plugin. https://www.pluggers.nl/product/xl-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 <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: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: REST server component?
> 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 <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: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: HTTP Body Size
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
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 > <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 <http://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 <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 **
HTTP Body Size
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 <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: The writing is on the wall
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 <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: Capture Image on Tablet
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 <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 **
Capture Image on Tablet
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 <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: Microsoft Outlook Integration
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 <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 Request PATCH
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 <mailto:jdcr...@telekinetix.com> Web : http://www.telekinetix.com <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
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 <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 **
POP3 Email Processing
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 <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 <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 **
Deprecated Constants
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 <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: What to do about users who won't follow instructions?
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 <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: 4D v16.2 false record locks
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 <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: Programmatic control of accept/reject new connections
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 <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 <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: v13.6 - 2 servers same network, how to make it work
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 <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: Getting image from JSON
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 <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 **
Getting image from JSON
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 <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: Image Export to Excel
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
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
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 <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 **
Expose with 4D Mobile Service
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 <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 **
Error -19191
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 <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: Website development path
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 > <http://shop.oreilly.com/product/0636920033486.do> > RESTful Web APIs: http://shop.oreilly.com/product/0636920028468.do > <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 <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: 4D and Sage
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
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 <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 <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 <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: Desktop DBMS engines
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...
> >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
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 <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: Replacing - OAuth.bundle
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 <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 **
Anyone using v16 in WAN
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 <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: HTML Editor in 4D
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/ <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 <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 **
HTML Editor in 4D
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 <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 **
What is Cadran?
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 <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: Strategy to allow one user to drop another from the server
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 <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: Understanding 4D Mobile
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 <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: 3rd Party Structure Repair Tools
Koen, Thank you for both postings. I was able to get into the design environment and after a bit of a battle with the bad method I was able to delete it and flush it from the trash. Miyako, I did not really understand your comment: - rather than going to Design the normal way, you could open the DB directly with the MSC. I did this for verifying and repairing both of which reported the structure was good. Am I missing something? Is there some way of looking deeper at the structure in MSC? I have a problem with a different database where tools gives me a warning on a method that no longer exists in the database. The warning reads: (MY_NON_EXISTENT_METHOD [I.55] : invalid table number So the bracket before the method indicates it is looking at a deleted method but the method does not exist in the trash. I have tried adding a method with the same name then deleting it and removing it from trash to see if that would either error along the way or flush it out. Any other ideas? The database is not broken YET... I saw a demo at one of the conferences for a full structure checking application but I have not heard anything since. 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 **
3rd Party Structure Repair Tools
Hi folks, Are there any 3rd party structure repair tools for 4D v15? I had a situation today where the database crashed when writing a method and now when I open the design environment the methods start opening and the database crashes. No way to open the design environment AT ALL. I have tried: Opening from Mac client, windows client mac/win standalone. Repairing structure (which comes up and says OK) Compacting structure (also OK) All of the above on different machines. I am going back to my backup but it worries me that this could happen and that there is no way to get in. Also is there some underlying issue that I cannot know about because 4D says the structure is fine? I have experienced issues like this a long time back and I was able to go back to my backup and then export bits of code that I had been working on with insider. Now I guess I have to take more regular backups during the development day? 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: What is your preferred way to inspect object contents ?
Peter, I do one of two things: Simple – Display the object on screen and scroll through the JSON to see if I like what I see. Complex - Write a parser to break the elements out and show them in a listbox. When you put an object field into a listbox 4D says that you need lstbox pro so maybe there is a better way if you have listbox pro? 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: Apple Agrees with 4D
Peter, So are 4D going to provide us with the tools to populate this new window or is some clever developer going to provide us with a plug-in? I may have miss-understood the whole thing but it seems that unless we have some access to the touch bar then in actual fact 4D will not agree with Apple ☺ 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: Data grid with variable height
Mitch, Depending on what you are trying to do with the interface you could probably achieve what you are looking to do with a sub form combined with the TEXT TO ARRAY command. It would not be simple though. In the past we have compromised on a general height for each row and then allowed the user to expand the text by clicking on the row but obviously this is not great. The web area is another option. You could use a simple HTML template or a Javascript library. There are so many that I do not want to make a recommendation. It really depends what you are trying to do. I have done this last one however, the problems start when you try to create interactivity with the web area as this is not simple and leads you down various choice trees about which implementation of the web area you use and platform specific issues and restrictions. 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: v15 DLL Plugin Issue
Many thanks to everyone who input into my issue. I have eventually found a solution. I wrote a VBScript that calls the ActiveX object and that works now. Initially it was not working when I tested it on the desktop but it works from within 4D v15. Here is my crude understanding of what was happening: When the script was double clicked it is running WScript and given the platform it is probably running the 64 bit version which could not create the ActiveX object. When I write and run the script file from within 4D I am using CScript and this is working. I am assuming because it is running 32bit version of CScript. What ever the reason I now have a working solution with the COM object and LAUNCH EXTERNAL PROCESS Thank you everyone who gave input as knowing I had other minds on it helped keep me sane. 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: v15 DLL Plugin Issue
Timothy and Miyako, Thank you for your input, I found the following based on your suggestions: Under v13 The plug-in shows in the list as AddressX but in the explorer window as DLLTOOLSSW Version 1.0.1.0 Location “AddressX.bundle” in volume “C:” with a full path displayed with a popup menu. Under v15 I see the plug-in called AddressX but the only information it shows in the explorer window is : AddressX Location “AddressX.bundle” in volume “C:” with a full path displayed with a popup menu. Also the commands now appear below a sub section now called “Theme 1” instead of directly under the AddressX plug-in. This does not give me any further clues. Clearly v15 is reading the plug-in differently but that does not help me fix the issue. 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: v15 DLL Plugin Issue
Miyako, Re: unless the plugin is dynamically loading the DLL (LoadLibrary), it should appear as disabled immediately because dependencies are resolved at startup. if that is the case, you could use "depends" to see which DLLs are missing. http://www.dependencywalker.com If I understand you correctly you are saying that if there was a broken dependency then the plugin would not load. If so, I can rule that out because the plugin is loading. On the clients machine I have put a very simple uncompiled database with two methods to test what happens. I have copied it and lauched it separately with v13 and v15. The converted (new style) plugin is installed in both. In both the plugin shows OK in the method after re-parsing it (several times). On the v13 copy the method runs and calls the plugin commands OK. On the v15 copy the 4D just crashes. what if you place the DLL right next to the 4DX? I had tried this, although it made no sense doing it as the original path was set to the DLL in the original DLLWizard project. Struggling… 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: Using ListBoxes as Output forms
I would agree with what Nigel said: “I would certainly recommend using Table based for the internal forms and only switching to array based only for the external data. The display of data in field based is easier to deal with.” We have been using list boxes in this way for a long time now for output listings. It has helped keep costs down as in the past we used ALP as there was nothing that could natively do the job. I do not miss anything from ALP but I know that it probably has some advantages for some people. 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: v15 DLL Plugin Issue
Randy, Re: Is it a path issue with how Windows is seamlessly running things out of the C:/ProgramData folder when your application is in C:/Program Files? No I do not thank it is anything like that. I thought it might be a 64bit vs 32bit issue because the server was moved from v13 to v15 64bit but when I try the code on standalone v15 which is 32 bit the code crashes when it makes the call to the plugin method which works fine with v13. Is there such a thing as a direct replacement for DLLWizard? 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/09/2016, 18:39, "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: Re: v15 DLL Plugin Issue ** 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 **
v15 DLL Plugin Issue
I have an issue which is quickly becoming a major issue with a Plugin that was working and is now no longer working since upgrading to v15. The plugin wqs originally written with DLLWizard as a WIN4DX header to a DLL. It calls an address lookup solution by passing a postcode. It was then converted to the new Plugin architecture via plugin wizard (although I am unsure of the settings that were used). This has worked for the past few years with v13 and appeared to work with v15 but since deploying it in on one of the few clients who use this PAF solution we have found that it no longer works with v15. The plugin shows and the code compiles but at runtime it does not work. As far as I can tell the internal path to the DLL is not resolving or there is an issue with how the plugin is I may need help more than just advice with this as each day that goes by means a client is unable to use the functionality. Any ideas are welcomed. Ideally what I need is a way of directly creating a new style plugin from the DLL like the old DLL Wizard process which is sadly missed. 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 **