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.


Topics - HendersonS

Pages: [1] 2
1
Programming / Sign XML Documents with Digital Signatures
« on: February 18, 2024, 04:05:16 PM »
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?


Code: [Select]
''' <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

2
ODBC / ODBC Views Issue
« on: April 25, 2023, 07:52:48 PM »
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

3
Webster Plus / Webster Queries
« on: April 05, 2023, 01:11:02 PM »
Hello everyone !

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

4
iNomads / Bar Code Reading in iNomads
« on: July 14, 2022, 05:41:06 PM »
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:
Code: [Select]
CALL "*plus/inomads/scanner",x_dat$,"CODABAR,CODE_39,CODE_93,CODE_128,QR_CODE"
For iPad/iPhone:
Code: [Select]
CALL "*plus/inomads/scanner",x_dat$,"QR_CODE"

5
iNomads / Fav Icon On Inomads
« on: May 17, 2022, 10:40:37 AM »
Hello everyone,

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

6
iNomads / how to extract a value passed in the url
« on: April 01, 2022, 09:37:07 AM »
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.


7
Nomads / Classic Query
« on: December 10, 2021, 10:22:40 AM »
hi all,

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

8
Off Topic / Oferta de Trabajo
« on: November 26, 2021, 09:17:20 AM »
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

9
iNomads / How To Call DLLs With Inomads
« on: October 25, 2021, 04:36:57 PM »
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?

10
iNomads / Screen Size
« on: August 31, 2021, 09:41:13 PM »
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.

11
iNomads / Inomads Error
« on: August 20, 2021, 09:52:47 AM »
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?



12
Nomads / inomads color manage
« on: August 09, 2021, 09:10:24 PM »
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?

13
Language / Problems with Report viewer
« on: March 17, 2021, 04:19:51 PM »
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?

14
Wish List / Add Feature to Viewer.
« on: May 27, 2020, 08:00:24 AM »
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.


15
Language / 'TEXT' mnemonic.
« on: May 26, 2020, 04:01:04 PM »
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.

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

Pages: [1] 2