datawatch monarch 13 release history · crash after pasting certain unicode characters into an...

Datawatch Monarch Release Notes Version 13.5August 18th, 2016

of 5

ISSUE ID RESOLVED ISSUEMOD-2266 Unable to load Files generated by Monarch in Designer v13.2.0.16464.MOD-2301 Appending data to a Excel named range with certain naming may lead to a corrupted file instead of producing an error.MOD-2446 Table View does not load when fields with names longer than 62 characters exist in a model.MOD-2453 QAT and ribbon placement setting changes are not retained between sessions.MOD-2456 Adjust Left in Report Verify not working as expected with certain numeric values.MOD-2461 Export Results Page Only Shows Aggregated Record Counts For Certain Multi-file Summary Exports. MOD-2480 Highlighting for duplicated Field Names did not persist properly.MOD-2487 No warning presented in some cases where settings were changed and a dialog was dismissed.MOD-2500 Error on opening files within zip files from a web server which does not properly support range requests.MOD-2501 Incorrect Successful Export to Tableau Server Message After Attempting an Export When the Tableau Server is not specified.MOD-2507 Model name not visible when opening from Datawatch Server Library.MOD-2508 File menu closes after clicking on 'First value of field..'MOD-2513 No error message when creating a summary with across key without a measureMOD-2518 Pasting a URL in the Open Web File Dialog does not switch to the appropriate protocolMOD-2519 Incorrect File Filter (*.zip, *.gz) After Opening A Zip File From The WebMOD-2520 Zip files not treated appropriately when invoking URLs which produce data served from a different URLMOD-2521 Typo in tooltip for HTTP and HTTPS in Open Web File dialogMOD-2523 Default Paper Orientation Not Respected When Using Quick PrintMOD-2525 Rounding errors when adding SUMs of multiple columns in a Summary formula calculation.MOD-2527 App Paths registry entry not correctly written. (Affects certain 3rd party product integrations such as Hyland and IBM CMOD)MOD-2568 Push Left/Right moves fields several times when clicking only once.MOD-2570 Field highlighting in multi-line templates not correctly synchronized with extraction rules.MOD-2584 Summary Subtotal Coloring fill does not always apply correctly when exported.MOD-2585 Command line export using a model with runtime variables may fail.MOD-2590 Difference in handling metadata for database inputs with dupllicated column names.MOD-2593 Crash when Access 2016 is installed and Rebuild Table is used.MOD-2603 Track between session folder option not working when network drive is used.MOD-2604 Incorrect text description of burst naming option.MOD-2605 Incomplete file name when burst exporting a summary.MOD-2606 Filter and Sort Macros not working in Page Header for exports to PDF and XLSX.MOD-2611 Validation of Lookup Duplicates only appears in Paste Data.MOD-2613 Close Database or Close All still maintains lock on an Excel file.MOD-2615 Row limit filter definition changes are not saved immediately in Table Design.MOD-2626 Potential crash if Office 2016 is installed, Monarch is connected to Access or Excel files, inactive for some time, then closed.MOD-2627 Windows 10 is not correctly defined in Monarch logs.


of 5

ISSUE ID RESOLVED ISSUEMOD-2634 Incorrect number of rows displayed in Data Preview when multiple reports are loaded.MOD-2635 Move Up/Down' of fields in the Field List does not refresh Data Preview.MOD-2638 Changes in Page Setup options are not saved automatically.MOD-2641 Data Preview always shows data starting from the first report, not the "active" report.MOD-2646 Hidden summary rows are present in CSV and XML exportsMOD-2651 Remove the prefix eg_ from the default generated Field NameMOD-2662 Files can't be opened from WEBDAV with specific settingsMOD-2673 Search Up finds only one instance on a lineMOD-2674 Failure to revert to previous default settings when Cancel/Close is clicked in OptionsMOD-2693 Crash when working with Korean PDFMOD-2694 Some buttons disappear in Report Design if there is an active Exclusion, Start/End Region templateMOD-2697 Templates may not extract data after open a project, changing all references, deleting templates and recreating them.MOD-2700 "Skip table" export option issue. MOD-2704 The count of specified keys for duplicate filters is not visible.MOD-2714 Inconsistent options in context menu and Report Design for Start and End Region Templates.MOD-2724 Order duplicates on Table designMOD-2725 Crash after pasting certain Unicode characters into an expression and editing.MOD-2733 Issues for Pull Left/Right functionality.MOD-2738 "Cannot import any of the columns from table" error when opening certain tables from Informix via ODBCMOD-2741 Monarch is not installed via silent mode if the user tries to install sample files to invalid folder

NEW FEATURE PDFInfo Function. Returns information from a PDF such as Author, Creation Date, Creator, Keywords, Modified Date, Page Count.NEW FEATURE PdfPage Function. Returns the page number of the PDF for the related row in the Table.NEW FEATURE Configurable Column Type Detection Sample Size for Excel inputs.

ENHANCEMENT Ability to sort the list of Filters and Sorts in the Ribbon dropdown via a rightclick menu.ENHANCEMENT Ability to create and edit Filters and Sorts in the Ribbon dropdown via a rightclick menu.ENHANCEMENT Sort creation via rightclick menu in the Table adds columns based on selection and autonames the sort.ENHANCEMENT Option to use Windows Regional Settings for date format in CSV export.ENHANCEMENT Reorder fields via Drag/Drop in the Field List.ENHANCEMENT Lookup Field usability improvementsENHANCEMENT Overwrite & Skip Options when including a Pivot Table in an Excel export.


of 5

