1. John Strack
  2. PowerBuilder
  3. Tuesday, 26 June 2018 19:20 PM UTC

We are looking into implementing electronic signatures into our shipping department. The application we will integrate into is desktop only. Does anyone have any experience in doing this? Any recommendations for hardware? Any pitfalls to look out for?

Thanks for the advice!

Tom McArdle Accepted Answer Pending Moderation
  1. Friday, 17 June 2022 18:45 PM UTC
  2. PowerBuilder
  3. # 1

Shenn the pad is know working. To be honest I am not sure what changed. Perhaps a reboot did it.

I have attached a test program that I got from TOPAZ that may help others in future.

 

Thank you and sorry if I wasted any of you time

Tom

 

 

 

Attachments (1)
Comment
There are no comments made yet.
Michael Kramer Accepted Answer Pending Moderation
  1. Tuesday, 26 June 2018 19:52 PM UTC
  2. PowerBuilder
  3. # 2

Hi, digital certificates and signing are mandatory for a huge range of interfaces to government IT systems across Denmark. I did a lot of interfacing to such government systems a few years back. We wrote all the interface code in C# and then used OLE (COM Callable wrapper) to interface from PB code to C#.

PB couldn't do the job due to lack of coding/encryption/signing/secure-protocol functionality. All of that becomes available with PB 2017 R3. Bruce Armstrong did a nice presentation of these upcoming features at the German User Group Conference a couple of weeks back.

HTH /Michael

Comment
  1. John Strack
  2. Wednesday, 27 June 2018 20:23 PM UTC
Thanks Michael. It is a good starting point. You wouldn't happen to know if Bruce Armstrong's presentation is available anywhere online would you? I haven't been able to find it anywhere.

  1. Helpful
  1. Michael Kramer
  2. Thursday, 28 June 2018 19:43 PM UTC
Hi John,



I was talking about digital signing. I see other answer on electronically collecting a "normal" signature. That is certainly possible. InkEdit is one possible answer. When that is what you look for I'm sure the other answer and its comments is a great resource.



/Michael

  1. Helpful
There are no comments made yet.
Shenn Sellers Accepted Answer Pending Moderation
  1. Wednesday, 27 June 2018 17:36 PM UTC
  2. PowerBuilder
  3. # 3

We use a combination of Topaz Signature Pads for some programs and Tablet PC's for other programs.  It isn't very difficult for either approach.  The Topaz Signature Pads are easy to interface with.  Using a Tablet PC, you just use an InkEdit control.  Both ways are then saved as a Blob.  If you go either route, I can share code samples with you.

https://www.topazsystems.com/index.html

Comment
  1. Shenn Sellers
  2. Thursday, 28 June 2018 16:39 PM UTC
No, if you are using a Signature Pad, you will be using the OLE control that should be provided by the drivers for whatever control you go with.

  1. Helpful
  1. Shenn Sellers
  2. Thursday, 28 June 2018 18:05 PM UTC
Hi Marco,



I'll put the code here so others can see it as well.  





//Opens the Signature Capture Window



Open(w_sign)



 



/* The code below is the OK Button code on the "w_sign" Window */



 



//Stores the signature (I've discovered that the Signature Files I store are not very large, so I can store them in a String.  You could easily change it to a blob



//if your needs are larger



ls_signature = ole_SigPlus1.object.SigString



 



//Preparing the signature to be saved



ole_SigPlus1.object.ImageFileFormat = 0 //0=bmp, 4=jpg, 6=tif



ole_SigPlus1.object.ImageXSize = 368 //width image in px



ole_SigPlus1.object.ImageYSize = 50 //height image in px



ole_SigPlus1.object.ImagePenWidth = 10 //image pen width in px



ole_SigPlus1.object.JustifyMode = 5 //zoom signature



 



//Saves the Signature as an image (I do this so I can display the signature anywhere in the program using a Picture Control)



ole_SigPlus1.object.WriteImageFile("C:\_APPS\TaDTP\issuer_sig.bmp")



 



//Closes the Signature Capture window

CloseWithReturn(parent, ls_signature)



 



/* End of the OK Button code on the "w_sign" Window */





 





//Error checking 



if (Message.DoubleParm = -1) then return



 



//Obtains the returned Signature (Stored as a string, but you can do blobs.  Blobs would require a little different code for saving).



ls_signature = Message.StringParm



 



//Sets the Signature into a string column (Saved by DW Update as this is a string)



this.SetItem(row, "issuer_signature", ls_signature)



 



//Puts the written image file into the Picture Control



this.object.p_issuer.FileName = "C:\_APPS\TaDTP\issuer_sig.bmp"









 



Asset Window



https://drive.google.com/file/d/192cjhR5LAl8ry5iPkOEbBUShAN6zMxM_/view?usp=sharing



w_sign Window



https://drive.google.com/file/d/1ZRXK8kES7MSK3N60GnUDnjmREI5gE2Gj/view?usp=sharing



 



Signature



https://drive.google.com/file/d/1ccloPeUMtzVQb0WdOBS2VL73A4owAPby/view?usp=sharing

  1. Helpful 1
  1. Marco Meoni
  2. Friday, 29 June 2018 08:25 AM UTC
thank you!

  1. Helpful
There are no comments made yet.
Shenn Sellers Accepted Answer Pending Moderation
  1. Wednesday, 27 June 2018 19:27 PM UTC
  2. PowerBuilder
  3. # 4

Comment
There are no comments made yet.
Shenn Sellers Accepted Answer Pending Moderation
  1. Thursday, 28 June 2018 16:28 PM UTC
  2. PowerBuilder
  3. # 5

I'm having issues posting my image...

Comment
There are no comments made yet.
Tom McArdle Accepted Answer Pending Moderation
  1. Friday, 17 June 2022 14:20 PM UTC
  2. PowerBuilder
  3. # 6

Hello.

Hopefully you can help me. I have been trying to implement the process defined above.

I have the Topaz pad. I downloaded the software. I then inserted the 'SignPlus Control' OLE on my window, but it does not seem to accept any entry from the Topaz pad. I have tested the pad with the standalone software that comes with it and that works fine.

Would you have any suggestion's as to what you think I may be doing wrong?

 

Thank You

Tom

Comment
  1. Shenn Sellers
  2. Friday, 17 June 2022 16:19 PM UTC
Did you see the code I posted previously? It is further down this thread. Following that should make it work.
  1. Helpful
  1. Tom McArdle
  2. Friday, 17 June 2022 16:53 PM UTC
Thank you Shenn



I did see that and that worked if I use inkedit, but inkedit only takes input form the mouse.

When I insert the Sigplus OLE control. The OLE will not take any input from the pen pad.



Tom



  1. Helpful
There are no comments made yet.
  • Page :
  • 1


There are no replies made for this question yet.
However, you are not allowed to reply to this question.