|
Versions History |
  
|
|
Versions History |
|
GOLD Version 1.5.0.5 released 5th November 2008
Enhancement : To support HyperFile, we had to create a new independent executable just for the Wizard and we added a new Setup - Settings parameter to let you define if you need working on those Files (to open either or Wizards).
Enhancement : In all Table reading we increased the number of columns from 999 to 9999 as it could result in column names being badly reported and GPF's during a cloning process.
GOLD Version 1.5.0.4 released 30th October 2008
New feature : Added support of Windev HyperFile as SOURCE format through ODBC (careful : BLOB columns cannot be updated in the Viewer as they are external files) - QBE Clone To .... are supported
New feature : Added in Mapping Options an IF THEN ELSE possibility
New feature : Added in Mapping Options an INLIST Condition Type to use with a LIST of up to 25 Values
Enhancement : To support HyperFile, we had to create a new independent executable just for the Wizard so as to access those Tables so now all this side is completely outside the tool and can be called as often as necessary without causing errors.
Enhancement : In the Viewer when a table is not fully compliant with DMC standards (Multi Columned PK or no PK) opened up all Viewer features but disconnected the Save to File only.
Enhancement : Many "logging lines" in code have been added to help you (and us) - in case of problems - to better trace all the tasks done by DMC.
Fixed Bug : In a TPS Table when the PREFIX was embedded in the structure the Key's were not properly assigned to Columns
Fixed Bug : Truncating a SQL Anywhere table was not working
GOLD Version 1.5.0.3 released 23rd October 2008
Enhancement : Added operation feature while mapping columns of LEFT - RIGHT and SUBSTRING
Fixed Bug : In Portable version creation and synching
GOLD Version 1.5.0.2 released 17th October 2008
New Feature : Support of SQL Anywhere cloning
New Feature : Real Edit In Place in the Viewer (with a calendar popup for all DATES)
New Feature : Viewer : format a LONG to a DATE or a TIME column and export the data as is directly
New Feature : Viewer : after doing a QBE on any Table you can now DELETE all the records of the resulting subset with a New DELETE button
New Feature : Viewer - Embedded BLOB Viewer with predefined types for Images - RTF - HTML - XML - PDF - VIDEO - SWF - DOC and XLS documents
New Feature : Complete LOG file creation by DMC (tasks and transfers)
New Feature : eMailing client to send us automatically the LOGS in case of a crash - this enables us to trace eventual errors in DMC or to show you why a process cannot be completed
New Feature : In the Mapping OPTIONS added the possibility to perform an OPERATION on two columns (+ - * /)
New Feature : In SQL Cloning we have added a BUTTON to rename the TABLE (instead of the old entry field)
New Feature : In SQL Cloning we have added a BUTTON to SEARCH & REPLACE text in the script (for example if you want to replace all 'ClientName' with 'Client_Name'
New Feature : When doing a Clone to xx the Destination Table is CLEANED from any illegal Names like ColName=N(12.2) and changed to ColName
Enhancement : Full support in PostGre SQL of Mixed cased Schemas and table names and Columns or keys
Enhancement : Full support by hand creation of SQL Structures for GUID type columns without having to use functions for displaying purposes
Enhancement : Full support of GUID columns in Random Data Generator
Enhancement : Added SQL DRIVER selection for MySQL (to let you use either 3.51 or the new 5.1 driver)
Enhancement : Added SQL KEY support in the cloning process (some Key's were not created properly in PostGre SQL mainly)
Enhancement : Added DECIMAL separator and number of decimals to be used in Settings
Enhancement : In the Mapping TAB a column "T" will show if Data is truncated while being transferred
Enhancement : In the Mapping TAB when columns are linked - the number of unlinked columns is displayed in the Status Bar rightmost part
Enhancement : When doing a Clone to TPS the Destination Table is NOT directly created : you are taken to the Creation Wizard Screen to let you check and modify the Structure
Fixed Bug : Several small bugs in the application (mainly in ASCII transfers and in DATE TIME support)
(there is no version 1.5.0.1)
GOLD Version 1.5.0.0 released 8th August 2008
New Feature : UPDATE any SQL Table with the proper mapping option
New Feature : Full support of SQL BLOB columns - these can be transferred even if the size is over 65k
Enhancement : In ODBC creation and edition of a form, we added a list of Drivers installed on your machine for you to choose from to help Oracle - PostGreSQL and SQL Anywhere users
Enhancement : Added full support of UNIQUEIDENTIFIER (GUID) columns in Pervasive and Ms SQL (and in generating random Data when the Table contains such columns)
Enhancement : Added full support of Clone to Pervasive Tables
Enhancement : Added full support of Clone to Access Tables
Enhancement : All windows are now compliant with LCD screens and also any language (Chinese etc ...)
Enhancement : Added in SQL environment two buttons : EMPTY & DROP (the selected table)
Enhancement : This version also brings the first of coming features : SQL Table synchronization and backups using profiles and the command line (more to come)
Enhancement : The ODBC connection string Display Name is now an open field for you to change if need be
Fixed Bug : When transferring Data and when you had selected to only read the First 50 records - you could not transfer records
Fixed Bug : When only one ODBC connection string was built you could no 'see' it in destination
Fixed Bug : Generating random data from SQL environment would hang
Fixed Bug : In SQL environment several DB - Table selections one after the other could crash the tool
From the GOLD version (1.5.0.0) onwards the licensing changes and all Enterprise and Viewer licenses are changed to MULTI-COPIES one - (multi End-User licenses are created for those needing to distribute DMC to their clients)
Version 1.4.0.2 released 3rd July 2008
New Feature : UPDATE any non SQL Table with the proper mapping option
New Feature : Command line (Runtime version of DMC) arguments are accepted to run single or Batch processes
Enhancement : Profiles are now 'linked' to Projects which allows you to group them by your preferred themes
Enhancement : When restoring a profile the process windows are replaced by a Queue treatment (speed)
Fixed Bug : When transferring Data and when you had selected to only read the First 50 records - you could not transfer more then 50 records
Version 1.4.0.1 released 23rd June 2008
New Feature : SQL Environment - work on any Data Base : - Query Builder Single or Multi Table - Export to TPS or SQL subsets - Viewer direct access - Generate Random Data etc ...
New Feature : Clone to DAT - DBF (DBase - Clipper and FoxPro)
New Feature : User option to display or not a Sum Up display screen of the Main Wizard (with canceling possibility)
New Feature : Direct access in Viewer to the last 25 Most Recently Used Tables (all formats)
Enhancement : All Data Management screens redesigned to accommodate more space (better visibility)
Enhancement : Data Management Task WIZARD - define step by step your task (change source and / or destination settings without loosing pace)
Enhancement : Create ODBC WIZARD
Enhancement : User option to read only first 50 records before reaching the Mapping tab
Enhancement : Define the Color of all List Box records
Enhancement : List of all SQL Key's in Structure Tab - Structures stored in Clipboard
Enhancement : In Mapping tab : List by ... processes changed to working on Queue's (speed)
Enhancement : Processing of Columns to define if DATETIME's are present also changed to working on a Queue (speed)
Fixed Bug : Clone to SQL - constraints where not always properly created
Fixed Bug : Removed the empty column in column list when creating a Key in 'Create with Wizard'
Version 1.3.0.1 released 26 May 2008
New version of DMC : Portable
Portable Version : Any multi copy licensed user can create one or several (depending on his license) copies of DMC on USB - Memory Cards etc.....
Please visit this page of the site to purchase any additional licenses
As this entirely NEW version of DMC is NOT a special installer but is created from within DMC itself and as it is impossible to create for single licenses, we are offering all registered users the possibility to purchase at special prices additional licenses
Common Enhancement : The ODBC Connection string window has been entirely redrawn and when CREATING a new one, wizard type messages are now displayed in sequence to help you in this process
(in the next version a similar type of wizard will be used for the Data Management and for the Creation Wizard windows)
Common Enhancement : When in the Viewer and you want to Export to CSV or XML a message of confirmation is opened for you.
Fixed Bug : When reading a TPS table with arrays (dimensioned columns) and when a column was OVER another one, you received an error message - corrected.
Version 1.2.0.3 released 19 May 2008
Viewer New Feature : Refresh TPS Multi Table Table List (if you added a table trough another application while the Viewer is opened)
Viewer New Feature : Use a new button to BUILD all KEY's of the viewed table (TPS & DAT)
New Common Feature : Store your encrypted TPS Passwords automatically by using a new checkbox in the PWD Message (it will be used automatically at next table opening)
Enterprise Enhancement : During all processes now no more dynamic Table creation in TPS format - this accelerates the result display
Version 1.2.0.2 released 14 May 2008
New version of DMC : Viewer
Viewer New Feature : A new technique is used to load the Data : the main screen opens up in around 2 seconds with the first 500 records displayed
Viewer New Feature : When reading a TPS Multi Table a List of tables is displayed to switch directly between them
Viewer New Feature : When reading a DAT - TPS or Ms SQL or MySQL table you can add and delete records
Viewer New Feature : Locator Search (full text) on the selected column or all columns
Viewer New Feature : Mass Updating of the table via a powerful Expression & Condition Builder (store queries for future use)
Viewer New Feature : QBE on the table via a powerful Query Builder (store for future use)
Viewer New Feature : Export what you have on screen after a QBE or a mass Update (WITHOUT having to save to File) to various predefined Formats plus XML and CSV directly from DMC Viewer
Viewer New Feature : After a QBE or a Mass Update before saving to File, you can reset all data to its original state with a button
New Feature : Full support of TPS Multi Tables
New Feature : When reading a TPS Multi Table a List of tables is displayed both for Source or Destination to let you chose from them the table to read
New Feature : When saving a Profile and Multi Tables are used, all will be stored and when you restore it, all will be done automatically for you (Table Name, Password etc...)
New Feature : Full support of array fields even while generating data and cloning to SQL (Column[4] will generate Column (in case of a Key) + Column_2 + Column_3 + Column_4)
New Feature : Change the SQL table Name when Cloning to SQL in the script editor window
New Feature : You can now use ODBC with Trusted Connection against an Ms SQL server (empty login and empty pwd)
Enhancement : A new technique is used for translating the IDE - switch language's on the fly
Enhancement : The installer now offers to link or not DBF - DAT and/or TPS Tables with DMC
Enhancement : In the messages displayed you can now use the "Enter" and "Escape" keys to accept or refuse it
Fixed Bug : When all the columns were not mapped for a transfer, some of them could be not transferred at all
Version 1.2.0.1 released 1st. April 2008
New Feature : You can use a simple Double-Click on any DAT - DBF or TPS file to view it in DMC (column sorting - key sorting etc...)
New Feature : Export from any structure to ASCII (CSV & TXT) format
New Feature : Generate Data for test tables from DMC for any structure
New Feature : Use Multiple Record Level conditional mappings combined with the Column Level ones
Enhancement : New conditional options in mappings : Replace - Starts with - Ends with - Empty & Not Empty
Enhancement : All the ASCII reading has been rewritten to speed up the process
Enhancement : The process used in DMC is now displayed in the main frame toolbar
Enhancement : XML export now opens immediately a Tab in DMC with your File displayed (no longer necessary to wait for IE to open the file)
Enhancement : The Data Tab showing your Source and Destination data now can be sorted with column headers
Enhancement : The Viewer mode in DMC is now full screen
Version 1.1.0.7 released 6th. March 2008
This version has been certified by Microsoft as "Works with Vista" and as "Works with Windows Server 2008"
New Feature : You can now use DMC to UPDATE (by record number only) any NON ODBC Table and not only to INSERT records.
New Feature : When a Clone to TPS process is done, a structure file will be created for you to be able to switch to Creation Wizard mode and modify your TPS table
New Feature : When in an ODBC record a list of all available DSN's is displayed and a Double-Click will fill in automatically the record for you
New Feature : Activation codes can be requested directly on Internet
Enhancement : The test ODBC button now returns a "Success" message along with the type of server you are connected to (and does no longer send an error when no Table is in the DB)
Enhancement : The main frame is resizable to any dimension and all windows fit in a resolution of 800x600
Enhancement : All buttons have been resized and some Icons removed to allow for a better UI integrity in some small screen resolutions
Enhancement : The Creation Wizard now let's you create multiple columned keys
Enhancement : The installer and updater now is fully Vista compatible and you will be able to install the program under Program Files and the data under Program Data (or change the directories of course)
Enhancement : The full installer can be used as an updater .... although we do not recommend it
Enhancement & Fixed Bug : The "Link by Name" process was creating wrong mappings - corrected and DATETIME icons added
Fixed Bug : The Clone to TPS was not creating properly certain keys
Version 1.1.0.6 released 14 February 2008
Bug Fix : when a BLOB is found in source Table it is stored in full BINARY to a temp TPS table and is transferred from there to your destination table
Bug Fix : when an XLS sheet is source then if a REAL is found an NO decimals it is converted (clone to TPS) in a LONG
Bug Fix : when an XLS sheet is source then the Clone to TPS or SQL table name is now without the trailing $ sign
Version 1.1.0.5 released 21 January 2008
| 1. | New Feature : DMC allows you to Visualize ANY Table and to limit the number of records to be displayed. |
| 2. | New Feature : DMC displays for you all the transferred data directly in a List Box for you to Visualize. |
| 3. | New Feature : DMC supports SQL Anywhere both as source and destination and for cloning purposes. |
| 4. | New Feature : "Horizontalize" your data : Transfer x RECORD values in x COLUMNS in ONE RECORD. |
| 5. | Added : While doing a "Link by Name" mapping DMC will automatically map DATE & TIME columns of a DATETIME GROUP. |
| 6. | Fixed Bug : SQL & XLS reading of tables did not return proper information's. |
Version 1.1.0.4 (bug fix) released 15 Jan 2008
| 1. | Fixed bug : when in "Creation Wizard" a KEY was defined as NODUPE then it would be created as DUP |
Version 1.1.0.3 released 14 Jan 2008
| 1. | New Feature : Clone to SQL - select ANY source table (DAT-DBF-TPS-CSV) and create an exact cloned SQL Structure |
| 2. | New Feature : Create from TXT File - use a TXT File containing a VALID TPS structure to create the table |
| 3. | New Feature : Creation Wizard to create a new TPS or SQL Table - Use a Wizard to manually define a new TPS or SQL Table |
| 4. | New Feature : support of FireBird InterBase SQL |
| 5. | Added : Expiry date of your maintenance Plan in the "About Screen" |
| 6. | Added : Right click support in ODBC connection module |
| 7. | Modified : "Link By Name" mapping now takes care of DATE fields in SQL destinations |
| 8. | Modified : TOPSPEED password is only asked if the table requires one |
| 9. | Fixed bug : when SQL DATETIME was NULL |
| 10. | Fixed bug : when Oracle or Pervasive where used in ODBC connection string (driver not saved properly) |
| 11. | Fixed bug : in ODBC when a table Name had a space in it |
| 12. | Fixed bug : UNIQUE KEY's were badly showing in mapping Tab |
| 13. | Fixed bug : in record level conditional rules |
| 14. | Fixed bug : when reading some DBF Tables with MEMO columns |
| 15. | Fixed bug : when Oracle or PostGre SQL where destination, some columns were not well read |
| 16. | Fixed bug : when an error occurred while reading a table, DMC would GPF without any error message. |
IMPORTANT NOTICE : when using the MySQL ODBC driver version 3.51.03 it is impossible to link to Tables - please update your driver to at least version 3.51.12
when reading an EXCEL worksheet, the first row MUST contains VALID NAMES and all columns must be VALID (no currency signs etc...)
Version 1.1.0.2 released 8 Dec 2007
1. Added feature of Cancel Processing on all data transfers
2. Changed Main Frame to resizable and made inner screens compatible with 1024x768 resolution
3. Transfer to XLS bug fix
Version 1.1.0.1 released 4 Dec 2007
1. Added support of XML files as DESTINATION and as Source Raw Data as is export also
2. Added feature to Clone to TPS from any source Table - All the data contained in the source Table can be transferred after mappings are done
3. Added feature of editing the Structure of both Source and Destination Tables : You can even use this txt file to add it in your dictionary if need be (with a small modification)
4. Added an extra Tab (Assign Q) which opens up after Transfer is done showing all columns used and the respective values found for the last scanned record
5. Added DBF overred Field support : if a field placed over another one is larger then the 'root' field size is dynamically changed
6. Added for Basic - CSV files a parser to replace any illegal character in column names
7. Added for Basic - CSV files a process to adapt automatically to the biggest length of field found in the file (a one pass process)
8. Added feature that both Source and Destination tables are automatically cloned to TPS - this let's you access an empty TPS table as a copy of your tables
9. GROUPS with DATE & TIME fields are better visibly shown when found (icons) and all unusable (depending on driver) columns are placed at the bottom of the mapping list
10. GROUPS with DATE & TIME fields are now automatically prohibited from being used in ODBC driver destination mappings
11. When a KEY has ascending or descending defined an different icon will reflect it for better understanding
12. When during any non ODBC Transfer of Data, errors occur, they will be logged to a txt file which will popup automatically at the end of the process
13. If Opening or Reading a Source or Destination File is impossible an error message will popup and the process will be stopped
14. Added feature for empty passwords in ODBC connections
15. Corrected bug when not using a Port in ODBC connections
Version 1.0.0.9 released 14 Nov 2007
1. Added support of DBF files as SOURCE and DESTINATION (read the docs for detailed explanation regarding directories)
2. Added feature to SendTo XLS-CSV-PDF-HTML-DOC and email or FTP or print those generated files when in the DATA tab (source data only) or the Mapping tab
3. Added a fully automatic DAT 2 TPS cloning possibility : now you can select a DAT File and have the tool clone it for you to a non existent TPS Table with all keys
4. Added an extra process to find in Source and Destination mappings if any STRING(8) 's are there with a DATETIME GROUP over it (mapping prohibited of course on those)
5. Small bug fixes ...
Version 1.0.0.8 released 7 Nov 2007
1. Added support of SQL Pervasive SQL files as SOURCE and DESTINATION
2. Bug fix in ODBC Connection record when Access or Excel where used
3. Bug fix in ODBC Connection when using the Test Button : now you can use this feature as many times as you wish
4. New Installer Vista UAC compliant : under VISTA with UAC turned ON you HAVE to use this tool as ADMINISTRATOR (for ODBC connection reasons) and you HAVE to install under root directory (till we find a solution to a FM3 problem)
5. Bug fix when dropping the activation file under Vista (executable path problem)
Version 1.0.0.7 released 3 Nov 2007
1. Added support of SQL PostGreSQL files as SOURCE and DESTINATION
2. Bug fix in Exports when aggregate was used
3. Changed the numbering of columns when a DATETIME was found
Version 1.0.0.6 released 2 Nov 2007
1. Added support of SQL Oracle files as SOURCE and DESTINATION
2. Bug fix in Exports ODBC / TPS / XLS (when ODBC and DATETIME as source then some fields were not transferred)
3. Opened up the mappings (drag & drop) : now you can map all fields together - "you" have to be careful
Version 1.0.0.5 released 30 Oct 2007
1. Added support of SQL DB2 files as SOURCE and DESTINATION
2. Bug fix in ODBC SQL (Keys not being properly retrieved)
Version 1.0.0.4 released 28 Oct 2007
1. Bug Fix in ODBC destination
Version 1.0.0.3 released 25 Oct 2007
1. Added support of Clarion DAT files as SOURCE and DESTINATION
2. Added Registration at the same time of the Licence and the Maintenance Plan
3. Added Portuguese language in the IDE
Version 1.0.0.2 released 20 Oct 2007
1. Added Spanish language
2. Added Skype support
3. Fixed bug in SV List boxes headers not being translated
4. Fixed bug in some Buttons and Action Message not being Translated
Version 1.0.0.1 released 17 Oct 2007
FIRST DMC Version released