ISSUE ID RESOLVED ISSUEDATA PREP STUDIO (MONARCH COMPLETE ONLY)DPS-216 Incorrect tool tips of Export Change List and Import Change List menu itemsDPS-408 Slow display when multi-selecting tables in Prep DataDPS-733 Scroll bar missing for long list of tables in Connector dialogDPS-743 Overlapping of statistics bar graph and count values for smaller valuesDPS-867 Zoom slider in Create Calculated Field affecting the size of the dialogDPS-925 Incomplete descriptions in create Calculated Field: Week(,) and Weekday(,) functionsDPS-962 Tool tip display after auto-matching tables with different structuresDPS-964 Reports not displaying in Report Discovery when opening multiple reports via Browse For File buttonDPS-969 Hotkey for Close and Edit Conversion options were the sameDPS-970 Hotkey display overlapping Edit Workspace Conversion optionDPS-972 Inconsistent error message related to XML files dragged into Start, Preview and PrepDPS-973 XML file with Ampersand (&) incorrectly opens after error message is displayedDPS-975 Inability to scroll down to the last row in Preview Data when window is not maximizedDPS-979 Error message screen should not display in Open File with password when exiting via the "Cancel" buttonDPS-987 Changes of data type Text to Numeric in Append Helper not retainedDPS-998 Screen display issues truncating values at the right margin in Prep DataDPS-1000 Scrolling not working when dragging to move columns in Column Information beyond visible rangeDPS-1003 Inability to edit a Transformed sub-table in a complex load planDPS-1005 Unable to display foreign characters when using XML and HTML ANSI-Encoded fileDPS-1007 Error when opening XML containing ANSI-Encoded foreign characters in column nameDPS-1011 Truncation of column header display upon initial loading into Prep DataDPS-1066 Failed Exports of large data sets to IBM Watson AnalyticsDPS-1074 Double-clicking inconsistency when selecting items in Calculated Field dialogDPS-1075 Crash when attempting a calculation with Stuff functionDPS-1081 Blank Report Discovery when accessing certain password protected PDF filesDPS-1100 Incorrect values produced with using Ditto in conjunction with certain Calculated field formulasDPS-1103 Crash when attempting to connect to SQL Server with an invalid queryDPS-1132 Crash when attempting to access non-existent table via OLEDB connectorDPS-1138 Error when exporting null and numeric values to csv: no longer include double-quotesDPS-1139 Error when attempting to load JSON and XML from Browse from FileDPS-1143 Cancel to close table option from "close" icon incorrectly removed tableDPS-1159 Issue when exporting column names with special characters to IBM Watson Analytics or IBM Cognos AnalyticsDPS-1160 Informix connector error via ODBC not allowing column selectionDPS-1161 Issue when exporting split date results to IBM Watson Analytics


of 5

ISSUE ID RESOLVED ISSUEDPS-1176 Custom Change List issues related to filters and calculated fieldsDPS-1223 Crash when splitting a date column and using result in a calculated fieldDPS-1235 Duplicate file types listed and file type case in Browse For File dialogDPS-1305 PostgreSQL connector error: invalid column type ByteDPS-1323 Crash when pasting rich text format into formula boxDPS-1334 Incorrect tooltip for Export Data button for Monarch for IBM AnalyticsDPS-1626 Out of memory exception crash caused by corrupt csv file

NEW FEATURE Dataset Library. Save, duplicate and edit connection to data sources from within a central location and share across workspaces.NEW FEATURE Google Analytics Connector.NEW FEATURE Microsoft Power BI export.NEW FEATURE Partial Loading. Specify amount fo rows to work with, then request a full load on demand.NEW FEATURE Sorts. Sorted columns include a shaded header indicator to easily see the sorting sequence.NEW FEATURE Floating Windows. Tables from data prep can be floated to compare side by side or send to another monitor. NEW FEATURE Hide/Unhide Columns.NEW FEATURE Set any row as a header.NEW FEATURE Most recently used list for each Connector.NEW FEATURE Merge Columns Wizard.NEW FEATURE De-dupe Transform.NEW FEATURE Remove Numeric and Remove non-Alphanumeric functions.NEW FEATURE File metadata when using reports.NEW FEATURE Null and Blank Value Transform.NEW FEATURE Autonumber column.

ENHANCEMENT Various enhancements to Salesforce and MongoDB connectors, including accessing Salesforce reports.NOTE: These changes will require redefining Workspaces which depend on the previous revision of these connectors.Please contact Customer Support for assistance in making such Workspaces backward compatible.

ENHANCEMENT Include column headers when copying data.ENHANCEMENT Improved Column Information.ENHANCEMENT Access Data Prep functionality from the Combine interface.ENHANCEMENT Additional options in the Options menu.ENHANCEMENT Guided help.ENHANCEMENT Negative joins.


of 5

ISSUE ID RESOLVED ISSUEENHANCEMENT Fuzzy Join Tolerance Result Column.ENHANCEMENT Improved Group By Transform capabilities.ENHANCEMENT Enhanced Text to Number conversion.ENHANCEMENT Append functionality for Excel and Access exports.ENHANCEMENT Calendar Week date split function.ENHANCEMENT Support for Excel XLSM files.

Datawatch Monarch Release Notes Version 13.4.1June 15th, 2016

Page 1 of 1

ISSUE ID RESOLVED ISSUEMOD-2603 Track between sessions folder option not working for network locations.MOD-2606 Filter and Sort Macros not working for exports to XLSX and PDF.MOD-2633 Hang when multiple PDF files are opened and data preview auto refresh is enabled. MOD-2644 Regional Settings not properly respected.

DATA PREP STUDIO (MONARCH COMPLETE ONLY)DPS-1124 Visualizations erroneously removed in IBM Watson when overwriting datasets.

KNOWN ISSUE:When upgrading from Monarch for IBM Analytics 13.4.0, the sample files may disappear. This can be resolved by performing a repair, once 13.4.1 is installed. For more information, refer to:https://support.datawatch.com/hc/en-us/articles/220759248-Monarch-for-IBM-Analytics-Sample-Files-Disappear-After-Upgrade

Datawatch Monarch Release Notes Version 13.4.0May 17th, 2016

Page 1 of 1

ISSUE ID RESOLVED ISSUEMOD-2542 Crash after clicking 'Enter DPWX Passwords' when incorrect file path is set.MOD-2557 Projects with saved Tableau Server publishing can't be opened in earlier versions of Monarch.MOD-2565 Certain date fields in CSV files not parsed correctly.

MOD-2569 PDF Import Options from a model created in an earlier version of Monarch are applied incorrectly under certain conditions.MOD-2586 Crash when attempting to connect to a subfolder in an Amazon S3 bucket when using empty or invalid credentials.

