48
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 263
The Process tab in the Options dialog now has a button called 'Encrypt & Save Password'.
It allows you to centralize & protect passwords by avoiding specifying them directly
inside command line argument. Instead, you can name, encrypt and store the passwords
inside DataLink_Viewer.ini. For detail, see "Referring to Saved Encrypted Passwords."
Added SQL_Extract_Files command line argument. Databases can store files (images,
spreadsheets, pdf, audio, etc.) within a database as binary column types. Certain workflow
scenario may require extracting these files to the file system for further processing (merging,
emailing…). This allows Visual CUT to automate such processes.
Added Use_Saved_Data_Recent command line argument. For example,
"Use_Saved_Data_Recent:60" tells Visual CUT to use saved data if it is not older than 60
minutes. Otherwise, fresh data is retrieved.
A typical use scenario is to export a report over itself (refreshing the saved data inside the
report) as well as exporting and/or emailing a requested format (Visual CUT can export to
multiple semi-colon separated files). Future requests for the same output avoid repeated data
retrievals if the saved data is fresh enough.
Note: if the source rpt/rpz file is included in the semi-colon separated list of export files, and
the process uses saved data (due to this command line argument), then the export of the
source rpt/rpt file over itself is skipped if it's not the first file in the list.
Added the ability to change folder location for ACT! (*.pad) data source files. See
"Changing Folder Location for Access/Excel/Pervasive/ACT! Files."
Added {%UserName%} to the fields/formulas area for dragging into processing options.
The Main_Files_Folder option (ini setting as well as the command line argument) now
supports dynamic substitution for any combination of the following environment variables:
%UserName%, %UserProfile%, and %Appdata%
Added TXT_Replace_Base64 command line argument. This allows automating the
process of inserting Base64-Encoded Files Inside Text exports. For example, you can export
invoice data to an XML file containing a reference to an image or pdf file. VC then replaces
the reference to the file with the content of that file encoded as Base64 (allowing conversion
from Binary to Text representation). The XML file with the embedded image file can then be
transmitted to a business partner using SFTP_Upload. For detail, see: Inserting Base64-
Encoded Files Inside Text/XML.
TXT_Merge can now handle cases where the files are merged into the first file (first file is
the target file). Also, there is no longer a need to specify the path to the target file if the path is
the same as the first source file.
Added a warning when settings for current user are managed under a VirtualStore
folder due to lack of permissions on the shared AppData or ProgramData MilletSoftware
folder.
VB.NET PDF: Basic SDK Concept of XDoc.PDF XDoc.PDF for .NET supports editing PDF document metadata, like Title, Subject, Author, Creator, Producer, Keywords, Created Date, and Last Modified Date.
edit pdf metadata; batch edit pdf metadata
47
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 264
The dialog offering automatic conversion from mapped drive to UNC path now applies also
to the email attachments option and to cases where Visual CUT is launched by double-
clicking an rpt file in File Explorer.
Added a
Enable_Auto_Conversion_to_UNC
ini option to allow automatic conversion of
rpt file, export file, and email attachment file paths from mapped to UNC convention.
When this option is set to True (default is False), mapped drive paths are automatically
converted to UNC paths after a message box is displayed to the user.
Added a
Display_Warning_Mapped_Drive
ini option to disable the dialog offering a
conversion to UNC path when loading a report from a mapped drive.
Word_Replace_Tags is now compatible with Word 2013.
Added Now_GMT_Plus_S and Now_GMT_Minus_S to the date constant functionality.
This allows setting parameters to values relative to the current universal (GMT) datetime.
Fixes
VC 11 now logs a failure and closes when a scheduled report loses connectivity to the
database in midstream (after a successful connection and while retrieving records). Also,
when the report encounters a Division by zero and other unhandled exceptions. This avoids
hanging instances of VC when such an event occurs. To disable this option, set
Detect_Lost_Connectivity=False
in DataLink_Viewer.ini
Fixed a Connect_To_SQLOLEDB command line argument scenario that might cause a
process to hang.
Fixed a problem causing the Export Burst checkbox to lose its status after using the right-click
report grid menu option of
‘Copy
.rpt and S
ettings’.
Fixed a login issue for subreports when requesting a database server change.
After_Burst_Batch, After_Export_Batch, and After_Success_Batch now generate temporary
work files (when the called batch file contains references to fields/formulas) in the temp
folder instead of in the Visual CUT main files folder. This avoids failures due to lack of
permissions.
C# PDF - Read Barcode on PDF in C#.NET Bookmark: Edit Bookmark. Metadata: Edit, Delete Metadata. Watermark: Add Watermark to PDF. Form Process. Data: Read, Extract Field Data. Data: Auto Fill-in Field
analyze pdf metadata; endnote pdf metadata
48
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 265
Version 6.7001: Released December 01, 2013
Email Features
It is now easier to monitor the status of queued emails. If an Outgoing folder is specified,
Visual CUT shows the number of email messages in the Outgoing and Undeliverable folders
in the first 2 panels of the status bar.
The panel showing the number of messages in the Outgoing Folder, also indicates if the
smtpQ service is Not Installed, Stopped, or Running.
The information is refreshed every 5 seconds:
You can now open the Outgoing folder or the Undeliverable folder by simply double-
clicking their status panel.
If the Visual CUT Outgoing Folder doesn’t match
the Outgoing folder specified for the
smtpQ service, the status bar shows this:
Added a section describing a technique for "Slowing Down Outgoing Emails." This is useful
when email queuing through the smtpQ service results in exceeding speed limits imposed by
your email service provider.
Added a user manual section about ‘Embedding Hyperlinks to Reports/Files
inside HTML
Email Messages’. A sample report demonstrating this technique is available upon request.
Added a button to the Email HTML Editor to show dynamic field names in Notepad.
When queuing emails,
’
characters (as in
O’Brien
) in the .eml file names are now removed.
This protects against emailing failures.
Updated an email processing component.
Improved handling of the optional Email_SMTP_Domain ini setting
Added optional Email_SMTP_Auth_Method ini and command line argument option. In
most cases, this setting is not needed since Visual CUT detects and automatically uses the
most secure authentication method supported by the SMTP: "NTLM", "CRAM-MD5",
"LOGIN", or "NONE".
Updated the procedure for substituting accented characters in eml file names to handle
additional Icelandic characters (
þ, Þ, æ, Æ).
47
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 266
PDF Features
Added PDF_Split_By_Bookmarks argument, allowing Visual CUT to split a pdf based on a
targeted level of bookmarks.
When using the Print_Copies argument to control the number of copies printed via the
PDF_Print argument, if the field or formula used to control the number of copies returns
a zero, the printing is skipped. This is useful in bursting scenarios where some recipients do
not want a hard copy.
Pdf processing tags are now removed even if they contain parentheses.
Fixed an issue in PDF_Auto_File_Link when the text contains literal double-quotes.
Excel Features
Visual CUT can now Replace or Append to an existing excel tab (using TabInOldFile! or
TabInOldFile_Replace! directives) even when the tab is hidden.
Also, fixed an issue with repositioning the workbook to its original selected tab.
Added XLS_Transfer_Tabs command line argument, allowing tabs to be transferred and
dynamically renamed to a new or existing workbook. This is particularly useful when bursting
report information into named ranges (XLS_Range_Insert) in a template workbook, and then
gathering the resulting tabs into a single workbook with multiple tabs.
Added XLS_Run_Macro command line argument for triggering an Excel macro.
XLS_Range_Insert
now creates folders on the fly if the target file path doesn’t exist.
XLS_Save_As can now accept a tab name as a scope argument, so a specified tab name can
be saved to a pdf file.
XLS_Save_As can now save Excel files as HTML.
Web Dashboard & FTP/SFTP Features
Expanded user manual section and added a demo of a secure auto-refreshing web
dashboard. To access the web dashboard demo use demo as the user id & password.
The TXT_DeGUID_png command line argument now handles cases where HTML exports
reference multiple image files:
1. Unique image files are renamed with incrementing index to differentiate them.
2. Identical image files (e.g. repeating logos) are consolidated into a single image file.
This avoids accumulating image files in web dashboard folders.
Fixed an FTP_Upload issue when using Active_1 as mode.
49
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 267
Added an ini file option (in the [Options] section) to disable EPSV mode when doing
Passive_1 ftp uploads or downloads:
FTP_Disable_EPSV_Mode=True
This aims at fixing timeout problems when the ftp server mishandles EPSV mode.
SFTP_Upload and FTP_Upload can now skip files that are older than N minutes. This
allows specifying files via wild card expressions but targeting only new files.
User Interface Enhancements
The text area showing the number of group values is now highlighted in red while Visual
CUT is busy loading and counting these group values.
The Option dialog has a new Database tab for setting connectivity options.
Ctrl-Shift-F1 now opens DataLink_Viewer.ini (configuration settings) in Notepad.
When a user selects the option to convert a mapped path to UNC path for a report with saved
settings, the process now checks to make sure the UNC path for that report doesn’t already
exist with saved settings.
During interactive use, the Progress window now stays on top. This reminds users to close
that window before clicking the Start button again.
During forced login scenarios, Integrated Authentication now automatically sets the Password
in the login dialog after the User ID is manually set.
Command Line Arguments
Added After_Success_Batch command line argument supporting workflow automation and
email notification after a successful completion of a Visual CUT process. Field/formula
references within the batch file are dynamically replaced with their content from the
processed report before the batch file is triggered.
Added support for specifying custom calendars as start or end points relative to date
constants. For example, this allows you to return the start or end of a the fiscal month relative
to yesterday’s date. For det
ail, see "Custom Calendars".
Added a Main_Files_Folder command line argument for specifying the location of Visual
CUT.mdb and DataLink_Viewer.ini. This is useful in scenarios where a centralized scheduler
triggers processing on behalf of multiple users who maintain settings in their own folders.
Added Word Print command line argument. Using fields/formulas you can dynamically
specify the file to be printed, the printer, and the number of copies.
Added a Word_Protect command line argument. This allows you to:
a) restrict viewing of a document to only users who know the Open Password.
47
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 268
b) restrict editing of a document to only users knows the Modify Password..
Added TXT_Remove_Short_Lines command line argument, allowing you to remove blank
or short lines in a text file. This is useful for cases where TEXT exports generate blank lines
or lines with just delimiters.
A new Set_Formulas1 command line argument allows setting of formula expressions
(provided the formula name starts with a ^ character). For detail, see the user manual section
on Using Command Line Argument to Set Formula Expressions.
Fixes
Fixed process logging when failure messages contain single quotes.
Fixed double-space handling in command line arguments.
Fixed a rare ‘Row cannot be located for updating’ error (when a report with linked dynamic
parameter reports that don’t match the connection properties of the main report) is loaded for
the first time.
Fixed tooltip display for dynamic field/formula values containing ‘&’ symbol.
Fixed handling of selective parameter refresh in an interactive use scenario.
Fixed a scenario causing the export burst checkbox to lose its checked values during
interactive use where the same report is refreshed or reloaded a 2
nd
time.
When closing the application after an interactive session, the ReportList.txt file
(1
st
tab report grid) is now transferred to the recycle bin approximately once per 10 times.
This provides a copy of the file in case it gets erased during abnormal termination of a user
session.
Other
If a link
ed dynamic parameter report uses an ODBC DSN that doesn’t exist, or if the
Set_Parameter_Rpt_to_Main_Rpt_DSN option in the ini file is set to True, the DSN of the
parameter report is automatically set to the DSN used by the main report.
You can now direct the Visual CUT database to another DBMS such as SQL Server. This is
particularly useful if you want multiple users to concurrently maintain Visual CUT settings in
the same database. This is currently available only in Visual CUT 11. For detail, see
Directing the Visual CUT database to Another DBMS.
51
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 269
Version 6.6001: Released December 31, 2012
Visual CUT can now capture and process incoming emails.
This new features supports a variety of new use scenarios, such as:
Requesting a Report via a Simple Web Form
Updating a Database via a Simple Web Form
Collecting Customer Feedback & Updating a Database via Email Links
Importing data from email file attachments into a database table
Requesting & Capturing Management Decisions Via Email
For more detail, see the new user manual section on Capturing & Processing
Incoming Emails.
You can now queue Visual CUT invocations so that at any point in time, no more than N
instances are actively processing reports. For detail, see:
"Avoiding Too Many Active Visual CUT Instances (Queuing)"
Fixed a problem with handling database connection failures during scheduled
processing. This issue could cause Visual CUT instances to hang in memory.
Reduced/improved concurrent connections to the Visual CUT.mdb. This should also fix rare
‘Error 91: Object variable or With block variable not set’ problems.
Fixed a problem caused by clicking on the Refresh button on the Preview tab. This could
cause saved Burst option for the report to be disabled.
After_Success_SQL:
a) Added support for triggering multiple SQL statements
(even for different ODBC DSNs)
b) fixed processing when bursting and ODBC logging is disabled,
c) if the SQL statement is blank, it gets skipped.
Added two options to the Report Grid right-click menu:
1. Open Containing Folder
2. Open In Crystal
Added SFTP_Upload command line argument supporting both regular as well as Private Key
authentication.
Visual CUT can now handle cases where the command line arguments are separated by
more than a single space.
Fixed a problem when connecting to OLE DB data sources.
Updated several components to latest available versions.
58
©2002-2016, Ido Millet, ido@MilletSoftware.com
Page 270
Double-clicking the Arguments field at the top of the Export/Email tab, or clicking a new
button to the right of that field, now opens an improved text editing window . The window
allows you to increase/decrease font size, and switch between a Rich and Plain text
format. The Rich text format highlights the names of acceptable command line
arguments, as well as typical delimiters. The window remembers its size and settings (font
size, text mode).
Fixed a problem with command line arguments containing ‘
"^^"
’
The ‘Change Stored Path Information’ button (Process tab in Options dialog) now also takes
care of updating file paths in the report grid (not just in Visual CUT.mdb). This is useful in
cases where you need to change report locations or where you need to move Visual CUT to
another server where the relative path to the report files is different.
Fixed an issue with Database_Path ini file entry or command line argument when used to
change the location of Excel files as a data source.
Fixed an issue with reading very large ini file entries (saved parameter values).
Added warnings when an export file
extension doesn’t
match the export format. You
can elect to turn off such future warnings.
Added an option to suppress a warning message when changing ODBC DSN.
The status bar now shows records Read >> Selected >> and Group-Filtered. Improved text
message and handling of cases where an interactively loaded report results in zero Selected or
Group-Filtered records.
Added Max Retries option to the smtpQ administration window. This allows you to control
how many attempts are made if an email queued for delivery fails to be sent. The delay before
each subsequent retry keeps increasing (from 5 seconds for the 1
st
retry up to a maximum of
20 minutes for the 10
th
retry). The default number of attempts is 7.
From email address for failure alerts can be set via a Email_Failure_Notices_From entry in
the [Options] section of DataLink_Viewer.ini.
Added a user manual section about generating Twitter or SMS messages.
Fixed a bookmark sort issue in PDF_Bookmark_Tags.
Updated pdf processing component provides faster processing and ability to handle
malformed pdf files.
When adding page numbers to pdf files, you can now instruct Visual CUT to skip the last N
pages. For detail, see ‘
Adding Page Numbers to a PDF File
’.
Documents you may be interested
Documents you may be interested
