charlotte powerbuilder...
TRANSCRIPT
Sponsored by Powered by
Moving at the Speed of Change May 2015
Charlotte PowerBuilder Conference
Imaging Web Application
For PowerBuilder, Appeon Web & Appeon Mobile
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
• Email: [email protected] • Blog: http://chrispollach.blogspot.ca • PBDJ: http://chrispollach.sys-con.com • LinkedIn: http://ca.linkedin.com/in/chrispollach • SourceForge: http://sourceforge.net/projects/stdfndclass • S.T.D.: http://www.softdie.ca
2 Human Image Redaction!
An Actual Implementation Case Study!
By Chris Pollach – President: Software Tool & Die Inc.
Ottawa, Canada
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
3 Problem?
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
4 Architecture Approach & Strategy
Dual deployment
strategy improves
chances of getting to
production.
Browser 1st choice
(GOC standard)
+
Bonus: Can use PB’s
internal debugging,
tracing, and profiling
features during
development!
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
5 Used the STD Framework – Web Design
Check out my Web
Design session at the
NCPBUG Conference
for all the details on
how to build a modern
website using PB &
Appeon!
DB Blobs
Database App_Form
Image
Supporting
Doc_Image
JPG, BMP, TIF,
PNG, etc images
using various
compression
schemes!
Scroll, pan, full screen mode, highlight
target area, identify image type/metrics, etc
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
Deciding on a DW Approach?
DataWindow Image Feature
• InkEdit
• InkPicture
• TableBlob
• Picture
• Display as Picture
Supported by Appeon
• No
• No
• No
• Yes (use Modify method)
• Yes (column value)
6
Various Image Types
Original Size
Transparency
Bitmap Type Only
AutoSize Height
No coding
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
7 Use an “Image” based External DataWindow!
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
8 Client Strategy – Image Transfer
Browser
Cache
Image
DB Blobs
Database App_Form
Image
Supporting
Doc_Image
• SelectBlob? • UpdateBlob?
• FTP?
• File Transfer? of_appeonupload () of_appeondownload ()
Appeon Only
PB+Appeon
TEMP
Image
Framework
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
Web Service
9 Image Format & Compression Strategy
-list compress (ImageMagick) B44
B44A
BZip
DXT1
DXT3
DXT5
Fax
Group4
JBIG1
JBIG2
JPEG
JPEG2000
Lossless
LosslessJPEG
LZMA
LZW
None
Piz
Pxr24
RLE
Zip
RunlengthEncoded
ZipS
DB Blobs
Database Image #1
Image #2 ...
Bitmap
Image
ImageMagicK No Compression
SelectBlob +
FileWriteEx ( )
- compress none bitmap
Browser
Cache
Image
SetItem (<name>.bmp)
- compress Group4 <ImageType>
Application Server
PPI
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
10 Leveraging the Web Service Architecture
Appl.
Image
Web Service (*)
Command Shell (+)
Imaging (#)
Framework (@)
Log
WSDL
Application Server
Appeon
Web (*)
WDSL (proxy)
Framework (@) Appl.
Image Appl.
Image
Appl.
Image
Ap
pl
Imag
e
Redact Rotate Flip DeSkew
Appl.
Image
Conversion
Appl.
Image
Information
Legend * - PB & Appeon Web
+ - MS-Windows “PowerShell” API.
@ - STD Foundation Classes
# - ImageMagicK
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
11 Locating Credit Card Information
Tesseract
OCR
Image
MagicK
*
-- -
-- -
OCR
#1
*
OCR
#2
-- -
-- -
Applicant +
Supporting
X1,Y1,X2,
Y2
*
*
-- -
-- -
OCR
#nn
OCR
Coordinates
OCR target
areas
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
12 Highlight & Auto Scroll!
Note: PPI vs PBU!
Tip: Double-Click to go to full screen!
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
13 Image Manipulation all by WS’s!
Web Service
Bitmap
Image
ImageMagicK
- compress none bitmap
Ap
plicatio
n S
erver
PPI
Appl.
Image
Appl.
Image
Ap
pl
Imag
e
Appl.
Image
Appl.
Image
1) Web Service Call SessionID, ImageID
+1 or 0,-1
2) SelectBlob
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
Targeting your quarry!
Allow Rectangle to Move Use Drag & Drop
14
Note: Does not work in Appeon!
Works in Appeon & PowerBuilder!
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
15 Redacting your quarry (Step 1)!
Digital Signature
Redaction Signature
Audit Info
Web Service
Bitmap
Image
ImageMagicK No Compression
Application Server
PPI PBU
PBUx ImageX
------- = ----------
DW_Height ImageHeight
PBUx
ImageX = ---------- x ImageHeight
DW_Height
Web Service Call SessionID, ImageID
X,Y,W,H
Digital Signature
Redaction Signature
Audit Info
PPI
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
16 Deriving the proper X,Y (Step 2)
DW
Control
Scro
llbar
RealX = ScrollHeight (X1) + DCx (X2)
X1
X2
PBU
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
17 Redacting your quarry (Step 3)!
Dig
ital Sig
natu
re
Red
action S
ignatu
re
Audit In
fo
Web Service
ImageMagicK No Compression
Application Server
PPI
PBU
Web Service Call SessionID, ImageID
Digital Signature
Redaction Signature
Audit Info
?
X1
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
18 Saving the completed Image 18
Digital Signature
Redaction Signature
Audit Info
Web Service
Bitmap
Image ImageMagicK
No Compression
Application Server
PPI Web Service Call SessionID, ImageID
Digital Signature
Redaction Signature
Audit Info
-list compress (ImageMagick) B44
B44A
BZip
DXT1
DXT3
DXT5
Fax
Group4
JBIG1
JBIG2
JPEG
JPEG2000
Lossless
LosslessJPEG
LZMA
LZW
None
Piz
Pxr24
RLE
Zip
RunlengthEncoded
ZipS
DB Blobs
Database Image #1
Image #2 ...
- compress Group4 <ImageType>
Digital Signature
Redaction Signature
Audit Info
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
Building the future on the past!
Future Applications
• PCM PhotoCard Manager
• Remedy Incident Management
Reusability
• STD Frameworks (100%)
• OCR Web Service (90%)
• Image Web Service (90%)
• LDAP Web Service (100%)
19
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
Questions?
20 Q&A Session
Charlotte PowerBuilder Conference Moving at the Speed of Change May 2015
Have you hugged your DataWindow today? 21