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 - HendersonS

Pages: [1] 2 3 4
1
Programming / Re: Sign XML Documents with Digital Signatures
« on: February 23, 2024, 12:43:19 PM »
Loren, thanks for your demonstration,

so far I have not been able to install xmlsec on Windows, and I have not been able to find a solution with pxplus either, so I will have to make some program in C# or another language to invoke it from pxplus, since I do not see a solution with pxplus.

2
Programming / Re: Sign XML Documents with Digital Signatures
« on: February 20, 2024, 04:47:02 PM »
Thanks Mike for your instructions.

If I understood correctly, you mean that I can invoke this tool from pxplus? And just in case I take another route to do it with pxplus, is there any utility to extract the private key from a .pem?

3
Programming / Re: Sign XML Documents with Digital Signatures
« on: February 19, 2024, 08:23:19 PM »
Loren thanks for yor reply

Below is the structure that the signature node should have within the xml, I have no experience in building these signatures. Maybe you can show me some example code to do it.

Code: [Select]
<Signature xmlns="http://www.w3.org/2000/09/xmldsig#">
 <SignedInfo>
<CanonicalizationMethod Algorithm="http://www.w3.org/TR/2001/RECxml-c14n-20010315" />
<SignatureMethod Algorithm="http://www.w3.org/2001/04/xmldsigmore#rsa-sha256" />
<Reference URI="">
 <Transforms>
 <Transform Algorithm="http://www.w3.org/2000/09/xmldsig#envelope d-signature" />
 </Transforms>
 <DigestMethod Algorithm="http://www.w3.org/2001/04/xmlenc#sha256" />
 <DigestValue>Atr9H7DiGlxrQOFII/hFihsL6ACiwe47Oo93tgtuera=</DigestValue>
</Reference>
</SignedInfo>
 <SignatureValue>gQyXO0FFDGIITESTpP5xZjLIRtv/Q7/ixe1lNDLDA5aw...</SignatureValue>
<KeyInfo>
 <X509Data>
<X509Certificate>DGIITESTBFagAwIBAgIIInYGQUX9q0IwDQYJKoZIhvcNAQ...</X509Certificate>
 </X509Data>
 </KeyInfo>
</Signature>

4
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

5
ODBC / Re: ODBC Views Issue
« on: May 02, 2023, 07:46:30 AM »
devon, Thanks for your answer, I was able to get it working.

6
ODBC / Re: ODBC Views Issue
« on: April 28, 2023, 11:41:39 AM »
hi devon,

If I have the sql odbc driver installed as a client, in the options tab I can include an address of a network shared folder, for example: \\12.8.1.54\PXPlus19\Pxplus, this being the directory where the pvxwin32.dll is located? With that configuration, would it show the views?

7
ODBC / Re: ODBC Views Issue
« on: April 26, 2023, 11:42:49 AM »
thanks, i'll check it out

8
ODBC / Re: ODBC Views Issue
« on: April 26, 2023, 08:33:33 AM »
Hi devon,

 thanks for your answer, we did that setup, in fact we have other views that work without errors, but this one has that error.

9
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

10
Webster Plus / Re: Webster Queries
« on: April 05, 2023, 02:41:33 PM »
oh ok that makes sense

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

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

12
Nomads / Re: Message/Status Bar Updates
« on: November 02, 2022, 04:37:27 PM »
hi james,

if you are using pxplus v10 or higher, you may want to use the listbox and grid system popup menu to accomplish this by simply calling a routine

Code: [Select]
CALL "*plus/winutl/listpopup;Export_to_File",ctl_no,exportfile$
For more info:
https://manual.pvxplus.com/PXPLUS/NOMADS%20Graphical%20Application/Creating%20Panel%20Controls/Popup%20Menu/List%20Box%20and%20Grid%20System%20Popup%20Menu.htm

13
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"

14
mike,

Thank you very much for this contribution, for days we have wanted to experiment with webster to rebuild our erp directly for the web.

so this helps us to take the first steps.

15
iNomads / Re: Fav Icon On Inomads
« on: May 20, 2022, 10:36:53 AM »
Mike,

thank you very much! it worked!

Pages: [1] 2 3 4