DATA PREP STUDIO (MONARCH COMPLETE ONLY)DPS-741 Ditto Produces Incorrect Values in Prep DataDPS-462 Improved disambiguation when joining tables with identical column names

NEW FEATURES Export to IBM Cognos AnalyticsExport to IBM Watson Analytics

Datawatch Monarch Release Notes Version 13.3.1April 4th, 2016

Page 1 of 2

ISSUE ID RESOLVED ISSUEMOD-1984 AutoDefine not recognizing column labels.MOD-2033 Data Prep Studio cannot start if user credentials for License Server are not saved in the registry.MOD-2066 When multiple reports are opened, there is no method to remove multiple selected reports.MOD-2130 Find in Report hotkey is not working.MOD-2145 Connection to Datawatch Server Library using Active Directory with SSO not workingMOD-2193 Cursor not retaining row location when drilling up or down a summaryMOD-2227 Uninstallation is not deleting cache databases.MOD-2228 "Fields in model do not match fields in data source" error does not allow the user to fix the definition issuesMOD-2233 Cannot change the database source of a Project when using DPWX as a data sourceMOD-2245 Unnecessary prompts to Save Model appear when a PDF file is openedMOD-2248 Table view is not created if the path for cache databases is set to a location where write privileges do not exist.MOD-2280 Gridline Changes in Table/Summary Page Setup Options are not applied in Print PreviewMOD-2281 A Crash may occur when opening certain DPWX filesMOD-2290 Duplicate handling issues for Lookup Calculated FieldsMOD-2300 Incorrect NSplit behavior for Lastname when the String doesn't contain a Comma before the SuffixMOD-2307 Illegal Characters In Path Error When Opening a Project Does Not Allow Changing Of The PathMOD-2312 Incorrect error message when attempting to configure SQL Server Standard or Enterprise as a cache database provider without the appropriate licenseMOD-2327 Issue with drag and drop report files on Model Information pageMOD-2333 1 column export to XLSX causes Excel to attempt to recover the file.MOD-2353 Cache logic is not working correctly if the cache databases cannot be created for any reasonMOD-2378 Projects without an associated Model are not opened via double click and Open with actionsMOD-2379 More than one identical character can be typed in Character list trapMOD-2402 Different behavior can occur when typing letters versus digits in a User Edit FieldMOD-2403 Main page in Help is opened instead of Cache OptionsMOD-2408 Issue when deleting a large number of cache databasesMOD-2442 Open Web Files fails if the URL contains a port numberMOD-2465 Issue with preview AutoRefresh on Lookup tabMOD-2479 Crash when changing field type/name in Table Design when the source file is locked by other application

NEW FEATURE Export to Tableau Server (Monarch Complete Only) NOTE: The TABCMD Utility is required and can be downloaded from the Tableau web siteNEW FEATURE Region Templates - Simplifies extraction of data for files containing multiple different report/document types and other scenariosNEW FEATURE Open files from an SFTP site

ENHANCEMENT Enhanced File Menu - Simplifies usage when using Datawatch Server Library, web based-files and archivesENHANCEMENT Password-protected ZIP supportENHANCEMENT Open web-based ZIP filesENHANCEMENT Open Models & Projects from within ZIP filesENHANCEMENT Save Models & Projects into an existing ZIP file

DATA PREP STUDIO (MONARCH COMPLETE ONLY)

Datawatch Monarch Release Notes Version 13.3.1April 4th, 2016

Page 2 of 2

ISSUE ID RESOLVED ISSUEDPS-472 XML Explorer extracts unwanted data.DPS-511 Exponential Values Not Recognized as Numeric Data TypeDPS-716 Adjust Scroll Bar to include both OK/CANCEL Button when Editing ColumnsDPS-719 Loading XML spikes CPU and also stops showing dataDPS-754 Incorrect Date values in Filter RangeDPS-797 Monarch v13 Data Prep Studio Edit in Classic Mode Not WorkingDPS-810 Regression: XML Explorer and Add Data shows different dataDPS-814 Table Icon for Create from Selection Not the Same in Prep as in CombineDPS-826 Multi-Select GroupBy Pull Down Not Displaying CorrectlyDPS-838 Error on Unpivot with multiple columns where one column is numericDPS-853 Transformed tables do not reflect a changed datasourceDPS-902 List of columns to Unpivot moves off the screen and can no longer be movedDPS-952 Crash when changing then editing a report

NEW FEATURE Fuzzy JoinNEW FEATURE Angoss ExportNEW FEATURE FilteringNEW FEATURE Tutorial VideoNEW FEATURE Load Plan Visualization

ENHANCEMENT JSON Parsing EnhancementsENHANCEMENT Edit data source connectionsENHANCEMENT FilteringENHANCEMENT Smart Data AppendsENHANCEMENT Edit table definitionsENHANCEMENT Move ColumnsENHANCEMENT Transform dates based on fiscal periodsENHANCEMENT Enhanced Calculated Columns

Datawatch Monarch Release Notes Version 13.2.1February 3rd, 2016

Page 1 of 2

ISSUE ID RESOLVED ISSUEMOD-2261 Startup delay caused by licensing componentMOD-2287 Cache instance is not deleted when the option is set to delete, but the application is opened and closed without opening any inputs MOD-2315 Cache databases are not deleted when switching between SQL Server LocalDB and SQL Server Express

ENHANCEMENT Ability to specify report inputs using ? and * wildcards when using the Command Line module, e.g. /rpt:"c:\reports\*.prn"ENHANCEMENT New "Debug" Logging Level Available


