Octoparse 歷史版本列表 Page13

更新時間：2020-05-16
更新細節：

What's new in this version:

- Changed type of output report transmitted to DS4 in BT. Now use report type 0x15 (previously 0x11)
- Added extra data transmission flag to output report
- Changed thread affinity of hidDevice object. Link with initial high priority thread
- Use a Dispatcher instance for managing the OutputSlotManager rather than Tasks
- Changed how a running output slot queue is specified
- Initial mouse offset refactors. Base mouse offset on percentage of full speed. Defaults to 0.500
- Make button mouse offset a profile setting
- Set MinWidth and MinHeight values for the main window. Contribution by dondrakon
- Group some button mouse fields into a class. Reduces getter calls
- Show minimum effective mouse speed in GUI
- Put OS Info in log. Will be useful for debugging
- Removed chance for a dead lock when stopping input controllers. Luckily I have never encountered it
- Fixed a bug where a shiftKey macro accidentally saved HoldMacro and Macro status values
- Fixed debug x86 project target by enabling the Allow Unsafe Code project setting

更新時間：2020-05-14
更新細節：

更新時間：2020-05-13
更新細節：

What's new in this version:

- Fixes swapped colors with ProRes 4444 codec
- Fixes crash when selecting some input devices
- Fixes crash when using Blackmagic Desktop Software 11.5.1
- Fixes ungroup action not correctly merging cue groups
- Fixes slide labels not updating for all media actions
- Fixes grayscale PNG file import
- Fixes importing Pro6 presentation causing a crash on import
- Fixes go to next timer not activating for looping foreground
- Fixes go to next timers not always being cleared
- Fixes Blackmagic USB devices not appearing in video input list
- Fixes PowerPoint import not getting all slide images correct
- Fixes slideshow timer not working for Planning Center items
- Fixes edge blend settings not saving
- Fixes Bible not sending next slide to the stage screen
- Fixes playlist items getting removed when re-arranging libraries
- Fixes scripture references not showing on stage screen
- Improves support for multiple GPUs
- Other bug fixes and improvements

更新時間：2020-05-03
更新細節：

What's new in this version:

- Fixed possible sign flip issue with radial output curves
- Fixed NaN problem when radial cap is 0. Fixes output curve coordinate issues on the extreme low end
- Support for various non-standard DS4 gamepads which behave in BT just like USB connected DS4. Contribution made by mika-n
- Made a dedicated updater dialog window
- Added Changelog text to updater window
- Now actively using Newtonsoft Json.NET library
- Added Markdown.XAML library
- Fixed a few networking issues when pulling new version info
- Minor optimization of Controller Readings tab. Moved state copying outside of UI thread
- Updated UDP server to call the semaphore release on socket complete event
- Added German translation files. Changes made by Flo082002
- Added small log message stating whether running as Admin or User. Useful info when dealing with SendInput problems
- Fixed bug with 360 Steering Wheel output. Now two DS4 gamepads can be properly mapped to different VJoy output device axes

更新時間：2020-04-30
更新細節：

What's new in this version:

Improvements:
- DB Support: DB2 LUW
- DB Support: SQL Server Export DDL for SQL Server and DB2 Temporal Tables (GENERATED AS)
- Installation/Update Installation
- OS Support: Linux Make installation on Fedora linux more according to convention
- Highlight when installing DbVisualizer in an environment where no display is available
- Warn when running DbVisualizer in an environment where no display is available
- Make installation on Ubuntu Linux more according to convention
- OS Support: macOS Window title bars color should adapt with light or dark mode in macOS

