1. John Strack
  2. PowerBuilder
  3. Tuesday, 26 June 2018

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!

Shenn Sellers Accepted Answer Pending Moderation
0
Votes
Undo

I'm having issues posting my image...

Comment
There are no comments made yet.
  1. Thursday, 28 June 2018
  2. PowerBuilder
  3. # 1
Shenn Sellers Accepted Answer Pending Moderation
0
Votes
Undo

Comment
There are no comments made yet.
  1. Wednesday, 27 June 2018
  2. PowerBuilder
  3. # 2
Shenn Sellers Accepted Answer Pending Moderation
0
Votes
Undo

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
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. Shenn Sellers
  2. Thursday, 28 June 2018
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. Shenn Sellers
  2. Thursday, 28 June 2018
thank you!

  1. Marco Meoni
  2. Friday, 29 June 2018
There are no comments made yet.
  1. Wednesday, 27 June 2018
  2. PowerBuilder
  3. # 3
Michael Kramer Accepted Answer Pending Moderation
0
Votes
Undo

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
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. John Strack
  2. Wednesday, 27 June 2018
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. Michael Kramer
  2. Thursday, 28 June 2018
There are no comments made yet.
  1. Tuesday, 26 June 2018
  2. PowerBuilder
  3. # 4
  • Page :
  • 1


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