Messages

1

Web Server - Ask For Help / Re: xFiles - Exporting Queues to xml that can be opend by spreadsheet

« on: February 08, 2022, 11:02:01 AM »

The code is dead simple

The prototype:
(Queue p:Q, <String p:Filename>, <String p:Format>) ,String ,Proc

Data section:

LocalXML  xFileXML


Code in question:
!------------------------------------------------------------------
  IF ~Records(p:Q)
    RetVal = 'Queue is empty. No export file produced.'
    DO ReturnRoutine
  END
  N_ExportQFile = choose(~p:Filename, 'ExportQ.xml', p:Filename)
  IF ~p:FileName                        ! prompt for a filename if not already provided
    if ~FileDialog('Export Queue to file ...', N_ExportQFile, 'XML files (*.xml)|*.xml', 10011b)
      RetVal = 'File Selection Cancelled'
      DO ReturnRoutine
     end
  END 
  LocalXML.start()
  LocalXML.Save(p:Q, N_ExportQFile)
  RetVal = 'Completed'
  DO ReturnRoutine

The output is attached as a txt.

Thanks, Bruce.

2

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.

3

Web Server - Ask For Help / Re: Conditionally refer to another page.

« on: December 13, 2021, 05:43:38 PM »

Thanks, Bruce

The menu item is a good idea that I hadn't considered.   

4

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.   

5

Web Server - Ask For Help / Re: Are browser specifi css s unnecessary, someplace else, or missing?

« on: November 28, 2021, 06:16:33 PM »

Sorry, posted by accident.

To continue, the browser specific css's are not in that folder now but were the last time I did a setup with NT 11.  Everything seems to work fine without them, but I would just like to confirm that these css's are unnecessary or are located somewhere else.  Or was my NT 12 installation incomplete or they were deleted somehow?

Thanks   

6

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.

7

Web Server - Ask For Help / Re: Intermittent error using Twilio SMS example

« on: November 24, 2021, 03:12:10 PM »

Thanks, Flint.

My intent is to let the end clients subscribe to SMS service (just Twilio at the moment)

8

Web Server - Ask For Help / Re: Intermittent error using Twilio SMS example

« on: November 20, 2021, 02:06:47 PM »

For those encountering a similar error, the fix is to put

net.SSLCertificateOptions.DontVerifyRemoteCertificateCommonName = TRUE

before the net.post.

Also, I replicated the same problem using the web client procedure in the demo.app example.

9

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.

10

Web Server - Ask For Help / Re: Creating multi dlls from a Web Server exe

« on: November 13, 2021, 03:58:12 PM »

Very useful. Thanks, Don.

Sorry, I didn't think of looking in the Clarion Live sessions; just the NT User Group and Net Talk Central.

11

Web Server - Ask For Help / Re: Creating multi dlls from a Web Server exe

« on: November 11, 2021, 04:50:08 PM »

Sorry. I forgot about the time change. I will be there next week.

12

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.

13

Web Server - Ask For Help / Re: _SessionQueue not found update from NT 11 to 12

« on: October 26, 2021, 03:12:58 PM »

I have several memory tables used for transactions during a session.  The my old session cleanup method and the new sessionmanager methods  finds all the  session table records that have the ending SessionID and delete them.  But if there is an error in the process some of these records become orphans.  Rare, but with thousands of sessions a day on servers running months at a time these might accumulate. A slow memory leak.

Before NT 12 I had another method that worked in the opposite direction as well.  Loop through each session memory table record, confirm that its SessionID is still in the SessionQueue, and if not delete it. Doesn't need to be done often; once a day or even one a week is more than enough. I just need a way to determine if the SessionID is in the SessionQueue.

Thanks.

14

Web Server - Ask For Help / Re: _SessionQueue not found update from NT 11 to 12

« on: October 22, 2021, 10:27:44 AM »

Hi,

I have replaced my session cleanup code with the new session manager template.  Great.

I am still concerned, though, that orphaned session memory table records will accumulate over time. If my installations were being restarted every day or even every week this wouldn't be an issue, but some of them run for months without a restart.  It was my orphan clean out methods that encountered the original 'not found' compiler error.

I looked through the new netwebsessions code, but couldn't get anything to work for me. So, how do I query whether a specific SessionID corresponds to an entry in the SessionQueue?

Many thanks.

15

Web Server - Ask For Help / Re: Task Panel tabs - opening and closing on conditions, adding CSS to tab header

« on: October 07, 2021, 08:38:04 AM »

For those following, during the Oct 7, 2021 user group Bruce showed how to do work arounds for these issues involving changes to the netweb template and adding a javascript.  He put issues on the list for a later release.