The CVS RTF conversion was done for converting simple RTF from PxPlus RTF Multilines into text. It is not guaranteed to work with any RTF generated elsewhere.

From my testing I was able to get text with some extra newlines from a conversion of a RTF file created by MS Wordpad but I was not able to get any text from conversion of RTF generated by MS Word 2010.

I think the easiest solution is to let Microsoft's own tools handle the conversion and to let MS Word do the work.

I am not to sure what you mean when you say "convert data files in the data dictionary to sql".

The PxPlus SQL ODBC driver and PxPlus SQL Server products are used to access PxPlus data file from third party applications like MS Excel using SQL statements i.e. "SELECT * FROM invoices".

The PxPlus SQL ODBC driver is used when the PxPlus data and the third party application are on the same machine. The PxPlus SQL ODBC driver and the PxPlus SQL Server are both used when the PxPlus data and the third party application are on different machines.

If this is what you are trying to do then you need to look at the documentation for instructions on how to configure and use:

https://manual.pvxplus.com/?odbc/configuration_procedures.htm
https://manual.pvxplus.com/?odbc/using_odbc_driver.htm

If what you want to do is convert your PxPlus data into relational database tables like for example MS SQL Server tables then you would not use those products at all. What you would do is use the [ODB] or [ADO] special file interface to connect to the relational database and you could create the table and copy in the data from your PxPlus data via a PxPlus program.

https://manual.pvxplus.com/?command_tags/odb.htm
https://manual.pvxplus.com/?command_tags/ADO.htm

To create the table you would do a WRITE RECORD (odb_chan) "CREATE TABLE ...". To make this easier you can from the data dictionary maintenance panel go to the utilities menu and select generate external and then select SQL Create Table. This will give you a SQL CREATE TABLE command for the current table selected in the data dictionary maintenance panel.

To copy the data in you could just do a loop that reads a record from the PxPlus data file and then does a WRITE RECORD (odb_chan) "INSERT INTO ..."

Hi Ned,

Here is a link to the current RTF specification (https://www.microsoft.com/en-ca/download/details.aspx?id=10725) at least according to Wikipedia (https://en.wikipedia.org/wiki/Rich_Text_Format).

Another approach you could use is to use the COM interface and open the RTF file via MS Word and then read back the text. If you are using PxPlus 2017 or higher this is made even easier because you can use the new *obj/word object (https://manual.pvxplus.com/?PxPlus%20User%20Guide/External%20Components/PxPlus%20COM%20Support/Word%20Object.htm).

It is unlikely that the activation being for version 11 has anything to do with the PxPlus crash you are seeing. I would look at other differences between the working old server and the problem new server. It is possible that other differences between the two systems is at fault here. For example, firewall, permissions, or OS libraries.

I suggest creating a HelpDesk ticket (https://helpdesk.pvxplus.com) where you can safely share your serial number with us and we can look into the serial for you.

My guess is it was a version 10 but got upgraded at some point after it was installed and registered on the old server. That being said this is not a problem as I mentioned the version 11 activation will work just the same as the version 10 activation on a version 10.20 of PxPlus.

Hi Sam,

If the version you installed of PxPlus is 10.20 then activating it with a version 11 license is the same as if you activated it with a version 10 license. The software is designed so that you can use higher version licenses on older software and that will work the same as using the exact version of the license. If you were to use a version 9 license on version 10.20 of PxPlus it would activate but warn you that version 10 features will be disabled.

Here is some Adobe Acrobat Reader Documentation that may help.

https://www.adobe.com/content/dam/acom/en/devnet/acrobat/pdfs/pdf_open_parameters.pdf#page=5&zoom=auto,-169,394

I was able to accomplish what you were trying to do with the following

invoke """C:\Program Files (x86)\Adobe\Acrobat Reader DC\Reader\AcroRd32.exe"" /A ""page=5"" ""test.pdf"""


If the PDF is on the web it can be done with a #page=5 at the end of the URL or a #nameddest=destination.

It is possible to run the Windows installers for some of our products in silent mode so no user interaction is needed.

PxPlus WindX Plug-in: From the command line run pxp1500-0001-WPI.exe /s /v"/qn"

PxPlus SQL ODBC Driver: From the command line run sql_odbc_driver_6.10.0000_windows_32-bit_x86.exe /VERYSILENT

PxPlus SQL Server: From the command line run sql_server_6.10.0000_windows_32-bit_x86.exe /VERYSILENT

PxPlus does not have a fully silent install as it will always bring up the activation screen.

There should be no reason for HTML to go through as an attachment. Is it possible your call to *web/email has some of the arguments mixed up or not set correctly?

the 7th argument is message$ and should be something like "<html><head><title>..</html>"

The 8th argument is attachment$ and should be ""

The 13th argument is bodyencoding$ and should be "text/html"

Hi Christian,

I can confirm you made your first post successfully.

Welcome to the forum.