DPS-173 Save file type as' is XLS instead of XLSX when exporting Excel files in Data Prep StudioDPS-190 Crash - Able to move/delete report file in use in Data Prep StudioDPS-202 Dropdown list with data types disappearsDPS-214 No Tooltip for Data Source Grouping and Data Source Search Drop Down Menu in Add Data Page.DPS-216 Tooltips of Export Change List and Import Change List menu items are incorrectDPS-218 Remove the truncated texts in Data Source Grouping and Data Source Search Drop Down Menu if Data Prep Studio is resized into smaller window.DPS-300 The first numeric value is replaced by underscore when exporting to Excel with TableName starting with numeric valueDPS-308 Filtering of tables is not applied when combining tables using the "Append Selected Tables" button.DPS-343 No tooltip displayed and OK button is enabled if the Delimiter Textbox is empty.DPS-394 No tooltip for collapsing the list of recently used data sources and tables.DPS-400 Keyboard Hotkey IssuesDPS-452 Error when opening table: SqlDateTime overflow. Must be between...DPS-460 No ability to refresh a data sourceDPS-466 Delimited file connector only lists CSV and TABDPS-472 XML Explorer extracts unwanted data.DPS-509 Load order and sort order issuesDPS-545 Certain connectors not appearingDPS-552 Business Objects Universe connector may generate invalid crosstabsDPS-628 Unable to replace values when value is showing as nothingDPS-635 Large File in Text Viewer/Add Data Crashes App or Makes it UnresponsiveDPS-644 Interacting with Filters Crashes the AppDPS-647 Ctrl-V is not working in some fieldsDPS-648 Preview does not Close When Closing TableDPS-652 Wrong table name saved after exporting to excelDPS-666 Hang when cancelling an exportDPS-668 MIN values are incorrect in Transform Data - Group byDPS-678 Error when opening .tab file via webDPS-679 Error message if clicking Select filter type > Multiple Selection before preview loadDPS-700 File names are displayed as url encodedDPS-702 Change default file path when editing report or file pathDPS-707 Implement remaining transform aggregations

Datawatch Monarch Release Notes Version 13.2.1February 3rd, 2016

Page 2 of 2

ISSUE ID RESOLVED ISSUEDPS-714 Changing File Path can cause a crash when using a web copy sourceDPS-715 Hang when trying to preview Excel objectDPS-719 Loading XML spikes CPU and also stops showing dataDPS-720 Append Selected Tables button in Add Data page is disabled.DPS-722 Salesforce Connector failing due to missing d9sfrc64.dllDPS-757 ODBC Password validation issue after saving a Workspace

ENHANCEMENT Transforms - Additional Group By and Pivot data calculation options.ENHANCEMENT Add Data - Text viewer optimized for large files and new search improvements introduced.ENHANCEMENT Prep Data - New capability to refresh data sources.ENHANCEMENT Prep Data - Editing a file path for report files now defaults to file extension type.ENHANCEMENT Start Page - Text connector now shows all supported file extensions, and also allows browse all files in a directory.

Datawatch Monarch Release Notes Version 13.2.0 December 18th, 2015

Page 1 of 3

ISSUE ID RESOLVED ISSUEMOD-491 Group using wildcards in Summary matching options is not recognized in version 12 if created in V11 and a special character was accidentally inserted into the definitionMOD-1786 Export to *.accdb sporadically fails with exception "The process cannot access the file '... because it is being used by another process"MOD-1833 Lookup field accepts blank values but validation says "Non blank value required" .MOD-1921 MySQL system tables are loaded with user tables via ODBC.MOD-1966 Project cannot be opened if DB column names were changedMOD-2015 Issue with error message if using Numeric OR with Floating TrapMOD-2017 Report Design Field Properties ImprovementsMOD-2023 Incorrect validation for fields on 'Add External Model' dialogMOD-2030 "Data Prep Studio is not licensed." error message is displayed instead of "Trial period Expired."MOD-2041 Added QAT items are not retained in the Ribbon after the restart of MonarchMOD-2045 Incorrect table when setting advanced properties for regex fieldMOD-2050 Incorrect name of an open fileMOD-2053 When Closing Data Prep Studio, "Unsaved Changes" dialog box doesn't appear after loading table in Classic ModeMOD-2060 Memo type field in Classic is cut at around 252 characters when loaded in Data Prep StudioMOD-2063 CJK - Incorrect export of Japanese characters for txt and csv filesMOD-2084 Datawatch Designer may become activated after Monarch is uninstalledMOD-2096 Suppress Splash Screen When Starting Monarch From Data Prep StudioMOD-2140 No Error When SQL DB Size is ExhaustedMOD-2154 Activation via silent mode does not work with Monarch x86MOD-2155 Login Credentials were not saved even if Save login credentials was set to "Always"MOD-2157 Select an ODBC Data Source dialog should be populated with the User ID and Password if they are saved in the ODBC DSNMOD-2183 No error when disk space is insufficient for cache.MOD-2189 Font color of Data Preview does not match font color of report linesMOD-2195 Implement warning message when saving model with functionality not available in previous versionsMOD-2209 Opening of new model doesn't ask to save the previous oneMOD-2217 Incorrect Decimal Places When Importing from certain ODBC/OLE DB Sources, e.g Dell Statistica MOD-2228 Monarch v13 Fields in model do not match fields in data source error

NEW FEATURE Exclusion TemplatesNEW FEATURE Amazon S3 Support: Load Reports, file-based Databases, Models and Projects. Save Models and Projects.NEW FEATURE ZIP and GZIP Archive Support: Load Reports, file-based Databases, Models and Projects. Save Models and Projects back into an archive.

ENHANCEMENT User Interface for Configuring the Cache. Options to reduce disk space usage and improve compatibility with complex deployment models such as CitrixENHANCEMENT UI Enhancements in Report Design Field Properties Panel: New Field Navigation, Ability to configure Template Width & Copy Value from Previous RecordENHANCEMENT Sample Line SynchronizationENHANCEMENT Compatibility warnings when saving and loading models containing new non-compatible functionality vs previous versions. ENHANCEMENT New Column Sizing OptionsENHANCEMENT Automatic recognition of pipe-delimited text files when using Open Database, explicit pipe-delimited export option.


Page 2 of 3

ISSUE ID RESOLVED ISSUEDATA PREP STUDIO (MONARCH COMPLETE ONLY)

