Menu

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.

Show posts Menu

Topics - HendersonS

Pages1 2
#1
Programming / Working with External objects
December 05, 2025, 12:43:47 PM
Hi everyone. Lately, we've been working with third-party objects to interact with xmlsig, CR reports, etc., and we're having the same problem when passing a value to a method that requires another object as its constructor, or when passing a boolean value to the method. Does anyone know how we should handle these kinds of interactions? Thanks in advance.

Example with cr reports:
Code Select
!
 DEF OBJECT CR_APP,"CrystalRuntime.Application"
 LET REPORT=CR_APP'OPENREPORT("C:\temp\customers.rpt") ! // This opens the report and creates the 'Report' object
 !
 LET EXP=REPORT'EXPORTOPTIONS
 LET EXP'DESTINATIONTYPE=1
 LET EXP'FORMATTYPE=31 ! pdf
 LET EXP'PDFEXPORTALLPAGES=-1
 LET EXP'DISKFILENAME$="C:\temp\customers.pdf")
 !CR Expects a boolean (true or false) !false no show dialog
 REPORT'EXPORT(0) ! this give an error 88 Invalid/unknown property name
example with xmlsig:
Code Select
DEF OBJECT SIG,"Chilkat.XmlDSigGen.11" ! xmlsigner object
DEF OBJECT CERT,"Chilkat.Cert.11" ! cert object
LET CERT'LOADPFXFILE("C:\temp\cert.p12","pass")
LET C=CERT'LOADPFXFILE("C:\temp\cert.p12","pass") ! also we try this
LET SIG'SETX509CERT(CERT,1) ! this give an error 88 Invalid/unknown property name
LET SIG'SETX509CERT(C,1) !this give an error 88 Invalid/unknown property name ! also we try this
#2
Web Services / Unexpected Response in an HTTP Request
September 04, 2025, 05:09:59 PM
Hello everyone, we are working with a third party API that we send xml files, and we are getting an unexpected response when we tried to post a file using the pxplus *plus/web/request utility, but when we use postman we get the expected response, we compare the raw http post, and initially we don't find any relevant differences.

this example of what we send from pxplus:
POST https://web.com/endpoint HTTP/1.1
Content-Type: multipart/form-data; boundary=----PxPlusFormDataBoundary_jqePihSICwS9OCggqvv6pcSWx53Sr4PI
Content-Length: 5506
User-Agent: CustomApp/3.5.1
accept-encoding: gzip, deflate, br
Accept: application/json
Authorization: bearer yJhbGciOiJIUzIfQ.VDMfa9MhV...
Host: web.com
Cache-Control: no-cache

------PxPlusFormDataBoundary_jqePihSICwS9OCggqvv6pcSWx53Sr4PI
Content-Disposition: form-data; name="xml"; filename="file_name.xml"
Content-Type: text/xml

<?xml version="1.0" encoding="utf-8"?>
<XMLCONTENT>
...HH
</XMLCONTENT>

------PxPlusFormDataBoundary_jqePihSICwS9OCggqvv6pcSWx53Sr4PI--

and this is the response:
HTTP/1.0 400 Bad Request
Content-Type: text/html

<html><head><title>Error</title></head><body>
<h2>ERROR: </h2>
<br>
</body></html>



this example from Postman:
POST https://web.com/endpoint HTTP/1.1
Authorization: Bearer yJhbGciOiJIUzIfQ.VDMfa9MhV...
User-Agent: PostmanRuntime/7.39.1
Accept: */*
Cache-Control: no-cache
Postman-Token: 84e36083-e8d2-45c0-a796-8ceba.......
Host: web.com
Accept-Encoding: gzip, deflate, br
Connection: keep-alive
Content-Type: multipart/form-data; boundary=--------------------------016854827228628556451404
Cookie: citrix_ns_id=AAI7XMG5aDvuodAGAAAAADtph5H_folAahaJO3ZgXF47eTRF6UPCLl86FZ_BO32DOw==Wci5aA==DQb-sHYMQEWeET5gyA37CgIG7zs=
Content-Length: 5500

----------------------------016854827228628556451404
Content-Disposition: form-data; name="xml"; filename="file_name.xml"
Content-Type: application/xml

<?xml version="1.0" encoding="utf-8"?>
<XMLCONTENT>
...HH
</XMLCONTENT>

----------------------------016854827228628556451404--

and the response is the expected json.

so What could be causing us not to have the same response in pxplus?

thanks in advance,
HendersonS.

#3
Programming / Sign XML Documents with Digital Signatures
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
#4
ODBC / ODBC Views Issue
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
#5
Webster Plus / Webster Queries
April 05, 2023, 01:11:02 PM
Hello everyone !

In webster plus, queries don't have a search field?
#6
iNomads / Bar Code Reading in iNomads
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"
#7
iNomads / Fav Icon On Inomads
May 17, 2022, 10:40:37 AM
Hello everyone,

Is there a way to put a custom favorite icon in the inomads template?
#8
iNomads / how to extract a value passed in the url
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.

#9
Nomads / Classic Query
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?
#10
Off Topic / Oferta de Trabajo
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
#11
iNomads / How To Call DLLs With Inomads
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?
#12
iNomads / Screen Size
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.
#13
iNomads / Inomads Error
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?


#14
Nomads / inomads color manage
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?
#15
Language / Problems with Report viewer
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?
#16
Wish List / Add Feature to Viewer.
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.

#17
Language / 'TEXT' mnemonic.
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)
#18
Programming / Working with DLL
May 13, 2020, 11:44:38 AM
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.
#19
Programming / Justify Fuction like ms word
December 09, 2019, 12:50:39 PM
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.
#20
Programming / Error to Generate a QRcode
September 25, 2019, 12:17:45 PM
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
Pages1 2