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.
16
Webster Plus / Re: EZWeb takes approx 20 seconds for actions
« on: February 28, 2024, 10:35:43 AM »
I was thinking about your issue last night and wondering if perhaps the easiest solution for you would be to use RSS.
There are a number of free RSS readers for Windows and other platforms, many of which can reside in the task bar or run in the background and display an alert when an RSS feed changes.
On the server you could create RSS files and have your internet web server (Apache, IIS, etc) simply serve up the RSS file. Depending on your needs you could have multiple RSS feeds, a global for all users, company specific feeds, even user specific feeds. These RSS files could be updated on the server as required using PxPlus either as the events occur or by a background task. As for load, most servers can easily handle 1000s of requests per minute if all they are doing is forwarding a data file (the RSS feed). This avoids you having to worry about how many PxPlus licenses you might need as PxPlus would not be directly involved in the RSS request.
Of course a lot of this depends on exactly what your application requirements are, but using RSS might be a real simple solution.
BTW: Another solution might be to use something like WhatsApp to send messages. This is something I am looking at presently.
There are a number of free RSS readers for Windows and other platforms, many of which can reside in the task bar or run in the background and display an alert when an RSS feed changes.
On the server you could create RSS files and have your internet web server (Apache, IIS, etc) simply serve up the RSS file. Depending on your needs you could have multiple RSS feeds, a global for all users, company specific feeds, even user specific feeds. These RSS files could be updated on the server as required using PxPlus either as the events occur or by a background task. As for load, most servers can easily handle 1000s of requests per minute if all they are doing is forwarding a data file (the RSS feed). This avoids you having to worry about how many PxPlus licenses you might need as PxPlus would not be directly involved in the RSS request.
Of course a lot of this depends on exactly what your application requirements are, but using RSS might be a real simple solution.
BTW: Another solution might be to use something like WhatsApp to send messages. This is something I am looking at presently.
17
Webster Plus / Re: EZWeb takes approx 20 seconds for actions
« on: February 27, 2024, 08:20:53 PM »
There are a number of ways you could handle this. You actually have two issues, one is the central server that the desktops will connect to and will serve up the status changes, the other is the software on the workstation.
For the central server you should be able to use PxPlus to handle the load. To determine the number of concurrent users you would need to determine how long a request takes to respond and the frequency that you want workstations updated.
For the workstation this would be fairly easy to do using PxPlus however the license costs might be prohibitive. If you find that is the case you could use something like powershell to create a workstation process or create a C, .NET or VB application to do the same.
Now technically depending on your actual application requirements you might be able to have the host simply maintain 'status files' on the server and use Apache (or any other web service like IIS) simply serve up the status files. PxPlus could update the status files as needed.
Last, but not least, you might be able to use Web Notifications as that may provide you the functionality you are looking for.
Of course, all of the above depends a lot on the exact needs of your application.
For the central server you should be able to use PxPlus to handle the load. To determine the number of concurrent users you would need to determine how long a request takes to respond and the frequency that you want workstations updated.
For the workstation this would be fairly easy to do using PxPlus however the license costs might be prohibitive. If you find that is the case you could use something like powershell to create a workstation process or create a C, .NET or VB application to do the same.
Now technically depending on your actual application requirements you might be able to have the host simply maintain 'status files' on the server and use Apache (or any other web service like IIS) simply serve up the status files. PxPlus could update the status files as needed.
Last, but not least, you might be able to use Web Notifications as that may provide you the functionality you are looking for.
Of course, all of the above depends a lot on the exact needs of your application.
18
Webster Plus / Re: EZWeb takes approx 20 seconds for actions
« on: February 27, 2024, 02:46:05 PM »
Webster+ uses the PxPlus Web server interface which can run on EZWeb, Apache, or IIS uses a user slot for the duration of the process. That is a user slot will be needed/allocated when the host server receives the request then freed up once the request has been completed.
When using the Web Server interface there is nothing actually running on the server until the user makes the request.
In normal Windows/Linux processing once the user starts the application a user slot is allocated and will remain in use until they totally exit the application and all processes have completed.
For example on Windows/Linux non-Web applications there is always at least one process running on the server and as such it requires a user slot for the duration. When running using the Web server interface when a request is received a PxPlus process is started (using a user slot) and terminated once the response is sent.
When using the Web Server interface there is nothing actually running on the server until the user makes the request.
In normal Windows/Linux processing once the user starts the application a user slot is allocated and will remain in use until they totally exit the application and all processes have completed.
For example on Windows/Linux non-Web applications there is always at least one process running on the server and as such it requires a user slot for the duration. When running using the Web server interface when a request is received a PxPlus process is started (using a user slot) and terminated once the response is sent.
19
Programming / Re: PXPlus crashing after error 61
« on: February 21, 2024, 07:48:30 PM »
Glad its been resolved.
Over the years I have seen a variety of weird OS compatibility issues so I always suggest you run a version of PxPlus compiled and tested AFTER the release date of any OS. In your case, while v12.50 may have started and appeared to run on Redhat 7, it was compiled and tested on Redhat 6.
Over the years I have seen a variety of weird OS compatibility issues so I always suggest you run a version of PxPlus compiled and tested AFTER the release date of any OS. In your case, while v12.50 may have started and appeared to run on Redhat 7, it was compiled and tested on Redhat 6.
20
ODBC / Re: Serius I complete missing undesrtand odbc
« on: February 21, 2024, 08:00:11 AM »
Edias is correct. This appears to be the ProvideX ODBC driver as sold and supported by Sage with their MAS90 accounting package.
If the issues you are having are relative accessing MAS90 data you should contact Sage for assistance as their ODBC driver is different than the drivers for PxPlus.
If the issues you are having are relative accessing MAS90 data you should contact Sage for assistance as their ODBC driver is different than the drivers for PxPlus.
21
Programming / Re: Sign XML Documents with Digital Signatures
« on: February 20, 2024, 07:42:33 AM »
I would probably use XMLSEC (xmlsec1) to do this from command line as it is available on both windows and Linux and there is fairly extensive documentation available at:
http://sgros.blogspot.com/2013/01/signing-xml-document-using-xmlsec1.html
Here is the command documentation:
https://www.mankier.com/1/xmlsec1
While PxPlus logic could be used directly; by using a standard package like xmlsec1, should you have any issues the company receiving the XML may have examples.
http://sgros.blogspot.com/2013/01/signing-xml-document-using-xmlsec1.html
Here is the command documentation:
https://www.mankier.com/1/xmlsec1
While PxPlus logic could be used directly; by using a standard package like xmlsec1, should you have any issues the company receiving the XML may have examples.
22
Programming / Re: PXPlus crashing after error 61
« on: February 15, 2024, 06:11:49 PM »
I think you may have misunderstood my comment.
There has never been a version of release 1250 of PxPlus built on nor tested on Redhat 7. That is not to say version 1250 won't work on that Redhat version, just that there may be compatibility issues.
If you are running Redhat version 7 you should use a version of PxPlus that was compiled on and tested on Redhat 7.
There has never been a version of release 1250 of PxPlus built on nor tested on Redhat 7. That is not to say version 1250 won't work on that Redhat version, just that there may be compatibility issues.
If you are running Redhat version 7 you should use a version of PxPlus that was compiled on and tested on Redhat 7.
23
Programming / Re: PXPlus crashing after error 61
« on: February 15, 2024, 04:09:26 PM »
Loren
You could be facing a OS compatibility issue. There never was a version 12.50 for any version of Redhat 7. The latest Redhat release for version 12.50 was Redhat 6.
You can see all the versions of PxPlus 12.50 at https://home.pvxplus.com/downloads/pxp1250/
If you want to run Redhat 7.9 you likely will need to use a newer PxPlus built for/on that release -- Version 14 PxPlus 2017 -- although even that release would have been made for an earlier version of Redhat 7.
Redhat 7.9 was only released in 2020, PxPlus 12.50 was released in 2015.
You could be facing a OS compatibility issue. There never was a version 12.50 for any version of Redhat 7. The latest Redhat release for version 12.50 was Redhat 6.
You can see all the versions of PxPlus 12.50 at https://home.pvxplus.com/downloads/pxp1250/
If you want to run Redhat 7.9 you likely will need to use a newer PxPlus built for/on that release -- Version 14 PxPlus 2017 -- although even that release would have been made for an earlier version of Redhat 7.
Redhat 7.9 was only released in 2020, PxPlus 12.50 was released in 2015.
24
Language / Re: Maximum Number of Columns in a Report View List Box
« on: February 14, 2024, 10:10:12 AM »
Glad to have helped.
25
Language / Re: Maximum Number of Columns in a Report View List Box
« on: February 12, 2024, 11:08:54 AM »
There is a limit imposed by Windows itself.
Check out the note at the bottom of: https://learn.microsoft.com/en-us/dotnet/api/system.windows.forms.listview.columnheadercollection
Unexpected behavior can result when the combined width of all columns exceeds 32,768 pixels.
So depending on the column widths and the current user font you may be hitting this limit.
Check out the note at the bottom of: https://learn.microsoft.com/en-us/dotnet/api/system.windows.forms.listview.columnheadercollection
Unexpected behavior can result when the combined width of all columns exceeds 32,768 pixels.
So depending on the column widths and the current user font you may be hitting this limit.
26
Webster Plus / Re: grid display using program - grid does not show
« on: February 12, 2024, 10:59:36 AM »
I tried the following with no problem:
HTML file demo.html (placed in the pages directory):
Program file "myprog" (in the prog directory)
Rather than read from a file I used in-code DATA values to make sure there was data present.
HTML file demo.html (placed in the pages directory):
Code: [Select]
<!DOCTYPE html>
<html>
<head>
</head>
<body>
[ttl]Grid[/ttl]<br>
[form]
[grid MyGrid program="myprog;makegrid" size=auto/20 ]
[col Source=ItemCode$ ttl="ItemCode" width=30 ]
[col Source=ItemName$ ttl="Name" width=50]
[col Source=ItemType$ ttl="Type" width=5]
[/grid]
[/form]
</body>
</html>
Program file "myprog" (in the prog directory)
Code: [Select]
! myprog (placed in the prog directory)
MAKEGRID:
enter MYGRID
open (hfn,iol=GRIDIOL)"*memory*"
MYGRID=lfo
while 1
read data iol=gridiol,end=*break
write (MYGRID)
wend
!
exit
!
data "item1","First Item","A"
data "item2","Second Item","B"
data "item3","Third Item","A"
data "item4","Last Item","C"
!
GRIDIOL: iolist ITEMCODE$,ITEMNAME$,ITEMTYPE$
Rather than read from a file I used in-code DATA values to make sure there was data present.
27
Webster Plus / Re: Loading list from program carList$
« on: January 30, 2024, 11:37:50 AM »
According to the documentation:
When used on a [ list ] short code, indicates the name of a program to beperformed called to return a file containing the data to be displayed.
The documentation has a minor error in that it says performed whereas it should say called.
So when you have a program=xxxxx in a list shortcode, the program should return a file handle to a keyed file with the desired contents. Generally this would be a memory file, but id could be a *query* file or actual data file. Something like:
The Key value will determine the sort sequence. You will generally provide a IOLIST on the file then use the [ col ] short code to reference the desired columns.
Normally you would have a file on your system with the car models and simply open and pass back this file then define which column/field you want displayed.
Now if you do want to use a program and a text string you could use something like:
Use the Execute to run your program to load carlist$ and the text= option in the [ data ] short code to pass the value. When you use the text= option, there is no [ /data ] needed.
When used on a [ list ] short code, indicates the name of a program to be
The documentation has a minor error in that it says performed whereas it should say called.
So when you have a program=xxxxx in a list shortcode, the program should return a file handle to a keyed file with the desired contents. Generally this would be a memory file, but id could be a *query* file or actual data file. Something like:
Code: [Select]
MakeCarList:
enter FileNo
open (hfn) "*memory*"
FileNo = lfo
write (lfo,key="0") "Ford"
write (lfo,key="1") "GM"
write (lfo,key="2") "Audi"
write (lfo,key="3") "Volvo"
exitThe Key value will determine the sort sequence. You will generally provide a IOLIST on the file then use the [ col ] short code to reference the desired columns.
Normally you would have a file on your system with the car models and simply open and pass back this file then define which column/field you want displayed.
Now if you do want to use a program and a text string you could use something like:
Code: [Select]
<p>[ttl]Cars[/ttl]</p>
<p>[form]</p>
<p>[execute perform"myprog;makecarlist"][list Cars$][data rowsep=/ text=(carList$)][/list]<br />
[list Cars2$][data rowsep=/]Ford/Gm/Audi/Volvo[/data][/list]
[/form]
</p>
Use the Execute to run your program to load carlist$ and the text= option in the [ data ] short code to pass the value. When you use the text= option, there is no [ /data ] needed.
28
Webster Plus / Re: EZWeb takes approx 20 seconds for actions
« on: January 27, 2024, 05:14:20 PM »
The fact that when the IDE is running you see a slowdown sounds like you are hitting the concurrent user count. Note that windows users are not shared with Remote users as there is no way to know if the remote web user is the same user as the Windows user.
So, if using a 1 user license only one user can run at a time; running the IDE will consume the only user slot.
When Webster detects the user limit has been hit it stalls the process for between 10-20 seconds waiting for a user slot to free up. Should a slot not free up it will let the process through rather than reporting the user limit error. This is done so your end users (who could be anybody) won't see the problem that they could not fix anyway, they will just perceive a slow response time.
So, if using a 1 user license only one user can run at a time; running the IDE will consume the only user slot.
When Webster detects the user limit has been hit it stalls the process for between 10-20 seconds waiting for a user slot to free up. Should a slot not free up it will let the process through rather than reporting the user limit error. This is done so your end users (who could be anybody) won't see the problem that they could not fix anyway, they will just perceive a slow response time.
29
Webster Plus / Re: EZWeb takes approx 20 seconds for actions
« on: January 26, 2024, 02:42:24 PM »
Are you connecting to your own machine and if so what URL are you using?
I have seen instances where Windows has issues with resolving localhost if you have both IPv4 and IPv6 enabled.
If using localhost try using the direct IP address of 127.0.0.1
The issue is that localhost often has two definitions -- one for IPv4 (127.0.0.1) and one for IPv6 (::1). I have seen this get things confused as the browser first tries the ::1 address then the 127.0.0.1.
I have seen instances where Windows has issues with resolving localhost if you have both IPv4 and IPv6 enabled.
If using localhost try using the direct IP address of 127.0.0.1
The issue is that localhost often has two definitions -- one for IPv4 (127.0.0.1) and one for IPv6 (::1). I have seen this get things confused as the browser first tries the ::1 address then the 127.0.0.1.
30
Programming / Re: Flash a Message
« on: January 26, 2024, 10:56:01 AM »
Jeff,
Perhaps the easiest solution if you are using Nomads is to set a timeout value to invoke code to hide/clear the message.
For example, when you display the message set %nomads'timeout to the number of seconds you want the message to remain. The timeout will cause the system to attempt to close your panel so in the panel wrap up logic test if CTL = -1900 (panel timeout); if its a panel timeout clear the message, reset %nomads'timeout to 0, and set IGNORE_EXIT to 1.
If you already have timeout logic in your panel you may want to set another variable as well when you display the message to indicate that the timeout is to handle clearing the message.
Perhaps the easiest solution if you are using Nomads is to set a timeout value to invoke code to hide/clear the message.
For example, when you display the message set %nomads'timeout to the number of seconds you want the message to remain. The timeout will cause the system to attempt to close your panel so in the panel wrap up logic test if CTL = -1900 (panel timeout); if its a panel timeout clear the message, reset %nomads'timeout to 0, and set IGNORE_EXIT to 1.
If you already have timeout logic in your panel you may want to set another variable as well when you display the message to indicate that the timeout is to handle clearing the message.