DPS-39 Dragging and dropping of reports does not work properly in the Combine Data ViewDPS-65 Xml file shows tables but no recordsDPS-139 Cannot enter a 'tab' as the Delimiter in the Delimited Text Options dialog.DPS-158 Floating position of connectors dialogsDPS-190 Crash - Able to move/delete report file in use in DPSDPS-192 Error when opening an XLSX file in Designer exported from DPS.DPS-202 Dropdown list with data types disappearsDPS-207 Error when opening a table more than 1023 columns in DPSDPS-208 " Validation Password (s)" option exist when right clicking a Table in Prep DataDPS-217 Export Change List is enabled when there are no changes listed yetDPS-219 Improper color for the Sub menu of Context MenuDPS-221 Error importing a change list with existing changesDPS-224 Monarch failed to open a big (1GB) Excel file through Open Data.DPS-225 Preview for a SQL table with 10 million rows is blank.DPS-298 Export Data: issue for Table Name and OK buttonDPS-299 Switch to Monarch via DPS not possible after Monarch is closedDPS-312 Incorrect error message when name range tables missingDPS-316 Crash Data PrepDPS-335 Preview Section re-appearsDPS-348 Change filter configuration checkbox labelDPS-353 Preview Section shows "NaN" for fields with integer value using JSON fileDPS-357 SQL Local DB is not listed in Control Panel > Programs > Programs and FeaturesDPS-360 Row Count does not load if deselect all is done before selecting the matching keyDPS-368 Crash on Preview for Informix table via generic ODBC connectorDPS-371 Crash after error messages when creating Calculated fieldDPS-372 Join Name is not updated if Join table is created from Join AnalysisDPS-373 Crash when typing too large value while editing fieldsDPS-376 Usability: Tooltip for tables needed to see "..." infoDPS-386 Invalid append allowed and then errors out in Prep DataDPS-388 Applying filter with blank values will remove all rows from tableDPS-389 ODBC Connector of Monarch Personal does not list existing DSNsDPS-390 DPS crashes when previewing/loading a file that could not be found.DPS-396 OK button in Export Result dialog is overlapped by a long export file name.DPS-401 Could not connect to the server using the ODBC as data source if Alias field is blank.DPS-404 Formatting a field to time then exporting to Excel loses formatDPS-405 Choose filter item that is last scrolls when it should selectDPS-418 Deselecting All from Joins and Create Join Key Does Not WorkDPS-465 Install:Incorrect Install Location for Monarch Personal if Access Database Engine 32 bit is installedDPS-477 Crash while attempting to open any fileDPS-485 Large tables are not fully loaded in Data Prep after switching from ClassicDPS-494 Close preview when navigating away from Add DataDPS-514 First column name has " symbol if source file has BOM at the start.


Page 3 of 3

ISSUE ID RESOLVED ISSUEDPS-531 Database connector not showing as available data sourceDPS-602 Side Panel Scrolling Missing in Add DataDPS-664 Crash after droppping web page with no tables onto Prep Data

NEW FEATURE Business Objects Universe ConnectorNEW FEATURE OLE DB ConnectorNEW FEATURE Transformations - Pivot, Unpivot, Group By and Remove RowsNEW FEATURE Fixed Value Columns - Ability to create a column of any type and assign a constant, fixed value which applies to all rows.NEW FEATURE Allow substitution of file references when loading file-based data sourcesNEW FEATURE Column information dialogNEW FEATURE Open files from a URLNEW FEATURE Table Pinning - save data snapshots into the workspaceNEW FEATURE Debugging Logs

ENHANCEMENT XML/JSON Explorer - Simple interface to explore the structure and select any part of the schema for loading into tables. Optimized for large files.ENHANCEMENT Redesigned & Enhanced Filtering, including visual filtering based on data distributionENHANCEMENT Speed and capacity enhancementsENHANCEMENT Ability to perform in-flight data prep with immediate feedback as a very large dataset continues loading in the backgroundENHANCEMENT UI EnhancementsENHANCEMENT Improved support for HP VerticaENHANCEMENT SQL query editor for some connectorsENHANCEMENT Improved integration with Datawatch Designer (requires Datawatch Designer 13.4.1.17543+)ENHANCEMENT Case sensitive option for text filtering

Datawatch Monarch Release Notes Version 13.1.2 October 29th, 2015

Page 1 of 1

ISSUE ID RESOLVED ISSUEMOD-2092 Licensing Issue


Page 1 of 2

ISSUE ID RESOLVED ISSUEMOD-15 Autosize Columns and Search does not work in Table view for External Lookups.MOD-124 File Menu and Open Document Submenu (File>Open) are displayed separately in Windows 8.MOD-129 ‘Security’ and ‘Pivot’ checkboxes should operate exclusively.MOD-306 QAT dropdown too long. MOD-484 Missing Zoom slider label in Print Preview.MOD-893 Monarch Utility: Missing Help hotkey.MOD-897 Add option to install / not install sample files. MOD-910 Add possibility to preserve folder structure in destination path.MOD-945 Auto-Define Trap changes not saved if repeated.MOD-1116 Unhelpful message displayed when opening another Monarch session whilst another session is open on a different machine when using License Server.MOD-1135 No error message appears when using Numeric OR with Floating Trap.MOD-1274 A single leading apostrophe is not displayed if pasted or exported to Excel. MOD-1696 Allow Sorting of Values when Matching Summary Keys using Specified ValuesMOD-1711 Using "Open With..." may incorrectly show the "Open Database" dialogMOD-1746 "Print" button may become incorrectly disabledMOD-1761 Model name is not shown in the title when opening together with a database.MOD-1822 /set and SetRuntimeParameter method is not working when use in Command Line and OLE/COM.MOD-1828 Very old PRF files cannot be opened.MOD-1832 Data Preview does not refresh automatically for Sorts defined in projects.MOD-1836 Data Preview does not show the values entered in User Edit Fields.MOD-1837 No Progress Indicator When Switching Between Summaries.MOD-1840 Issue when duplicating Runtime Parameter Fields.MOD-1844 Spurious error message may appear when using advanced Filter features.MOD-1850 Crash: press Print Preview when not initialized data in summary tabMOD-1853 Data Preview in Table Design not populating for projects with password protected pdf filesMOD-1856 Order numbers in the Field List are incorrect after deleting fields.MOD-1858 The number of fields loaded via ODBC (using Datawatch SQL Server Wire Protocol) is not the same as that loaded via SQL Server connector in DPS.MOD-1859 Monarch Utility: Copying files to web folder falsely reports success.MOD-1863 Data Preview is not refreshed when changing some properties of value based filtersMOD-1864 Filter name falsely marked as invalid in certain cases when creating a new filter after deleting an existing filterMOD-1865 Issue with empty password field in Datawatch Server Library optionsMOD-1866 Positioning Issue for Datawatch Server Library Revisions windowMOD-1878 Status bar is not refreshed after changing active filter/sortMOD-1887 Append data is not working when exporting table and summary to QlikView QVXMOD-1888 Invalid Export Combinations Allowed for Tableau Data(.csv) fileMOD-1889 Invalid Export Combinations Allowed for QlikView (.qvx) fileMOD-1891 Incorrect button in Save Export File dialog box - "Save" instead of "Open" button should appear.MOD-1895 Crash on Run Report Verify after hiding/showing some fields on Table ViewMOD-1905 Export of summary with multilined header to Excel is impossible when 'Add data' is setMOD-1924 COM: OpenDatabase() returns False when explictly specifying a table schemaMOD-1926 -1 records written error when exporting to existing file in certain conditions.MOD-1930 Not converting numeric fields with numbers containing more than 15 digits to Character data type from ODBC sources.MOD-1998 Prompt to save PDF Password appears when saving a project which contains a PDF without a passwordMOD-2024 Crash on generating formula-based filter for Null values


