Softpedia >Windows >Internet >Servers >Database Utils >DBF Commander Professional >  Changelog

DBF Commander Professional Changelog

What's new in DBF Commander Professional 5.0 Build 110

Oct 25, 2022
  • New Database Scheme feature implemented (thanks to Kevin Salisbury for the feature request)
  • Added possibility to select field(s) and copy its values for further paste into MS Excel sheet or somewhere else (thanks to Jonny McAreavey for the feature request)
  • Added possibility to import data from a text file of any type
  • Export to all file types now supports 'omit deleted' parameter in batch mode
  • Export DBF to XLS and XLSX in batch mode now supports custom sheet name (thanks to Max Gross for the feature request)
  • Replace is now works on Logical fields (thanks to Steve Henning for the bug report)
  • Fixed bug related to DBF field types on import from a database (thanks to Adil Demiri for the bug report)
  • Some commands became disabled after creating destination DBF on-the-fly during import from database. Fixed now
  • Fixed error appeared on structure changing and other operations on DBF file named with non-ANSI characters

New in DBF Commander Professional 4.4 Build 101 (Mar 18, 2019)

  • Multiple SQL tabs implemented
  • Hide Column feature added (thanks to Matthew Jones for the feature request)
  • Fixed bug related to memory leak during export to XLSX (thanks to Mike Todd for the bug report)
  • Added support for nested queries (or, subqueries) with short table names at the SQL Panel
  • Minor fixes in export and import processes

New in DBF Commander Professional 4.3 Build 91 (May 14, 2018)

  • Added support for EXECSCRIPT() and INDEX commands in user interface
  • Native export to XLSX file (no need MS Excel to be installed)
  • Incorrect Date, DateTime, and Numeric values are shown now without error message and highlighted with red (thanks to Gary Sanders and Chris Allen for the request)
  • Added support for -frfn, -srft, -ansi/-utf8, and -append parameters to export to CSV command (thanks to Alexander Datsomor for the feature request)
  • Date/time stamp added to each line logged within the log file when DBF commander is run with the -silent option (thanks to David Thomas for the feature request)
  • Some enhancements in import from DBMS functionality, as well in the interface

New in DBF Commander Professional 4.2 Build 82 (Nov 29, 2017)

  • French language added
  • Delete Duplicates feature implemented
  • Omit deleted records export DBF to a database option added
  • New 'Start New SQL' and 'Save SQL As' commands were added to the SQL Panel
  • Minor bug fixes

New in DBF Commander Professional 4.1 Build 80 (Apr 22, 2017)

  • Added support for EXECSCRIPT() command in batch mode
  • Support for SELECT statement added to Generate SQL Script feature. SQL text area is editable now
  • Chinese Simplified language added (thanks to Hsu Hongsheng for the translation)
  • New Import Custom XML option '-attr' added
  • Added NULL values support in Import Custom XML feature (thanks to Richard Hartnett for the bug request)

New in DBF Commander Professional 3.8 Build 65 (Jan 18, 2016)

  • New '-qf' batch command allows to run SQL text from a file
  • Added possibility to save or load SQL queries to SQL Panel from a text file
  • New batch command '-chart' allows to generate chart images via command line interface
  • Some import/export to CSV fixes regarding to quotes handling
  • You can now execute all queries from the SQL Panel without selecting them
  • Progress bar is now hidden in batch mode when the '-silent' mode is on

New in DBF Commander Professional 3.7 Build 63 (Aug 6, 2015)

  • 'Empty destination table' export to database option implemented (thanks to Matej Leban for the feature request)
  • Trial period extended to 30 days
  • Trial version nag-screen removed
  • Automatic Memo file conversion dialog has been added on DBF file opening to fix 'File must be opened exclusively to convert the Memo file' error (thanks to Lenard Hannam for the request)
  • 'Add field names' and 'Add field types' export to CSV options added
  • Minor interface changes and a rare bug fix in export to a database process
  • 'File does not exist' message on SQL query execution replaced with Open File dialog (thanks to Luk Kier for request)
  • Chinese Traditional language added

New in DBF Commander Professional 3.6 Build 60 (Oct 3, 2014)

  • Missing database *.DBC files handling fixed.
  • MS Excel export issues (incorrect cell format and black background) have been fixed.
  • Few of fixes in export to a MS SQL Server database have been made.

New in DBF Commander Professional 3.5 Build 57 (Sep 10, 2014)

  • New feature to create target tables on-the-fly while exporting a DBF file to a database implemented. DBMS supported: MS SQL Server, MySQL, Oracle, Postgre SQL, MS Access SQL, Visual FoxPro.
  • New feature to change table font has been implemented (thanks to Markus Hubert for request).
  • Portuguese language was added (thanks to Andre Marques dos Santos for translation).
  • Norwegian language was added (thanks to Son Tuan Huynh for translation).
  • "Open result file after import completion" option implemented.
  • Automatically check for updates feature implemented.

New in DBF Commander Professional 3.4 Build 55 (Sep 10, 2014)

  • Italian language added
  • Finnish language added
  • Moving by opened tables and SQL Panel with Ctrl+Tab shortcut implemented.

