PxPlus User Forum

Twitter Twitter Twitter

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.


Messages - Mike King

Pages: 1 ... 53 54 [55] 56 57 ... 65
811
Programming / Re: detect embedded quotes
« on: January 25, 2019, 05:45:04 PM »
Lawrence,

You can use the POS function to detect the double quotes as in:

(Assuming the field is in X$)...

IF POS(QUO=X$)<>0 MSGBOX "Invalid quote character in data"

Alternatively you could change them to something else using the SUB function as in:

X$= SUB (X$, QUO, "'")

(That's a single apostrophe inside double quotes)

If you happen to be using the standard Windows ISO character set you might try replacing the quote with something like $A8$ which would generally convert like this:

"Quoted String"   -> ¨Quoted String¨

812
Programming / Re: List Box Keystroke Entry Selection
« on: January 23, 2019, 07:00:35 PM »
Unfortunately the report view is a Windows control and, to the best of me knowledge, there is no option to use a different column... although it is something we could look into.

813
Wish List / Re: PxPlus - WindX on IOS or Android
« on: January 23, 2019, 06:44:11 PM »
Mike

Part of the problem of migrating WindX to a iOS or Android device has to do with real estate and control compatibility.

iNomads provides a solution that addresses control compatibility but many applications are not well suited to the smaller screen sizes and often require rework.  In many cases its just not practical on a small screen to allow for the number of controls/inputs that most applications want.

As for the specific issues you mentioned, we are looking at addressing both the expense of iNomads and the ease of implementation with PxPlus 2019 with the introduction of an App builder.  These should make it easier to integrate PxPlus applications with your iOS or Android devices.

Lastly, for many clients the simple solution for running on a Smartphone or iOS is to use the free Windows RDP app and connect to a Windows server running the application either locally or via WindX. 

814
Language / Re: *VIEWER* with SSH
« on: January 14, 2019, 11:33:44 AM »
Assuming you are using WindX to connect to your host/server.

The IP address should be the same as you provided to WindX, just the port number needs to change as port 22 is the SSH connection port.

You should be able to the firewall/connection as follows:

On one WIndX session:

  OPEN (1) "[TCP];20000"
  READ RECORD (1) R$
  WHILE 1
  READ RECORD (1,TIM=1 :(,ERR=*BREAK) R$
  PRINT R$
  WEND
  PRINT (1) "HTTP/1.1 200 OK"
  PRINT (1) "Content-type: text/plain",'lf'
  PRINT (1) "Hello There"
  CLOSE (1)


Then on your workstation open a browser and navigate to

  http://x.x.x.x:20000

Where x.x.x.x is the IP address of your server.

The first session will wait for a connection on port 20000 (or whatever port you chose).  When the browser connects it will respond with "Hello There".  Make sure you use the server IP address not its network name to avoid a browser error.

815
Language / Re: *VIEWER* with SSH
« on: January 11, 2019, 09:40:00 AM »
The 20000 can be any port you want, it just has to be open on your server so that the workstation can make an in-bound connection to it.

As for multiple users, the logic used to spawn a process does the following:

  • Generates a random key (session ID)
  • Write this key to a control file
  • Locks a control record on the same control file to assure  only one process is doing starting up/connecting at a time
  • Spawns a process on the server to monitor the selected port.  This process will listen for incoming connection on the specified port.
  • Spawns a process on the workstation passing it the host address, port and random key
  • Waits for the record with the session id to be removed (max 30 seconds)
  • Removes lock from control record and exits back to process

When the workstation connects to the host the process, it passes it the random key.  The spawned host process then stop listening for any more connections and removes the key from the control file completing the connection which can then be used to run the viewer or any other program.

The above process means only one port is needed and can be shared between users.

816
Language / Re: *VIEWER* with SSH
« on: January 10, 2019, 01:50:50 PM »
An SSH connection requires each session to log in to the server thus you cannot directly use any functionality that spawns a separate process such as SSH.

What you can to is make sure there is an open port on your server and set %PXPLUS_HOST$ as described in our online documentation regard *windx.utl;spawn.
(see last part of https://manual.pvxplus.com/page/windx/windxutl.htm)

So for example if your host is at IP address 192.168.1.123 and you open up port 20000 then you could set %PXPLUS_HOST$ to

*192.168.1.123;20000





817
Programming / Re: draw button as empty rectangle
« on: January 10, 2019, 11:56:21 AM »
If what you are looking for is to dynamically control the presence of the control, just put the button in your Nomads panel but make it hidden. When you need it simply make it visible. 

If you need to dynamically control its location, change its size/position prior making it visible since Nomads generally doesn't care about button positions.

Another option would be to again create a hidden button whose characteristics are based on a theme.  When you want to create your dynamic button simply copy the border and color properties from the hidden button to the button you are creating.  Something like:

ThemeSettings$=hidden_btn.ctl'border.borderColor.hoverTextColor.hoverBackColor.$
...
btnCd'border.borderColor.hoverTextColor.hoverBackColor.$-ThemeSettings$


This will just copy the attributes from the hidden button to the dynamic button.

818
iNomads / Re: Error presented in Installation of Inomads
« on: January 09, 2019, 11:38:20 AM »
We supply a Win32 mod_inomads.so for both Apache 2.2 and 2.4 in your install directory for PxPlus. 

The files can be found in :

<install directory>\lib\_plus\inomads\apache\module\windows

For Apache 2.2 simply copy mod_inomads.so to the Apache 2.2 modules directory.
For Apache 2.4 simply copy mod_inomads.so.24 to the Apache 2.4 modules directory and rename as mod_inomads.so.

We do not supply 64 bit versions but you can compile these yourself from the source provided in inomads\apache\module directory.

819
iNomads / Re: File Upload
« on: January 09, 2019, 09:07:33 AM »
There is no built-in method to limit file size or scan for viruses but you can do both of these yourself once the file has been uploaded (which is what mamy sites do at least for anti-virus).

What I would generally do is once the file is uploaded, open it (or read the directory) to get its file length.  If too large erase the file and advise the client.

As for anti-virus, it all depends on what anti-virus tools you want and have purchased.  Most have some form of command line utility you can call to check for viruses,  You would need to check with the anti-virus supplier for details. 

If you want a free option or need this for Linux have a look at ClamAV.

It is important to make sure whatever you chose to use for anti-virus protection gets updated regularly.


820
Language / Re: Events programming
« on: January 04, 2019, 09:42:11 AM »
You should be able to just copy/replicate the properties/events you need into your own object.  There is nothing 'Special' about the generated code that you cannot include in your own logic.

821
Off Topic / Re: Website down?
« on: January 02, 2019, 10:40:42 AM »
Actually we had an issue with the disc system (out of space) which we have fixed and are not back up and running.

822
Programming / Re: FTPS instead of FTP or SFTP
« on: December 31, 2018, 10:47:18 AM »
depending on the server downloads are easy and if the server is using PxPlus its easy to create an HTTPS page for uploading.  If the server is not using PxPlus then you can use PHP or even a simple CGI script to handle uploading. 

Creating a CGI script for use on Linux to handle the uploads is a fairly easy task.



823
Programming / Re: FTPS instead of FTP or SFTP
« on: December 28, 2018, 05:46:08 PM »
Mike,

Have you inquired about switching to SFTP or HTTPS for the transfers?

Everything we have read about FTPS indicates its not the easiest to setup and using an explicit FTP it is somewhat insecure.  Also generally FTPS indicates you are using an implicit connection, whereas FTPES is generally used to refer to secure FTP on explicit connections.

Here are some links on the subject:
https://serverfault.com/questions/10807/what-firewall-ports-do-i-need-to-open-when-using-ftps
https://en.wikipedia.org/wiki/FTPS

Lastly, below is a link to a site that talks about how to get curl to use FTPES which may allow you to construct your own command.  It also advises how to deal with the certificate validation, which appears to basically be to copy our supplied cert file to curl-ca-bundle.crt.
https://www.lewisroberts.com/2010/08/06/scripting-ftpes-explicit-tlsssl-with-curl/

Frankly though I still think your should try to use HTTPS if all you are doing is downloading data is the easiest solution.

824
Programming / Re: ERROR 46 PRINTING TO A PDF PRINTER
« on: December 28, 2018, 11:53:53 AM »
An Error 46 indicates a length of string error.  There are some limits on the length of data you can put in a 'TEXT' mnemonic, font name, or pathname for an image, so these might be the cause.

Also make sure the WindX is running current software as old versions of WindX had different string length maximums.

We would also suggest that you perhaps contact our support department at https://helpdesk.pvxplus.com and see if they can assist.  Please provide them the serial number and version of PxPlus you are using.

825
Nomads / Re: winqry ERROR=42
« on: December 28, 2018, 09:14:50 AM »
Ed, *winqry does not have a line 1875 (any version). 

In fact I cannot find any program in our library that have a line number 1875.

Pages: 1 ... 53 54 [55] 56 57 ... 65