Page 2 of 2

ISSUE ID RESOLVED ISSUE

NEW FEATURE Regular Expression Traps & Field Capture GroupsNEW FEATURE Regular Expression FunctionsNEW FEATURE Autodefine Templates, Fields and Fieldnames

ENHANCEMENT Reintroduction of Append DOS End of File Marker OptionENHANCEMENT Improved highlighting for Report VerifyENHANCEMENT Report Verify Starts ImmediatelyENHANCEMENT Adjust All Fields Option in Report VerifyENHANCEMENT Pagination option for fixed-width text exportsENHANCEMENT Option to repeat field names on each page of fixed width text exports where pagination is enabledENHANCEMENT Option to specify number of spaces for padding for fields in fixed width text exports


DPS-374 Cannot drag and drop .CSV files containing ampersand charactersDPS-359 Data Prep Export Issue for Access and ExcelDPS-326 Export Skipped when overwriting existing tableDPS-294 CSV export incorrectly puts double quotes around numeric and date fieldsDPS-169 Crash when opening an HTML file via drag-and-dropDPS-168 Crash: right click on the list of tables after closing workspace

NEW FEATURE Join AnalysisNEW FEATURE Generic ODBC ConnectorNEW FEATURE Custom Number FormattingNEW FEATURE Column Filtering

ENHANCEMENT Incremental Data LoadingENHANCEMENT Custom Change ListsENHANCEMENT Data Source GroupingENHANCEMENT View Full File Path for file based sourcesENHANCEMENT Combine Data window Usability ImprovementsENHANCEMENT Multi-select tables in Data Prep windowENHANCEMENT Append functionality in Data Prep windowENHANCEMENT Any File Connector moved to Browse for File at the bottom of the Connector listENHANCEMENT Set default file order in the Add Data window

Datawatch Monarch Release Notes Version 13.0.3 September 8th, 2015

Page 1 of 3

ISSUE ID RESOLVED ISSUEMOD-79 Could not open the exported EXW with multiple table DWX in Datawatch DesktopMOD-130 Wrong Desktop Designer Workbook Target Folder is used when opening v11 project.MOD-136 "Unrecognizable database format 'dwx.'" error appears when opening a Modeler exported Workbook (exw) in Designer.MOD-156 No Create Desktop Designer Workbook Options in Create Export dialog.MOD-190 Bold, Italics and Underline styles set in Default style-Summary Properties are also applied in Row Title/Number of Summary View.MOD-192 The Underline in Default Style-Summary Properties is not being applied in the Summary-PDF export.MOD-293 Print option is missing in Report Design - Context menu.MOD-490 Enhancements for redactionMOD-760 Selected Font is not applied if Italic checkbox is tickedMOD-761 Underline option does not work in Custom fontMOD-896 Automator: SDK locks a project input file in some cases (when the option "HasHeader" is different in the project and model)MOD-935 Database - table data lossMOD-948 Section 508 Compliance: Address BlockMOD-952 Section 508 Compliance: Table Design - Compound FiltersMOD-954 Section 508 Compliance: Trial Mode Window issuesMOD-956 Section 508 Compliance: issue for Summary DesignMOD-960 Section 508 Compliance: Editable ComboBoxes issueMOD-990 File Name textbox should have fixed sizeMOD-996 Field list Number for External Lookup fields are incorrect.MOD-1021 Sort Order button and Search don't work on Report Verify viewMOD-1151 Zoom doesn't work in User Edit FieldMOD-1154 Home - Model information - Comments of Summaries doesn't displayedMOD-1614 Monarch Complete: The list of tables loaded from the Amazon Redshift ODBC Driver is different from Designer and DPS.MOD-1653 File extension for export is dropped after clicking Browse buttonMOD-1654 Enhancement: Disable Datawatch Designer buttons if there's no Designer installed.MOD-1659 Save As dialog has blank file nameMOD-1665 It is impossible to retain current model from DSL in Retention OptionsMOD-1673 Data Preview is not working for password protected pdf filesMOD-1676 Incorrect Field List when printingMOD-1678 Issues of report searchMOD-1683 Project is invisible after unsuccessful opening of model from DSLMOD-1687 Header Date Conversion on Monarch/Automator ExportMOD-1698 Implement Smart RebuildMOD-1702 Issue with typing in User Edit FieldsMOD-1703 Incorrect search with 'Enter' buttonMOD-1705 Wrong navigation via context menu on Table viewMOD-1712 Inconsistent values of 'Color null values as' comboboxMOD-1713 Issues with 'Lines to skip at start' valueMOD-1716 Error 'The specified path cannot be found.' when opening a Web file in Monarch.MOD-1718 "Close" button works as "Ignore This Update" buttonMOD-1723 Crash when clicking on printMOD-1724 Unreadable content when opening a large PDF fileMOD-1729 Issue with "Restore from default settings" buttonMOD-1735 Options - Clipboard functions: incorrect behaviour


