127
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 2
INTRODUCTION & KEY BENEFITS ................................................................................................................... 11
INSTALL / REMOVE ............................................................................................................................................... 13
Selecting a Version: 8.5, 9, or 11 (XI R2) ......................................................................................................... 13
STEP 1: SELECT REPORT..................................................................................................................................... 15
STEP 2: PREVIEW ................................................................................................................................................... 17
S
PEEDING
U
P
R
EPORT
P
REVIEWS
............................................................................................................................ 18
C
HANGING
P
ROCESSING
O
PTIONS WITHOUT
P
REVIEWING
....................................................................................... 18
C
HANGING
L
OGIN
,
R
EPORT
P
ATHS
&
O
THER
S
ETTINGS WITHOUT
P
REVIEWING
..................................................... 18
Find & Replace Report Paths and other Saved Settings ..................................................................................... 19
Disabling Find & Replace Categories ................................................................................................................ 19
S
AVE AND
R
EUSE
N
AMED
P
ARAMETER
S
ETS
.......................................................................................................... 20
STEP 3: EXPORT/BURST
/EMAIL…
.................................................................................................................... 22
G
ROUP
V
ALUES
A
REA
............................................................................................................................................. 23
F
IELDS
&
F
ORMULAS
A
REA
.................................................................................................................................... 24
E
XPORTING
/B
URSTING
/P
RINTING
O
PTIONS
A
REA
................................................................................................... 25
Exporting to Multiple Files/Formats In a Single Pass ........................................................................................ 25
Replacing Illegal Characters in Dynamic File Names........................................................................................ 26
E
MAIL
O
PTIONS
A
REA
............................................................................................................................................. 27
Combining Static & Dynamic Content .............................................................................................................. 27
Specifying SMTP Server (optional) ................................................................................................................... 28
Embedding Report as Image in Email Message Body ....................................................................................... 29
Embedding Pivot Tables in Email Message Body ............................................................................................. 30
Embedding HTML Export in Email Message Body .......................................................................................... 31
Embedding TEXT Export in Email Message Body ........................................................................................... 32
Embedding File(s) Content in Email Message Body ......................................................................................... 32
Sending Message Text as HTML ....................................................................................................................... 33
Integrated HTML Editor .................................................................................................................................... 34
Embedding Images inside the HTML email body (old email engine
–
no longer available) ............................. 34
Embedding Images inside the HTML email body (2009 email engine) ............................................................. 34
Dynamic Tables inside HTML Email Messages ................................................................................................ 35
Applying Alternating Row Color ....................................................................................................................... 38
Embedding Hyperlinks to Reports/Files inside HTML Email Messages ........................................................... 39
Using Cascading Style Sheets (CSS) in HTML messages ................................................................................. 40
Attaching Multiple Files..................................................................................................................................... 41
Attaching Optional Files .................................................................................................................................... 41
Specifying Multiple (Simple/Composite) Email Addresses ............................................................................... 42
Specifying Email Distribution Lists in Text Files .............................................................................................. 42
Specifying Email Distribution Lists in SQL Queries ......................................................................................... 43
Specifying Bursting email Addresses in a Formula ........................................................................................... 44
Specifying an Email Reconnect Option for Email Bursting ............................................................................... 44
Specifying a Different Character Set .................................................................................................................. 44
Skipping Emails (VC_Skip_Email) ................................................................................................................... 44
N
EW
E
MAIL
E
NGINE
............................................................................................................................................... 45
Key Features ...................................................................................................................................................... 45
167
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 3
Q
UEUING
E
MAILS
&
T
HE SMTP
Q
S
ERVICE
.............................................................................................................. 47
Monitoring Email Queuing ................................................................................................................................ 47
smtpQ Administration ........................................................................................................................................ 48
Naming Scheme of .eml Files ............................................................................................................................ 49
smtpQ Service Failure Action Properties ........................................................................................................... 50
Slowing Down Outgoing Emails ........................................................................................................................ 51
G
ENERATING
T
WITTER OR
SMS
M
ESSAGES VIA
E
MAIL
.......................................................................................... 52
‘S
TART
P
ROCESS
’
BUTTON AND
P
ROGRESS
W
INDOW
.............................................................................................. 53
S
CHEDULING
A
REA
................................................................................................................................................. 54
Scheduling String ............................................................................................................................................... 54
Arguments .......................................................................................................................................................... 54
Scheduled Printing ............................................................................................................................................. 54
SCHEDULING (NEW APPROACH) ...................................................................................................................... 55
M
ANAGEMENT
&
M
ONITORING OF
S
CHEDULED
T
ASKS
.......................................................................................... 55
A
DDING
S
CHEDULED
T
ASKS
.................................................................................................................................... 56
D
ATA
L
INK
V
IEWER
R
EQUIREMENT
......................................................................................................................... 57
Free DataLink Viewer License .......................................................................................................................... 57
Set DataLink Viewer to Run as Administrator ................................................................................................... 57
SCHEDULING (OLD APPROACH) ....................................................................................................................... 58
P
LACE THE COMMAND LINE IN A BATCH
(.
BAT
)
FILE
................................................................................................ 58
Command Line Wizard (Parameters & Skip Zero Records) .............................................................................. 59
P
ROCESSING OF
M
ULTIPLE
R
EPORTS IN A
S
INGLE
B
ATCH
(.BAT)
F
ILE
................................................................... 60
C
ALL THE
B
ATCH FILE FROM
W
INDOWS
T
ASK
S
CHEDULER
.................................................................................... 60
S
CHEDULING
I
SSUES
................................................................................................................................................ 65
Mapped
UNC File Paths................................................................................................................................ 65
Windows 7/8 Task Scheduler ............................................................................................................................. 65
Hide Batch (Command) Windows ..................................................................................................................... 66
C
ONTROL
P
ROCESSING
O
PTIONS
W
HEN
E
NCOUNTERING
Z
ERO
R
ECORDS
.............................................................. 66
E-MAILING ALERT MESSAGES AND EXCEPTION REPORTS.................................................................... 67
USING COMMAND LINE ARGUMENTS ............................................................................................................ 68
A
RGUMENTS TO
S
PECIFY
P
ARAMETER
V
ALUES
...................................................................................................... 68
Range and Multi-Value Parameters ................................................................................................................... 69
Request User Input for Certain Parameters ........................................................................................................ 69
Null Values ........................................................................................................................................................ 69
Date Constants ................................................................................................................................................... 70
Custom Calendars .............................................................................................................................................. 71
Adjusting Data Constants for Day of Week ....................................................................................................... 72
Number Constants .............................................................................................................................................. 73
Reports with More Than 8 Parameters (restriction removed, 6.2002) ............................................................... 74
Using Parm8 to Specify all Extra Parameter Values .......................................................................................... 74
Using PowerShell to Set Relative Date Parameters and Call Visual CUT ......................................................... 75
Using Command Line Argument to Set Formula Expressions .......................................................................... 76
A
RGUMENTS TO
S
PECIFY
P
RINTER
D
ESTINATION
.................................................................................................... 77
Printing to Multiple Printers ............................................................................................................................... 77
231
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 4
Using a Text File to Specify Multiple Printers ................................................................................................... 77
A
RGUMENTS TO
S
PECIFY
P
RINTER
B
URSTING
D
ESTINATION
................................................................................... 78
S
PECIFYING
N
UMBER OF
C
OPIES
............................................................................................................................. 78
S
ETTING
C
USTOM
T
EXT FOR EACH
P
RINT
C
OPY
...................................................................................................... 78
A
RGUMENTS TO
S
PECIFY
U
SER
ID
&
P
ASSWORD
.................................................................................................... 79
S
ETTING
E
NCRYPTED
P
ASSWORD
E
NTRIES
.............................................................................................................. 79
D
ATABASE
C
HOICE
F
UNCTIONALITY
(C
OMMAND
L
INE
/
GUI) ............................................................................... 81
Selecting an Alternative ODBC Data Source ..................................................................................................... 81
Overriding the Database Specified in the Report or ODBC DSN ...................................................................... 83
Overriding ODBC Table Location (.CSV Files as Data Source) ....................................................................... 83
Overriding the Server in Native Oracle Connection .......................................................................................... 84
Selecting an Alternative SQL Server
–
OLE DB Data Source ........................................................................... 84
Changing Folder Location for Access/Excel/Pervasive/ACT! Files .................................................................. 85
A
RGUMENTS TO
S
PECIFY
E
XPORT
F
ORMAT
............................................................................................................. 86
A
RGUMENT TO
S
PECIFY
E
MAIL
P
RIORITY
............................................................................................................... 87
A
RGUMENT TO
S
PECIFY
E
MAIL
H
EADERS
............................................................................................................... 87
A
RGUMENTS TO
S
PECIFY
E
MAIL
O
PTIONS
............................................................................................................... 88
A
RGUMENTS TO
P
ROCESS
R
EPORTS WITH
N
O
S
ETTINGS
......................................................................................... 88
C
ALLING
V
ISUAL
CUT
F
ROM
A
NOTHER
A
PPLICATION
........................................................................................... 89
S
PECIFYING
A
RGUMENTS FROM THE
GUI ................................................................................................................ 90
R
EFERRING TO
S
AVED
E
NCRYPTED
P
ASSWORDS
..................................................................................................... 91
OTHER OPTIONS AND FEATURES .................................................................................................................... 92
D
ELEGATING
E
XPORTING
/B
URSTING TO
D
ATA
L
INK
V
IEWER
2011 ......................................................................... 92
T
RIGGERING A
B
ATCH
F
ILE WITH
D
YNAMIC
C
ONTENT
B
EFORE
/A
FTER
E
XPORT
.................................................... 93
Triggering Reports Based on Database, File, and Email Events ........................................................................ 94
P
RINTING
................................................................................................................................................................. 94
Bursting to Printer .............................................................................................................................................. 94
Interweaving Burst Printouts From Multiple Reports ........................................................................................ 95
Printer Job Name Functionality .......................................................................................................................... 96
ZIP
AND
P
ASSWORD
P
ROTECT
F
ILES
....................................................................................................................... 97
L
OAD INI
V
ALUES INTO
P
ARAMETERS
..................................................................................................................... 98
Securing Reports against Unauthorized Use ...................................................................................................... 98
FTP/SFTP ............................................................................................................................................................... 99
Exporting to an FTP Server (old approach) ....................................................................................................... 99
Uploading to an FTP Server (new approach) ................................................................................................... 100
Uploading to an SFTP Server ........................................................................................................................... 101
Downloading from an FTP Server ................................................................................................................... 102
E
XTRACT
F
ILES
S
TORED IN
D
ATABASE
................................................................................................................. 103
F
ILE
L
OCATION
F
UNCTIONALITY
........................................................................................................................... 104
Automatic Handling of Write-Protected Application Folders .......................................................................... 104
D
IRECTING THE
V
ISUAL
CUT
DATABASE TO
A
NOTHER
DBMS ............................................................................ 105
273
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 5
U
PDATING
D
ATA
L
INK
_V
IEWER
.
INI VIA A
D
ELTA
F
ILE
......................................................................................... 106
R
ESTRICTING
U
SER
A
CTIONS
................................................................................................................................ 107
I
NTEGRATED
I
NTERACTIVE
A
UTHENTICATION
...................................................................................................... 108
Integrated Authentication ("Remember Me") .................................................................................................. 108
Shared Machine Authentication ....................................................................................................................... 109
AUTO-REFRESHING WEB DASHBOARDS ..................................................................................................... 110
W
EB
D
ASHBOARD
E
XPERT
.................................................................................................................................... 110
IF
RAME
A
PPROACH
............................................................................................................................................... 111
P
REVENTING
F
ILE
L
OCKING
.................................................................................................................................. 111
C
ASE
S
TUDY
.......................................................................................................................................................... 111
H
YPERLINKS
.......................................................................................................................................................... 112
T
OOLTIPS
............................................................................................................................................................... 112
G
ENERATING
HTML
VIA
E
MAIL
M
ESSAGE
B
ODY
................................................................................................. 112
C
LEANING PNG
F
ILE
R
EFERENCES
......................................................................................................................... 113
R
ESTRICTING
A
CCESS TO
W
EB
D
ASHBOARDS
....................................................................................................... 113
PDF FUNCTIONALITY......................................................................................................................................... 114
C
REATING
B
OOKMARKS
(G
ROUP
T
REE
)
IN
E
XPORTED
PDF
F
ILES
[O
LD
A
PPROACH
] ........................................... 114
Controlling PDF Bookmark Colors (& Text) ................................................................................................... 115
Controlling How Many Bookmark Levels Are Initially Expanded .................................................................. 116
Guarding Against Null Bookmark Values ....................................................................................................... 116
Generating PDF Bookmarks from within Subreports ...................................................................................... 117
A
DDING
B
OOKMARKS
U
SING
C
RYSTAL
F
ORMULAS AS
T
AGS
[N
EW
A
PPROACH
] .................................................. 118
Setting Up a Crystal Report with pdf formula tags .......................................................................................... 118
A
DDING A
T
ABLE OF
C
ONTENT TO A
PDF
F
ILE
..................................................................................................... 120
Advanced Table of Content Options ................................................................................................................ 121
A
DDING
P
AGE
N
UMBERS TO A
PDF
F
ILE
............................................................................................................... 122
A
DDING
W
EB
/F
ILE
/
EMAIL
H
OTSPOT TO A
PDF
F
ILE
............................................................................................. 123
A
DDING AN
I
MAGES WITH AN
O
PTIONAL
H
OTSPOT TO A
PDF
F
ILE
....................................................................... 124
A
DDING
L
INKS
/I
MAGES TO
F
ILES
/P
AGES
U
SING
C
RYSTAL
F
ORMULAS AS
T
AGS
................................................... 125
Setting Up a Crystal Report with pdf field tags ............................................................................................... 125
Formula Example from the Sample Report ...................................................................................................... 126
E
MBEDDING
F
ILES AS
A
TTACHMENTS INSIDE A
PDF
F
ILE
..................................................................................... 127
A
DDING
L
INKS AND
E
MBEDDED
F
ILES
U
SING
C
RYSTAL
F
ORMULAS AS
T
AGS
...................................................... 128
Setting Up a Crystal Report with Link_Tag Formulas ..................................................................................... 128
Formula Example from the Sample Report ...................................................................................................... 129
A
DDING
L
INKS TO
F
ILES BY
D
ETECTING
F
ILE
R
EFERENCES IN
PDF
T
EXT
............................................................ 131
Detecting Additional File References Using Wild Card Tokens ...................................................................... 132
A
DDING
D
IGITAL
S
IGNATURE TO A
PDF
F
ILE
....................................................................................................... 133
E
NCRYPTING
&
P
ROTECTING A
PDF
F
ILE
.............................................................................................................. 134
M
ERGING
PDF
F
ILES
............................................................................................................................................. 135
180
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 6
Dynamic File Names ........................................................................................................................................ 136
Using a Text File to Specify Files for Merging ................................................................................................ 137
Using Wild Cards to Specify Files for Merging ............................................................................................... 137
Controlling Merged Bookmark Colors ............................................................................................................. 137
Specifying Bookmarks when Merging PDF Files ............................................................................................ 138
Using the Merged File Names to Generate Bookmarks ................................................................................... 139
Using the Merged File Names to Generate Multi-Level Bookmarks ............................................................... 140
M
ERGING
1-P
AGE
PDF
F
ILES INTO
L
AYERS IN A
S
INGLE
PDF
F
ILE
...................................................................... 141
Dynamic File Names ........................................................................................................................................ 141
Using a Text File to Specify Files for Merging ................................................................................................ 142
Controlling Layer Name & Visibility .............................................................................................................. 142
P
RINTING
PDF
F
ILES
............................................................................................................................................. 143
PDF_Print......................................................................................................................................................... 143
PDF_Clone_And_Print .................................................................................................................................... 144
Printing PDF Files To Multiple Printer Trays .................................................................................................. 145
Using PDF_Print_Split ..................................................................................................................................... 145
Using PDF_Print_Split_Tag ............................................................................................................................ 146
Controlling Print Quality/Speed ....................................................................................................................... 147
A
DDING
B
ACK
-P
AGES
........................................................................................................................................... 148
Using PDF_Insert_BackPage ........................................................................................................................... 148
S
AVING
PDF
F
ILES TO
I
MAGE
F
ILES
...................................................................................................................... 149
A
DDING
F
ORM
F
IELDS
&
S
UBMIT
B
UTTONS TO
PDF
F
ILES
................................................................................... 150
Sample PDF File with Form Fields & Submit Buttons .................................................................................... 150
Sample Crystal Report with Formulas as Form Field Tags .............................................................................. 151
Setting Up a Crystal Report with pdf field tags ............................................................................................... 151
Formula Example from the Sample Report ...................................................................................................... 151
Populating Form Field Text or Description via ODBC Query ......................................................................... 153
F
ILLING
PDF
F
ORMS
............................................................................................................................................. 154
Setting Up a Crystal Report to Act as a PDF Form Filler ................................................................................ 154
Setting Up the Report in Visual CUT .............................................................................................................. 154
S
ETTING
PDF
D
OCUMENT
P
ROPERTIES AFTER
E
XPORT
(A
UTOMATIC
) ................................................................. 155
F
LATTEN
PDF
F
ILES
.............................................................................................................................................. 156
S
ETTING
PDF
D
OCUMENT
P
ROPERTIES
................................................................................................................. 157
B
UILDING AN
I
NDEX
PDF
D
OCUMENTS
................................................................................................................. 158
A
DDING AN
I
NDEX
F
ILE TO A
PDF
D
OCUMENT
..................................................................................................... 159
A
DDING
M
ULTIMEDIA TO
PDF
D
OCUMENT
........................................................................................................... 160
I
MPORTING
M
ULTI
-P
AGE
TIFF
F
ILES INTO
PDF
F
ILES
.......................................................................................... 161
I
MPORTING
I
MAGE
F
ILES AS
N
EW
P
AGES
(T
AG
A
PPROACH
).................................................................................. 162
S
PLITTING
PDF
F
ILES
............................................................................................................................................ 163
Splitting By Bookmarks ................................................................................................................................... 163
Splitting By Embedded Tags ............................................................................................................................ 164
Splitting and Protecting PDF Files By Embedded Tags ................................................................................... 165
C
OMPRESS
PDF
F
ILES
........................................................................................................................................... 167
305
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 7
L
INEARIZE
(
WEB
-
ENABLE
)
PDF
F
ILES
................................................................................................................... 168
E
XPORT TO
PDF
VIA
MS
WORD .......................................................................................................................... 169
EXCEL FUNCTIONALITY ................................................................................................................................... 170
E
XPORTING TO
E
XCEL
2007
(.
XLSX
)
F
ILES
............................................................................................................ 170
C
OMBINING
E
XCEL
B
URSTING
E
XPORTS INTO A
S
INGLE
M
ULTI
-T
AB
S
PREADSHEET
............................................ 171
A
DDING
E
XCEL
E
XPORTS AS
T
ABS IN
E
XISTING
/N
EW
S
PREADSHEETS
(B
RIEFING
B
OOKS
) ................................... 172
Appending or Replacing Data for Existing Tabs ............................................................................................. 172
C
ONTROLLING
E
XCEL
T
AB
C
OLORS
...................................................................................................................... 173
S
ETTING
U
P
P
RINT
P
ROPERTIES FOR
E
XCEL
W
ORKBOOKS
.................................................................................... 174
A
UTO
F
ILTER
&
F
REEZE
P
ANES IN
E
XCEL
E
XPORTS
.............................................................................................. 175
C
OLUMN
A
UTO
F
IT IN
E
XCEL
E
XPORTS
................................................................................................................. 175
P
ASSWORD
P
ROTECTING
E
XCEL
W
ORKBOOKS
...................................................................................................... 176
P
ROTECTING
E
XCEL
W
ORKSHEETS AGAINST
U
SER
V
IEWING
/E
DITING
.................................................................. 177
I
NSERTING
F
ILE
E
XPORTS INTO
E
XCEL
T
EMPLATES
.............................................................................................. 178
Sample Input & Output .................................................................................................................................... 179
I
NSERTING
C
RYSTAL
V
ALUES INTO
E
XCEL
T
EMPLATES
........................................................................................ 180
Specifying Named Ranges in the Excel Template and Matching Formulas in Crystal .................................... 180
Crystal Formula Content for Multi-cell and multi-row Named Ranges ........................................................... 181
Populating Multiple Named Ranges................................................................................................................. 182
Before & After Images ..................................................................................................................................... 183
T
RANSFERRING
T
ABS
T
O
A
NOTHER
W
ORKBOOK
.................................................................................................. 184
S
PLITTING
E
XCEL
W
ORKBOOKS BY
T
ABS
............................................................................................................. 185
S
PLITTING
E
XCEL
W
ORKBOOKS BY
F
IRST
C
OLUMN
.............................................................................................. 186
G
ENERATING
E
XCEL
P
IVOT
T
ABLES
...................................................................................................................... 187
R
EFRESHING
D
ATA
(Q
UERIES
,
P
IVOT
T
ABLES
)
FROM ALL
C
ONNECTIONS
............................................................. 190
R
UNNING AN
E
XCEL
M
ACRO
................................................................................................................................. 191
R
EPLACING
C
ONTENT IN
E
XCEL
F
ILES
.................................................................................................................. 192
Exporting Formula Expressions to Excel, and Activating Them ..................................................................... 192
C
ONVERT
XLS
F
ILES TO
XLSX
(
AND MERGING SHEETS
) ...................................................................................... 193
C
ONVERT
E
XCEL
F
ILES TO
PDF ............................................................................................................................ 194
C
ONVERT
E
XCEL
F
ILES TO
HTML ........................................................................................................................ 195
C
ONVERT
E
XCEL
F
ILES TO
CSV ............................................................................................................................ 196
C
ONVERT
E
XCEL
F
ILES TO
TEXT ......................................................................................................................... 197
MS WORD FUNCTIONALITY............................................................................................................................. 198
P
ROTECTING
MS
WORD
F
ILES
............................................................................................................................. 198
I
NSERTING
C
RYSTAL
V
ALUES INTO
MS
W
ORD
D
OCUMENTS
................................................................................ 199
Specifying Field/Formula References (tags) in the Word document ............................................................... 199
Populating Word Tables with Crystal Formula Data ....................................................................................... 201
R
EPLACE
F
ORMATTING IN
MS
WORD
F
ILES
........................................................................................................ 203
207
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 8
P
RINTING
MS
WORD
F
ILES
.................................................................................................................................. 204
P
RINTING
MS
WORD
F
ILES WITH
W
ATERMARKS
................................................................................................ 205
C
ONVERT
WORD
F
ILES TO
PDF ........................................................................................................................... 206
TEXT FUNCTIONALITY ..................................................................................................................................... 207
S
PLITTING
T
EXT
F
ILES BY
E
MBEDDED
T
AGS
......................................................................................................... 207
M
ERGING
T
EXT
F
ILES
........................................................................................................................................... 208
R
EPLACING
C
ONTENT IN
T
EXT
F
ILES
.................................................................................................................... 209
R
EMOVING
B
LANK OR
S
HORT
L
INES IN
T
EXT
F
ILES
.............................................................................................. 210
R
EMOVING
GUID
S FROM PNG
F
ILES
R
EFERENCED IN
HTML
E
XPORTS
................................................................ 211
R
EPLACING
C
ONTENT IN
T
EXT
/HTML
F
ILES
–
T
OKEN
A
PPROACH
....................................................................... 212
I
NSERTING
B
ASE
64-E
NCODED
F
ILES
I
NSIDE
T
EXT
/XML ...................................................................................... 214
C
HANGING
T
EXT
F
ILE
E
NCODING
......................................................................................................................... 215
ODBC EXPORT FUNCTIONALITY ................................................................................................................... 216
Append Functionality ....................................................................................................................................... 216
Replace Functionality ....................................................................................................................................... 216
CAPTURING & PROCESSING INCOMING EMAILS ..................................................................................... 217
U
SE
S
CENARIOS
..................................................................................................................................................... 217
T
RIGGERING
E
MAIL
C
APTURE
............................................................................................................................... 220
[E
MAIL
_G
ET
]
INI
S
ECTION
.................................................................................................................................... 220
E
MAIL
G
ET
D
IRECTIVE
S
ECTIONS
.......................................................................................................................... 221
C
APTURING
E
MAILS
.............................................................................................................................................. 222
Phase 1: Header Download & Filtering ........................................................................................................... 222
Phase 2: Targeted Download & Database Capture .......................................................................................... 223
Monitoring Results of the Process.................................................................................................................... 223
E
MAIL
C
APTURE
T
ABLE
S
TRUCTURE
.................................................................................................................... 224
MS Access Table Structure .............................................................................................................................. 224
SQL Server Table Structure ............................................................................................................................. 225
Oracle Table Structure ..................................................................................................................................... 226
MONITORING VISUAL CUT PROCESSING ................................................................................................... 227
L
OGGING AND
M
ONITORING
V
ISUAL
CUT ............................................................................................................ 227
‘Log Email Activity’ option
............................................................................................................................. 227
Silent Unattended Failure Option ..................................................................................................................... 228
Silent Attended Failure Option ........................................................................................................................ 229
Avoiding Duplicate Processing ........................................................................................................................ 230
Avoiding Too Many Active Visual CUT Instances (Queuing) ........................................................................ 231
J
OB
S
TATUS
F
UNCTIONALITY
................................................................................................................................ 232
F
AILURE
A
LERTS VIA
E
MAIL
................................................................................................................................. 233
R
ECORD
P
ROCESSING TO AN
ODBC
D
ATABASE
.................................................................................................... 234
MS Access Database Sample ........................................................................................................................... 234
SQL Server Instructions ................................................................................................................................... 235
Process Logging Settings in Options Dialog .................................................................................................... 236
189
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 9
U
PDATE A
D
ATABASE
A
FTER
S
UCCESS
(A
FTER
_S
UCCESS
_SQL) ......................................................................... 237
SQL Server Example 1 ..................................................................................................................................... 238
SQL Server Example 2 ..................................................................................................................................... 238
U
PDATE A
D
ATABASE
B
EFORE
R
EPORT
R
UNS
(B
EFORE
_R
EPORT
_R
UN
_SQL) ..................................................... 239
C
ALL A
W
EB
S
ERVICE AFTER
S
UCCESS
(A
FTER
_S
UCCESS
_HTTP) ....................................................................... 240
Sending SMS Messages ................................................................................................................................... 240
T
RIGGER
D
YNAMIC
B
ATCH
F
ILE AFTER
S
UCCESS
(A
FTER
_S
UCCESS
_B
ATCH
) ...................................................... 241
Dynamic References to Fields/Formulas within the Batch File ....................................................................... 241
Logging to a text file ........................................................................................................................................ 241
TABLE OF COMMAND LINE ARGUMENTS .................................................................................................. 243
UPDATE HISTORY ............................................................................................................................................... 250
V
ERSION
6.9002:
E
NTERED
T
ESTING
A
PRIL
24,
2016 ............................................................................................ 250
Fixes ................................................................................................................................................................. 251
V
ERSION
6.9001:
R
ELEASED
N
OVEMBER
21,
2015 ................................................................................................ 253
Key Features .................................................................................................................................................... 253
Excel Features .................................................................................................................................................. 254
PDF Features .................................................................................................................................................... 255
Email Features .................................................................................................................................................. 255
Other Features .................................................................................................................................................. 256
Fixes ................................................................................................................................................................. 256
V
ERSION
6.8001:
R
ELEASED
N
OVEMBER
16,
2014 ................................................................................................ 257
Web Dashboard and FTP/SFTP Features ......................................................................................................... 257
PDF Features .................................................................................................................................................... 257
Excel Features .................................................................................................................................................. 258
Email Features .................................................................................................................................................. 258
Other Features .................................................................................................................................................. 259
Fixes ................................................................................................................................................................. 261
V
ERSION
6.7001:
R
ELEASED
D
ECEMBER
01,
2013 ................................................................................................ 262
Email Features .................................................................................................................................................. 262
PDF Features .................................................................................................................................................... 263
Excel Features .................................................................................................................................................. 263
Web Dashboard & FTP/SFTP Features ........................................................................................................... 263
User Interface Enhancements ........................................................................................................................... 264
Command Line Arguments .............................................................................................................................. 264
Fixes ................................................................................................................................................................. 265
Other ................................................................................................................................................................ 265
V
ERSION
6.6001:
R
ELEASED
D
ECEMBER
31,
2012 ............................................................................................... 266
V
ERSION
6.5001:
R
ELEASED
J
ANUARY
26,
2012 .................................................................................................. 271
V
ERSION
6.4001:
R
ELEASED
J
UNE
01,
2011 ......................................................................................................... 276
V
ERSION
6.3001:
R
ELEASED
J
ULY
02,
2010 ......................................................................................................... 282
New PDF Features ........................................................................................................................................... 285
V
ERSION
6.2001:
R
ELEASED
N
OVEMBER
28,
2009 ............................................................................................... 287
V
ERSION
6.1001:
R
ELEASED
M
ARCH
10,
2009 ..................................................................................................... 291
V
ERSION
6.0000:
R
ELEASED
11/23/2008 .............................................................................................................. 294
3
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 10
KNOWN ISSUES AND LIMITATION ................................................................................................................. 336
Documents you may be interested
Documents you may be interested