New in DBF Commander Professional 3.3 Build 54 (Mar 26, 2014)

  • Polish language added (thanks to Maciej Bojakowski for translation)
  • Fixed bug related to registered version work in batch mode
  • Handling of fields that named as reserved word has been improved (thanks to Jay Walker for the request)

New in DBF Commander Professional 3.2 Build 53 (Jan 21, 2014)

  • Licensing scheme changed back from 1 year to perpetual
  • Opened DBF file now placed on its own tab. Tab context menu commands available: Close Tab, Close All, Close All But This, etc
  • Appearance option 'File name at tab title contains path' added
  • Added Hungarian language (thanks to Torok Istvan for translation)
  • Fixed bug related to import from CSV which contains wrong field names in the 1st row (thanks to Jean Claude Cajot for testing)
  • Fixed 'Out of memory' error on import large CSV files (thanks to Ulukbek Yusupov for bug report)

New in DBF Commander Professional 3.1 Build 52 (Nov 6, 2013)

  • Replace and Replace All commands now replace the matching text only (not a whole cell text as it was earlier). Thanks to Jean Claude Cajot for the request
  • Fixed bug in command-line silent mode (thanks to Brendon O'Sullivan for the bug report and testing)
  • Added possibility to import XML files containing incorrect characters (particulary, '↕' symbols). Other special symbols can be added on demand
  • Date and DateTime field values now have explicit format on export to XML: "yyyy-MM-dd" and "yyyy-MM-dd'T'HH:mm:ss" correspondingly
  • XML files no longer require a comment field while import
  • Fixed bug related to search by Logical and General fields
  • Table hint is multiline now
  • Other insignificant interface improvements

New in DBF Commander Professional 3.0 Build 50 (Oct 3, 2013)

  • SQL queries execution was highly improved:
  • Multiline queries support
  • SQL execution messages and errors in a separate text box
  • Commentaries support in SQL text
  • SQL syntax highlight has been corrected
  • New tools and features:
  • Table grid data is in Unicode now
  • Added a facility to compare DBF files considering field types
  • Deleted rows count now displayed at the status bar
  • Multi-page print of DBF file implemented
  • Visual FoxPro syntax support was added to SQL Scripts Generation
  • Column moving support
  • DBF file opening and table drawing were slightly hastened
  • Cosmetic interface improvements
  • Import and Export enhancements:
  • Import Wizard implemented
  • Added export DBF to MS Excel 2007 and above
  • Export to CSV now supports UTF-8 encoding
  • Exported HTML and XML files' encoding is UTF-8 now
  • Fixed 'Out of memory' bug on export large DBF files to CSV
  • A few useful changes has been made in Export to Database facility:
  • Command line for the current data transfer from/to a database is now generated automatically in the window
  • Added an option to enclose field names in brackets, quotes, etc.
  • Missing field names are shown also (as well as common field names)
  • Editable tables list (e.g., for Postgre SQL schemas support)
  • Changes in Memo fields work up:
  • Memo fields support added to SQL Scripts Generation
  • Memo field value text box is scrollable now
  • Memo fields displaying hastened
  • New options:
  • Automatically open DBF files participated in SQL queries
  • Add structure changes as queries to SQL Panel
  • Ukrainian interface language added
  • Bug fixes:
  • Incorrect encoding on copy DBF table cell bug fixed
  • Cut/Copy/Paste routines in editor mode fixed
  • Case Sense bug in Find and Replace fixed
  • Autoinc field type is now restores after the file has been ordered
  • Minor bugs on DBF structure changing fixed

New in DBF Commander Professional 2.8 Build 41 (Jan 11, 2013)

  • Serbian language added
  • New option "Server-side cursor" added in "Import/Export to DBMS" feature
  • Fixed bug related to some of command-line routines

New in DBF Commander Professional 2.7 Build 40 (Oct 31, 2012)

  • New command added: Export DBF file structure to DBF file
  • New -silent mode has been added to command-line operations processing (thanks to Riccardo Bodini for request)
  • New command Import Custom XML added to command-line interface (thanks to Richard Hartnett for request)
  • Error processing in command-line mode has been improved
  • Wrong charset of error message in command-line fixed
  • Error "Multiple-step OLE DB operation" on export DBF has been fixed (thanks to Mary Jane Kelly for request)
  • Some other rare bugs fixed
  • Small cosmetic changes

New in DBF Commander Professional 2.5 Build 38 (Apr 17, 2012)

  • Incorrect date values are displayed now as is, without OLE DB provider error (thanks to Kris Senden for request)
  • Conversion of Memo-files (both FPT and DBT) was added (thanks to Mark Bustin for request)
  • "DBF Commander Home Page" and "Elphsoft Home Page" main menu items added
  • Error on change field order of a DBF file with Memo (FPT and DBT) has been fixed
  • Error on sort field of a DBF file with Memo (FPT and DBT) has been fixed
  • Fixed error on new dBase file creation
  • Conversion to dBase didn't work in some cases after searching

New in DBF Commander Professional 2.4 Build 37 (Mar 1, 2012)

  • Save As command was added (for example, in order to save a SQL query result set to a new DBF file)
  • Import from DBMS command was added to command-line interface
  • Export to DBMS command was added to command-line interface
  • Light-gray background for cells with NULL values
  • Minor bug on file open fixed
  • Insignificant cosmetic improvements

New in DBF Commander Professional 2.3 Build 36 (Sep 21, 2011)

  • Import from XML implemented
  • Import from CSV implemented
  • Indonesian UI language implemented (thanks to Rully Pratama for the translation)
  • Export to XLS has been completely reworked (with fixing the bug related to column type) and highly improved
  • In order to export to XLS now no need MS Excel to be installed on the workstation
  • Field definitions are now inserts on export to XML and CSV
  • Imports from XML and CSV are available via command line also
  • Other small changes and bug fixes in export
  • Added a possibility to change the grid's charset (without changing Windows locale settings)
  • Feature to convert DBF file type from "Visual FoxPro (autoinc)" to "dBase III Plus" has been added
  • A few insignificant bug fixes

New in DBF Commander Professional 2.2 Build 35 (Jun 15, 2011)

  • Registration dialog appears if trial period is expired
  • Other small improvements in registration process

New in DBF Commander Professional 2.2 Build 34 (Jun 15, 2011)

  • Some spelling mistakes has been fixed in German UI language
  • Table structure grid's titles are translatable now

New in DBF Commander Professional 2.2 Build 33 (May 31, 2011)

  • German UI language implemented
  • New SQL script option "Insert into defined fields" implemented
  • Run under virtualization software is now allowed (for registered copies only)
  • New command Maximize/Restore has been implemented (View -> Maximize/Restore, or Alt+Enter)
  • Small bug related to "INSERT INTO ..." SQL clause fixed
  • Insignificant cosmetic improvements

New in DBF Commander Professional 2.1 Build 31 (Mar 24, 2011)

  • "Open new files in existing instance" option implemented
  • "Could not save the log file" and "Failed to set data for ..." bugs fixed
  • The bug related to file access after searching is fixed
  • Minor bug related to column dropping while structure changing is fixed

New in DBF Commander Professional 2.0 Build 30 (Feb 28, 2011)

  • ANSI UTF-8 encoding conversion. Reworked completely and improved with some bugs fixing
  • Import/export data from/to DBMS (MS SQL, Postgre, Oracle, MySQL, Firebird, Interbase, and etc.)
  • Encrypt and decrypt DBF files (with AES-256 algorithm)
  • Convert DBF file to SQL script
  • Chart Wizard
  • Go to Field
  • Trim Spaces
  • Reopen File
  • Nullize Field and Set NULL commands
  • Compare Files
  • Check for Updates
  • BLOB fields support
  • Command line support
  • Now you can to specify the delimiter for export to *.CSV file
  • Possibility of export and print Advanced Statistics added
  • NULL values shown as NULL in the grid explicitly
  • Highly improved export DBF to XML
  • Create backup files (*.BAK) option added
  • Bug related to accidental table's title click during the program maximization fixed
  • Bug related to grid's popup and Recent Files menus drop down after structure changing fixed
  • Add the application to the Vista/Windows 7 Default Programs (thanks to Albert Akhmetov for help)
  • Moving by DBF file opened from a LAN resource becomes much faster
  • "=" filter conditions implemented. "!=" condition changed to ""
  • Small bugs fixes, code optimizations, and cosmetic improvements

New in DBF Commander Professional 1.1 Build 25 (Feb 28, 2011)

  • Conversion UTF-8 to ANSI possibility implemented.
  • The code has been cleaned (size of DBFCommander.exe becomes smaller).

New in DBF Commander Professional 1.1 Build 24 (Feb 28, 2011)

  • Minimized application window flashes when a SQL query executing has been finished.
  • Horizontal scroll bar removes when it's not needed.
  • Some enhancements included.
  • Some insignificant bugs fixed.

New in DBF Commander Professional 1.1 Build 23 (Feb 28, 2011)

  • The File Structure bug related to 'Duplicate field name' error fixed.
  • Windows 7 and Vista user interface themes support.
  • Bug related to invoke DBF Commander Help fixed.

New in DBF Commander Professional 1.1 Build 22 (Feb 28, 2011)

  • "CREATE TABLE ..." clause bug fixed. AV error appears when no files open.
  • Fixed critical bug related to deleting the DBF file while executing a SQL query.

New in DBF Commander Professional 1.1 Build 21 (Feb 28, 2011)

  • Sorting dialog box was reworked completely.
  • 'XX) is not a valid integer value' bug fixed. The error window appears on DBF file type change.
  • Temporary DBF files deletes after they are closed at once.
  • Recent Files submenu handling was reworked completely.
  • The Exception bug related to File Structure window fixed.
  • New command "Insert Current Filename" implemented.
  • Temporary DBF files and the log-file now stores at current user's Application Data directory.
  • Application help system implemented.
  • A lot of minor improvements and bug fixes