On the [TCP] open specify the "TLS1.2" option to force pxplus to use TLS1.2 which is the newest protocol it supports and the most likely to be accepted. Without specifying that the server may be detecting that PxPlus supports a older unsupported protocol and rejecting it.

Hi Peter,

If you can sometimes download the file and other times you can't that would possibly indicate the issue is on the sftp server. Likely sometimes the file is locked by a program updating it for example. The best you can do in that situation is to handle errors like that by trying again a few times before giving up.

Another probably less likely possibility is that sometimes your current directory is different so maybe using a absolute path would help /HOME/USERNAME/PO/OUT

In the doc for the Excel object there is an example program at the bottom that demonstrates a lot of the functionality. It shows opening a workbook and setting the active worksheet and reading and writing to it. https://manual.pvxplus.com/?PxPlus%20User%20Guide/External%20Components/PxPlus%20COM%20Support/Excel%20Object.htm

Creating a sheet is easy just use the CreateWorksheet method.

x'CreateWorksheet("My New Sheet")

this will create a new sheet that is inserted before the active sheet.

Another option is you can enable the right click menu for the Grid which has a export to excel option. Then a user just has to right click and select the option to export to excel and you don't have to write the code. The listbox/grid right click menu is controlled via %list_popup (https://manual.pvxplus.com/?NOMADS%20Graphical%20Application/Creating%20Panel%20Controls/Popup%20Menu/List%20Box%20and%20Grid%20System%20Popup%20Menu.htm).

I think you just need to set the 'U8' system parameter (https://manual.pvxplus.com/?parameters/u8.htm).

Try putting a backslash before the $ i.e. \$.
Does that work?

Hi Jeff,

You can use *Browser to manually print to a PDF but there is nor current built in functionality to print to a PDF programmatically.

If you load the HTML into a *Browser control you can then right click on the rendered web page and then select print, then select print to PDF.

Instead of right click you can also use the code:

myBrowser'window'print()

where myBrowser is the *Browser handle.

This code will programmatically trigger the print dialog. The user will still have to select the print to PDF printer.

We can look at possibly adding this feature to *Browser for a future release.

See the forum post here: https://forum1.pvxplus.com/index.php?topic=39.0

It gives a description of what keyed load does and what an error means. It also provides a link to the fixvlr program (actually fixvlr2 which is newer) and describes what it does.

Effectively you may have some lost data but fixvlr2 will get out what it can from the file.

Using the pxpsql command line client with --version will return the version.

pxpsql --version

You can also run the PxPlus Sql Server with a --version to get it's version

pxpsqlsvr --version

If on Windows you can hover over the pxpsqlodbc.dll or pxpsqlsvr.exe file to see the version. In this case it will look like 7.0.3.0 for 7.00.0003

On Windows you can also see the ODBC driver version in the Data Source Administrator window. Open a PxPlus ODBC DSN and go to the about tab. Before you create a DSN the ODBC version will appear beside the name of the driver as well.

For the PxPlus SQL Server you can open the pxpsconf.exe config app and go to about to see the version as well.

The version in these programs appears as 7.00.0003.

An ODBC client application can also query the version number using a SQLGetInfo call with the SQL_DBMS_VER property.

Does any of that get you what you want or are you looking for something different?