Bugs Fixed:
- @import @import target fails on data type of not-imported column
- Create/Alter Table
- DB Support: MySQL ALTER TABLE shows SQLs in the preview even though no changes has been made
- Create/Alter Table
- DB Support: Oracle DDL generated by the Alter Table action includes the VISIBILITY clause even if not set/changed
- DB Support: Oracle Constraints with DEFERRABLE and DEFERRED properties are exported as regular Constraints for tables
- DB Support: Redshift There are no object views for Procedures and Procedure objects in the Databases tab for Redshift
- DB Support: SQL Server
- DDL Generator Generated DDL for index is incomplete if it contains the INCLUDE clause
- DDL Generator DDL not refreshed after Alter Table
- Data tab Max Rows on First Display = 0 is not honored
- Database Objects Tree Right-click in the Databases tab having "Autoscroll TO Object View tab" enabled, will not only show the popup menu but also open the object
- Row labels may be presented with different fonts in the Databases tab
- Sudden error in the Databases tab
- Database Profile: View Having viewer="text" for a DataView shows it as viewer="grid"
- Grid Component Clicking in the area outside the data in a grid should focus the grid
- Query Builder Query builder may generate wrong SQL
- References In References graph, "selected tables" only include outbound relations
- SQL Formatter SQL Formatter alters DbVis Variables ${...}$

更新時間：2020-04-16
更新細節：

What's new in this version:

- Improves the bullet/underline build interface and behaviors
- Improves copy/pasting of group slides within a presentation
- Improves media bin performance with a large number of media cues
- Updates NDI to version 4.5.1
- Adds support for ASIO audio output devices
- Disables identify screen/output when screen configuration is closed
- Fixes the last chapter of Bible translations not loading
- Fixes linked media fills not rendering
- Fixes presentation imports not preserving the selected arrangement
- Fixes calendar events not triggering playlist items
- Fixes slide labels not showing passage reference
- Fixes quick search not updating when presentation names are changed
- Fixes the look action when trigger from a slide not working properly
- Fixes arrangements not being used in playlists on ProRemote
- Fixes audio channel routing not mapping audio as expected for the output device

更新時間：2020-04-12
更新細節：

What's new in this version:

- Made stick output curves radial
- Doubled SocketAsyncEventArgs buffer length in UDP server (now 80)
- Added semaphore to UDP server class to control SocketAsyncEventArgs instances used
- Changed access flags used while enumerating controllers
- Increased HID disable time when attempting to get exclusive access (now 100 ms)
- Added updated DS4Updater downloading and version check
- Removed DS4Updater copy routine at start of DS4Windows. Changed responsibility to end of DS4Updater script
- Added rounding back to LS and RS Deadzone Profile Editor controls
- Now download latest updater version number from online repository
- Reduce confusion with minimize to taskbar/sys tray. Contributed by SteelShot
- Bundled DS4Updater version 1.4.2

更新時間：2020-04-10
更新細節：

What's new in this version:

New Features:
- @import Add a client-side command for import allowing to import table data in SQL scripts
- DB Support: MariaDB Add support for MariaDB
- DB Support: Snowflake Add extended support for Snowflake

Mail Support:
- SQL Commander Add @mail client side command used to email the result set from a query or file
- SQL Commander Add a "Morph to Delimited List" function in the SQL Commander
- Add new @open <file | URL> command used to open file in associated program or URL in web browser

Improvements:
- Cell Viewer/Editor Add options to format/unformat JSON in the cell editor
- Chart Resizing Charts on export distorts geometry
- Add more color schemes for charts
- Command Line Support (dbviscmd) dbviscmd should prompt for variables in connection details and variables used in scripts
- The dbviscmd script should use the same environment and JRE detection as the launcher for the GUI (dbvis)

Create/Alter Table:
- DB Support: MySQL Add support for check constraints in the Create/Alter table dialog for MySQL

Create/Alter Table:
- DB Support: Oracle Make it possible to change the visibility of a column through the Create and Alter table dialog
- DB Support: DB2 LUW Add user and role information for DB2 LUW
- DB Support: Exasol Always pass SQLs to the Exasol database with LF instead of CRLF line separators
- Enable the Procedure Editor for UDFs and Functions in Exasol

