Re: iNUG Messages ― Is it time for it to be more than just 'plain text' ???
Yes! Finally! I'll be using the new one from now on. However! Let's leave this one alone at least for searching old posts. Looking forward to seeing you all on the new forum. - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) New Forum: https://discuss.4D.com 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 Upload file size too low
This is something that will be needed for an upcoming project. I'm thinking more and more to outsource this part to leave me concentrating on the rest. Let me know if you would be interested in doing this. It does not look like a huge job but there are other specs I'd need to be implemented. Please contact me directly at j...@infobase.biz to let me know if you are interested. Thanks - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: HTTP Upload file size too low
Ok that's a start if using WEB GET BODY PART will get the "chunks" and I can then reconstruct the file (I am assuming that is how it works). I'll b echeking for libraries that will allow me to implemnt chuncked uploads. Thanks for your acknowledgement that you have had success doing this. 4D Tech mailing list wrote > I'm not sure if I understand your environment in which you would do that > file upload. As I mentioned before, I did some little testing with chunked > uploads using a web browser as a client and there a javascript library. At > the server side I use WEB GET BODY PART in conjunction with WEB Get body > part count. I was able to upload file up to 4 GB. > > It looks really simple: > > For ($index;1;WEB Get body part count) > > WEB GET BODY PART($index;$MimeBody;$name;$mimeType;$filename) > > // do something with the chunk received in $MimeBody > > End for > > If you use another client than a web browser you have to mimic the > appropriate request. Using 4D as a client shouldn't be a problem. Simply > use HTTP Request and build appropriate headers and body. > > Regards > Lutz > > > > > ** > 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-Unsubscribe@.4D > ** - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: HTTP Upload file size too low
Thanks for link John. I'll give it a look. I knew it needed more than HTML on the browser's side just wasn't sure if 4D was then able to receive the chunks. Cheers 4D Tech mailing list wrote > This is what I was trying to get at a few messages ago. Maybe WEB GET BODY > PART does support chunked encoding, but that is irrelevant if the client > side does not support it. As best I can tell from Jim's description is he > is using a standard HTML multipart form with a file input. Javascript is > not involved, so having this work depends on the browser's support for > switching to chunked encoding. I don't know if web browsers directly > support it or if there is some magic you can add to the form to request > it. If not, there seem to be plenty of Javascript libraries that can do > it. So then the task becomes redoing the form with the Javascript library > instead of relying on the standard HTML form implementation. > > I found this Javascript example, which looks simple to implement. > > https://gist.github.com/shiawuen/1534477 > > > John DeSoi, Ph.D. > > >> On Jan 9, 2020, at 3:38 AM, Epperlein, Lutz (agendo) via 4D_Tech < > 4d_tech@.4d >> wrote: >> >> I'm not sure if I understand your environment in which you would do that >> file upload. As I mentioned before, I did some little testing with >> chunked uploads using a web browser as a client and there a javascript >> library. At the server side I use WEB GET BODY PART in conjunction with >> WEB Get body part count. I was able to upload file up to 4 GB. >> >> It looks really simple: >> >> For ($index;1;WEB Get body part count) >> >> WEB GET BODY PART($index;$MimeBody;$name;$mimeType;$filename) >> >> // do something with the chunk received in $MimeBody >> >> End for >> >> If you use another client than a web browser you have to mimic the >> appropriate request. Using 4D as a client shouldn't be a problem. Simply >> use HTTP Request and build appropriate headers and body. > > ** > 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-Unsubscribe@.4D > ** - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: HTTP Upload file size too low
I wish. However as someone else pointed out some IT departments will not allow FTP. The people who would be using this are not predetermined so I have no way of knowing or vetting FTP. Cheers Just curious could you not code something so that it uses FTP? Regards Chuck Chuck Miller Voice: (617) 739-0306 Informed Solutions, Inc. Fax: (617) 232-1064 mailto:cjmillerinformed-solutions.com Brookline, MA 02446 USA Registered 4D Developer Providers of 4D and Sybase connectivity http://www.informed-solutions.com This message and any attached documents contain information which may be confidential, subject to privilege or exempt from disclosure under applicable law. These materials are intended only for the use of the intended recipient. If you are not the intended recipient of this transmission, you are hereby notified that any distribution, disclosure, printing, copying, storage, modification or the taking of any action in reliance upon this transmission is strictly prohibited. Delivery of this message to any person other than the intended recipient shall not compromise or waive such confidentiality, privilege or exemption from disclosure as to this communication. ** 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-Unsubscribe@.4D ** - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: HTTP Upload file size too low
Thanks John. At least that gives me an idea of what I have to do. I'll see if I can pursue that avenue. Not sure but I think David Adam's book had an example of receiving in chunks. Damn I think I got ri of the book a few years ago. I'm still curious as to why 4D chose to give us 2GB limit but not the ability to do it regardless of fragmented RAM. Cheers 4D Tech mailing list wrote >> On Jan 8, 2020, at 4:15 PM, Jim Labos - infobase via 4D_Tech < > 4d_tech@.4d >> wrote: >> >> No I am using just plain File object to send file. On the 4D side I use >> WEB >> Get body part count and WEB GET BODY PART. No chunking that I know of >> unless >> 4D is doing itself (which by the way I don't know why they didn't >> implement >> that themselves since they give us a 2GB limit). > > The client and the server have to agree on sending with the chunked > protocol. This is obviously not supported by WEB GET BODY PART. That means > you would have to code the transfer yourself using WEB GET HTTP BODY > (using chunked encoding) and then you will have to parse the multi-part > form yourself because you can't use WEB GET BODY PART. > > I did something like this aeons ago using ITK before 4D's web server was > implemented. Even if I could find the code, I don't think it would be much > help. > > John DeSoi, Ph.D. > > > ** > 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-Unsubscribe@.4D > ** - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: HTTP Upload file size too low
No I am using just plain File object to send file. On the 4D side I use WEB Get body part count and WEB GET BODY PART. No chunking that I know of unless 4D is doing itself (which by the way I don't know why they didn't implement that themselves since they give us a 2GB limit). That was my question before: Anyone have access to code samples/examples on how to do it with chunks. - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: HTTP Upload file size too low
Good to know that but from what I've read I'm not the only one having this issue with inconsistent size uploads. I also get the same error others are getting. I'm using the basic way to obtain the file in a Blob in 4D by using WEB Get body part count and WEB GET BODY PART to get the Blob. I get the Document name consistently but the Blob will be empty in some cases. Are you using the same methods to obtain the file or receiving in chunks? Thanks - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: HTTP Upload file size too low
This is a known issue due to fragmented memory as 4D will only use contiguous memory for uploads. I do check with WEB GET OPTION(Web Maximum requests size;$i_SET_SIZE) and $i_SET_SIZE is at the max setting of 2GB. I'd be content with the 2GB limit. I can sometimes upload 500MB, others not even 300MB. Next day 1GB is good then try again and it fails. The name of the file comes in when calling "WEB GET BODY PART($i;blb_FILE;object_name;txt_mime;fileName)" but the BLOB will be empty. The only way to upload consistently without getting any errors supposedly is to do it in chunks. I am trying to find a way to do that. So far I could not find any code examples. Is anyone uploading files as large as 2GB to 4D? - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: HTTP Upload file size too low
I'm back after holidays and also testing other solutions. I keep getting the "413 - Request Entity Too Large" error. The On Web Authentication" method never get's triggered. The conclusion is that I need to find a way to upload from browser and receive in 4D pieces or chunks of the file and then concatenate the bits into what should add up to the original file. I couldn't figure out how to chunk the file with the Google solution suggested above. I've tried to find 4D code samples and/or examples on how to upload files regardless of size but have been unable to do so. Anyone have a link or some sample code/examples they can point me to? Thanks. ----- Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: HTTP Upload file size too low
You are correct with the FTP, I didn't think of that but now that you mention it yes I would probably have to deal with IT and in our case the users are in many locations in the U.S.. I'm looking into restricting the upload size as one solutions (the huge sizes were for testing and not necessarily real world in our case). I will also look at using chunks as a last resort. Thanks for the confirmation and caveat on the FTP. - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: AW: HTTP Upload file size too low
Ok thanks for the link Jim. Essentially what 4D is saying (and it makes sense) is that the BLOB will need a contiguous block of memory and so if memory is fragmented and no block large enough exists 4D rejects the entire upload. That may be why I was getting inconsistent limits on different days. To break it up in chunks is not a solution I am looking for. I will be looking into FTP. My users will be needing to click on a button on a form to upload documents. I have other problems of which one is that there has to be a button for each specific document uploaded as it has to go into a specific folder. Naming the button gives me that ability. There the problem is that thye could select many documents before uploading any of them and then any "submit" button would Post the form and there comes all these documents at once (so now that memory issue is increased even more). I am looking into the selection and upload being one operation and not 2. Which would force the upload everytime instead of waiting for a Post event. Got some research to do. Cheers - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: AW: HTTP Upload file size too low
I seem to remember in the past there was a way to get the entire body and one would have to parse the contents in order to delineate the part that was the uploaded file. Also if you do a WEB GET VARIABLES you will get an out of memory error if the file is too large (413 - Request Entity Too Large) and the 2 arrays are empty. I just tried it with 637,939,648 bytes (637.9MB) and that is error I get on browser just before On Web Authentication is triggered. The problem is that I would not know beforehand what size of document the user will be uploading. That is why I am testing to see what the limits are. I was prepared for the default 2GB limit but I am encountering this wall at around 600MB. Last week I did a few tests and I think (I wasn't paying attention as I was just starting to dabble in the code.) I was able to do around 1.3GB. But like I said I can't be sure as I was just picking documents randomly as I tested the code. I am glad to see I am not the only one getting this result. If anyone has an explanation or solution I would certainly like to hear about it. Thanks - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
HTTP Upload file size too low
Settings for Web Option is at the max limit. However the largest file size I can receive is around 600mb. The limit should be aprox. 2gb. Same limit on v13 or v15. "WEB GET BODY PART" will receive zero bytes when file is over aprox. 600mb. I have not done this kind of coding in years but I recall testing uploads in the gb range with no problem. Any clues? Thanks. - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: How to Modify a column using SQL
Thanks for the info John. I'm not planning on going to v18 until it is mature. I'm a little superstitious for even numbered versions! Cheers - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: How to Modify a column using SQL
Hi Chuck, No I meant the field definition as in the original post. I cannot alter the field type etc.. That part of SQL does not work in 4D but I was wondering if that had changed for v17 or even will for v18. From the looks of things it doesn't look like it has or will. Cheers Jim - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: How to Modify a column using SQL
Does anyone know if this has changed since 2013? I couldn't find anything but I could be missing something. Thanks - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Importing into 4D View
This particular requirement is still in V13 at the moment. There are Tab Delimited Text documents that need to be imported partly into vars and partly into a Table. Since these documents are from various sources they can contain varying numbers of columns or rows (ie: One document may have 16 columns and 32000 rows another 10 rows and 23 rows. We never know what we get as Forrest Gump says) 4D View seems ideal for this case. Or 'am I not seeing a better way? Anyone have a better idea? The other ways I saw required declaring arrays etc. Not always practical. 4D View will display and give access to the values without requiring declaring anything. Thanks for any thoughts. Jim Labos - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: MySQL connection from 4D
My suggestion is to try the demo of Pluggers myConnect plugin to try and connect. It will at least help you find the correct syntax or protocol to connect. We have been using it for years with no problem. It's one of those plugins that is worth every penny. For the price it may be worth buying and stop puling your hairs out. Also Rob is very helpful when needed. Whenever we had a problem it was always our syntax etc. Worth giving it a try if only to verify if something else isn't the problem. Jim - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: _ as first character in Method Name [was 64 bit...]
I haven't started to look at v17. Are we still limited to 32 characters for Method and Variable names? - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Sending Text Messages From 4D
Got it! Thanks Randy and the rest of you. It would have taken me a lot longer. The PostMan app really helped and yes the header MUST be included in order for it to work. Once I saw how a good request was formatted I was able to pinpoint my 4D code that was not doing the job 100%. All good now. Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Sending Text Messages From 4D
Hi Randy, I just tried PostMan! Fantastic tool! A million thanks for suggesting that. However I am still getting the same 400 error. It's great to be able to see the complete request sent to Twilio. The formatting looks good. This is teh problem I was having on my own and that is why I asked for help. I'll put in a request for some support from Twilio to see what's going on. Jim - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Sending Text Messages From 4D
Here are what the HTTP_REQUEST parameters look like. $lHTTPStatus:=HTTP Request(HTTP POST Method;$tURI;$tRequest;tResponse) $tURI="https://api.twilio.com/2010-04-01/Accounts/account SID goes here/Messages.json" $tRequest="FROM=%2B15551234537=%2B15551212=Test%20SMS" tResponse= "{"code": 21602, "message": "Message body is required.", "more_info": "https://www.twilio.com/docs/errors/21602;, "status": 400}" So it looks like loging in goes well but the formatting of "$tRequest" doesn't jive with Trilio. Anyone see what it could be? I'm new to direct HTTP requests like this. Thanks Jim - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Sending Text Messages From 4D
Thanks Koen, but with the headers I get a 404. Not sure but I believe the headers are optional. My guess is that the "$tRequest" var is not formatted correctly. I'm going to ask Twilio if they can help here. Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Sending Text Messages From 4D
Thanks for the code example, much appreciated. I keep getting a 400 HTTP error however. I am not using "HTTP_Request_Build" as I don't have it but I assume the "*" is an option to omit or include some characters for formatting. Here is what I am using from your code less proper username (assume it is the Account SID), password (assume it is the Authorization token) and phone numbers. Note I left out some parameters in the "HTTP Request" method as I am using v13.6 on this version and there is no timeout parameter. It may be that the "tRequest" var is not being formatted properly? I'll be trying in v15 next to see if I get better results. // Twilio_Send // // $1 - TEXT - SendTo phone number // $2 - TEXT - Message to send C_TEXT($1;$tSendToNumber) C_TEXT($2;$tMessage) $tSendToNumber:="5145551212" //$1 $tMessage:="Test SMS" //$2 C_TEXT($tURI;$tUserName;$tPassword;$tPlugin;$tInfo;$tFromNumber;$tRequest;$tResponse;tResponse) C_LONGINT($lJson;$lHTTPStatus;$lTimeout;$lPort) // Stuff unique to your Twilio account $tUserName:="Account SID" $tPassword:="AUTH Token" //"Your Twilio password" $tFromNumber:="5552221212" //"Your Twilio mobile account number" $tURI:="https://api.twilio.com/2010-04-01/Accounts/"+$tUserName+"/Messages.json; $tFromNumber:="+1"+$tFromNumber $tSendToNumber:="+1"+$tSendToNumber $tRequest:="" $tRequest:="FROM="+$tFromNumber //String_FixURL ($tFromNumber) $tRequest:=$tRequest+"="+$tSendToNumber //String_FixURL ($tSendToNumber) $tRequest:=$tRequest+"="+String_FixURL ($tMessage) ARRAY TEXT($atHeaderNames;0) ARRAY TEXT($atHeaderValues;0) APPEND TO ARRAY($atHeaderNames;"content-type") APPEND TO ARRAY($atHeaderValues;"application/x-www-form-urlencoded") HTTP AUTHENTICATE($tUserName;$tPassword;HTTP Basic) $lTimeout:=10 $lHTTPStatus:=HTTP Request(HTTP POST Method;$tURI;$tRequest;tResponse) - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Sending Text Messages From 4D
Hi Tim (or anyone else that could help), I am looking for a quick and simple SMS solution and came upon your (Tim's) message that you possibly had gotten some HTTP code snippets to send SMS via 4D using Twilio. I tried and was unsuccessful probably because of syntax so I gave up and moved on. I am trying Clickatell soon. If you have a working example for Twilio I would much appreciate looking at it. Thanks in advance. Cheers Jim - infobase _ Sent from http://4d.1045681.n5.nabble.com - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Video viewer on Webarea on Windows 7
Hi Kirk, Yes sorry, on this particular application it is still v13.6. Windows 7. I've solved the problem of IE when I upgraded it to version 11. So now video plays on IE and Chrome browsers on Windows 7. However I still cannot get it to work on the Webarea on windows (it works fine on OSX). I have enabled javascript via WA prefs. Still no go. I've turned on and off the "use Webkit" option and same problem. So right now I get it to work on Mac, Windows 7 IE v11 and Chrome but not 4D. I cannot set drag and drop on the area (4D v15 has option in prefs but I can't find a way to do it in v13.6). I tried another player ( Video.js) with same results. I have not tried Youtube's player on windows but it's not an elegant option for thsi purpose. I agree with you that using a browser to display the video is a solution and I do have it as a last resort. I would ask anyone that has successfully displayed/streamed a video (ideally mp4) on 4D Windows v13.6 to let me know. So right now logic dictates that either one cannot stream a video on v13.6 Webarea or I am doing something silly. For now I am assuming that it's my ignorance and not the Webarea. Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Video viewer on Webarea on Windows 7
Hi, (I don't see a name sorry). I am using URL's and they work on Win7 on Chrome but not Explorer. So certain it's not a URL problem. It may be the Webkit use so I'll check that. I've disabled drag and drop so I'll try that as well. Thanks for the tips. Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Video viewer on Webarea on Windows 7
I am just testing a way to display short intructional videos in a 4D Webarea via simple HTML. On Mac it looks something like this: Video type="video/mp4" width="980" autoplay="True"> ERROR: Cannot locate Help file. So the above is working fine on Mac but on windows I get the "ERROR: Cannot locate Help file.". Is this error caused by Windows 7 not supporting HTML5? (I think the HTML above is HTML5 code but not sure as I just basically found some code and adapted it to my needs). Is anyone displaying video (mp4) on 4D Webarea on Windows 7? Thanks Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: SEND PACKET in a multi-process environment
I have an aversion from long ago for semaphores so this may not be the best advise but what I'd do in these situations is create a "queu" list either in memory or records and let the file writing be done by only one process. The queu list could contain all the info necessary to pass to the process via parameters. Most of the times when I encountered -43 was due to the Finder lagging behind the 4D call. Never had to try on Windows so not sure how it would behave there but that could be something to look for. If you trace the processes and step through the code with debugger do you still get -43? Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: UUID query ignores characters 33 to n.... didn't know that!
Yes thanks, that is what I became aware of at that point. Previously UUID's nature was not particularly interesting to me and so I thought of it as Alpha numeric string. For comparison's sake a text will work but not as I previously falsely assumed. This old dog can still learn! Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
UUID query ignores characters 33 to n.... didn't know that!
Mac OS Yosemite, 4D v15.6 If I am querying a UUID field, I use a UUID var of course. However there is no UUID variable type so like everyone I use a text var. What I never noticed before as I didn't need to check, is that *if* the var itself contains the UUID in the first 32 characters but has extra characters after it then 4D still finds a match! So let's say the value in the UUID field's value is 607BFEA7CE2244EB9B00C2330E4E32F5 if my var $txt_UUID:="607BFEA7CE2244EB9B00C2330E4E32F5"+"xxx" Query([table1];[table1]UUID_FIELD=$txt_UUID) will still find the record. So in this case 607BFEA7CE2244EB9B00C2330E4E32F5"=607BFEA7CE2244EB9B00C2330E4E32F5xxx" I don't think this is a bug as 4D is using a special format for the UUID. However I falsely assumed that you needed an exact match for that type of query but it seems not. What do you all think? Is this a bug? An annoying gotcha? Did you already all know this and I am the only one who didn't? Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
RE: UUID version 4 needed
This brings up the question of shouldn't 4D confirm what method they are using? The random (version 4) does rely on the host computer's system to generate the randomness I would assume so that becomes the weakness (according to the definitions). As far as I know most computers generate pseudo random and if so will increase chance of UUID's colliding no? Albeit the chances are still astronomical. However it would be an advantage to "know" what the limitations (of what we mostly use to generate unique keys) are. Cheers - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: How does one detect that Cookies are disabled?
Hi John, I just saw this and will check it out. I knew there are Javascripts to check for Cookies but was resisting going that route. I will give it a try. Thanks to you and Danny Beaubien. Cheers - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: How does one detect that Cookies are disabled?
Thanks to all that replied. I learned a lot here. It forced me to understand the process and sequence of events that goes into creating, reading and deleting Cookies. Cheers - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: How does one detect that Cookies are disabled?
Thanks John. This was my finding as well although I was not using Xojo (if Xojo code is running from within the HTML form than if it programmed to send message to server you may be able to detect it). Essentially the browser does not see anything until 4D ends the code. I have not checked if it does work right after the WEB Send Blob or WEB Send File but before Web Process ends execution. Cheers - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: How does one detect that Cookies are disabled?
Thanks John. That was my thought too but I thought maybe someone had some other "magic" trick. It's clear now there is none in this case. It's cumbersome but it will need to be processed as you stated. Since it's not a single call I can be checking if the Cookie was created on first hit and proceed from there. Cheers - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: How does one detect that Cookies are disabled?
Yes but I am trying to detect if Cookies are "Disabled". If I can read the Cookie it exists and there is no problem. If I cannot read a Cookie then I will create it and that is where the problem lies as one cannot know if it was or not. At least not immediately. That is the predicament. Cheers - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: How does one detect that Cookies are disabled?
I am creating the cookie and immediately after that checking if cookie exists. We handle our own session so no we do not use 4D Session method. So by session I mean the initial call on the server. Using v13 in this application. 1: User hits server with a URL. 2: Server analyzes URL and if it passes checks for presence of cookie. If Cookie does not exist we create it. So at this point if the Cookie gets created all is fine but if user's browser has Cookies disabled 4D does not get an error or any indication of that. If I try and read Cookie on same connection/session the Cookie can indeed exist but it will come back as blank value. If Cookie had previously existed then there is no need to check of course. We only want to check when we create the Cookie. I think that it's a question of the Browser not actually creating the Cookie until 4D ends the connection/method. If one traces the browser's actions one only sees the Cookie existing only after 4D sends the response but not before that. Upon the next connection there is no problem reading the Cookie. So I cannot assume that the Cookie was created because of not being able to read it on same connection, and I cannot assume it wasn't created due to Cookies being disabled. Thanks - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: How does one detect that Cookies are disabled?
Hi, Don't take this the wrong way but other then telling me what you do on your computer to the cache from browser I don't know what this has to do with the subject matter. I just want to be able to "detect" if cookies are enabled or not. It is not my business what the person connecting to the server why or what he does. I just need to know so I can re-act accordingly. The connection is not with a website but it is to surveys that are mandated by the organization they belong to. So it is in no way an attempt to intrude into their browser history if that is what you are implying. Being able to detect that cookies are disabled can allow us to alert them that they will not be able to participate. It then becomes their choice. Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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 **
How does one detect that Cookies are disabled?
This particular Web application sends out emails with embedded ID's in a URL that uniquely identifies a connection. We have been able to do this because our customers forward us their list of members etc. We have a new customer that must send out the emails themselves and therefore it is not possible to embed our usual URL. So now I am turning to "Cookies" and as I am new to the Cookie thing 4D has made it pretty simple to create and read them. However I would like to detect first if the browser connecting has Cookies enabled or not. 4D does not have a method for that. Therefore I create a Cookie (ie: "EXISTS" ) with a value (ie: "YES" ) and then immediately try and read back the Cookie. If I get back a blank the assumption is Cookies are disabled and I can deal with a response. However when trying to read a cookie that has just been created it always comes back blank. I think what is happening is that the session is not finished and therefore the Cookie is not actually created until the session is over. If I check the cookie's existence after session is over it does exist. So 'am I correct in assuming I cannot read a Cookie until web session is over? Thanks - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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 Server crashing with MyConnect
Are you checking on the mySQL server side to see what is going on there? Restart mySQL? If it was running that long without a hiccup it's probably not this but make sure all the connections are closed and none left hanging open. We had that problem a while back where we kept opening new connections and not closing them. A long shot but you asked for some ideas. Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: Setting color print option problem
Unfortunately they are on v13 still. Looks like its available only starting in v15. Looks like they will have to live by doing manually each time they change settings for a print job. Thanks. Jim Labos infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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 **
Setting color print option problem
A customer is using a Xerox printer where customer is charged on a per page printed basis. There are 2 tariffs, the cheaper one is the black and white. Since the customer mostly does not need the color options I set him up with a way to set his print settings at startup so tha he does not have to do it for every print job. The difference in cost is hundreds of dollars per month, easily over $1000 per year. So I can understand his concern. On v13 Mac you cannot use the color settings option for Set Print Option. It only works on Windows and they are a mac only shop. The only way to have a setting that is maintained is to use Print Settings to bring up the system Print Dialog and make settings in there. That seems to work most of the time. Not sure why yet, but the customer says the settings do not always maintain for the entire 4D session. Has anyone had a similar problem and found a more elegant solution? Thanks Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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
Thanks for taking the time to give us this detailed hint at what's coming. This is fantastic and exciting news! I hope the iOS feature will get developed to it's max. This has potential to open many areas for us developers. I have not found a need for the object oriented code yet, but then I'm an old man who does not easily kill habits (good or bad). However I do still find that necessity is the mother of necessity (yes I said it the way I intended) when it comes to using new or yet used 4D code. In other words I learn very fast if a feature is all of a sudden required for a customer. But I am excited and encouraged (and proud) to see that 4D is still pouring creativity and features into the platform. As developers we need to be constantly kept excited and challenged with new features to at least experiment with and find new uses for. Some of us have made a career using only 4D. In the beginning 4D was not exactly the most powerful and/or popular software around. Look at it now! Keep it coming. I'm curious if they have added anything more to the WEB modules? Not that you can't do a lot right now but it could be easier to implement certain scenarios. Looking forward to get my hands on a demo of v17. Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Best way to get HTML Tables to MS Word tables
Since I am only interested in generating tables in word I have no need for something elaborate enough to generate everything. So yes Dan what I did is I started to look at table sin Excel and copy pasting to Word. Finally I created a sample of the simplest table we need to generate and then saved as HTML from the Word document. That is best solution I could find for now. I am fooling around manipulating the HTML and so far it seems to be doing well. The objective is to use templates and tags then run Process 4D Tags and build the tables that way. I was able to accurately create tables, rows and columns no problem. I can manipulate certain formatting parameters etc. The only thing right now is that I assign a Table width as well as column widths and they are not conforming to that setting. For instance I have 4 columns, first is 300 and the next 3 are 75. However the 2nd to last seems to be 150. Too tired tonight to go on but it should not be impossible to get this to work. So in conclusion I think using snippets of Word's HTML is the way to go in my case. At least it would seem so up to now. Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Re: Best way to get HTML Tables to MS Word tables
Thanks Dani, I'll check that out. I have never used or needed to use PHP so I hope that I can find another solution. If it's the only game in town then I guess I'll have to dive in. I'm thinking XML, as I am more familiar with that and MS Word seems to support it, but again I would feel better if someone has done it successfully before. Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: https://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
Best way to get HTML Tables to MS Word tables
I've been doing some HTML tables that end up in Word for a while now but until now there was no need to get it to render any better so if it ain't broke. However now comes the need to have tables render as exact as possible in Word. Now I say /from/ HTML because I have been doing it that way in past but going direct to Word would be even better. The good thing in HTML is it is simple to develop and maintain as well as debug. The problem many things don't end up looking the same in MS Word. I know practically nothing about using MS XML language, are there any tools available for 4D that would let me construct Tables and populate the contents directly to MS Word format? Any thoughts? Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: Saving open windows in Design environment feature
I can't find my request now but certain I had put one on. Maybe because it is exactly same as ; <http://forums.4d.com/Post/FR/18085500/0/0/> In any case they do have the request in. I am assuming that it would not be a big deal to implement. If we can do it with a keystroke, doing it with code should be even simpler. Jim Labos - infobase ----- Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: Saving open windows in Design environment feature
Not unless something has changed since then. I put in a 4D feature Request in order to do this but have not checked if it was done. Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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 **
Statistical functions
Does anyone know of a plug-in or component that computes statistics: t-tests, analysis of variance, correlation coefficients, chi-square etc.? Thanks Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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 use phpdocx with 4D or using external interpreter?
Looking at phpdocx as they claim to be able to generate decent looking Word ( .docx ) from HTML. I am getting good results on Word but my partner is not getting the same at all. I am trying to avoid using XML to generate the Word file and so the idea of using HTML (which I am doing already in any case) would be the easiest (lazy bugger that I am). I have not used or had need to use PHP as of yet. I believe that the developers of phpdocx recommend using LibreOffice. My limited knowledge of PHP with 4D points to needing a custom interpreter as the 4D one will only run the 4D supplied PHP. Is that correct? Any clues would be helpful. Thanks. Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: METHOD OPEN PATH Equivalent For Forms
I asked the same question and got same answer a few months back. Maybe if we push enough they will add it in? Cheers Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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 Write Pro - WP EXPORT DOCUMENT to WORD?
Hi Lutz, Thanks I just added my vote for this feature. - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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 Write Pro - WP EXPORT DOCUMENT to WORD?
Thanks Pat, However I believe my colleague has tried this and the result was not pretty, so it is not a solution that would be acceptable to us at this moment. - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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 Write Pro - WP EXPORT DOCUMENT to WORD?
Why I wonder does the list often mix thread messages such as here? The thread was started by me with a subject about 4D Write Pro. However we find another totally different subject matter within it? This is not the first time I have seen this. Any clues as to why this happens? Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 4D Internet Users Group (4D iNUG) FAQ: http://lists.4d.com/faqnug.html Archive: http://lists.4d.com/archives.html Options: http://lists.4d.com/mailman/options/4d_tech Unsub: mailto:4d_tech-unsubscr...@lists.4d.com **
4D Write Pro - WP EXPORT DOCUMENT to WORD?
Trying out 4D Write Pro with v16 R4 beta for possible use in an upcoming project. It's the "Bookmark" feature that got me curious as without it we would not be able to fulfill our requirement. I will need to "construct" a 4D Write document from "Bookmarks". If this works well then we need to export or save the 4D Write document in Word. The current version of 4D Write can export as a Word file, however I do not see any option for doing it in 4D Write Pro. Anyone have any idea if this is coming soon or if the option exists, where I can find it? Thanks Jim Labos - infobase - Jim Labos - infobase -- Sent from: http://4d.1045681.n5.nabble.com/4D-Tech-f1376241.html ** 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: Re(4): 4D db -> SAAS
Unless I misunderstood the requirement, if it's a single user application and the Data is particular to each customer but not the schema/structure than why not use 4D Volume Desktop? Cheers Jim Labos - infobase - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/D3-js-Wow-Some-notes-on-SVG-D3-and-data-visualizations-tp5741826p5753601.html Sent from the 4D Tech mailing list archive at Nabble.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: Put a button in an email that won't open a web page
My bad I misunderstood your question. It seems what you want is for the user to be able to click on the button in the email and only sent an email and be taken to a webpage that first time. After that any click on button in the email would only send an email. Yes the URL will send the user to a browser by default. Then if you do not respond (you do not have to but the browser will timeout at some point) it would be disconcerting to the user. So yes best thing is to present an HTML page. I do not think there is a way to not have the browser timeout if webserver does not respond. So since the user is always sent to the browser you should respond appropriately with an HTML page. Emails can be sent irregardless of that. Cheers Jim Labos - infobase - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/Put-a-button-in-an-email-that-won-t-open-a-web-page-tp5753240p5753276.html Sent from the 4D Tech mailing list archive at Nabble.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: Put a button in an email that won't open a web page
Without knowing the details of what you are doing I can only say that the button will just act like any URL to a server. What you do with the URL and respond to it is entirely up to how the server responds. I regularly send out emails with buttons linked to a URL. I use 4D Webserver and trap the URL and depending on the encoding parts I run whatever code required. I need not respond with a Web page at all. In that case however the user may get confused if you have not alerted them previously (in the email) of what to expect when clicking on the button. If for instance the button text reads: "Click here to receive an email from us" with added instructions below or above the button stating that the email may take up to 24 hours to come (or whatever time interval you deem fit). Of course all this is dependent on you having control of what the Web server does. Cheers Jim Labos - infobase - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/Put-a-button-in-an-email-that-won-t-open-a-web-page-tp5753240p5753272.html Sent from the 4D Tech mailing list archive at Nabble.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: Saving open windows in Design environment feature
Hi Jeremy, What I mean by that is to open the form editing window in Design environment. For instance. If I have a form named "input" in the table named "Access" I can call the following: FORM GET NAMES([ACCESS];atxt_PATHS) now the array "atxt_PATHS" will contain a list of all the forms in that table. However there seems to be no commands that will open the forms via 4D code. There is no equivalent to the METHOD OPEN PATH command that opens the forms instead of code. I need to be able to open both code and forms. Cheers Jim - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/Saving-open-windows-in-Design-environment-feature-tp5752737p5752768.html Sent from the 4D Tech mailing list archive at Nabble.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: Saving open windows in Design environment feature
I am looking into Design Object Access to do what I need but I although there is a way to get the Form names there seems to be no way that I found to open up the forms themselves. All commands deal with Methods and all other code. Have not looked at the 4D POP yet as Douglas mentioned. Nevertheless it is fun discovering commands I had no need for up to now. Cheers Jim - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/Saving-open-windows-in-Design-environment-feature-tp5752737p5752765.html Sent from the 4D Tech mailing list archive at Nabble.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: Saving open windows in Design environment feature
Thanks for your replies Douglas and Jody. It looks like I'll have to look into rolling my own. I'll create a feature request as well. Thanks for the insights. Cheers Jim - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/Saving-open-windows-in-Design-environment-feature-tp5752737p5752764.html Sent from the 4D Tech mailing list archive at Nabble.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 **
Saving open windows in Design environment feature
Before I create a feature request I thought I'd ask here to see if I am missing something (sometimes yes, I am guilty of not reading the manuals fully!). I would love to see an implementation for naming and saving "sets" of windows in Design. It would be a way to organize sets of code and forms per module. So for instance if you are working on several modules at once it gets to be a pain (for me) to constantly have to go back and forth selecting methods etc. from menu. So a way to save all the current open windows and have access to it from a list in the design toolbar would be a great feature n my opinion. Opening one "set" would close all current windows that are not in the called set or we could have a way to "merge" and/or "append" to them as well. I know we can save methods etc. to "folders" but that is not as handy as the above proposition. So 'am I crazy or is this something we could all use? Thanks - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/Saving-open-windows-in-Design-environment-feature-tp5752737.html Sent from the 4D Tech mailing list archive at Nabble.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: Sending Emails Quicker?
Not sure about the authenticate but what I do is use multiple processes to send out. There is the added work to keep track of what has gone out and divide the selections for each process but it does enable one to send out faster. Note also that your outgoing email server may have a maximum of emails it allows per second. Also do not think that if you have 10 processes your emails will go out 10 times faster. I have not timed it but there seems to be a diminishing returns depending on the total number of emails to send. I generally have a maximum of 5,000 emails per process when there are more than 20,000. I keep the number of processes under 10 and generally only need 4 or 5. Cheers Jim Labos - infobase - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/Sending-Emails-Quicker-tp5752683p5752694.html Sent from the 4D Tech mailing list archive at Nabble.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 **
Setting "DEFAULT VALUE" with SQL
I have no problem setting a default value with mySQL but I am having trouble getting the correct syntax with 4D's SQL implementation. I am just in test and experiment phase of trying to see if I can replace mySQL with 4D (so far so good except for this little hiccup which I am certain is my ignorance). Normally this should work: ** SQL LOGIN(SQL_INTERNAL;"root";"") txt_TABLE_NAME:="Test__0353" txt_QUESTION_TYPE:=" INT" txt_QUESTION_NAME:="X0101" txtRequest:="Alter TABLE "+txt_TABLE_NAME+" add "+txt_QUESTION_NAME+""+txt_QUESTION_TYPE+" DEFAULT -99 ;" Begin SQL EXECUTE IMMEDIATE: txtRequest End SQL SQL LOGOUT ** I get syntax errors at this and other variations (I'm just guessing hoping I hit on correct syntax!) I checked and the DEFAULT reserved work exists in 4D's SQL (but maybe it is only valid in a Select?). Cheers and thanks Jim Labos - infobase - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/Setting-DEFAULT-VALUE-with-SQL-tp5751741.html Sent from the 4D Tech mailing list archive at Nabble.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: PROCESS 4D TAGS
Just tried exactly that (I used select document and the Document variable to get document). It worked with no problem. I tested on v16 OSX10.10.5 So it's either v14 problem or your settings. Cheers Jim Labos - infobase - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/PROCESS-4D-TAGS-tp5751717p5751731.html Sent from the 4D Tech mailing list archive at Nabble.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: styled/formatted text for email body contents
As Lutz wrote previously the way to do this the easiest is to use PROCESS 4D TAGS . You can use loops in an HTML template to create your item lines or anything that would be variable and then concatenate your form (Blobs or Text) into one variable containing the entire body. This will do exactly what you want (if I understood your needs). If you need more detail let me know. Regards Jim Labos - infobase - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/styled-formatted-text-for-email-body-contents-tp5749019p5749244.html Sent from the 4D Tech mailing list archive at Nabble.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: Problem saving blob to a record
Created a new DB and did this with no problem. Created a record and saved it. READ WRITE([Table_1]) ALL RECORDS([Table_1]) FIRST RECORD([Table_1]) // only one $TemplateFilePath_t:=Select document("";"";"Select a document:";0) If (OK=1) SET BLOB SIZE([Table_1]Field_1;0)// don't really need this but it doesn't hurt $TemplateFilePath_t:=document DOCUMENT TO BLOB($TemplateFilePath_t;[Table_1]Field_1)// the field now contains the 76Kb doc SAVE RECORD([Table_1])// you didn't show this but you have it I'm sure End if Calling the record again the field contains 76kb I suspect the record is not being saved. Do you have On Error running and it is maybe trapping the 4D error and you are not displaying it? Been there. Cheers Jim Labos - infobase - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/Problem-saving-blob-to-a-record-tp5748862p5748880.html Sent from the 4D Tech mailing list archive at Nabble.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: Questionary into the mail message
I would ask you if you have a Webserver license? Even if you don't you can use the server for 1 hour as trial. It is a lot easier and efficient as well as accurate to do what you are trying to do, although more expensive. However I would recommend using the Web features of 4D as it saves a lot of headaches and opens up more possibilities for your current and future development. You would create an HTML email "Form". You can embed into the HTML objects your 4D references. So for instance a "Name" field could be named "Name" or anything else that makes sense in your 4D database. You can also use 4D fields directly but I never use that method so I can't comment on it's use. You will need a "Submit" action button in the form to make this work. This submit button must point to the URL that the 4D Webserver is listening to. Look at how the Webserver works with 4D Tags and you will get an idea of how to do it. Sorry if you already knew this, but just in case Cheers Jim Labos - infobase - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/Questionary-into-the-mail-message-tp5748444p5748682.html Sent from the 4D Tech mailing list archive at Nabble.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
I agree! (couldn't help myself on a Friday afternoon). Cheers Jim Labos - infobase - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/Re-Apple-Agrees-with-4D-tp5748218p5748224.html Sent from the 4D Tech mailing list archive at Nabble.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 on Sierra?
Thanks to all that replied. I will recommend to not use Sierra. Jim Labos - infobase - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/v13-on-Sierra-tp5747493p5747498.html Sent from the 4D Tech mailing list archive at Nabble.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 **
v13 on Sierra?
I have a customer that is asking if v13 will work on Sierra. I admit I didn't look too hard yet but anyone know if it's at least OK (I have v13 on El Capitan and the only problem is in desgn mode it will quit on me randomly but seldom). Thanks Jim Labos - infobase - Jim Labos - infobase -- View this message in context: http://4d.1045681.n5.nabble.com/v13-on-Sierra-tp5747493.html Sent from the 4D Tech mailing list archive at Nabble.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 **