Hello everyone,
recently we are working on web services that use digitally signed xml files for validation, these xml files must be signed with digital certificates (.P12 files), does anyone have experience doing this? Or can you guide us how to do this in Pvx Plus? Any idea is welcome, thank you very much in advance.

Below is some example code in VB.NET. Any idea how we can replicate it in pxplus?


''' <summary>
''' Method for signing XML with digital certificate (*.p12)
''' </summary>
''' <param name="xmlDoc"> document to sign </param>
''' <param name="pathCert">location of certificate to use for signing </param>
''' <param name="passCert">digital certificate password</param>
''' <returns>Digitally signed XML</returns>
Private Function Signed (ByVal xmlDoc As XmlDocument, ByVal pathCert As String, ByVal
passCert As String) As XmlDocument
Try
If Not File.Exists(pathCert) Then Throw New Exception("The signing certificate does not exist")
Dim cert = New X509Certificate2(pathCert, passCert, X509KeyStorageFlags.Exportable)
Dim exportedKeyMaterial = cert.PrivateKey.ToXmlString(True)
Dim key = New RSACryptoServiceProvider(New CspParameters(24))
key.PersistKeyInCsp = False
key.FromXmlString(exportedKeyMaterial)
Dim signedXml As SignedXml = New SignedXml(xmlDoc)
  signedXml.SigningKey = key
  signedXml.SignedInfo.SignatureMethod =
"http://www.w3.org/2001/04/xmldsig-more#rsa-sha256"
  Dim reference As Reference = New Reference()
  reference.AddTransform(New XmlDsigEnvelopedSignatureTransform())
  reference.DigestMethod = "http://www.w3.org/2001/04/xmlenc#sha256"
  reference.Uri = ""
  signedXml.AddReference(reference)
  Dim keyInfo As KeyInfo = New KeyInfo()
  keyInfo.AddClause(New KeyInfoX509Data(cert))
  signedXml.KeyInfo = keyInfo
  signedXml.ComputeSignature()
  Dim xmlDigitalSignature As XmlElement = signedXml.GetXml()
  xmlDoc.DocumentElement.AppendChild(xmlDoc.ImportNode(xmlDigitalSignature, True))
  Return xmlDoc
  Catch ex As Exception
  Throw ex
  End Try
End Function

hello All,

we are trying to query data from a view in excel and we are getting this error (attached in the screenshot).

The thing is that when we try the query from Excel to the same file from which the view was created, we can access the data.

What could be happening?

we are using a Pxplus Sql ODBC Driver Version 7 and Pxplus Version 19.1

Hello everyone !

In webster plus, queries don't have a search field?

hello everyone,

we are trying to use the "*plus/inomads/scanner" tool to read barcodes on mobile devices (iPhone/iPad) and it always generates an 11 error on the line that calls this routine.
on android devices it opens the code reader application but it does not return the read value, has anyone used this tool that can give me some help?

This is a sample of how I am calling the routine:
For Android:
CALL "*plus/inomads/scanner",x_dat$,"CODABAR,CODE_39,CODE_93,CODE_128,QR_CODE"

For iPad/iPhone:
CALL "*plus/inomads/scanner",x_dat$,"QR_CODE"

Hello everyone,

Is there a way to put a custom favorite icon in the inomads template?

Hello everyone,

we are trying to query a receipt or invoice with inomads directly passing the receipt number through the url, so we need to extract the value from the url.
we have read the manual tried several ways but we have not been able to achieve it.
we have a transaction called "qryrec" and we want to pass the value "5580" and later extract that value.

for example:
http://website.com/?txid=qryrec&?id=5580

We also add the PxPlus program CGI handler as specified in https://manual.pvxplus.com/PXPLUS/apache/sampleinstall.htm, but when we try to run the program we get this message "Submission rejected. Web server license not found."

note:
Pxplus 2021 V18.1 Wayfer license .
we are using apeche 2.4 web server.

We are new to using inomads, so if anyone can help us, we would really appreciate it.

hi all,

its there a way to change The Query+ mode by the default to the classic query? something like a global variable?

Saludos a Todos,

Somos Una Empresa de desarrollo de Software y estamos buscando programadores para desarrollo con PxPlus, así como experiencia en implementaciones con Inomads.
Si Alguien esta interesado puede contactarme por correo electrónico hjsalva2@gmail.com.

Saludos,
HendersonS

Hello everyone,

we have a program that calls  functions in a dll to communicate with external hardware (fiscal printer), we want us to do this through the browser using inomads, someone has experience with this that can help us?

Hi everyone!  using inomads is there any way to calculate the screen size of the device that is being used?, in nomads we usually use MSE to calculate the dimensions but apparently it doesn't work in inomads.

Hi,

we have a routine to make quick queries where we send a file and the format of the columns to show, this works normally in nomads, but when it is executed in inomads it gives us an error 13 (see attached).

the error occurs in a protected program so we cannot see the possible reason.

what could be happening?

hello everyone, recently we are working with inomads and we have some problems with the handling of colors in the buttons and texts.

these have the color defined in a global variable with the hexadecimal color code but apparently inomads does not recognize it.

what could be happening?

Hello everyone, recently we have a strange message from the report viewer when it is in the tray to print some reports (see attached image), after this message the viewer closes, does anyone know why this happens?

We have been working with crystal reports in pxplus for the creation of reports for a long time and it worked very well, but with the updates of crystal Reports the integration with pxplus is more difficult.

so we started to use the Viewer for the reports, and we would like that the viewer will integrate the feature of exporting to excel, word, xml, etc. like pdf.

I think it would be very convenient and extremely useful if it could be export from the same viewer.

Hi all,

Printing with mnemonic 'TEXT', to print text, and using mnemonic 'BB' for bold text, everything in the viewer looks fine, but when exported to PDF format, bold disappears.

anyone know why? code used below.

LET CHAN=UNT; OPEN (CHAN)"*viewer*;SUPPRESSWATERMARKS;ORIENTATION=PORTRAIT"
PRINT (CHAN)'BB','TEXT'(600,190,"Customer:"+CUST_NAME$),'EB'
CLOSE (CHAN)

Hi All,

Recently we are working with several DLL´s, and they give us error 15 when traying to load them, anyone knows more information about this error ?

thaks,
Henderson S.

Hi everyone,

who know of some function to justify string like ms word ?, i mean  adding spaces when needed to complete a number of characters.

Hi to everyone,

i get this error to generate a qr code with the tool of pxplus "makeqrcode".

somebody knows why ?


i have pxplus v15.0

Hello everyone,

Does anyone know if there is a function in pxplus to convert a binary number (0000000001000000) to a decimal number(64)?, I read about the dec () function but it's not what I want.

We are trying to generate QR codes, does anyone know how to do it with pxplus? We would appreciate it if you shared it with us.