DB Support: MySQL:
- DDL Generator Improve support of the ON UPDATE clause for temporal types for MySQL

DB Support: MySQL:
- Procedure Editor Automatically set SQL Mode when editing Procedures and Functions

DB Support: PostgreSQL:
- Query Builder Add support for ~, !~, ~*, !~* operators in the Query Builder for PostgreSQL
- Data tab Add capability to set a key binding for the generic "Stop" action
- Option to prevent any filter from being used when loading a table during its first display
- Data tab should have a "Reload with Sorting as ORDER BY" action used to reload from database using a ORDER BY clause defined by the current sorting in the grid
- Database Objects Tree Show all contained database connections when selecting a database connections folder
- Need capability to make it easier to scope what database connections that should be updated in multi connections edits

Database Objects Tree:
- Database Profile: Commands For DB2 LUW and using the Generic profile, there is a (null) catalog node in the Databases tab
- Driver Manager Update bundled JDBC drivers
- Export For Excel exports, the "Include original SQL" setting in Export Grid and for @export ExcelIncludeSQLCommand parameter should allow: "sheet" parameter in addition to "none", "top", "bottom"
- The Open as Spreadsheet action should put the SQL in a separate sheet
- Rename "XLS" output format to "Excel" and accept "XLS" or "XLSX" (default) in the "ExcelFileFormat" parameter in @export
- Add "Auto Resize Columns" for Excel export
- Add new "Export Visible" and "Open Visible as Spreadsheet" actions for grids that considers any current filters, sorting, and visible columns in the grid
- Favorites Opening a favorite object for a database connection that fail to establish give no visible feedback that there is a problem
- Grid Component Add a new Copy Selection As->Copy Selection as AND/OR clause
- Key Bindings Possible to assign a modifier with TAB as key binding
- Should be possible to easily browse all available keyboard shortcuts
- Key bindings editor need a filtering/search capability to locate an existing key binding and filtering
- References Selected table nodes in the references graph should not change background color
- When Highlight Links is checked, do also color code the associated column names in the source and target nodes
- Table references to self (same table) should attach to the corresponding column names when using Hierarchic layout and not in random positions
- Certain controls in the References graph requires Hierarchic layout. Highlight this condition for controls when not using hierarchic layout mode
- SQL Commander Add new "Set Modified State when Scripting" setting in Tools->Tool Properties under General / SQL Commander
- Add "Change Default Values..." in the SQL Commander Options menu and SQL Commander toolbar drop-down
- Show the full path for the current database connection when hovering the Database Connection drop-down
- Have an option in SQL Commander to generate a dbviscmd command string that can be pasted in a terminal
- Refresh of the object tree (as a result of for example filtering) does not refresh the Catalog/Schema drop-down lists
- SQL Editor Offer GUI help for regular Expression replacement text (similar to the helper for the Find text)
- Show visible margin at user specified column
- Add support for adding linefeed, tab etc. in the replacement text in the Replace dialog
- SQL Formatter Allow setting indent for joins INNER, LEFT OUTER, RIGHT OUTER
- Allow for having multiple SQL Formatting profiles
- SQL Formatter should use the keyword lists defined for each supported database (use when for example upper/lower case keywords)
- Make it possible to add custom keywords that are upper/lowercased along with standard

Introduce a new SQL Formatter:
- Add multiple indentation levels and other improvements
- The Format SQL->Copy/Paste Formatted should allow setting that formatting should not be applied
- SQL Log Allow configuring what columns and order should be displayed in the SQL Log tab for SQL Commanders
- Table Data Editor Add a link to tool properties when the "Number of rows limited by <link>Max Rows at First Display</link> setting" balloon in the data tab is displayed
- Tool Properties Allow user to edit the sample text when choosing fonts

Bugs Fixed:
- Auto Completion Having Fully Qualify Objects for Auto Completion and then AC a table name, database.null.table is inserted
- Chart When exporting graph the width and height does not always honor the selected orientation
- Connection Setup Copying driver property name copies the wrong name if entries are filtered