Page 2 of 3

ISSUE ID RESOLVED ISSUEMOD-1737 Issue with "Open a document" in QATMOD-1739 Commandline /datasource method is not workingMOD-1741 Error "Column already exists: STRING" when connecting to MongoDB server.MOD-1745 Monarch stops working when editing templates or traps while Data Preview is refreshingMOD-1747 Sudden Freeze when Editing of FiltersMOD-1753 Monarch Complete: Initial memo data type definition is not retained when creating calculated fieldsMOD-1754 Monarch v13 Converting Short Date and Time turns to NullMOD-1756 Export File type is not retained when opening projects created in previous version of Monarch.MOD-1757 Incorrect project export settings for multiple exports of Projects created in previous build when open in Monarch 13MOD-1758 Change description of Delimited Text and Fixed-Length Text in Export File type dropdownMOD-1759 Issue with add fields in SortMOD-1762 Monarch is empty when opening a project file with double click or 'Open with'MOD-1763 Performance issue on opening table design view with large amount of fields in modelMOD-1764 Values in the "Value Based Filter" are not saved automaticallyMOD-1765 Values in the "Lookup Field" are not saved automaticallyMOD-1766 Redaction feature takes time to apply (Data Preview Refreshed Button)MOD-1771 QVX export issueMOD-1772 Table view is empty when opening MongoDB Table via ODBC.MOD-1773 CurrentModel() method returns location instead of name of current modelMOD-1775 Crash when attempting to open the exclusive file with the extension .txtMOD-1776 Crash: 'Ctrl + C' + click on TableMOD-1777 OpenDatabase() returns 'True' if password is wrongMOD-1779 Cannot open database with model.MOD-1782 Sample Text Box Line Values Push to the Right when scrolled to Right under Template EditorMOD-1789 ExportTable and JetExportTable return True if no table is opened.MOD-1790 OpenDatabase() returns True if table name is not correctMOD-1791 Opening 2nd Instance of Monarch via Remote Desktop results in Unknown ErrorMOD-1792 Crashing on certain Model modficationsMOD-1793 Crash: Print Preview when Font textbox is emptyMOD-1794 .xls file with macro is corrupted when export (add to file, overwrite table) is done.MOD-1796 Deleted values "Lookup field" are displayed in Data PreviewMOD-1811 Table with values for lookup fields is cleared when you attempt to enter "h"MOD-1813 Monarch Utility: converting some models from .mod to .dmod failedMOD-1815 Cannot open project file with database input.MOD-1820 Issue with rebuild data if add external lookupMOD-1822 /set and SeRuntimeParameter method is not working when use in Commandline and OLECOMMOD-1823 Table View does not load.MOD-1824 Export Failed when table is not initialize before exporting.MOD-1827 Monarch Crashes for the First Two AttemptMOD-1831 Cannot edit an export with 'All filters - auto naming by tables' setup from a project created from lower version of Monarch (v11.8.14.5 and 11.10.3)MOD-1835 Active Directory Credentials not working when using License ServerMOD-1838 Designer fails to open Monarch exported XLSX files that contain datesMOD-1839 Formula return type does not change automatically MOD-1841 Default buttons do not work in dialogs when pressing Enter


Page 3 of 3

ISSUE ID RESOLVED ISSUEMOD-1842 Crash: Copy action on Data PreviewMOD-1843 Issue with Exporting of Table after changing Font Style and SizeMOD-1845 It's impossible to open project with password protected database and modelMOD-1848 Cannot open a project file connecting to a database via ODBC when password is not saved in the project.MOD-1849 X-Over Character is a quadrate for old modelsMOD-1861 Issue for Database Password Required dialogMOD-1862 Open Web File: only root files are visible, no way to open subfoldersMOD-1872 "Connection refused." error displays when attempting to connect to Cloudera Impala.MOD-1873 "Connection refused." error displays when attempting to connect to Apache Hive.MOD-1874 "Cannot open external database ODBC.." error displays when selecting a table from MongoDB data source.MOD-1881 Unexpected error after closing Monarch with saving workspace

ENHANCEMENT Ability to specify X-Over Character in RedactionENHANCEMENT Ability to randomize X-Over length in Redaction

DATA PREP STUDIO (MONARCH COMPLETE ONLY)DPS-169 Crash when opening an HTML file via drag-and-dropDPS-189 Column information does not update when re-selecting the table

ENHANCEMENT Data Prep Studio: Tableau TDE ExportENHANCEMENT Data Prep Studio: Export and Import Change ListsENHANCEMENT Data Prep Studio: Data Source Grouping in Add DataENHANCEMENT Data Prep Studio: Calculated Numeric ColumnsENHANCEMENT Data Prep Studio: Keyboard Shortcuts for main toolbarENHANCEMENT Data Prep Studio: Zoom SliderENHANCEMENT Data Prep Studio: Add Workspace name to titleENHANCEMENT Data Prep Studio: Improve algorithm when adding or excluding rows in Report Discovery.ENHANCEMENT Data Prep Studio: Persist Data Sources in Add Data Between SessionsENHANCEMENT Data Prep Studio: Data Source Name Search in Add DataENHANCEMENT Data Prep Studio: Edit Report View Definition in Prep Data

Datawatch Monarch Release Notes Version 13.0.2 August 4th, 2015

Page 1 of 2

