Show Posts
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
1
Web Server - Ask For Help / xFiles - Exporting Queues to xml that can be opend by spreadsheet
« on: February 07, 2022, 04:59:32 PM »
Hi, Bruce
For several years I have been using a couple of custom procedures to view the contents of queues and memory tables in a spreadsheet. These were based on a Clarion Magazine article written by Carl Barnes (thanks, Carl). These work fine but I thought I could reduce complexity using xFiles instead. An xml file with the data is successfully generated, but Excel and LibreCalc choke on it because of "Reference to undeclared namspace prefix.." then the queue or mem table prefix.
I couldn't find a reference either to the task or the problem in the documentation or discussion about xFiles, so how is this done. If it is more than a setting or parameter or two, I would be happy to ask at the next User Group.
Thanks.
For several years I have been using a couple of custom procedures to view the contents of queues and memory tables in a spreadsheet. These were based on a Clarion Magazine article written by Carl Barnes (thanks, Carl). These work fine but I thought I could reduce complexity using xFiles instead. An xml file with the data is successfully generated, but Excel and LibreCalc choke on it because of "Reference to undeclared namspace prefix.." then the queue or mem table prefix.
I couldn't find a reference either to the task or the problem in the documentation or discussion about xFiles, so how is this done. If it is more than a setting or parameter or two, I would be happy to ask at the next User Group.
Thanks.
2
Web Server - Ask For Help / Conditionally refer to another page.
« on: December 12, 2021, 12:30:03 PM »
Hi, all
I am a bit embarrassed to ask this because I am sure it is simple and documented even if I can't find it.
Users call a memory form from a menu;
the memory form is primed from intersession values;
if one of those values is set to TRUE the user should be referred to another page automatically;
if not the form is display to collect user input.
How do I do the automatic referral?
Thanks.
I am a bit embarrassed to ask this because I am sure it is simple and documented even if I can't find it.
Users call a memory form from a menu;
the memory form is primed from intersession values;
if one of those values is set to TRUE the user should be referred to another page automatically;
if not the form is display to collect user input.
How do I do the automatic referral?
Thanks.
3
Web Server - Ask For Help / Are browser specifi css s unnecessary, someplace else, or missing?
« on: November 28, 2021, 06:05:45 PM »
Hi, Bruce
I am deploying my first NT 12 app and Setup Builder complained about missing css's from:
Clarion11\accessory\libsrc\win\NetWeb\web\styles. In particular the browser specific css's.
I am deploying my first NT 12 app and Setup Builder complained about missing css's from:
Clarion11\accessory\libsrc\win\NetWeb\web\styles. In particular the browser specific css's.
4
Web Server - Ask For Help / Intermittent error using Twilio SMS example
« on: November 18, 2021, 05:54:00 PM »
Hi, Bruce
I am adding SMS notifications to a solution starting with Twilio. Got the example working fine. Put it in my solution where it also worked. Until it didn't. At that time, the example also failed with the same message. A day later the both started working again. And now, they are both out again with this error message:
"NET ERROR: The Remote TLS Certificate's Common Name () does not match the Server name (localhost). And so the connection failed to open"
All the message and connection parameters are hard coded for testing to avoid typos, so it isn't input changes. Twilio's servers responded to direct URL requests and I can't imagine their servers being down that much.
Any suggestions?
On a related matter. Is sms.capesoft.com fully functional now? Can end clients subscribe instead of NT developers? I really don't want to get involved with small monthly billings.
Thanks a lot.
I am adding SMS notifications to a solution starting with Twilio. Got the example working fine. Put it in my solution where it also worked. Until it didn't. At that time, the example also failed with the same message. A day later the both started working again. And now, they are both out again with this error message:
"NET ERROR: The Remote TLS Certificate's Common Name () does not match the Server name (localhost). And so the connection failed to open"
All the message and connection parameters are hard coded for testing to avoid typos, so it isn't input changes. Twilio's servers responded to direct URL requests and I can't imagine their servers being down that much.
Any suggestions?
On a related matter. Is sms.capesoft.com fully functional now? Can end clients subscribe instead of NT developers? I really don't want to get involved with small monthly billings.
Thanks a lot.
5
Web Server - Ask For Help / Creating multi dlls from a Web Server exe
« on: November 10, 2021, 05:41:18 PM »
Hi, Bruce
Several years ago I broke a Clarion Windows app into a parent exe with a data dll and another dll with most of the procedures. I did it largely for memory management since there would be several instances of the exe. I didn't see that as an issue for a WebServer app so just left everything in the exe. You sessions on Clarion Live have caused me to revisit that choice, but while I am comfortable with the mechanics of multi-dll I am less certain about what should go where. I have a lot of my own and third party classes and procedures, etc. I thought we might discuss it at the next user group. Thanks.
Several years ago I broke a Clarion Windows app into a parent exe with a data dll and another dll with most of the procedures. I did it largely for memory management since there would be several instances of the exe. I didn't see that as an issue for a WebServer app so just left everything in the exe. You sessions on Clarion Live have caused me to revisit that choice, but while I am comfortable with the mechanics of multi-dll I am less certain about what should go where. I have a lot of my own and third party classes and procedures, etc. I thought we might discuss it at the next user group. Thanks.
6
Web Server - Ask For Help / Task Panel tabs - opening and closing on conditions, adding CSS to tab header
« on: October 06, 2021, 03:12:54 PM »
Hi, Bruce (et al)
I have been looking forward to the Task Panel form tabs in NT12. Now that they are here, I am missing how to do certain things with them:
1) For new records, open a default tab on opening the form, leaving the others closed.
2) For the other tabs, set the color of the tab header to indicate any non-default values in the fields of the tab.
I was not able to get background color css for the Tab Header to work even though the css did work when applied to the tab itself. This was true for the tabs(57) example app as well.
If this has been covered somewhere I wasn't able to find it, so a pointer would be great. If not, I thought I would ask at tomorrow's user group.
Thanks.
I have been looking forward to the Task Panel form tabs in NT12. Now that they are here, I am missing how to do certain things with them:
1) For new records, open a default tab on opening the form, leaving the others closed.
2) For the other tabs, set the color of the tab header to indicate any non-default values in the fields of the tab.
I was not able to get background color css for the Tab Header to work even though the css did work when applied to the tab itself. This was true for the tabs(57) example app as well.
If this has been covered somewhere I wasn't able to find it, so a pointer would be great. If not, I thought I would ask at tomorrow's user group.
Thanks.
7
Web Server - Ask For Help / _SessionQueue not found update from NT 11 to 12
« on: October 04, 2021, 02:16:52 PM »
Hi, Bruce
I am updating to NT 12 and I am finding that a method I added to NetWebServer class many NT versions ago now generates a 'not found' compiler error. The method loops through the records of a memory table and deletes any that do not have an active SessionID. The method is called after the parent of the GarbageCollector method is called. The exact code with the problem:
SELF._SessionQueue.SessionID = MemSessionID
GET(SELF._SessionQueue,SELF._SessionQueue.SessionID)
What is the location/label of the sessionqueue used by the web server? Is there a better way to get conform a sessionId is active?
Thanks
I am updating to NT 12 and I am finding that a method I added to NetWebServer class many NT versions ago now generates a 'not found' compiler error. The method loops through the records of a memory table and deletes any that do not have an active SessionID. The method is called after the parent of the GarbageCollector method is called. The exact code with the problem:
SELF._SessionQueue.SessionID = MemSessionID
GET(SELF._SessionQueue,SELF._SessionQueue.SessionID)
What is the location/label of the sessionqueue used by the web server? Is there a better way to get conform a sessionId is active?
Thanks
8
Web Server - Ask For Help / Let's Encrypt - Challenge token was not created
« on: April 27, 2021, 05:41:04 PM »
Hi, Bruce
My perennial problem getting certificates renewed at Let's Encrypt has returned and, unfortunately it is affecting my clients' installations as well as my test site. I have attached both the Debug view output and the activity log. I removed what looked like an encrypted certificate of some sort from the Debug out put. Any assistance you can give me on this would be greatly appreciated.
Thanks.
My perennial problem getting certificates renewed at Let's Encrypt has returned and, unfortunately it is affecting my clients' installations as well as my test site. I have attached both the Debug view output and the activity log. I removed what looked like an encrypted certificate of some sort from the Debug out put. Any assistance you can give me on this would be greatly appreciated.
Thanks.
9
Web Server - Ask For Help / NT 11.48 problem renewing Lets Encrypt certificate
« on: December 04, 2020, 12:58:23 PM »
Hi, Bruce
I was glad to get your notice about Lets Encrypt and NT11.48 because I was encountering problems renewing a certificate. Unfortunately, after updating NT the problem remains. I have attached the DebugView output for the attempt with one edit. At line 30 there was very long string starting '{"protected": ' which had what looked like an encryption and its key. Without knowing what it was I didn't think it would be wise to post it to a public forum. If you need the contents of that string, happy to post or email them.
Thanks a lot.
BTW, is there any hope that LE will go to longer certificate periods?
I was glad to get your notice about Lets Encrypt and NT11.48 because I was encountering problems renewing a certificate. Unfortunately, after updating NT the problem remains. I have attached the DebugView output for the attempt with one edit. At line 30 there was very long string starting '{"protected": ' which had what looked like an encryption and its key. Without knowing what it was I didn't think it would be wise to post it to a public forum. If you need the contents of that string, happy to post or email them.
Thanks a lot.
BTW, is there any hope that LE will go to longer certificate periods?
10
Web Server - Ask For Help / Conditional Last on Line
« on: September 10, 2020, 03:06:44 PM »
Hi,
I have a situation where one field is usually the last on line, but occasionally there should be a second field shown after it. This isn't a CSS situation; it is a program setting that determines whether the second field appears on the page. I can get by putting each on their own line, but it would be intuitively clearer and aesthetically less awkward if they were on the same line.
Thanks.
I have a situation where one field is usually the last on line, but occasionally there should be a second field shown after it. This isn't a CSS situation; it is a program setting that determines whether the second field appears on the page. I can get by putting each on their own line, but it would be intuitively clearer and aesthetically less awkward if they were on the same line.
Thanks.
11
Web Server - Ask For Help / Input multiple items using bar code scanner
« on: July 20, 2020, 10:18:07 AM »
Hi, Bruce
I thought I would ask about this at the next User Group. I am trying to add multiple child records to a parent form using the bar code scanner. Similar to the order form / items list examples we are familiar with. I am trying to do it so that when the bar code is successfully scanned the input form is cleared and ready for the next item without the user having to click an 'Add' button on the browse list control.
If I have missed an example that does this or some documentation, my apologies. Just point me in the right direction. Thanks.
I thought I would ask about this at the next User Group. I am trying to add multiple child records to a parent form using the bar code scanner. Similar to the order form / items list examples we are familiar with. I am trying to do it so that when the bar code is successfully scanned the input form is cleared and ready for the next item without the user having to click an 'Add' button on the browse list control.
If I have missed an example that does this or some documentation, my apologies. Just point me in the right direction. Thanks.
12
Web Server - Ask For Help / NetTalk User Group - can't connect
« on: June 11, 2020, 08:52:58 AM »
Just in case there are others who have the same problem, I thought I would ask here.
For the last two weeks, when I try to register for NT User Group I just got dumped to the Capesoft home page. Looked a little closer and found that Registration page had the current/next session was Feb 6 2021.
Same problem for both Firefox and Chrome, so I don't think it is a cache issue.
Any thoughts? Thanks.
For the last two weeks, when I try to register for NT User Group I just got dumped to the Capesoft home page. Looked a little closer and found that Registration page had the current/next session was Feb 6 2021.
Same problem for both Firefox and Chrome, so I don't think it is a cache issue.
Any thoughts? Thanks.
13
Web Server - Ask For Help / SessionValue truncated
« on: May 13, 2020, 09:27:19 PM »
Same situation as my last question: parent form with a pop up child form with three text fields. Putting the three text fields in a txt file for downloading. On the pop up form I put text of a field in a session value which is then processed into the txt file in a source procedure on pressing the Start button. In the source procedure the session value is truncated quite dramatically. I TRACED the session value before and after calling the source procedure. Before calling the session value was fine, but once in the source procedure the session value is truncated. Two other fields don't have the problem, probably because they are quite short already.
Thanks
Thanks
14
Web Server - Ask For Help / Progress - txt file download - for browser to save instead of open
« on: May 13, 2020, 09:14:34 PM »
Hi, Bruce
Here is one of two questions I thought I would ask about at tomorrow's user group meeting. I have a parent form that calls a pop up form that has three read only text fields. I want to put all three fields into a simple txt file that the user can simply download to send to someone else. The Progress control works but the template for the Click to Download link doesn't have an entry for content type or disposition, so browsers just try to open file instead of save it. Thanks
Here is one of two questions I thought I would ask about at tomorrow's user group meeting. I have a parent form that calls a pop up form that has three read only text fields. I want to put all three fields into a simple txt file that the user can simply download to send to someone else. The Progress control works but the template for the Click to Download link doesn't have an entry for content type or disposition, so browsers just try to open file instead of save it. Thanks
15
Web Server - Ask For Help / No cypher overlap error after upgrading to 11.35
« on: May 05, 2020, 09:29:59 PM »
Hi, Bruce
I upgraded from NT 11.32 to 11.35 today, did a full regeneration and rebuild of my app. Seemed Ok but when I try to connect I get the dreaded "SSL_ERROR_NO_CYPHER_OVERLAP" error in Firefox and the equivalent in EDGE. Are there some files I should move somewhere? Thanks.
I upgraded from NT 11.32 to 11.35 today, did a full regeneration and rebuild of my app. Seemed Ok but when I try to connect I get the dreaded "SSL_ERROR_NO_CYPHER_OVERLAP" error in Firefox and the equivalent in EDGE. Are there some files I should move somewhere? Thanks.