DB Support: DB2 LUW:
- SQL Commander Stopped query leaves locks on SYSIBM tables
- DB Support: H2 DDL Tab for Table with Identity columns are not generated correctly when H2 1.4.199 is used
- DB Support: PostgreSQL For some PostgreSQL installations the pg_catalog.pg_database is empty resulting in no databases being displayed in the databases tab
- Space is inserted in middle of Operator when formatting
- Data tab Generate Filter for quoted string fails

Data tab:
- Grid Component NULL and duplicated values not handled properly in "Copy Selection as IN Clause" and "Generate Filter & Sort"
- Database Profile: Actions Main windows locks when shutting down action dialogs in the wrong order

Explain Plan:
- Performance/Stability Show confirm dialog when executing explain plan with multiple statements
- Export Exporting Binary/BLOB to File with JSON format outputs the binary data as is rather than the special ${data8-1||blob/8.png||BinaryData||noshow vl=file}$

Export:
- Import Malformed XML generated when export DbVis style XML
- OS Support: Linux Application icons on Linux are blurry when placed on desktop, and present in the application (task) switcher

Procedure Editor:
- SQL Editor The line break style (CRLF or LF) should be retained when editing an existing file or database code object
- Query Builder Conditions tab tree row heights are too small when loading a query in the query builder
- References Remove link "handles" in the references graph that are visible on self referencing tables
- SQL Commander Find and Replace with regular expression does not work
- Some ${dbvis-xxx}$ variables are not case sensitive
- SQL Editor Using Ctrl+A/Cmd+A keybinding to Select All will not enable some right-click actions unless opening the menu again
- SQL Formatter When applying the SQL formatter the schema name in some situations may be preceded by blanks
- UNLOGGED keyword with create table statement breaks formatting
- Script Table as INSERT adds the schema in uppercase when SQL formatted
- Having comments in a WITH clause breaks the SQL formatting
- Format with string literals longer than max Line Width results in invalid SQL
- Scripts If focus not in the Scripts tab, renaming a file using right-click immediately cancels the editing

更新時間：2020-04-06
更新細節：

What's new in this version:

- Made a wrapper script for launching process in Explorer. Needed for opening URLs with query strings in un-elevated mode
- Loosened enhanced precision curves
- Changed check for remapping execution. Take some Gyro mode settings into account
- Increased virtual device hotplug delay time to 500 ms (previously 200 ms)
- Changed to store force feedback delegate and unsubscribe before virtual controller is disconnected
- Force initial lightbar color change on profile load
- Added extra profile flag caching when loading a profile
- Temporarily establish main lightbar color after turning off lag flashing
- Changed how state data is read for Controller Readings tab in Profile Editor
- Added Newtonsoft.Json library to dependencies
- Fixed setting arguments string for Launch Program special action
- Added reference check while unplugging virtual device
- Added tooltip showing program path for Launch Program special action

更新時間：2020-03-26
更新細節：

What's new in this version:

- Added wait event to use for refreshing controller readings
- Added extra launch parameter for DS4Updater
- Disable Controller Readings tab when not associated with a controller and profile
- Make sure UDP server edit controls are enabled when UDP server is active
- More actively refresh cached profile properties
- Log exceptions from failed Tasks
- Added Unbound preset menu option for preset context menu in Profile Editor
- Increased stick mouse offset
- Changed volume scale used for both headphone and microphone
- Display input delay as a double in interface
- Added more proper logging of background thread exceptions
- Make profile list in Controller listing expand
- Changed Controller Readings section to display numeric data for input and mapped output values
- Changed some logging calls to use warning flag when exceptions are caught
- Temporary: Commented out lightbar color changing routine from virtual DS4. Reverted to use old force feedback routine. The previous change seemed to contribute to infinite rumble for some people but I can't verify anything on my end
- Bundled DS4Updater version 1.4.1