ISSUE ID RESOLVED ISSUEMOD-13 SmartCopy from Report View Not Working CorrectlyMOD-25 Field list properties (alignment) does not automatically update when changing data types (character to numeric).MOD-29 Templates accepts empty traps.MOD-47 Functions from Strong-Linked External Models Do Not Fail If They Are MissingMOD-65 Inconsistent alignment of Header and Subtotal label in Summary View and Excel Export.MOD-67 Cannot select field using keyboard select in Add/Remove Fields' Table fieldMOD-126 Incorrectly able to set Coloring properties in an across key.MOD-128 Key Field title is not retained in key field selector search.MOD-191 Bold, Italics and Underline defined in Default styles-Summary Properties are also reflected in the Title Column of the Summary HTM/HTML export.MOD-218 Merging of Row Number cells for Header (Upper Left cells) in Summary View is not applied.MOD-219 Incorrect Percentage value when using Excel as input and a model created in v11.MOD-289 Advanced Excel Features in Excel Output panel are still enabled even if the Excel Formatting tickboxes in Options - Export are not selected.MOD-321 Unreadable content message when opening an XLSX export file in Excel When The Worksheet Name Starts With R or C followed by numbersMOD-485 Truncated columns in PDF Export. Not consistent with the Print Preview.MOD-757 Changes in Options of Page Setup are not saved automaticallyMOD-775 Field List is truncated when printingMOD-885 Incorrect keyboard behavior of New template and Clearing template listboxesMOD-941 Open Web File Credentials IssueMOD-951 Keyboard focus issue in Export DesignMOD-974 Report design: Template editor disappears when sorting or searching templatesMOD-975 Next/Previous Bookmark search works in order by chronological creation.MOD-976 Search issue with period characterMOD-994 Selected Sort Fields does not automatically return to Available Fields when Cleared.MOD-1008 Incorrect export location when changing export definition from single file export to multiple by file nameMOD-1065 Incorrect window prefix of 'and 0 more' when opening database sourcesMOD-1067 Underscores in Field Names are removed not in the Show Hidden Field context menuMOD-1088 Table Design - Stop verify after n seconds not working. The entire table is verifiedMOD-1092 Show Field Contents always shows data as one lineMOD-1104 Fieldnames are not refreshed in the Expression Editor after name changesMOD-1128 Summary definitions without key fields are acceptedMOD-1155 PDF password dialog appears while opening a modelMOD-1157 Time Intervals - Radiobutton switches from Months to WeeksMOD-1160 Report Design doesn't open via double clickMOD-1174 Report Export is enabled when a database is openedMOD-1178 Add to Export Job List function is always enabledMOD-1188 Buttons incorrectly disabled if the Report View is closed while processing a multi-report search operationMOD-1267 Summary Design - ctrl+tab switching not working correctlyMOD-1297 Exporting a table with CJK characters to PDF produces a blank table even after the appropriate Adobe Font Pack is installedMOD-1309 Cannot open exported files after changing Excel file extensions from XLS to XLSX in Project Exports using the Monarch UtilityMOD-1594 Last line of the report in the last page is truncated in Print PreviewMOD-1621 Data Prep Studio: Extract accepts invalid value for lengthMOD-1677 Uninstall of Monarch 13 deletes Designer icons in Start MenuMOD-1682 Issue with frozen panesMOD-1688/MOD-1694 Missing error message when trying to open dpwx files in Monarch Classic

Datawatch Monarch Release Notes Version 13.0.2 August 4th, 2015

Page 2 of 2

ISSUE ID RESOLVED ISSUEMOD-1689 Monarch Complete 13.0.1 May Crash When Creating Template After Certain Steps In A Data Prep Studio SessionMOD-1694 Incorrect "Open with" behavior for .dpwx filesMOD-1695 'Clearing template' is enabled if there is only one templateMOD-1715 Crash When Using External Lookup After Dragging An MDB As Main InputMOD-1717 Datawatch Server Library icon Appears Incorrectly in Resolve Missing Files dialog when no DSL has been definedMOD-1721 No Deactivation Option Shown During UninstallMOD-1728 Datawatch Server Library Default Save Location Not SavedMOD-1730 Crash when navigating empty report fileMOD-1733 Redaction not enabled by defaultMOD-1739 using /datasource Command Line argument may result in an error MOD-1745 Hang when editing templates and Live Data Preview is enabledMOD-1748 Issue with instantiating 64-bit COM sessionMOD-1749 SetReportFile COM Automation method failsMOD-1757 Incorrect file type for All Filters, All Summaries project exports when using projects created in V12MOD-1773 CurrentModel COM Automation method not returning full path and filename of modelMOD-1777 OpenDatabase COM Automation method incorrectly returns true for a password protected input and the password is incorrectMOD-1789 ExportTable and JetExportTable COM Automation methods return true, even if no report and model have been specifiedMOD-1790 OpenDatabase COM Automation method incorrectly returns true if the view is not specifiedDPS-155 Data Prep Studio:Empty Table When Importing a Web Page Containing A Table

NEW FEATURE New COM Automation Method Added: SetPasswordProtectedReportFile(string ReportFile, string Password, boolean AppendFlag)This is used to open password protected PDF files when using COM Automation

Datawatch Monarch Release Notes Version 13.0.1.4310 July 1st, 2015

Page 1 of 1

ISSUE ID RESOLVED ISSUEMOD-1655 Invalid filechck.dll error appears after installing over Monarch 12.4.3MOD-1460 Unable to open password protected accdb/mdb file in Classic Mode when opened initially from Data Prep StudioMOD-1314 Extension is not dropped for Default Naming Rule - "Input TableName (Database sources)".MOD-1656 Blank File Name Created When Replacing a Model In Datawatch Server LibraryMOD-1348 Support Changing Between OLEDB and ODBC Sources When Managing External References in Monarch UtilityMOD-1159 Project is not closed after all Reports and the Model have been closedMOD-1103 Model and Project Information Not Opening on Windows Server 2008 and 2012MOD-1320 Hiding a Summary Key Field Also Hides Header and SubtotalsMOD-1005/1286 Erroneous Extra backslash in Export Results Panel When Performing "By Files" or "By Tables" NamingMOD-1115 External Lookup fields are lost on selecting/deselecting 'First row ... names"MOD-1119 Incorrect behaviour of External Lookup propertiesMOD-1126 Pull Left and Pull Right Context Menu Items Appear When a Field Is Not Selected in Report DesignMOD-1244 Order numbers of new fields are incorrect in Field ListMOD-1642 Incorrect Column Definitions When Exporting to Tableau from Classic Mode

datawatch monarch 13 release history · crash after pasting certain unicode characters into an...

Documents